Hi,
http://www.mail-archive.com/vchkpw@inter7.com/msg04765.html
check that link out.. i did the same kinda mistake and that's the solution..
regards
dushyanth
> 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
--
As we enjoy great advantages from the inventions of
others, we should be glad of an opportunity to serve others by any
invention of ours; and this we should do freely and generously."
-- Benjamin Franklin
Dushyanth Harinath
Archean Infotech Limited
Ph No:091-040-3228666,6570704,3228674
http://www.archeanit.com
