RE: [PHP-DB] mssql_connect not working from command line [RESOLVED]
Thanks for informing me that CGI and CLI may use a different php.ini and that they may be compiled differently. The admin finally admitted that he ran a yum update which overwrote the manually compiled CLI version. The reason I missed it was that the build date of the latest CLI version was earlier than when the scripts broke. _ Climb to the top of the charts! Play Star Shuffle: the word scramble challenge with star power. http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_oct
Re: [PHP-DB] mssql_connect not working from command line
From: Chris <[EMAIL PROTECTED]>
Instruct ICC wrote:
You said something about 2 different configuration files. I'm just making
up this name, but do you have something like:
CLI_Configuration File (php.ini) Path => /etc/cli_php.ini
as well as:
Configuration File (php.ini) Path => /etc/php.ini
I use debian and it places them in different folders:
/etc/php5/apache2/php.ini
and
/etc/php5/cli/php.ini
cat /etc/redhat-release
Fedora Core release 6 (Zod)
dmesg | head
Linux version 2.6.20-1.2962.fc6 ([EMAIL PROTECTED])
(gcc version 4.1.1 20070105 (Red Hat 4.1.1-51)) #1 SMP Tue Jun 19 19:27:14
EDT 2007
php -version
PHP 5.1.6 (cli) (built: May 9 2007 11:47:50)
The strange thing is that it used to work up until apparently Jul 31. And
the /etc/php.ini had been changed well before that (and had been working on
both web and cli).
1) A web page referencing mssql_connect works in a browser.
2) A cronjob (CLI) referencing mssql_connect which had been working now does
not work.
New Info:
3) Attempting to run the web page from the command line fails on at
mssql_connect.
4) A CLI script using file("The web page") actually works?!?!?!?!
_
Gear up for Halo® 3 with free downloads and an exclusive offer.
http://gethalo3gear.com?ocid=SeptemberWLHalo3_MSNHMTxt_1
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] mssql_connect not working from command line
Instruct ICC wrote: From: Chris <[EMAIL PROTECTED]> Instruct ICC wrote: Both your command php -i | grep 'php.ini' and find / -name php.ini 2>/dev/null report the single /etc/php.ini Hmm. do a php -i and look for: Configuration File (php.ini) Path => That will tell you where it's looking for the file. Maybe you need to create that file (or just symlink it to the other one). I get Configuration File (php.ini) Path => /etc/php.ini Hmm strange. Looks ok. You said something about 2 different configuration files. I'm just making up this name, but do you have something like: CLI_Configuration File (php.ini) Path => /etc/cli_php.ini as well as: Configuration File (php.ini) Path => /etc/php.ini I use debian and it places them in different folders: /etc/php5/apache2/php.ini and /etc/php5/cli/php.ini -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] mssql_connect not working from command line
From: Chris <[EMAIL PROTECTED]> Instruct ICC wrote: Both your command php -i | grep 'php.ini' and find / -name php.ini 2>/dev/null report the single /etc/php.ini Hmm. do a php -i and look for: Configuration File (php.ini) Path => That will tell you where it's looking for the file. Maybe you need to create that file (or just symlink it to the other one). I get Configuration File (php.ini) Path => /etc/php.ini You said something about 2 different configuration files. I'm just making up this name, but do you have something like: CLI_Configuration File (php.ini) Path => /etc/cli_php.ini as well as: Configuration File (php.ini) Path => /etc/php.ini Then I could see having "CLI_Configuration File" exist and reference _some_ file. _ Get a FREE small business Web site and more from Microsoft® Office Live! http://clk.atdmt.com/MRT/go/aub0930003811mrt/direct/01/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] mssql_connect not working from command line
Instruct ICC wrote: However, a web page that includes the same file with the mssql_connect call still works fine, and now it makes sense that I see mssql is still enabled in phpinfo. The apache version of the php.ini file is different to the cli version. Make sure you are looking at the right one. On debian I have two separate directories for each config - /etc/php5/apache2/ and /etc/php5/cli/ Try this: php -i | grep 'php.ini' from the command line to work out which php.ini to look at. Both your command php -i | grep 'php.ini' and find / -name php.ini 2>/dev/null report the single /etc/php.ini Hmm. do a php -i and look for: Configuration File (php.ini) Path => That will tell you where it's looking for the file. Maybe you need to create that file (or just symlink it to the other one). -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] mssql_connect not working from command line
However, a web page that includes the same file with the mssql_connect call still works fine, and now it makes sense that I see mssql is still enabled in phpinfo. The apache version of the php.ini file is different to the cli version. Make sure you are looking at the right one. On debian I have two separate directories for each config - /etc/php5/apache2/ and /etc/php5/cli/ Try this: php -i | grep 'php.ini' from the command line to work out which php.ini to look at. Both your command php -i | grep 'php.ini' and find / -name php.ini 2>/dev/null report the single /etc/php.ini Is there something in php.ini that would: 1) Allow web pages to work with mssql_connect 2) Allow the command line to use other PHP functions 3) Disallow mssql_connect from a script run from the command line _ Can you find the hidden words? Take a break and play Seekadoo! http://club.live.com/seekadoo.aspx?icid=seek_hotmailtextlink1 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] mssql_connect not working from command line
However, a web page that includes the same file with the mssql_connect call still works fine, and now it makes sense that I see mssql is still enabled in phpinfo. The apache version of the php.ini file is different to the cli version. Make sure you are looking at the right one. On debian I have two separate directories for each config - /etc/php5/apache2/ and /etc/php5/cli/ Try this: php -i | grep 'php.ini' from the command line to work out which php.ini to look at. -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] mssql_connect not working from command line
I had cronjobs running fine on Linux which included a file which called mssql_connect. Today when I run the cronjob script directly from the command line, I get: PHP Fatal error: Call to undefined function mssql_connect() in /the/included/file.php on line # Fatal error: Call to undefined function mssql_connect() in /the/included/file.php on line # I also notice that the cronjob started failing 1 month ago. The file is owned by the command line user and apache is in its group and vice versa. However, a web page that includes the same file with the mssql_connect call still works fine, and now it makes sense that I see mssql is still enabled in phpinfo. The admin says nothing changed. Is there a setting that must have been changed to disallow this function from working on the command line? I'm using PHP Version 5.1.6 and /etc/php.ini has changed 2 months ago and the cronjob worked since then. _ Gear up for Halo® 3 with free downloads and an exclusive offer. http://gethalo3gear.com?ocid=SeptemberWLHalo3_MSNHMTxt_1 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
