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="xxxxxx", 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="xxxxxx", 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, 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!
>
>
