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