It looks like vpopmail is having a problem connecting to the database. Did you set the correct information up in vmysql.h Information like... /* Edit to match your set up */ #define MYSQL_SERVER "localhost" #define MYSQL_USER "vpopmail" #define MYSQL_PASSWD "supersecretpassword" /* End of setup section*/ If you didn't. Do it. mysql> GRANT ALL PRIVILEGES ON vpopmail.* TO vpopmail@localhost IDENTIFIED BY 'supersecretpassword' WITH GRANT OPTION; If you did. Check it. Confirm that the user can connect to the SQL database with that password $ mysql -u<vpopmail user> -p<password> vpopmail Check that the user has enough privileges to create a table - which it is trying to do. Check stupid things like mysql is running. >From the error it looks like its trying create the relay table. You configured vpopmail with --enable-roaming-users=y. Do you want this? If you dont need it, recompile with out it! -- Regards, Kieran Barnes Signum 1226 Ltd Visit our website at http://www.1226.net Phone: 01772 622889 || Fax: 01772 622558 > -----Original Message----- > From: Rami Laiho [mailto:[EMAIL PROTECTED]] > Sent: 14 June 2001 09:55 > To: [EMAIL PROTECTED] > Subject: POP authentication > > > > Hi > > I'm trying to get mails with pop and get this error: > [root]# telnet localhost 110 > Trying 127.0.0.1... > Connected to localhost.localdomain. > Escape character is '^]'. > +OK <19958.992508159@localhost> > user rami > +OK > pass password > could not create relay table create table relay ( ip_addr char(18) not > null, timestamp char(12), primary key(ip_addr) ) > error inserting into ip_addr table > could not create relay table create table relay ( ip_addr char(18) not > null, timestamp char(12), primary key(ip_addr) ) > +OK > > Does anybody know what is wrong? I'm using vpopmail with > mySQL database. > > Rami > > -- > [EMAIL PROTECTED] >
