Обсуждение: connection error

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

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?

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
-----------------------------------------------------------------