Gerry Sweeney wrote:
> I would imagine that the problem is an NT thing. I am making the
> assumption that you are using NT. What web server are you using?
you're right I'm using NT4 Server SP6a, but I do not use the IIS in this
case, it's Roxen.
> The point is, if you where using IIS, then the PHP.EXE would get
> executed in the security context of the account IIS_USER. This account
> may have insufficient privs to do what you want. I believe that you can
> execute a PHP script on the command line, don't know how, I just read it
> somewhere. You may want to try that. This will test the security theory.
That's it! PHP can be run as CGI or ISAPI Module on Win32. I choosed the
CGI version and due to this I can run it on the command line:
f:\www\Roxen1\cgi-bin> php -q test.php3
with test.php3: <?php mysql_connect("localhost:3306", "test", ""); ?>
Voila - no error message! So the Roxen configuration parameter
"Scripting->CGI->Run scripts as..." must be changed.
> Another thing on Windows 9x/NT is there is Winsock 1.1 and Winsock 2.0.
> These are two different DLL's. Winsock 1.1 is done through wsock32.dll
> while Winsock 2.0 is done through ws2_32.dll. I have had many problems
> with using the ws2_32.dll, but these are mainly on Win9x. Not NT.
I knew that there was some trouble with different Winsock version on
Win9x. This is mentioned in the PHP Knowledge Base as well as in the
Mailinglist archive. But I was completely confused this would happen on
> system. It could be that you have a faulty TCP/IP installation and
> WinMySQL works because is uses Winsock 1.1 but the libmysql module does
> not because it uses Winsock 2.0.
That's probably why.
You both have done a perfect support job! I'll do my part and take the
information to the PHP Mailinglist archive and Knowled Base.