I did some more investigation into this and found some problems with the coding in vpopmail
I have submitted a patch to the vpopmail project on sourceforge that should fix this problem Michael. ----- Original Message ----- From: "Michael Bowe" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 17, 2003 2:22 PM Subject: Re: [qmailadmin] Authentication oddity in qmailadmin > My server also runs the mysql backend > > I tried adding a aliasdomain (testme.com) and then logging into qmailadmin > on the alias domain and it failed with an error : > > vmysql: sql error[3]: Table 'vpopmail.testme_com' doesn't exist > > I took a quick look through the code, and I think the problem may have > something to do with line 358 from the vauth_getpw() function in vmysql.c > > /*vget_real_domain(in_domain, 100);*/ > > Shorly after this remarked line, an SQL command is built that contains a > SELECT for the aliased domain name. Since the alised domain doesnt actually > exist in SQL you get a nasty error. The SELECT should really contain a > lookup on the real domain rather than the aliased domain. > > I wonder why that code was remarked out, because it seems to be the solution > to this problem? > > Michael. > > > > ----- Original Message ----- > From: "Matt Simerson" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, June 17, 2003 12:37 PM > Subject: Fwd: [qmailadmin] Authentication oddity in qmailadmin > > > > (sorry for the personal reply Tom, I forgot to change the reply-to) > > > > OK, I've updated both my vpopmail and qmailadmin to the latest devel > > versions and it still doesn't work. Here's how I'm configured: > > > > vpopmail: > > > > ./configure --enable-mysql=y --enable-rebuild-tcpserver-file=n > > --enable-defaultquota=100000000S,10000C --enable-roaming-users=y > > --enable-learn-passwords=y --enable-logging=v > > --enable-default-domain=u-r-on.net --enable-mysql-replication=y > > > > qmailadmin: > > > > ./configure --enable-domain-autofill=Y --enable-modify-spam=Y > > '--enable-spam-command=| /usr/local/bin/maildrop' > > --enable-modify-quota=y --enable-cgibindir=/usr/local/www/cgi-bin.mail > > > > > > I can't think of why any of the above would cause this to not work. I > > can authenticate via just fine via POP3 using all three domains > > (indicating that yea verily, it is set up in vpopmail correctly). But I > > can only log into qmailadmin using the "main" domain. The domains were > > added using qmailadmin 1.0.15 but I don't see anything particularly > > relevant in the ChangeLog. > > > > I can log in just fine as [EMAIL PROTECTED] but I cannot log in as > > [EMAIL PROTECTED], which is an aliasdomain of u-r-on.net. I've tried > > removing the aliasdomain avgisp.com and then re-adding it but still no > > luck. > > > > Matt > > > > > > On Monday, June 16, 2003, at 05:57 PM, Tom Collins wrote: > > > > > On Monday, June 16, 2003, at 02:30 PM, Matt Simerson wrote: > > >> I can thus add bobsmith.com to vpopmail as an aliasdomain. Now any > > >> user in bob.com can also authenticate as user at bobsmith.com. I'm > > >> sure you're all with me so far. > > >> > > >> However, qmailadmin does not appear to support this. Only > > >> [EMAIL PROTECTED] is able to log in via qmailadmin. > > >> > > >> Shouldn't the user also be able to authenticate as [EMAIL PROTECTED] > > > > > > Works for me (qmailadmin 1.0.21, vpopmail 5.3.20). > > > > > > -- > > > Tom Collins > > > [EMAIL PROTECTED] > > > >
