Re: [vchkpw] wondering what I did wrong..
yes, it sounds like your active build of vpopmail is using the "--enable-many-domains=y", but your mysql structure is setup for "--enable-many-domains=n" If you are happy with your mysql structure, then you should perhaps : delete your existing vpopmail source dir untar setup your vmysql.h re-run configure (making sure you specify --enable-many-domains=n" make make install-strip Then dont forget you have to recompile any add-on apps that use the vpopmail libraries, eg qmailadmin, courier-imap Michael. - Original Message - From: "Evren Yurtesen" <[EMAIL PROTECTED]> To: "Brian" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, August 09, 2003 4:23 AM Subject: Re: [vchkpw] wondering what I did wrong.. > You have vpopmail set as one domain with many users > --enable-many-domains=n > then you shouldnt have users table if I am not mistaken. > > But yet vchkpw should know this I wonder if you have an older version > somehow from somewhere? I use vpopmail with FreeBSD too and it works fine. > Although I am using many domains approach. Although I would suggest that > you should use many domains if you at least have more than 1 domain and > you dont have like 10 users in each :) > > Evren > > On Fri, 8 Aug 2003, Brian wrote: > > > Hello, > > > > vpopmail 5.3.20 from FreeBSD ports collection. it *was* a cdb based > > setup and I've recently moved from cdb to mysql. (it's much faster and > > went seemingly easy.. but) > > > > [EMAIL PROTECTED] [~]# 11 > telnet localhost 110 > > Trying 127.0.0.1... > > Connected to localhost > > Escape character is '^]'. > > +OK <[EMAIL PROTECTED]> > > user user > > +OK > > pass pass > > vmysql: sql error[3]: Table 'vpopmail.users' doesn't exist > > -ERR authorization failed > > Connection closed by foreign host. > > > > and yes it's true the users table does not exist in the mysql vpopmail > > database, also when people with virtual domains try and login as > > postmaster from an alias'd domain it gives them a simmilar error. > > > > This is what I have from a make configure: > > > > vpopmail 5.3.20 > > Current settings > > --- > > > > vpopmail directory = /usr/local/vpopmail > > uid = 89 > > gid = 89 > >ip alias = OFF --enable-ip-alias-domains=n (default) > > address extentions = ON --enable-qmail-ext=y > > rebuild tcpserver file = YES --enable-rebuild-tcpserver-file=y (default) > > roaming users = ON --enable-roaming-users=y > > tcpserver file = /usr/local/vpopmail/etc/tcp.smtp > > open_smtp file = /usr/local/vpopmail/etc/open-smtp > > user quota = 1048576S -enable-hardquota=1048576S > > domain quotas = OFF --enable-domainquotas=n (default) > > auth module = mysql --enable-mysql=y > > mysql replication = OFF --enable-mysql-replication=n (default) > > table optimization = one domain with many users --enable-many-domains=n > >system passwords = ON --enable-passwd=y > >file locking = ON --enable-file-locking=y (default) > > file sync = OFF --enable-file-sync=n disable vdelivermail fsync > > (default) > > make seekable = ON --enable-make-seekable=y (default) > >auth logging = ON --enable-auth-logging=y (default) > > mysql logging = ON --enable-mysql-logging=y > >clear passwd = ON --enable-clear-passwd=y (default) > > users big dir = ON --enable-users-big-dir=y (default) > > valias processing = ON --enable-valias=y > >mysql limits = OFF --enable-mysql-limits=n (default) > > pop syslog = show failure attempts with clear text password > > --enable-logging=p > > default domain = --enable-default-domain= > >auth inc = -I/usr/local/include/mysql > >auth lib = -L/usr/local/lib/mysql -lmysqlclient -lz > > > > mysql> show tables; > > ++ > > | Tables_in_vpopmail | > > ++ > > | dir_control| > > | lastauth | > > | limits | > > | relay | > > | valias | > > | vlog | > > ++ > > > > this is a result of show tables; with my domains removed. (there are > > about 45-50 of them) > > > > Clues or suggestions would be -greatly- appreciated. > > > > > > > > > > > > > > > > >
Re: [vchkpw] wondering what I did wrong..
You have vpopmail set as one domain with many users --enable-many-domains=n then you shouldnt have users table if I am not mistaken. But yet vchkpw should know this I wonder if you have an older version somehow from somewhere? I use vpopmail with FreeBSD too and it works fine. Although I am using many domains approach. Although I would suggest that you should use many domains if you at least have more than 1 domain and you dont have like 10 users in each :) Evren On Fri, 8 Aug 2003, Brian wrote: > Hello, > > vpopmail 5.3.20 from FreeBSD ports collection. it *was* a cdb based > setup and I've recently moved from cdb to mysql. (it's much faster and > went seemingly easy.. but) > > [EMAIL PROTECTED] [~]# 11 > telnet localhost 110 > Trying 127.0.0.1... > Connected to localhost > Escape character is '^]'. > +OK <[EMAIL PROTECTED]> > user user > +OK > pass pass > vmysql: sql error[3]: Table 'vpopmail.users' doesn't exist > -ERR authorization failed > Connection closed by foreign host. > > and yes it's true the users table does not exist in the mysql vpopmail > database, also when people with virtual domains try and login as > postmaster from an alias'd domain it gives them a simmilar error. > > This is what I have from a make configure: > > vpopmail 5.3.20 > Current settings > --- > > vpopmail directory = /usr/local/vpopmail > uid = 89 > gid = 89 >ip alias = OFF --enable-ip-alias-domains=n (default) > address extentions = ON --enable-qmail-ext=y > rebuild tcpserver file = YES --enable-rebuild-tcpserver-file=y (default) > roaming users = ON --enable-roaming-users=y > tcpserver file = /usr/local/vpopmail/etc/tcp.smtp > open_smtp file = /usr/local/vpopmail/etc/open-smtp > user quota = 1048576S -enable-hardquota=1048576S > domain quotas = OFF --enable-domainquotas=n (default) > auth module = mysql --enable-mysql=y > mysql replication = OFF --enable-mysql-replication=n (default) > table optimization = one domain with many users --enable-many-domains=n >system passwords = ON --enable-passwd=y >file locking = ON --enable-file-locking=y (default) > file sync = OFF --enable-file-sync=n disable vdelivermail fsync > (default) > make seekable = ON --enable-make-seekable=y (default) >auth logging = ON --enable-auth-logging=y (default) > mysql logging = ON --enable-mysql-logging=y >clear passwd = ON --enable-clear-passwd=y (default) > users big dir = ON --enable-users-big-dir=y (default) > valias processing = ON --enable-valias=y >mysql limits = OFF --enable-mysql-limits=n (default) > pop syslog = show failure attempts with clear text password > --enable-logging=p > default domain = --enable-default-domain= >auth inc = -I/usr/local/include/mysql >auth lib = -L/usr/local/lib/mysql -lmysqlclient -lz > > mysql> show tables; > ++ > | Tables_in_vpopmail | > ++ > | dir_control| > | lastauth | > | limits | > | relay | > | valias | > | vlog | > ++ > > this is a result of show tables; with my domains removed. (there are > about 45-50 of them) > > Clues or suggestions would be -greatly- appreciated. > > > > > > >
Re: [vchkpw] wondering what I did wrong..
Brian wrote: vpopmail 5.3.20 from FreeBSD ports collection. it *was* a cdb based setup and I've recently moved from cdb to mysql. (it's much faster and went seemingly easy.. but) [EMAIL PROTECTED] [~]# 11 > telnet localhost 110 Trying 127.0.0.1... Connected to localhost Escape character is '^]'. +OK <[EMAIL PROTECTED]> user user +OK pass pass vmysql: sql error[3]: Table 'vpopmail.users' doesn't exist -ERR authorization failed Connection closed by foreign host. and yes it's true the users table does not exist in the mysql vpopmail database, also when people with virtual domains try and login as postmaster from an alias'd domain it gives them a simmilar error. Did you convert all the accounts over to MySQL? I think there's a script to do that... -- Aj. Systems Administrator / Developer
