View Single Post
  #7  
Old 2nd September 2010, 14:10
scottrill2 scottrill2 is offline
HowtoForge Supporter
 
Join Date: Dec 2009
Posts: 93
Thanks: 21
Thanked 2 Times in 1 Post
Default Man this is sad.

Well I think I must have horrid mysql karma or something lol



So I followed your instructions, all seemed well. I then saw a new tutorial by falko of setting up master slave replication with ssl. Now I'm just on a private network playing around and stuff so I don't NEED security lol but figured what the hell lets play around with it.

Now I get this error in syslog:



Sep 2 05:00:05 server2 mysqld[4567]: 100902 5:00:05 [ERROR] Slave I/O thread: error connecting to master 'slave_user@10.1.10.123:3306': Error: 'Access denied for user 'slave_user'@'10.1.10.124' (using password: YES)' errno: 1045 retry-time: 60 retries: 86400


After searching the forums I found a post where it was possibly a firewall problem. Now before the ssl the slave was working just fine until it hit that duplication error, so I wouldn't think it is a firewall issue. I found this command as well:

mysql -u slave_user@10.1.10.123 -pmypassword

This returns with this error:

ERROR 1045 <28000>: Access denied for user 'slave_user@10.1.'@'localhost' <using password: YES>

It cuts off the host after 5 digits, don't know if that is normal either?


So any ideas folks?



Thanks as always for your time,



Scott
Reply With Quote