ID: 30902
User updated by: justind at ela dot com dot au
Reported By: justind at ela dot com dot au
Status: Open
Bug Type: DBX related
Operating System: Windows XP SP2
PHP Version: 5.0.2
New Comment:
Were I wrote CDX i meant DBX sorry.
Previous Comments:
------------------------------------------------------------------------
[2004-11-26 09:20:32] justind at ela dot com dot au
Description:
------------
I have just installed PHP 5.0.2 and MySQL 4.1.7. After several hours of
attempting to connect to MySQL through CDX abstration layer I discovered
that CDX was using mysql_connect function calls. This of course is no
longer supported on MySQL 4.1 upwards. Instead the call should have
been the improved version e.g. mysqli_connect.
Any way I search for an answer to my problem before comming here and
thought I better let everyone know before they waste hours finding out
them selves.
CDX database abstraction layer does not support MySQL versions 4.1
upwards
Reproduce code:
---------------
$sedco = dbx_connect(DBX_MYSQL, "localhost", $DBNAME, $DBUSER,
$DBPASS); //Create a connection to MYSQL 4.1.7 database
Expected result:
----------------
a connection should be made to the database, the connection worked when
I used MySQLi Extension instead e.g. $sedco =
mysqli_connect("localhost", "$DBUSER", "$DBPASS", "$DBNAME"); //Create
a connection to MYSQL 4.1.7 database
Actual result:
--------------
Warning: mysql_connect() [function.mysql-connect]: Client does not
support authentication protocol requested by server; consider upgrading
MySQL client in C:\Inetpub\wwwroot\Sedco\test.php on line 57
Unable to connect to database
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=30902&edit=1
