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 1D56BD8EC4 for ; Fri, 14 Oct 2005 16:28:37 -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 75431-09 for ; Fri, 14 Oct 2005 19:28:34 +0000 (GMT) Received: from hotmail.com (bay14-f26.bay14.hotmail.com [64.4.49.26]) by svr1.postgresql.org (Postfix) with ESMTP id 42D9ED76E9 for ; Fri, 14 Oct 2005 16:28:35 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Fri, 14 Oct 2005 12:28:01 -0700 Message-ID: Received: from 201.242.103.50 by by14fd.bay14.hotmail.msn.com with HTTP; Fri, 14 Oct 2005 19:28:01 GMT X-Originating-IP: [201.242.103.50] X-Originating-Email: [juanernestof@hotmail.com] X-Sender: juanernestof@hotmail.com In-Reply-To: <1EEA0DF5-57C5-42D5-96A4-DAD19FBD9D53@ehpg.net> From: "JUAN ERNESTO FLORES BELTRAN" To: gmr@ehpg.net Cc: operationsengineer1@yahoo.com, pgsql-php@postgresql.org Subject: Re: autentication problem Date: Fri, 14 Oct 2005 19:28:01 +0000 Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1; format=flowed X-OriginalArrivalTime: 14 Oct 2005 19:28:01.0430 (UTC) FILETIME=[64109360:01C5D0F5] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.193 required=5 tests=[AWL=-0.557, DNS_FROM_RFC_ABUSE=0.374, DNS_FROM_RFC_POST=1.376, MSGID_FROM_MTA_HEADER=0] X-Spam-Level: * X-Archive-Number: 200510/34 X-Sequence-Number: 3302 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" >To: "JUAN ERNESTO FLORES BELTRAN" >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: >>>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=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