Re: Cannot execute php applications. Problems with required library mysql.so

Well for starters, you shouldn't be running a repetitive process from the web each time, thats why they have cron jobs. In order to have cron jobs execute php code as an executable, you must make sure you have php compiled as a cgi. It seems on your error message also that you don't have php compiled with mysql, you might want to do that also. When compiling, use "./configure -with-mysql", that should do it for MySQL. On Wednesday, March 12, 2003, at 08:24 PM, Mathieu Dumoulin wrote:

Got this problem here. I have a script i wish to run from a crontab every 2 minutes (Compiles live stats for a hockey site). This script doesn't run at all in shell mode as an application but works perfectly fine when called from the web. Problem is i can't integrate it in the web site like when someone adds an event or they have to wait like 30 seconds before being able to enter something else. Talk about live stats if you can only enter 1 shot/hit/faceoff/etc each 30 seconds.. So i HAVE, unless there is a way to do it another way, to run it as a crontab. My question now is: - Can i, from a php script from the web start running another script directly and ignoring the reply...just make it run, thats all and then redirect the user to some other page while it runs - Or, can you help me solve my problem about unloadable libraries: Here is what i can tell from the error i got: =============================== [root@www cron_compile_sys]# ./compileMatches.php Zend Optimizer requires Zend Engine API version 20020429 The installed Zend Engine API version is 20001224 Content-type: text/html PHP Warning: Unable to load dynamic library '/usr/lib/php4/mysql.so' - libmysqlclient.so.10: cannot open shared object file: No such file or directory in Unknown on line 0 X-Powered-By: PHP/4.0.6 Content-type: text/html <br> <b>Fatal error</b>: Call to undefined function: mysql_connect() in <b>/var/www/sandbox.lhjmq.xl5.net/web/classes/class.mysql.connection.php</b> on line <b>53</b><br> =============================== I check my /usr/lib/php4/ folder and it DOES contain the mysql.so file Second, i looked all over the machine to find other PHP interpretors, i found several ones all saying version 4.0.6 although when i run phpinfo.php it says php4.2.2 in the phpinfo response. http://www.lhjmq.qc.ca/phpinfo.php Finaly, since it's a production web server, i cannot take the risk to recompile apache, php or install a new module unless i get an approval from the website owner, so please, if possible try not to give me that as a solution. ohh, another thing. When i directly run the interpreter it says this: =============================== [root@www /]# cd /usr [root@www usr]# cd bin [root@www bin]# php Content-type: text/html PHP Warning: imap: Unable to initialize module Module compiled with module API=20001222, debug=0, thread-safety=0

PHP    compiled with module API=20020429, debug=0, thread-safety=0

These options need to match in Unknown on line 0 PHP Warning: ldap: Unable to initialize module Module compiled with module API=20001222, debug=0, thread-safety=0

PHP    compiled with module API=20020429, debug=0, thread-safety=0

These options need to match in Unknown on line 0 PHP Warning: Unable to load dynamic library '/usr/lib/php4/mysql.so' - libmysqlclient.so.10: cannot open shared object file: No such file or directory in Unknown on line 0 =============================== Please oh please, help me out on this Mathieu Dumoulin Programmer analyst for web solutions www.groupimage.com --PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Richard Sumilang

IT Manager ExexDirect, LLC 21650 Oxnard St., Suite 2350 Woodland Hills, CA 91367 (877) 591-3252 rsumilang@exexdirect.com www.exexdirect.com