pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: connection error
6+ messages / 6 participants
[nested] [flat]

* connection error
@ 2003-10-02 19:45 Ana Carolina Alonso de Armiño <aalonso@uncoma.edu.ar>
  2003-10-02 19:45 ` Re: connection error scott.marlowe <scott.marlowe@ihs.com>
  2003-10-02 20:02 ` Re: connection error Martin Marques <martin@bugs.unl.edu.ar>
  0 siblings, 2 replies; 6+ messages in thread

From: Ana Carolina Alonso de Armiño @ 2003-10-02 19:45 UTC (permalink / raw)
  To: pgsql-php

Hi, i had installed postgress 7.3 in a database server, and php is running 
in an apache web server.
There are 6 databases. I can access to one of then from a php pages, and 
the system work fine.
The problem is when I want to access from a php page to another database. 
The conection is failed.
I had created this database using next comand:

createdb expedientes

And from phppgadmin (2.4.2) I had add privileges to a user. And I do the 
conect from the php page with this user. The do the conection with:

pg_pconnect(" host=one_host dbname=one_dbase user=one_user password=one_pass")

Some ideas?
Thanks in advance.

Ana

^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: connection error
  2003-10-02 19:45 connection error Ana Carolina Alonso de Armiño <aalonso@uncoma.edu.ar>
@ 2003-10-02 19:45 ` scott.marlowe <scott.marlowe@ihs.com>
  1 sibling, 0 replies; 6+ messages in thread

From: scott.marlowe @ 2003-10-02 19:45 UTC (permalink / raw)
  To: Ana Carolina Alonso de Armiño <aalonso@uncoma.edu.ar>; +Cc: pgsql-php

On Thu, 2 Oct 2003, Ana Carolina Alonso de Armiño wrote:

> Hi, i had installed postgress 7.3 in a database server, and php is running 
> in an apache web server.
> There are 6 databases. I can access to one of then from a php pages, and 
> the system work fine.
> The problem is when I want to access from a php page to another database. 
> The conection is failed.
> I had created this database using next comand:
> 
> createdb expedientes
> 
> And from phppgadmin (2.4.2) I had add privileges to a user. And I do the 
> conect from the php page with this user. The do the conection with:
> 
> pg_pconnect(" host=one_host dbname=one_dbase user=one_user password=one_pass")

Maybe your settings in pg_hba.conf are limiting that user to one database?




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: connection error
  2003-10-02 19:45 connection error Ana Carolina Alonso de Armiño <aalonso@uncoma.edu.ar>
@ 2003-10-02 20:02 ` Martin Marques <martin@bugs.unl.edu.ar>
  1 sibling, 0 replies; 6+ messages in thread

From: Martin Marques @ 2003-10-02 20:02 UTC (permalink / raw)
  To: Ana Carolina Alonso de Armiño <aalonso@uncoma.edu.ar>; pgsql-php

El Jue 02 Oct 2003 16:45, Ana Carolina Alonso de Armiño escribió:
> Hi, i had installed postgress 7.3 in a database server, and php is running
> in an apache web server.
> There are 6 databases. I can access to one of then from a php pages, and
> the system work fine.
> The problem is when I want to access from a php page to another database.
> The conection is failed.
> I had created this database using next comand:
>
> createdb expedientes
>
> And from phppgadmin (2.4.2) I had add privileges to a user. And I do the
           ^^^^^^^^^^^^^^^^^
Upgrade to phpPgAdmin 3.1. Your PostgreSQL has schemas, and that version of 
phpPgAdmin doesn't have support for them, as well as many other things that 
this new version has.

-- 
Porqué usar una base de datos relacional cualquiera,
si podés usar PostgreSQL?
-----------------------------------------------------------------
Martín Marqués                  |        mmarques@unl.edu.ar
Programador, Administrador, DBA |       Centro de Telemática
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Connection Error
@ 2005-09-12 13:02 JUAN ERNESTO FLORES BELTRAN <juanernestof@hotmail.com>
  2005-09-12 13:27 ` Re: Connection Error John DeSoi <desoi@pgedit.com>
  2005-09-12 15:15 ` Re: Connection Error Joshua D. Drake <jd@commandprompt.com>
  0 siblings, 2 replies; 6+ messages in thread

From: JUAN ERNESTO FLORES BELTRAN @ 2005-09-12 13:02 UTC (permalink / raw)
  To: pgsql-php

Hi,

I am trying to develop a graphical and statistical interface wiht PHP and 
Postgresql, however it seems is not possible to connect properly to the 
database i have creates. Everytime i try to connect to my database i receive 
the following message at the PHP interface:

Fatal error: Call to undefined function pg_connect() in 
c:\Inetpub\wwwroot\Untitled.php on line 8

I installed php-5.0.5-Win32.zip and PostgreSQL8.0, them both are installed 
in my PC (win2000) wich have been configured as a server. What the problem 
could be?

Thanks for your answers
Juan





^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Connection Error
  2005-09-12 13:02 Connection Error JUAN ERNESTO FLORES BELTRAN <juanernestof@hotmail.com>
@ 2005-09-12 13:27 ` John DeSoi <desoi@pgedit.com>
  1 sibling, 0 replies; 6+ messages in thread

From: John DeSoi @ 2005-09-12 13:27 UTC (permalink / raw)
  To: JUAN ERNESTO FLORES BELTRAN <juanernestof@hotmail.com>; +Cc: pgsql-php


On Sep 12, 2005, at 9:02 AM, JUAN ERNESTO FLORES BELTRAN wrote:

> I am trying to develop a graphical and statistical interface wiht  
> PHP and Postgresql, however it seems is not possible to connect  
> properly to the database i have creates. Everytime i try to connect  
> to my database i receive the following message at the PHP interface:
>
> Fatal error: Call to undefined function pg_connect() in c:\Inetpub 
> \wwwroot\Untitled.php on line 8
>
> I installed php-5.0.5-Win32.zip and PostgreSQL8.0, them both are  
> installed in my PC (win2000) wich have been configured as a server.  
> What the problem could be?

Windows comes with lots of modules precompiled but they are not  
enabled by default. Look at your php.ini file and make sure the  
PostgreSQL module is enabled. You should find the line below; just  
remove the leading ";".

;extension=php_pgsql.dll



John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Connection Error
  2005-09-12 13:02 Connection Error JUAN ERNESTO FLORES BELTRAN <juanernestof@hotmail.com>
@ 2005-09-12 15:15 ` Joshua D. Drake <jd@commandprompt.com>
  1 sibling, 0 replies; 6+ messages in thread

From: Joshua D. Drake @ 2005-09-12 15:15 UTC (permalink / raw)
  To: JUAN ERNESTO FLORES BELTRAN <juanernestof@hotmail.com>; +Cc: pgsql-php

JUAN ERNESTO FLORES BELTRAN wrote:

> Hi,
>
> I am trying to develop a graphical and statistical interface wiht PHP 
> and Postgresql, however it seems is not possible to connect properly 
> to the database i have creates. Everytime i try to connect to my 
> database i receive the following message at the PHP interface:
>
> Fatal error: Call to undefined function pg_connect() in 
> c:\Inetpub\wwwroot\Untitled.php on line 8

You don't have the pgsql.dll extension enabled in the php.ini.

Sincerely,

Joshua D. Drake


>
> I installed php-5.0.5-Win32.zip and PostgreSQL8.0, them both are 
> installed in my PC (win2000) wich have been configured as a server. 
> What the problem could be?
>
> Thanks for your answers
> Juan
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly



-- 
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/




^ permalink  raw  reply  [nested|flat] 6+ messages in thread


end of thread, other threads:[~2005-09-12 15:15 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-10-02 19:45 connection error Ana Carolina Alonso de Armiño <aalonso@uncoma.edu.ar>
2003-10-02 19:45 ` scott.marlowe <scott.marlowe@ihs.com>
2003-10-02 20:02 ` Martin Marques <martin@bugs.unl.edu.ar>
2005-09-12 13:02 Connection Error JUAN ERNESTO FLORES BELTRAN <juanernestof@hotmail.com>
2005-09-12 13:27 ` Re: Connection Error John DeSoi <desoi@pgedit.com>
2005-09-12 15:15 ` Re: Connection Error Joshua D. Drake <jd@commandprompt.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox