Brian wrote:
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.Thanx for your help,
I found sampels for smale, medium, large and huge systems. Now I have something to do ;-)
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!
