php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #30902 Authentication issue due to DBX not supporting mysqli functions
Submitted: 2004-11-26 09:20 UTC Modified: 2004-11-26 13:32 UTC
From: justind at ela dot com dot au Assigned:
Status: Closed Package: DBX related
PHP Version: 5.0.2 OS: Windows XP SP2
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: justind at ela dot com dot au
New email:
PHP Version: OS:

 

 [2004-11-26 09:20 UTC] 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

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2004-11-26 09:23 UTC] justind at ela dot com dot au 
Were I wrote CDX i meant DBX sorry.
 [2004-11-26 13:32 UTC] edink@php.net 
PHP 5.0.3 and newer will support MySQL 4.1.7.

For the inpatient:

http://snaps.php.net/win32/php5.0-win32-latest.zip
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Sat Dec 21 14:01:32 2024 UTC