Koozali.org: home of the SME Server

php and mysql will not cooperate

b2vn

php and mysql will not cooperate
« on: February 23, 2007, 08:16:30 AM »
Hi all experts

Some time ago I tried to update mysql and php. I got mysql updated to 5.0.27, but php really failed badly, and I had to recover from the installation cd. Ps, running SME 7.1

Now I have access to mysql from shell, but via php.

While looking for the problem, I noticed that mod_mysql was not installed. I tried to install it via the server-manager, and when I look in the list of available packaged mod_mysql is gone, but when in look in the list in 'Remove installed software' nor does it appear here.

What am I missing?

b2vn

php and mysql will not cooperate
« Reply #1 on: February 23, 2007, 09:02:26 AM »
In phpinfo() I have just noticed: '--with-mysql=shared,/usr' Shouldn't this have been something with '/usr/share/mysql', '/usr/lib' or some other path to something with mysql?

b2vn

php and mysql will not cooperate
« Reply #2 on: February 23, 2007, 12:39:28 PM »
I got it running, I updated php to php5 with the help from this:
http://www.dlaoctet.com/index.php/2006/11/13/18-migration-php4-php5-sur-sme-server

Now everthing works... at least everything I have tested till now :)

Offline william_syd

  • *****
  • 1,608
  • +0/-0
  • Nothing to see here.
    • http://www.magicwilly.info
php and mysql will not cooperate
« Reply #3 on: February 23, 2007, 11:09:14 PM »
Quote from: "b2vn"
I got it running, I updated php to php5 with the help from this:
http://www.dlaoctet.com/index.php/2006/11/13/18-migration-php4-php5-sur-sme-server

Now everthing works... at least everything I have tested till now :)


Quote from: "http://www.dlaoctet.com/index.php/2006/11/13/18-migration-php4-php5-sur-sme-server"
So that Apache can take into account the modifications, it is necessary, in the /etc/httpd/conf/httpd.conf file to replace the line,
LoadModule php4_module modules/libphp4.so
by
LoadModule php5_module modules/libphp5.so

Then Apache is started again: httpd - K restart



Not advised.
Regards,
William

IF I give advise.. It's only if it was me....