Umm, why wouldn't you compile sqwebmail with authvchkpw authentication? It'll handle all the mysql stuff for you.
Regards, Tren. -----Original Message----- From: Raymond Danks [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 11:21 AM To: [EMAIL PROTECTED] Subject: Configuring SQWebmail auth using vpopmail MySQL database Hi, I have been struggling with this for some time now and I was hoping that maybe someone here could help me or at least send me in the right direction. I am configuring Qmailadmin 0.45 with vpopmail 0.5 and SQWebmail 3.1.0. I have Qmailadmin working fine using a MYSql database vpopmail and I am trying to bring SQWebmail into the picture. I saw a note in the SQWebamil docs saying not to ue MYsql authentification if using vpopmail. I am trying to do this anyhow, because I believe that the version of vpopmail that I am using was not taken into account when this note was written. My vpopmail is using MySql and the database tables seem in close enough format to be compatible with SQWebmail...? I have compiled SQWebmail with the recommended env "LIBS=-L/usr/lib/mysql -lmysqlclient -lz" \. I have alterred the authwebmailrc to use vpopmail as the database and table for atuhentication. Basically: MYSQL_DATABASE vpopmail MYSQL_DATABASE vpopmail MYSQL_CRYPT_PWFIELD pw_passwd MYSQL_UID_FIELD pw_uid MYSQL_GID_FIELD pw_gid MYSQL_LOGIN_FIELD pw_name MYSQL_HOME_FIELD pw_dir MYSQL_NAME_FIELD pw_gecos I am getting nothing but authentication failures in SQWemaiil. I can see from the mysql logs that the database is being accessed, however: 011024 16:20:52 Aborted connection 424 to db: 'vpopmail' user: 'root' host: `lo calhost' (Got an error reading communication packets) this is not enough for me to decipher exactly what is going on. I can't seem to find any logging that SQWebmail is doing or can be configured to do. The users in the vpopmail database were created using Qmailadmin. One thing I noticed about this is that the pw_uid and pw_gid fields are always 0. I am wondering if this is having an effect on the way SQWebmail is parsing the database. If anyone has any information on this or has configured this themselves, I would greatly appreciate it. Thanks, Ray
