atom feed14 messages in net.sourceforge.lists.courier-usersRe: [courier-users] Courier-Imap + Vp...
FromSent OnAttachments
Don HinshawMar 16, 2001 5:35 am 
Don HinshawMar 16, 2001 7:02 pm 
Richard BrowneMar 16, 2001 8:04 pm 
Don HinshawMar 16, 2001 10:28 pm 
Yoshi MelroseMar 17, 2001 12:43 am 
Don HinshawMar 17, 2001 5:46 am 
Wes WannemacherMar 17, 2001 9:45 am 
Don HinshawMar 17, 2001 1:00 pm 
Rudy SetiawanMar 18, 2001 10:36 pm 
Don HinshawMar 19, 2001 5:41 am 
Daniel BiddleMar 19, 2001 8:25 am 
Don HinshawMar 19, 2001 4:58 pm 
Jame...@china.comMar 19, 2001 5:33 pm 
Brad DameronMar 19, 2001 5:46 pm 
Subject:Re: [courier-users] Courier-Imap + Vpopmail +MySQL (not the usual question)
From:Rudy Setiawan (rud@indocafe.org)
Date:Mar 18, 2001 10:36:06 pm
List:net.sourceforge.lists.courier-users

Don Hinshaw,

Hey2...finally I got someone actually installed COURIER-IMAPD with VPOPMAIL MYSQL. Ok I got the latest vpopmail and courier-imap. and I got this version of MYSQL: MySQL-client-3.23.33-1 MySQL-devel-3.23.33-1 MySQL-shared-3.23.33-1 MySQL-3.23.33-1

but i am still having that problem regarding the errors on making courier-imap:

make[1]: Entering directory `/home/username/oldqmail/courier-imap-1.3.5/authlib' gcc -I/home/vpopmail/include -g -O2 -Wall -I.. -I./.. -L/home/vpopmail/lib -o authvchkpw modauthvchkpw.o libauthmod.a libauth.a ../md5/libmd5.a -lvpopmail -lm -lcrypt /home/vpopmail/lib/libvpopmail.a(vauth.o): In function `vauth_open': /home/username/oldqmail/vpopmail-4.9.8-1/vauth.c:66: undefined reference to `mysql_init' /home/username/oldqmail/vpopmail-4.9.8-1/vauth.c:68: undefined reference to `mysql_real_connect' /home/username/oldqmail/vpopmail-4.9.8-1/vauth.c:70: undefined reference to `mysql_real_connect'

So yeah if you can give me some direction that will be great. What kind of correct path that you are talking about. I have tried recompiling vpopmail again and again...still wont work :(

Thank you in advance.

Rudy

----- Original Message ----- From: "Don Hinshaw" <dw@kaltobepress.com> To: <cour@lists.sourceforge.net> Sent: Friday, March 16, 2001 5:35 AM Subject: [courier-users] Courier-Imap + Vpopmail +MySQL (not the usual question)

Hi,

After running Courier-Imap and Vpopmail for around two years, I decided that for this upgrade I would move to Vpopmail's MySQL auth (there is good reason for this, we will be storing other user data in the databases as well as the vpop stuff). I'm using:

RH7 vpopmail-4.9.8-1.tar.gz courier-imap-1.3.5.tar.gz

Qmail is installed and working fine from BG's latest .rpms. Vpopmail is installed and working fine and all of it's /bin programs work correctly and add/del tables and records to the MySQL server (on a different system, but with an identical RH install).

I then ran into that problem that's mentioned so many times on both lists, that of the compile error where the mysql libs can't be found. Got that straightened out and got Courier-Imap compiled and installed (installed latest MySQL-client and -devel and rebuilt both Vpopmail and Courier with the right paths).

The problem is the system won't auth. I've used vconvert to stuff the data from existing vdomains into the database, and I've created new test domains. This is what is in /var/log/maillog when trying to connect to an existing domain that was vconverted:

imapd: chdir: Permission denied

So, I went and double (and triple) checked all the permissions and they match those of our older and properly working vpasswd.cdb system.

I saw something on one of the lists about adding -user=vpopmail and - group=vchkpwd to the imapd.rc and that gave me:

imapd: setuid: Operation not permitted

I then reversed that change to imapd.rc.

When adding a new domain and a new (non postmaster) account I get this:

imapd: LOGIN FAILED, ip=[::ffff:x.x.x.x] (ip changed to protect the innocent)

I think I saw something on one of the lists about using some kind of

-lmysqlcrypt

or something to that effect (although I can't seem to find it now since the Courier list doesn't seem to be searchable).

What I'm wondering is: Is it possible that Courier-Imap is not passing the correct encrypted string to the sql server? Failing that, has anyone else run across these symptoms? I didn't find it after many hours of poring over the list archives (for both lists).

Or have I overlooked something and Courier-Imap is actually trying to use the vpasswd file (I ask this because in the new test domain, there is a .vpasswd.lock file, but of course no .vpasswd or .vpasswd.cdb)?

I have only the one authmodule configured in /etc/imapd: AUTHMODULES="authvchkpw"

-=dwh=-