Jeremy:

Your answers are always very helpful. I had almost given up using mysql
backend on a master server. Now I am going to try again. I will keep posted.

Thanks again.

Kirti

-----Original Message-----
From: Jeremy Kitchen [mailto:[EMAIL PROTECTED]
Sent: Sunday, June 06, 2004 11:36 PM
To: [EMAIL PROTECTED]
Subject: Re: [vchkpw] Vpopmail & MySQL


On Sunday 06 June 2004 08:37 pm, Kirti S. Bajwa wrote:
> Hello:
>
> I had posted a similar question couple of days ago. I have done quite a
bit
> research & actual installation and would like to post the following
> question for somebody's help and/or recommendation:
>
> I have setup a MAIL server with RH9, qmail, mysql, vpopmail, etc. I have
> tested vpopmail by adding a domain & it works. I also have setup a DATA
> server with RH9 & Master MySQL. My goal is to keep all MySQL data on the
> DATA server. MAIL server & RADIUS servers go to the DATA server for MySQL
> records. Latency is not a problem because all these servers are connected
> on a private (192.168.237.X) network.

right, a relatively common configuration.  I've done multiple
mysql-replicated 
setups (this isn't replication, but vpopmail is configured very similarly.

> After I tested the MAIL server, I tried for it to create a domain on DATA
> server vpopmail database. On the MAIL server I changed the
> "/home/vpopmail/etc/vpopmail.mysql" from:
>
> localhost|0|vpopmailuser|vpoppasswd|vpopmail  -to-
> 192.167.237.16|0|vpopmailuser|vpoppasswd|vpopmail

ok.  make sure your mysql server is listening on TCP port 3306 (which is the

default) and that you can connect to it from the 'MAIL' server.  Telnet 
should suffice.  Once you've determined you can connect to it, make sure you

are able to perform operations on the database using the 'mysql' command
line 
interface (from the MAIL server).

> where 192.167.237.16 is the IP address of the DATA server. I also have
> tried various other techniques but nothing seem to work. When I try adding
> a domain, I get error message:

various other techniques of doing what?  I don't see how this is difficult,
to 
be honest.

> vmysql: sql error[c]: MYSQL server has gone away
> (and slew of other similar error messages)

and those other error messages are?

Usually 'mysql server has gone away' means that the password didn't work.

> Therefore, my question is:
>
> (1) Has anybody tried setting up vpopmail with MySQL backend data being on
> server (but on the same LAN/network)?

yes.

> (2) Is it even possible?

yes.

> (3) If not possible, how can I move the user data to the backend MySQL
DATA
> server so other servers (such as RADIUS for authentication) can use it?

well, if it wasn't possible (which it is) you're asking how to do the 
impossible....  I don't see how you could expect a solution to an impossible

question :)


> I have spent about two weeks on this project. Your help is highly
> appreciated.

setting up vpopmail with mysql backend shouldn't take more than about 3 
minutes.

-Jeremy

-- 
Jeremy Kitchen ++ Systems Administrator ++ Inter7 Internet Technologies,
Inc.
  [EMAIL PROTECTED] ++ www.inter7.com ++ 866.528.3530 ++ 847.492.0470 int'l
        kitchen @ #qmail #gentoo on EFnet ++ scriptkitchen.com/qmail

Reply via email to