| View previous topic :: View next topic |
| Author |
Message |
Geeko
n00b
Joined: 13 Sep 2003
Posts: 21
|
 Posted: Sat Sep 13, 2003 1:11 pm Post subject: vpopmail + mysql trouble |
 |
|
Hi All,
I've installed qmail + vpopmail with vmysql from portage. Generally, I'm happy with the result, but there is a trouble: when any user tries to log in his mail account, vpopmail returns this error:
| Code: | could not connect to mysql update server Access denied for user: 'root@localhost' (Using password: YES) with database
could not connect to mysql update server Access denied for user: 'root@localhost' (Using password: YES)
could not create lastauth table 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) )
error inserting into lastauth table
-ERR authorization failed |
vpopmail is triying to acces mysql as root and with "secret" as password, the default config in vpopmail. I've edited /etc/vpopmail.conf according with my DB configuration and ALL the binaries of vpopmail (under /var/vpopmail/bin) works fine with the DB. I can add/edit/delete users and domains, but it fails at auth time. First I tried increasing the value of softlimit, but it seems not be the problem... I'am confused, because this error is only in the auth process.
Thanks
(Sorry for my english  ) |
|
| Back to top |
|
 |
el_mariel
n00b
Joined: 17 Jul 2002
Posts: 18
Location: Brazil
|
| Posted: Wed Apr 07, 2004 9:51 pm Post subject: vpopmail qmail smtp auth |
|
|
if you use vpopmail for smtp auth, check if vchkpw suid is set. If not, run the following command:
chmod u+s /var/vpopmail/bin/vchkpw
_________________
[ ]'s
Lucas Roxo Mundim
Desenvolvimento e tecnologia
lucas@zambba.com
Zambba Editorações Ltda.
http://www.zambba.com
Gentoo GNU/Linux
Linux user #232879
Machine Number 158947 |
|
| Back to top |
|
|
ito
n00b
Joined: 22 Jul 2002
Posts: 27
|
| Posted: Sun May 23, 2004 9:53 pm Post subject: qmail vpopmail smtp auth login mysql |
|
|
Hi ,
thanks .. I was working on this for a couple of hours ... !$&#@
I flew over this one ...
chmod u+s vchkpw
cheers,
-- ito |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
Networking & Security
