adodb-mysql.inc.php error

adodb-mysql.inc.php error

par Pat Simmons,
Nombre de réponses : 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
Moyenne des évaluations  -
En réponse à Pat Simmons

Re: adodb-mysql.inc.php error

par Martin Dougiamas,
Avatar Core developers Avatar Documentation writers Avatar Moodle HQ Avatar Particularly helpful Moodlers Avatar Plugin developers Avatar Testers
Does your PHP installation have MySQL support compiled in?

You can check using a small PHP file containing <? phpinfo() ?>
En réponse à Pat Simmons

Re: adodb-mysql.inc.php error

par 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?
En réponse à Simon Pichette

Re: adodb-mysql.inc.php error

par Martin Dougiamas,
Avatar Core developers Avatar Documentation writers Avatar Moodle HQ Avatar Particularly helpful Moodlers Avatar Plugin developers Avatar Testers
dbx is installed (with MySQL support), but plain MySQL support isn't (and it needs to be).
En réponse à Martin Dougiamas

Re: adodb-mysql.inc.php error

par Simon Pichette,
Can you give me any directions?
En réponse à Simon Pichette

Re: adodb-mysql.inc.php error

par Martin Dougiamas,
Avatar Core developers Avatar Documentation writers Avatar Moodle HQ Avatar Particularly helpful Moodlers Avatar Plugin developers Avatar 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
En réponse à Martin Dougiamas

Re: adodb-mysql.inc.php error

par 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 !
En réponse à Simon Pichette

PHP support

par Martin Dougiamas,
Avatar Core developers Avatar Documentation writers Avatar Moodle HQ Avatar Particularly helpful Moodlers Avatar Plugin developers Avatar 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.
En réponse à Martin Dougiamas

Re: PHP support

par 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...