Thread: autentication problem
Hi everyone
i am working on php and posgresql, i designed a database system web oriented
on windows at first on template1 default database. I used a password and a
loggin
loggin=postgres
password=13177337
this info is requested when installing postgresql on windows.
Know i trying to migrate to suse linux...i moved my scripts to
srv/www/htdocs/prototipo as root. I installed apache2 server, and i
configured both apache and posgtresql to start running when starting the
computer.
The problem is, i have not been able tu run properly the system on linux...i
receive the following message when conecting to postgresql:
"Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: la
autentificación Ident falló para el usuario «jufl» in
/srv/www/htdocs/Prototipo/opciones.php on line 51"
I didnt create any user when installing postgres, it didnt request during
installation...so i wonder....how can i manage this? the extrange thing is
that i can modify tables from console as follows;
...............................................................................................................................................................
su root
enter password
su postgres
psql prototipo
Bienvenido a psql 8.0.3, el terminal interactivo de PostgreSQL.
Digite: \copyright para ver los términos de distribución
\h para obtener ayuda sobre comandos SQL
\? para obtener ayuda sobre comandos internos
\g o punto y coma (;) para ejecutar consulta
\q para salir
prototipo=#
.....................................................................................................................................................................................
so i dont understand what the problem is.....
Thaks for your help...
--- JUAN ERNESTO FLORES BELTRAN <juanernestof@hotmail.com> wrote: > Hi everyone > > i am working on php and posgresql, i designed a > database system web oriented > on windows at first on template1 default database. did you copy template1 and then create your db from the template? i always understood that template1 itself was to be left alone and left as template. > I > used a password and a > loggin > loggin=postgres > password=13177337 > this info is requested when installing postgresql on > windows. > Know i trying to migrate to suse linux...i moved my > scripts to > srv/www/htdocs/prototipo as root. I installed > apache2 server, and i > configured both apache and posgtresql to start > running when starting the > computer. > > The problem is, i have not been able tu run properly > the system on linux...i > receive the following message when conecting to > postgresql: > > "Warning: pg_connect(): Unable to connect to > PostgreSQL server: FATAL: la > autentificación Ident falló para el usuario > «jufl» in > /srv/www/htdocs/Prototipo/opciones.php on line 51" i've never administered pgsql on linux before, so i don't have direct experience. what does opciones.php line 51 say? is tcp/ip enabled? are you using the same username and password? > I didnt create any user when installing postgres, it > didnt request during > installation...so i wonder....how can i manage this? > the extrange thing is > that i can modify tables from console as follows; > > ............................................................................................................................................................... > su root > enter password > su postgres > psql prototipo > Bienvenido a psql 8.0.3, el terminal interactivo de > PostgreSQL. > > Digite: \copyright para ver los términos de > distribución > \h para obtener ayuda sobre comandos SQL > \? para obtener ayuda sobre comandos > internos > \g o punto y coma (;) para ejecutar > consulta > \q para salir > > prototipo=# > > ..................................................................................................................................................................................... > > > so i dont understand what the problem is..... > > Thaks for your help... not sure i can help, but if you post line 51 it will likely help those who can help. best of luck. ps - a guy on the pgsql novice mailint list was recently asking how to install pgsql onto suse. if you had any instructions or could point to a tutorial that you used, he would like appreciate it. __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com
tha instructions as follows; 1.- open yast2 2.- change Installation Source 3.- Add HTTP 4.- Add Server: ftp.leo.org 5.- indicate Directory: mirrors Now u have changed the source to install postgres, the installation source is know a server. It seems it is not available from the cds, it would take some time....then the systme is goin to ask you find or search...the package u want to install. write postgresql and select all the options available....thats that...the installation is going to run automatically...some cds will be required regards.- >From: <operationsengineer1@yahoo.com> >To: pgsql-php@postgresql.org >Subject: Re: [PHP] autentication problem >Date: Fri, 14 Oct 2005 09:32:08 -0700 (PDT) > >--- JUAN ERNESTO FLORES BELTRAN ><juanernestof@hotmail.com> wrote: > > > Hi everyone > > > > i am working on php and posgresql, i designed a > > database system web oriented > > on windows at first on template1 default database. > >did you copy template1 and then create your db from >the template? i always understood that template1 >itself was to be left alone and left as template. > > > I > > used a password and a > > loggin > > loggin=postgres > > password=13177337 > > this info is requested when installing postgresql on > > windows. > > Know i trying to migrate to suse linux...i moved my > > scripts to > > srv/www/htdocs/prototipo as root. I installed > > apache2 server, and i > > configured both apache and posgtresql to start > > running when starting the > > computer. > > > > The problem is, i have not been able tu run properly > > the system on linux...i > > receive the following message when conecting to > > postgresql: > > > > "Warning: pg_connect(): Unable to connect to > > PostgreSQL server: FATAL: la > > autentificación Ident falló para el usuario > > «jufl» in > > /srv/www/htdocs/Prototipo/opciones.php on line 51" > >i've never administered pgsql on linux before, so i >don't have direct experience. what does opciones.php >line 51 say? is tcp/ip enabled? are you using the >same username and password? > > > I didnt create any user when installing postgres, it > > didnt request during > > installation...so i wonder....how can i manage this? > > the extrange thing is > > that i can modify tables from console as follows; > > > > >............................................................................................................................................................... > > su root > > enter password > > su postgres > > psql prototipo > > Bienvenido a psql 8.0.3, el terminal interactivo de > > PostgreSQL. > > > > Digite: \copyright para ver los términos de > > distribución > > \h para obtener ayuda sobre comandos SQL > > \? para obtener ayuda sobre comandos > > internos > > \g o punto y coma (;) para ejecutar > > consulta > > \q para salir > > > > prototipo=# > > > > >..................................................................................................................................................................................... > > > > > > so i dont understand what the problem is..... > > > > Thaks for your help... > >not sure i can help, but if you post line 51 it will >likely help those who can help. > >best of luck. > >ps - a guy on the pgsql novice mailint list was >recently asking how to install pgsql onto suse. if >you had any instructions or could point to a tutorial >that you used, he would like appreciate it. > > > > >__________________________________ >Yahoo! Mail - PC Magazine Editors' Choice 2005 >http://mail.yahoo.com > >---------------------------(end of broadcast)--------------------------- >TIP 5: don't forget to increase your free space map settings
Information contained on page 51: pg_connect(host=localhost port=5432 dbname=prototipo user=postgres password=13177337) this is the route i used on windows to run queries on postgre trough php. This does not work on linux, and result in an autentication error What the problem could be? thanks for your answers in advance.. >From: <operationsengineer1@yahoo.com> >To: pgsql-php@postgresql.org >Subject: Re: [PHP] autentication problem >Date: Fri, 14 Oct 2005 09:32:08 -0700 (PDT) > >--- JUAN ERNESTO FLORES BELTRAN ><juanernestof@hotmail.com> wrote: > > > Hi everyone > > > > i am working on php and posgresql, i designed a > > database system web oriented > > on windows at first on template1 default database. > >did you copy template1 and then create your db from >the template? i always understood that template1 >itself was to be left alone and left as template. > > > I > > used a password and a > > loggin > > loggin=postgres > > password=13177337 > > this info is requested when installing postgresql on > > windows. > > Know i trying to migrate to suse linux...i moved my > > scripts to > > srv/www/htdocs/prototipo as root. I installed > > apache2 server, and i > > configured both apache and posgtresql to start > > running when starting the > > computer. > > > > The problem is, i have not been able tu run properly > > the system on linux...i > > receive the following message when conecting to > > postgresql: > > > > "Warning: pg_connect(): Unable to connect to > > PostgreSQL server: FATAL: la > > autentificación Ident falló para el usuario > > «jufl» in > > /srv/www/htdocs/Prototipo/opciones.php on line 51" > >i've never administered pgsql on linux before, so i >don't have direct experience. what does opciones.php >line 51 say? is tcp/ip enabled? are you using the >same username and password? > > > I didnt create any user when installing postgres, it > > didnt request during > > installation...so i wonder....how can i manage this? > > the extrange thing is > > that i can modify tables from console as follows; > > > > >............................................................................................................................................................... > > su root > > enter password > > su postgres > > psql prototipo > > Bienvenido a psql 8.0.3, el terminal interactivo de > > PostgreSQL. > > > > Digite: \copyright para ver los términos de > > distribución > > \h para obtener ayuda sobre comandos SQL > > \? para obtener ayuda sobre comandos > > internos > > \g o punto y coma (;) para ejecutar > > consulta > > \q para salir > > > > prototipo=# > > > > >..................................................................................................................................................................................... > > > > > > so i dont understand what the problem is..... > > > > Thaks for your help... > >not sure i can help, but if you post line 51 it will >likely help those who can help. > >best of luck. > >ps - a guy on the pgsql novice mailint list was >recently asking how to install pgsql onto suse. if >you had any instructions or could point to a tutorial >that you used, he would like appreciate it. > > > > >__________________________________ >Yahoo! Mail - PC Magazine Editors' Choice 2005 >http://mail.yahoo.com > >---------------------------(end of broadcast)--------------------------- >TIP 5: don't forget to increase your free space map settings
I would guess your pg_hba.conf is not configured correctly. It appears to be an ident matching issue (best I can tell from the spanish error messages, sorry). Gavin On Oct 14, 2005, at 12:06 PM, JUAN ERNESTO FLORES BELTRAN wrote: > Information contained on page 51: > > pg_connect(host=localhost port=5432 dbname=prototipo user=postgres > password=13177337) > > this is the route i used on windows to run queries on postgre > trough php. This does not work on linux, and result in an > autentication error > > What the problem could be? > thanks for your answers in advance.. > > >> From: <operationsengineer1@yahoo.com> >> To: pgsql-php@postgresql.org >> Subject: Re: [PHP] autentication problem >> Date: Fri, 14 Oct 2005 09:32:08 -0700 (PDT) >> >> --- JUAN ERNESTO FLORES BELTRAN >> <juanernestof@hotmail.com> wrote: >> >> > Hi everyone >> > >> > i am working on php and posgresql, i designed a >> > database system web oriented >> > on windows at first on template1 default database. >> >> did you copy template1 and then create your db from >> the template? i always understood that template1 >> itself was to be left alone and left as template. >> >> > I >> > used a password and a >> > loggin >> > loggin=postgres >> > password=13177337 >> > this info is requested when installing postgresql on >> > windows. >> > Know i trying to migrate to suse linux...i moved my >> > scripts to >> > srv/www/htdocs/prototipo as root. I installed >> > apache2 server, and i >> > configured both apache and posgtresql to start >> > running when starting the >> > computer. >> > >> > The problem is, i have not been able tu run properly >> > the system on linux...i >> > receive the following message when conecting to >> > postgresql: >> > >> > "Warning: pg_connect(): Unable to connect to >> > PostgreSQL server: FATAL: la >> > autentificación Ident falló para el usuario >> > «jufl» in >> > /srv/www/htdocs/Prototipo/opciones.php on line 51" >> >> i've never administered pgsql on linux before, so i >> don't have direct experience. what does opciones.php >> line 51 say? is tcp/ip enabled? are you using the >> same username and password? >> >> > I didnt create any user when installing postgres, it >> > didnt request during >> > installation...so i wonder....how can i manage this? >> > the extrange thing is >> > that i can modify tables from console as follows; >> > >> > >> ..................................................................... >> ..................................................................... >> ..................... >> > su root >> > enter password >> > su postgres >> > psql prototipo >> > Bienvenido a psql 8.0.3, el terminal interactivo de >> > PostgreSQL. >> > >> > Digite: \copyright para ver los términos de >> > distribución >> > \h para obtener ayuda sobre comandos SQL >> > \? para obtener ayuda sobre comandos >> > internos >> > \g o punto y coma (;) para ejecutar >> > consulta >> > \q para salir >> > >> > prototipo=# >> > >> > >> ..................................................................... >> ..................................................................... >> ........................................... >> > >> > >> > so i dont understand what the problem is..... >> > >> > Thaks for your help... >> >> not sure i can help, but if you post line 51 it will >> likely help those who can help. >> >> best of luck. >> >> ps - a guy on the pgsql novice mailint list was >> recently asking how to install pgsql onto suse. if >> you had any instructions or could point to a tutorial >> that you used, he would like appreciate it. >> >> >> >> >> __________________________________ >> Yahoo! Mail - PC Magazine Editors' Choice 2005 >> http://mail.yahoo.com >> >> ---------------------------(end of >> broadcast)--------------------------- >> TIP 5: don't forget to increase your free space map settings >> > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > Gavin M. Roy 800 Pound Gorilla gmr@ehpg.net
Sorry for the english message, i will translate it as follows: "Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: autentification has failed for postgres user in /srv/www/htdocs/Prototipo/opciones.php on line 51" any other suggesttion? what shoudl i modify to pg_hba.conf? regards >From: "Gavin M. Roy" <gmr@ehpg.net> >To: "JUAN ERNESTO FLORES BELTRAN" <juanernestof@hotmail.com> >CC: operationsengineer1@yahoo.com, pgsql-php@postgresql.org >Subject: Re: [PHP] autentication problem >Date: Fri, 14 Oct 2005 12:16:42 -0700 > >I would guess your pg_hba.conf is not configured correctly. It appears to >be an ident matching issue (best I can tell from the spanish error >messages, sorry). > >Gavin > >On Oct 14, 2005, at 12:06 PM, JUAN ERNESTO FLORES BELTRAN wrote: > >>Information contained on page 51: >> >>pg_connect(host=localhost port=5432 dbname=prototipo user=postgres >>password=13177337) >> >>this is the route i used on windows to run queries on postgre trough php. >>This does not work on linux, and result in an autentication error >> >>What the problem could be? >>thanks for your answers in advance.. >> >> >>>From: <operationsengineer1@yahoo.com> >>>To: pgsql-php@postgresql.org >>>Subject: Re: [PHP] autentication problem >>>Date: Fri, 14 Oct 2005 09:32:08 -0700 (PDT) >>> >>>--- JUAN ERNESTO FLORES BELTRAN >>><juanernestof@hotmail.com> wrote: >>> >>> > Hi everyone >>> > >>> > i am working on php and posgresql, i designed a >>> > database system web oriented >>> > on windows at first on template1 default database. >>> >>>did you copy template1 and then create your db from >>>the template? i always understood that template1 >>>itself was to be left alone and left as template. >>> >>> > I >>> > used a password and a >>> > loggin >>> > loggin=postgres >>> > password=13177337 >>> > this info is requested when installing postgresql on >>> > windows. >>> > Know i trying to migrate to suse linux...i moved my >>> > scripts to >>> > srv/www/htdocs/prototipo as root. I installed >>> > apache2 server, and i >>> > configured both apache and posgtresql to start >>> > running when starting the >>> > computer. >>> > >>> > The problem is, i have not been able tu run properly >>> > the system on linux...i >>> > receive the following message when conecting to >>> > postgresql: >>> > >>> > "Warning: pg_connect(): Unable to connect to >>> > PostgreSQL server: FATAL: la >>> > autentificación Ident falló para el usuario >>> > «jufl» in >>> > /srv/www/htdocs/Prototipo/opciones.php on line 51" >>> >>>i've never administered pgsql on linux before, so i >>>don't have direct experience. what does opciones.php >>>line 51 say? is tcp/ip enabled? are you using the >>>same username and password? >>> >>> > I didnt create any user when installing postgres, it >>> > didnt request during >>> > installation...so i wonder....how can i manage this? >>> > the extrange thing is >>> > that i can modify tables from console as follows; >>> > >>> > >>>..................................................................... >>>..................................................................... >>>..................... >>> > su root >>> > enter password >>> > su postgres >>> > psql prototipo >>> > Bienvenido a psql 8.0.3, el terminal interactivo de >>> > PostgreSQL. >>> > >>> > Digite: \copyright para ver los términos de >>> > distribución >>> > \h para obtener ayuda sobre comandos SQL >>> > \? para obtener ayuda sobre comandos >>> > internos >>> > \g o punto y coma (;) para ejecutar >>> > consulta >>> > \q para salir >>> > >>> > prototipo=# >>> > >>> > >>>..................................................................... >>>..................................................................... >>>........................................... >>> > >>> > >>> > so i dont understand what the problem is..... >>> > >>> > Thaks for your help... >>> >>>not sure i can help, but if you post line 51 it will >>>likely help those who can help. >>> >>>best of luck. >>> >>>ps - a guy on the pgsql novice mailint list was >>>recently asking how to install pgsql onto suse. if >>>you had any instructions or could point to a tutorial >>>that you used, he would like appreciate it. >>> >>> >>> >>> >>>__________________________________ >>>Yahoo! Mail - PC Magazine Editors' Choice 2005 >>>http://mail.yahoo.com >>> >>>---------------------------(end of broadcast)--------------------------- >>>TIP 5: don't forget to increase your free space map settings >>> >> >> >> >>---------------------------(end of broadcast)--------------------------- >>TIP 9: In versions below 8.0, the planner will ignore your desire to >> choose an index scan if your joining column's datatypes do not >> match >> > >Gavin M. Roy >800 Pound Gorilla >gmr@ehpg.net > > > >---------------------------(end of broadcast)--------------------------- >TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match
http://www.postgresql.org/docs/7.4/interactive/client- authentication.html#AUTH-PG-HBA-CONF ^^ should have everything you need to know :) Gavin On Oct 14, 2005, at 12:28 PM, JUAN ERNESTO FLORES BELTRAN wrote: > Sorry for the english message, i will translate it as follows: > > "Warning: pg_connect(): Unable to connect to PostgreSQL server: > FATAL: autentification has failed for postgres user in /srv/ > www/htdocs/Prototipo/opciones.php on line 51" > > any other suggesttion? > what shoudl i modify to pg_hba.conf? > > regards > > >> From: "Gavin M. Roy" <gmr@ehpg.net> >> To: "JUAN ERNESTO FLORES BELTRAN" <juanernestof@hotmail.com> >> CC: operationsengineer1@yahoo.com, pgsql-php@postgresql.org >> Subject: Re: [PHP] autentication problem >> Date: Fri, 14 Oct 2005 12:16:42 -0700 >> >> I would guess your pg_hba.conf is not configured correctly. It >> appears to be an ident matching issue (best I can tell from the >> spanish error messages, sorry). >> >> Gavin >> >> On Oct 14, 2005, at 12:06 PM, JUAN ERNESTO FLORES BELTRAN wrote: >> >> >>> Information contained on page 51: >>> >>> pg_connect(host=localhost port=5432 dbname=prototipo >>> user=postgres password=13177337) >>> >>> this is the route i used on windows to run queries on postgre >>> trough php. This does not work on linux, and result in an >>> autentication error >>> >>> What the problem could be? >>> thanks for your answers in advance.. >>> >>> >>> >>>> From: <operationsengineer1@yahoo.com> >>>> To: pgsql-php@postgresql.org >>>> Subject: Re: [PHP] autentication problem >>>> Date: Fri, 14 Oct 2005 09:32:08 -0700 (PDT) >>>> >>>> --- JUAN ERNESTO FLORES BELTRAN >>>> <juanernestof@hotmail.com> wrote: >>>> >>>> > Hi everyone >>>> > >>>> > i am working on php and posgresql, i designed a >>>> > database system web oriented >>>> > on windows at first on template1 default database. >>>> >>>> did you copy template1 and then create your db from >>>> the template? i always understood that template1 >>>> itself was to be left alone and left as template. >>>> >>>> > I >>>> > used a password and a >>>> > loggin >>>> > loggin=postgres >>>> > password=13177337 >>>> > this info is requested when installing postgresql on >>>> > windows. >>>> > Know i trying to migrate to suse linux...i moved my >>>> > scripts to >>>> > srv/www/htdocs/prototipo as root. I installed >>>> > apache2 server, and i >>>> > configured both apache and posgtresql to start >>>> > running when starting the >>>> > computer. >>>> > >>>> > The problem is, i have not been able tu run properly >>>> > the system on linux...i >>>> > receive the following message when conecting to >>>> > postgresql: >>>> > >>>> > "Warning: pg_connect(): Unable to connect to >>>> > PostgreSQL server: FATAL: la >>>> > autentificación Ident falló para el usuario >>>> > «jufl» in >>>> > /srv/www/htdocs/Prototipo/opciones.php on line 51" >>>> >>>> i've never administered pgsql on linux before, so i >>>> don't have direct experience. what does opciones.php >>>> line 51 say? is tcp/ip enabled? are you using the >>>> same username and password? >>>> >>>> > I didnt create any user when installing postgres, it >>>> > didnt request during >>>> > installation...so i wonder....how can i manage this? >>>> > the extrange thing is >>>> > that i can modify tables from console as follows; >>>> > >>>> > >>>> ................................................................... >>>> .. ................................................................ >>>> ..... ..................... >>>> > su root >>>> > enter password >>>> > su postgres >>>> > psql prototipo >>>> > Bienvenido a psql 8.0.3, el terminal interactivo de >>>> > PostgreSQL. >>>> > >>>> > Digite: \copyright para ver los términos de >>>> > distribución >>>> > \h para obtener ayuda sobre comandos SQL >>>> > \? para obtener ayuda sobre comandos >>>> > internos >>>> > \g o punto y coma (;) para ejecutar >>>> > consulta >>>> > \q para salir >>>> > >>>> > prototipo=# >>>> > >>>> > >>>> ................................................................... >>>> .. ................................................................ >>>> ..... ........................................... >>>> > >>>> > >>>> > so i dont understand what the problem is..... >>>> > >>>> > Thaks for your help... >>>> >>>> not sure i can help, but if you post line 51 it will >>>> likely help those who can help. >>>> >>>> best of luck. >>>> >>>> ps - a guy on the pgsql novice mailint list was >>>> recently asking how to install pgsql onto suse. if >>>> you had any instructions or could point to a tutorial >>>> that you used, he would like appreciate it. >>>> >>>> >>>> >>>> >>>> __________________________________ >>>> Yahoo! Mail - PC Magazine Editors' Choice 2005 >>>> http://mail.yahoo.com >>>> >>>> ---------------------------(end of >>>> broadcast)--------------------------- >>>> TIP 5: don't forget to increase your free space map settings >>>> >>>> >>> >>> >>> >>> ---------------------------(end of >>> broadcast)--------------------------- >>> TIP 9: In versions below 8.0, the planner will ignore your desire to >>> choose an index scan if your joining column's datatypes do not >>> match >>> >>> >> >> Gavin M. Roy >> 800 Pound Gorilla >> gmr@ehpg.net >> >> >> >> ---------------------------(end of >> broadcast)--------------------------- >> TIP 9: In versions below 8.0, the planner will ignore your desire to >> choose an index scan if your joining column's datatypes do not >> match >> > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org > Gavin M. Roy 800 Pound Gorilla gmr@ehpg.net
hi everyone, i tried as explained at: http://www.postgresql.org/docs/8.0/interactive/client-authentication.html#AUTH-PG-HBA-CONF i searched the file pg_hba.conf at: /usr/local/pgsql/data/pg_hba.conf ....................................................................................................................................................................................... Client authentication is controlled by the file pg_hba.conf in the data directory, e.g., /usr/local/pgsql/data/pg_hba.conf. (HBA stands for host-based authentication.) A default pg_hba.conf file is installed when the data directory is initialized by initdb. ....................................................................................................................................................................................... However, i didnt find any pg_hba.conf ahywhere in my computer. So how can i access to this information in order to configure my database system? I tried both, posgresql running mode and stopped. No pg_hba.conf file found..... /etc/init.d/postgresql stop and /etc/init.d/postgresql start What should i do next? Thanks for your help Juan >From: "Gavin M. Roy" <gmr@ehpg.net> >To: "JUAN ERNESTO FLORES BELTRAN" <juanernestof@hotmail.com> >CC: operationsengineer1@yahoo.com, pgsql-php@postgresql.org >Subject: Re: [PHP] autentication problem >Date: Fri, 14 Oct 2005 12:41:00 -0700 > >http://www.postgresql.org/docs/7.4/interactive/client- >authentication.html#AUTH-PG-HBA-CONF > >^^ should have everything you need to know :) > >Gavin > >On Oct 14, 2005, at 12:28 PM, JUAN ERNESTO FLORES BELTRAN wrote: > >>Sorry for the english message, i will translate it as follows: >> >>"Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: >>autentification has failed for postgres user in /srv/ >>www/htdocs/Prototipo/opciones.php on line 51" >> >>any other suggesttion? >>what shoudl i modify to pg_hba.conf? >> >>regards
Juan, Make sure that your linux user "postgres" has permissions to access the tables on your linux box. verify permissions for postgres on the postgres directory structure. it osunds like you aren't authenticating against some check to make sure that postgres can access the directories and/or tables. best of luck. --- JUAN ERNESTO FLORES BELTRAN <juanernestof@hotmail.com> wrote: > hi everyone, i tried as explained at: > > http://www.postgresql.org/docs/8.0/interactive/client-authentication.html#AUTH-PG-HBA-CONF > > i searched the file pg_hba.conf at: > /usr/local/pgsql/data/pg_hba.conf > ....................................................................................................................................................................................... > Client authentication is controlled by the file > pg_hba.conf in the data > directory, e.g., /usr/local/pgsql/data/pg_hba.conf. > (HBA stands for > host-based authentication.) A default pg_hba.conf > file is installed when the > data directory is initialized by initdb. > ....................................................................................................................................................................................... > > However, i didnt find any pg_hba.conf ahywhere in my > computer. So how can i > access to this information in order to configure my > database system? > > I tried both, posgresql running mode and stopped. No > pg_hba.conf file > found..... > /etc/init.d/postgresql stop > and > /etc/init.d/postgresql start > > What should i do next? > Thanks for your help > Juan > > > >From: "Gavin M. Roy" <gmr@ehpg.net> > >To: "JUAN ERNESTO FLORES BELTRAN" > <juanernestof@hotmail.com> > >CC: operationsengineer1@yahoo.com, > pgsql-php@postgresql.org > >Subject: Re: [PHP] autentication problem > >Date: Fri, 14 Oct 2005 12:41:00 -0700 > > > >http://www.postgresql.org/docs/7.4/interactive/client- > > >authentication.html#AUTH-PG-HBA-CONF > > > >^^ should have everything you need to know :) > > > >Gavin > > > >On Oct 14, 2005, at 12:28 PM, JUAN ERNESTO FLORES > BELTRAN wrote: > > > >>Sorry for the english message, i will translate it > as follows: > >> > >>"Warning: pg_connect(): Unable to connect to > PostgreSQL server: FATAL: > >>autentification has failed for postgres user > in /srv/ > >>www/htdocs/Prototipo/opciones.php on line 51" > >> > >>any other suggesttion? > >>what shoudl i modify to pg_hba.conf? > >> > >>regards > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will > ignore your desire to > choose an index scan if your joining column's > datatypes do not > match > __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com