This db was a new one , empty... :)
I tried now to create a domain with: # ./vadddomain test.gr Error - no authentication database connection. Initial open. I thought I had fixed the connectivity , why is this happenning now? Marcos --- On Thu 04/26, Philip < [EMAIL PROTECTED] > wrote: From: Philip [mailto: [EMAIL PROTECTED] To: [email protected] Date: Thu, 26 Apr 2007 15:41:28 +0200 Subject: Re: [qmailtoaster] mysql vpopmail user not logging in You have a backup of your ex/brocken :) database you did with mysqldump <br>maybe ?<br>if you dont well,. the tables will be created when you add a newdomaim <br>(vadddomain ...)<br>so you have nothing else to do<br><br><br>[EMAIL PROTECTED] wrote:<br>><br>> No, I din't alter the my.cnf file even the start script but I have good news:<br>><br>><br>><br>> 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.<br>><br>><br>><br>> The steps I follow to recreate it:<br>><br>><br>><br>> # mysqladmin create vpopmail -uroot -pqwerty<br>><br>> # mysqladmin -uroot -pqwerty reload<br>><br>> # mysqladmin -uroot -pqwerty refresh<br>><br>> # echo "GRANT ALL PRIVILEGES ON vpopmail.* TO [EMAIL PROTECTED] IDENTIFIED BY 'qwerty'" | mysql -uroot -pqwerty<br>><br>> # mysqladmin -uroot -pqwerty reload<br>><br>> # mysqladmin -uroot -pqwerty refresh<br>><br>> # mysql -u vpopmail -pqwerty vpopmail<br>><br>> Welcome to the MySQL monitor. Commands end with ; or \g.<br>><br>> Your MySQL connection id is 26 to server version: 5.0.27<br>><br>><br>><br>> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.<br>><br>><br>><br>> mysql><br>><br>><br>><br>><br>><br>> Now, at this point, should I run this to create the tables or do I need another intermediate step?:<br>><br>><br>><br>> CREATE TABLE relay (<br>><br>> ip_addr char(18) NOT NULL default '',<br>><br>> timestamp char(12) default NULL,<br>><br>> PRIMARY KEY (ip_addr)<br>><br>> );<br>><br>><br>><br>> Marcos<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 15:16:51 +0200<br>><br>> Subject: Re: [qmailtoaster] mysql vpopmail user not logging in<br>><br>><br>><br>> Ok<br>hmmm you didnt install and make an update like had old-passwords feature <br>before and no longer have it in the my.cnf or in the starting script by <br>any chance ?<br><br>Try to create a testdb, add a user and see if that works (use locahost)<br>you have a password set for the root user ?<br><br><br>[EMAIL PROTECTED] wrote:<br>><br>> Yes, it is 5.X but I tried the command and still the same problem:<br>><br>><br>><br>> # mysql -u vpopmail -pqwerty vpopmail<br>><br>> ERROR 1045 (28000): Access denied for user 'vpopmail'@'localhost' (using password: YES)<br>><br>> # mysql -u vpopmail -pqwerty vpopmail -h localhost<br>><br>> ERROR 1045 (28000): Access denied for user 'vpopmail'@'localhost' (using password: YES)<br>><br>> # mysql -u vpopmail -pqwerty vpopmail -h mailhost2<br>><br>> ERROR 1045 (28000): Access denied for user 'vpopmail'@'mailhost2.adacom.com' (using password: YES)<br>><br>><br>><br>> It has no sense...:(<br>><br>><br>><br>><br>><br>> --- On Thu 04/26, <br>> Philip < [EMAIL PROTECTED] > wrote:<br>><br>> From: Philip [mailto: [EMAIL PROTECTED]<br>><br>> To: [email protected]<br>><br>> Date: Thu, 26 Apr 2007 15:02:34 +0200<br>><br>> Subject: Re: [qmailtoaster] mysql vpopmail user not logging in<br>><br>><br>><br>> 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>>>><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 <br>> 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: <br>> [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>>>> <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>>>> <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] <br>> 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] <br>> 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, <br>> 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>>>> <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>>>> <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>> <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>>>> <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 <br>> 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 <br>> 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>>>> <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>> <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>>>> <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>> _______________________________________________<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>>>> <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>>>> <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 <br>> 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>> <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>> <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 <br>> 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>> <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>> ---------------------------------------------------------------------<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, <br>> 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>> ---------------------------------------------------------------------<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>> Join Excite! - <br>> 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>> 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> _______________________________________________ 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]
