Обсуждение: 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
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
-----------------------------------------------------------------