Re: autentication problem
От | Gavin M. Roy |
---|---|
Тема | Re: autentication problem |
Дата | |
Msg-id | 1EEA0DF5-57C5-42D5-96A4-DAD19FBD9D53@ehpg.net обсуждение исходный текст |
Ответ на | Re: autentication problem ("JUAN ERNESTO FLORES BELTRAN" <juanernestof@hotmail.com>) |
Ответы |
Re: autentication problem
("JUAN ERNESTO FLORES BELTRAN" <juanernestof@hotmail.com>)
|
Список | pgsql-php |
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
В списке pgsql-php по дате отправления: