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
