Re: [vchkpw] Problens with vpopmail + mysql

2006-01-25 Thread Li Qidong

it seems like that you have not install mysql-devel.
maybe

- Original Message - 
From: Rosivaldo Azevedo Ramalho [EMAIL PROTECTED]

To: vchkpw@inter7.com
Sent: Wednesday, January 25, 2006 4:24 AM
Subject: Re: [vchkpw] Problens with vpopmail + mysql


Yeah, i forgot to tell that i did this tests, they just work fine when i 
connect to the mysql with the vpopmailuser.


**
[EMAIL PROTECTED] etc]# mysql -u vpopmailuser -p vpopmail
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9 to server version: 5.0.13-rc-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql show tables;
Empty set (0.00 sec)

mysql select database();
++
| database() |
++
| vpopmail   |
++
1 row in set (0.00 sec)

mysql


- Original Message - 
From: Stoyan Marinov [EMAIL PROTECTED]

To: vchkpw@inter7.com
Sent: Tuesday, January 24, 2006 5:20 PM
Subject: Re: [vchkpw] Problens with vpopmail + mysql



Create, Select... ;)

Also try connecting to the MySQL server with the vpopmail user (mysql -u
vpopmail -p) to see if the login is correct.

C.

On Tue, 2006-01-24 at 13:46 -0600, alex wrote:

Almost certaintly your permissions are wrongly set. Make shure vpopmail
mysql config files has the correct user, login and password and that
that user has necesary permission (insert, update, delete) over ther db
in question (tipically vpopmail).

Rosivaldo Azevedo Ramalho wrote:
 Hi there, i installed the vpopmail 5.4.13 on a RHEL 4 box with Mysql
 5.0 installed. At the installation process everything looks good, but
 when i try to add a new virtual domain i got the following error:
 **
 [EMAIL PROTECTED] bin]# pwd
 /home/vpopmail/bin
 [EMAIL PROTECTED] bin]# ./vadddomain foo.foobar.net 123mudar
 vmysql: error creating table 'dir_control': MySQL server has gone away
 vmysql: sql error[b]: MySQL server has gone away
 vmysql: error creating table 'foo_foobar_net': 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 foo.foobar.net
 Error: no auth connection
 [EMAIL PROTECTED] bin]#
 **
 Here is a copy of my ~vpopmail/etc/vpopmail.mysql
 localhost|0|vpopmailuser||vpopmail
 localhost|0|root||vpopmail

 I've searche for all over the google and i couldn't find nothing, if
 some one can help i really apreciate

 Regards
 -- 
 Rosivaldo Azevedo Ramalho - Gerente de Redes

 Prefeitura Municipal de Campina Grande
 Secretaria de Administração
 Departamento de Tecnologia de Informação
 [EMAIL PROTECTED]









Re: [vchkpw] Problens with vpopmail + mysql

2006-01-24 Thread alex
Almost certaintly your permissions are wrongly set. Make shure vpopmail
mysql config files has the correct user, login and password and that
that user has necesary permission (insert, update, delete) over ther db
in question (tipically vpopmail).

Rosivaldo Azevedo Ramalho wrote:
 Hi there, i installed the vpopmail 5.4.13 on a RHEL 4 box with Mysql
 5.0 installed. At the installation process everything looks good, but
 when i try to add a new virtual domain i got the following error:
 **
 [EMAIL PROTECTED] bin]# pwd
 /home/vpopmail/bin
 [EMAIL PROTECTED] bin]# ./vadddomain foo.foobar.net 123mudar
 vmysql: error creating table 'dir_control': MySQL server has gone away
 vmysql: sql error[b]: MySQL server has gone away
 vmysql: error creating table 'foo_foobar_net': 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 foo.foobar.net
 Error: no auth connection
 [EMAIL PROTECTED] bin]#
 **
 Here is a copy of my ~vpopmail/etc/vpopmail.mysql
 localhost|0|vpopmailuser||vpopmail
 localhost|0|root||vpopmail

 I've searche for all over the google and i couldn't find nothing, if
 some one can help i really apreciate

 Regards
 -- 
 Rosivaldo Azevedo Ramalho - Gerente de Redes
 Prefeitura Municipal de Campina Grande
 Secretaria de Administração
 Departamento de Tecnologia de Informação
 [EMAIL PROTECTED] 



Re: [vchkpw] Problens with vpopmail + mysql

2006-01-24 Thread Stoyan Marinov
Create, Select... ;)

Also try connecting to the MySQL server with the vpopmail user (mysql -u
vpopmail -p) to see if the login is correct.

C.

On Tue, 2006-01-24 at 13:46 -0600, alex wrote:
 Almost certaintly your permissions are wrongly set. Make shure vpopmail
 mysql config files has the correct user, login and password and that
 that user has necesary permission (insert, update, delete) over ther db
 in question (tipically vpopmail).
 
 Rosivaldo Azevedo Ramalho wrote:
  Hi there, i installed the vpopmail 5.4.13 on a RHEL 4 box with Mysql
  5.0 installed. At the installation process everything looks good, but
  when i try to add a new virtual domain i got the following error:
  **
  [EMAIL PROTECTED] bin]# pwd
  /home/vpopmail/bin
  [EMAIL PROTECTED] bin]# ./vadddomain foo.foobar.net 123mudar
  vmysql: error creating table 'dir_control': MySQL server has gone away
  vmysql: sql error[b]: MySQL server has gone away
  vmysql: error creating table 'foo_foobar_net': 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 foo.foobar.net
  Error: no auth connection
  [EMAIL PROTECTED] bin]#
  **
  Here is a copy of my ~vpopmail/etc/vpopmail.mysql
  localhost|0|vpopmailuser||vpopmail
  localhost|0|root||vpopmail
 
  I've searche for all over the google and i couldn't find nothing, if
  some one can help i really apreciate
 
  Regards
  -- 
  Rosivaldo Azevedo Ramalho - Gerente de Redes
  Prefeitura Municipal de Campina Grande
  Secretaria de Administração
  Departamento de Tecnologia de Informação
  [EMAIL PROTECTED] 
 
 



Re: [vchkpw] Problens with vpopmail + mysql

2006-01-24 Thread Rosivaldo Azevedo Ramalho
Yeah, i forgot to tell that i did this tests, they just work fine when i 
connect to the mysql with the vpopmailuser.


**
[EMAIL PROTECTED] etc]# mysql -u vpopmailuser -p vpopmail
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9 to server version: 5.0.13-rc-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql show tables;
Empty set (0.00 sec)

mysql select database();
++
| database() |
++
| vpopmail   |
++
1 row in set (0.00 sec)

mysql


- Original Message - 
From: Stoyan Marinov [EMAIL PROTECTED]

To: vchkpw@inter7.com
Sent: Tuesday, January 24, 2006 5:20 PM
Subject: Re: [vchkpw] Problens with vpopmail + mysql



Create, Select... ;)

Also try connecting to the MySQL server with the vpopmail user (mysql -u
vpopmail -p) to see if the login is correct.

C.

On Tue, 2006-01-24 at 13:46 -0600, alex wrote:

Almost certaintly your permissions are wrongly set. Make shure vpopmail
mysql config files has the correct user, login and password and that
that user has necesary permission (insert, update, delete) over ther db
in question (tipically vpopmail).

Rosivaldo Azevedo Ramalho wrote:
 Hi there, i installed the vpopmail 5.4.13 on a RHEL 4 box with Mysql
 5.0 installed. At the installation process everything looks good, but
 when i try to add a new virtual domain i got the following error:
 **
 [EMAIL PROTECTED] bin]# pwd
 /home/vpopmail/bin
 [EMAIL PROTECTED] bin]# ./vadddomain foo.foobar.net 123mudar
 vmysql: error creating table 'dir_control': MySQL server has gone away
 vmysql: sql error[b]: MySQL server has gone away
 vmysql: error creating table 'foo_foobar_net': 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 foo.foobar.net
 Error: no auth connection
 [EMAIL PROTECTED] bin]#
 **
 Here is a copy of my ~vpopmail/etc/vpopmail.mysql
 localhost|0|vpopmailuser||vpopmail
 localhost|0|root||vpopmail

 I've searche for all over the google and i couldn't find nothing, if
 some one can help i really apreciate

 Regards
 -- 
 Rosivaldo Azevedo Ramalho - Gerente de Redes

 Prefeitura Municipal de Campina Grande
 Secretaria de Administração
 Departamento de Tecnologia de Informação
 [EMAIL PROTECTED]