Thread: Unknown Host in pg_connect()

Unknown Host in pg_connect()

From
Thorsten Haude
Date:
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!

Re: Unknown Host in pg_connect()

From
"PG Explorer"
Date:
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


Re: Unknown Host in pg_connect()

From
Thorsten Haude
Date:
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

Content management in PHP + PostgreSQL

From
Francisco Reyes
Date:
Any recommendations for a content management program for PHP + PostgreSQL.

Today I was looking at PostNuke, but it uses MySQL.


Re: Content management in PHP + PostgreSQL

From
"Christopher Kings-Lynne"
Date:
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
>


Re: Content management in PHP + PostgreSQL

From
Vince Vielhaber
Date:
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
==========================================================================




Re: Content management in PHP + PostgreSQL

From
Francisco Reyes
Date:
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?


Re: Content management in PHP + PostgreSQL

From
Vince Vielhaber
Date:
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
==========================================================================




Re: Content management in PHP + PostgreSQL

From
Francisco Reyes
Date:
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?


Re: Content management in PHP + PostgreSQL

From
Vince Vielhaber
Date:
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
==========================================================================




Re: Content management in PHP + PostgreSQL

From
Francisco Reyes
Date:
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.



Re: Content management in PHP + PostgreSQL

From
"Andy Samuel"
Date:
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.
> >




Re: Content management in PHP + PostgreSQL

From
Boris Köster
Date:
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)