文章详情

  • 游戏榜单
  • 软件榜单
关闭导航
热搜榜
热门下载
热门标签
php爱好者> php文档>mysql: error creating table 'dir_control': MySQL

mysql: error creating table 'dir_control': MySQL

时间:2006-10-30  来源:snowtty

[root@localhost /]# uname -a
Linux localhost.localdomain 2.6.9-5.0.3.EL #1 Sat Feb 19 18:26:49 CST 2005 i686 i686 i386 GNU/Linux
[root@localhost /]# mysql --version
mysql Ver 14.7 Distrib 4.1.14, for pc-linux-gnu (i686) using EditLine wrapper

So I'm running CentOS and I've gone through the qmail install perfectly until now, when I try to use vpopmail and mysql.

[root@localhost bin]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 88 to server version: 4.1.14-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> update user set Password=password("password") where user="vpopmailuser";
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye
[root@localhost bin]# mysql -u vpopmailuser -p password
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 90 to server version: 4.1.14-log

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

mysql> use vpopmail
Database changed

mysql> show tables;
Empty set (0.00 sec)

mysql> quit
Bye
[root@localhost /]# cd ~vpopmail/bin
[root@localhost bin]# cat ../etc/vpopmail.mysql
localhost|0|vpopmailuser|password|vpopmail
[root@localhost bin]# ./vadddomain example.com t3stp4ss
vmysql: error creating table 'dir_control': MySQL server has gone away
vmysql: sql error[b\]: MySQL server has gone away
vmysql: error creating table 'example_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 example.com
Error: no auth connection
[root@localhost bin]# wtf yo?

Any ideas from here? There are several other threads on this board about this, none of them seem to be resolved, really. Where did I go wrong?
Is there a reason why it shouldn't work the way I have it setup?
I have tried a different password for mysql as well as tried to add my actual domain.
gza
11-06-2005, 05:02 PM
Aha!
I was using /tmp/mysql.sock and vadddomain was looking for /var/lib/mysql/mysql.sock, so a link worked.
相关阅读 更多 +
排行榜 更多 +
狂热战车

狂热战车

飞行射击 下载
士兵和小鸡

士兵和小鸡

飞行射击 下载
西部枪射击目标

西部枪射击目标

飞行射击 下载