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 0D146D9036; Fri, 14 Oct 2005 15:37:40 -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 65620-10; Fri, 14 Oct 2005 18:37:31 +0000 (GMT) Received: from hotmail.com (bay14-f30.bay14.hotmail.com [64.4.49.30]) by svr1.postgresql.org (Postfix) with ESMTP id E2FBED8EC4; Fri, 14 Oct 2005 15:37:31 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Fri, 14 Oct 2005 11:37:12 -0700 Message-ID: Received: from 201.242.103.50 by by14fd.bay14.hotmail.msn.com with HTTP; Fri, 14 Oct 2005 18:37:11 GMT X-Originating-IP: [201.242.103.50] X-Originating-Email: [juanernestof@hotmail.com] X-Sender: juanernestof@hotmail.com In-Reply-To: <20051014163208.12755.qmail@web33315.mail.mud.yahoo.com> From: "JUAN ERNESTO FLORES BELTRAN" To: pgsql-php-owner@postgresql.org, pgsql-php@postgresql.org Subject: Re: autentication problem Date: Fri, 14 Oct 2005 18:37:11 +0000 Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1; format=flowed X-OriginalArrivalTime: 14 Oct 2005 18:37:12.0040 (UTC) FILETIME=[4A7C9680:01C5D0EE] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.167 required=5 tests=[AWL=-0.583, DNS_FROM_RFC_ABUSE=0.374, DNS_FROM_RFC_POST=1.376, MSGID_FROM_MTA_HEADER=0] X-Spam-Level: * X-Archive-Number: 200510/31 X-Sequence-Number: 3299 tha instructions as follows; 1.- open yast2 2.- change Installation Source 3.- Add HTTP 4.- Add Server: ftp.leo.org 5.- indicate Directory: mirrors Now u have changed the source to install postgres, the installation source is know a server. It seems it is not available from the cds, it would take some time....then the systme is goin to ask you find or search...the package u want to install. write postgresql and select all the options available....thats that...the installation is going to run automatically...some cds will be required regards.- >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