Enviroment variables?

[taiguer]

Hi,

I need to run a php script in the command line that connect's to a mysql DB

php4 some_file.php

And I get this error "Call to undefined function: mysql_connect()"

But my php has the mysql module compiled, i have have some web pages that use php and mysql under apache and I have no problem there.
Can anyone help?

TIA

[erick_w]

May I see your code? There must be something wrong there (as you said that you have other run well with your php)...

and do you compile your PHP on a linux box or windows? which version?

[yelvington]

It is entirely possible that the Apache module was compiled with mysql support, but the stand-alone binary was not. Run "php -m" from the command line and see if it mentions mysql. If it does not, obtain the sources, recompile, and reinstall.

[taiguer]

I'm using php4 from the packages of debian 3, this are the php4 packages that i Have installed
ii libphp-adodb 1.51-1 The 'adodb' database abstraction layer for p
ii libphp-phplot 4.4.6-2 The graphic library for php.
ii php4 4.1.2-5 A server-side, HTML-embedded scripting langu
ii php4-cgi 4.1.2-5 A server-side, HTML-embedded scripting langu
ii php4-gd 4.1.2-5 GD module for php4
ii php4-imap 4.1.2-5 IMAP module for php4
ii php4-mysql 4.1.2-5 MySQL module for php4

this is the output of php4 -m
taiguer@savanah:~$ php4 -m
Running PHP 4.1.2
Zend Engine v1.1.1, Copyright (c) 1998-2001 Zend Technologies

[PHP Modules]
yp
xml
wddx
sysvshm
sysvsem
standard
sockets
shmop
session
posix
pcre
mbstring
iconv
gettext
ftp
filepro
exif
dba
ctype
calendar
bz2
bcmath
zlib

[Zend Modules]
Not Implemented

the script i'm using is from debian package "cacti" and it´s called cmd.php

this script includes another one
include ('include/database.php');
and when running php4 cmd.php this is the error I get

X-Powered-By: PHP/4.1.2
Content-type: text/html

<br />
<b>Fatal error</b>: Call to undefined function: mysql_connect() in <b>/usr/share/cacti/include/database.php</b> on line <b>19</b><br />

database.php is as follows
<?/
+-------------------------------------------------------------------------+
| raXnet Database Wrappers |
+-------------------------------------------------------------------------+
| This code was crafted by Ian Berry, make sure any questions |
| about the structure or integrity of this code be directed to: |
| - [e-mail] |
| - [e-mail] |
+-------------------------------------------------------------------------+
/?>
<?

$current_path = dirname(FILE);
$do_not_read_config = true; include ("$current_path/config.php");

/ if no database name is specified; used default /
if ($database == "") { $database = $database_default; }

$cnn_id = mysql_connect($database_hostname,$database_username,$database_password) or die ("Cannot connect to MySQL server on $database_hostname");
$db = mysql_select_db($database, $cnn_id) or die ("Cannot find the database $database");

And it's included in a lot of other php4 scripts that work perfectly (under apache)

[erick_w]

php -m, I don't see mysql listed there... I suggest you to reinstall your PHP from the source and reconfigure it.

Your code is just okay..