[vchkpw] authdaemond: vmysql: sql error[3]: Table 'vpopmail.testi_com' doesn't exist
Hello, I'm in need of a bit of advice: I first installed vpopmail-5.4.13 with the many domains option (own table for each virtual domain). Now, when I installed vpopmail-5.4.17 so that each domain goes to the table vpopmail.vpopmail, thinks get wrong. (I even removed whole /home/vpopmail/ and the database and did the install from the begining) When I do vadddomain and vadduser, the users go neatly to vpopmail.vpopmail (and the Maildir-directory sturcture is nicely created), but when I try to authenticate via IMAP (Courier) it failes an /var/log/maillog tells me this: Oct 18 12:14:20 moya authdaemond: vmysql: sql error[3]: Table 'vpopmail.testi_com' doesn't exist Oct 18 12:14:20 moya authdaemond: Attempting to rebuild connection to SQL server Oct 18 12:14:20 moya authdaemond: vmysql: connection rebuild failed: Table 'vpopmail.testi_com' doesn't exist Oct 18 12:14:20 moya imapd: LOGIN FAILED, [EMAIL PROTECTED], ip=[:::62.142.95.226] Where can I tell vpopmail that it should try table vpopmail.vpopmail and not vpopmail.DOMAIN? I configured vpopmail-5.4.17 with this: ./configure --disable-ip-alias-domains --enable-auth-module=mysql --enable-clear-passwd --enable-libdir=/usr/lib64/mysql/ --enable-tcpserver-path=/home/vpopmail/etc/ --enable-tcpserver-file=/home/vpopmail/etc/tcp.smtp --enable-qmail-ext --enable-logging=e --enable-tcprules-prog=/usr/local/bin/tcprules --enable-rebuild-tcpserver-file --disable-domain-quotas --enable-many-domains=y --enable-auth-logging --enable-sql-logging --enable-valias --disable-mysql-limits --disable-roaming-users --enable-logging=p --disable-passwd Best Regards, Jarkko Ranta
Re: [vchkpw] authdaemond: vmysql: sql error[3]: Table 'vpopmail.testi_com' doesn't exist
On Oct 18, 2006, at 02:45:12 MST, Jarkko Ranta wrote: Hello, I'm in need of a bit of advice: I first installed vpopmail-5.4.13 with the many domains option (own table for each virtual domain). Now, when I installed vpopmail-5.4.17 so that each domain goes to the table vpopmail.vpopmail, thinks get wrong. (I even removed whole /home/ vpopmail/ and the database and did the install from the begining) When I do vadddomain and vadduser, the users go neatly to vpopmail.vpopmail (and the Maildir-directory sturcture is nicely created), but when I try to authenticate via IMAP (Courier) it failes an /var/log/maillog tells me this: Oct 18 12:14:20 moya authdaemond: vmysql: sql error[3]: Table 'vpopmail.testi_com' doesn't exist Oct 18 12:14:20 moya authdaemond: Attempting to rebuild connection to SQL server Oct 18 12:14:20 moya authdaemond: vmysql: connection rebuild failed: Table 'vpopmail.testi_com' doesn't exist Oct 18 12:14:20 moya imapd: LOGIN FAILED, [EMAIL PROTECTED], ip=[:::62.142.95.226] Where can I tell vpopmail that it should try table vpopmail.vpopmail and not vpopmail.DOMAIN? I configured vpopmail-5.4.17 with this: ./configure --disable-ip-alias-domains --enable-auth-module=mysql -- enable-clear-passwd --enable-libdir=/usr/lib64/mysql/ --enable- tcpserver-path=/home/vpopmail/etc/ --enable-tcpserver-file=/home/ vpopmail/etc/tcp.smtp --enable-qmail-ext --enable-logging=e -- enable-tcprules-prog=/usr/local/bin/tcprules --enable-rebuild- tcpserver-file --disable-domain-quotas --enable-many-domains=y -- enable-auth-logging --enable-sql-logging --enable-valias --disable- mysql-limits --disable-roaming-users --enable-logging=p --disable- passwd Best Regards, Jarkko Ranta You need to recompile vmysql or whatever authdaemond is using. It is out of date. Bert JW Regeer smime.p7s Description: S/MIME cryptographic signature
Re: [vchkpw] authdaemond: vmysql: sql error[3]: Table 'vpopmail.testi_com' doesn't exist
Bert JW Regeer kirjoitti: On Oct 18, 2006, at 02:45:12 MST, Jarkko Ranta wrote: Hello, I'm in need of a bit of advice: I first installed vpopmail-5.4.13 with the many domains option (own table for each virtual domain). Now, when I installed vpopmail-5.4.17 so that each domain goes to the table vpopmail.vpopmail, thinks get wrong. (I even removed whole /home/vpopmail/ and the database and did the install from the begining) When I do vadddomain and vadduser, the users go neatly to vpopmail.vpopmail (and the Maildir-directory sturcture is nicely created), but when I try to authenticate via IMAP (Courier) it failes an /var/log/maillog tells me this: Oct 18 12:14:20 moya authdaemond: vmysql: sql error[3]: Table 'vpopmail.testi_com' doesn't exist Oct 18 12:14:20 moya authdaemond: Attempting to rebuild connection to SQL server Oct 18 12:14:20 moya authdaemond: vmysql: connection rebuild failed: Table 'vpopmail.testi_com' doesn't exist Oct 18 12:14:20 moya imapd: LOGIN FAILED, [EMAIL PROTECTED], ip=[:::62.142.95.226] Where can I tell vpopmail that it should try table vpopmail.vpopmail and not vpopmail.DOMAIN? I configured vpopmail-5.4.17 with this: ./configure --disable-ip-alias-domains --enable-auth-module=mysql --enable-clear-passwd --enable-libdir=/usr/lib64/mysql/ --enable-tcpserver-path=/home/vpopmail/etc/ --enable-tcpserver-file=/home/vpopmail/etc/tcp.smtp --enable-qmail-ext --enable-logging=e --enable-tcprules-prog=/usr/local/bin/tcprules --enable-rebuild-tcpserver-file --disable-domain-quotas --enable-many-domains=y --enable-auth-logging --enable-sql-logging --enable-valias --disable-mysql-limits --disable-roaming-users --enable-logging=p --disable-passwd Best Regards, Jarkko Ranta You need to recompile vmysql or whatever authdaemond is using. It is out of date. Bert JW Regeer Shouldn't it get recompiled from vpopmail-5.4.17/vmysql.c vpopmail-5.4.17/vmysql.h when I do make (and make install-strip) after the vpopmail's configurartion script? Or have I missed a switch or something? It's Inter7's own files, so they should be the most recent? Best Regards, Jarkko Ranta
Re: [vchkpw] authdaemond: vmysql: sql error[3]: Table 'vpopmail.testi_com' doesn't exist
On Oct 18, 2006, at 03:24:42 MST, Jarkko Ranta wrote: Bert JW Regeer kirjoitti: On Oct 18, 2006, at 02:45:12 MST, Jarkko Ranta wrote: Hello, I'm in need of a bit of advice: I first installed vpopmail-5.4.13 with the many domains option (own table for each virtual domain). Now, when I installed vpopmail-5.4.17 so that each domain goes to the table vpopmail.vpopmail, thinks get wrong. (I even removed whole /home/ vpopmail/ and the database and did the install from the begining) When I do vadddomain and vadduser, the users go neatly to vpopmail.vpopmail (and the Maildir-directory sturcture is nicely created), but when I try to authenticate via IMAP (Courier) it failes an /var/log/maillog tells me this: Oct 18 12:14:20 moya authdaemond: vmysql: sql error[3]: Table 'vpopmail.testi_com' doesn't exist Oct 18 12:14:20 moya authdaemond: Attempting to rebuild connection to SQL server Oct 18 12:14:20 moya authdaemond: vmysql: connection rebuild failed: Table 'vpopmail.testi_com' doesn't exist Oct 18 12:14:20 moya imapd: LOGIN FAILED, [EMAIL PROTECTED], ip=[:::62.142.95.226] Where can I tell vpopmail that it should try table vpopmail.vpopmail and not vpopmail.DOMAIN? I configured vpopmail-5.4.17 with this: ./configure --disable-ip-alias-domains --enable-auth-module=mysql --enable-clear-passwd --enable-libdir=/usr/lib64/mysql/ --enable- tcpserver-path=/home/vpopmail/etc/ --enable-tcpserver-file=/home/ vpopmail/etc/tcp.smtp --enable-qmail-ext --enable-logging=e -- enable-tcprules-prog=/usr/local/bin/tcprules --enable-rebuild- tcpserver-file --disable-domain-quotas --enable-many-domains=y -- enable-auth-logging --enable-sql-logging --enable-valias -- disable-mysql-limits --disable-roaming-users --enable-logging=p -- disable-passwd Best Regards, Jarkko Ranta You need to recompile vmysql or whatever authdaemond is using. It is out of date. Bert JW Regeer Shouldn't it get recompiled from vpopmail-5.4.17/vmysql.c vpopmail-5.4.17/vmysql.h when I do make (and make install-strip) after the vpopmail's configurartion script? Or have I missed a switch or something? It's Inter7's own files, so they should be the most recent? Best Regards, Jarkko Ranta authdaemond is failing, recompile that. Bert JW Regeer smime.p7s Description: S/MIME cryptographic signature