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 A3271D89B0 for ; Fri, 14 Oct 2005 13:32:13 -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 32506-10 for ; Fri, 14 Oct 2005 16:32:09 +0000 (GMT) Received: from web33315.mail.mud.yahoo.com (web33315.mail.mud.yahoo.com [68.142.206.130]) by svr1.postgresql.org (Postfix) with SMTP id 092E8D76E9 for ; Fri, 14 Oct 2005 13:32:08 -0300 (ADT) Received: (qmail 12757 invoked by uid 60001); 14 Oct 2005 16:32:08 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=vNPS8kVDDjGxHN7mYvbp+WqUms+13LRdQ2ExoJpwXrKIelxgRIF4ZmURzK1oX8WyaZobwmTeNQnUJvMnN64k3ufTXGHNSrdzbcDKaRkxEibj3fw7sasAEKxiD3iPGFcXc4OWUBXnPp8I/7QSlhn/WuR64Yn2oy4QvGHQ70DMb+s= ; Message-ID: <20051014163208.12755.qmail@web33315.mail.mud.yahoo.com> Received: from [12.9.179.126] by web33315.mail.mud.yahoo.com via HTTP; Fri, 14 Oct 2005 09:32:08 PDT Date: Fri, 14 Oct 2005 09:32:08 -0700 (PDT) From: Subject: Re: autentication problem To: pgsql-php@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.868 required=5 tests=[AWL=0.316, DNS_FROM_RFC_ABUSE=0.374, NO_REAL_NAME=0.178] X-Spam-Level: X-Archive-Number: 200510/30 X-Sequence-Number: 3298 --- 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