Re: [vchkpw] vpopmail+mysql
Hrmm didn't get D.Hilbig's reply..so mines included in this... my problem is solved once after installation of devel package. during next upgradation i'll switch to centos. you'll still have the same problem, last time I loaded up a CentOS image. This is why I am only useing slackware now, that includes the gradual phase out of BSD and slowaris for it, rock hard stable and reliable, the programs contained within are not messed with like RH/ Debian etc do (hence way less problems = way less updates) and greater than 5 years support of updates, I've used Slackware since v2 and I've used RH since early days as well, but its so B.S now I wouldnt use even fedora on a desktop again, that's Ubuntu's job now :) . Hrmm come to think of it I think we have so e AIX boxes that need replacing soon too ;) D. Hilbig wrote: alternative. I use CentOS (http://www.centos.org) which is effectively a RHEL production release. But its still released by the same butchers that hack out code to suite their internal politics. Early RH releases were OK, that's before they started to get too big and political, but not as reliable as much as Slackware or BSD is (for reasons stated above), but in fairness I have not had access to RHEL5 to try, but you know what they say, same dog different s... anyways way OT now so I'll end my participation in this thread :) all the best. !DSPAM:480edb36120501257442357!
Re: [vchkpw] vpopmail+mysql
Why you want to use fedora on a production server I'll never know, but as usual with everything butchered to buggery by RH, you dont have the headers files, so you need to install the -devel packages of mysql (and anything you want to build against), if your not commited try a decent server OS like Slackware or one of the BSD's On 22/04/08 16:22:08, Dhaval Thakar wrote: Dear All, i am trying to compile vpopmail (5.4.24) with mysql I used ./configure --enable-logging=p --enable-auth-module=mysql -- disable-passwd --enable-clear-passwd --disable-many-domains -- enable-auth-logging --enable-sql-logging --enable-valias --disable- mysql-limits --enable-incdir=/usr/lib/mysql --enable-onchange- script --enable-libdir=/var/lib/mysql --enable-libdir=/usr/lib/ mysql vpopmail 5.4.24 Current settings --- vpopmail directory = /home/vpopmail domains directory = /home/vpopmail/domains uid = 508 gid = 503 roaming users = OFF --disable-roaming-users (default) password learning = OFF --disable-learn-passwords (default) md5 passwords = ON --enable-md5-passwords (default) file locking = ON --enable-file-locking (default) vdelivermail fsync = OFF --disable-file-sync (default) make seekable = ON --enable-make-seekable (default) clear passwd = ON --enable-clear-passwd (default) user dir hashing = ON --enable-users-big-dir (default) address extensions = OFF --disable-qmail-ext (default) ip alias = OFF --disable-ip-alias-domains (default) onchange script = ON --enable-onchange-script auth module = mysql --enable-auth-module=mysql mysql replication = OFF --disable-mysql-replication (default) sql logging = ON --enable-sql-logging mysql limits = OFF --disable-mysql-limits (default) SQL valias table = ON --enable-valias auth inc = -I/usr/lib/mysql auth lib = -L/usr/lib/mysql -lmysqlclient -lz -lm system passwords = OFF --disable-passwd (default) pop syslog = show failed attempts with clear text password -- enable-logging=p auth logging = ON --enable-auth-logging (default) one domain per SQL table = --disable-many-domains spamassassin = OFF --disable-spamassassin (default) maildrop = OFF --disable-maildrop (default) during make, i am getting following error vauth.c:33:19: error: mysql.h: No such file or directory vauth.c:40: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘mysql_update’ vauth.c:41: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘mysql_read_getall’ vauth.c:59: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token vauth.c:60: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘*’ token vauth.c:68: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘row’ vauth.c:69: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘row_getall’ vauth.c: In function ‘vauth_open_update’: vauth.c:206: warning: implicit declaration of function ‘mysql_ping’ vauth.c:206: error: ‘mysql_update’ undeclared (first use in this function) vauth.c:206: error: (Each undeclared identifier is reported only once vauth.c:206: error: for each function it appears in.) vauth.c:212: warning: implicit declaration of function ‘mysql_init’ vauth.c:213: warning: implicit declaration of function ‘mysql_options’ vauth.c:213: error: ‘MYSQL_OPT_CONNECT_TIMEOUT’ undeclared (first use in this function) vauth.c:216: warning: implicit declaration of function ‘mysql_real_connect’ vauth.c:226: warning: implicit declaration of function ‘mysql_select_db’ vauth.c:230: warning: implicit declaration of function ‘mysql_query’ vauth.c:236: warning: implicit declaration of function ‘mysql_error’ vauth.c:236: warning: format ‘%s’ expects type ‘char *’, but argument 4 has type ‘int’ vauth.c: In function ‘vauth_open_read_getall’: vauth.c:316: error: ‘mysql_read_getall’ undeclared (first use in this function) vauth.c: In function ‘vauth_create_table’: vauth.c:343: error: ‘mysql_update’ undeclared (first use in this function) vauth.c:346: warning: format ‘%s’ expects type ‘char *’, but argument 4 has type ‘int’ vauth.c: In function ‘vauth_adduser’: vauth.c:428: error: ‘mysql_update’ undeclared (first use in this function) vauth.c:429: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’ vauth.c: In function ‘vauth_getpw’: vauth.c:480: error: ‘mysql_update’ undeclared (first use in this function) vauth.c:481: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’ vauth.c:504: warning: format ‘%s’ expects type ‘char *’, but argument 3 has type ‘int’ vauth.c:509: error: ‘res_update’ undeclared (first use in this function) vauth.c:509: warning: implicit declaration of function ‘mysql_store_result’ vauth.c:514: warning: implicit declaration of function ‘mysql_num_rows’ vauth.c:515: warning: implicit declaration of function ‘mysql_free_result’ vauth.c:533: error: ‘row’ undeclared (first use in this function) vauth.c:533: warning: implicit
Re: [vchkpw] vpopmail+mysql (KMM3511892I87L0KM)
Dear Customer, Thank you for contacting Wachovia. This message is in response to your recent communication, which was received on 04/22/2008 and assigned Case ID 27119495. I regret the message we received was unclear. Please send us another secure e-mail with additional information regarding your inquiry. We will be happy to assist you in addressing your concerns when we receive further details. You may also call us at the number listed below for assistance. I sincerely apologize for any inconvenience. If you have additional questions or concerns, please contact us via e-mail or call 800-950-2296. Representatives are available to assist you 24 hours a day, seven days a week. I value your business as a Wachovia customer and look forward to continuing to serve your financial needs. Visit us again at wachovia.com. Note: Wachovia requires the use of secure browsers to protect you while you access our on-line financial services over the Internet. However, information sent by electronic mail cannot utilize the same standards of securing your personal information that secure browsers afford. Therefore, do not send confidential information such as account numbers or social security numbers through e-mail. Sincerely, LaToya B Original Message Excluded: - |1364Wach1364| !DSPAM:480e01be120501367316094!
RE: [vchkpw] vpopmail+mysql
Dhaval, For now, you shouldn't specify the --enable-auth-logging option because it's got bugs up through v5.4.26. Like Quey said, you'll need the mysql-devel package. And as for Fedora on a production server, you might want to consider an alternative. I use CentOS (http://www.centos.org) which is effectively a RHEL production release. -Original Message- From: Quey [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 22, 2008 12:44 AM To: vchkpw@inter7.com Subject: Re: [vchkpw] vpopmail+mysql Why you want to use fedora on a production server I'll never know, but as usual with everything butchered to buggery by RH, you dont have the headers files, so you need to install the -devel packages of mysql (and anything you want to build against), if your not commited try a decent server OS like Slackware or one of the BSD's On 22/04/08 16:22:08, Dhaval Thakar wrote: Dear All, i am trying to compile vpopmail (5.4.24) with mysql I used ./configure --enable-logging=p --enable-auth-module=mysql -- disable-passwd --enable-clear-passwd --disable-many-domains -- enable-auth-logging --enable-sql-logging --enable-valias --disable- mysql-limits --enable-incdir=/usr/lib/mysql --enable-onchange- script --enable-libdir=/var/lib/mysql --enable-libdir=/usr/lib/ mysql vpopmail 5.4.24 Current settings --- vpopmail directory = /home/vpopmail domains directory = /home/vpopmail/domains uid = 508 gid = 503 roaming users = OFF --disable-roaming-users (default) password learning = OFF --disable-learn-passwords (default) md5 passwords = ON --enable-md5-passwords (default) file locking = ON --enable-file-locking (default) vdelivermail fsync = OFF --disable-file-sync (default) make seekable = ON --enable-make-seekable (default) clear passwd = ON --enable-clear-passwd (default) user dir hashing = ON --enable-users-big-dir (default) address extensions = OFF --disable-qmail-ext (default) ip alias = OFF --disable-ip-alias-domains (default) onchange script = ON --enable-onchange-script auth module = mysql --enable-auth-module=mysql mysql replication = OFF --disable-mysql-replication (default) sql logging = ON --enable-sql-logging mysql limits = OFF --disable-mysql-limits (default) SQL valias table = ON --enable-valias auth inc = -I/usr/lib/mysql auth lib = -L/usr/lib/mysql -lmysqlclient -lz -lm system passwords = OFF --disable-passwd (default) pop syslog = show failed attempts with clear text password -- enable-logging=p auth logging = ON --enable-auth-logging (default) one domain per SQL table = --disable-many-domains spamassassin = OFF --disable-spamassassin (default) maildrop = OFF --disable-maildrop (default) during make, i am getting following error vauth.c:33:19: error: mysql.h: No such file or directory vauth.c:40: error: expected '=', ',', ';', 'asm' or '__attribute__' before 'mysql_update' vauth.c:41: error: expected '=', ',', ';', 'asm' or '__attribute__' before 'mysql_read_getall' vauth.c:59: error: expected '=', ',', ';', 'asm' or '__attribute__' before '*' token vauth.c:60: error: expected '=', ',', ';', 'asm' or '__attribute__' before '*' token vauth.c:68: error: expected '=', ',', ';', 'asm' or '__attribute__' before 'row' vauth.c:69: error: expected '=', ',', ';', 'asm' or '__attribute__' before 'row_getall' vauth.c: In function 'vauth_open_update': vauth.c:206: warning: implicit declaration of function 'mysql_ping' vauth.c:206: error: 'mysql_update' undeclared (first use in this function) vauth.c:206: error: (Each undeclared identifier is reported only once vauth.c:206: error: for each function it appears in.) vauth.c:212: warning: implicit declaration of function 'mysql_init' vauth.c:213: warning: implicit declaration of function 'mysql_options' vauth.c:213: error: 'MYSQL_OPT_CONNECT_TIMEOUT' undeclared (first use in this function) vauth.c:216: warning: implicit declaration of function 'mysql_real_connect' vauth.c:226: warning: implicit declaration of function 'mysql_select_db' vauth.c:230: warning: implicit declaration of function 'mysql_query' vauth.c:236: warning: implicit declaration of function 'mysql_error' vauth.c:236: warning: format '%s' expects type 'char *', but argument 4 has type 'int' vauth.c: In function 'vauth_open_read_getall': vauth.c:316: error: 'mysql_read_getall' undeclared (first use in this function) vauth.c: In function 'vauth_create_table': vauth.c:343: error: 'mysql_update' undeclared (first use in this function) vauth.c:346: warning: format '%s' expects type 'char *', but argument 4 has type 'int' vauth.c: In function 'vauth_adduser': vauth.c:428: error: 'mysql_update' undeclared (first use in this function) vauth.c:429: warning: format '%s' expects type 'char *', but argument 3 has type 'int' vauth.c: In function 'vauth_getpw': vauth.c:480: error: 'mysql_update' undeclared (first use
Re: [vchkpw] vpopmail+mysql
dear list, thanks for the guidance, my problem is solved once after installation of devel package. during next upgradation i'll switch to centos. thanks regards dhaval D. Hilbig wrote: Dhaval, For now, you shouldn't specify the --enable-auth-logging option because it's got bugs up through v5.4.26. Like Quey said, you'll need the mysql-devel package. And as for Fedora on a production server, you might want to consider an alternative. I use CentOS (http://www.centos.org) which is effectively a RHEL production release. -Original Message- From: Quey [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 22, 2008 12:44 AM To: vchkpw@inter7.com Subject: Re: [vchkpw] vpopmail+mysql Why you want to use fedora on a production server I'll never know, but as usual with everything butchered to buggery by RH, you dont have the headers files, so you need to install the -devel packages of mysql (and anything you want to build against), if your not commited try a decent server OS like Slackware or one of the BSD's On 22/04/08 16:22:08, Dhaval Thakar wrote: Dear All, i am trying to compile vpopmail (5.4.24) with mysql I used ./configure --enable-logging=p --enable-auth-module=mysql -- disable-passwd --enable-clear-passwd --disable-many-domains -- enable-auth-logging --enable-sql-logging --enable-valias --disable- mysql-limits --enable-incdir=/usr/lib/mysql --enable-onchange- script --enable-libdir=/var/lib/mysql --enable-libdir=/usr/lib/ mysql vpopmail 5.4.24 Current settings --- vpopmail directory = /home/vpopmail domains directory = /home/vpopmail/domains uid = 508 gid = 503 roaming users = OFF --disable-roaming-users (default) password learning = OFF --disable-learn-passwords (default) md5 passwords = ON --enable-md5-passwords (default) file locking = ON --enable-file-locking (default) vdelivermail fsync = OFF --disable-file-sync (default) make seekable = ON --enable-make-seekable (default) clear passwd = ON --enable-clear-passwd (default) user dir hashing = ON --enable-users-big-dir (default) address extensions = OFF --disable-qmail-ext (default) ip alias = OFF --disable-ip-alias-domains (default) onchange script = ON --enable-onchange-script auth module = mysql --enable-auth-module=mysql mysql replication = OFF --disable-mysql-replication (default) sql logging = ON --enable-sql-logging mysql limits = OFF --disable-mysql-limits (default) SQL valias table = ON --enable-valias auth inc = -I/usr/lib/mysql auth lib = -L/usr/lib/mysql -lmysqlclient -lz -lm system passwords = OFF --disable-passwd (default) pop syslog = show failed attempts with clear text password -- enable-logging=p auth logging = ON --enable-auth-logging (default) one domain per SQL table = --disable-many-domains spamassassin = OFF --disable-spamassassin (default) maildrop = OFF --disable-maildrop (default) during make, i am getting following error vauth.c:33:19: error: mysql.h: No such file or directory vauth.c:40: error: expected '=', ',', ';', 'asm' or '__attribute__' before 'mysql_update' vauth.c:41: error: expected '=', ',', ';', 'asm' or '__attribute__' before 'mysql_read_getall' vauth.c:59: error: expected '=', ',', ';', 'asm' or '__attribute__' before '*' token vauth.c:60: error: expected '=', ',', ';', 'asm' or '__attribute__' before '*' token vauth.c:68: error: expected '=', ',', ';', 'asm' or '__attribute__' before 'row' vauth.c:69: error: expected '=', ',', ';', 'asm' or '__attribute__' before 'row_getall' vauth.c: In function 'vauth_open_update': vauth.c:206: warning: implicit declaration of function 'mysql_ping' vauth.c:206: error: 'mysql_update' undeclared (first use in this function) vauth.c:206: error: (Each undeclared identifier is reported only once vauth.c:206: error: for each function it appears in.) vauth.c:212: warning: implicit declaration of function 'mysql_init' vauth.c:213: warning: implicit declaration of function 'mysql_options' vauth.c:213: error: 'MYSQL_OPT_CONNECT_TIMEOUT' undeclared (first use in this function) vauth.c:216: warning: implicit declaration of function 'mysql_real_connect' vauth.c:226: warning: implicit declaration of function 'mysql_select_db' vauth.c:230: warning: implicit declaration of function 'mysql_query' vauth.c:236: warning: implicit declaration of function 'mysql_error' vauth.c:236: warning: format '%s' expects type 'char *', but argument 4 has type 'int' vauth.c: In function 'vauth_open_read_getall': vauth.c:316: error: 'mysql_read_getall' undeclared (first use in this function) vauth.c: In function 'vauth_create_table': vauth.c:343: error: 'mysql_update' undeclared (first use in this function) vauth.c:346: warning: format '%s' expects type 'char *', but argument 4 has type 'int' vauth.c: In function 'vauth_adduser': vauth.c:428: error: 'mysql_update' undeclared (first use in this function) vauth.c:429: warning: format '%s' expects type 'char *', but argument 3 has
Re: [vchkpw] Vpopmail mysql and aborted clients
the warnings are daily... on sarge unless on etch yesterday in a testing machine I had a hang of courier and had to restart it by hand, but today have started mysqld_safe with --wait_timeout=345600 and haven't seen today any warning and courier has logged properly... I'm gonna check the two solutions... the wait_timeout increasing and the vmysql.patch... (that I think it come from vpopmail 5.4.17 to more newer...) thanks a lot mates :) have a nice day [EMAIL PROTECTED] wrote: Yes it really goes ok... and now for example the server has a uptime of more or less 110 days... I have never had to restart courier-imap package (wich I use for pop and imap services) and seems to be running ok... so this is normal then? and I shouldn't change nothing then? or is it advisable to increase mysql timeout?? or I could stay as I'm now? I would suggest setting the mysql timeout to about twice the longest interval between pop/imap logins. 4 or 5 days is probably good. One day wouldn't be bad if you don't mind seeing a few warnings on weekends. I don't use mysql though. Rick
Re: [vchkpw] Vpopmail mysql and aborted clients
[EMAIL PROTECTED] wrote: Yes it really goes ok... and now for example the server has a uptime of more or less 110 days... I have never had to restart courier-imap package (wich I use for pop and imap services) and seems to be running ok... so this is normal then? and I shouldn't change nothing then? or is it advisable to increase mysql timeout?? or I could stay as I'm now? I would suggest setting the mysql timeout to about twice the longest interval between pop/imap logins. 4 or 5 days is probably good. One day wouldn't be bad if you don't mind seeing a few warnings on weekends. I don't use mysql though. Rick
Re: [vchkpw] Vpopmail mysql and aborted clients
So then no matter for worrying about this? This can't break the database or... don't know cause any type of problem... or should I do any conf in authdaemon for this to be avoided? or is this normal and nothing happens with it? Thanks a lot!!! As told in other messages, the way of playing is different. Each vpopmail/qmail program usually executes brieftly and opens and closes MySQL, so there are no abnormal exits. When courier plays (both imap and pop), it asks auth data to courier's auth daemon. When this daemon is started, it opens MySQL and never closes it, as it supposes to reuse continuosly the same opened connection. But if none is going to use the connection for eigth hours, MySQL itself closes the connection. This will be opened again automatically by vpopmail library in courier's daemon, but you see an error in MySQL stats. Hope I've been clear. Tonino At 12.54 05/10/2007, [EMAIL PROTECTED] wrote: sorry for insisting but this happens when courier enters, it's the same for pop, or imap or... in the moment courier enters in the play for imap only imagine because you use qmail-pop there in the way I told yesterday... after some time of inactivity happens this... sorry for insisting At 04.55 05/10/2007, you wrote: tonix (Antonio Nati) wrote: MysSQL has now an hardcoded timeout of eight hours. Courier uses it's authentication daemon with persistent attach to vpopmail/MySQL, it could be that during the night there are no requests, so MySQL connections are droppped (by MySQL). I thought this was addressed in a recent version of vpopmail? Yes, but you see in the logs that some connections have been dropped. Tonino Yep but wait a minute! if you have a machine in wich you only run qmail for mail scanning or smtp relay, or even with qmail-pop3d you don't get those aborted clients... but if you run there pop and imap with couier, so the problem occurs when you use courier... if you don't use it... you don't see any error... and both use vpopmail equally aren't they (courier and qmail) ? if you have for example qmail-smtpd with smtp auth only and of course vpopmail you will never have that errors... and you go to ask to courier and they say is a vpopmail question... but vpopmail works fine with qmail-smtpd!!! this was an important detail I forgot to tell yesterday... could this give you any more clue???
Re: [vchkpw] Vpopmail mysql and aborted clients
If your courier still works without you need to restart it, it means you already have vpopmail in the right configuration, and you are only facing a log warning (which reason is now known). Ciao, Tonino At 11.00 06/10/2007, you wrote: So then no matter for worrying about this? This can't break the database or... don't know cause any type of problem... or should I do any conf in authdaemon for this to be avoided? or is this normal and nothing happens with it? Thanks a lot!!! As told in other messages, the way of playing is different. Each vpopmail/qmail program usually executes brieftly and opens and closes MySQL, so there are no abnormal exits. When courier plays (both imap and pop), it asks auth data to courier's auth daemon. When this daemon is started, it opens MySQL and never closes it, as it supposes to reuse continuosly the same opened connection. But if none is going to use the connection for eigth hours, MySQL itself closes the connection. This will be opened again automatically by vpopmail library in courier's daemon, but you see an error in MySQL stats. Hope I've been clear. Tonino At 12.54 05/10/2007, [EMAIL PROTECTED] wrote: sorry for insisting but this happens when courier enters, it's the same for pop, or imap or... in the moment courier enters in the play for imap only imagine because you use qmail-pop there in the way I told yesterday... after some time of inactivity happens this... sorry for insisting At 04.55 05/10/2007, you wrote: tonix (Antonio Nati) wrote: MysSQL has now an hardcoded timeout of eight hours. Courier uses it's authentication daemon with persistent attach to vpopmail/MySQL, it could be that during the night there are no requests, so MySQL connections are droppped (by MySQL). I thought this was addressed in a recent version of vpopmail? Yes, but you see in the logs that some connections have been dropped. Tonino Yep but wait a minute! if you have a machine in wich you only run qmail for mail scanning or smtp relay, or even with qmail-pop3d you don't get those aborted clients... but if you run there pop and imap with couier, so the problem occurs when you use courier... if you don't use it... you don't see any error... and both use vpopmail equally aren't they (courier and qmail) ? if you have for example qmail-smtpd with smtp auth only and of course vpopmail you will never have that errors... and you go to ask to courier and they say is a vpopmail question... but vpopmail works fine with qmail-smtpd!!! this was an important detail I forgot to tell yesterday... could this give you any more clue???
Re: [vchkpw] Vpopmail mysql and aborted clients
Christopher Chan wrote: [EMAIL PROTECTED] wrote: So then no matter for worrying about this? This can't break the database or... don't know cause any type of problem... or should I do any conf in authdaemon for this to be avoided? or is this normal and nothing happens with it? Either restarted authdaemon if this happens or upgrade vpopmail. This should not break the database. It just affects your imap connections. Or change your my.cnf for mysql to allow unlimited timeout's. That's what I did (Well I actually set it to 4 days). Rick
Re: [vchkpw] Vpopmail mysql and aborted clients
sorry for insisting but this happens when courier enters, it's the same for pop, or imap or... in the moment courier enters in the play for imap only imagine because you use qmail-pop there in the way I told yesterday... after some time of inactivity happens this... sorry for insisting At 04.55 05/10/2007, you wrote: tonix (Antonio Nati) wrote: MysSQL has now an hardcoded timeout of eight hours. Courier uses it's authentication daemon with persistent attach to vpopmail/MySQL, it could be that during the night there are no requests, so MySQL connections are droppped (by MySQL). I thought this was addressed in a recent version of vpopmail? Yes, but you see in the logs that some connections have been dropped. Tonino Yep but wait a minute! if you have a machine in wich you only run qmail for mail scanning or smtp relay, or even with qmail-pop3d you don't get those aborted clients... but if you run there pop and imap with couier, so the problem occurs when you use courier... if you don't use it... you don't see any error... and both use vpopmail equally aren't they (courier and qmail) ? if you have for example qmail-smtpd with smtp auth only and of course vpopmail you will never have that errors... and you go to ask to courier and they say is a vpopmail question... but vpopmail works fine with qmail-smtpd!!! this was an important detail I forgot to tell yesterday... could this give you any more clue???
Re: [vchkpw] Vpopmail mysql and aborted clients
At 04.55 05/10/2007, you wrote: tonix (Antonio Nati) wrote: MysSQL has now an hardcoded timeout of eight hours. Courier uses it's authentication daemon with persistent attach to vpopmail/MySQL, it could be that during the night there are no requests, so MySQL connections are droppped (by MySQL). I thought this was addressed in a recent version of vpopmail? Yes, but you see in the logs that some connections have been dropped. Tonino Yep but wait a minute! if you have a machine in wich you only run qmail for mail scanning or smtp relay, or even with qmail-pop3d you don't get those aborted clients... but if you run there pop and imap with couier, so the problem occurs when you use courier... if you don't use it... you don't see any error... and both use vpopmail equally aren't they (courier and qmail) ? if you have for example qmail-smtpd with smtp auth only and of course vpopmail you will never have that errors... and you go to ask to courier and they say is a vpopmail question... but vpopmail works fine with qmail-smtpd!!! this was an important detail I forgot to tell yesterday... could this give you any more clue???
Re: [vchkpw] Vpopmail mysql and aborted clients
thanks a lot mates for you're answers, and in where logs could you see connections have been droped?? you doing an overview for all answers some mysql versions have timeout for it's persistent connections (connections as vpopmail connections) and this causes connection not to close properly and the aborted client... so then is a mysql issue?? could this cause problems? At 04.55 05/10/2007, you wrote: tonix (Antonio Nati) wrote: MysSQL has now an hardcoded timeout of eight hours. Courier uses it's authentication daemon with persistent attach to vpopmail/MySQL, it could be that during the night there are no requests, so MySQL connections are droppped (by MySQL). I thought this was addressed in a recent version of vpopmail? Yes, but you see in the logs that some connections have been dropped. Tonino
Re: [vchkpw] Vpopmail mysql and aborted clients
At 04.55 05/10/2007, you wrote: tonix (Antonio Nati) wrote: MysSQL has now an hardcoded timeout of eight hours. Courier uses it's authentication daemon with persistent attach to vpopmail/MySQL, it could be that during the night there are no requests, so MySQL connections are droppped (by MySQL). I thought this was addressed in a recent version of vpopmail? Yes, but you see in the logs that some connections have been dropped. Tonino
Re: [vchkpw] Vpopmail mysql and aborted clients
[EMAIL PROTECTED] wrote: sorry for insisting but this happens when courier enters, it's the same for pop, or imap or... in the moment courier enters in the play for imap only imagine because you use qmail-pop there in the way I told yesterday... after some time of inactivity happens this... sorry for insisting The problem does not really lie with courier. All qmail processes run under tcpserver and are only invoked when a connection appears. courier has this authdaemon that maintains persistent connections to mysql via the vpopmail library and so its behaviour is different from being run under tcpserver in qmail-smtpd or qmail-pop3d. This is why it appears that courier is the problem but it actually is not. It is just that courier has a different way of being run and this was not taken into account by vpopmail because none of the relevant qmail processes run persistently.
Re: [vchkpw] Vpopmail mysql and aborted clients
As told in other messages, the way of playing is different. Each vpopmail/qmail program usually executes brieftly and opens and closes MySQL, so there are no abnormal exits. When courier plays (both imap and pop), it asks auth data to courier's auth daemon. When this daemon is started, it opens MySQL and never closes it, as it supposes to reuse continuosly the same opened connection. But if none is going to use the connection for eigth hours, MySQL itself closes the connection. This will be opened again automatically by vpopmail library in courier's daemon, but you see an error in MySQL stats. Hope I've been clear. Tonino At 12.54 05/10/2007, [EMAIL PROTECTED] wrote: sorry for insisting but this happens when courier enters, it's the same for pop, or imap or... in the moment courier enters in the play for imap only imagine because you use qmail-pop there in the way I told yesterday... after some time of inactivity happens this... sorry for insisting At 04.55 05/10/2007, you wrote: tonix (Antonio Nati) wrote: MysSQL has now an hardcoded timeout of eight hours. Courier uses it's authentication daemon with persistent attach to vpopmail/MySQL, it could be that during the night there are no requests, so MySQL connections are droppped (by MySQL). I thought this was addressed in a recent version of vpopmail? Yes, but you see in the logs that some connections have been dropped. Tonino Yep but wait a minute! if you have a machine in wich you only run qmail for mail scanning or smtp relay, or even with qmail-pop3d you don't get those aborted clients... but if you run there pop and imap with couier, so the problem occurs when you use courier... if you don't use it... you don't see any error... and both use vpopmail equally aren't they (courier and qmail) ? if you have for example qmail-smtpd with smtp auth only and of course vpopmail you will never have that errors... and you go to ask to courier and they say is a vpopmail question... but vpopmail works fine with qmail-smtpd!!! this was an important detail I forgot to tell yesterday... could this give you any more clue???
Re: [vchkpw] Vpopmail mysql and aborted clients
MysSQL has now an hardcoded timeout of eight hours. Courier uses it's authentication daemon with persistent attach to vpopmail/MySQL, it could be that during the night there are no requests, so MySQL connections are droppped (by MySQL). Ciao, Tonino At 09.36 04/10/2007, you wrote: Hi, I'm running vpopmail-5.4.13 with courier-imap-4.0.2 and courier-authlib-0.55... have noticed that each morning for example after all the night without poping or imaping... the next time someone pop or imap in the morning I get no errors on mail client and everything works fine... but have noticed that 10 aborted cliets appear... in show status in mysql... it is as this near 1 year now (since I set up that server) and everything works fine and there's any error and everything fine... but only those aborted clients each morning... why is this happening? I have asked sometime in courier mailing lists but they say me to ask at vpopmail mailing lists... and I know qmail and vpopmail both don't cause this aborteds because I have another machine in the same way configured (of course as the machine in wich this is seeing) but without courier because it's only for mail scanning and have any aborted client... each machine has it's own mysql server... and I'm totally sure this aborted happen when courier talks to vpopmail the first time after a inactivity period... is this normal¿? why happens this?? Have a nice day! P.D. John (John Simpson) perhaps this could be a challenge for you :)
Re: [vchkpw] Vpopmail mysql and aborted clients
On 2007-10-04, at 0336, [EMAIL PROTECTED] wrote: ... have noticed that each morning for example after all the night without poping or imaping... the next time someone pop or imap in the morning I get no errors on mail client and everything works fine... but have noticed that 10 aborted cliets appear... in show status in mysql... P.D. John (John Simpson) perhaps this could be a challenge for you :) i don't know a whole lot about how vpopmail uses mysql, the only thing i use mysql for is the back-end storage for my jabber server, and a few clients who need it for their web sites. my only guess would be the eight-hour timeout that tonix already mentioned. | John M. Simpson--- KG4ZOW ---Programmer At Large | | http://www.jms1.net/ [EMAIL PROTECTED] | | http://video.google.com/videoplay?docid=-1656880303867390173 | PGP.sig Description: This is a digitally signed message part
Re: [vchkpw] Vpopmail mysql and aborted clients
tonix (Antonio Nati) wrote: MysSQL has now an hardcoded timeout of eight hours. Courier uses it's authentication daemon with persistent attach to vpopmail/MySQL, it could be that during the night there are no requests, so MySQL connections are droppped (by MySQL). I thought this was addressed in a recent version of vpopmail?
Re: [vchkpw] Vpopmail mysql and aborted clients
On 2007-10-04, at 2255, Christopher Chan wrote: tonix (Antonio Nati) wrote: MysSQL has now an hardcoded timeout of eight hours. Courier uses it's authentication daemon with persistent attach to vpopmail/MySQL, it could be that during the night there are no requests, so MySQL connections are droppped (by MySQL). I thought this was addressed in a recent version of vpopmail? when vpopmail tries to do something on the sql server and gets a connection was closed error, it now opens a new connection and tries the operation again. it sounded like he was talking about seeing the stale client threads/ processes within the sql server itself, which for whatever reason hadn't been harvested by the sql server's reaper. if so, that question has more to do with the sql server's internals than it does with vpopmail. | John M. Simpson--- KG4ZOW ---Programmer At Large | | http://www.jms1.net/ [EMAIL PROTECTED] | | http://video.google.com/videoplay?docid=-1656880303867390173 | PGP.sig Description: This is a digitally signed message part
Re: [vchkpw] Vpopmail + MySQL, Advise needed.
Sergio Rosa wrote: Hi all, I had vpopmail running with cdb, upgraded to vpopmail with MySQL but did a bad choice! I configure it without (the default) support for many domains. How can I convert my configuration, from one table per domain to a new configuration of one column by domain? I need to change things on my server because I now have a lot more domains that I had a few weeks before. BTW I'm running vpopmail 5.4.10 with the followinf config: ./configure \ --enable-clear-passwd \ --enable-learn-passwords \ --enable-domainquotas \ --disable-password \ --enable-logging=y \ --enable-valias \ --enable-mysql-limits \ --disable-many-domains \ --enable-auth-module=mysql \ --enable-sql-logging on a Fedora Core 1 and a rpm build of MySQL 4.0.20, plus a lot of other things like clamd, spamassassin, apache, and so on... I only have this server and a down time is not welcome by the Clients. Recently my sql server Gone away! for a while and it cause a big trouble on mail delivery. Hi, Sorry, I can't you with the conversion of the database but your Gone Away! problem can be helped by increasing the number of connections that MySQL allows and increasing the memory available to MySQL by modifying your my.cnf file. The large_my.cnf file that came with Fedora is a good place to start looking. You may also not want to use mysql-logging as you do have to clean that out sometime or you'll just fill up your logging table with millions of records. Regards, Rick
Re: [vchkpw] vpopmail-mysql problem
Andrea Benedetto wrote: We have a big mail server which authenticate users against mysql (mysql server 4.1.10 and mysql client 4.1.10). Some times we can see in /var/log/qmail/smtpd/current this line: 2005-04-04 11:43:50.962470500 vmysql: sql error[3]: MySQL server has gone away and after this qmail-server says that the mail box doesn't exists. We have read that it could be a timeout error, because vpopmail keep alive conections with mysql server but mysql doesn't (wait_timeout = 28800). But probably this isn't the case, because in the log file we can see that the error above doesn't occur every 8 hours but it appears at every time. Here an example: 2005-04-04 01:30:47.096746500 vmysql: sql error[3]: MySQL server has gone away 2005-04-04 08:25:35.172402500 vmysql: sql error[3]: MySQL server has gone away 2005-04-04 08:25:38.270531500 vmysql: sql error[3]: MySQL server has gone away 2005-04-04 11:45:26.640551500 vmysql: sql error[3]: MySQL server has gone away 2005-04-04 17:24:29.706105500 vmysql: sql error[3]: MySQL server has gone away 2005-04-04 19:30:11.903721500 vmysql: sql error[3]: MySQL server has gone away In other days we haven't any errors. Some suggestions from prior experience, Make sure your MySQL server can see DNS for your client (add your clients IP and host name to the /etc/hosts file to avoid DNS issues) When your mail server says the mySQL server has gone away, 1) check your Aborted_clients and Aborted_connects values in MYSQL. 2) issue a flush status command on the MySQL server and see if connections begin again. 3) check your uptime in mysqladmin, is the SQL server crashing and restarting? It could be your connection between the MySQL server and the vpopmail server is faulty, bad cat5, bad switch, bad NIC. I've seen these happen before. MySQL doesn't like it's connections being interupted. DAve
RE: [vchkpw] vpopmail-mysql problem
Andrea Benedetto wrote: We have a big mail server which authenticate users against mysql (mysql server 4.1.10 and mysql client 4.1.10). Some times we can see in /var/log/qmail/smtpd/current this line: 2005-04-04 11:43:50.962470500 vmysql: sql error[3]: MySQL server has gone away and after this qmail-server says that the mail box doesn't exists. We have read that it could be a timeout error, because vpopmail keep alive conections with mysql server but mysql doesn't (wait_timeout = 28800). But probably this isn't the case, because in the log file we can see that the error above doesn't occur every 8 hours but it appears at every time. Here an example: 2005-04-04 01:30:47.096746500 vmysql: sql error[3]: MySQL server has gone away 2005-04-04 08:25:35.172402500 vmysql: sql error[3]: MySQL server has gone away 2005-04-04 08:25:38.270531500 vmysql: sql error[3]: MySQL server has gone away 2005-04-04 11:45:26.640551500 vmysql: sql error[3]: MySQL server has gone away 2005-04-04 17:24:29.706105500 vmysql: sql error[3]: MySQL server has gone away 2005-04-04 19:30:11.903721500 vmysql: sql error[3]: MySQL server has gone away In other days we haven't any errors. Can you help us? Thanks, andrea Is it possible that you're hitting your MySql max connections? The default is 100 simultaneous connections. Try running this... mysql -uroot -pmysql password -e 'show status;'|grep Max_used_connections If you haven't restarted MySql since the problem was last seen...and if it shows 100...then that is your problem. As a side note, I reported the fact that maxing out connections bounced mail to the devs some time ago. I think they've fixed that in more recent releases. http://www.mail-archive.com/vchkpw@inter7.com/msg19810.html
Re: [vchkpw] Vpopmail + Mysql, can't add domains
I'm not entirely sure how to rebuild qmail-smtpd to use the new libvpopmail for MySQL. I'm imagining I have to recompile Qmail, but how do I single out qmail-smtpd to be the only thing to build, and how do I get it to recognize vpopmail with mysql support exactly? Thanks for your help! On Jun 15, 2004, at 3:50 PM, Tom Collins wrote: On Jun 15, 2004, at 2:41 PM, James Taylor wrote: Looking though the other directories of domains that DO work, I'm noticing they have a file called vpasswd. I've had trouble getting MySQL to completely work, I thought I had it before but now it's acting funky again with this issue. I think what's happening is Vpopmail is using MySQL to store the information, but then it's not using MySQL to retrieve. It sounds like you originally compiled vpopmail for CDB, then compiled qmail-smtpd with the chkusr patch, and then reconfigured/installed vpopmail for MySQL. You need to rebuild qmail-smtpd so it links to the new libvpopmail that's built for MySQL instead of CDB. -- Tom Collins - [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ Info on the Sniffter hand-held Network Tester: http://sniffter.com/
Re: [vchkpw] Vpopmail + Mysql, can't add domains
Hello James, Wednesday, June 16, 2004, 9:57:44 AM you wrote: JT I'm not entirely sure how to rebuild qmail-smtpd to use the new JT libvpopmail for MySQL. I'm imagining I have to recompile Qmail, but JT how do I single out qmail-smtpd to be the only thing to build, and how JT do I get it to recognize vpopmail with mysql support exactly? Thanks JT for your help! Bear with me as I'm new to qmail myself but it seems that it's not getting resolved... I really don't see why you would have to recompile qmail, and especially qmail-smtpd. qmail-smtp uses an external password checker like vchkpw. qmail-send bounces the message if it can't find a match. Why don't you post an unedited version of your logfile and your run script. What patches have you applied to qmail? Are you using vchkpw to check the password? If it was working before, what have you installed recently? You need to rebuild qmail-smtpd so it links to the new libvpopmail that's built for MySQL instead of CDB. What does qmail-smtpd with libvpopmail? -- Regards, Charles.
Re: [vchkpw] Vpopmail + Mysql, can't add domains
Charles M. Gerungan wrote: I really don't see why you would have to recompile qmail, and especially qmail-smtpd. qmail-smtp uses an external password checker like vchkpw. qmail-send bounces the message if it can't find a match. The vpopmail library is statically linked, so every time you recompile it you have to re-link everything that uses it. Many configuration changes in vpopmail require you to recompile vpopmail... and everything that uses it. If the patched qmail-smtpd uses the vpopmail library, it needs to be re-linked. If you keep your source available that usually means make; make install. Many makefiles are smart enough not to wipe out your configuration settings, but always have a backup! Re-compiling this way may be a bit of a hassle, but it allows vpopmail to be much more efficient in day to day operation.
Re: [vchkpw] Vpopmail + Mysql, can't add domains
Hi James I ask because I am having a problem with bounce-no-mailbox. Every domain (about 6 of them) that had bounce-no-mailbox set, was bouncing everything including messages to postmaster. If you could change bounce-no-mailbox to /home/vpopmail/domains/testdomain.com/postmaster (ie set the domain to catch all mail to postmaster) and see if that fixes (albeit temporarily) your problem, it most likely means that we are having the same problem, and I would like to know why too :) Cheers Alastair James Taylor said: | /home/vpopmail/bin/vdelivermail '' bounce-no-mailbox .. which is think is what it's supposed to be set at, no? On Jun 15, 2004, at 2:46 PM, Alastair Battrick wrote: Hi James What is in the .qmail-default for the domain? Cheers Alastair James Taylor wrote: Hi everyone, running vpopmail 5.4 compiled with MySQL (Everything else via Bill's Qmail Toaster) and everything was working just fine until today when I tried to add a domain. Existing domains seem to be working just fine, you can add/delete users fine, information is stored in MySQL and it all looks good. Now though, when I go to add a new domain, just for instance say ./vadddomain testdomain.com testpw It appears to have added the directory - it creates the domain directory as well as the postmaster maildir, and adds the testdomain_com table to MySQL with the postmaster user. It also adds the testdomain_com information to the dir_control table. However, if I try to send mail to postmaster: telnet localhost 25 helo mail from: [EMAIL PROTECTED] rcpt to: [EMAIL PROTECTED] 550 sorry, no mailbox here by that name (#5.1.1 - chkusr) ./vuserinfo [EMAIL PROTECTED] name: postmaster passwd: $1$YnGeWacE$YYLUcT0Gw.te3HGkRa9lD. clear passwd: testpw uid:0 gid:0 flags: 0 gecos: Postmaster limits: No user limits set. dir: /home/vpopmail/domains/testdomain.com/postmaster quota: NOQUOTA usage: NOQUOTA account created: Tue Jun 15 14:28:53 2004 last auth: Never logged in Same information listed in the MySQL row. ./vadduser [EMAIL PROTECTED] testpw .. same results with that user as with postmaster, everything LOOKS good, but nothing works Looking though the other directories of domains that DO work, I'm noticing they have a file called vpasswd. I've had trouble getting MySQL to completely work, I thought I had it before but now it's acting funky again with this issue. I think what's happening is Vpopmail is using MySQL to store the information, but then it's not using MySQL to retrieve. The weird thing about it though is that I can add users to other domains, make changes to existing domains, and it all takes just fine. It makes the changes in the MySQL DB, and it READS those changes, it's just new domains aren't wanting to work anymore. I tried doing ./vconvert -m -c to see if it was using CDB to store all the user info instead of mysql for some reason, but it still doesn't pick up the user information when trying to send them mail. Gives the same as above. If anyone could point me in the right direction I'd appreciate it, I've been pulling my hair out for the past couple hours now.
Re: [vchkpw] Vpopmail + Mysql, can't add domains
Hello Rick, Wednesday, June 16, 2004, 10:56:30 AM you wrote: I really don't see why you would have to recompile qmail, and especially qmail-smtpd. qmail-smtp uses an external password checker like vchkpw. qmail-send bounces the message if it can't find a match. RW The vpopmail library is statically linked, so every time you recompile RW it you have to re-link everything that uses it. Many configuration RW changes in vpopmail require you to recompile vpopmail... and everything RW that uses it. But why would he have to recompile qmail? qmail's password checker is external (it should use vchkpw in his case which is not part of qmail). And okay, I did a grep on qmail's make file, and there's no vpopmail in there. What am I missing? -- Regards, Charles.
Re: [vchkpw] Vpopmail + Mysql, can't add domains
Charles M. Gerungan wrote: Hello Rick, Wednesday, June 16, 2004, 10:56:30 AM you wrote: I really don't see why you would have to recompile qmail, and especially qmail-smtpd. qmail-smtp uses an external password checker like vchkpw. qmail-send bounces the message if it can't find a match. RW The vpopmail library is statically linked, so every time you recompile RW it you have to re-link everything that uses it. Many configuration RW changes in vpopmail require you to recompile vpopmail... and everything RW that uses it. But why would he have to recompile qmail? qmail's password checker is external (it should use vchkpw in his case which is not part of qmail). And okay, I did a grep on qmail's make file, and there's no vpopmail in there. What am I missing? Stock qmail you don't have to recompile. It executes vchkpw to validate users for pop and imap, and vdelivermail in .qmail-default to deliver mail. The only thing I can think of where qmail-smtpd has anything to do with vpopmail is a patch that allows it to reject messages to invalid addresses before they are queued. That patch calls functions in the vpopmail library, and must be recompiled when vpopmail changes. For installs on a virgin machine you must compile qmail, compile vpopmail, then compile qmail again (at least qmail-smtpd) to apply the patch.
Re: [vchkpw] Vpopmail + Mysql, can't add domains
At 16/06/2004 16/06/2004 +0200, you wrote: Hello James, Wednesday, June 16, 2004, 9:57:44 AM you wrote: I really don't see why you would have to recompile qmail, and especially qmail-smtpd. qmail-smtp uses an external password checker like vchkpw. qmail-send bounces the message if it can't find a match. Chkuser does use the vpopmail library, in order to check instantly for user existance. It does NOT use external checker, for performance reasons. Using an external checker would mean to run it each time for a different recipient (one run, one attach, etc.. for each recipient), much more slow and resources demanding. I remember you're using Bill's Shupp megapatch, and Bill gives different versions of chkuser integration, depending if you're using cdb, mysql or other. So, if you changed from cdb to MySQL, you must now adapt your Makefile (add mysql libraries and probably -lz) an recompile, or run again Bill's patch (chkuser.mysql) over a plain qmail installation and recompile. Or, there is a new patch here around, using an external checker. If you don't have any performance issue, use the new patch. Tonino [EMAIL PROTECTED]Interazioni di Antonio Nati http://www.interazioni.it [EMAIL PROTECTED]
Re: [vchkpw] Vpopmail + Mysql, can't add domains
On Jun 16, 2004, at 1:26 AM, Charles M. Gerungan wrote: I really don't see why you would have to recompile qmail, and especially qmail-smtpd. qmail-smtp uses an external password checker like vchkpw. qmail-send bounces the message if it can't find a match. The start of the thread indicated that he was having trouble with the chkusr patch to qmail-smtpd -- it was only working for domains with a vpasswd file, even though he was now using the MySQL backend. Based on his description, I indicated that qmail-smtpd (with chkusr) needed to be re-linked to the libvpopmail built with MySQL support. -- Tom Collins - [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ Info on the Sniffter hand-held Network Tester: http://sniffter.com/
Re: [vchkpw] Vpopmail + Mysql, can't add domains
On Wednesday 16 June 2004 05:11 am, Charles M. Gerungan wrote: What am I missing? you're missing that he's using the chkuser patch. -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
Re: [vchkpw] Vpopmail + Mysql, can't add domains
Hello Tom, Wednesday, June 16, 2004, 4:52:45 PM you wrote: TC The start of the thread indicated that he was having trouble with the TC chkusr patch to qmail-smtpd -- it was only working for domains with a TC vpasswd file, even though he was now using the MySQL backend. As I only just became a member, I must have missed this. Ignore... -- Regards, Charles.
Re: [vchkpw] Vpopmail + Mysql, can't add domains
Actually, strangely enough, this DID fix the problem so mail is at least working, but I'm going to have to try to figure out how to get everything else going. On Jun 16, 2004, at 2:10 AM, Alastair Battrick wrote: Hi James I ask because I am having a problem with bounce-no-mailbox. Every domain (about 6 of them) that had bounce-no-mailbox set, was bouncing everything including messages to postmaster. If you could change bounce-no-mailbox to /home/vpopmail/domains/testdomain.com/postmaster (ie set the domain to catch all mail to postmaster) and see if that fixes (albeit temporarily) your problem, it most likely means that we are having the same problem, and I would like to know why too :) Cheers Alastair James Taylor said: | /home/vpopmail/bin/vdelivermail '' bounce-no-mailbox .. which is think is what it's supposed to be set at, no? On Jun 15, 2004, at 2:46 PM, Alastair Battrick wrote: Hi James What is in the .qmail-default for the domain? Cheers Alastair James Taylor wrote: Hi everyone, running vpopmail 5.4 compiled with MySQL (Everything else via Bill's Qmail Toaster) and everything was working just fine until today when I tried to add a domain. Existing domains seem to be working just fine, you can add/delete users fine, information is stored in MySQL and it all looks good. Now though, when I go to add a new domain, just for instance say ./vadddomain testdomain.com testpw It appears to have added the directory - it creates the domain directory as well as the postmaster maildir, and adds the testdomain_com table to MySQL with the postmaster user. It also adds the testdomain_com information to the dir_control table. However, if I try to send mail to postmaster: telnet localhost 25 helo mail from: [EMAIL PROTECTED] rcpt to: [EMAIL PROTECTED] 550 sorry, no mailbox here by that name (#5.1.1 - chkusr) ./vuserinfo [EMAIL PROTECTED] name: postmaster passwd: $1$YnGeWacE$YYLUcT0Gw.te3HGkRa9lD. clear passwd: testpw uid:0 gid:0 flags: 0 gecos: Postmaster limits: No user limits set. dir: /home/vpopmail/domains/testdomain.com/postmaster quota: NOQUOTA usage: NOQUOTA account created: Tue Jun 15 14:28:53 2004 last auth: Never logged in Same information listed in the MySQL row. ./vadduser [EMAIL PROTECTED] testpw .. same results with that user as with postmaster, everything LOOKS good, but nothing works Looking though the other directories of domains that DO work, I'm noticing they have a file called vpasswd. I've had trouble getting MySQL to completely work, I thought I had it before but now it's acting funky again with this issue. I think what's happening is Vpopmail is using MySQL to store the information, but then it's not using MySQL to retrieve. The weird thing about it though is that I can add users to other domains, make changes to existing domains, and it all takes just fine. It makes the changes in the MySQL DB, and it READS those changes, it's just new domains aren't wanting to work anymore. I tried doing ./vconvert -m -c to see if it was using CDB to store all the user info instead of mysql for some reason, but it still doesn't pick up the user information when trying to send them mail. Gives the same as above. If anyone could point me in the right direction I'd appreciate it, I've been pulling my hair out for the past couple hours now.
Re: [vchkpw] Vpopmail + Mysql, can't add domains
This is not strange, as you are disabling chkuser. You have a misconfiguration. You must modify your qmail Makefile, and recompile it, with the lastest vpopmail library you are using. Tonino At 16/06/2004 16/06/2004 -0700, you wrote: Actually, strangely enough, this DID fix the problem so mail is at least working, but I'm going to have to try to figure out how to get everything else going. On Jun 16, 2004, at 2:10 AM, Alastair Battrick wrote: Hi James I ask because I am having a problem with bounce-no-mailbox. Every domain (about 6 of them) that had bounce-no-mailbox set, was bouncing everything including messages to postmaster. If you could change bounce-no-mailbox to /home/vpopmail/domains/testdomain.com/postmaster (ie set the domain to catch all mail to postmaster) and see if that fixes (albeit temporarily) your problem, it most likely means that we are having the same problem, and I would like to know why too :) Cheers Alastair James Taylor said: | /home/vpopmail/bin/vdelivermail '' bounce-no-mailbox .. which is think is what it's supposed to be set at, no? On Jun 15, 2004, at 2:46 PM, Alastair Battrick wrote: Hi James What is in the .qmail-default for the domain? Cheers Alastair James Taylor wrote: Hi everyone, running vpopmail 5.4 compiled with MySQL (Everything else via Bill's Qmail Toaster) and everything was working just fine until today when I tried to add a domain. Existing domains seem to be working just fine, you can add/delete users fine, information is stored in MySQL and it all looks good. Now though, when I go to add a new domain, just for instance say ./vadddomain testdomain.com testpw It appears to have added the directory - it creates the domain directory as well as the postmaster maildir, and adds the testdomain_com table to MySQL with the postmaster user. It also adds the testdomain_com information to the dir_control table. However, if I try to send mail to postmaster: telnet localhost 25 helo mail from: [EMAIL PROTECTED] rcpt to: [EMAIL PROTECTED] 550 sorry, no mailbox here by that name (#5.1.1 - chkusr) ./vuserinfo [EMAIL PROTECTED] name: postmaster passwd: $1$YnGeWacE$YYLUcT0Gw.te3HGkRa9lD. clear passwd: testpw uid:0 gid:0 flags: 0 gecos: Postmaster limits: No user limits set. dir: /home/vpopmail/domains/testdomain.com/postmaster quota: NOQUOTA usage: NOQUOTA account created: Tue Jun 15 14:28:53 2004 last auth: Never logged in Same information listed in the MySQL row. ./vadduser [EMAIL PROTECTED] testpw .. same results with that user as with postmaster, everything LOOKS good, but nothing works Looking though the other directories of domains that DO work, I'm noticing they have a file called vpasswd. I've had trouble getting MySQL to completely work, I thought I had it before but now it's acting funky again with this issue. I think what's happening is Vpopmail is using MySQL to store the information, but then it's not using MySQL to retrieve. The weird thing about it though is that I can add users to other domains, make changes to existing domains, and it all takes just fine. It makes the changes in the MySQL DB, and it READS those changes, it's just new domains aren't wanting to work anymore. I tried doing ./vconvert -m -c to see if it was using CDB to store all the user info instead of mysql for some reason, but it still doesn't pick up the user information when trying to send them mail. Gives the same as above. If anyone could point me in the right direction I'd appreciate it, I've been pulling my hair out for the past couple hours now. [EMAIL PROTECTED]Interazioni di Antonio Nati http://www.interazioni.it [EMAIL PROTECTED]
Re: [vchkpw] Vpopmail + Mysql, can't add domains
Hi James What is in the .qmail-default for the domain? Cheers Alastair James Taylor wrote: Hi everyone, running vpopmail 5.4 compiled with MySQL (Everything else via Bill's Qmail Toaster) and everything was working just fine until today when I tried to add a domain. Existing domains seem to be working just fine, you can add/delete users fine, information is stored in MySQL and it all looks good. Now though, when I go to add a new domain, just for instance say ./vadddomain testdomain.com testpw It appears to have added the directory - it creates the domain directory as well as the postmaster maildir, and adds the testdomain_com table to MySQL with the postmaster user. It also adds the testdomain_com information to the dir_control table. However, if I try to send mail to postmaster: telnet localhost 25 helo mail from: [EMAIL PROTECTED] rcpt to: [EMAIL PROTECTED] 550 sorry, no mailbox here by that name (#5.1.1 - chkusr) ./vuserinfo [EMAIL PROTECTED] name: postmaster passwd: $1$YnGeWacE$YYLUcT0Gw.te3HGkRa9lD. clear passwd: testpw uid:0 gid:0 flags: 0 gecos: Postmaster limits: No user limits set. dir: /home/vpopmail/domains/testdomain.com/postmaster quota: NOQUOTA usage: NOQUOTA account created: Tue Jun 15 14:28:53 2004 last auth: Never logged in Same information listed in the MySQL row. ./vadduser [EMAIL PROTECTED] testpw .. same results with that user as with postmaster, everything LOOKS good, but nothing works Looking though the other directories of domains that DO work, I'm noticing they have a file called vpasswd. I've had trouble getting MySQL to completely work, I thought I had it before but now it's acting funky again with this issue. I think what's happening is Vpopmail is using MySQL to store the information, but then it's not using MySQL to retrieve. The weird thing about it though is that I can add users to other domains, make changes to existing domains, and it all takes just fine. It makes the changes in the MySQL DB, and it READS those changes, it's just new domains aren't wanting to work anymore. I tried doing ./vconvert -m -c to see if it was using CDB to store all the user info instead of mysql for some reason, but it still doesn't pick up the user information when trying to send them mail. Gives the same as above. If anyone could point me in the right direction I'd appreciate it, I've been pulling my hair out for the past couple hours now.
Re: [vchkpw] Vpopmail + Mysql, can't add domains
| /home/vpopmail/bin/vdelivermail '' bounce-no-mailbox .. which is think is what it's supposed to be set at, no? On Jun 15, 2004, at 2:46 PM, Alastair Battrick wrote: Hi James What is in the .qmail-default for the domain? Cheers Alastair James Taylor wrote: Hi everyone, running vpopmail 5.4 compiled with MySQL (Everything else via Bill's Qmail Toaster) and everything was working just fine until today when I tried to add a domain. Existing domains seem to be working just fine, you can add/delete users fine, information is stored in MySQL and it all looks good. Now though, when I go to add a new domain, just for instance say ./vadddomain testdomain.com testpw It appears to have added the directory - it creates the domain directory as well as the postmaster maildir, and adds the testdomain_com table to MySQL with the postmaster user. It also adds the testdomain_com information to the dir_control table. However, if I try to send mail to postmaster: telnet localhost 25 helo mail from: [EMAIL PROTECTED] rcpt to: [EMAIL PROTECTED] 550 sorry, no mailbox here by that name (#5.1.1 - chkusr) ./vuserinfo [EMAIL PROTECTED] name: postmaster passwd: $1$YnGeWacE$YYLUcT0Gw.te3HGkRa9lD. clear passwd: testpw uid:0 gid:0 flags: 0 gecos: Postmaster limits: No user limits set. dir: /home/vpopmail/domains/testdomain.com/postmaster quota: NOQUOTA usage: NOQUOTA account created: Tue Jun 15 14:28:53 2004 last auth: Never logged in Same information listed in the MySQL row. ./vadduser [EMAIL PROTECTED] testpw .. same results with that user as with postmaster, everything LOOKS good, but nothing works Looking though the other directories of domains that DO work, I'm noticing they have a file called vpasswd. I've had trouble getting MySQL to completely work, I thought I had it before but now it's acting funky again with this issue. I think what's happening is Vpopmail is using MySQL to store the information, but then it's not using MySQL to retrieve. The weird thing about it though is that I can add users to other domains, make changes to existing domains, and it all takes just fine. It makes the changes in the MySQL DB, and it READS those changes, it's just new domains aren't wanting to work anymore. I tried doing ./vconvert -m -c to see if it was using CDB to store all the user info instead of mysql for some reason, but it still doesn't pick up the user information when trying to send them mail. Gives the same as above. If anyone could point me in the right direction I'd appreciate it, I've been pulling my hair out for the past couple hours now.
Re: [vchkpw] Vpopmail + Mysql, can't add domains
On Jun 15, 2004, at 2:41 PM, James Taylor wrote: Looking though the other directories of domains that DO work, I'm noticing they have a file called vpasswd. I've had trouble getting MySQL to completely work, I thought I had it before but now it's acting funky again with this issue. I think what's happening is Vpopmail is using MySQL to store the information, but then it's not using MySQL to retrieve. It sounds like you originally compiled vpopmail for CDB, then compiled qmail-smtpd with the chkusr patch, and then reconfigured/installed vpopmail for MySQL. You need to rebuild qmail-smtpd so it links to the new libvpopmail that's built for MySQL instead of CDB. -- Tom Collins - [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ Info on the Sniffter hand-held Network Tester: http://sniffter.com/
RE: [vchkpw] Vpopmail MySQL
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
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
Re: [vchkpw] vpopmail mysql database
You need to make sure you granted the appropriate permissions in the database eg GRANT select,insert,update,delete,create,drop ON vpopmail.* TO [EMAIL PROTECTED] IDENTIFIED BY 'vpoppasswd'; Also make sure you dont have ipchains/iptables blocking the mysql port Michael. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, October 25, 2003 9:46 PM Subject: [vchkpw] vpopmail mysql database Hi to all, i have to use vpopmail on a machine and read database password (mysql) on another machine. Please note that in the first machine there are not any mailboxes. I only have to read password on mysql database on another machine in which is installed vpopmail with mailboxes. I tryied to edit vmysql.h e recompile but always it can't authenticate. Have i forgot anything? Thankx for help matmak
Re: [vchkpw] vpopmail + mysql
On Thursday, October 2, 2003, at 10:52 AM, Russell Mann wrote: Finally fixed the vpopmail 5.3.27 + mysql non-working issue (see previous posts). In trying to track this down I've come across some other problems. [EMAIL PROTECTED] new.bin]# ./vadddomain media.khouse.org Please enter password for postmaster: enter password again: Error: Domain already exists [EMAIL PROTECTED] new.bin]# Domain already exists eh? media.khouse.org not found in: ~vpopmail/domains/* /var/qmail/users/assign /var/qmail/control/rcpthosts /var/qmail/control/virtualdomains Whats up with that? Is it still in the MySQL database? By the way, this is how I fixed the mysql issue: After this, I made some changes to ~vpopmail/etc/vpopmail.mysql I went from two lines to one line, and gave the one line user these permissions: SELECT, INSERT, UPDATE, DELETE, CREATE Hmm. This is good to know. What happens if you use the same login information on both lines? Does it still work? There's a chance that part of the auth module is opening a read connection when it should be opening an update connection. -- Tom Collins [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ Info on the Sniffter hand-held Network Tester: http://sniffter.com/
RE: [vchkpw] vpopmail + mysql
On Thursday, October 2, 2003, at 10:52 AM, Russell Mann wrote: Finally fixed the vpopmail 5.3.27 + mysql non-working issue (see previous posts). In trying to track this down I've come across some other problems. [EMAIL PROTECTED] new.bin]# ./vadddomain media.khouse.org Please enter password for postmaster: enter password again: Error: Domain already exists [EMAIL PROTECTED] new.bin]# Domain already exists eh? media.khouse.org not found in: ~vpopmail/domains/* /var/qmail/users/assign /var/qmail/control/rcpthosts /var/qmail/control/virtualdomains Whats up with that? Is it still in the MySQL database? Nope, I dropped it manually. By the way, this is how I fixed the mysql issue: After this, I made some changes to ~vpopmail/etc/vpopmail.mysql I went from two lines to one line, and gave the one line user these permissions: SELECT, INSERT, UPDATE, DELETE, CREATE Hmm. This is good to know. What happens if you use the same login information on both lines? Does it still work? With one simple test it seems to work. I didn't try anything but popping in, as this is a production box. There's a chance that part of the auth module is opening a read connection when it should be opening an update connection. This is what I suspected, but I'm not familiar enough with this code base to track down which exact line it is. I was getting a sql error[3] which is always listed as a read open.
Re: [vchkpw] vpopmail + mysql
On Thursday, October 2, 2003, at 12:59 PM, Russell Mann wrote: Domain already exists eh? media.khouse.org not found in: ~vpopmail/domains/* /var/qmail/users/assign /var/qmail/control/rcpthosts /var/qmail/control/virtualdomains Whats up with that? Is it still in the MySQL database? Nope, I dropped it manually. After removing it from users/assign, did you run qmail-newu to update users/cdb? The vpopmail code actually uses the cdb file, and not the assign file used to create it, when checking to see if a domain already exists. -- Tom Collins [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ Info on the Sniffter hand-held Network Tester: http://sniffter.com/
RE: [vchkpw] vpopmail + mysql
After removing it from users/assign, did you run qmail-newu to update users/cdb? The vpopmail code actually uses the cdb file, and not the assign file used to create it, when checking to see if a domain already exists. [EMAIL PROTECTED] /var/qmail/bin/qmail-newu qmail-newu: fatal: bad format in users/assign
Re: [vchkpw] vpopmail mysql !!
On Thu, 14 Aug 2003, eLgino wrote: could not connect to mysql update server Client does not support authentication protocol requested by server. Consider upgrading MySQL client Server: 4.1.0 Client 3 and 4 all right, right password for vpopmail user and the server is running!! But your client and server are different versions. pkg_delete your mysql stuff and start from scratch. Use the 4.0.x version of the port. It will build the client and server. Rebuild your vpopmail stuff so it links against the right mysql library... Charles
Re: [vchkpw] vpopmail mysql !!
thanks to all it works with MySQL-4.0 Server and client not with 4.1-Alpha! - Original Message - From: Charles Sprickman [EMAIL PROTECTED] To: eLgino [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, August 16, 2003 9:32 PM Subject: Re: [vchkpw] vpopmail mysql !! On Thu, 14 Aug 2003, eLgino wrote: could not connect to mysql update server Client does not support authentication protocol requested by server. Consider upgrading MySQL client Server: 4.1.0 Client 3 and 4 all right, right password for vpopmail user and the server is running!! But your client and server are different versions. pkg_delete your mysql stuff and start from scratch. Use the 4.0.x version of the port. It will build the client and server. Rebuild your vpopmail stuff so it links against the right mysql library... Charles
Re: [vchkpw] vpopmail mysql
Could it be that you're linking against MySQL client 3 instead of MySQL client 4? Or is your MySQL 4.0 client library trying to connect to MySQL 4.1 server? You've definitely got a version mismatch of *some* sort Also, I'd strongly recommend NOT using MySQL Server 4.1.0. It was released just to convince people that MySQL AB follows the release early, release often philosophy (though that version is ages old by now), but it really has too many bugs. If you absolutely need the latest MySQL (for subselects and derived tables, for example, though I don't see how you need use them in the vpopmail database) then install from the 4.1 bitkeeper branch. Instructions are on mysql.com. If you don't know what you want, you want MySQL 4.0.13. And you want to uninstall MySQL Client 3. -- Adam Hooper [EMAIL PROTECTED] eLgino wrote: ERROR 1249: Client does not support authentication protocol requested by server. Consider upgrading MySQL client i have mysql client 3 AND 4 and server 4.1.0 OS: FreeBSD 4.8 vpopmail= newest one - Original Message - From: Rick Macdougall [EMAIL PROTECTED] To: eLgino [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, August 14, 2003 6:17 PM Subject: Re: [vchkpw] vpopmail mysql Hi, We use it with 4.x without a problem. Regards, Rick eLgino wrote: hi folks, does work vpopmail with MySQL 4.1.0? or only with version 3? thx
Re: [vchkpw] vpopmail mysql
On Thu, 14 Aug 2003, eLgino wrote: hi folks, does work vpopmail with MySQL 4.1.0? or only with version 3? I've been running with 4.0.x with no problems. 4.1.x is not recommended for production use though, as stated on the mysql.com website... Charles thx
Re: [vchkpw] vpopmail mysql
Hi, We use it with 4.x without a problem. Regards, Rick eLgino wrote: hi folks, does work vpopmail with MySQL 4.1.0? or only with version 3? thx
RE: [vchkpw] vpopmail mysql
:: hi folks, :: :: does work vpopmail with MySQL 4.1.0? or only with version 3? Just to provide a me too... We are currently using 4.0.13 in production coupled with replication and has worked flawlessly for us. (We dediced to go with 4.0.x because of the positive things I have heard with regard to speed performance coupled with replication.) Tom Walsh Network Administrator http://www.ala.net/
Re: [vchkpw] vpopmail + mysql : Define other mysql host in vmysql.hhow-to?
Of course, this is all documented in README.mysql... Ahmad Masood Shah wrote: Hi Kuan, Thanks for your kind of information. any how where are you from. and What type of enviornment you have. I'm working with an ISP www.fibre.net.pk http://www.fibre.net.pk -- Best Regs, Masood Ahmad Shah System Administrator ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ | * * * * * * * * * * * * * * * * * * * * * * * * | Fibre Net (Pvt) Ltd. Lahore, Pakistan | Tel: +92-42-6677024 | Mobile: +92-300-4277367 | http://www.fibre.net.pk | * * * * * * * * * * * * * * * * * * * * * * * * ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ Unix is very simple, but it takes a genius to understand the simplicity. (Dennis Ritchie) - Original Message - From: Kuan Yik mailto:[EMAIL PROTECTED] To: Ahmad Masood Shah mailto:[EMAIL PROTECTED] ; [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 8:23 AM Subject: Re: [vchkpw] vpopmail + mysql : Define other mysql host in vmysql.h how-to? Hi Ahmad, I have found out how to define the different port number for the mysql. We can actually define the mysql port number in the vmysql.h file under the /* defaults - no need to change */ #define MYSQL_VPORT 0 Default value is 0 and you can define to the differnet port number if you wish. Thank you for your help anyway. - Original Message - From: Ahmad Masood Shah mailto:[EMAIL PROTECTED] To: Kuan Yik mailto:[EMAIL PROTECTED] ; [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Sent: Friday, July 11, 2003 3:21 PM Subject: Re: [vchkpw] vpopmail + mysql : Define other mysql host in vmysql.h how-to? hmm have u changed /etc/service mysql it can be handy ... me is kinda busy let me find where you can put port in vmyslq.h or you will have to change some code in this file...give me time I will do for u... -- Best Regs, Masood Ahmad Shah System Administrator ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ | * * * * * * * * * * * * * * * * * * * * * * * * | Fibre Net (Pvt) Ltd. Lahore, Pakistan | Tel: +92-42-6677024 | Mobile: +92-300-4277367 | http://www.fibre.net.pk | * * * * * * * * * * * * * * * * * * * * * * * * ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ Unix is very simple, but it takes a genius to understand the simplicity. (Dennis Ritchie) - Original Message - From: Kuan Yik mailto:[EMAIL PROTECTED] To: Ahmad Masood Shah mailto:[EMAIL PROTECTED] ; [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Sent: Friday, July 11, 2003 11:42 AM Subject: Re: [vchkpw] vpopmail + mysql : Define other mysql host in vmysql.h how-to? Hi Ahmad, thanks for your reply, but what if I want to define different port number or sock file? It is not working if I define like #define MYSQL_UPDATE_SERVER localhost: #define MYSQL_READ_SERVER localhost: OR #define MYSQL_UPDATE_SERVER /usr/local/mysq/mysql.sock #define MYSQL_READ_SERVER /usr/local/mysql/mysql.sock Any idea how ? thanks - Original Message - From: Ahmad Masood Shah mailto:[EMAIL PROTECTED] To: Kuan Yik mailto:[EMAIL PROTECTED] ; [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Sent: Friday, July 11, 2003 2:25 PM Subject: Re: [vchkpw] vpopmail + mysql : Define other mysql host in vmysql.h how-to? simple is that open you command prompt vi vmysql.h you will find 2 lines like shown below... #define MYSQL_UPDATE_SERVER localhost #define MYSQL_READ_SERVER localhost and blah balh -- Best Regs, Masood Ahmad Shah System Administrator ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ | * * * * * * * * * * * * * * * * * * * * * * * * | Fibre Net (Pvt) Ltd. Lahore, Pakistan | Tel: +92-42-6677024 | Mobile: +92-300-4277367 | http://www.fibre.net.pk | * * * * * * * * * * * * * * * * * * * * * * * * ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ Unix is very simple, but it takes a genius to understand
Re: [vchkpw] vpopmail + mysql : Define other mysql host in vmysql.h how-to?
Hi Ahmad, I have found out how to define the different port number for the mysql. We can actually define the mysql port number in the vmysql.h file under the /* defaults - no need to change */#define MYSQL_VPORT 0 Default valueis 0 and you can define to the differnet port number if you wish. Thank you for your help anyway. - Original Message - From: Ahmad Masood Shah To: Kuan Yik ; [EMAIL PROTECTED] Sent: Friday, July 11, 2003 3:21 PM Subject: Re: [vchkpw] vpopmail + mysql : Define other mysql host in vmysql.h how-to? hmm have u changed /etc/service mysql it can be handy ... me is kinda busy let me find where you can put port in vmyslq.h or you will have to change some code in this file...give me time I will do for u... -- Best Regs,Masood Ahmad ShahSystem Administrator^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^| * * * * * * * * * * * * * * * * * * * * * * * *| Fibre Net (Pvt) Ltd. Lahore, Pakistan| Tel: +92-42-6677024| Mobile: +92-300-4277367| http://www.fibre.net.pk| * * * * * * * * * * * * * * * * * * * * * * * *^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^Unix is very simple, but it takes a genius to understand the simplicity.(Dennis Ritchie) - Original Message - From: Kuan Yik To: Ahmad Masood Shah ; [EMAIL PROTECTED] Sent: Friday, July 11, 2003 11:42 AM Subject: Re: [vchkpw] vpopmail + mysql : Define other mysql host in vmysql.h how-to? Hi Ahmad, thanks for your reply, but what if I want to define different port number or sock file? It is not working if I define like #define MYSQL_UPDATE_SERVER "localhost:" #define MYSQL_READ_SERVER "localhost:" OR #define MYSQL_UPDATE_SERVER "/usr/local/mysq/mysql.sock" #define MYSQL_READ_SERVER "/usr/local/mysql/mysql.sock" Any idea how ? thanks - Original Message - From: Ahmad Masood Shah To: Kuan Yik ; [EMAIL PROTECTED] Sent: Friday, July 11, 2003 2:25 PM Subject: Re: [vchkpw] vpopmail + mysql : Define other mysql host in vmysql.h how-to? simple is that open you command prompt vi vmysql.h you will find 2 lines like shown below... #define MYSQL_UPDATE_SERVER "localhost" #define MYSQL_READ_SERVER "localhost" and blah balh -- Best Regs,Masood Ahmad ShahSystem Administrator^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^| * * * * * * * * * * * * * * * * * * * * * * * *| Fibre Net (Pvt) Ltd. Lahore, Pakistan| Tel: +92-42-6677024| Mobile: +92-300-4277367| http://www.fibre.net.pk| * * * * * * * * * * * * * * * * * * * * * * * *^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^Unix is very simple, but it takes a genius to understand the simplicity.(Dennis Ritchie) - Original Message - From: Kuan Yik To: [EMAIL PROTECTED] Sent: Friday, July 11, 2003 6:16 AM Subject: [vchkpw] vpopmail + mysql : Define other mysql host in vmysql.h how-to? Hi guys, anyone of you have any idea how to defind the parameter of mysql host in vmysql.h file if I want to point it to different port and host instead of "localhost". Please advise and thank you very much. Regards, Max
Re: [vchkpw] vpopmail + mysql : Define other mysql host in vmysql.h how-to?
Hi Kuan,
Thanks for your kind of information.
any how where are you from. and What type of
enviornment you have.
I'm working with an ISP www.fibre.net.pk
-- Best Regs,Masood Ahmad ShahSystem
Administrator^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^
^| * * * * * * * * * * * * * * * * * * * * * * *
*| Fibre Net (Pvt) Ltd. Lahore, Pakistan| Tel:
+92-42-6677024| Mobile: +92-300-4277367| http://www.fibre.net.pk| * *
* * * * * * * * * * * * * * * * * * * * * *^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^
^ ^ ^ ^ ^ ^ ^ ^Unix is very simple, but it takes a genius to understand the
simplicity.(Dennis Ritchie)
- Original Message -
From:
Kuan
Yik
To: Ahmad Masood Shah ; [EMAIL PROTECTED]
Sent: Tuesday, July 22, 2003 8:23
AM
Subject: Re: [vchkpw] vpopmail + mysql :
Define other mysql host in vmysql.h how-to?
Hi Ahmad,
I have found out how to define the different port
number for the mysql. We can actually define the mysql port number in the
vmysql.h file under the
/* defaults - no need to change */#define
MYSQL_VPORT 0
Default valueis 0 and you can define to the
differnet port number if you wish.
Thank you for your help anyway.
- Original Message -
From:
Ahmad
Masood Shah
To: Kuan Yik ; [EMAIL PROTECTED]
Sent: Friday, July 11, 2003 3:21
PM
Subject: Re: [vchkpw] vpopmail + mysql
: Define other mysql host in vmysql.h how-to?
hmm have u changed /etc/service mysql
it can be handy ... me is kinda busy let me
find where you can put port in vmyslq.h or you will have to change some code
in this file...give me time I will do for u...
-- Best Regs,Masood Ahmad ShahSystem
Administrator^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^
^| * * * * * * * * * * * * * * * * * * * * * * *
*| Fibre Net (Pvt) Ltd. Lahore, Pakistan|
Tel: +92-42-6677024| Mobile:
+92-300-4277367| http://www.fibre.net.pk|
* * * * * * * * * * * * * * * * * * * * * * * *^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^
^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^Unix is very simple, but it takes a genius to
understand the simplicity.(Dennis Ritchie)
- Original Message -
From:
Kuan
Yik
To: Ahmad Masood Shah ; [EMAIL PROTECTED]
Sent: Friday, July 11, 2003 11:42
AM
Subject: Re: [vchkpw] vpopmail +
mysql : Define other mysql host in vmysql.h how-to?
Hi Ahmad, thanks for your reply, but what if
I want to define different port number or sock file?
It is not working if I define
like
#define MYSQL_UPDATE_SERVER
"localhost:"
#define MYSQL_READ_SERVER
"localhost:"
OR
#define MYSQL_UPDATE_SERVER
"/usr/local/mysq/mysql.sock"
#define MYSQL_READ_SERVER
"/usr/local/mysql/mysql.sock"
Any idea how ?
thanks
- Original Message -
From:
Ahmad
Masood Shah
To: Kuan Yik ; [EMAIL PROTECTED]
Sent: Friday, July 11, 2003 2:25
PM
Subject: Re: [vchkpw] vpopmail +
mysql : Define other mysql host in vmysql.h how-to?
simple is that open you command
prompt
vi vmysql.h
you will find 2 lines like shown
below...
#define MYSQL_UPDATE_SERVER
"localhost"
#define MYSQL_READ_SERVER
"localhost"
and blah balh
-- Best Regs,Masood Ahmad ShahSystem
Administrator^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^
^ ^| * * * * * * * * * * * * * * * * * * * * * * *
*| Fibre Net (Pvt) Ltd. Lahore,
Pakistan| Tel: +92-42-6677024| Mobile:
+92-300-4277367| http://www.fibre.net.pk|
* * * * * * * * * * * * * * * * * * * * * * * *^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^
^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^Unix is very simple, but it takes a
genius to understand the simplicity.(Dennis Ritchie)
- Original Message -
From:
Kuan Yik
To: [EMAIL PROTECTED]
Sent: Friday, July 11, 2003 6:16
AM
Subject: [vchkpw] vpopmail +
mysql : Define other mysql host in vmysql.h how-to?
Hi guys, anyone of you have any idea how
to defind the parameter of mysql host in vmysql.h file if I want to
point it to different port and host instead of
"localhost".
Please advise and thank you very
much.
Regards,
Max
Re: [vchkpw] vpopmail + mysql : Define other mysql host in vmysql.h how-to?
simple is that open you command prompt vi vmysql.h you will find 2 lines like shown below... #define MYSQL_UPDATE_SERVER "localhost" #define MYSQL_READ_SERVER "localhost" and blah balh -- Best Regs,Masood Ahmad ShahSystem Administrator^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^| * * * * * * * * * * * * * * * * * * * * * * * *| Fibre Net (Pvt) Ltd. Lahore, Pakistan| Tel: +92-42-6677024| Mobile: +92-300-4277367| http://www.fibre.net.pk| * * * * * * * * * * * * * * * * * * * * * * * *^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^Unix is very simple, but it takes a genius to understand the simplicity.(Dennis Ritchie) - Original Message - From: Kuan Yik To: [EMAIL PROTECTED] Sent: Friday, July 11, 2003 6:16 AM Subject: [vchkpw] vpopmail + mysql : Define other mysql host in vmysql.h how-to? Hi guys, anyone of you have any idea how to defind the parameter of mysql host in vmysql.h file if I want to point it to different port and host instead of "localhost". Please advise and thank you very much. Regards, Max
Re: [vchkpw] vpopmail + mysql : Define other mysql host in vmysql.h how-to?
Hi Ahmad, thanks for your reply, but what if I want to define different port number or sock file? It is not working if I define like #define MYSQL_UPDATE_SERVER "localhost:" #define MYSQL_READ_SERVER "localhost:" OR #define MYSQL_UPDATE_SERVER "/usr/local/mysq/mysql.sock" #define MYSQL_READ_SERVER "/usr/local/mysql/mysql.sock" Any idea how ? thanks - Original Message - From: Ahmad Masood Shah To: Kuan Yik ; [EMAIL PROTECTED] Sent: Friday, July 11, 2003 2:25 PM Subject: Re: [vchkpw] vpopmail + mysql : Define other mysql host in vmysql.h how-to? simple is that open you command prompt vi vmysql.h you will find 2 lines like shown below... #define MYSQL_UPDATE_SERVER "localhost" #define MYSQL_READ_SERVER "localhost" and blah balh -- Best Regs,Masood Ahmad ShahSystem Administrator^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^| * * * * * * * * * * * * * * * * * * * * * * * *| Fibre Net (Pvt) Ltd. Lahore, Pakistan| Tel: +92-42-6677024| Mobile: +92-300-4277367| http://www.fibre.net.pk| * * * * * * * * * * * * * * * * * * * * * * * *^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^Unix is very simple, but it takes a genius to understand the simplicity.(Dennis Ritchie) - Original Message - From: Kuan Yik To: [EMAIL PROTECTED] Sent: Friday, July 11, 2003 6:16 AM Subject: [vchkpw] vpopmail + mysql : Define other mysql host in vmysql.h how-to? Hi guys, anyone of you have any idea how to defind the parameter of mysql host in vmysql.h file if I want to point it to different port and host instead of "localhost". Please advise and thank you very much. Regards, Max
Re: [vchkpw] vpopmail + mysql : Define other mysql host in vmysql.h how-to?
hmm have u changed /etc/service mysql
it can be handy ... me is kinda busy let me find
where you can put port in vmyslq.h or you will have to change some code in this
file...give me time I will do for u...
-- Best Regs,Masood Ahmad ShahSystem
Administrator^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^
^| * * * * * * * * * * * * * * * * * * * * * * *
*| Fibre Net (Pvt) Ltd. Lahore, Pakistan| Tel:
+92-42-6677024| Mobile: +92-300-4277367| http://www.fibre.net.pk| * *
* * * * * * * * * * * * * * * * * * * * * *^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^
^ ^ ^ ^ ^ ^ ^ ^Unix is very simple, but it takes a genius to understand the
simplicity.(Dennis Ritchie)
- Original Message -
From:
Kuan
Yik
To: Ahmad Masood Shah ; [EMAIL PROTECTED]
Sent: Friday, July 11, 2003 11:42
AM
Subject: Re: [vchkpw] vpopmail + mysql :
Define other mysql host in vmysql.h how-to?
Hi Ahmad, thanks for your reply, but what if I
want to define different port number or sock file?
It is not working if I define like
#define MYSQL_UPDATE_SERVER
"localhost:"
#define MYSQL_READ_SERVER
"localhost:"
OR
#define MYSQL_UPDATE_SERVER
"/usr/local/mysq/mysql.sock"
#define MYSQL_READ_SERVER
"/usr/local/mysql/mysql.sock"
Any idea how ?
thanks
- Original Message -
From:
Ahmad
Masood Shah
To: Kuan Yik ; [EMAIL PROTECTED]
Sent: Friday, July 11, 2003 2:25
PM
Subject: Re: [vchkpw] vpopmail + mysql
: Define other mysql host in vmysql.h how-to?
simple is that open you command
prompt
vi vmysql.h
you will find 2 lines like shown
below...
#define MYSQL_UPDATE_SERVER
"localhost"
#define MYSQL_READ_SERVER
"localhost"
and blah balh
-- Best Regs,Masood Ahmad ShahSystem
Administrator^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^
^| * * * * * * * * * * * * * * * * * * * * * * *
*| Fibre Net (Pvt) Ltd. Lahore, Pakistan|
Tel: +92-42-6677024| Mobile:
+92-300-4277367| http://www.fibre.net.pk|
* * * * * * * * * * * * * * * * * * * * * * * *^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^
^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^Unix is very simple, but it takes a genius to
understand the simplicity.(Dennis Ritchie)
- Original Message -
From:
Kuan
Yik
To: [EMAIL PROTECTED]
Sent: Friday, July 11, 2003 6:16
AM
Subject: [vchkpw] vpopmail + mysql :
Define other mysql host in vmysql.h how-to?
Hi guys, anyone of you have any idea how to
defind the parameter of mysql host in vmysql.h file if I want to point it
to different port and host instead of "localhost".
Please advise and thank you very
much.
Regards,
Max
Re: [vchkpw] vpopmail + mysql : Define other mysql host in vmysql.h how-to?
Thanks to u first Ahmad.
I don't think I willchange the port number in
the /etc/service. Because, sometime I need to configure mysql running on a
system with two different port for two different usage/user. So, like PHP and
Perl, the parameter will be define as localhost:/usr/local/mysql.sock or
something like "localhost:"
Sorry for my poor explanation and hope that you can
understand wat I need.
- Original Message -
From:
Ahmad Masood
Shah
To: Kuan Yik ; [EMAIL PROTECTED]
Sent: Friday, July 11, 2003 3:21 PM
Subject: Re: [vchkpw] vpopmail + mysql :
Define other mysql host in vmysql.h how-to?
hmm have u changed /etc/service mysql
it can be handy ... me is kinda busy let me find
where you can put port in vmyslq.h or you will have to change some code in
this file...give me time I will do for u...
-- Best Regs,Masood Ahmad ShahSystem
Administrator^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^
^| * * * * * * * * * * * * * * * * * * * * * * *
*| Fibre Net (Pvt) Ltd. Lahore, Pakistan| Tel:
+92-42-6677024| Mobile: +92-300-4277367| http://www.fibre.net.pk| *
* * * * * * * * * * * * * * * * * * * * * * *^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^
^ ^ ^ ^ ^ ^ ^ ^ ^ ^Unix is very simple, but it takes a genius to
understand the simplicity.(Dennis Ritchie)
- Original Message -
From:
Kuan
Yik
To: Ahmad Masood Shah ; [EMAIL PROTECTED]
Sent: Friday, July 11, 2003 11:42
AM
Subject: Re: [vchkpw] vpopmail + mysql
: Define other mysql host in vmysql.h how-to?
Hi Ahmad, thanks for your reply, but what if I
want to define different port number or sock file?
It is not working if I define like
#define MYSQL_UPDATE_SERVER
"localhost:"
#define MYSQL_READ_SERVER
"localhost:"
OR
#define MYSQL_UPDATE_SERVER
"/usr/local/mysq/mysql.sock"
#define MYSQL_READ_SERVER
"/usr/local/mysql/mysql.sock"
Any idea how ?
thanks
- Original Message -
From:
Ahmad
Masood Shah
To: Kuan Yik ; [EMAIL PROTECTED]
Sent: Friday, July 11, 2003 2:25
PM
Subject: Re: [vchkpw] vpopmail +
mysql : Define other mysql host in vmysql.h how-to?
simple is that open you command
prompt
vi vmysql.h
you will find 2 lines like shown
below...
#define MYSQL_UPDATE_SERVER
"localhost"
#define MYSQL_READ_SERVER
"localhost"
and blah balh
-- Best Regs,Masood Ahmad ShahSystem
Administrator^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^
^| * * * * * * * * * * * * * * * * * * * * * * *
*| Fibre Net (Pvt) Ltd. Lahore, Pakistan|
Tel: +92-42-6677024| Mobile:
+92-300-4277367| http://www.fibre.net.pk|
* * * * * * * * * * * * * * * * * * * * * * * *^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^
^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^Unix is very simple, but it takes a genius to
understand the simplicity.(Dennis Ritchie)
- Original Message -
From:
Kuan Yik
To: [EMAIL PROTECTED]
Sent: Friday, July 11, 2003 6:16
AM
Subject: [vchkpw] vpopmail + mysql
: Define other mysql host in vmysql.h how-to?
Hi guys, anyone of you have any idea how to
defind the parameter of mysql host in vmysql.h file if I want to point
it to different port and host instead of "localhost".
Please advise and thank you very
much.
Regards,
Max
Re: [vchkpw] vpopmail+mysql config
Hi Ajai, Im looking thru vmysql.h and was wondering if it was OK to use a different login name instead of root for MySQL? sure, just make certain that this user have the appropriate permissions to create/modifiy/access data, something like: GRANT select,insert,update,delete,create,drop ON your_vpopmail_db.* TO [EMAIL PROTECTED] IDENTIFIED BY 'your_pass'; Regards, -- Dorneles Treméa Caxias do Sul - RS - Brasil +55 54 9114 9312 - UIN: 2413568 X3ng Web Technology http://www.x3ng.com.br -BEGIN GEEK CODE BLOCK- Version: 3.12 GCS/IT d- s:-: a23 C+++ UBL$ P--- L++ E-- W+++ N++ o? K? w+ O M+ V-- PS+ PE- Y-- PGP++ t+ 5 X++ R+ tv+ b(++) DI+ D++ G e++ h r+++ y+++** --END GEEK CODE BLOCK-- pgp0.pgp Description: PGP signature
RE: [vchkpw] vpopmail mysql registration trouble
Perhaps compare your config to my vpopmail w/mysql guide at http://www.pipeline.com.au/staff/mbowe/isp/vpopmail-mysql.htm Michael. -Original Message- From: miks [mailto:[EMAIL PROTECTED] Sent: Wednesday, 12 March 2003 8:57 AM To: [EMAIL PROTECTED] Subject: [vchkpw] vpopmail mysql registration trouble I have FreeBSD 5.0, qmail, mysql, vpopmail. My problem is: /skynet# ./vdominfo /domain: section-1.org /uid:89 /gid:89 /dir:/var/vpopmail/domains/section-1.org /could not connect to mysql update server Access denied for /user: '[EMAIL PROTECTED]' (Using password: YES) with database /could not connect to mysql update server Access denied for /user: '[EMAIL PROTECTED]' (Using password: YES) /users: 0 /vmysql: sql error[c]: MySQL server has gone away /vmysql: sql error[b]: MySQL server has gone away --- there is - '[EMAIL PROTECTED]' but why? I changed vmysql.h file with my name: vpopmail my password. please HELP ME.
Re: [vchkpw] vpopmail mysql registration trouble
Not to ask a stupid question, but did you do this before or after compiling? Also it looks like this is only a problem logging into the update server, make sure you edited that field as well. -John - Original Message - From: miks [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 1:57 PM Subject: [vchkpw] vpopmail mysql registration trouble I have FreeBSD 5.0, qmail, mysql, vpopmail. My problem is: /skynet# ./vdominfo /domain: section-1.org /uid:89 /gid:89 /dir:/var/vpopmail/domains/section-1.org /could not connect to mysql update server Access denied for /user: '[EMAIL PROTECTED]' (Using password: YES) with database /could not connect to mysql update server Access denied for /user: '[EMAIL PROTECTED]' (Using password: YES) /users: 0 /vmysql: sql error[c]: MySQL server has gone away /vmysql: sql error[b]: MySQL server has gone away --- there is - '[EMAIL PROTECTED]' but why? I changed vmysql.h file with my name: vpopmail my password. please HELP ME.
Re: [vchkpw] vpopmail MySQL can't find limits for domain
Hello, ... manage Aliased to alias orphanag Aliased to alias warning Aliased to alias webmaste Aliased to alias Note users without last char. Also I don't know from where come these alias... :-) This continues a mystery to me... :-( Aham! I found it... :-) It's another Debian (qmail-src package) related issue: file '/var/qmail/users/assign' has all this entries. I just removed them, run '/var/qmail/bin/qmail-newu' to update '/var/qmail/users/cdb' and solve the problem... Regards, -- Dorneles Treméa Caxias do Sul - RS - Brasil +55 54 9114 9312 - UIN: 2413568 X3ng Web Technology http://www.x3ng.com.br -BEGIN GEEK CODE BLOCK- Version: 3.12 GCS/IT d- s:-: a23 C+++ UBL$ P--- L++ E-- W+++ N++ o? K? w+ O M+ V-- PS+ PE- Y-- PGP++ t+ 5 X++ R+ tv+ b(++) DI+ D++ G e++ h r+++ y+++** --END GEEK CODE BLOCK-- pgp0.pgp Description: PGP signature
Re: [vchkpw] vpopmail MySQL can't find limits for domain
Hi, I'm playing with this the whole day, but just discovered: Both qmailadmin than vqadmin web interfaces are working, I can log in, create new domains, add new users... The problem is with MUAs... I can send messages, but I can't get them... if I telnet port 110, and issue: user [EMAIL PROTECTED] pass thepassword retr 1 retr 2 quit I see the messages, but if I use Outlook Express, Mozilla Mail, it gives me timeout... and with IMP web mail I just see 2 lines with 'Subject: nosubject', 'Length: 0'... :-( Aham! I found the problem who is causing this... :-) Debian 'qmail-src' package already comes with some patches applied. The one who gives me all this headache is: = netscape-progress.patch It was adding message size before header 'Return-Path': xReturn-Path I don't know if this is the expected behavior to this path. Anyway it isn't important to me... :-) ... manage Aliased to alias orphanag Aliased to alias warning Aliased to alias webmaste Aliased to alias Note users without last char. Also I don't know from where come these alias... :-) This continues a mystery to me... :-( A last one: in qmail log, after delivery a message to a maildir, I have: timestamp delivery XX: success: vnysql:_can't_find_limits_for_domain_'test.com'/did_0+0+1/ Obviously, my 'limits' mysql table is empty. I have the feeling that this is the main reason of my problems... And this is what I will debug this night... :-) Regards, -- Dorneles Treméa Caxias do Sul - RS - Brasil +55 54 9114 9312 - UIN: 2413568 X3ng Web Technology http://www.x3ng.com.br -BEGIN GEEK CODE BLOCK- Version: 3.12 GCS/IT d- s:-: a23 C+++ UBL$ P--- L++ E-- W+++ N++ o? K? w+ O M+ V-- PS+ PE- Y-- PGP++ t+ 5 X++ R+ tv+ b(++) DI+ D++ G e++ h r+++ y+++** --END GEEK CODE BLOCK-- pgp0.pgp Description: PGP signature
Re: [vchkpw] vpopmail + mysql. Basic question.
using vadduser not only adds the row to the table, but creates the directory structure for vdelivermail to put mail into. It also encrypts the password field. So you should either use the vadduser program or the vpopmail vadduser() API routine. Brian Sorry for the basic question but i can't figure how they work together. If i add a vpopmail user ( ~vpopmail/bin/vadduser [EMAIL PROTECTED] ), it will saved in mysql db. All right. But if i add a mysql record will it added to vpopmail users? What's about fields like pw_passwd? Tnx in advance. -- cris
Re: [vchkpw] vpopmail + mysql. Basic question.
On Wednesday 26 February 2003 17:33, Brian Kolaci wrote: using vadduser not only adds the row to the table, but creates the directory structure for vdelivermail to put mail into. It also encrypts the password field. So you should either use the vadduser program or the vpopmail vadduser() API routine. well.. not really. vchkpw for example creates the maildir, if it's missing, and so does vdelivermail. so if you just want to _create_ users by adding them to the mysql table, this is just fine. just if you want to delete the users thas way, it will keep their Maildirs in place. -- Best Regards --- Justin Heesemannionium Technologies [EMAIL PROTECTED]www.ionium.org
Re: [vchkpw] vpopmail + mysql. Basic question.
On Wednesday 26 February 2003 22:29, Justin Heesemann wrote: On Wednesday 26 February 2003 17:33, Brian Kolaci wrote: using vadduser not only adds the row to the table, but creates the directory structure for vdelivermail to put mail into. It also encrypts the password field. So you should either use the vadduser program or the vpopmail vadduser() API routine. well.. not really. vchkpw for example creates the maildir, if it's missing, and so does vdelivermail. so if you just want to _create_ users by adding them to the mysql table, this is just fine. just if you want to delete the users thas way, it will keep their Maildirs in place. add: i don't know, when this was introduced.. i'm speaking of 5.3.18 here (but i think this was already in some earlier versions) -- Best Regards --- Justin Heesemannionium Technologies [EMAIL PROTECTED]www.ionium.org
Re: [vchkpw] vpopmail + mysql. Basic question.
On Wednesday 26 February 2003 17:33, Brian Kolaci wrote: using vadduser not only adds the row to the table, but creates the directory structure for vdelivermail to put mail into. It also encrypts the password field. So you should either use the vadduser program or the vpopmail vadduser() API routine. well.. not really. vchkpw for example creates the maildir, if it's missing, and so does vdelivermail. so if you just want to _create_ users by adding them to the mysql table, this is just fine. just if you want to delete the users thas way, it will keep their Maildirs in place. Didn't know the recovery code was there. That's great. I've had instances in my old version where it wouldn't deliver mail because the maildir was missing, but now that I think about it, I haven't seen that problem for awhile. Thanks, Brian
Re: [vchkpw] vpopmail + mysql + sqwebmail
on 12/22/02 9:07 PM, Hugo Escobar [EMAIL PROTECTED] wrote: On Mon, 2002-12-23 at 00:17, Kurt Bigler wrote: on 12/22/02 5:37 PM, Hugo Escobar [EMAIL PROTECTED] wrote: Hi list: Sorry if this is off-topic but the sqwebmail ml-manager seems to be discarding message postings. This is what I have so far: Vpopmail+mysql working fine. $ telnet mymailserver 110 always works for all the virtualdomains. When it comes to the SqWebMail part, everything compiles, installs, etc. but when I try to log in I get the following message: Internal error (module sqconfig.c, line 63) - contact system administrator I don't have the same version of sqwebmail as you, but it looks like this might be a problem opening the sqconfig file (whatever that is) for writing. The error is likely to be a failure at this point in the C code: f=fopen(p, w); if (!f) enomem(); enomem is a macro that generates the error message you see with the file name and line number. fopen is what is failing. So if you can figure out that that configuration file might be, I suppose it might be a permission problem with that file, the directory containing it, or the user/group that one of the sqwebmail applications is running under. Sorry can't look into this more right now - hoping that might give you a clue. Yes, indeed that file is one of the files that store session information related to the user. The name of the file is sqwebmail-ip and this is supposed to be created in the directory ~vpopmail/domains/virtualdomain/username/Maildir. The problem is that when the function gets called, the first parameter should be ~vpopmail/domains/virtualdomain/username/Maildir, but the function only receives ., in other words, sqwebmail is trying to create the file at the root directory. You mean the code is running cd'd to / so that . is / ? Conceivably some code is trying to generate a pathname and uses . instead when it gives up due to some error. Did you try running as root temporarily just to see if that helps? Unjustifiable hunch: maybe a chdir is failing. Maybe . is fine when the current directory is set right. So I guess I should dig deeper into the source code. Configuration information: vpopmail-5.2.1 mysql Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386) sqwebmail-3.4.0.20021212 relevant line in the /usr/local/share/sqwebmail/authdaemonrc: authmodulelist=authcustom authvchkpw authdaemond is running. Any ideas? Hugo
Re: [vchkpw] vpopmail + mysql + sqwebmail
On Mon, 2002-12-23 at 00:17, Kurt Bigler wrote: on 12/22/02 5:37 PM, Hugo Escobar [EMAIL PROTECTED] wrote: Hi list: Sorry if this is off-topic but the sqwebmail ml-manager seems to be discarding message postings. This is what I have so far: Vpopmail+mysql working fine. $ telnet mymailserver 110 always works for all the virtualdomains. When it comes to the SqWebMail part, everything compiles, installs, etc. but when I try to log in I get the following message: Internal error (module sqconfig.c, line 63) - contact system administrator I don't have the same version of sqwebmail as you, but it looks like this might be a problem opening the sqconfig file (whatever that is) for writing. The error is likely to be a failure at this point in the C code: f=fopen(p, w); if (!f) enomem(); enomem is a macro that generates the error message you see with the file name and line number. fopen is what is failing. So if you can figure out that that configuration file might be, I suppose it might be a permission problem with that file, the directory containing it, or the user/group that one of the sqwebmail applications is running under. Sorry can't look into this more right now - hoping that might give you a clue. Yes, indeed that file is one of the files that store session information related to the user. The name of the file is sqwebmail-ip and this is supposed to be created in the directory ~vpopmail/domains/virtualdomain/username/Maildir. The problem is that when the function gets called, the first parameter should be ~vpopmail/domains/virtualdomain/username/Maildir, but the function only receives ., in other words, sqwebmail is trying to create the file at the root directory. So I guess I should dig deeper into the source code. Configuration information: vpopmail-5.2.1 mysql Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386) sqwebmail-3.4.0.20021212 relevant line in the /usr/local/share/sqwebmail/authdaemonrc: authmodulelist=authcustom authvchkpw authdaemond is running. Any ideas? Hugo
Re: [vchkpw] vpopmail + mysql + sqwebmail
on 12/22/02 5:37 PM, Hugo Escobar [EMAIL PROTECTED] wrote: authdaemond is running. Any ideas? One thing comes to mind... I did not look at your specific problem, but in everything I've seen when using sqwebmail with vpopmail says you should NOT use authdaemon. I've seen numerous problems from people who are doing it, and always the solution is to re-compile sqwebmail with: --with-authvchkpw --without-authdaemon Kill off the troublesome daemon, and use vchkpw authentication only. Rick
Re: [vchkpw] vpopmail+mysql + changing mysql servers
This could be from a number of problems, but most likely, the MySQL version has changed between boxes, or mysql is in a different place on the machine. vpopmail takes the mysql include and lib files and compiles them into the vpopmail binaries. Changing versions may require recompiling vpopmail. Other issues could be: connectivity - can the vpopmail user log into mysql? Is the username and password correct? Does the mysql user physically have access to the port? DNS - is the new machine properly set up? Do you get any errors? They would be helpful. On Monday 16 December 2002 04:59, Kent Ritchie wrote: I might be stupid to ask this, but I have looked online and in documentation, so I decided to ask here. I have a qmail+vpopmail setup, that authenticates through a remote mysql server. When I take the mysql server down and replace it with a different box, thats has all the data, users, grants etc on it that the previous box had, it no longer authenticates. I replace the old box, and it once again works... So, has anyone here ever made replacement like I am trying and failing to do?
Re: [vchkpw] Vpopmail + Mysql. Tables not created?
The ./configure options for vpopmail are as follow.. ./configure --enable-roaming-users=y --enable-logging=y \ --enable-defaultquota=150 --enable-ip-alias-domains=y \ --enable-mysql=y --enable-sqllibdir=/usr/local/lib/mysql/ \ --enable-sqlincdir=/usr/local/include/mysql/ - Original Message - From: Clayton Weise [EMAIL PROTECTED] To: Gerald [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 1:45 AM Subject: RE: [vchkpw] Vpopmail + Mysql. Tables not created? Please paste your ./configure line for vpopmail. -Original Message- From: Gerald [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 10:32 AM To: [EMAIL PROTECTED] Subject: [vchkpw] Vpopmail + Mysql. Tables not created? Hi there I've compiled support for mysql in qmail and vpopmail. I've read README.mysql and went thru the guide at (http://matt.simerson.net/computing/qmail.toaster.shtml) However, when I add a virtual domain, a mysql table wasn't created, and instead, a .cdb file was produced. Why is that so? Programs which are installed on my system: qmail-1.03 vpopmail-5.2.1 mysql-server-3.23.52_1 FreeBSD 4.7-RC Help would be greatly appreciated, Thanks Gerald
Re: [vchkpw] Vpopmail + Mysql. Tables not created?
Hi Gerald, Just a couple of observations - maybe it will help... Your configure line says --enable-sqllibdir=... and --enable-sqlincdir= I don't see those as available configure options when I do ./configure --help in vpopmail5.2.1. I see --enable-libdir; --enable-incdir; and --enable-libs. That may be part of the problem. Also, I've found when I've compiled it on Redhat7.1 I had to truncate the path to the mysql libraries prior to /mysql. I don't know if that would work the same way in BSD. What I mean is my mysql libraries are in /usr/lib/mysql - but when I configured with --enable-libdir=/usr/lib/mysql ; it didn't work - but when I configured with --enable-libdir=/usr/lib ; it worked like a charm. Hope that helps a bit, Regis On Wed, 2002-09-25 at 02:29, Gerald wrote: The ./configure options for vpopmail are as follow.. ./configure --enable-roaming-users=y --enable-logging=y \ --enable-defaultquota=150 --enable-ip-alias-domains=y \ --enable-mysql=y --enable-sqllibdir=/usr/local/lib/mysql/ \ --enable-sqlincdir=/usr/local/include/mysql/ - Original Message - From: Clayton Weise [EMAIL PROTECTED] To: Gerald [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 1:45 AM Subject: RE: [vchkpw] Vpopmail + Mysql. Tables not created? Please paste your ./configure line for vpopmail. -Original Message- From: Gerald [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 10:32 AM To: [EMAIL PROTECTED] Subject: [vchkpw] Vpopmail + Mysql. Tables not created? Hi there I've compiled support for mysql in qmail and vpopmail. I've read README.mysql and went thru the guide at (http://matt.simerson.net/computing/qmail.toaster.shtml) However, when I add a virtual domain, a mysql table wasn't created, and instead, a .cdb file was produced. Why is that so? Programs which are installed on my system: qmail-1.03 vpopmail-5.2.1 mysql-server-3.23.52_1 FreeBSD 4.7-RC Help would be greatly appreciated, Thanks Gerald
RE: [vchkpw] Vpopmail + Mysql. Tables not created?
Please paste your ./configure line for vpopmail. -Original Message- From: Gerald [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 10:32 AM To: [EMAIL PROTECTED] Subject: [vchkpw] Vpopmail + Mysql. Tables not created? Hi there I've compiled support for mysql in qmail and vpopmail. I've read README.mysql and went thru the guide at (http://matt.simerson.net/computing/qmail.toaster.shtml) However, when I add a virtual domain, a mysql table wasn't created, and instead, a .cdb file was produced. Why is that so? Programs which are installed on my system: qmail-1.03 vpopmail-5.2.1 mysql-server-3.23.52_1 FreeBSD 4.7-RC Help would be greatly appreciated, Thanks Gerald
Re: [vchkpw] Vpopmail + Mysql. Tables not created?
I have a quick vpopmail + mysql guide available at http://www.pipeline.com.au/staff/mbowe/isp/vpopmail-mysql.htm Maybe take a look there to see if it gives you any clues as to what went wrong with your install Michael. - Original Message - From: Gerald [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 3:31 AM Subject: [vchkpw] Vpopmail + Mysql. Tables not created? Hi there I've compiled support for mysql in qmail and vpopmail. I've read README.mysql and went thru the guide at (http://matt.simerson.net/computing/qmail.toaster.shtml) However, when I add a virtual domain, a mysql table wasn't created, and instead, a .cdb file was produced. Why is that so? Programs which are installed on my system: qmail-1.03 vpopmail-5.2.1 mysql-server-3.23.52_1 FreeBSD 4.7-RC Help would be greatly appreciated, Thanks Gerald
