Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Server Operation

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old 22nd July 2010, 21:34
isn isn is offline
Join Date: Oct 2009
Posts: 57
Thanks: 6
Thanked 3 Times in 3 Posts
Default mysql ssl data replication problem certificate issue?


*************************** 1. row ***************************
Slave_IO_State: Connecting to master
Master_Host: mercury.investmenttool.com
Master_User: slave_user
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000006
Read_Master_Log_Pos: 98
Relay_Log_File: mysqld-relay-bin.000001
Relay_Log_Pos: 98
Relay_Master_Log_File: mysql-bin.000006
Slave_IO_Running: No
Slave_SQL_Running: Yes
Replicate_Do_DB: transferdb
Last_Errno: 0
Skip_Counter: 0
Exec_Master_Log_Pos: 98
Relay_Log_Space: 98
Until_Condition: None
Until_Log_Pos: 0
Master_SSL_Allowed: Yes
Master_SSL_CA_File: /etc/mysql/newcerts/ca-cert.pem
Master_SSL_Cert: /etc/mysql/newcerts/client-cert.pem
Master_SSL_Key: /etc/mysql/newcerts/client-key.pem
Seconds_Behind_Master: NULL
1 row in set (0.00 sec)

100722 7:37:57 [ERROR] Slave I/O thread: error connecting to master 'slave_user@mercury.investmenttool.com:3306': Error: 'Access denied for user 'slave_user'@'basestar.investmenttool.com' (using password: YES)' errno: 1045 retry-time: 60 retries: 86400

Read thte notes in the thread itself and decided to verify the certificate:

[root@basestar newcerts]# openssl verify -CAfile ca-cert.pem client-cert.pem
client-cert.pem: /C=US/ST=Illinois/L=Chicago/O=ISN Corporation/CN=basestar.investmenttool.com/emailAddress=hpuxconsulting@yahoo.com
error 20 at 0 depth lookup:unable to get local issuer certificate

Master is the main server, I'd just like data replication to a hot site.

the hot site is at a fixed ip address, and everything is wonderful. So I think.

isn aka SEP from ITRC forums

Last edited by isn; 22nd July 2010 at 22:25.
Reply With Quote
Sponsored Links


mysql, openssl, replication, ssl

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Issues securing Webmail with SSL Certificate Robeast Installation/Configuration 10 31st January 2008 02:05
SSL for virtual hosts on one certificate rbartz Tips/Tricks/Mods 8 20th November 2007 18:59
mysql clustering problem : cannot create table in database prince.fer Server Operation 2 16th April 2007 18:03
Problem installing ISPConfig, then with MySQL... ctroyp Installation/Configuration 7 26th September 2005 17:37
MySQL issue during install of ISPConfig ricbax Installation/Configuration 4 16th September 2005 10:41

All times are GMT +2. The time now is 22:32.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.