X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6BFEDD76E9 for ; Fri, 14 Oct 2005 16:16:47 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 77980-01 for ; Fri, 14 Oct 2005 19:16:42 +0000 (GMT) Received: from tetra.ehpg.net (tetra2.ehpg.net [65.19.161.8]) by svr1.postgresql.org (Postfix) with ESMTP id 761E6D863C for ; Fri, 14 Oct 2005 16:16:43 -0300 (ADT) Received: from dsl081-087-203.lax1.dsl.speakeasy.net ([64.81.87.203]) by tetra.ehpg.net with esmtpa (Exim 4.50) id 1EQV2q-000535-49; Fri, 14 Oct 2005 12:16:44 -0700 In-Reply-To: References: Mime-Version: 1.0 (Apple Message framework v734) Content-Type: text/plain; charset=ISO-8859-1; delsp=yes; format=flowed Message-Id: <1EEA0DF5-57C5-42D5-96A4-DAD19FBD9D53@ehpg.net> Cc: operationsengineer1@yahoo.com, pgsql-php@postgresql.org Content-Transfer-Encoding: quoted-printable From: "Gavin M. Roy" Subject: Re: autentication problem Date: Fri, 14 Oct 2005 12:16:42 -0700 To: "JUAN ERNESTO FLORES BELTRAN" X-Mailer: Apple Mail (2.734) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.001 required=5 tests=[AWL=0.001] X-Spam-Level: X-Archive-Number: 200510/33 X-Sequence-Number: 3301 I would guess your pg_hba.conf is not configured correctly. It =20 appears to be an ident matching issue (best I can tell from the =20 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=3Dlocalhost port=3D5432 dbname=3Dprototipo = user=3Dpostgres =20 > password=3D13177337) > > this is the route i used on windows to run queries on postgre =20 > trough php. This does not work on linux, and result in an =20 > autentication error > > What the problem could be? > thanks for your answers in advance.. > > >> From: >> To: pgsql-php@postgresql.org >> Subject: Re: [PHP] autentication problem >> Date: Fri, 14 Oct 2005 09:32:08 -0700 (PDT) >> >> --- JUAN ERNESTO FLORES BELTRAN >> 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=3Dpostgres >> > password=3D13177337 >> > 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=C3=B3n Ident fall=C3=B3 para el usuario >> > =C2=ABjufl=C2=BB 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; >> > >> > >> .....................................................................=20= >> .....................................................................=20= >> ..................... >> > 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=E9rminos de >> > distribuci=F3n >> > \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=3D# >> > >> > >> .....................................................................=20= >> .....................................................................=20= >> ........................................... >> > >> > >> > 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 =20 >> broadcast)--------------------------- >> TIP 5: don't forget to increase your free space map settings >> > > > > ---------------------------(end of =20 > 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