adodb-mysql.inc.php error

adodb-mysql.inc.php error

by Pat Simmons -
Number of replies: 8
Fatal error: Call to undefined function: mysql_pconnect() in /var/www/html/moodle/lib/adodb/drivers/adodb-mysql.inc.php on line 120
Make any sense to anybody. This time am installing on redhat 7.2 using mysql 3.23.41 and apache 1.3.20 and PHP 4.

It's probably something i've forgot to set. I've just been working on this project for so long now that i almost forgot my own name! (-:

pat
Average of ratings: -
In reply to Pat Simmons

Re: adodb-mysql.inc.php error

by Martin Dougiamas -
Picture of Core developers Picture of Documentation writers Picture of Moodle HQ Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers
Does your PHP installation have MySQL support compiled in?

You can check using a small PHP file containing <? phpinfo() ?>
In reply to Pat Simmons

Re: adodb-mysql.inc.php error

by Simon Pichette -
I have the same problem here, albeit with different versions. I am using RedHat 8.0, Apache 2.0.40, MySQL 3.23 and PHP 4.

PHP info here : http://praxis.fsa.ulaval.ca

MySQL is listed under the DBX group. I assumed it meant it was properly included in PHP. My installation of PHPMyAdmin, under the moodle/admin/mysql/ directory also does not work, producing only blank pages, So There must be a problem between mysql and PHP after all.

Any Ideas?
In reply to Simon Pichette

Re: adodb-mysql.inc.php error

by Martin Dougiamas -
Picture of Core developers Picture of Documentation writers Picture of Moodle HQ Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers
dbx is installed (with MySQL support), but plain MySQL support isn't (and it needs to be).
In reply to Martin Dougiamas

Re: adodb-mysql.inc.php error

by Simon Pichette -
Can you give me any directions?
In reply to Simon Pichette

Re: adodb-mysql.inc.php error

by Martin Dougiamas -
Picture of Core developers Picture of Documentation writers Picture of Moodle HQ Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers
Well, there are better places on the web than this for PHP support, but you need to check the --with-mysql is working when configuring/compiling PHP.

Here is the compile command I used to compile PHP 4.3.0 on a fairly stock Redhat 7.3 box:

./configure --with-mysql --with-pgsql=/usr --enable-track-vars --enable-trans-sid --with-gd --with-jpeg-dir=/usr --with-ttf --with-zlib-dir=/usr --with-xpm-dir=/usr/X11R6 --with-freetype-dir=/usr --with-apxs=/opt/bin/apxs
In reply to Martin Dougiamas

Re: adodb-mysql.inc.php error

by Simon Pichette -
A pointer to one of those better places would have been sufficient and was actually what I expected.

Thanks for getting out of your way to help.

I think I will try to avoid recompiling and find the appropriate RPM, maybe on RPMfind.

I will keep the command close at hand in case I cannot avoid recompiling.

Have a nice day !
In reply to Simon Pichette

PHP support

by Martin Dougiamas -
Picture of Core developers Picture of Documentation writers Picture of Moodle HQ Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers
Sorry, I didn't know what your skills were.

Since it appears you're using the standard RPMs that came with RedHat 8.0, it seems very strange that MySQL isn't working by default. Perhaps this problem is caused by something else (unfortunately I don't know what).

As an aside, I'd like to put put more information about installing PHP in Moodle's install documentation - so any good HOWTOs/packages/forums that you find for PHP on Redhat would be much appreciated.
In reply to Martin Dougiamas

Re: PHP support

by Simon Pichette -
Hi, I finally found where the problem lied.

It seems Red Hat 8.0 does not install the PHP-mysql package by itself when you install Apache, PHP and MySQL. You have to manually install the php-mysql-4.2.2-8.0.5.i386.rpm file wich is on CD 3.

See the thread below this article :
http://www.phpfreaks.com/articles/51/0.php

Hope this can help some others...