Re: [Php-java-bridge-users] Getting MySQL to work with Tomcat and PHP

Hi Marta,

php_mysql.dll needs mysql.

Please use

  cgi\php-cgi.exe -c
    cgi\conf.d\mysql.ini -d
      extension_dir=cgi\ext -i

to test ("x86-windows" omitted for clarity). If the above command line shows
mysql in its output, the php demo files shipped with JavaBridge.war will be
able to use mysql.

However, I recommend to download php to c:\program files\php\ and use that
for your tests. You can create your own demo (or product) using the
JavaBridgeTemplate.war and your php download later.

Regards,
Jost Bökemeier

26. Mai 2010 4:46 vorm. schrieb am <
php...@li...>:


Hi!

Thanks to the PHP/Java Bridge I managed to get my PHP
applications running under Tomcat 6 (OS: Windows 7). The problem is, I can't
seem to
connect MySQL with PHP.
I installed MySQL, added PHP's home directory and \ext directory to the PATH
environment variable, and uncommented the extension lines for php_mysql.dll
and
php_mysqli.dll in php.ini. After doing that my PHP applications stopped
working. I decided to comment the extension lines again and as soon as I
 did that my PHP applications started working again (but obviously I
can't use MySQL). I did this a few times just to make sure the problem
lied in those two extension lines.
I keep getting the following
error:

HTTP Status 500 - type
 Exception report
message
description The
 server encountered an internal error () that prevented it from
fulfilling this request.
exception
javax.servlet.ServletException: PHP FastCGI instance failed.

 php.java.servlet.fastcgi.FastCGIServlet.execute(FastCGIServlet.java:957)

 php.java.servlet.fastcgi.FastCGIServlet.handle(FastCGIServlet.java:991)

 php.java.servlet.fastcgi.FastCGIServlet.doGet(FastCGIServlet.java:1040)
       javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
       javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root
 cause
php.java.servlet.fastcgi.ConnectionException

 php.java.servlet.fastcgi.FastCGIInputStream.read(FastCGIInputStream.java:52)

 php.java.servlet.fastcgi.FastCGIServlet.parseBody(FastCGIServlet.java:876)

 php.java.servlet.fastcgi.FastCGIServlet.execute(FastCGIServlet.java:944)

 php.java.servlet.fastcgi.FastCGIServlet.handle(FastCGIServlet.java:991)

 php.java.servlet.fastcgi.FastCGIServlet.doGet(FastCGIServlet.java:1040)
       javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
       javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root
 cause
java.io.IOException: Protocol error

 php.java.servlet.fastcgi.FastCGIInputStream.doRead(FastCGIInputStream.java:61)

 php.java.servlet.fastcgi.FastCGIInputStream.read(FastCGIInputStream.java:48)

 php.java.servlet.fastcgi.FastCGIServlet.parseBody(FastCGIServlet.java:876)

 php.java.servlet.fastcgi.FastCGIServlet.execute(FastCGIServlet.java:944)

 php.java.servlet.fastcgi.FastCGIServlet.handle(FastCGIServlet.java:991)

 php.java.servlet.fastcgi.FastCGIServlet.doGet(FastCGIServlet.java:1040)
       javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
       javax.servlet.http.HttpServlet.service(HttpServlet.java:717)


If anyone could help me I'd be very thankful as I need Tomcat, PHP and MySQL
working together in order to do my job.

Sincerely,

Marta Fernandes
_________________________________________________________________
Hotmail: Free, trusted and rich email service.
https://signup.live.com/signup.aspx?id=60969
------------------------------------------------------------------------------

_______________________________________________
php-java-bridge-users mailing list
php...@li...
https://lists.sourceforge.net/lists/listinfo/php-java-bridge-users