having trouble getting mysql to work (i am quite a newbie to mysql and how
it works). i can log into the server using vpopmail user and the password i
chose. when logged into mysql as vpopmail user i can create and destroy
databases (only ones vpopmail created). here are my compile options and
settings after configure. below that is the output when i try add a test
domain. everything works great using cdb auth module but i would like to
learn to use mysql. any hints would be appreciated. thanx.
./configure --enable-mysql=y --enable-auth-logging=y --enable-logging=p --en
able-roaming-users=y --enable-hardquota=31457280 --enable-sqwebmail-pass=y -
-enable-tcprules-prog=/usr/local/bin/tcprules --enable-tcpserver-file=/var/v
popmail/etc/tcp.smtp
vpopmail 4.10.18
Current settings
---------------------------------------
vpopmail directory = /var/vpopmail
uid = 60
gid = 60
ip alias = OFF --enable-ip-alias-domains=n (default)
address extentions = OFF --enable-qmail-ext=n (default)
roaming users = ON --enable-roaming-users=y
tcpserver file = /var/vpopmail/etc/tcp.smtp
open_smtp file = /var/vpopmail/etc/open-smtp
user quota = 31457280 -enable-hardquota=31457280
auth module = mysql --enable-mysql=y
mysql replication = OFF --enable-mysql-replication=n default
table optimization = many domains --enable-large-site=n default
system passwords = OFF --enable-passwd=n
file locking = ON --enable-file-locking=y default
auth logging = ON --enable-auth-logging=y
mysql clear passwd = OFF --enable-clear-passwd=n default
valias processing = OFF --enable-valias=n
pop syslog = show failure attempts with clear text password
--enable-logging=p
default domain = --enable-default-domain=
auth inc = -I/usr/include/mysql
auth lib = -L/usr/lib/mysql -lmysqlclient -lz
[root@que vpopmail-4.10.18]# vadddomain testing.com
Please enter password for postmaster:
enter password again:
could not connect to mysql update server
could not create dir control table create table dir_control ( domain
varchar(255) not null, cur_users int, level_cur int, level_max int,
level_start0 int, level_start1 int, level_start2 int, level_end0 int,
level_end1 int, level_end2 int, level_mod0 int, level_mod1 int, level_mod2
int, level_index0 int , level_index1 int, level_index2 int, the_dir
varchar(255), primary key (domain) )
could not replace dir control table 2 replace into dir_control ( domain,
cur_users, level_cur, level_max, level_start0, level_start1, level_start2,
level_end0, level_end1, level_end2, level_mod0, level_mod1, level_mod2,
level_index0, level_index1, level_index2, the_dir ) values ( 'dom_60', 1, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '')
vsql_getpw: failed select
could not create dir control table create table dir_control ( domain
varchar(255) not null, cur_users int, level_cur int, level_max int,
level_start0 int, level_start1 int, level_start2 int, level_end0 int,
level_end1 int, level_end2 int, level_mod0 int, level_mod1 int, level_mod2
int, level_index0 int , level_index1 int, level_index2 int, the_dir
varchar(255), primary key (domain) )
could not create dir control table create table dir_control ( domain
varchar(255) not null, cur_users int, level_cur int, level_max int,
level_start0 int, level_start1 int, level_start2 int, level_end0 int,
level_end1 int, level_end2 int, level_mod0 int, level_mod1 int, level_mod2
int, level_index0 int , level_index1 int, level_index2 int, the_dir
varchar(255), primary key (domain) )
could not replace dir control table 2 replace into dir_control ( domain,
cur_users, level_cur, level_max, level_start0, level_start1, level_start2,
level_end0, level_end1, level_end2, level_mod0, level_mod1, level_mod2,
level_index0, level_index1, level_index2, the_dir ) values ( 'testing.com',
1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '')
vsql_getpw: failed select
MySQL server has gone away
mysql adduser failed
Error: Unable to chdir to vpopmail/users directory
