Re: connection error

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?


---------------------------(end of broadcast)---------------------------
TIP 3: 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

connection error

--=====================_24869756==_.ALT
Content-Type: text/plain; charset="us-ascii"; format=flowed

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
--=====================_24869756==_.ALT
Content-Type: text/html; charset="us-ascii"


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

--=====================_24869756==_.ALT--

Re: connection error

El Jue 02 Oct 2003 16:45, Ana Carolina Alonso de Armi=F1o escribi=F3:
> 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=
=20
phpPgAdmin doesn't have support for them, as well as many other things that=
=20
this new version has.

--=20
Porqu=E9 usar una base de datos relacional cualquiera,
si pod=E9s usar PostgreSQL?
------------------------------------------------------------ -----
Mart=EDn Marqu=E9s | mmarques@unl.edu.ar
Programador, Administrador, DBA | Centro de Telem=E1tica
Universidad Nacional
del Litoral
------------------------------------------------------------ -----


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)