RE: [vchkpw] MySQL has gone away
Well guys, Ive made progress on this. If I change the IP to my external IP rather than localhost it works. So apparently, its looking for the socket in the wrong place. Where does it pull the path of the socket from? Thanks, Chris Miller Compuville www.compuville.net From: Chris Miller [mailto:[EMAIL PROTECTED] Sent: Saturday, March 27, 2004 2:15 PM To: [EMAIL PROTECTED] Subject: RE: [vchkpw] MySQL has gone away I am using 5.4.0, which is the latest version. I was using an older version before, but I ditched it and am reinstalling it. Thanks, Chris Miller Compuville www.compuville.net From: Remo Mattei [mailto:[EMAIL PROTECTED] Sent: Saturday, March 27, 2004 2:13 PM To: [EMAIL PROTECTED] Subject: RE: [vchkpw] MySQL has gone away The version of vpopmail you are using is not using the file for password you need to modify the vmysql.c or .h I cant remember which one so make sure either you are using the latest version or modify that file and then recompile.. Remo Mattei NetworkSecurity Engineer cell 801-808-unix email [EMAIL PROTECTED] From: Chris Miller [mailto:[EMAIL PROTECTED] Sent: Saturday, March 27, 2004 12:03 PM To: [EMAIL PROTECTED] Subject: [vchkpw] MySQL has gone away Heres what I get when I try to add a domain: [/var/vpopmail/bin]# ./vadddomain test.com Please enter password for postmaster: enter password again: vmysql: sql error[c]: MySQL server has gone away vmysql: sql error[b]: MySQL server has gone away vmysql: sql error[3]: MySQL server has gone away vmysql: sql error[c]: MySQL server has gone away vmysql: sql error[c]: MySQL server has gone away vmysql: sql error[b]: MySQL server has gone away vmysql: sql error[3]: MySQL server has gone away vmysql: sql error[2]: MySQL server has gone away Failed while attempting to add user to auth backend Error: (vadduser) no auth connection [/var/vpopmail/etc]# cat vpopmail.mysql localhost|0|vpopmail|***|vpopmail My password has odd characters in it, specifically the + character. Could that cause anything to break? I have tried connecting manually with the username/password in that file, and I can get in fine. Thanks, Chris Miller Compuville www.compuville.net
RE: [vchkpw] MySQL has gone away
The version of vpopmail you are using is not using the file for password you need to modify the vmysql.c or .h I cant remember which one so make sure either you are using the latest version or modify that file and then recompile.. Remo Mattei NetworkSecurity Engineer cell 801-808-unix email [EMAIL PROTECTED] From: Chris Miller [mailto:[EMAIL PROTECTED] Sent: Saturday, March 27, 2004 12:03 PM To: [EMAIL PROTECTED] Subject: [vchkpw] MySQL has gone away Heres what I get when I try to add a domain: [/var/vpopmail/bin]# ./vadddomain test.com Please enter password for postmaster: enter password again: vmysql: sql error[c]: MySQL server has gone away vmysql: sql error[b]: MySQL server has gone away vmysql: sql error[3]: MySQL server has gone away vmysql: sql error[c]: MySQL server has gone away vmysql: sql error[c]: MySQL server has gone away vmysql: sql error[b]: MySQL server has gone away vmysql: sql error[3]: MySQL server has gone away vmysql: sql error[2]: MySQL server has gone away Failed while attempting to add user to auth backend Error: (vadduser) no auth connection [/var/vpopmail/etc]# cat vpopmail.mysql localhost|0|vpopmail|***|vpopmail My password has odd characters in it, specifically the + character. Could that cause anything to break? I have tried connecting manually with the username/password in that file, and I can get in fine. Thanks, Chris Miller Compuville www.compuville.net
RE: [vchkpw] MySQL has gone away
I am using 5.4.0, which is the latest version. I was using an older version before, but I ditched it and am reinstalling it. Thanks, Chris Miller Compuville www.compuville.net From: Remo Mattei [mailto:[EMAIL PROTECTED] Sent: Saturday, March 27, 2004 2:13 PM To: [EMAIL PROTECTED] Subject: RE: [vchkpw] MySQL has gone away The version of vpopmail you are using is not using the file for password you need to modify the vmysql.c or .h I cant remember which one so make sure either you are using the latest version or modify that file and then recompile.. Remo Mattei NetworkSecurity Engineer cell 801-808-unix email [EMAIL PROTECTED] From: Chris Miller [mailto:[EMAIL PROTECTED] Sent: Saturday, March 27, 2004 12:03 PM To: [EMAIL PROTECTED] Subject: [vchkpw] MySQL has gone away Heres what I get when I try to add a domain: [/var/vpopmail/bin]# ./vadddomain test.com Please enter password for postmaster: enter password again: vmysql: sql error[c]: MySQL server has gone away vmysql: sql error[b]: MySQL server has gone away vmysql: sql error[3]: MySQL server has gone away vmysql: sql error[c]: MySQL server has gone away vmysql: sql error[c]: MySQL server has gone away vmysql: sql error[b]: MySQL server has gone away vmysql: sql error[3]: MySQL server has gone away vmysql: sql error[2]: MySQL server has gone away Failed while attempting to add user to auth backend Error: (vadduser) no auth connection [/var/vpopmail/etc]# cat vpopmail.mysql localhost|0|vpopmail|***|vpopmail My password has odd characters in it, specifically the + character. Could that cause anything to break? I have tried connecting manually with the username/password in that file, and I can get in fine. Thanks, Chris Miller Compuville www.compuville.net
RE: [vchkpw] MySQL has gone away
Somehow, the subject of this conversation has gotten changed the original subject was MySQL has gone away. Please make sure all future messages related to this problem have this subject, NOT SMTP AUTH as that is a different problem. Thanks, Chris Miller Compuville www.compuville.net -Original Message- From: Chris Miller [mailto:[EMAIL PROTECTED] Sent: Saturday, March 27, 2004 8:39 PM To: [EMAIL PROTECTED] Subject: RE: [vchkpw] SMTP AUTH Well, my connection file is correct. So why is it still saying MySQL Server has gone away? Thanks, Chris Miller Compuville www.compuville.net -Original Message- From: Michael Bowe [mailto:[EMAIL PROTECTED] Sent: Saturday, March 27, 2004 6:28 PM To: [EMAIL PROTECTED] Subject: Re: [vchkpw] SMTP AUTH It is my understanding that : MYSQL CONNECTION SETTINGS FOR VPOPMAIL Line 1 defines the connection to use for database reads, Line 2 defines the connection to use for database updates/writes. If you omit line 2, then the same settings will be used for both read and write. settings for each line: host|port|user|password|database eg localhost|0|root|secret|vpopmail Note: The value of host may be either a hostname or an IP address. If host is 'localhost', then sockets (Unix) or named pipes (Windows) will be used instead of TCP/IP to connect to the server. Michael. - Original Message - From: Chris Miller [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, March 28, 2004 5:43 AM Subject: RE: [vchkpw] SMTP AUTH Nope, Same problem. Is there any way to have it use a socket at '/var/run/mysqld/mysqld.sock' instead of over TCP/IP? Thanks, Chris Miller Compuville www.compuville.net -Original Message- From: Shane Chrisp [mailto:[EMAIL PROTECTED] Sent: Saturday, March 27, 2004 2:31 PM To: [EMAIL PROTECTED] Subject: RE: [vchkpw] SMTP AUTH try changing the 0 in the file to 3306 like localhost|3306|vpopmail|pass|vpopmail Shouldn't have any effect but who knows. I have also had issues where ive needed to connect to the ip of the machine rather than localhost due to a few crazy mysql dns bugs. Adding the details to the hosts file sometimes fixes that one too. Shane -Original Message- From: Chris Miller [mailto:[EMAIL PROTECTED] Sent: Sunday, 28 March 2004 3:24 AM To: [EMAIL PROTECTED] Subject: RE: [vchkpw] SMTP AUTH Nope, same error... -rw-r-1 vpopmail vchkpw 41 Mar 27 14:24 vpopmail.mysql Thanks, Chris Miller Compuville www.compuville.net -Original Message- From: Shane Chrisp [mailto:[EMAIL PROTECTED] Sent: Saturday, March 27, 2004 2:19 PM To: [EMAIL PROTECTED] Subject: RE: [vchkpw] SMTP AUTH does mysql -D vpopmail -user=vpopmail --password=pass get you in as well? Im guessing you might need to escape the \+ sign or your permissions on the vpopmail.mysql file are wrong. -rw-r-1 vpopmail vchkpw235 Sep 4 2003 vpopmail.mysql Shane. -Original Message- From: Chris Miller [mailto:[EMAIL PROTECTED] Sent: Sunday, 28 March 2004 3:04 AM To: [EMAIL PROTECTED] Subject: RE: [vchkpw] SMTP AUTH Is it safe to use 0.31 with vpopmail-5.4.0? Thanks, Chris Miller Compuville www.compuville.net -Original Message- From: Erwin Hoffmann [mailto:[EMAIL PROTECTED] Sent: Monday, March 22, 2004 12:12 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [vchkpw] SMTP AUTH Hi, dont use the version 0.32 of the smtp-auth patch; it's not gonna work with vpopmail 5.4.x. Read: http://www.fehcom.de/qmail/smtpauth.html regards. --eh. At 14:38 22.03.04 +0100, [EMAIL PROTECTED] wrote: Am Mo, 2004-03-22 um 14.30 schrieb Chris Miller: Does vpopmail come with SMTP AUTH? Is there a compatable patch out there? Try this one: qmail-smtpd-auth, http://members.elysium.pl/brush/qmail-smtpd-auth/, Gruss, Peter. -- [EMAIL PROTECTED], gpg -key http://blackhole.pca.dfn.de:11371/pks/lookup?op=getsearch=0x690A1AC2 Dr. Erwin Hoffmann | FEHCom | http://www.fehcom.de/ Wiener Weg 8, 50858 Cologne | T: +49 221 484 4923 | F: ...24
Re: [vchkpw] MySQL has gone away error .. UPDATE.
At 01:13 AM 18/08/2003 -0400, you wrote: Scratch this and chuck it into the up-too-late file. It was a typo when I created the MySQL user. D'oh. Wonderful. Now my mistake will be eternal, for posterity, on Google. ;) -- Steve Hi all, To those that remember me, long time no see. Nice to be back. Or more accurately, nice to be paid what I enjoy doing, again. I've installed vchkpw on a fresh RH 7.3 box and I've run into the error in the subject line. I'm using an RPM install of MySQL 4 (server, development, client etc etc). Here's an example of the error: vmysql: sql error[9]: MySQL server has gone away I've reviewed the list and Google'd to no avail. A vpopmail DB and user/pass has been created. The info was manually inputted into the vmysql.h file. It compiled fine, yet I still get this error. I tried changing the MySQL socket from /var/lib/mysql/mysql.sock to /tmp/mysql.sock to no avail. Any other suggestions? -- Steve