Hi guys,
Jean Paul: Mysql db is on mailhost2, I'm working locally. 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...) Marcos --- On Thu 04/26, Philip < [EMAIL PROTECTED] > wrote: From: Philip [mailto: [EMAIL PROTECTED] To: [email protected] Date: Thu, 26 Apr 2007 13:50:59 +0200 Subject: Re: [qmailtoaster] mysql vpopmail user not logging in 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: [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 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>> 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 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>> 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>>> <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>> 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]
