php 4.2 connection to mysql 5.0.11

Hello,

i have two nw6.5 sp5 servers.

Server A) 10.0.1.1 runs Apache 2.0.54 with PHP 4.2.4
Server B) 10.0.1.2 runs MySQL 5.0.11

I try to use a PHP Script to connect from Server A to Server B but it does not
work

mysql_connect ("10.0.1.2","user","pwadmin");


The user has the right to connect from everywhere to the MYSQL Server B but
everytime it does not connct.


Doese anyone has an idea for this?

Kind regards
Jens Geier

b+w Electronic Systems GmbH & Co. KG
------------------------------------
Zur Eisenhütte 11
D-46047 Oberhausen
------------------------------------

Hi Jens,
JGeier<High.Spam@b-w.com> wrote in
news:8C8C000044073FEF000060D9@support-forums.novell.com: 

> i have two nw6.5 sp5 servers.
> 
> Server A) 10.0.1.1 runs Apache 2.0.54 with PHP 4.2.4
> Server B) 10.0.1.2 runs MySQL 5.0.11
> 
> I try to use a PHP Script to connect from Server A to Server B but it
> does not work 
> 
> mysql_connect ("10.0.1.2","user","pwadmin");
> 
> 
> The user has the right to connect from everywhere to the MYSQL Server B
> but everytime it does not connct. 
> 
> 
> Doese anyone has an idea for this?
your php_mysql client is too old - you need a 4.1.x or later client lib;
you should tell server A to use PHP 5.0.5, and the php_mysqli extension, or 
an updated php_mysql for mysql 4.1.x or later; probably you will find updated 
php_mysql extensions for your old PHP 4.2.4 on the Forge PHP site, or with my 
builds, cant remember....
btw. server B might want an update: 5.0.18 is current release...., smile

G.

Hello Guenter,

i will look up for a new php_mysql.

But of cause i tried to use PHP5 that was delivered with NW6.5 OVLSP5.

But everytime when i triy to connect to the MySQL Server the NetWare Server
abends imidietly ..... =:-(

Kind Regards
Jens Geier

"Guenter" <devforums@novell.com> schrieb im Newsbeitrag
news:AIHNf.2207$oh5.1428@prv-forum2.provo.novell.com...
> Hi Jens,
> JGeier<High.Spam@b-w.com> wrote in
> news:8C8C000044073FEF000060D9@support-forums.novell.com:
>
> > i have two nw6.5 sp5 servers.
> >
> > Server A) 10.0.1.1 runs Apache 2.0.54 with PHP 4.2.4
> > Server B) 10.0.1.2 runs MySQL 5.0.11
> >
> > I try to use a PHP Script to connect from Server A to Server B but it
> > does not work
> >
> > mysql_connect
("10.0.1.2","user","pwadmin");
> >
> >
> > The user has the right to connect from everywhere to the MYSQL Server
B
> > but everytime it does not connct.
> >
> >
> > Doese anyone has an idea for this?
> your php_mysql client is too old - you need a 4.1.x or later client lib;
> you should tell server A to use PHP 5.0.5, and the php_mysqli extension,
or
> an updated php_mysql for mysql 4.1.x or later; probably you will find
updated
> php_mysql extensions for your old PHP 4.2.4 on the Forge PHP site, or with
my
> builds, cant remember....
> btw. server B might want an update: 5.0.18 is current release...., smile
>
> G.
>

See my last post below that is curently waiting for a response.  I
upgraded to SP5 after it was recommended and receive the same abend
issues.  When someone finds a definitively stable environment involving
Apache, PHP, and MySQL, please let us know.


JGeier wrote:

> Hello Guenter,

> i will look up for a new php_mysql.

> But of cause i tried to use PHP5 that was delivered with NW6.5 OVLSP5.

> But everytime when i triy to connect to the MySQL Server the NetWare
Server
> abends imidietly ..... =:-(

> Kind Regards
> Jens Geier

> "Guenter" <devforums@novell.com> schrieb im Newsbeitrag
> news:AIHNf.2207$oh5.1428@prv-forum2.provo.novell.com...
> > Hi Jens,
> > JGeier<High.Spam@b-w.com> wrote in
> > news:8C8C000044073FEF000060D9@support-forums.novell.com:
> >
> > > i have two nw6.5 sp5 servers.
> > >
> > > Server A) 10.0.1.1 runs Apache 2.0.54 with PHP 4.2.4
> > > Server B) 10.0.1.2 runs MySQL 5.0.11
> > >
> > > I try to use a PHP Script to connect from Server A to Server B
but it
> > > does not work
> > >
> > > mysql_connect
("10.0.1.2","user","pwadmin");
> > >
> > >
> > > The user has the right to connect from everywhere to the MYSQL
Server B
> > > but everytime it does not connct.
> > >
> > >
> > > Doese anyone has an idea for this?
> > your php_mysql client is too old - you need a 4.1.x or later client
lib;
> > you should tell server A to use PHP 5.0.5, and the php_mysqli
extension,
> or
> > an updated php_mysql for mysql 4.1.x or later; probably you will find
> updated
> > php_mysql extensions for your old PHP 4.2.4 on the Forge PHP site, or
with
> my
> > builds, cant remember....
> > btw. server B might want an update: 5.0.18 is current release....,
smile
> >
> > G.
> >

See Guenter's post below for a potential fix.  SP5 did not change my
version of MySQL and was still running 5.0.  I rolled it back to 4.0.25,
so I'm now running:

Apache 2.0.54
PHP 5.0.5
MySQL 4.0.25

At this point, that version configuration is working for me.  I do not
want to get ahead of myself without it working for an extended period of
time, but simply not abending everytime I launch the web app is a huge
hurdle passed.

JGeier wrote:

> Hello Guenter,

> i will look up for a new php_mysql.

> But of cause i tried to use PHP5 that was delivered with NW6.5 OVLSP5.

> But everytime when i triy to connect to the MySQL Server the NetWare
Server
> abends imidietly ..... =:-(

> Kind Regards
> Jens Geier

> "Guenter" <devforums@novell.com> schrieb im Newsbeitrag
> news:AIHNf.2207$oh5.1428@prv-forum2.provo.novell.com...
> > Hi Jens,
> > JGeier<High.Spam@b-w.com> wrote in
> > news:8C8C000044073FEF000060D9@support-forums.novell.com:
> >
> > > i have two nw6.5 sp5 servers.
> > >
> > > Server A) 10.0.1.1 runs Apache 2.0.54 with PHP 4.2.4
> > > Server B) 10.0.1.2 runs MySQL 5.0.11
> > >
> > > I try to use a PHP Script to connect from Server A to Server B
but it
> > > does not work
> > >
> > > mysql_connect
("10.0.1.2","user","pwadmin");
> > >
> > >
> > > The user has the right to connect from everywhere to the MYSQL
Server B
> > > but everytime it does not connct.
> > >
> > >
> > > Doese anyone has an idea for this?
> > your php_mysql client is too old - you need a 4.1.x or later client
lib;
> > you should tell server A to use PHP 5.0.5, and the php_mysqli
extension,
> or
> > an updated php_mysql for mysql 4.1.x or later; probably you will find
> updated
> > php_mysql extensions for your old PHP 4.2.4 on the Forge PHP site, or
with
> my
> > builds, cant remember....
> > btw. server B might want an update: 5.0.18 is current release....,
smile
> >
> > G.
> >