[opencms-dev] Installation of OpenCMS-6.2.1 on PostgreSQL 8.1.3

[Andreas Haumer]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi!

I just wanted to report that today I successfully installed
OpeenCMS 6.2.1 using PostgreSQL-8.1.3 as database system.

Here is a list of the most important system components involved
in my test installation:

* Linux operating system
* Sun JDK 1.5.0_06
* Apache Tomcat 5.5.17
* PostgreSQL-8.1.3
* JDBC driver postgresql-8.1-405.jdbc3.jar
* OpenCMS-6.2.1

I did a full installation of OpenCMS-6.2.1 with all modules
provided in the standard distribution and also did a few tests
of the installed product, which all went without problems.

The installation went quite smoothly, though you still have
to be careful _not_ to specify "template1" as "Template Db"
in the database setup dialog.

Instead you have to use the name of some other existing database
(I always use "postgres", because that also does exist on our
standard PostgreSQL installations)

If you specify "template1" as "Template DB" in the database
setup dialog, the next step will fail, as after the initial
database check the connection to the "template1" database
will stay in the Tomcat database connection pool and so the
"template1" database will still be open when the setup program
tries to create the "opencms" database. PostgreSQL doesn't like
that and will react with the following message:

ERROR:  source database "template1" is being accessed by other users

For a more elaborate description of this problem please see my
mail to this mailing list from March 7th, 2006
<http://mail.opencms.org/pipermail/opencms-dev/2006q1/022605.html>

(I haven't got any reply to my report, but as far as I can tell
from all my tests since then the analysis and my suggestions to
solve the problem still are correct. I'm sending this mail hoping
that it might be useful for others)

HTH

- - andreas

- --
Andreas Haumer                     | mailto:andreas at xss.co.at
*x Software + Systeme              | http://www.xss.co.at/
Karmarschgasse 51/2/20             | Tel: +43-1-6060114-0
A-1100 Vienna, Austria             | Fax: +43-1-6060114-71
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.2 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFEWwyWxJmyeGcXPhERAiaYAJ42YQsjBl6w6Hopfl2Y+0mVZMlTcwCgvmT7
NNFASkd7lhPyHRbdYqibmOQ=
=554y
-----END PGP SIGNATURE-----