ok false alarm...i had vpopmail as user in vmysql.h and that user didn't
have rights to create database or modify existing one. everything is
working good. having problem recompiling sqwebmail but that is for another
list. thanx all.
-----Original Message-----
From: inter7 [mailto:inter7]On Behalf Of Ken Jones
Sent: Thursday, June 14, 2001 11:03 PM
To: Chris Ochap
Subject: Re: mysql blues
What are the contents of your vmysql.h file?
Did you edit that?
What OS are you using?
have you tried to log into mysql from a non root shell account?
Ken Jones
Chris Ochap wrote:
>
> 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
