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