I have two servers running mysql on UnixWare 7.1.1. The 1st (uwdev1) is on
level 3.22.25 and has been running for more than a year with no problems at
all. The 2nd (sqlsrv1) is new and is running 3.23.39. The same databses are
on each server. Eventually all mysql databases will be on the sqlsrv1
system. I have a program (mappermysql) that uses the mysql API to send SQL
statements to mysql. This program is normally rexec'd from another
application.
Here is the problem:
1. When mappermysql is executed directly from the command line, it works in
all cases.
2. When mappermysql is rexec'd and the target mysql host is uwdev1 (running
3.22.25), it works in all cases.
3. When mappermysql is rexec'd and the target mysql host is sqlsrv1 (running
3.23.39) it always fails on mysql_real_open with the error:
ERROR: 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (4)
The code that fails is
if (!mysql_real_connect(mysql, "localhost", "root", NULL, database, 0,
NULL, 0))
I assume that the (4) is the errno value, which in UnixWare is "interupted
system call". The only difference between rexecing mappermysql and not is
that the rexec'd one has a user of "inetd". This causes no problem on the
earlier level. This seems to be a permissions problem, but I have not been
able to figure it out.
Any help will be greatly appreciated.
Steve
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
