Linode.com Forum

[OrionXI]

I installed apache-ssl, php4 and mysql 3.23.49 using apt-get. They all work fine by themselves, and apache has no problem with the usual php functions, e.g. phpinfo(). But when I try to connect to mysql with a script using

mysql_connect("localhost", "root", "*******") or exit();

I get the error message:

Fatal error: Call to undefined function: mysql_connect() in /var/www/htdocs/index.php on line 36

Then I tried:

apt-get install php4-mysql

but I still get the same error message.

Any ideas?? Thanks.

[rko]

When you run phpinfo(), what do you get for "Configure Command" values? Sounds like you have php version in apache that don't have mysql built in.

Risto

[OrionXI]

Here's what I get from phpinfo():

'../configure' '--prefix=/usr' '--with-apxs=/usr/bin/apxs' '--with-regex=php' '--with-config-file-path=/etc/php4/apache' '--disable-rpath' '--disable-debug' '--enable-memory-limit' '--enable-calendar' '--enable-sysvsem' '--enable-sysvshm' '--enable-track-vars' '--enable-trans-sid' '--enable-bcmath' '--with-bz2' '--enable-ctype' '--with-db2' '--with-iconv' '--with-ndbm' '--enable-exif' '--enable-filepro' '--enable-ftp' '--with-gettext' '--enable-mbstring' '--with-pcre-regex=/usr' '--enable-shmop' '--enable-sockets' '--enable-wddx' '--with-xml=/usr' '--with-expat-dir=/usr' '--enable-yp' '--with-zlib' '--without-pgsql' '--disable-static' '--with-layout=GNU' '--with-curl=shared,/usr' '--with-dom=shared,/usr' '--with-zlib-dir=/usr' '--with-gd=shared,/usr' '--with-jpeg-dir=shared,/usr' '--with-xpm-dir=shared,/usr/X11R6' '--with-png-dir=shared,/usr' '--with-freetype-dir=shared,/usr' '--with-imap=shared,/usr' '--with-ldap=shared,/usr' '--with-mcal=shared,/usr' '--with-mhash=shared,/usr' '--with-mm' '--with-mysql=shared,/usr' '--with-unixODBC=shared,/usr' '--with-recode=shared,/usr' '--enable-xslt' '--with-xslt-sablot=shared,/usr' '--with-snmp=shared' '--enable-ucd-snmp-hack' '--with-sybase-ct=shared,/usr' '--with-ttf=shared,/usr' '--with-t1lib=shared,/usr'

You can see it has '--with-mysql=shared,/usr' in there. Dunno if that's sufficient....

[komy]

In your php.ini, have you load the mysql.so extension?

I compiled php manually and I have to load the extension manually in php.ini in order to get it work.

You should have a line like:

Code: extension=mysql.so

in your ini file. Be sure to point the extension_dir to the dir where your extensions are located.

Hope this help.

Kevin

[OrionXI]

I was sure that I had already put the

extension=mysql.so

line in php.ini. But when I just checked it, it wasn't there. I must have forgot to save it.....hmmm. It works fine now. Thanks.