RE: [vchkpw] vpopmail and mysql problem

2005-10-04 Thread Ingo Claro
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]



Re: [vchkpw] vpopmail and mysql problem

2005-10-03 Thread Sergio Rosa

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

2005-10-03 Thread Ken Jones

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

2005-10-03 Thread Wes Hegge
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

2005-10-03 Thread Rick Macdougall

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

2005-10-03 Thread Wes Hegge
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

2005-10-03 Thread Rick Macdougall

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

2005-10-03 Thread Wes Hegge
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

2005-10-03 Thread Wes Hegge
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]


Re: [vchkpw] vpopmail with mysql problem

2003-07-18 Thread Ahmad Masood Shah
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

2003-07-18 Thread John Johnson
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

2003-07-18 Thread Ajai Khattri
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