Re: [qmailtoaster] mysql vpopmail user not logging in

Philip Thu, 26 Apr 2007 05:53:40 -0700

It isnt necessary
specially if it is all local, localhost should be enough



[EMAIL PROTECTED] wrote:

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 You can have both if it is a host issue ... (looks weird though) try as a testing purpose to have % as Host for the user vpopmail see if that works (if it does, the password is encrypted fine then) [EMAIL PROTECTED] wrote: > 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 loggingin > > > > I ment - readd it in case you did a typo and check the mysql.user table, make sure the vpopmail user has as Host mailhost2 (if that's what you want) . would be better to use locahost or add both once with TO [EMAIL PROTECTED] ... and TO [EMAIL PROTECTED] ... Philip wrote: > Hello Mark > did you change the password within mysql ? > log into your mysql server and change password there > or do it through mysqladmin command line > > > [EMAIL PROTECTED] wrote: >> Still same problem: >> >> >> >> # mysql -u vpopmail -pqwerty vpopmail -h mailhost2 >> >> ERROR 1045 (28000): Access denied for user 'vpopmail'@'localhost' >> (using password: YES) >> >> >> >> >> >> >> >> >> >> >> >> >> >> --- On Thu 04/26, Jean-Paul van de Plasse < [EMAIL PROTECTED] > >> wrote: >> >> From: Jean-Paul van de Plasse [mailto: [EMAIL PROTECTED] >> >>To: > [email protected] >> >> Date: Thu, 26 Apr 2007 13:19:43 +0200 >> >> Subject: Re: [qmailtoaster] mysql vpopmail user not logging in >> >> >> >> If you try : mysql -u vpopmail -pqwerty vpopmail -h >> mailhost2 It should work. JP ----- Original >> Message ----- From: <[EMAIL PROTECTED]> To: >> <[email protected]> Sent: Thursday, April 26, >> 2007 12:51 PM Subject: Re: [qmailtoaster] mysql vpopmail user not >> logging in > > Hi Jean Paul, > > I just did the >> change in the vpopmail.mysql file and now the contents of > the >> file are: > > mailhost2|0|vpopmail|qwerty|vpopmail > > I >> stopped and started again the Mysql server with: > > # >> /etc/init.d/mysqld stop > # /etc/init.d/mysqld start > > >> Then I tried again but I had the same error: > > # mysql -u >> vpopmail-pqwerty > vpopmail > ERROR 1045 (28000): Access denied for >> user 'vpopmail'@'localhost' (using > password: YES) > > Any >> idea? > > Marcos > > > > --- On Thu 04/26, >> Jean-Paul van de Plasse < [EMAIL PROTECTED] > wrote: > From: >> Jean-Paul van de Plasse [mailto: [EMAIL PROTECTED] > To: >> [email protected] > Date: Thu, 26 Apr 2007 >> 12:34:12 +0200 > Subject: Re: [qmailtoaster] mysql vpopmail user >> not logging in > > Hi, The difference is >> [EMAIL PROTECTED] versus > [EMAIL PROTECTED] Either >> change your grant to > [EMAIL PROTECTED] or change your >> vpopmail.mysql from localhost to > >> mailhost2 JP ----- Original Message ----- From: >> > <[EMAIL PROTECTED]> To: >> <[email protected]> Sent: > Thursday, April >> 26, 2007 12:30 PM Subject: [qmailtoaster]mysql > > vpopmail >> user not logging in > > > > Hi, > > I > >> have installed qmail toaster on fedora core 6.I want to use the MySql >> > > solution for relay so I did the following: > > I >> run the > mysql-setup.sh script with this >> modifications. > > GRANT ALL > PRIVILEGES ON vpopmail.* TO >> [EMAIL PROTECTED] identified by > > 'qwerty'; > > I >> guess this command creates and gives all privileges > to vpopmail >> on db > vpopmail.Right? > > The vpopmail database > >> already exists with all its tables. > > The problem now is that >> when > I try to log in to check if > everything is ok > I >> have the following error: > > # mysql -u > vpopmail >> -pqwerty vpopmail > ERROR 1045 (28000): Access denied for user >> > 'vpopmail'@'localhost' (using > password: >> YES) > > >Does > anybody > knows what is wrong >> here? > > Marcos > > > > > >> _______________________________________________ > 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] > > > >> --------------------------------------------------------------------- >> > QmailToaster hosted by: VR Hosted > >><http://www.vr.org> --------------------------------------------------------------------- To >> > > unsubscribe, e-mail: >> [EMAIL PROTECTED] For > >> additional commands, e-mail: > >> [EMAIL PROTECTED] > > >> _______________________________________________ > 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] > > >> --------------------------------------------------------------------- >> QmailToaster hosted by: VR Hosted >> > <http://www.vr.org> --------------------------------------------------------------------- To >> unsubscribe, e-mail: >> [EMAIL PROTECTED] For additional >> commands, e-mail: [EMAIL PROTECTED] >> >> _______________________________________________ >> 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] >> >> >> > > > --------------------------------------------------------------------- > QmailToaster hosted by: VR Hosted <http://www.vr.org> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- QmailToaster hosted by: VR Hosted <http://www.vr.org> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] > > _______________________________________________ > 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] > > > --------------------------------------------------------------------- QmailToaster hosted by: VR Hosted <http://www.vr.org> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] 
_______________________________________________
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]



---------------------------------------------------------------------
    QmailToaster hosted by: VR Hosted <http://www.vr.org>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [qmailtoaster] mysql vpopmail user not logging in

Reply via email to