I used to have the pente database replicated to my home computer, but for the last few years haven’t been doing that (my linux box got gutted for other projects, and laziness). I’ve been just backing up a nightly copy of the database to my remote backup space.
Today I decided it is finally time to start backing up again, especially since I recently had a hard drive go bad on my server. I setup a vmware copy of Debian on my home PC and got it networked. Then I setup mysql and started to setup replication and realized I should probably replicate over SSL now, no sense in letting anyone snoop the data. So I followed the instructions at mysql.com and here but got stuck when I tried to connect with ssl with the error message
usr/src# mysql --ssl -h pente.org -uroot -p --ssl-ca=/dev/null
Enter password:
ERROR 2026 (HY000): SSL connection error
Looking on google that appears to happen to Debian because the mysql packages aren’t linked to openssl due to Debian’s strict licensing stuff. I found someone with a solution of compiling from source, and that worked for me as well. The one thing I’m not sure about now though is if future apt-get upgrade’s will work for security fixes to mysql, or will I have to check myself and redo the whole thing each time?
-dweebo