Problem after an upgrade to php 5.0.1 and Apache 1.3.31

NothingHere

Hello,

I have upgraded, on linux redhat 8, to Apache 1.3.31 and PHP 5.0.1.
I think all was good but, POST method on Form did not work (simple html form post with login & pass in a database), and create of mysql db wouldn't work ( with mysql_create_db() I have the error "Call to undefined function : mysql_create_db()").

I think I have doing something wrong when I was installing PHP, so I have rebuild it with a minimal configuration (just mysql, apxs, and config-file-path ).
Nothing appens ... same problem as above.

I decided to go back to my old PHP (4.3.2) and Apache (1.3.29) ... always same problem (and I've tested with all my config option or just basic config option).

I need to use mysql_create_db() (yes I know it's depreciated), and of course I need to use the post method in my form.

I've try to not specify my mysql dir when I do "./configure --with-mysql", but I need to specify on configure of PHP where mysql is ( so I use ./configure --with-mysql=/opt/mysql ).

All other query between php and mysql seem to work fine ( and PHPMyAdmin works fine ! ).

Anyone have an idea ? I fond nothing on google ...

Please, need help ... really !

NothingHere

for the first error, I see that my "register_globals" where Off, not "On"...
First "bug" resolved =)

But if anyone have an idea for mysql_create_db(), please tell me.

I've tried this :

<?php
    // you need to replace server, username and paswword with your own data
    $link = mysql_connect("server", "username", "password")
        or exit("Can not make an connection: " . mysql_error());
    if (mysql_create_db("my_db")) {
        print ("Database successfully created\n");
    } else {
        printf ("Error with creation of database: %s\n", mysql_error());
    }
?>

For that I have :
Fatal error: Call to undefined function mysql_create_db() in /var/www/test.php on line 5

Thats help you on something ? ... not me ... 🙁

Thanks for help ...

Nothing

d_l

I'm a Windows user .. not Linux ..

but a quick search (not on google) found this thread .. might help you ..

www.linuxquestions.org

NothingHere

Thanks, I read this post.
There is no "mysql.so" on my computer, and I installed php & apache from source, not from rpm.

PHP 4.3.2 works fine with "mysql_create_db", and I see there is no line in php.ini 4.3.2 about mysql.so , so I think I don't need it ...

"mysql_create_db" don't work since I've upgraded from PHP 4.3.2 to PHP 5.0.1 ...

Any other tips ?

d_l

well .. as a long shot I can give one tip ..

when troubleshooting such issues (in windows) I sometimes use utilities from sysinternals.com

in Windows I use FILEMON and PROCEXP ..

FILEMON picks up failed paths ..
PROCEXP picks up all dll's used in Apache.exe

...

but only FILEMON is available in Linux .. try that .. FILEMON Linux version

setup the filters ..

exclude field .. define all running processes you wish to exclude from the monitor window
include field .. insert keywords to be monitored .. like php;mysql

then clear the monitor window and stop/restart the Apache server
you might find some failed path or other problem in your configuration or when running the script.

If nothing else, it gives a useful insight .. perhaps some clues.

...

another useful troubleshooting tool is .. dependency walker .. but unfortunately not available for Linux.

p.s. .. this site .. suggests use mysql_query instead ..

and perhaps read the note in this page .. what version MySQL do you have ??

Warning This function will not be available if the MySQL extension was built against a MySQL 4.x client library.

p.p.s.

here is another thought

in PHP4 the path to extensions is C:\PHP\extensions\

in PHP5 this path is C:\PHP\ext\

so .. check extension_dir in php.ini ..