Re: [qmailtoaster] MYSQL replication question.
Hi Richard, is there a firewall between the two servers which block port 3306 on server2? Regards, Peter rich...@avits.ca schreef op 12-4-2014 1:47: Shouldn't the wildcard grant cover that? I have tried a number of combinations, IP with the wildcard, just the IP, and wildcard without the IP entry. Same issue every time. I have flushed privs and reloaded the grants table, no change. Thanks, Richard *From: *Wim Godden *Sent: *Friday, April 11, 2014 16:41 *To: *qmailtoaster-list@qmailtoaster.com *Reply To: *qmailtoaster-list@qmailtoaster.com *Subject: *Re: [qmailtoaster] MYSQL replication question. Have you tried setting it up as 'mail1_user'@'mail.avits.ca' ? Because that's the one being specified... MySQL is very picky on this. On 12/04/2014 0:53, Richard Whittaker wrote: Hi. I'm following Jake's video on setting up a replicating toaster setup, and have hit a pretty solid brick wall, and can't figure out how to get around it. I have the 2 MySQL servers setup, and running. Replication seems to be working fine in one direction, but not in the other. The slave thread on server1 fails with this error: 140411 15:02:27 [ERROR] Slave I/O thread: error connecting to master 'mail1_user@192.168.64.4:3306': Error: 'Access denied for user 'mail1_user'@'mail.avits.ca' (using password: YES)' errno: 1045 retry-time: 60 retries: 86400 I know the grants on server2 are setup on the target database. I have tried specific IP address and wildcard, and neither has worked. mysql show grants for mail1_user; +--+ | Grants for mail1_user@% | +--+ | GRANT REPLICATION SLAVE ON *.* TO 'mail1_user'@'%' IDENTIFIED BY PASSWORD 'blah' | +--+ 1 row in set (0.00 sec) mysql show grants for mail1_user@192.168.0.4; ++ | Grants for mail1_user@192.168.0.4 | ++ | GRANT REPLICATION SLAVE ON *.* TO 'mail1_user'@'192.168.0.4' IDENTIFIED BY PASSWORD 'blah' | ++ 1 row in set (0.00 sec) I can connect using the MySQL client as the use mail1_user and that password with no issues. Thoughts, suggestions? Thanks, Richard. - To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com - To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com -- Met vriendelijke groet, Peter Peterse
Re: [qmailtoaster] MYSQL replication question.
On 2014-04-11 16:41, Wim Godden wrote: Have you tried setting it up as 'mail1_user'@'mail.avits.ca' ? Because that's the one being specified... MySQL is very picky on this. So I did some more digging on this, and realized the IP 192.168.0.4 reverse resolved to more than one hostname, so I thought that might be part of the problem. I removed the second hostname from the reverse mapping, and updated the grants table to use the one hostname that I knew would resolve back to. No joy. mysql GRANT REPLICATION SLAVE ON *.* TO 'mail1_user'@'defiant.avits.ca' IDENTIFIED BY 'blah'; Query OK, 0 rows affected (0.00 sec) mysql FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) Client connections work just fine from the same IP, and with the same username/password combo as the replication account. [root@defiant conf.d]# mysql -h192.168.64.4 -umail1_user -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 422 Server version: 5.0.95-log Source distribution Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql quit Really, really scratching my head here. Thanks in advance for any advice. -- Alberni Valley IT Services
Re: [qmailtoaster] MYSQL replication question.
Hey Goddon, Sorry, haven't followed the entire convo here but did you try adding the user@ip too? I see you try to connect with an IP so maybe it circumvents the host check? Cheers, Sebastian On 12.04.2014, at 21:50, Richard Whittaker rich...@avits.ca wrote: On 2014-04-11 16:41, Wim Godden wrote: Have you tried setting it up as 'mail1_user'@'mail.avits.ca' ? Because that's the one being specified... MySQL is very picky on this. So I did some more digging on this, and realized the IP 192.168.0.4 reverse resolved to more than one hostname, so I thought that might be part of the problem. I removed the second hostname from the reverse mapping, and updated the grants table to use the one hostname that I knew would resolve back to. No joy. mysql GRANT REPLICATION SLAVE ON *.* TO 'mail1_user'@'defiant.avits.ca' IDENTIFIED BY 'blah'; Query OK, 0 rows affected (0.00 sec) mysql FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) Client connections work just fine from the same IP, and with the same username/password combo as the replication account. [root@defiant conf.d]# mysql -h192.168.64.4 -umail1_user -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 422 Server version: 5.0.95-log Source distribution Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql quit Really, really scratching my head here. Thanks in advance for any advice. -- Alberni Valley IT Services - To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com
Re: [qmailtoaster] MYSQL replication question.
Hi.As mentioned I have tried GRANTS by IP, Hostname and wildcard, and various combinations of those.Thanks,Richard From: Sebastian GreweSent: Saturday, April 12, 2014 12:57To: qmailtoaster-list@qmailtoaster.comReply To: qmailtoaster-list@qmailtoaster.comSubject: Re: [qmailtoaster] MYSQL replication question.Hey Goddon,Sorry, haven't followed the entire convo here but did you try adding the user@ip too? I see you try to connect with an IP so maybe it circumvents the host check?Cheers,Sebastian On 12.04.2014, at 21:50, Richard Whittaker rich...@avits.ca wrote: On 2014-04-11 16:41, Wim Godden wrote: Have you tried setting it up as 'mail1_user'@'mail.avits.ca' ? Because that's the one being specified... MySQL is very picky on this. So I did some more digging on this, and realized the IP 192.168.0.4 reverse resolved to more than one hostname, so I thought that might be part of the problem. I removed the second hostname from the reverse mapping, and updated the grants table to use the one hostname that I knew would resolve back to. No joy. mysql GRANT REPLICATION SLAVE ON *.* TO 'mail1_user'@'defiant.avits.ca' IDENTIFIED BY 'blah'; Query OK, 0 rows affected (0.00 sec) mysql FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) Client connections work just fine from the same IP, and with the same username/password combo as the replication account. [root@defiant conf.d]# mysql -h192.168.64.4 -umail1_user -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 422 Server version: 5.0.95-log Source distribution Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql quit Really, really scratching my head here. Thanks in advance for any advice.-- Alberni Valley IT Services -To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.comFor additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com - To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com
Re: [qmailtoaster] MYSQL replication question.
I am thinking of updating MYSQL to a more recent version, as that may solve this issue. 5.0.95 is pretty old. Are there any caveats using a newer version of MYSQL with QmailToaster, and what versions have people had success with? Running CentOS 5.10.Thanks,Richard From: Sebastian GreweSent: Saturday, April 12, 2014 12:57To: qmailtoaster-list@qmailtoaster.comReply To: qmailtoaster-list@qmailtoaster.comSubject: Re: [qmailtoaster] MYSQL replication question.Hey Goddon,Sorry, haven't followed the entire convo here but did you try adding the user@ip too? I see you try to connect with an IP so maybe it circumvents the host check?Cheers,Sebastian On 12.04.2014, at 21:50, Richard Whittaker rich...@avits.ca wrote: On 2014-04-11 16:41, Wim Godden wrote: Have you tried setting it up as 'mail1_user'@'mail.avits.ca' ? Because that's the one being specified... MySQL is very picky on this. So I did some more digging on this, and realized the IP 192.168.0.4 reverse resolved to more than one hostname, so I thought that might be part of the problem. I removed the second hostname from the reverse mapping, and updated the grants table to use the one hostname that I knew would resolve back to. No joy. mysql GRANT REPLICATION SLAVE ON *.* TO 'mail1_user'@'defiant.avits.ca' IDENTIFIED BY 'blah'; Query OK, 0 rows affected (0.00 sec) mysql FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) Client connections work just fine from the same IP, and with the same username/password combo as the replication account. [root@defiant conf.d]# mysql -h192.168.64.4 -umail1_user -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 422 Server version: 5.0.95-log Source distribution Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql quit Really, really scratching my head here. Thanks in advance for any advice.-- Alberni Valley IT Services -To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.comFor additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com - To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com
Re: [qmailtoaster] MYSQL replication question.
Hi, I am going try to test on CentOS 5.10 64bit version with OpenSSL-0.9.8y and MySQL-5.5.23. I guess that is working including ezmlm,ezmlm-idx with MySQL. My impression is fine. php is php-5.4.x latest also. apache is 2.2.x as latest. thank you Nori -- NoriyukiHayashinhaya...@wats.gr.jp ibisMailで送信! - To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com
Re: [qmailtoaster] MYSQL replication question.
Hi, again In this case all depends packages and QMT must recompile as rpm rebuild that I did. I never use any repo. Thanks, -- NoriyukiHayashinhaya...@wats.gr.jp ibisMailで送信! - To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com
[qmailtoaster] MYSQL replication question.
Hi. I'm following Jake's video on setting up a replicating toaster setup, and have hit a pretty solid brick wall, and can't figure out how to get around it. I have the 2 MySQL servers setup, and running. Replication seems to be working fine in one direction, but not in the other. The slave thread on server1 fails with this error: 140411 15:02:27 [ERROR] Slave I/O thread: error connecting to master 'mail1_user@192.168.64.4:3306': Error: 'Access denied for user 'mail1_user'@'mail.avits.ca' (using password: YES)' errno: 1045 retry-time: 60 retries: 86400 I know the grants on server2 are setup on the target database. I have tried specific IP address and wildcard, and neither has worked. mysql show grants for mail1_user; +--+ | Grants for mail1_user@% | +--+ | GRANT REPLICATION SLAVE ON *.* TO 'mail1_user'@'%' IDENTIFIED BY PASSWORD 'blah' | +--+ 1 row in set (0.00 sec) mysql show grants for mail1_user@192.168.0.4; ++ | Grants for mail1_user@192.168.0.4 | ++ | GRANT REPLICATION SLAVE ON *.* TO 'mail1_user'@'192.168.0.4' IDENTIFIED BY PASSWORD 'blah' | ++ 1 row in set (0.00 sec) I can connect using the MySQL client as the use mail1_user and that password with no issues. Thoughts, suggestions? Thanks, Richard. -- Alberni Valley IT Services attachment: richard.vcf- To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com
Re: [qmailtoaster] MYSQL replication question.
If I may ask, where did you get the replication video? On 4/11/2014 4:53 PM, Richard Whittaker wrote: Hi. I'm following Jake's video on setting up a replicating toaster setup, and have hit a pretty solid brick wall, and can't figure out how to get around it. I have the 2 MySQL servers setup, and running. Replication seems to be working fine in one direction, but not in the other. The slave thread on server1 fails with this error: 140411 15:02:27 [ERROR] Slave I/O thread: error connecting to master 'mail1_user@192.168.64.4:3306': Error: 'Access denied for user 'mail1_user'@'mail.avits.ca' (using password: YES)' errno: 1045 retry-time: 60 retries: 86400 I know the grants on server2 are setup on the target database. I have tried specific IP address and wildcard, and neither has worked. mysql show grants for mail1_user; +--+ | Grants for mail1_user@% | +--+ | GRANT REPLICATION SLAVE ON *.* TO 'mail1_user'@'%' IDENTIFIED BY PASSWORD 'blah' | +--+ 1 row in set (0.00 sec) mysql show grants for mail1_user@192.168.0.4; ++ | Grants for mail1_user@192.168.0.4 | ++ | GRANT REPLICATION SLAVE ON *.* TO 'mail1_user'@'192.168.0.4' IDENTIFIED BY PASSWORD 'blah' | ++ 1 row in set (0.00 sec) I can connect using the MySQL client as the use mail1_user and that password with no issues. Thoughts, suggestions? Thanks, Richard. - To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com
Re: [qmailtoaster] MYSQL replication question.
I bought it on vcghosting.comRegards,Richard From: Eric BrochSent: Friday, April 11, 2014 16:23To: qmailtoaster-list@qmailtoaster.comReply To: qmailtoaster-list@qmailtoaster.comSubject: Re: [qmailtoaster] MYSQL replication question. If I may ask, where did you get the replication video? On 4/11/2014 4:53 PM, Richard Whittaker wrote: Hi. I'm following Jake's video on setting up a replicating toaster setup, and have hit a pretty solid brick wall, and can't figure out how to get around it. I have the 2 MySQL servers setup, and running. Replication seems to be working fine in one direction, but not in the other. The slave thread on server1 fails with this error: 140411 15:02:27 [ERROR] Slave I/O thread: error connecting to master 'mail1_user@192.168.64.4:3306': Error: 'Access denied for user 'mail1_user'@'mail.avits.ca' (using password: YES)' errno: 1045 retry-time: 60 retries: 86400 I know the grants on server2 are setup on the target database. I have tried specific IP address and wildcard, and neither has worked. mysql show grants for "mail1_user"; +--+ | Grants for mail1_user@% | +--+ | GRANT REPLICATION SLAVE ON *.* TO 'mail1_user'@'%' IDENTIFIED BY PASSWORD 'blah' | +--+ 1 row in set (0.00 sec) mysql show grants for "mail1_user"@"192.168.0.4"; ++ | Grants for mail1_user@192.168.0.4 | ++ | GRANT REPLICATION SLAVE ON *.* TO 'mail1_user'@'192.168.0.4' IDENTIFIED BY PASSWORD 'blah' | ++ 1 row in set (0.00 sec) I can connect using the MySQL client as the use mail1_user and that password with no issues. Thoughts, suggestions? Thanks, Richard. - To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com - To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com
Re: [qmailtoaster] MYSQL replication question.
Have you tried setting it up as 'mail1_user'@'mail.avits.ca' ? Because that's the one being specified... MySQL is very picky on this. On 12/04/2014 0:53, Richard Whittaker wrote: Hi. I'm following Jake's video on setting up a replicating toaster setup, and have hit a pretty solid brick wall, and can't figure out how to get around it. I have the 2 MySQL servers setup, and running. Replication seems to be working fine in one direction, but not in the other. The slave thread on server1 fails with this error: 140411 15:02:27 [ERROR] Slave I/O thread: error connecting to master 'mail1_user@192.168.64.4:3306': Error: 'Access denied for user 'mail1_user'@'mail.avits.ca' (using password: YES)' errno: 1045 retry-time: 60 retries: 86400 I know the grants on server2 are setup on the target database. I have tried specific IP address and wildcard, and neither has worked. mysql show grants for mail1_user; +--+ | Grants for mail1_user@% | +--+ | GRANT REPLICATION SLAVE ON *.* TO 'mail1_user'@'%' IDENTIFIED BY PASSWORD 'blah' | +--+ 1 row in set (0.00 sec) mysql show grants for mail1_user@192.168.0.4; ++ | Grants for mail1_user@192.168.0.4 | ++ | GRANT REPLICATION SLAVE ON *.* TO 'mail1_user'@'192.168.0.4' IDENTIFIED BY PASSWORD 'blah' | ++ 1 row in set (0.00 sec) I can connect using the MySQL client as the use mail1_user and that password with no issues. Thoughts, suggestions? Thanks, Richard. - To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com
Re: [qmailtoaster] MYSQL replication question.
Shouldn't the wildcard grant cover that? I have tried a number of combinations, IP with the wildcard, just the IP, and wildcard without the IP entry. Same issue every time.I have flushed privs and reloaded the grants table, no change. Thanks,Richard From: Wim GoddenSent: Friday, April 11, 2014 16:41To: qmailtoaster-list@qmailtoaster.comReply To: qmailtoaster-list@qmailtoaster.comSubject: Re: [qmailtoaster] MYSQL replication question. Have you tried setting it up as 'mail1_user'@'mail.avits.ca' ? Because that's the one being specified... MySQL is very picky on this. On 12/04/2014 0:53, Richard Whittaker wrote: Hi. I'm following Jake's video on setting up a replicating toaster setup, and have hit a pretty solid brick wall, and can't figure out how to get around it. I have the 2 MySQL servers setup, and running. Replication seems to be working fine in one direction, but not in the other. The slave thread on server1 fails with this error: 140411 15:02:27 [ERROR] Slave I/O thread: error connecting to master 'mail1_user@192.168.64.4:3306': Error: 'Access denied for user 'mail1_user'@'mail.avits.ca' (using password: YES)' errno: 1045 retry-time: 60 retries: 86400 I know the grants on server2 are setup on the target database. I have tried specific IP address and wildcard, and neither has worked. mysql show grants for "mail1_user"; +--+ | Grants for mail1_user@% | +--+ | GRANT REPLICATION SLAVE ON *.* TO 'mail1_user'@'%' IDENTIFIED BY PASSWORD 'blah' | +--+ 1 row in set (0.00 sec) mysql show grants for "mail1_user"@"192.168.0.4"; ++ | Grants for mail1_user@192.168.0.4 | ++ | GRANT REPLICATION SLAVE ON *.* TO 'mail1_user'@'192.168.0.4' IDENTIFIED BY PASSWORD 'blah' | ++ 1 row in set (0.00 sec) I can connect using the MySQL client as the use mail1_user and that password with no issues. Thoughts, suggestions? Thanks, Richard. - To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com - To unsubscribe, e-mail: qmailtoaster-list-unsubscr...@qmailtoaster.com For additional commands, e-mail: qmailtoaster-list-h...@qmailtoaster.com