[vvvv]

peterlaursen wrote on Dec 5 2005, 06:09 PM:

I think I got it. 

You have this in the jobfile:

Code:

You specified a two-way sync.  Try 'no' instead of 'yes'.

There must some data in 'timestamp' table that exist in target that don't exist in source.  With a two-way sync they will be written to the source.  Was that it?

[post=”8112″]<{POST_SNAPBACK}>[/post]

yes it was. wow. thanks a lot!!

[vvvv]

hi there 🙂

to be sure there is no problem with my /etc/hosts i change 'localhost' to 127.0.0.1 in my sja config and it looked like this:

10.5.1.1

tmp_backup

4444 3306

lms

127.0.0.1

root

a 3306

lms

and got the same:

./sja config

SQLyog Job Agent Version 5.0

Copyright © Webyog Softworks Pvt. Ltd.. All Rights Reserved.

Sync started at Mon Dec 5 15:51:03 2005

Could not connect to TARGET MySQL server

Check sja.log for complete error details.

mysql-admin works.

changing /etc/hosts to

127.0.0.1 localhost

didnt help.

no doubt, the problem is not in wrong resolving of 'localhost'.

i made it work.. somehow. i don't like the way how.

add external ip, no metter on which phisical devise:

#ip a a 10.10.10.10/32 dev dummy0

#ip l s dev dummy0 up

force mysql listen on this ip. change /etc/mysql/my.cfg:

# Instead of skip-networking the default is now to listen only on

# localhost which is more compatible and is not less secure.

bind-address = 10.10.10.10

#

(in order to chech if it works:)

darkstar:/home/iv/installs/sja# lsof | grep -i listen

mysqld 6579 mysql 3u IPv4 10075 TCP 10.10.10.10:mysql (LISTEN)

now create a mysql user whith apropriate previleges. i just copied my 'root'@'localhost' to 'root'@'%'

and change sja config:

10.5.1.1

tmp_backup

4444 3306

lms

10.10.10.10

root

a 3306

lms

at this point i can connect to both source and target servers. but something odd appeared

look here:

darkstar:/home/iv/installs/sja# ./sja config

SQLyog Job Agent Version 5.0

Copyright © Webyog Softworks Pvt. Ltd.. All Rights Reserved.

Sync started at Mon Dec 5 16:35:04 2005

Table SrcRows TgtRows Inserted Updated Deleted

========================= ======= ======= ======== ======= =======

`tariffs` 21 21 0 0 No change

`tariffs` 21 21 0 0 No change

`timestamps` 15 15 There was an error while execute a query. The query and the error has been logged in the log file.`timestamps` 15 15 There was an error while execute a query. The query and the error has been logged in the log file.`userassignments` 1709 1709 0 0 No change

`userassignments` 1709 1709 0 0 No change

sja.log:

Sync started at Mon Dec 5 16:35:04 2005

Error No. 1142

INSERT command denied to user: '[email protected]' for table 'timestamps'

you can say “previleges”. ok, i intentionally didn't allow user 'tmp_backup'@'%' to make any inserts and updates, only selects on the source server. so it looks like sja try to change both source and target databases? is it a bug or i don't uderstand something? why the source database has being changed?

best regards

iv

[vvvv]

hi peter

i've checked whether 'localhost' is resolving, and it is. here is my /etc/hosts:

127.0.0.1 localhost.localdomain localhost

127.0.1.1 darkstar

darkstar:/home/iv/installs/sja# ping localhost

PING localhost.localdomain (127.0.0.1) 56(84) bytes of data.

64 bytes from localhost.localdomain (127.0.0.1): icmp_seq=1 ttl=64 time=0.081 ms

64 bytes from localhost.localdomain (127.0.0.1): icmp_seq=2 ttl=64 time=0.068 ms

i tried to change 'localhost' to 127.0.0.1, 127.0.1.1 and even 'localhost.localdomain' – nothing helped.

and no, it's not a router.. i have only 2 interfaces:

1: eth0: mtu 1500 qdisc pfifo_fast qlen 1000

link/ether 00:05:5d:d9:41:0d brd ff:ff:ff:ff:ff:ff

inet 10.5.1.3/25 brd 10.5.1.127 scope global eth0

2: lo: mtu 16436 qdisc noqueue

link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00

inet 127.0.0.1/8 scope host lo

darkstar:/home/iv/installs/sja# cat /proc/sys/net/ipv4/ip_forward

0

i'm not sure if any of client applications use tcp/ip connection. i run phpmyadmin, and if it does, there is no problem with connecting – phpmyadmin works perfectly.

with high probability i can solve this problem by making mysql listening on a dedicated ip address, probably even on dummy interface – but i don't like this solution.

you wrote sth about a sock, and i saw many mentions about this, but default installation doesn't contain any config samples with this option. if i could connect to server via mysql.sock i would be happy :). do you have any idea how to do that?

btw, if you are a developer (or you know someone of them 😉 ) – sja.log is absolutely unuseful in this case. it would be a good idea to add some logs, for example “can't connect to database” or “the user/password is wrong” – because if user/password is wrong, the log is the same – 'Could not connect to TARGET MySQL server'..

best regards

iv

[Author]

Posts