Re: [qmailtoaster] mysql vpopmail user not logging in

Jean-Paul van de Plasse Thu, 26 Apr 2007 05:54:19 -0700

don't forget to flush privileges;
on your mysql command line.

JP

----- Original Message -----From: <[EMAIL PROTECTED]>

To: <[email protected]>
Sent: Thursday, April 26, 2007 2:46 PM
Subject: Re: [qmailtoaster] mysql vpopmail user not logging in

First I'd like to ask if it is necessary to have two vpopmail users. Doesit 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' (usingpassword: 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' (usingpassword: 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 uservpopmail see if that works (if it does, the password is encrypted finethen) [EMAIL PROTECTED] wrote: > Higuys, > > > > Jean Paul: Mysql db is on mailhost2, I'm workinglocally. > > Philip: I did a query to mysql.user and found that Ialready have TWICE user vpopmail, once with Host value 'localhost' and thesecond with 'mailhost2' value. Should this cause any kind of conflict oras you suggest I can have both solutions? (But still notworking...) > > > >Marcos > > > > > > > > > > > > > >--- On Thu 04/26, Philip < [EMAIL PROTECTED] > wrote: > > From: Philip[mailto: [EMAIL PROTECTED] > > To:[email protected] > > Date: Thu, 26 Apr 200713:50:59 +0200 > > Subject: Re: [qmailtoaster] mysql vpopmail usernot loggingin > > > > I ment - readd it in case you did a typo andcheck the mysql.user table, make sure the vpopmail user has as Host mailhost2 (if that's what you want) . would be better to uselocahost 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 serverand change password there > or do it through mysqladmin commandline > > > [EMAIL PROTECTED] wrote: >> Still sameproblem: >> >> >> >> # mysql -u vpopmail -pqwerty vpopmail -hmailhost2 >> >> 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 Apr2007 13:19:43 +0200 >> >> Subject: Re: [qmailtoaster] mysql vpopmailuser not logging in >> >> >> >> If you try : mysql -uvpopmail -pqwerty vpopmail -h >> mailhost2 It shouldwork. 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 loggingin > > > > Hi, > > I > >> have installedqmail 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 commandcreates and gives all privileges > to vpopmail >> on db >vpopmail.Right? > > The vpopmail database > >> alreadyexists 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 theWeb! >> >> >> >> --------------------------------------------------------------------- >>QmailToaster hosted by: VR Hosted<http://www.vr.org> >> --------------------------------------------------------------------- >>To unsubscribe, e-mail:[EMAIL PROTECTED] >> For additionalcommands, e-mail:[EMAIL PROTECTED] >> >> >> > > > --------------------------------------------------------------------- >QmailToaster hosted by: VR Hosted <http://www.vr.org> > > --------------------------------------------------------------------- >To unsubscribe, e-mail:[EMAIL PROTECTED] > For additionalcommands, e-mail:[EMAIL PROTECTED] > > --------------------------------------------------------------------- QmailToaster hosted by: VR Hosted<http://www.vr.org> --------------------------------------------------------------------- Tounsubscribe, e-mail: [EMAIL PROTECTED] Foradditional commands, e-mail:[EMAIL PROTECTED] > >_______________________________________________ > Join Excite! -http://www.excite.com > The most personalized portal on theWeb! > > > >--------------------------------------------------------------------- >QmailToaster hosted by: VR Hosted<http://www.vr.org> > --------------------------------------------------------------------- >To unsubscribe, e-mail:[EMAIL PROTECTED] > For additionalcommands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- QmailToaster hosted by: VR Hosted<http://www.vr.org> --------------------------------------------------------------------- Tounsubscribe, e-mail: [EMAIL PROTECTED] Foradditional 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