RE: [vchkpw] vpopmail and mysql problem
you use mysql 4.1, have you enabled use old passwords? maybe its that. regards, ingo -Mensaje original- De: Wes Hegge [mailto:[EMAIL PROTECTED] Enviado el: Lunes, 03 de Octubre de 2005 20:45 Para: vchkpw@inter7.com Asunto: Re: [vchkpw] vpopmail and mysql problem On Mon, 2005-10-03 at 20:02 -0400, Rick Macdougall wrote: Wes Hegge wrote: On Mon, 2005-10-03 at 12:22 -0500, Ken Jones wrote: Wes Hegge wrote: Hello everyone, Hopefully someone can help me with this problem I am having. I spent all day yesterday looking for an answer. I found some that were close but still no luck. Here is the error I am getting: vmysql: error creating table 'dir_control': MySQL server has gone away vmysql: sql error[b]: MySQL server has gone away vmysql: error creating table 'signalblast_com': MySQL server has gone away Error. Failed while attempting to add domain to auth backend vmysql: error creating table 'dir_control': MySQL server has gone away vmysql: error creating table 'dir_control': MySQL server has gone away vmysql: sql error[b]: MySQL server has gone away vmysql: error creating table 'dir_control': MySQL server has gone away vmysql: sql error[e]: MySQL server has gone away Warning: Failed to delete dir_control for signalblast.com Error: no auth connection I am installing this on a Debian Sarge install: Linux version 2.4.27-2-386 ([EMAIL PROTECTED]) (gcc version 3.3.5 (Debian 1:3.3.5-12)) #1 Mon May 16 16:47:51 JST 2005 I have installed mysql-standard-4.1.14-pc-linux-gnu-i686 and then made a symbolic link for mysql pointing to the above directory. Qmail, daemontools, and tcuspi is installed. Here is my vpopmail.mysql: localhost|0|vpopmailuser|vpoppasswd|vpopmail I can connect and make a test table using the above user and password. I cannot figure out what the problem is. Any help would be greatly appreciated. make sure the vpopmailuser has permission to create tables in the vpopmail database. Ken Jones I have checked this. I mentioned this just above, by creating a test table. Is qmail-smtpd running as the vpopmail user ? Does it have the permissions to read the vpopmail.mysql file in vpopmail/etc ? Sorry, did not get this before your other email. But as I have said, qmail-smtpd is not part of the problem at this time. But just to be sure I 'chmod 644 vpopmail.mysql'. Still the same problem. Regards, Rick -- Wes Hegge Technical Engineer SignalBlast.Com, Inc. p: (815) 397-1700 e: [EMAIL PROTECTED]
[vchkpw] vpopmail and mysql problem
Hello everyone, Hopefully someone can help me with this problem I am having. I spent all day yesterday looking for an answer. I found some that were close but still no luck. Here is the error I am getting: vmysql: error creating table 'dir_control': MySQL server has gone away vmysql: sql error[b]: MySQL server has gone away vmysql: error creating table 'signalblast_com': MySQL server has gone away Error. Failed while attempting to add domain to auth backend vmysql: error creating table 'dir_control': MySQL server has gone away vmysql: error creating table 'dir_control': MySQL server has gone away vmysql: sql error[b]: MySQL server has gone away vmysql: error creating table 'dir_control': MySQL server has gone away vmysql: sql error[e]: MySQL server has gone away Warning: Failed to delete dir_control for signalblast.com Error: no auth connection I am installing this on a Debian Sarge install: Linux version 2.4.27-2-386 ([EMAIL PROTECTED]) (gcc version 3.3.5 (Debian 1:3.3.5-12)) #1 Mon May 16 16:47:51 JST 2005 I have installed mysql-standard-4.1.14-pc-linux-gnu-i686 and then made a symbolic link for mysql pointing to the above directory. Qmail, daemontools, and tcuspi is installed. Here is my vpopmail.mysql: localhost|0|vpopmailuser|vpoppasswd|vpopmail I can connect and make a test table using the above user and password. I cannot figure out what the problem is. Any help would be greatly appreciated. -- Wes Hegge Technical Engineer SignalBlast.Com, Inc. p: (815) 397-1700 e: [EMAIL PROTECTED]
Re: [vchkpw] vpopmail and mysql problem
Hi, increase the max_connections = 250 variable in my.cnf. I had the same problem and this worked for me. regards, srosa Wes Hegge wrote: Hello everyone, Hopefully someone can help me with this problem I am having. I spent all day yesterday looking for an answer. I found some that were close but still no luck. Here is the error I am getting: vmysql: error creating table 'dir_control': MySQL server has gone away vmysql: sql error[b]: MySQL server has gone away vmysql: error creating table 'signalblast_com': MySQL server has gone away Error. Failed while attempting to add domain to auth backend vmysql: error creating table 'dir_control': MySQL server has gone away vmysql: error creating table 'dir_control': MySQL server has gone away vmysql: sql error[b]: MySQL server has gone away vmysql: error creating table 'dir_control': MySQL server has gone away vmysql: sql error[e]: MySQL server has gone away Warning: Failed to delete dir_control for signalblast.com Error: no auth connection I am installing this on a Debian Sarge install: Linux version 2.4.27-2-386 ([EMAIL PROTECTED]) (gcc version 3.3.5 (Debian 1:3.3.5-12)) #1 Mon May 16 16:47:51 JST 2005 I have installed mysql-standard-4.1.14-pc-linux-gnu-i686 and then made a symbolic link for mysql pointing to the above directory. Qmail, daemontools, and tcuspi is installed. Here is my vpopmail.mysql: localhost|0|vpopmailuser|vpoppasswd|vpopmail I can connect and make a test table using the above user and password. I cannot figure out what the problem is. Any help would be greatly appreciated. begin:vcard fn;quoted-printable:S=C3=A9rgio Manuel Rosa n;quoted-printable:Rosa;S=C3=A9rgio Manuel org;quoted-printable:Dotwebon - Servi=C3=A7os de Internet, Lda;Internet Services adr;quoted-printable:;;Rua Francisco Tom=C3=A1s da Costa, 51-A;Lisboa;Lisboa;1600-092;Portugal email;internet:[EMAIL PROTECTED] title:Consultant tel;work:+351 21 793 50 28 tel;fax:+351 21 781 77 49 tel;cell:+351 91 618 42 75 x-mozilla-html:TRUE url:http://www.dotwebon.pt version:2.1 end:vcard
Re: [vchkpw] vpopmail and mysql problem
Wes Hegge wrote: Hello everyone, Hopefully someone can help me with this problem I am having. I spent all day yesterday looking for an answer. I found some that were close but still no luck. Here is the error I am getting: vmysql: error creating table 'dir_control': MySQL server has gone away vmysql: sql error[b]: MySQL server has gone away vmysql: error creating table 'signalblast_com': MySQL server has gone away Error. Failed while attempting to add domain to auth backend vmysql: error creating table 'dir_control': MySQL server has gone away vmysql: error creating table 'dir_control': MySQL server has gone away vmysql: sql error[b]: MySQL server has gone away vmysql: error creating table 'dir_control': MySQL server has gone away vmysql: sql error[e]: MySQL server has gone away Warning: Failed to delete dir_control for signalblast.com Error: no auth connection I am installing this on a Debian Sarge install: Linux version 2.4.27-2-386 ([EMAIL PROTECTED]) (gcc version 3.3.5 (Debian 1:3.3.5-12)) #1 Mon May 16 16:47:51 JST 2005 I have installed mysql-standard-4.1.14-pc-linux-gnu-i686 and then made a symbolic link for mysql pointing to the above directory. Qmail, daemontools, and tcuspi is installed. Here is my vpopmail.mysql: localhost|0|vpopmailuser|vpoppasswd|vpopmail I can connect and make a test table using the above user and password. I cannot figure out what the problem is. Any help would be greatly appreciated. make sure the vpopmailuser has permission to create tables in the vpopmail database. Ken Jones
Re: [vchkpw] vpopmail and mysql problem
On Mon, 2005-10-03 at 12:22 -0500, Ken Jones wrote: Wes Hegge wrote: Hello everyone, Hopefully someone can help me with this problem I am having. I spent all day yesterday looking for an answer. I found some that were close but still no luck. Here is the error I am getting: vmysql: error creating table 'dir_control': MySQL server has gone away vmysql: sql error[b]: MySQL server has gone away vmysql: error creating table 'signalblast_com': MySQL server has gone away Error. Failed while attempting to add domain to auth backend vmysql: error creating table 'dir_control': MySQL server has gone away vmysql: error creating table 'dir_control': MySQL server has gone away vmysql: sql error[b]: MySQL server has gone away vmysql: error creating table 'dir_control': MySQL server has gone away vmysql: sql error[e]: MySQL server has gone away Warning: Failed to delete dir_control for signalblast.com Error: no auth connection I am installing this on a Debian Sarge install: Linux version 2.4.27-2-386 ([EMAIL PROTECTED]) (gcc version 3.3.5 (Debian 1:3.3.5-12)) #1 Mon May 16 16:47:51 JST 2005 I have installed mysql-standard-4.1.14-pc-linux-gnu-i686 and then made a symbolic link for mysql pointing to the above directory. Qmail, daemontools, and tcuspi is installed. Here is my vpopmail.mysql: localhost|0|vpopmailuser|vpoppasswd|vpopmail I can connect and make a test table using the above user and password. I cannot figure out what the problem is. Any help would be greatly appreciated. make sure the vpopmailuser has permission to create tables in the vpopmail database. Ken Jones I have checked this. I mentioned this just above, by creating a test table. -- Wes Hegge Technical Engineer SignalBlast.Com, Inc. p: (815) 397-1700 e: [EMAIL PROTECTED]
Re: [vchkpw] vpopmail and mysql problem
Wes Hegge wrote: On Mon, 2005-10-03 at 12:22 -0500, Ken Jones wrote: Wes Hegge wrote: Hello everyone, Hopefully someone can help me with this problem I am having. I spent all day yesterday looking for an answer. I found some that were close but still no luck. Here is the error I am getting: vmysql: error creating table 'dir_control': MySQL server has gone away vmysql: sql error[b]: MySQL server has gone away vmysql: error creating table 'signalblast_com': MySQL server has gone away Error. Failed while attempting to add domain to auth backend vmysql: error creating table 'dir_control': MySQL server has gone away vmysql: error creating table 'dir_control': MySQL server has gone away vmysql: sql error[b]: MySQL server has gone away vmysql: error creating table 'dir_control': MySQL server has gone away vmysql: sql error[e]: MySQL server has gone away Warning: Failed to delete dir_control for signalblast.com Error: no auth connection I am installing this on a Debian Sarge install: Linux version 2.4.27-2-386 ([EMAIL PROTECTED]) (gcc version 3.3.5 (Debian 1:3.3.5-12)) #1 Mon May 16 16:47:51 JST 2005 I have installed mysql-standard-4.1.14-pc-linux-gnu-i686 and then made a symbolic link for mysql pointing to the above directory. Qmail, daemontools, and tcuspi is installed. Here is my vpopmail.mysql: localhost|0|vpopmailuser|vpoppasswd|vpopmail I can connect and make a test table using the above user and password. I cannot figure out what the problem is. Any help would be greatly appreciated. make sure the vpopmailuser has permission to create tables in the vpopmail database. Ken Jones I have checked this. I mentioned this just above, by creating a test table. Is qmail-smtpd running as the vpopmail user ? Does it have the permissions to read the vpopmail.mysql file in vpopmail/etc ? Regards, Rick
Re: [vchkpw] vpopmail and mysql problem
I added this to my.cnf in the [mysqld] set-variable=max_connection=250 Did not work. Any ideas on debugging I can do? Is there anything for vpopmail? Thanks, Wes On Mon, 2005-10-03 at 18:17 +0100, Sergio Rosa wrote: Hi, increase the max_connections = 250 variable in my.cnf. I had the same problem and this worked for me. regards, srosa Wes Hegge wrote: Hello everyone, Hopefully someone can help me with this problem I am having. I spent all day yesterday looking for an answer. I found some that were close but still no luck. Here is the error I am getting: vmysql: error creating table 'dir_control': MySQL server has gone away vmysql: sql error[b]: MySQL server has gone away vmysql: error creating table 'signalblast_com': MySQL server has gone away Error. Failed while attempting to add domain to auth backend vmysql: error creating table 'dir_control': MySQL server has gone away vmysql: error creating table 'dir_control': MySQL server has gone away vmysql: sql error[b]: MySQL server has gone away vmysql: error creating table 'dir_control': MySQL server has gone away vmysql: sql error[e]: MySQL server has gone away Warning: Failed to delete dir_control for signalblast.com Error: no auth connection I am installing this on a Debian Sarge install: Linux version 2.4.27-2-386 ([EMAIL PROTECTED]) (gcc version 3.3.5 (Debian 1:3.3.5-12)) #1 Mon May 16 16:47:51 JST 2005 I have installed mysql-standard-4.1.14-pc-linux-gnu-i686 and then made a symbolic link for mysql pointing to the above directory. Qmail, daemontools, and tcuspi is installed. Here is my vpopmail.mysql: localhost|0|vpopmailuser|vpoppasswd|vpopmail I can connect and make a test table using the above user and password. I cannot figure out what the problem is. Any help would be greatly appreciated. -- Wes Hegge Technical Engineer SignalBlast.Com, Inc. p: (815) 397-1700 e: [EMAIL PROTECTED]
Re: [vchkpw] vpopmail and mysql problem
Wes Hegge wrote: I added this to my.cnf in the [mysqld] set-variable=max_connection=250 Did not work. Any ideas on debugging I can do? Is there anything for vpopmail? Hi, As stated earlier, it really sound like qmail-smtpd is running as qmail and not vpopmail. I think the qmail side of things can not read your vpopmail.mysql file. Regards, Rick
Re: [vchkpw] vpopmail and mysql problem
On Mon, 2005-10-03 at 20:13 -0400, Rick Macdougall wrote: Wes Hegge wrote: I added this to my.cnf in the [mysqld] set-variable=max_connection=250 Did not work. Any ideas on debugging I can do? Is there anything for vpopmail? Hi, As stated earlier, it really sound like qmail-smtpd is running as qmail and not vpopmail. I think the qmail side of things can not read your vpopmail.mysql file. What does qmail-smtpd have to do with vaddomain and the error I am getting? All I have tried to do so far is add a domain. Regards, Rick -- Wes Hegge Technical Engineer SignalBlast.Com, Inc. p: (815) 397-1700 e: [EMAIL PROTECTED]
Re: [vchkpw] vpopmail and mysql problem
On Mon, 2005-10-03 at 20:02 -0400, Rick Macdougall wrote: Wes Hegge wrote: On Mon, 2005-10-03 at 12:22 -0500, Ken Jones wrote: Wes Hegge wrote: Hello everyone, Hopefully someone can help me with this problem I am having. I spent all day yesterday looking for an answer. I found some that were close but still no luck. Here is the error I am getting: vmysql: error creating table 'dir_control': MySQL server has gone away vmysql: sql error[b]: MySQL server has gone away vmysql: error creating table 'signalblast_com': MySQL server has gone away Error. Failed while attempting to add domain to auth backend vmysql: error creating table 'dir_control': MySQL server has gone away vmysql: error creating table 'dir_control': MySQL server has gone away vmysql: sql error[b]: MySQL server has gone away vmysql: error creating table 'dir_control': MySQL server has gone away vmysql: sql error[e]: MySQL server has gone away Warning: Failed to delete dir_control for signalblast.com Error: no auth connection I am installing this on a Debian Sarge install: Linux version 2.4.27-2-386 ([EMAIL PROTECTED]) (gcc version 3.3.5 (Debian 1:3.3.5-12)) #1 Mon May 16 16:47:51 JST 2005 I have installed mysql-standard-4.1.14-pc-linux-gnu-i686 and then made a symbolic link for mysql pointing to the above directory. Qmail, daemontools, and tcuspi is installed. Here is my vpopmail.mysql: localhost|0|vpopmailuser|vpoppasswd|vpopmail I can connect and make a test table using the above user and password. I cannot figure out what the problem is. Any help would be greatly appreciated. make sure the vpopmailuser has permission to create tables in the vpopmail database. Ken Jones I have checked this. I mentioned this just above, by creating a test table. Is qmail-smtpd running as the vpopmail user ? Does it have the permissions to read the vpopmail.mysql file in vpopmail/etc ? Sorry, did not get this before your other email. But as I have said, qmail-smtpd is not part of the problem at this time. But just to be sure I 'chmod 644 vpopmail.mysql'. Still the same problem. Regards, Rick -- Wes Hegge Technical Engineer SignalBlast.Com, Inc. p: (815) 397-1700 e: [EMAIL PROTECTED]
[vchkpw] vpopmail with mysql problem
hi i am installing vpopmail-5.2.1 with mysql centralized database ports, I successfully compile everything but when adding the domain it give me error like that [EMAIL PROTECTED] vpopmail-5.2.1]# /home/vpopmail/bin/vadddomain example.com Please enter password for postmaster: enter password again: 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) 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 Error: Unable to chdir to vpopmail/users directory Is there anything wrong. Tx ZaFAr
Re: [vchkpw] vpopmail with mysql problem
hmmm you have not compiled vpopmail with user that can connect to mysql databases. I will suggest better to study FAQs and then create username and password in databases compile vpopmail with username that can create modify delete vpopmail database -- 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: zafar rizvi [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 18, 2003 12:20 PM Subject: [vchkpw] vpopmail with mysql problem | hi | i am installing vpopmail-5.2.1 with mysql centralized database ports, | I successfully compile everything but when adding the domain it give me | error like that | | [EMAIL PROTECTED] vpopmail-5.2.1]# /home/vpopmail/bin/vadddomain example.com | Please enter password for postmaster: | enter password again: | 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) | 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 | Error: Unable to chdir to vpopmail/users directory | | Is there anything wrong. | | Tx | ZaFAr | | |
Re: [vchkpw] vpopmail with mysql problem
Is Mysql started? -John - Original Message - From: zafar rizvi [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 18, 2003 12:20 AM Subject: [vchkpw] vpopmail with mysql problem hi i am installing vpopmail-5.2.1 with mysql centralized database ports, I successfully compile everything but when adding the domain it give me error like that [EMAIL PROTECTED] vpopmail-5.2.1]# /home/vpopmail/bin/vadddomain example.com Please enter password for postmaster: enter password again: 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) 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 Error: Unable to chdir to vpopmail/users directory Is there anything wrong. Tx ZaFAr
Re: [vchkpw] vpopmail with mysql problem
zafar rizvi wrote: i am installing vpopmail-5.2.1 with mysql centralized database ports, I successfully compile everything but when adding the domain it give me error like that [EMAIL PROTECTED] vpopmail-5.2.1]# /home/vpopmail/bin/vadddomain example.com Please enter password for postmaster: enter password again: 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) 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 Error: Unable to chdir to vpopmail/users directory Is there anything wrong. A whole bunch of things could be wrong - you have to do some troubleshooting yourself to check these: 1. MySQL isn't running at the remote end. and/or 2. Your MySQL username or password is/are incorrect. and/or 3. You haven't given permission on the remote MySQL server to connect to it from your server (i.e. GRANT ALL PRIVILEGES ON vpopmail.* TO [EMAIL PROTECTED] IDENTIFIED BY password etc etc etc). and/or 4. There is a firewall running on either or both machines preventing communication. Again, as I suggested in a previous email, you can test these things yourself easily enough using simple things like telnet, the mysql client, etc etc. -- Aj. Systems Administrator / Developer
