Hi Alan You should not have multiple domain tables in the database if you configure with --enable-many-domains=y
Did you perhaps configure/make originally with --enable-many-domains=n, and then swap over to --enable-many-domains=y ? Could be some left over config hanging around... If in doubt, I would recommend you do these steps : delete your existing vpopmail source dir untar setup your vmysql.h re-run configure (checking that you are using the desired --enable-many-domains) make make install-strip Then dont forget you have to recompile any add-on apps that use the vpopmail libraries, eg qmailadmin, courier-imap Also, you could compare your config against my guide : "A QUICK GUIDE TO VPOPMAIL WITH MYSQL" http://www.pipeline.com.au/staff/mbowe/isp/vpopmail-mysql.htm Michael. ----- Original Message ----- From: "Alan Murrell" <[EMAIL PROTECTED]> To: "Vpopmail Users List" <[EMAIL PROTECTED]> Sent: Monday, August 11, 2003 2:18 PM Subject: [vchkpw] Unknown column 'pw_name' in 'field list' > Hello, > > Mandrake 9.1 > Qmail 1.03 > Vpopmail 5.3.24 > > I am setting up a new server with the latest (devel) > version of vpopmail, using MySQL as the backend. I > edited vmysql to point to the database server, and > have confirmed that the (MySQL) username and password > work by authenticating from the mail server to the > MySQL server using the 'mysql' program. > > However, when I test POP authentication via telnet, I > get the following error: > > --- CUT HERE --- > [EMAIL PROTECTED] vpopmail-5.3.24]# telnet localhost 110 > Trying 127.0.0.1... > Connected to localhost (127.0.0.1). > Escape character is '^]'. > +OK <[EMAIL PROTECTED]> > user alan > +OK > pass bofh123 > vmysql: sql error[3]: Unknown column 'pw_name' in > 'field list' > -ERR authorization failed > Connection closed by foreign host. > --- CUT HERE --- > > I have checked several of the domain tables in the > database, and they do indeed have the 'pw_name' > column, and it appears to be defined in the 'vmysql.h' > file. The README.mysql file does not shed any light > on this. > > I was wondering if anyone here would be able to shed > some light on this, and let me know what I appear to > have done wrong? > > In case it is relevent, my vpopmail configuration > looks like this: > > --- CUT HERE --- > ./configure --enable-tcprules-prog=/usr/bin/tcprules \ > --enable-tcpserverfile=/etc/tcp.smtp \ > --enable-clear-passwd=y \ > --enable-mysql=y \ > --enable-valias=y \ > --enable-file-locking=y \ > --enable-many-domains=y \ > --enable-defaultquota=25214400S,1000C \ > --enable-domainquotas=y > --- CUT HERE --- > > TIA for your help and insight. > > Alan Murrell <[EMAIL PROTECTED]> > > > ______________________________________________________________________ > Post your free ad now! http://personals.yahoo.ca > >
