mysql_connect Fatal Error - Help

michelle

Hi,

I'm really stuck, I am using Redhat 7.2 w/Apache mod_php and MySQL.

MySQL client works fine.
PHP code in apache works fine,
and PHP does have the MySQL option compled in ('--with-mysql=shared').

I keep getting;

"PHP Fatal error: Call to undefined function: mysql_connect()"

in the HTTPD error log.

The client page is output up to the 'call' but stops at that statement.

Maybe it's a php.ini library issue ????

nevermore2181

You might have better luck searching/posting in the Install Help, or General Help Forums.

michelle

Thanks,

I've been reading and trying all day with no luck. I don't understand why php dosen't see the function.

nevermore2181

The only thing I can find is this:

In order to have these functions available, you must compile PHP with MySQL support by using the --with-mysql option. If you use this option without specifying the path to MySQL, PHP will use the built-in MySQL client libraries. Users who run other applications that use MySQL (for example, running PHP 3 and PHP 4 as concurrent apache modules, or auth-mysql) should always specify the path to MySQL: --with-mysql=/path/to/mysql. This will force PHP to use the client libraries installed by MySQL, avoiding any conflicts.

It would seem that the directory of your --with-mysql is wrong, or the client libraries didn't install correctly.

michelle

Is that directory in php.ini ?

In my second post I pasted from the info() and mysql appears to be complied in.

Users who run other applications that use MySQL (for example, running PHP 3 and PHP 4 as concurrent apache modules, or auth-mysql) should always specify the path to MySQL: --with-mysql=/path/to/mysql.

That's my system OK.

But is the path to the php lib set in php.ini ??

michelle

Additional note:

Should

;extension=ifx.so
extension=imap.so
;extension=interbase.so
;extension=java.so
extension=ldap.so
;extension=mhash.so
;extension=mssql65.so
;extension=mssql70.so
;extension=mysql.so <--------- ****
;extension=oas.so
extension=odbc.so
;extension=oci8.so
;extension=oracle.so
;extension=pdf.so
;extension=pgsql.so
;extension=sablot.so

** in php.ini be ignored or enabled,
OBCD

nevermore2181

Wish I could say, unfortunately, I know more about PHP and MySQL coding, than I do about installation/configuration.

michelle

God, There's got to be a better way to do this.

Maybe someone could build a PHP script to configure of fix PHP's little issues, kind of like the registry cleaner/fixers???

M...

dannys

Have you tried compiling *WITHOUT* the --with-mysql option? PHP has MySQL functionality builtin, therefore there is no real need to add --with-mysql especially if you're having problems doing so.

So, try it without, if it still doesn't work, then i'm stumped too 🙂

HTH

Anon

It is automatically enabled in Windows, but it is not in Linux (which is what Michelle is using)...

Diego

Anon

have you tried installing without the "shared" part?

i.e. compile with --with-mysql

Diego

dannys

Wanna bet? I use the linux build (wouldn't touch Windows for serving) and i've used 4.0.4 right through to 4.1.2 and they all have MySQL functionality built in, no config necessary, the only way I know of disabling mysql is to build using --without-mysql!

michelle

Sorry, I'm also confuzzed, the doc's state to MAKE SURE it IS complied in?

I need MySQL to work from within Apache, and php, php3, and php4 all work fine.

MySQL works fine from the command line also.

Whenever I use the mysql_connect, statement, inside <?php, it errors, it seems that php dosen't see the statement as a key word at all.

I installed php as an rpm, and I haven't complied it myself yet.

Am I to understand that MySQL is an external module that is linked to php at COMPILE time, or RUN TIME?

If it's at RUN TIME, then maybe it can't see the library link.

Anon

Michelle,

I had similiar problem on a clean install of Red Hat 7.3. Installing the php-mysql RPM worked like a champ for me. HTH.

Ken