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] > > > > > > >