Mantis Bugtracker

Viewing Issue Simple Details Jump to Notes ] View Advanced ] Issue History ] Print ]
ID Category Severity Reproducibility Date Submitted Last Update
0003098 [Quercus] block always 11-25-08 13:30 03-23-10 07:41
Reporter catkins View Status public  
Assigned To
Priority normal Resolution open  
Status new   Product Version 3.2.1
Summary 0003098: mysql_connect hostname substition by mangling jndi name
Description I have this string in the php:


What happens is I get this error:

Warning: A link to the server could not be established. url=jdbc:mysql://java:3306/?characterEncoding=ISO8859_1 [^]

If I change the statement to:


Warning: A link to the server could not be established. url=jdbc:mysql://localhost:3306/?characterEncoding=ISO8859_1 [^]

In fact, I can change it to anything and have a similar result. However, if a non-word character is put in the string, then that appears to be the terminator as in the first example.

I get:

"jdbc/thecrossingchurch" is configured in resin.xml. I can confirm this by doing:

$conn = jndi_lookup("java:comp/env/jdbc/thecrossingchurch");
print $conn;

Which shows the name and this works as well:

$db = new PDO("java:comp/env/jdbc/thecrossingchurch");

Returning a connection, but the site design expect a mysql_connect and mysql_select_db call to setup a current database.

Additional Information
Attached Files

- Relationships

- Notes
01-30-09 05:04

  $jndi_name = "java:comp/env/jdbc/cms";
  $conn = jndi_lookup( $jndi_name );
  var_dump( $conn );
  $link = mysql_connect( $jndi_name );
  var_dump( $link );



/D:/Programme/resin/webapps/ACME/test.php:6: Warning: A link to the server could not be established.
  url=jdbc:mysql://java:3306/?characterEncoding=ISO8859_1&useOldAliasMetadataBehavior=true [^]
  java.sql.SQLException: Unable to connect to any hosts due to exception: java


Could someone please care?
01-19-10 15:05

I have the same problem with postgresql (pg_connect) and quercus 4.0.3

I can connect via PDO using the jndi name but I cannot connect using pg_connect with the jndi name
03-21-10 16:01

I'm experiencing the same problem with mysql_connect and mysql_pconnect.

I've had to revert from JNDI to using direct JDBC URIs to get my legacy PHP app working without having to rewrite a lot of code to use PDO instead.
03-23-10 07:41

I use resin 4.0.5, Postgresql 8.4.2 and PEAR.DB library.
I have found that the following configuration works:

in resin.xml: ...<database><jndi-name>jdbc/erw</jndi-name>...
in web.xml: ...<init><database>java:comp/env/jdbc/erw</database>...
in the PHP file:
$db = DB::connect('pgsql://java:comp/env/jdbc/erw'); [^]

In other words, I have put 'pgsql://' [^] before the jndi name.

- Issue History
Date Modified Username Field Change
11-25-08 13:30 catkins New Issue
01-30-09 05:04 obaltz Note Added: 0003788
01-19-10 15:05 pablorg Note Added: 0004389
01-28-10 14:37 domdorn Issue Monitored: domdorn
03-21-10 00:02 flushot Issue Monitored: flushot
03-21-10 16:01 flushot Note Added: 0004475
03-23-10 07:41 posenato Note Added: 0004482

Mantis 1.0.0rc3[^]
Copyright © 2000 - 2005 Mantis Group
41 total queries executed.
33 unique queries executed.
Powered by Mantis Bugtracker