For Programmers: Free Programming Magazines  


Home > Archive > PHP DB > September 2007 > Re: [PHP-DB] mssql_connect not working from command line









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: [PHP-DB] mssql_connect not working from command line
Chris

2007-09-10, 9:59 pm


> 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/
Instruct ICC

2007-09-11, 6:59 pm

>>However, a web page that includes the same file with the mssql_connect
>
>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 Sadoo!
[url]http://club.live.com/sadoo.aspx?icid=s_hotmailtextlink1[/url]
Chris

2007-09-11, 10:01 pm

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).

--
Postgresql & php tutorials
http://www.designmagick.com/
Instruct ICC

2007-09-12, 6:59 pm

>From: Chris <dmagick@gmail.com>
>
>Instruct ICC wrote:
>
>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/
Chris

2007-09-12, 9:58 pm

Instruct ICC wrote:
>
> 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/
Instruct ICC

2007-09-13, 6:59 pm

>From: Chris <dmagick@gmail.com>
>Instruct ICC wrote:
>
>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 (brewbuilder@ls20-bc2-14.build.redhat.com)
(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=Septem...alo3_MSNHMTxt_1
Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com