Current time: 04-18-2024, 07:06 PM Hello There, Guest! (LoginRegister)


Poll: What do you think of this How-to?
Great!
Good
Average
So So
Bad Idea/Completely Wrong
[Show Results]
 
Post Reply 
How to use Google Apps as your email solution on your system
Author Message
wb6vpm Offline
Junior Member
*

Posts: 80
Joined: Oct 2007
Reputation: 0
Post: #1
How to use Google Apps as your email solution on your system
How to make your system use Google Apps (herein known as Google)

Before we delve into this, there are a few caveats (disclaimers) that we do have to consider:

1. This how-to is ONLY if you want to host ALL of your domains on Google
2. This does not have you use an API of Google to do it automatically, you will have to do the email setup on Google manually.
3. You will need to use the html verification method for Google. (Or you can manually edit the .db files at the end for each domain if you wish to put the CNAME in)
4. This worked for me, I cannot guarantee that it will work for you, and I assume no liability for you using it.
5. I cannot stress this enough, BACKUP, BACKUP BACKUP! So, incase something goes wrong, you can always roll back to the old settings!

Now that the disclaimers are out of the way Tongue, first things first, lets change the configuration template files

Edit /etc/ispcp/bind/parts/db_e.tpl it should look something like below when you are done (may vary slightly):

Quote:$TTL 86400
@ IN SOA ns.{DMN_NAME}. root.{DMN_NAME}. (
; dmn [{DMN_NAME}] timestamp entry BEGIN.
{TIMESTAMP}
; dmn [{DMN_NAME}] timestamp entry END.
8H
2H
4W
1D
)
IN NS ns1.{DMN_NAME}.
IN NS ns2.{DMN_NAME}.
IN MX 1 ASPMX.L.GOOGLE.COM.
IN MX 5 ALT1.ASPMX.L.GOOGLE.COM.
IN MX 5 ALT2.ASPMX.L.GOOGLE.COM.
IN MX 10 ASPMX2.GOOGLEMAIL.COM.
IN MX 10 ASPMX3.GOOGLEMAIL.COM.


{DMN_NAME}. IN A {DMN_IP}
{DMN_NAME}. IN TXT "v=spf1 mx ip4:{DMN_IP} include:aspmx.googlemail.com ~all"
ns1 IN A {BASE_SERVER_IP}
ns2 IN A {SECONDARY_DNS_IP}
localhost IN A 127.0.0.1
www CNAME {DMN_NAME}.
ftp CNAME {DMN_NAME}.
calendar IN CNAME ghs.google.com.
start IN CNAME ghs.google.com.
mail IN CNAME ghs.google.com.
docs IN CNAME ghs.google.com.
sites IN CNAME ghs.google.com.


; sub [{SUB_NAME}] entry BEGIN.
; sub [{SUB_NAME}] entry END.

Next, we will edit /etc/postfix/main.cf by changing virtual_mailbox_{domains|maps} as shown below:
Code:
...
virtual_mailbox_domains      = hash:/etc/postfix/ispcp/domains-empty
virtual_mailbox_maps         = hash:/etc/postfix/ispcp/mailboxes-empty
...

then execute:

Code:
touch /etc/postfix/ispcp/{domains,mailboxes}-empty
postmap /etc/postfix/ispcp/{domains,mailboxes}-empty
/etc/init.d/postfix force-reload

(Please verify command settings, as they can change OS to OS)

Keep in mind, if main.cf is ever regenerated, (i.e. upgrade ispCP) you will have to redo the above (re-edit, and run the commands)

Next, we will be doing a bit of sql to have the system regenerate our files.

http://isp-control.net/documentation/how...ate_config Wrote:====== Howto regenerate the config files ======
Modifying the template files in parts/ is not enough to apply the modification to existing domains. The config files of the affected services have to be regenerated. The following steps will guide you through the process

===== 1. Stop ispCP daemon =====

# /etc/init.d/ispcp_daemon stop

===== 2. Log into MySQL =====

mysql -u root -p

It will prompt for the password.

===== 3. Set to regenerate =====
In the mysql promtp enter:

USE ispcp;

-To regenerate all the domains configs:-

UPDATE `domain` SET `domain_status` = 'change' WHERE `domain_status` = 'ok';

-To regenerate all the subdomains configs:-

UPDATE `subdomain` SET `subdomain_status` = 'change' WHERE `subdomain_status` = 'ok';

-To regenerate all the aliases configs:-

UPDATE `domain_aliasses` SET `alias_status` = 'change' WHERE `alias_status` = 'ok';

-To regenerate all the emails configs:-

UPDATE `mail_users` SET `status` = 'change' WHERE `status` = 'ok';

===== 4. Quit mysql =====

quit

===== 5. Process the request =====

# /var/www/ispcp/engine/ispcp-rqst-mngr

===== 6. Start ispCP Daemon =====

# /etc/init.d/ispcp_daemon start

If you have any comments/suggestions/issues, please do not hesitate to put them here.
(This post was last modified: 07-17-2008 08:22 AM by wb6vpm.)
07-02-2008 05:36 AM
Visit this user's website Find all posts by this user Quote this message in a reply
RatS Offline
Project Leader
******

Posts: 1,854
Joined: Oct 2006
Reputation: 17
Post: #2
RE: How to use Google Apps as your email solution on your system
Why do you use google? You don't care of your privacy? Are voyeurs allowed if you have sex? Think twice why you have your own server and don't use google and why this is good as it is ...
07-02-2008 08:32 AM
Visit this user's website Find all posts by this user Quote this message in a reply
MicCo Offline
Moderator
*****
Moderators

Posts: 277
Joined: Oct 2006
Reputation: 1
Post: #3
RE: How to use Google Apps as your email solution on your system
O'boy Smile
07-14-2008 08:00 PM
Visit this user's website Find all posts by this user Quote this message in a reply
BioALIEN Offline
Public Relations Officer
*****
Dev Team

Posts: 620
Joined: Feb 2007
Reputation: 5
Post: #4
RE: How to use Google Apps as your email solution on your system
Some small businesses demand a higher level of service and flexibility. For this, Google/Live/Yahoo hosted services are the perfect addition to their existing IT needs.

You are experts in this space, but think of it from the average consumer. It also appeals to startups and people with a limited budget too.

+1 from me on this write up. SAAS is the way to go these days.
07-17-2008 08:06 AM
Find all posts by this user Quote this message in a reply
wb6vpm Offline
Junior Member
*

Posts: 80
Joined: Oct 2007
Reputation: 0
Post: #5
RE: How to use Google Apps as your email solution on your system
BioALIEN Wrote:Some small businesses demand a higher level of service and flexibility. For this, Google/Live/Yahoo hosted services are the perfect addition to their existing IT needs.

You are experts in this space, but think of it from the average consumer. It also appeals to startups and people with a limited budget too.

+1 from me on this write up. SAAS is the way to go these days.

Thank you! that is pretty much the way I am looking at it.
07-17-2008 08:19 AM
Visit this user's website Find all posts by this user Quote this message in a reply
wb6vpm Offline
Junior Member
*

Posts: 80
Joined: Oct 2007
Reputation: 0
Post: #6
RE: How to use Google Apps as your email solution on your system
I will be updating this shortly, as I have discovered a few minor issues that I am currently working on to resolve.
07-17-2008 08:23 AM
Visit this user's website Find all posts by this user Quote this message in a reply
four2theizz0 Offline
Junior Member
*

Posts: 59
Joined: Sep 2008
Reputation: 0
Post: #7
RE: How to use Google Apps as your email solution on your system
This is great, i do understand the need to use a reliable service like gmail
and even if you guys dont like it, is there another answer?
i am just starting up my hosting company and have worked in an email call center and DONOT want to deal with the hassles of running your own email and having paying customers and then having something screw up

i would love to run my own email and will if i have to but it is a nightmare when somethign goes wrong ans someone is paying you for it.

so thank you for the write up and please let us know of any updates you have Smile
10-08-2008 11:50 PM
Find all posts by this user Quote this message in a reply
DecIRC Offline
Banned

Posts: 15
Joined: May 2008
Post: #8
RE: How to use Google Apps as your email solution on your system
What kind of issues did you encountered ?
And isn't there some mail services we can stop to get some benefits at resource level ?
And an easy way to remove the mail part in the menu... If I put to 0 I have a problem with the automatic created mailboxes (three)

cEd
(This post was last modified: 10-17-2008 04:47 AM by DecIRC.)
10-17-2008 04:46 AM
Find all posts by this user Quote this message in a reply
four2theizz0 Offline
Junior Member
*

Posts: 59
Joined: Sep 2008
Reputation: 0
Post: #9
RE: How to use Google Apps as your email solution on your system
Oh, I didn't mean anything specific...I just mean if you are running your own mail and ANYTHING goes wrong, people get mad. Rightfully so. At least if I am not running it and there is a problem I can blame them hehe. Still looks bad on me, but waaaayyyyy less stress.

I didn't encounter the problems myself, I just worked for a big email provider and have been on the frontlines(phone support) when there are email problems.

I am not arguing any of the privacy issues or any other reasons to dislike gmail, just partial to google for the reliability and its free. will take anything else tho Big Grin
10-17-2008 08:40 AM
Find all posts by this user Quote this message in a reply
Illidan Offline
Junior Member
*

Posts: 93
Joined: May 2007
Reputation: 2
Post: #10
RE: How to use Google Apps as your email solution on your system
At the moment I created my first e-mail in Google Apps for your Domain, as admin@vecho.de.

I edited the MX Records at my domain hoster and today I edit it then in the bind files. Can I create then in ispCP all email adresses? Also, admin@vecho.de or info@vecho.de or webmaster@subdomain.vecho.de ?
04-14-2009 09:12 PM
Visit this user's website Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)