Help About Sja & Named Pipe …

[MuphoOx]

G'Evening …

Urgent need to know how to access a mysql database, using a named pipe.

My situation:

* 2 servers : server1 – ip1 / server2 – ip2

* with 2 databases DB_clt and DB_serv

* sja.exe (version 5.15) with xml configuration files

The “DB_clt” has a mysql service named Mysql_db2 listening on port 3301

and the “DB_serv” is used by a software, which access it by a named pipe : named “MYSQL”.

I'd like to synchronize my 2 databases, but i don't know how should i put the named pipe parameter; and not even know if SJA support this … hope it is!

PS: i've tried to put the name of the pipe in stead of the port number, doesn't work.

i've thinkied about the http tuneling, but i don't know if it will work and how should i do.

Hope i'll hear from you asap. Thx

Best Regards

MuphoOx

[peterlaursen]

SQLyog and SJA only connects to MySQL using TCP-IP and neither 'named pipes' (on Windows) or 'socket' (on *nix)

You have some other software using a 'named pipe' on port 3301. However that should not prevent you from using TCP-IP too on (typically) port 3306.

Is the Server configured not to used TCP-IP? Any particular reason for that? You can cooment-out 'disable-networking' in MySQL cofiguration then (you will need to retart the server).

BTW: I think that it is well known that 'named pipes' on Windows are less efficient that TCP. On some *nix systems 'socket' is most efficient.

[MuphoOx]

thx for your answer, Peter;

i was writing an update of this situation …

actually, i've changed the parameters; i've commented-out 'disable-networking' in MySQL and used a tcp port, and have put a 'bind-address=127.0.0.1' clause to keep my server secure.

I was using the “named pipe” 'cause our clients when they have a firewall, it block the communication port of mysql, so no more connexion to the data base is possible; then the software is not working… and the client complain … 😡 . The named pipe was used cause it doesn't use any communication port …

Anyway, with the bind-address, the sync job works well; but i have to find a solution to avoid the firewall… or to add a rule on every well knwon firewall…. but it's an other task…

[Author]

Posts