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
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
