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]
