If I understand correctly you are trying to do replication over two service
providers of AWS and Rackspace. If that is the case you need to use the
Fully qualified domain name for setting your masterserver rather than "
masterserver". More over the replication user should have access to coming
from that IP address.
On Mon, Aug 3, 2015 at 3:36 AM, Ajeesh Kannan <ajeeshbkannan at gmail.com>
wrote:
Hi,
I am getting the following error while connecting mysql replication over
ssl connection.
[root at slave server ]# mysql -u replicationuser -p -hmasterserver
--ssl-ca /etc/ssl/certs/mysql/ca-cert.pem --ssl-cert
/etc/ssl/certs/mysql/slave-public.pem --ssl-key
/etc/ssl/certs/mysql/slave-private.pem
*ERROR 2026 (HY000): SSL connection error*
mysql slave server is located on : *aws* [ ec2 instance ]
mysql master server is located on : *RackSpace* [ cloud server ]
on rackspace :- any traffic is allowed from that machine to host
on master
mysql> show variables like '%ssl%';
+---------------+----------------------------+
| Variable_name | Value |
+---------------+----------------------------+
| have_openssl | YES |
| have_ssl | YES |
| ssl_ca | /etc/mysql/ca-cert.pem |
| ssl_capath | |
| ssl_cert | /etc/mysql/server-cert.pem |
| ssl_cipher | |
| ssl_key | /etc/mysql/server-key.pem |
+---------------+----------------------------+
Using the same ssl key I can connect replication with in aws/rack space
servers.
--
With Regards,
Ajeesh B.Kannan
_______________________________________________
ILUGC Mailing List:
http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
ILUGC Mailing List Guidelines:
http://ilugc.in/mailinglist-guidelines