--- 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
