Re: [qmailtoaster] mysql vpopmail user not logging in

Philip Thu, 26 Apr 2007 07:22:32 -0700

Send yourself some emails :)
well relay table is mainly used if you use pop3 before smtp auth
that's not default's qt installation


you need to modify vpopmail's installation to use roaming
http://wiki.qmailtoaster.com/index.php/Vpopmail_-_roaming_users_configuration

You should be good now.. and running a nice QT system :)



[EMAIL PROTECTED] wrote:

You were right again,



I changed it back to localhost and could create the new domain.



After that I checked the vpopmail db to see the new tables and I found these 
but no relay table...When is that table created them?



mysql> show tables;

+--------------------+

| Tables_in_vpopmail |

+--------------------+
| domain_com || dir_control || lastauth |
+--------------------+

3 rows in set (0.00 sec)



Marcos





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

From: Philip [mailto: [EMAIL PROTECTED]

To: [email protected]

Date: Thu, 26 Apr 2007 16:04:25 +0200

Subject: Re: [qmailtoaster] mysql vpopmail user not logging in
Your vpopmail.mysql file matches your new infos ? localhost|0|vpopmail|password|vpopmail ? [EMAIL PROTECTED] wrote: > 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 maybe ? 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 apassword 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 loggingin > > > > 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 triedagain > 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.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 mostpersonalized 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 additionalcommands, > 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 theWeb! > > > > > --------------------------------------------------------------------- > 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] 
_______________________________________________
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