Re: [qmailtoaster] mysql vpopmail user not logging in

Philip Thu, 26 Apr 2007 06:38:39 -0700

You have a backup of your ex/brocken :) database you did with mysqldumpmaybe ?if you dont well,. the tables will be created when you add a newdomaim(vadddomain ...)

so you have nothing else to do


[EMAIL PROTECTED] wrote:

No, I din't alter the my.cnf file even the start script but I have good news:



I drop the vpopmail table and create it again and after that I can log in ! 
Don't ask me, I have no idea what was wrong with the old one.



The steps I follow to recreate it:



# mysqladmin create vpopmail -uroot -pqwerty

# mysqladmin -uroot -pqwerty reload

# mysqladmin -uroot -pqwerty refresh

# echo "GRANT ALL PRIVILEGES ON vpopmail.* TO [EMAIL PROTECTED] IDENTIFIED BY 
'qwerty'" | mysql -uroot -pqwerty

# mysqladmin -uroot -pqwerty reload

# mysqladmin -uroot -pqwerty refresh

# mysql -u vpopmail -pqwerty vpopmail

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 26 to server version: 5.0.27



Type 'help;' or '\h' for help. Type '\c' to clear the buffer.



mysql>





Now, at this point, should I run this to create the tables or do I need another 
intermediate step?:



CREATE TABLE relay (

ip_addr char(18) NOT NULL default '',

timestamp char(12) default NULL,

PRIMARY KEY (ip_addr)

);



Marcos







 --- On Thu 04/26, Philip < [EMAIL PROTECTED] > wrote:

From: Philip [mailto: [EMAIL PROTECTED]

To: [email protected]

Date: Thu, 26 Apr 2007 15:16:51 +0200

Subject: Re: [qmailtoaster] mysql vpopmail user not logging in
Ok hmmm you didnt install and make an update like had old-passwords feature before and no longer have it in the my.cnf or in the starting script by any chance ? Try to create a testdb, add a user and see if that works (use locahost) you have a password set for the root user ? [EMAIL PROTECTED] wrote: > > 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 you are using 5.x I suppose ? then it will bypass and works sorry for confusion Philip wrote: > Your mysql comannd line is wrong > vpopmail has no access to mysql db but to vpopmail db only > > try this : > mysql -u vpopmail -pqwerty vpopmail > > Philip wrote: >> 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 logging in > > > > 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.Iwant 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> >> >>> --------------------------------------------------------------------- >> >>> Tounsubscribe, 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] >> >> > > --------------------------------------------------------------------- > 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