Thanks I got it working. I needed to create the user but I initially was not
"make distclean" before attempting to remake.
----- Original Message -----
From: "Matthias Henze" <[EMAIL PROTECTED]>
To: "Dean Mumby" <[EMAIL PROTECTED]>
Sent: Friday, March 16, 2001 1:04 PM
Subject: Re: vpopmail + mysql
> At 12:55 16.03.01 +0200, you wrote:
> >Thanks for the response
> >
> >Do I need to create tables etc.. ??
>
> i do not remember .... but, according to your errormessage: no
>
> >I am using webmin to configure mysql
>
> i do not like webmin :-)
>
>
>
> >----- Original Message -----
> >From: "Matthias Henze" <[EMAIL PROTECTED]>
> >To: "Dean Mumby" <[EMAIL PROTECTED]>
> >Sent: Friday, March 16, 2001 12:30 PM
> >Subject: Re: vpopmail + mysql
> >
> >
> > > follow this:
> > >
> > > create a databas, e.g. vpopmail
> > > create a userwith password, e.g. vpopmail
> > > give the user access rights from localhost to the database
> > > don't forget to reload/refresh mysql
> > > make vmysql.h reflect this data
> > > now any thing should work
> > >
> > > perhaps you want to use http://phpwizard.net/projects/phpMyAdmin/ in
order
> > > to make your life easierer :-)
> > >
> > > At 10:43 16.03.01 +0200, you wrote:
> > > >Hi
> > > >I have installed qmail-1.03+patches-18.rpm and now vpopmail-4.9.9
> > > >
> > > >I configured vpopmail with
> > > >--enable-default-domain=sslmail.co.za
> > > >--enable-mysql=y
> > > >--enable-sqlincdir=/usr/include/mysql
> > > >--enable-ucspi-dir=/usr/bin
> > > >--enable-logging=y
> > > >--enable-auth-logging=y
> > > >[EMAIL PROTECTED]
> > > >--enable-tcpserver-file=/etc/tcpcontrol/smtp.rules
> > > >--enable-tcprules-prog=/usr/bin/tcprules
> > > >--enable-passwd=y
> > > >It worked fine
> > > >I then make
> > > >and make install-strip and got no errors
> > > >
> > > >I edited vmysql.h and made it
> > > >mysql_server "localhost"
> > > >...user "root"
> > > >...passwd "xxxxx"
> > > >
> > > >When I tried to add a test domain this is what I got
> > > >
> > > > ./vadddomain test5.com
> > > >Please enter password for postmaster: xx
> > > >enter password again:xx
> > > >could not connect to mysql server
> > > >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), unique index (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 (
'test5.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
> > > >vsql_getpw: failed select
> > > >
> > > >Could someone please tell me what has happened I am new to mysql . I
cant
> > > >find a database anywhere . there are no entries in
/var/log/mysqld.log
> > > >
> > > >regards
> > > >dean
> > >
> > >
> > > Matthias Henze MH458-RIPE
> > > [EMAIL PROTECTED]
> > >
> > > Use PGP!! http://www.mhcsoftware.de/MatthiasHenze.asc
> > > -----------------------------------------------------
> > > MHC SoftWare GmbH voice: +49-(0)9533-92006-0
> > > Fichtera 17 fax: +49-(0)9533-92006-6
> > > 96274 Itzgrund/Germany e-Mail: [EMAIL PROTECTED]
> > > -----------------------------------------------------
> > >
> > >
>
>
> Matthias Henze MH458-RIPE
> [EMAIL PROTECTED]
>
> Use PGP!! http://www.mhcsoftware.de/MatthiasHenze.asc
> -----------------------------------------------------
> MHC SoftWare GmbH voice: +49-(0)9533-92006-0
> Fichtera 17 fax: +49-(0)9533-92006-6
> 96274 Itzgrund/Germany e-Mail: [EMAIL PROTECTED]
> -----------------------------------------------------
>
>
