adodb-mysql.inc.php error

adodb-mysql.inc.php error

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
In reply to Pat Simmons

Re: adodb-mysql.inc.php error

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

Martin Dougiamas - келді
Core developers қатысушының суреті Documentation writers қатысушының суреті Moodle HQ қатысушының суреті Particularly helpful Moodlers қатысушының суреті Plugin developers қатысушының суреті 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

Simon Pichette - келді
In reply to Simon Pichette

Re: adodb-mysql.inc.php error

Martin Dougiamas - келді
Core developers қатысушының суреті Documentation writers қатысушының суреті Moodle HQ қатысушының суреті Particularly helpful Moodlers қатысушының суреті Plugin developers қатысушының суреті 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

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

Martin Dougiamas - келді
Core developers қатысушының суреті Documentation writers қатысушының суреті Moodle HQ қатысушының суреті Particularly helpful Moodlers қатысушының суреті Plugin developers қатысушының суреті 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

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