PHP and MYSQL ("mysql_connect")

smaida · 05-17-2004, 04:00 PM

Hello,

I am currently trying to install phpbb on debian with apache2 and I have been chasing down a blank index.php issue for several days.

It appears now that the server is unable to find the function "mysql_connect" which I suspect is at the core of my problem.

Here is the configure command displayed from my phpinfo script:

Code:

 	 '../configure' '--prefix=/usr' '--with-apxs2=/usr/bin/apxs2'

'--with-regex=php' '--with-config-file-path=/etc/php4/apache2' '--disable-rpath' '--enable-memory-limit' '--disable-debug' '--with-layout=GNU' '--with-pear=/usr/share/php' '--enable-calendar' 
'--enable-sysvsem' '--enable-sysvshm' '--enable-track-vars' 
'--enable-trans-sid' '--enable-bcmath' '--with-bz2' '--enable-ctype' 
'--with-db4' '--with-iconv' '--enable-exif' '--enable-filepro' '--enable-ftp' 
'--with-gettext' '--enable-mbstring' '--with-pcre-regex=/usr' 
'--enable-shmop' '--enable-sockets' '--enable-wddx' '--disable-xml' 
'--with-expat-dir=/usr' '--enable-yp' '--with-zlib' '--without-pgsql' 
'--with-kerberos=/usr' '--with-openssl=/usr' 
'--with-exec-dir=/usr/lib/php4/libexec' '--disable-static' 
'--with-curl=shared,/usr' '--with-dom=shared,/usr' 
'--with-dom-xslt=shared,/usr' '--with-dom-exslt=shared,/usr' 


'--with-zlib-dir=/usr' '--with-gd=shared,/usr' '--enable-gd-native-ttf' 
'--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-imap-ssl' '--with-ldap=shared,/usr' 
'--with-mcal=shared,/usr' '--with-mhash=shared,/usr' '--without-mm' 
'--with-mysql=shared,/usr' '--with-unixODBC=shared,/usr' 
'--with-recode=shared,/usr' '--enable-xslt=shared' 
'--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'

Doesn't the above mean that mysql support is installed or is this just the command that was run when configuring php?

If in fact php mysql support is not installed do you have any suggestions?

php, apache, mysql and phpbb were all installed using apt and the php4.load and php4.conf symlinks are set in the mods-enabled section of /etc/apache2/

Squirrelmail and phpmyadmin work with out error althout testing for the mysql_connect function in their respective directories also shows that the function is not available.

Thanks for the help

Shawn

Mara · 05-17-2004, 04:59 PM

Do you have php4-mysql package?

smaida · 05-17-2004, 05:40 PM

Yes,

It's been installed with apt.

smaida · 05-17-2004, 05:55 PM

I uncommented the following line in my php.ini file.

extension=mysql.so

Then I restarted apache and I am now getting the following error in my php.log file.

[17-May-2004 17:47:41] PHP Warning: Unknown(): Unable to load dynamic library '/usr/lib/php4/20020429/msql.so' - /usr/lib/php4/20020429/msql.so: cannot open shared object file: No such file or directory in Unknown on line 0

The file
/usr/lib/php4/20020429/msql.so
does exist

permission are
drwxr-xr-x root root 20020429
-rw-r--r-- root root mysql.so

Not sure if the permissions are the problem or if it's somthing else. I tried changing the permissions and ownership, but that doesn't seem to do anything.

Thanks

Mara · 05-18-2004, 05:27 PM

Try to make the library executable.