Installing PostgresSQL 7.0.2
Translation of the original in Catalan. Read it in: CatalàCastellano
Updating PHP and adding postgres to the portal server.
In order to install the calendar program that interests me on the portal I have had to install Postgres on the server, since otherwise I had to modify the source code of the calendar, which is in php, and I had no time to do it.
Taking advantage of this change in PHP, which now has to support pg, I have updated the version of PHP and I have put 4.0.2, I still had 4.0.1, so the config line of PHP has ended up like this: ./configure --prefix=/usr/local/php4 --enable-ftp --with-apxs=/usr/local/apache- ssl/bin/apxs --enable-versioning --with-mysql=/usr/local/mysql --enable-track-va rs --enable-xml --with-gd --with-mcrypt --with-mhash --without-ttf --with-pgsql= /usr/local/pgsql
This is a line practically the same as the one used at maestratnet.net but I have added pg support. But initially it did not work properly, since I was missing a couple of libraries:
libmcrypt --> freshmeat.net
libmhash --> mhash.sourceforge.net
1 comment
Comments from the old blog, as they were written. Comments are closed.
Oriol Rius
Com sempre en les bases de dades SQL t'estàs un segle per entendre com
carai funciona el tema dels usuaris. Doncs bé després de moltes
proves he solucionat el problema instal.lant el phpPgSQL un gestor PHP de bases
de dades postgres.
Aquest usa les propies bases de dades per entrar al programa a no se q
desactivis al fitxer de configuració la opció d'authadv algo
així com accés avançat. Així doncs desactives la
opció entres a la base de dadesi afegeixes l'usuari 'root'. Un cop
afegit aquest usuari ja pots activar la opció q havies desactivat i
així soluciones fàcilment el problema dels usuaris.