Pb using mysql with php

gaboo · 2005-03-10 21:24:57

I currently have apache/php/mysql installed.

[root@gaboo /]# pacman -Qi | grep apa
apache 2.0.53-2

[root@gaboo /]# pacman -Qi | grep mysql
mysql 4.1.10-1

[root@gaboo /]# pacman -Qi | grep php
php 5.0.3-5

But when I tried to make a mysql connection, I get

Fatal error: Call to undefined function mysql_connect() in /home/httpd/gg/pageprincipale.php on line 16

Moreover, when I display this php page :

<?php phpinfo(); exit(); ?>

I don't have a mysql section, displaying its settings.

The mysql extension is built-in into php5, everything seems at the right place, I can't find why it doesn't work.

Any ideas ? :?:

RedShift · 2005-03-10 21:28:25

try mysqli (www.php.net/mysqli)

neri · 2005-03-10 23:46:22

gaboo wrote:

I don't have a mysql section, displaying its settings.
The mysql extension is built-in into php5, everything seems at the right place, I can't find why it doesn't work.
Any ideas ? :?:

uncomment the extension=mysql.so from /etc/php.ini

-neri

gaboo · 2005-03-12 14:13:52

Are there someone who succeed using php/mysql with the packages provided by arch ?

Because it seems that both mysqli and mysql are compiled although they aren't compatible.

I'm going to compile php myself to try.

neri · 2005-03-12 15:06:40

gaboo wrote:

Are there someone who succeed using php/mysql with the packages provided by arch ?
Because it seems that both mysqli and mysql are compiled although they aren't compatible.
I'm going to compile php myself to try.

did you uncomment this line from php.ini ?

-neri

gaboo · 2005-03-12 18:05:50

Ok, it works now.
I had several problems on my system.

Moreover, the line wasn't commented, but I added it at the end of the config file. But it wasn't working this way.

Anyway, it's ok now.

Thanks !

uberGeek · 2005-07-14 03:55:57

Hey! Thanks for posting your solution to get it working. I'm sure it's helped many others over come the same or similar problems.

rinzai · 2005-07-18 21:25:10

Gee...I had a similar problem...The thing was I had uncommented extension=mysql.so... :shock:

An upgrade from php 5.0.3 to 5.0.4 did the trick...so just as a sidenote:
you might experience problems with php 5.0.3-3 / mysql 4.1.12-1

uberGeek · 2005-07-18 23:42:37

I had to uncomment:

extension=mysql.so

AND THEN edit it to:

extension=mysqli.so

Working great now.

Now that MySQL is working I've started playing with GD in PHP, cool stuff.

Shofs · 2005-09-26 03:48:57

uberGeek wrote:

I had to uncomment:
extension=mysql.so
AND THEN edit it to:
extension=mysqli.so
Working great now.
Now that MySQL is working I've started playing with GD in PHP, cool stuff.

That didn't work for me. I don't have a MySQL section when I go to a phpinfo() page.

EDIT: Thingsare working now. MySQLi is now in the phpinfo().

usedtire · 2005-10-05 00:09:11

Not working for me.

I recently upgraded everything on my server using pacman and now I get the mysql_connect() error. I made sure the extension was uncommented. Restarted httpd, but still nothing. Funny thing is phpMyAdmin works fine.

Odd thing is that all my MySQL passwords no longer work. I had to break into MySQL. ah, the joys of learning things over.

usedtire · 2005-10-05 02:12:03

THis is just plain dumb. I had to create this link

ln -s /usr/lib/php/extensions/no-debug-non-zts-20041030/mysql.so /usr/lib/php/mysql.so

to get it to work.

WHY??

It works, but how often do I need to this? Everytime Pacman upgrades?

Shofs · 2005-10-05 03:01:43

I thought I read somewhere about someone compiling PHP with support for both MySQL and MySQLi. If that is possible I think we should do that because some PHP apps don't work with MySQLi yet.

Any thoughts?

Victor · 2005-10-12 15:05:33

usedtire wrote:

THis is just plain dumb. I had to create this link
ln -s /usr/lib/php/extensions/no-debug-non-zts-20041030/mysql.so /usr/lib/php/mysql.so
to get it to work.
WHY??
It works, but how often do I need to this? Everytime Pacman upgrades?

Instead, you can change the line:

extension_dir = "/usr/lib/php/extensions/no-debug-non-zts-20041030/"

of your /etc/php.ini file

cactus · 2005-10-12 15:57:42

Yeah. I am not happy with the way some of the arch packages are being packaged lately. It seems as time passes, I am having to build more and more of the packages myself after customizing the build. Which is fine...if you like gentoo.

Arch Linux

#1 2005-03-10 21:24:57

Pb using mysql with php

#2 2005-03-10 21:28:25

Re: Pb using mysql with php

#3 2005-03-10 23:46:22

Re: Pb using mysql with php

#4 2005-03-12 14:13:52

Re: Pb using mysql with php

#5 2005-03-12 15:06:40

Re: Pb using mysql with php

#6 2005-03-12 18:05:50

Re: Pb using mysql with php

#7 2005-07-14 03:55:57

Re: Pb using mysql with php

#8 2005-07-18 21:25:10

Re: Pb using mysql with php

#9 2005-07-18 23:42:37

Re: Pb using mysql with php

#10 2005-09-26 03:48:57

Re: Pb using mysql with php

#11 2005-10-05 00:09:11

Re: Pb using mysql with php

#12 2005-10-05 02:12:03

Re: Pb using mysql with php

#13 2005-10-05 03:01:43

Re: Pb using mysql with php

#14 2005-10-12 15:05:33

Re: Pb using mysql with php

#15 2005-10-12 15:57:42

Re: Pb using mysql with php

Board footer