pg.ddx.io pgsql-php@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: 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