PHP 5.0.5 extension for MySQL 5.0.21

Is anyone using MySQL 5.0.x with the PHP 5.0.5 that comes with NetWare 
6.5 SP5?

NetWare 6.5 SP5 installs PHP 5.0.5 with only a MySQL 4.0.x extension as 
well as an old version of both MySQL 4.0.26a and phpMyAdmin 2.6.4-pl3.

I've upgraded MySQL to 4.1.19 and tried replacing the PHP MySQL 
extension (sys:\php5\ext\phpmysql.nlm) with that from Guenter Knauf's 
Novell add-ons (php_mysql4.1.nlm) but whilst the MySQLi extension will 
load, the MySQL won't.

So I gave up with MySQL 4.1.x and switched to MySQL 5.0.21 since it's 
where I want to be anyway.  So I've now replaced the phpmysql.nlm with 
the php_mysql5.nlm, again from Guenter Knauf's build (against the PHP 
5.0.5 shipped with NW6.5SP5).

Same problems.  The PHP error log reports:

[18-Jul-2006 14:01:01] PHP Warning:  PHP Startup: Invalid library (maybe 
not a PHP library) 'phpmysql.nlm'  in Unknown on line 0

I'm able to use phpMyAdmin if I enable the MySQLi extension for PHP and 
edit the config.inc.php to use MySQLi in preference to MySQL.  However 
not all PHP apps will work with MySQLi, MediaWiki for one.

Server has been restarted in between changes so there should be no old 
modules floating around.  MODULES *PHP* and MODULES *MYSQL* doesn't 
reveal any mismatched versions.

MYSQLD_SAFE.NLM 

   Loaded from [SYS:\MYSQL\BIN\] on Jul 18, 2006   2:00:55 pm 

   (Address Space = OS) 

   MySQL Database Server Monitor 

   Version 5.00.21 April 26, 2006 

   (c) 2003-2005 Novell, Inc. Portions (c) 2003 MySQL AB. All Rights 
Reserved.
MYSQLD.NLM 

   Loaded from [SYS:/MYSQL/BIN/] on Jul 18, 2006   2:00:59 pm 

   (Address Space = OS) 

   MySQL Database Server 

   Version 5.00.21 April 26, 2006 

   (c) 2003-2005 Novell, Inc. Portions (c) 2003 MySQL AB. All Rights 
Reserved.
LIBMYSQL.NLM
   Loaded from [SYS:\MYSQL\BIN\] on Jul 18, 2006   2:01:01 pm 

   (Address Space = ADMINSRV) 

   MySQL Client Library 

   Version 5.00.21 April 26, 2006 

   (c) 2003-2005 Novell, Inc. Portions (c) 2003 MySQL AB. All Rights 
Reserved.
PHP5LIB.NLM
   Loaded from [SYS:\PHP5\] on Jul 18, 2006   2:00:58 pm
   (Address Space = ADMINSRV)
   PHP 5.0.5 - Script Interpreter and Library - Zend API Number 20041030
   Version 1.00.03 December 6, 2005
   Copyright (C) 2002-2005  Novell, Inc. All Rights Reserved.
MOD_PHP5.NLM
   Loaded from [SYS:\APACHE2\MODULES\] on Jul 18, 2006   2:00:59 pm
   (Address Space = ADMINSRV)
   PHP 5.0.5 - Apache 2.0 Module
   Version 1.00.02 October 3, 2005
   Copyright (C) 2002-2005  Novell, Inc. All Rights Reserved.
PHP_LDAP.NLM
   Loaded from [SYS:/PHP5/EXT/] on Jul 18, 2006   2:01:00 pm
   (Address Space = ADMINSRV)
   PHP 5.0.5 - LDAP Extension - Zend API Number 20041030
   Version 1.00.02 October 3, 2005
   Copyright (C) 2002-2005  Novell, Inc. All Rights Reserved.
PHP2UCS.NLM
   Loaded from [SYS:/PHP5/EXT/] on Jul 18, 2006   2:01:11 pm
   (Address Space = ADMINSRV)
   PHP 5.0.5 - UCS Extension - Zend API Number 20041030
   Version 1.00.02 October 3, 2005
   Copyright (C) 2002-2005  Novell, Inc. All Rights Reserved.
PHP_XML.NLM
   Loaded from [SYS:/PHP5/EXT/] on Jul 18, 2006   2:01:12 pm
   (Address Space = ADMINSRV)
   PHP 5.0.5 - XML Extension - Zend API Number 20041030
   Version 1.00.02 October 3, 2005
   Copyright (C) 2002-2005  Novell, Inc. All Rights Reserved.
PHP_OSSL.NLM
   Loaded from [SYS:/PHP5/EXT/] on Jul 18, 2006   2:01:12 pm
   (Address Space = ADMINSRV)
   PHP 5.0.5 - OpenSSL Extension - Zend API Number 20041030
   Version 1.00.02 October 3, 2005
   Copyright (C) 2002-2005  Novell, Inc. All Rights Reserved.
PHP_MBSTRING.NLM
   Loaded from [SYS:/PHP5/EXT/] on Jul 18, 2006   2:01:19 pm
   (Address Space = ADMINSRV)
   PHP 5.0.5 - Multi-Byte String Extension - Zend API Number 20041030
   Version 1.00.02 October 3, 2005
   Copyright (C) 2002-2005  Novell, Inc. All Rights Reserved.
PHP_MYSQLI.NLM
   Loaded from [SYS:/PHP5/EXT/] on Jul 18, 2006   2:01:23 pm
   (Address Space = ADMINSRV)
   PHP 5.0.5 - MySQLi Extension - Zend API Number 20041030
   Version 1.00.02 October 3, 2005
   Copyright (C) 2002-2005  Novell, Inc. All Rights Reserved.
PHP_GD2.NLM
   Loaded from [SYS:/PHP5/EXT/] on Jul 18, 2006   2:01:25 pm
   (Address Space = ADMINSRV)
   PHP 5.0.5 - GD2 Extension - Zend API Number 20041030
   Version 1.00.02 October 3, 2005
   Copyright (C) 2002-2005  Novell, Inc. All Rights Reserved.

Hi Simon,

Simon Flood <S.M.Flood@ucs.cam.ac.uk> wrote in
news:rl5vg.500$2s3.488@prv-
forum2.provo.novell.com:

> Is anyone using MySQL 5.0.x with the PHP 5.0.5 that comes with NetWare 
> 6.5 SP5?
> 
> NetWare 6.5 SP5 installs PHP 5.0.5 with only a MySQL 4.0.x extension as 
> well as an old version of both MySQL 4.0.26a and phpMyAdmin 2.6.4-pl3.
> 
> I've upgraded MySQL to 4.1.19 and tried replacing the PHP MySQL 
> extension (sys:\php5\ext\phpmysql.nlm) with that from Guenter Knauf's 
> Novell add-ons (php_mysql4.1.nlm) but whilst the MySQLi extension will 
> load, the MySQL won't.

> So I gave up with MySQL 4.1.x and switched to MySQL 5.0.21 since it's 
> where I want to be anyway.  So I've now replaced the phpmysql.nlm with 
> the php_mysql5.nlm, again from Guenter Knauf's build (against the PHP 
> 5.0.5 shipped with NW6.5SP5).
> 
> Same problems.  The PHP error log reports:
> 
> [18-Jul-2006 14:01:01] PHP Warning:  PHP Startup: Invalid library (maybe 
> not a PHP library) 'phpmysql.nlm'  in Unknown on line 0
hmm - I guess you have a typo somewhere, or no search path to libmysql.nlm;
I think you should check the extension names, and compare to what you have with

the load statement in php.ini; I name the extenssions php_mysql.nlm while 
Novell named it phpmysql.nlm....

HTH, Guen.

Hi Simon,

Simon Flood <S.M.Flood@ucs.cam.ac.uk> wrote in
news:rl5vg.500$2s3.488@prv-
forum2.provo.novell.com:

> Is anyone using MySQL 5.0.x with the PHP 5.0.5 that comes with NetWare 
> 6.5 SP5?
> 
> NetWare 6.5 SP5 installs PHP 5.0.5 with only a MySQL 4.0.x extension as 
> well as an old version of both MySQL 4.0.26a and phpMyAdmin 2.6.4-pl3.
> 
> I've upgraded MySQL to 4.1.19 and tried replacing the PHP MySQL 
> extension (sys:\php5\ext\phpmysql.nlm) with that from Guenter Knauf's 
> Novell add-ons (php_mysql4.1.nlm) but whilst the MySQLi extension will 
> load, the MySQL won't.

> So I gave up with MySQL 4.1.x and switched to MySQL 5.0.21 since it's 
> where I want to be anyway.  So I've now replaced the phpmysql.nlm with 
> the php_mysql5.nlm, again from Guenter Knauf's build (against the PHP 
> 5.0.5 shipped with NW6.5SP5).
> 
> Same problems.  The PHP error log reports:
> 
> [18-Jul-2006 14:01:01] PHP Warning:  PHP Startup: Invalid library (maybe 
> not a PHP library) 'phpmysql.nlm'  in Unknown on line 0
hmm - I guess you have a typo somewhere, or no search path to libmysql.nlm;
I think you should check the extension names, and compare to what you have with

the load statement in php.ini; I name the extenssions php_mysql.nlm while 
Novell named it phpmysql.nlm....

HTH, Guen.

On 19/07/2006 10:54, Guenter wrote:

> hmm - I guess you have a typo somewhere, or no search path to
libmysql.nlm;

As you can see from the list of loaded modules in my original message, 
libmysql.nlm (5.00.21 April 26, 2006) is most definitely found in the 
search path (sys:\mysql\bin) and loaded.

> I think you should check the extension names, and compare to what you have
with 
> the load statement in php.ini; I name the extenssions php_mysql.nlm while 
> Novell named it phpmysql.nlm....

Yes I realised that and renamed your extension to match phpmysql.nlm 
(having renamed Novell's version to something different).  Didn't want 
to have to keep editing the php.ini file each time I tried a different 
version of the MySQL extension.

Just a thought - does your 5.0 extension (compiled for PHP 5.0.5 as 
provided with NW6.5 SP5) work in extended address space?

On 19/07/2006 10:54, Guenter wrote:

> hmm - I guess you have a typo somewhere, or no search path to
libmysql.nlm;

As you can see from the list of loaded modules in my original message, 
libmysql.nlm (5.00.21 April 26, 2006) is most definitely found in the 
search path (sys:\mysql\bin) and loaded.

> I think you should check the extension names, and compare to what you have
with 
> the load statement in php.ini; I name the extenssions php_mysql.nlm while 
> Novell named it phpmysql.nlm....

Yes I realised that and renamed your extension to match phpmysql.nlm 
(having renamed Novell's version to something different).  Didn't want 
to have to keep editing the php.ini file each time I tried a different 
version of the MySQL extension.

Just a thought - does your 5.0 extension (compiled for PHP 5.0.5 as 
provided with NW6.5 SP5) work in extended address space?