Re: autentication problem
От | JUAN ERNESTO FLORES BELTRAN |
---|---|
Тема | Re: autentication problem |
Дата | |
Msg-id | BAY14-F26C5C076A4F326723A09B5CD7D0@phx.gbl обсуждение исходный текст |
Ответ на | Re: autentication problem ("Gavin M. Roy" <gmr@ehpg.net>) |
Ответы |
Re: autentication problem
("Gavin M. Roy" <gmr@ehpg.net>)
|
Список | pgsql-php |
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
В списке pgsql-php по дате отправления: