I'm using the linux version of sja to sync two databases.
First, thank you for the linux version of sja!
Now, I can log into a MySQL server running locally like this:
mysql -u -h localhost -p
which works with no problem.
However, the following .xml file does not work:
localhost
username
3306
…
….
….
Now, I tend to think that this is a sja bug for the following reason. When localhost is used, there is no entry in the mysql.log file indicating either success or failure in the login. If is the actual IP address, then it does log something.
I wonder if my installation of MySQL has something to do with it, since 'strace sja the_file.xml' does show this:
connect(5, {sin_family=AF_UNIX, path=”/var/lib/mysql/mysql.sock”}, 110) = -1 ENOENT (No such file or directory)
shutdown(5, 2 /* send and receive */) = 0
That is, there is no file named /var/lib/mysql/mysql.sock in that directory, so I think that it is never actually connecting to the MySQL server, but instead bails out early. The only error log entry that appears is:
