Topic: Need help installing a web app

[soprom]

There is a problem with upgrading from pg7.4.17 to pg8 with  php-common

yum --enablerepo=centosplus install postgresql postgresql-contrib postgresql-devel postgresql-docs postgresql-pl postgresql-python postgresql-test

Transaction Check Error:   file /etc/php.ini from install of php-common-5.1.6-3.el4s1.5 conflicts with file from package php-4.3.9-3.22.5

So I renamed /etc/php.ini -> .old and did the upgrading. Then I restored php.ini

After rebooting the serveur, php seams to work but sql-ledger is broken.

could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

[wjhobbs]

I'm not sure.

Could you check to see which repository centosplus is pointing to. SME7 is based on Centos4 but Centos recently made Centos5 available -- which includes php5. SME7 is only at php4. It is possible that your yum repo for centosplus is pointing at the wrong repository.

db yum_repositories show | more

should show what repositories are specified. The centosplus repo should be pointing to .../centos/4/centosplus/...

John

[wjhobbs]

I would very much like to know how you installed LSMB 1.1.12 !

I put the how-to here http://forums.contribs.org/index.php?topic=37181.0

John

[soprom]

It appears that databases are to be upgraded!

Here's what I did to make sql-ledger work again:

Before upgrading postgres, I had a dump of all databases (pg_dump -c -F p -U postgres <database>).
Stop postgres
yum install as above

Code: [Select]


UPGRADE TO 8:
=============

mv /var/lib/pgsql/data /var/lib/pgsql/data7.4
su postgres
initdb -D /var/lib/pgsql/data
exit

/etc/init.d/postgresql start
mv /home/e-smith/files/ibays/../databases/pg_*.* /var/lib/pgsql/backups

su postgres
cd /var/lib/pgsql/data
createuser -d -P sql-ledger
createuser -d -P ledgersmb
createdb ledgersmb
createdb <databases>
createlang plpgsql template1
exit

psql <databases> < backups/pg_<databases>


Sql-ledger is now working!
Ouch!!

[soprom]

pgAdmin is not working anymore...
pgsql.so is not loading.
I don't want to upgrade to php5 because SME7 will break on the next update.

[soprom]

php is having problems...

Unable to load dynamic library '/usr/lib/php4/pgsql.so'
Unable to load dynamic library '/usr/lib/php4/pdo.so'
Unable to load dynamic library '/usr/lib/php4/pdo_pgsql.so'
Unable to load dynamic library '/usr/lib/php4/pdo_sqlite.so'
Unable to load dynamic library '/usr/lib/php4/pgsql.so'

I copied files in modules folder to php4 folder but nothing does it.
From a search, I see that this means php5 is required.
How can I roll back to postgresql 7 ?

Help !

[soprom]

John,
Thanks for your howto. I'm trying it.