Re: [PHP] autentication problem

[<operationsengineer1@xxxxxxxxx>]

--- JUAN ERNESTO FLORES BELTRAN
<juanernestof@xxxxxxxxxxx> 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