Re: [vchkpw] vchkpw with mysql
thanx Tom ... I use the Debian (woody) qmail-src to build my qmail. I found the link to the new smtp-auth patch on the qmail-site .. http://www.fehcom.de/qmail/smtpauth.html#PATCHES Thanx Tom Brian ;-) - Original Message - From: "Tom Collins" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 26, 2004 10:37 PM Subject: Re: [vchkpw] vchkpw with mysql > On Aug 26, 2004, at 1:02 PM, Brian wrote: > > I use the smtp-auth patch 0.31 release from > > http://members.elysium.pl/brush/qmail-smtpd-auth/ > > > > it's the newest one and the project is stopped. what can I do ? > > Use the 0.42 patch from the contrib directory in the vpopmail source. > > -- > Tom Collins - [EMAIL PROTECTED] > QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ > Info on the Sniffter hand-held Network Tester: http://sniffter.com/ > >
Re: [vchkpw] vchkpw with mysql
On Aug 26, 2004, at 1:02 PM, Brian wrote: I use the smtp-auth patch 0.31 release from http://members.elysium.pl/brush/qmail-smtpd-auth/ it's the newest one and the project is stopped. what can I do ? Use the 0.42 patch from the contrib directory in the vpopmail source. -- Tom Collins - [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ Info on the Sniffter hand-held Network Tester: http://sniffter.com/
Re: [vchkpw] vchkpw with mysql
Hello, it's me again. new Version of vpopmail has in UPGRADE file a note .. problems with SMTP-AUTH. I think, I have this problem .. (thanx to my test maschine) :-) I use the smtp-auth patch 0.31 release from http://members.elysium.pl/brush/qmail-smtpd-auth/ it's the newest one and the project is stopped. what can I do ? Thanx, Brian - Original Message - From: "Tom Collins" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 25, 2004 4:41 PM Subject: Re: [vchkpw] vchkpw with mysql On Aug 25, 2004, at 4:40 AM, Brian wrote: > the request try to create the database .. ?? Upgrade to 5.4.5 or later (it would be best to go to 5.4.6 due to a security fix in that release). At some point in the 5.3.x series, the MySQL code to connect to the database got changed around in a way that could result in the errors you see when MySQL was heavily loaded. The change introduced in 5.4.5 (by Françoi Wautier) uses an improved method. -- Tom Collins - [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ Info on the Sniffter hand-held Network Tester: http://sniffter.com/
Re: [vchkpw] vchkpw with mysql
Thanx Tom. current I use 5.4.0 . I try to update it to 5.4.6. Cheers, Brian - Original Message - From: "Tom Collins" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 25, 2004 4:41 PM Subject: Re: [vchkpw] vchkpw with mysql On Aug 25, 2004, at 4:40 AM, Brian wrote: > the request try to create the database .. ?? Upgrade to 5.4.5 or later (it would be best to go to 5.4.6 due to a security fix in that release). At some point in the 5.3.x series, the MySQL code to connect to the database got changed around in a way that could result in the errors you see when MySQL was heavily loaded. The change introduced in 5.4.5 (by Françoi Wautier) uses an improved method. -- Tom Collins - [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ Info on the Sniffter hand-held Network Tester: http://sniffter.com/
Re: [vchkpw] vchkpw with mysql
Brian wrote: That' not the problem, Dave .. I still have the same problem .. Error message in outlook There was a problem logging onto your mail server. Your Password was rejected. Account: 'Kai', Server: 'smtp.mydomain.tld', Protocol: POP3, Server Response: 'vmysql: sql error[1]: Can't create database 'MyMailDB'. Database exists', Port: 110, Secure(SSL): No, Server Error: 0x800CCC90, Error Number: 0x800CCC92 the request try to create the database .. ?? Ahh, shame on me for not asking for more specifics about the error. I believe Mr, Collins has given you the answer you are looking for. DAve error message in logfile 430 Connect [EMAIL PROTECTED] on 430 Query create database mailuserdb 430 Query INSERT INTO vlog set user="name", passwd="xx", domain="mydomain.tld", [EMAIL PROTECTED], remoteip="80.184.xxx.xx", message="vchkpw-pop3: vpopmail user not found [EMAIL PROTECTED]:80.184.xx.xxx", error=1, timestamp=1093432933 430 Query CREATE TABLE vlog ( id BIGINT PRIMARY KEY AUTO_INCREMENT, user char(32), passwd CHAR(32), domain CHAR(64), logon VARCHAR(200), remoteip char(18), message VARCHAR(255), timestamp bigint default 0 NOT NULL, error INT, INDEX user_idx (user), INDEX domain_idx (domain), INDEX remoteip_idx (remoteip), INDEX error_idx (error), INDEX message_idx (message) ) 430 Query INSERT INTO vlog set user="name", passwd="xx", domain="friends69.com", logon="[EMAIL PROTECTED]", remoteip="80.184.xxx.xx", message="vchkpw-pop3: vpopmail user not found [EMAIL PROTECTED]:80.184.xx.xxx", error=1, timestamp=1093432933 430 Quit when everything is ok, it look like the follow, 040825 11:26:57 435 Connect [EMAIL PROTECTED] on mailuserdb 435 Query select pw_name, pw_passwd, pw_uid, pw_gid, pw_gecos, pw_dir, pw_shell from bihaatch_com where pw_name = "user" 435 Query replace into lastauth set user="user", domain="mydomain.tld", remote_ip="80.184.xxx.xx", timestamp=1093433217 It shows like the vpopmail try to create the database ... why ?? I try 10 times to recive my mail ... 9 are successfully. one time i have this problem.. cheers, brian - Original Message - From: "Dave Goodrich" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 25, 2004 12:13 AM Subject: Re: [vchkpw] vchkpw with mysql Brian wrote: Thanx for your help, I found sampels for smale, medium, large and huge systems. Now I have something to do ;-) No problem. I would suggest though if you are new to MySQL you first get vpopmail and qmail up and running, learn them and what they can do before you add MySQL auth. Other than ease of dealing with large numbers of users, there is no real advantage to using MySQL IMO. I found the standard vpopmail using cdb to very reliable, robust and quite fast. We only moved to MySQL auth to gain a better interface for user/domain management. DAve in debian is it in /usr/share/doc/mysql-server/examples/ thanx, Brian - Original Message - From: "Dave Goodrich" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 24, 2004 8:33 PM Subject: Re: [vchkpw] vchkpw with mysql Brian wrote: current my settings on my debian host key_buffer= 16M max_allowed_packet = 1M that's the only places where I can change something .. Where is this? /etc/my.cnf? There are a lot of tunable vars that can be set in your my.cnf file. Look in your MySQL source, maybe in /usr/local/share/mysql, there are some sample *.cnf files in there. A lot depends on how much memory your system has, and how much it is using. right to change this? I'm not a mysql professional :-( Sure, that is why it is there. Just make sure you know what you are changing, I'm no MySQL guru either. I would first get your bin log running and see what is going on with the mysql daemon. The select may not even be happening which is what I saw. http://dev.mysql.com/doc/mysql/en/Binary_log.html I'm no expert and may not be the best person to guide you through this ;^) DAve thanx for your help, Brian - Original Message - From: "Dave Goodrich" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 24, 2004 7:52 PM Subject: Re: [vchkpw] vchkpw with mysql I have seen some similar issues with using vpopmail and MySQL. Most notably a failure to authenticate becasue MySQL doesn't respond correctly. Not sure if it was timing out or what. The solution was to give MySQL more resources over the default install. I upped my key, index, and table cache,
Re: [vchkpw] vchkpw with mysql
On Aug 25, 2004, at 4:40 AM, Brian wrote: the request try to create the database .. ?? Upgrade to 5.4.5 or later (it would be best to go to 5.4.6 due to a security fix in that release). At some point in the 5.3.x series, the MySQL code to connect to the database got changed around in a way that could result in the errors you see when MySQL was heavily loaded. The change introduced in 5.4.5 (by Françoi Wautier) uses an improved method. -- Tom Collins - [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ Info on the Sniffter hand-held Network Tester: http://sniffter.com/
Re: [vchkpw] vchkpw with mysql
That' not the problem, Dave .. I still have the same problem .. Error message in outlook There was a problem logging onto your mail server. Your Password was rejected. Account: 'Kai', Server: 'smtp.mydomain.tld', Protocol: POP3, Server Response: 'vmysql: sql error[1]: Can't create database 'MyMailDB'. Database exists', Port: 110, Secure(SSL): No, Server Error: 0x800CCC90, Error Number: 0x800CCC92 the request try to create the database .. ?? error message in logfile 430 Connect [EMAIL PROTECTED] on 430 Query create database mailuserdb 430 Query INSERT INTO vlog set user="name", passwd="xx", domain="mydomain.tld", [EMAIL PROTECTED], remoteip="80.184.xxx.xx", message="vchkpw-pop3: vpopmail user not found [EMAIL PROTECTED]:80.184.xx.xxx", error=1, timestamp=1093432933 430 Query CREATE TABLE vlog ( id BIGINT PRIMARY KEY AUTO_INCREMENT, user char(32), passwd CHAR(32), domain CHAR(64), logon VARCHAR(200), remoteip char(18), message VARCHAR(255), timestamp bigint default 0 NOT NULL, error INT, INDEX user_idx (user), INDEX domain_idx (domain), INDEX remoteip_idx (remoteip), INDEX error_idx (error), INDEX message_idx (message) ) 430 Query INSERT INTO vlog set user="name", passwd="xx", domain="friends69.com", logon="[EMAIL PROTECTED]", remoteip="80.184.xxx.xx", message="vchkpw-pop3: vpopmail user not found [EMAIL PROTECTED]:80.184.xx.xxx", error=1, timestamp=1093432933 430 Quit when everything is ok, it look like the follow, 040825 11:26:57 435 Connect [EMAIL PROTECTED] on mailuserdb 435 Query select pw_name, pw_passwd, pw_uid, pw_gid, pw_gecos, pw_dir, pw_shell from bihaatch_com where pw_name = "user" 435 Query replace into lastauth set user="user", domain="mydomain.tld", remote_ip="80.184.xxx.xx", timestamp=1093433217 It shows like the vpopmail try to create the database ... why ?? I try 10 times to recive my mail ... 9 are successfully. one time i have this problem.. cheers, brian - Original Message - From: "Dave Goodrich" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 25, 2004 12:13 AM Subject: Re: [vchkpw] vchkpw with mysql > Brian wrote: > > > Thanx for your help, > > > > I found sampels for smale, medium, large and huge systems. Now I have > > something to do ;-) > > > No problem. I would suggest though if you are new to MySQL you first get > vpopmail and qmail up and running, learn them and what they can do > before you add MySQL auth. > > Other than ease of dealing with large numbers of users, there is no real > advantage to using MySQL IMO. I found the standard vpopmail using cdb to > very reliable, robust and quite fast. We only moved to MySQL auth to > gain a better interface for user/domain management. > > DAve > > > > in debian is it in /usr/share/doc/mysql-server/examples/ > > > > thanx, Brian > > > > > > - Original Message - > > From: "Dave Goodrich" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Tuesday, August 24, 2004 8:33 PM > > Subject: Re: [vchkpw] vchkpw with mysql > > > > > > > >>Brian wrote: > >> > >> > >>>current my settings on my debian host > >>> > >>>key_buffer= 16M > >>>max_allowed_packet = 1M > >>> > >>>that's the only places where I can change something .. > >> > >>Where is this? /etc/my.cnf? There are a lot of tunable vars that can be > >>set in your my.cnf file. Look in your MySQL source, maybe in > >>/usr/local/share/mysql, there are some sample *.cnf files in there. A > >>lot depends on how much memory your system has, and how much it is using. > >> > >> > >>>right to change this? I'm not a mysql professional :-( > >> > >>Sure, that is why it is there. Just make sure you know what you are > >>changing, I'm no MySQL guru either. > >> > >>I would first get your bin log running and see what is going on with the > >>mysql daemon. The select may not even be happening which is what I saw. > >> > >>http://dev.mysql.com/doc/mysql/en/Binary_log.html > >> > >>I'm no expert and may not be the best person to guide you through this ;^) > >> > >>DAve > >
Re: [vchkpw] vchkpw with mysql
Brian wrote: Thanx for your help, I found sampels for smale, medium, large and huge systems. Now I have something to do ;-) No problem. I would suggest though if you are new to MySQL you first get vpopmail and qmail up and running, learn them and what they can do before you add MySQL auth. Other than ease of dealing with large numbers of users, there is no real advantage to using MySQL IMO. I found the standard vpopmail using cdb to very reliable, robust and quite fast. We only moved to MySQL auth to gain a better interface for user/domain management. DAve in debian is it in /usr/share/doc/mysql-server/examples/ thanx, Brian - Original Message - From: "Dave Goodrich" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 24, 2004 8:33 PM Subject: Re: [vchkpw] vchkpw with mysql Brian wrote: current my settings on my debian host key_buffer= 16M max_allowed_packet = 1M that's the only places where I can change something .. Where is this? /etc/my.cnf? There are a lot of tunable vars that can be set in your my.cnf file. Look in your MySQL source, maybe in /usr/local/share/mysql, there are some sample *.cnf files in there. A lot depends on how much memory your system has, and how much it is using. right to change this? I'm not a mysql professional :-( Sure, that is why it is there. Just make sure you know what you are changing, I'm no MySQL guru either. I would first get your bin log running and see what is going on with the mysql daemon. The select may not even be happening which is what I saw. http://dev.mysql.com/doc/mysql/en/Binary_log.html I'm no expert and may not be the best person to guide you through this ;^) DAve thanx for your help, Brian - Original Message - From: "Dave Goodrich" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 24, 2004 7:52 PM Subject: Re: [vchkpw] vchkpw with mysql I have seen some similar issues with using vpopmail and MySQL. Most notably a failure to authenticate becasue MySQL doesn't respond correctly. Not sure if it was timing out or what. The solution was to give MySQL more resources over the default install. I upped my key, index, and table cache, increased my thread cache, now I have no problems. I use MySQL heavliy though, three cluster machines hitting it all day, plus spamassassin uses it as well. YMMV. DAve Brian wrote: Hello List, I have installed vpopmail with mysql-support. It's running well but sometimes my mail client ask about username and password. Error message is the user is not found. vpopmail[1003]: vchkpw-pop3: vpopmail user not found [EMAIL PROTECTED]:99.99.99.99 The User exist in the database and next time it's running well again. someone know this problem? thanx, Brian -- Systems Administrator http://www.tls.net Get rid of Unwanted Emails...get TLS Spam Blocker! -- Systems Administrator http://www.tls.net Get rid of Unwanted Emails...get TLS Spam Blocker! -- Systems Administrator http://www.tls.net Get rid of Unwanted Emails...get TLS Spam Blocker!
Re: [vchkpw] vchkpw with mysql
Thanx for your help, I found sampels for smale, medium, large and huge systems. Now I have something to do ;-) in debian is it in /usr/share/doc/mysql-server/examples/ thanx, Brian - Original Message - From: "Dave Goodrich" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 24, 2004 8:33 PM Subject: Re: [vchkpw] vchkpw with mysql > Brian wrote: > > > current my settings on my debian host > > > > key_buffer= 16M > > max_allowed_packet = 1M > > > > that's the only places where I can change something .. > Where is this? /etc/my.cnf? There are a lot of tunable vars that can be > set in your my.cnf file. Look in your MySQL source, maybe in > /usr/local/share/mysql, there are some sample *.cnf files in there. A > lot depends on how much memory your system has, and how much it is using. > > > > > right to change this? I'm not a mysql professional :-( > Sure, that is why it is there. Just make sure you know what you are > changing, I'm no MySQL guru either. > > I would first get your bin log running and see what is going on with the > mysql daemon. The select may not even be happening which is what I saw. > > http://dev.mysql.com/doc/mysql/en/Binary_log.html > > I'm no expert and may not be the best person to guide you through this ;^) > > DAve > > > > > > thanx for your help, Brian > > > > > > - Original Message - > > From: "Dave Goodrich" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Tuesday, August 24, 2004 7:52 PM > > Subject: Re: [vchkpw] vchkpw with mysql > > > > > > > >>I have seen some similar issues with using vpopmail and MySQL. Most > >>notably a failure to authenticate becasue MySQL doesn't respond > >>correctly. Not sure if it was timing out or what. The solution was to > >>give MySQL more resources over the default install. > >> > >>I upped my key, index, and table cache, increased my thread cache, now I > >>have no problems. I use MySQL heavliy though, three cluster machines > >>hitting it all day, plus spamassassin uses it as well. YMMV. > >> > >>DAve > >> > >>Brian wrote: > >> > >> > >>>Hello List, > >>> > >>>I have installed vpopmail with mysql-support. It's running well but > > > > sometimes my mail client ask about username and password. Error message is > > the user is not found. > > > >>>vpopmail[1003]: vchkpw-pop3: vpopmail user not found > > > > [EMAIL PROTECTED]:99.99.99.99 > > > >>> > >>>The User exist in the database and next time it's running well again. > >>> > >>>someone know this problem? > >>> > >>>thanx, Brian > >>> > >> > >>-- > >>Systems Administrator > >>http://www.tls.net > >>Get rid of Unwanted Emails...get TLS Spam Blocker! > >> > >> > > > > > > > > -- > Systems Administrator > http://www.tls.net > Get rid of Unwanted Emails...get TLS Spam Blocker! > >
Re: [vchkpw] vchkpw with mysql
Brian wrote: current my settings on my debian host key_buffer= 16M max_allowed_packet = 1M that's the only places where I can change something .. Where is this? /etc/my.cnf? There are a lot of tunable vars that can be set in your my.cnf file. Look in your MySQL source, maybe in /usr/local/share/mysql, there are some sample *.cnf files in there. A lot depends on how much memory your system has, and how much it is using. right to change this? I'm not a mysql professional :-( Sure, that is why it is there. Just make sure you know what you are changing, I'm no MySQL guru either. I would first get your bin log running and see what is going on with the mysql daemon. The select may not even be happening which is what I saw. http://dev.mysql.com/doc/mysql/en/Binary_log.html I'm no expert and may not be the best person to guide you through this ;^) DAve thanx for your help, Brian - Original Message - From: "Dave Goodrich" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 24, 2004 7:52 PM Subject: Re: [vchkpw] vchkpw with mysql I have seen some similar issues with using vpopmail and MySQL. Most notably a failure to authenticate becasue MySQL doesn't respond correctly. Not sure if it was timing out or what. The solution was to give MySQL more resources over the default install. I upped my key, index, and table cache, increased my thread cache, now I have no problems. I use MySQL heavliy though, three cluster machines hitting it all day, plus spamassassin uses it as well. YMMV. DAve Brian wrote: Hello List, I have installed vpopmail with mysql-support. It's running well but sometimes my mail client ask about username and password. Error message is the user is not found. vpopmail[1003]: vchkpw-pop3: vpopmail user not found [EMAIL PROTECTED]:99.99.99.99 The User exist in the database and next time it's running well again. someone know this problem? thanx, Brian -- Systems Administrator http://www.tls.net Get rid of Unwanted Emails...get TLS Spam Blocker! -- Systems Administrator http://www.tls.net Get rid of Unwanted Emails...get TLS Spam Blocker!
Re: [vchkpw] vchkpw with mysql
current my settings on my debian host key_buffer= 16M max_allowed_packet = 1M that's the only places where I can change something .. right to change this? I'm not a mysql professional :-( thanx for your help, Brian - Original Message - From: "Dave Goodrich" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 24, 2004 7:52 PM Subject: Re: [vchkpw] vchkpw with mysql > I have seen some similar issues with using vpopmail and MySQL. Most > notably a failure to authenticate becasue MySQL doesn't respond > correctly. Not sure if it was timing out or what. The solution was to > give MySQL more resources over the default install. > > I upped my key, index, and table cache, increased my thread cache, now I > have no problems. I use MySQL heavliy though, three cluster machines > hitting it all day, plus spamassassin uses it as well. YMMV. > > DAve > > Brian wrote: > > > Hello List, > > > > I have installed vpopmail with mysql-support. It's running well but sometimes my mail client ask about username and password. Error message is the user is not found. > > > > vpopmail[1003]: vchkpw-pop3: vpopmail user not found [EMAIL PROTECTED]:99.99.99.99 > > > > > > The User exist in the database and next time it's running well again. > > > > someone know this problem? > > > > thanx, Brian > > > > -- > Systems Administrator > http://www.tls.net > Get rid of Unwanted Emails...get TLS Spam Blocker! > >
Re: [vchkpw] vchkpw with mysql
I have seen some similar issues with using vpopmail and MySQL. Most notably a failure to authenticate becasue MySQL doesn't respond correctly. Not sure if it was timing out or what. The solution was to give MySQL more resources over the default install. I upped my key, index, and table cache, increased my thread cache, now I have no problems. I use MySQL heavliy though, three cluster machines hitting it all day, plus spamassassin uses it as well. YMMV. DAve Brian wrote: Hello List, I have installed vpopmail with mysql-support. It's running well but sometimes my mail client ask about username and password. Error message is the user is not found. vpopmail[1003]: vchkpw-pop3: vpopmail user not found [EMAIL PROTECTED]:99.99.99.99 The User exist in the database and next time it's running well again. someone know this problem? thanx, Brian -- Systems Administrator http://www.tls.net Get rid of Unwanted Emails...get TLS Spam Blocker!
[vchkpw] vchkpw with mysql
Hello List, I have installed vpopmail with mysql-support. It's running well but sometimes my mail client ask about username and password. Error message is the user is not found. vpopmail[1003]: vchkpw-pop3: vpopmail user not found [EMAIL PROTECTED]:99.99.99.99 The User exist in the database and next time it's running well again. someone know this problem? thanx, Brian