I have resolved this problem. The program doing the mysql_real_open had been
compiled with the thread library by a "cc -Kthread ..." compile. When
the -Kthread option was removed the problem went away.
----- Original Message -----
From: "Steve Rickard" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Tuesday, August 14, 2001 9:08 AM
Subject: program using mysql_real_open gets error when rexec'd on 3.23.39
> 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
>
>
---------------------------------------------------------------------
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
