adodb-mysql.inc.php error

adodb-mysql.inc.php error

door Pat Simmons -
Aantal antwoorden: 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
Gemiddelde van de beoordelingen:  -
Als antwoord op Pat Simmons

Re: adodb-mysql.inc.php error

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

You can check using a small PHP file containing <? phpinfo() ?>
Gemiddelde van de beoordelingen:  -
Als antwoord op Pat Simmons

Re: adodb-mysql.inc.php error

door 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?
Gemiddelde van de beoordelingen:  -
Als antwoord op Simon Pichette

Re: adodb-mysql.inc.php error

door Martin Dougiamas -
Foto van Core developers Foto van Documentation writers Foto van Moodle HQ Foto van Particularly helpful Moodlers Foto van Plugin developers Foto van Testers
dbx is installed (with MySQL support), but plain MySQL support isn't (and it needs to be).
Gemiddelde van de beoordelingen:  -
Als antwoord op Martin Dougiamas

Re: adodb-mysql.inc.php error

door Simon Pichette -
Can you give me any directions?
Gemiddelde van de beoordelingen:  -
Als antwoord op Simon Pichette

Re: adodb-mysql.inc.php error

door Martin Dougiamas -
Foto van Core developers Foto van Documentation writers Foto van Moodle HQ Foto van Particularly helpful Moodlers Foto van Plugin developers Foto van 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
Gemiddelde van de beoordelingen:  -
Als antwoord op Martin Dougiamas

Re: adodb-mysql.inc.php error

door 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 !
Gemiddelde van de beoordelingen:  -
Als antwoord op Simon Pichette

PHP support

door Martin Dougiamas -
Foto van Core developers Foto van Documentation writers Foto van Moodle HQ Foto van Particularly helpful Moodlers Foto van Plugin developers Foto van 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.
Gemiddelde van de beoordelingen:  -
Als antwoord op Martin Dougiamas

Re: PHP support

door 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...
Gemiddelde van de beoordelingen:  -