First I'd like to ask if it is necessary to have two vpopmail users. Does it
make any sense? why not only one with Host mailhost2 ?
Second I changed the vpopmail user who has Host "localhost" to "%"
mysql> update user set Host='%' where Host='localhost';
Query OK, 3 rows affected (0.00 sec)
Rows matched: 3 Changed: 3 Warnings: 0
Exited from mysql and tried again but...
# mysql -u vpopmail -pqwerty
ERROR 1045 (28000): Access denied for user 'vpopmail'@'localhost' (using
password: YES)
# mysql -u vpopmail -pqwerty -h mailhost2
ERROR 1045 (28000): Access denied for user 'vpopmail'@'mailhost2.adacom.com'
(using password: YES)
# mysql -u vpopmail -pqwerty -h localhost
ERROR 1045 (28000): Access denied for user 'vpopmail'@'localhost' (using
password: YES)
--- On Thu 04/26, Philip < [EMAIL PROTECTED] > wrote:
From: Philip [mailto: [EMAIL PROTECTED]
To: [email protected]
Date: Thu, 26 Apr 2007 14:32:47 +0200
Subject: Re: [qmailtoaster] mysql vpopmail user not logging in
Hey<br>You can have both<br>if it is a host issue ... (looks weird though) try
as a testing purpose <br>to have % as Host for the user vpopmail<br>see if that
works (if it does, the password is encrypted fine then)<br><br><br>[EMAIL
PROTECTED] wrote:<br>> Hi guys,<br>><br>><br>><br>> Jean Paul: Mysql db is on
mailhost2, I'm working locally.<br>><br>> Philip: I did a query to mysql.user
and found that I already have TWICE user vpopmail, once with Host value
'localhost' and the second with 'mailhost2' value. Should this cause any kind
of conflict or as you suggest I can have both solutions? (But still not
working...)<br>><br>><br>><br>>
Marcos<br>><br>><br>><br>><br>><br>><br>><br>><br>><br>><br>><br>><br>><br>>
--- On Thu 04/26, Philip < [EMAIL PROTECTED] > wrote:<br>><br>> From: Philip
[mailto: [EMAIL PROTECTED]<br>><br>> To:
[email protected]<br>><br>> Date: Thu, 26 Apr 2007 13:50:59
+0200<br>><br>> Subject: Re: [qmailtoaster] mysql vpopmail user not logging
in<br>><br>><br>><br>> I ment - readd it in case you did a typo<br>and check
the mysql.user table, make sure the vpopmail user has as Host
<br>mailhost2<br>(if that's what you want) . would be better to use locahost or
add both<br>once with TO [EMAIL PROTECTED] ... and TO [EMAIL PROTECTED]
...<br><br><br><br>Philip wrote:<br>> Hello Mark<br>> did you change the
password within mysql ?<br>> log into your mysql server and change password
there<br>> or do it through mysqladmin command line<br>><br>><br>> [EMAIL
PROTECTED] wrote:<br>>> Still same problem:<br>>><br>>><br>>><br>>> # mysql -u
vpopmail -pqwerty vpopmail -h mailhost2<br>>><br>>> ERROR 1045 (28000): Access
denied for user 'vpopmail'@'localhost' <br>>> (using password:
YES)<br>>><br>>><br>>><br>>><br>>><br>>><br>>><br>>><br>>><br>>><br>>><br>>><br>>><br>>>
--- On Thu 04/26, Jean-Paul van de Plasse < [EMAIL PROTECTED] > <br>>>
wrote:<br>>><br>>> From: Jean-Paul van de Plasse [mailto: [EMAIL
PROTECTED]<br>>><br>>>
To: <br>> [email protected]<br>>><br>>> Date: Thu, 26 Apr 2007
13:19:43 +0200<br>>><br>>> Subject: Re: [qmailtoaster] mysql vpopmail user not
logging in<br>>><br>>><br>>><br>>> If you try :<br>mysql -u vpopmail -pqwerty
vpopmail -h <br>>> mailhost2<br><br>It should work.<br><br>JP<br><br>-----
Original <br>>> Message ----- <br>From: <[EMAIL PROTECTED]><br>To: <br>>>
<[email protected]><br>Sent: Thursday, April 26, <br>>> 2007
12:51 PM<br>Subject: Re: [qmailtoaster] mysql vpopmail user not <br>>> logging
in<br><br><br>><br>> Hi Jean Paul,<br>><br>> I just did the <br>>> change in
the vpopmail.mysql file and now the contents of <br>> the <br>>> file
are:<br>><br>> mailhost2|0|vpopmail|qwerty|vpopmail<br>><br>> I <br>>> stopped
and started again the Mysql server with:<br>><br>> # <br>>> /etc/init.d/mysqld
stop<br>> # /etc/init.d/mysqld start<br>><br>> <br>>> Then I tried again but I
had the same error:<br>><br>> # mysql -u <br>>> vpopmail
-pqwerty <br>> vpopmail<br>> ERROR 1045 (28000): Access denied for <br>>> user
'vpopmail'@'localhost' (using <br>> password: YES)<br>><br>> Any <br>>>
idea?<br>><br>> Marcos<br>><br>><br>><br>> --- On Thu 04/26, <br>>> Jean-Paul
van de Plasse < [EMAIL PROTECTED] > wrote:<br>> From: <br>>> Jean-Paul van de
Plasse [mailto: [EMAIL PROTECTED]<br>> To: <br>>>
[email protected]<br>> Date: Thu, 26 Apr 2007 <br>>> 12:34:12
+0200<br>> Subject: Re: [qmailtoaster] mysql vpopmail user <br>>> not logging
in<br>><br>> Hi,<br><br>The difference is <br>>> [EMAIL PROTECTED] versus <br>>
[EMAIL PROTECTED]<br><br>Either <br>>> change your grant to <br>> [EMAIL
PROTECTED]<br>or change your <br>>> vpopmail.mysql from localhost to <br>>
<br>>> mailhost2<br><br>JP<br><br>----- Original Message ----- <br>From: <br>>>
<br>> <[EMAIL PROTECTED]><br>To: <br>>>
<[email protected]><br>Sent: <br>> Thursday, April <br>>> 26,
2007 12:30 PM<br>Subject: [qmailtoaster]
mysql <br>> <br>> vpopmail <br>>> user not logging
in<br><br><br>><br>><br>><br>> Hi,<br>><br>> I <br>> <br>>> have installed
qmail toaster on fedora core 6.I want to use the MySql <br>>> <br>> <br>>
solution for relay so I did the following:<br>><br>> I <br>>> run the <br>>
mysql-setup.sh script with this <br>>> modifications.<br>><br>> GRANT ALL <br>>
PRIVILEGES ON vpopmail.* TO <br>>> [EMAIL PROTECTED] identified by <br>> <br>>
'qwerty';<br>><br>> I <br>>> guess this command creates and gives all
privileges <br>> to vpopmail <br>>> on db <br>> vpopmail.Right?<br>><br>> The
vpopmail database <br>> <br>>> already exists with all its tables.<br>><br>>
The problem now is that <br>>> when <br>> I try to log in to check if<br>>
everything is ok <br>> I <br>>> have the following error:<br>><br>> # mysql -u
<br>> vpopmail <br>>> -pqwerty vpopmail<br>> ERROR 1045 (28000): Access denied
for user <br>>> <br>> 'vpopmail'@'localhost' (using <br>> password: <br>>>
YES)<br>><br>><br>>
Does <br>> anybody <br>> knows what is wrong <br>>> here?<br>><br>>
Marcos<br>><br>><br>><br>> <br>> <br>>>
_______________________________________________<br>> Join Excite! - <br>>>
<br>> http://www.excite.com<br>> The most personalized portal on the <br>>>
<br>> Web!<br>><br>><br>><br>> <br>>>
---------------------------------------------------------------------<br>>
<br>>> <br>> QmailToaster hosted by: VR Hosted <br>> <br>>>
<http://www.vr.org><br>> <br>>>
---------------------------------------------------------------------<br>>
<br>>> <br>> To unsubscribe, e-mail: <br>> <br>>> [EMAIL PROTECTED]<br>> For
additional <br>>> <br>> commands, e-mail: <br>>> [EMAIL PROTECTED]<br>><br>>
<br>> <br>>>
<br><br><br>---------------------------------------------------------------------<br>
<br>>> <br>> QmailToaster hosted by: VR Hosted<br>> <br>>>
<http://www.vr.org><br>---------------------------------------------------------------------<br>To
<br>>> <br>> <br>> unsubscribe, e-mail: <br>>> [EMAIL PROTECTED]<br>For <br>>
<br>>> additional commands, e-mail: <br>> <br>>> [EMAIL
PROTECTED]<br><br><br>><br>> <br>>>
_______________________________________________<br>> Join Excite! - <br>>>
http://www.excite.com<br>> The most personalized portal on the <br>>>
Web!<br>><br>><br>><br>> <br>>>
---------------------------------------------------------------------<br>>
<br>>> QmailToaster hosted by: VR Hosted <http://www.vr.org><br>> <br>>>
---------------------------------------------------------------------<br>>
<br>>> To unsubscribe, e-mail: <br>>> [EMAIL PROTECTED]<br>> For additional
<br>>> commands, e-mail: [EMAIL PROTECTED]<br>><br>> <br>>>
<br><br><br>---------------------------------------------------------------------<br>
<br>>> QmailToaster hosted by: VR Hosted <br>>> <br>>
<http://www.vr.org><br>---------------------------------------------------------------------<br>To
<br>>> unsubscribe, e-mail: <br>>> [EMAIL PROTECTED]<br>For additional <br>>>
commands, e-mail: [EMAIL PROTECTED]<br><br><br>>><br>>>
_______________________________________________<br>>> Join Excite! -
http://www.excite.com<br>>> The most personalized portal on the
Web!<br>>><br>>><br>>><br>>>
---------------------------------------------------------------------<br>>>
QmailToaster hosted by: VR Hosted <http://www.vr.org><br>>>
---------------------------------------------------------------------<br>>> To
unsubscribe, e-mail: [EMAIL PROTECTED]<br>>> For additional commands, e-mail:
[EMAIL PROTECTED]<br>>><br>>><br>>>
<br>><br>><br>>
---------------------------------------------------------------------<br>>
QmailToaster hosted by: VR Hosted <http://www.vr.org><br>> <br>>
---------------------------------------------------------------------<br>> To
unsubscribe, e-mail: [EMAIL PROTECTED]<br>> For additional commands, e-mail:
[EMAIL
PROTECTED]<br>><br>><br><br>---------------------------------------------------------------------<br>
QmailToaster hosted by: VR Hosted
<http://www.vr.org><br>---------------------------------------------------------------------<br>To
unsubscribe, e-mail: [EMAIL PROTECTED]<br>For additional commands, e-mail:
[EMAIL PROTECTED]<br><br><br>><br>>
_______________________________________________<br>> Join Excite! -
http://www.excite.com<br>> The most personalized portal on the
Web!<br>><br>><br>><br>>
---------------------------------------------------------------------<br>>
QmailToaster hosted by: VR Hosted <http://www.vr.org><br>>
---------------------------------------------------------------------<br>> To
unsubscribe, e-mail: [EMAIL PROTECTED]<br>> For additional commands, e-mail:
[EMAIL PROTECTED]<br>><br>><br>>
<br><br><br>---------------------------------------------------------------------<br>
QmailToaster hosted by: VR Hosted
<http://www.vr.org><br>---------------------------------------------------------------------<br>To
unsubscribe, e-mail: [EMAIL PROTECTED]<br>For additional commands, e-mail:
[EMAIL PROTECTED]<br><br>
_______________________________________________
Join Excite! - http://www.excite.com
The most personalized portal on the Web!
---------------------------------------------------------------------
QmailToaster hosted by: VR Hosted <http://www.vr.org>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
