RE: [PHP] Problem connecting to Postgres

2004-08-23 Thread Jay Blanchard
[snip]
Fatal error: Call to undefined function:  pg_connect() in 
/Users/jcapy2/Sites/Jesper/SyncPosgresToMbrMaxData
.php on line 28
[/snip]

http://www.php.net/manual/en/features.commandline.php

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Problem connecting to Postgres

2004-08-23 Thread Joshua Capy
Thanks
On Aug 23, 2004, at 12:04 PM, Jay Blanchard wrote:
[snip]
Fatal error: Call to undefined function:  pg_connect() in
/Users/jcapy2/Sites/Jesper/SyncPosgresToMbrMaxData
.php on line 28
[/snip]
http://www.php.net/manual/en/features.commandline.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


Re: [PHP] Problem connecting to Postgres

2004-08-23 Thread Michal Migurski
 I am a newby having a configuration problem. I am using PHP 4.3.6 and
 postgres 7.4.3

 The problem is when I try to execute my php scripts that connect to
 postgres from the command line I get error like this:

 Fatal error: Call to undefined function:  pg_connect() in
 /Users/jcapy2/Sites/Jesper/SyncPosgresToMbrMaxData
 .php on line 28

 But it works fine from a browser using apache.

The version of PHP used by Apache may not necessarily have been configured
the same way as the one you're using on the command line. Try phpinfo() to
determine what's there, and recompile/reinstall if you're lacking PG
support. Or, try to find the command line instance that corresponds to the
apache module you're using.

-
michal migurski- contact info and pgp key:
sf/cahttp://mike.teczno.com/contact.html

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Problem connecting to Postgres

2004-08-23 Thread Joshua Capy
Yes I have found that I am running v 4.3.2 on the command line and 
4.3.6 under apache

Is it possible to run the same version both on the command line and 
running on apache?


On Aug 23, 2004, at 12:23 PM, Michal Migurski wrote:
I am a newby having a configuration problem. I am using PHP 4.3.6 and
postgres 7.4.3
The problem is when I try to execute my php scripts that connect to
postgres from the command line I get error like this:
Fatal error: Call to undefined function:  pg_connect() in
/Users/jcapy2/Sites/Jesper/SyncPosgresToMbrMaxData
.php on line 28
But it works fine from a browser using apache.
The version of PHP used by Apache may not necessarily have been 
configured
the same way as the one you're using on the command line. Try 
phpinfo() to
determine what's there, and recompile/reinstall if you're lacking PG
support. Or, try to find the command line instance that corresponds to 
the
apache module you're using.

-
michal migurski- contact info and pgp key:
sf/cahttp://mike.teczno.com/contact.html
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


RE: [PHP] Problem connecting to Postgres

2004-08-23 Thread Jay Blanchard
[snip]
Yes I have found that I am running v 4.3.2 on the command line and 
4.3.6 under apache

Is it possible to run the same version both on the command line and 
running on apache?
[/snip]

Yes.

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Problem connecting to Postgres

2004-08-23 Thread Joshua Capy
Ok next stupid question
At the command line how to I force the execution of the 4.3.6 apache 
version or change the default to it.

On Aug 23, 2004, at 2:39 PM, Jay Blanchard wrote:
[snip]
Yes I have found that I am running v 4.3.2 on the command line and
4.3.6 under apache
Is it possible to run the same version both on the command line and
running on apache?
[/snip]
Yes.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


RE: [PHP] Problem connecting to Postgres

2004-08-23 Thread Jay Blanchard
[snip]
At the command line how to I force the execution of the 4.3.6 apache 
version or change the default to it.
[/snip]

You need to install the proper CLI version as described
http://www.php.net/manual/en/features.commandline.php

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] Problem connecting to Postgres

2004-08-23 Thread Jason Wong
On Tuesday 24 August 2004 02:42, Joshua Capy wrote:
 Ok next stupid question

 At the command line how to I force the execution of the 4.3.6 apache
 version or change the default to it.

What one usually does is compile different 'versions' of php using the same 
config options (if you want them to have the same functionality).

The most common case would be to compile an apache module version, and CLI 
version. You can in fact compile and install both in one operation but I 
prefer to separate them so I can specify different php.ini for each.

All the boring details are in the manual.

-- 
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design  Hosting * Internet  Intranet Applications Development *
--
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-general
--
/*
You had some happiness once, but your parents moved away, and you had to
leave it behind.
*/

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php