Thread: Unknown Host in pg_connect()
Hi,
I'm trying to connect to PostgreSQL using pg_connect:
$dbh = pg_connect("host=localhost, dbname=inventory, user=inventoryUser, password=secret");
However, I get an unknow host for localhost:
- - - Schnipp - - -
Warning: Unable to connect to PostgreSQL server: connectDBStart() --
unknown hostname: localhost
- - - Schnapp - - -
gethostbyname() has no problems to resolve localhost.
This is certainly an oversight on my part, but I couldn't find
anything in the books or in the FAQ.
tia,
Thorsten
--
Death to all fanatics!
Try Omitting host=localhost or start the postmaster with -i
$dbh = pg_connect("dbname=inventory, user=inventoryUser, password=secret");
http://www.pgexplorer.com
GUI tool for Postgres
----- Original Message -----
From: "Thorsten Haude" <postgresql@thorstenhau.de>
To: "PostgreSQL PHP ML" <pgsql-php@postgresql.org>
Sent: Sunday, March 24, 2002 2:41 PM
Subject: [PHP] Unknown Host in pg_connect()
> Hi,
>
> I'm trying to connect to PostgreSQL using pg_connect:
> $dbh = pg_connect("host=localhost, dbname=inventory, user=inventoryUser,
password=secret");
>
> However, I get an unknow host for localhost:
> - - - Schnipp - - -
> Warning: Unable to connect to PostgreSQL server: connectDBStart() --
> unknown hostname: localhost
> - - - Schnapp - - -
>
> gethostbyname() has no problems to resolve localhost.
>
> This is certainly an oversight on my part, but I couldn't find
> anything in the books or in the FAQ.
>
> tia,
> Thorsten
> --
> Death to all fanatics!
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
Hi,
>> I'm trying to connect to PostgreSQL using pg_connect:
>> $dbh = pg_connect("host=localhost, dbname=inventory, user=inventoryUser,
>password=secret");
It's a simple syntax error, the commas are not required.
Thorsten
--
The privacy of correspondence, posts and telecommunications shall be inviolable.
- Grundgesetz, Article 10, Sec. 1
Any recommendations for a content management program for PHP + PostgreSQL. Today I was looking at PostNuke, but it uses MySQL.
As far as i was aware, the PostNuke guys had just switched to using ADODB for their db abstraction layer and so postgres support was possible - I might be wrong tho. Chris > -----Original Message----- > From: pgsql-php-owner@postgresql.org > [mailto:pgsql-php-owner@postgresql.org]On Behalf Of Francisco Reyes > Sent: Monday, 8 April 2002 9:21 AM > To: PostgresSQL PHP list > Subject: [PHP] Content management in PHP + PostgreSQL > > > Any recommendations for a content management program for PHP + PostgreSQL. > > Today I was looking at PostNuke, but it uses MySQL. > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster >
On Sun, 7 Apr 2002, Francisco Reyes wrote: > Any recommendations for a content management program for PHP + PostgreSQL. > > Today I was looking at PostNuke, but it uses MySQL. It's a REAL pain in the ass, but I've gotten PostNuke to run with PostgreSQL. For the most part the core stuff is already adodb, but the modules are lacking in readiness. Check out www.clickcorrs.com to see where we're at - it's been production since St Paddy's Day. Ain't been a hell of alot of sleep either since then! Vince. -- ========================================================================== Vince Vielhaber -- KA8CSH email: vev@michvhf.com http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directory http://www.camping-usa.com Online Giftshop Superstore http://www.cloudninegifts.com ==========================================================================
On Sun, 7 Apr 2002, Vince Vielhaber wrote: > On Sun, 7 Apr 2002, Francisco Reyes wrote: > > > Any recommendations for a content management program for PHP + PostgreSQL. > > > > Today I was looking at PostNuke, but it uses MySQL. > > It's a REAL pain in the ass, but I've gotten PostNuke to run with > PostgreSQL. For the most part the core stuff is already adodb, but > the modules are lacking in readiness. Check out www.clickcorrs.com > to see where we're at - it's been production since St Paddy's Day. > Ain't been a hell of alot of sleep either since then! Where do I get the latest code? From the Post-Nuke web site?
On Mon, 8 Apr 2002, Francisco Reyes wrote: > On Sun, 7 Apr 2002, Vince Vielhaber wrote: > > > On Sun, 7 Apr 2002, Francisco Reyes wrote: > > > > > Any recommendations for a content management program for PHP + PostgreSQL. > > > > > > Today I was looking at PostNuke, but it uses MySQL. > > > > It's a REAL pain in the ass, but I've gotten PostNuke to run with > > PostgreSQL. For the most part the core stuff is already adodb, but > > the modules are lacking in readiness. Check out www.clickcorrs.com > > to see where we're at - it's been production since St Paddy's Day. > > Ain't been a hell of alot of sleep either since then! > > Where do I get the latest code? From the Post-Nuke web site? I grabbed it from CVS sometime around the 7.1 release which wasn't adodb complete yet. 7.1.1 is on the website but I haven't looked at it yet. The table setups also took alot of converting but my2pg.pl got me 99% of the way there. I just had to manually go thru and touch things up. One of the biggest problems is that they use the same table variables for inserts, updates and selects. Unfortunately they define them as table.column which doesn't work in pg with inserts. We discussed it recently in Hackers but I don't think anything's happened yet and I haven't looked at it yet. I got rid of the table. part of it and went in and cleaned up the couple dozen or so selects that needed it. I liked the look and ease of administration of postnuke or I wouldn't have gone thru the trouble and the PostNukeBlue theme looks really nice, but doesn't work 100% with netscape 4.7x. Vince. -- ========================================================================== Vince Vielhaber -- KA8CSH email: vev@michvhf.com http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directory http://www.camping-usa.com Online Giftshop Superstore http://www.cloudninegifts.com ==========================================================================
On Mon, 8 Apr 2002, Vince Vielhaber wrote: > We discussed it > recently in Hackers but I don't think anything's happened yet and I > haven't looked at it yet. When you say "we discussed it recently... " Do you mean submited your changes to them?
On Mon, 8 Apr 2002, Francisco Reyes wrote: > On Mon, 8 Apr 2002, Vince Vielhaber wrote: > > > We discussed it > > recently in Hackers but I don't think anything's happened yet and I > > haven't looked at it yet. > > When you say "we discussed it recently... " Do you mean submited > your changes to them? No, it was discussed a while back and the decision was that INSERT INTO foo(foo.a) ... wouldn't be supported. However with other databases supporting it and software such as postnuke trying to do it, that it would be supported under certain conditions. But AFAIK noone's submitted a patch. Vince. -- ========================================================================== Vince Vielhaber -- KA8CSH email: vev@michvhf.com http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directory http://www.camping-usa.com Online Giftshop Superstore http://www.cloudninegifts.com ==========================================================================
On Mon, 8 Apr 2002, Vince Vielhaber wrote: > No, it was discussed a while back and the decision was that > > INSERT INTO foo(foo.a) ... > wouldn't be supported. However with other databases supporting it and > software such as postnuke trying to do it, that it would be supported > under certain conditions. But AFAIK noone's submitted a patch. Ok.. thanks for the info. I guess I will pass on post-nuke for now.
Check out drupal.org I have never used it. Best regards Andy ----- Original Message ----- From: Francisco Reyes <lists@natserv.com> To: Vince Vielhaber <vev@michvhf.com> Cc: Francisco Reyes <lists@natserv.com>; PostgresSQL PHP list <pgsql-php@postgresql.org> Sent: Monday, April 08, 2002 6:51 PM Subject: Re: [PHP] Content management in PHP + PostgreSQL > On Sun, 7 Apr 2002, Vince Vielhaber wrote: > > > On Sun, 7 Apr 2002, Francisco Reyes wrote: > > > > > Any recommendations for a content management program for PHP + PostgreSQL. > > > > > > Today I was looking at PostNuke, but it uses MySQL. > >
Hello Francisco, Monday, April 8, 2002, 3:20:40 AM, you wrote: FR> Any recommendations for a content management program for PHP + PostgreSQL. There is a commercial 4 business only CMS from our company based on postgresql + optional mysql called CMS/R, examples at www.x-itec.net and a customer example at www.familienservice.de IŽm sorry currently only with german documentation and administration, but we are working for an international version. Maybe itŽs interesting for anyone, maybe not - who knows *g -- Best regards, Boris Köster mailto:koester@x-itec.de Developer of X-ITEC CMS/R Content Management System (CMS)