[opencms-dev] Installation of 6.3 beta with PostgreSQL throws exceptions
Aleaxnder Kandzior
alex at opencms.org
Fri Feb 17 13:06:56 CET 2006
This is a PostgrSQL related issue. Apparently the PostgreSQL driver needs to
be updated.
Since we from Alkacon do not support this driver directly, we have to rely
on the community to fix this. Otherwise we will have to ship the 6.2 beta
without the PostgeSQL driver.
Kind Regards,
Alex.
-------------------
Alexander Kandzior
Alkacon Software GmbH - The OpenCms Experts
http://www.alkacon.com <http://www.alkacon.com/> - http://www.opencms.org
<http://www.opencms.org/>
_____
From: opencms-dev-bounces at opencms.org
[mailto:opencms-dev-bounces at opencms.org] On Behalf Of Dirk Hartmann
Sent: Friday, February 17, 2006 12:57 PM
To: opencms-dev at opencms.org
Subject: [opencms-dev] Installation of beta throws exceptions
Hello List,
maybe it is helpful to send you problems with installation of the beta.
Following exceptions have been thown while standard installation on tomcat4
with postgres 7.4.3:
12282: ( 2 / 12 ) Importing /alkacon-documentation/examples_directedit/
... o.k.
12281: ( 1 / 12 ) Importing /alkacon-documentation/ ... o.k.
12280: ------ Importing module ...
com.alkacon.documentation.examples_directedit ... Import Version 4
12279: ... 16 more
12278: at
org.opencms.db.generic.CmsProjectDriver.createProject(CmsProjectDriver.java:
165)
12277: at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delegating
PreparedStatement.java:101)
12276: at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delegating
PreparedStatement.java:101)
12275: at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1State
ment.java:273)
12274: at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.j
ava:50)
12273: at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.j
ava:517)
12272: at org.postgresql.core.QueryExecutor.execute
(QueryExecutor.java:43)
12271: at
org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
12270: at
org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152)
12269: at org.postgresql.util.PSQLException.parseServerError
(PSQLException.java:139)
12268:
12267: Caused by: org.postgresql.util.PSQLException: FEHLER: Wert zu lang
f?Typ character varying(64)
12266: ... 14 more
12265: at org.opencms.db.CmsSecurityManager.createProject
(CmsSecurityManager.java:1024)
12264: at
org.opencms.db.CmsDriverManager.createProject(CmsDriverManager.java:1398)
12263: at
org.opencms.db.generic.CmsProjectDriver.createProject(CmsProjectDriver.java:
179)
12262: Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred
when executing the following query: INSERT INTO CMS_PROJECTS
(PROJECT_ID,USER_ID,GROUP_ID,MANAGERGROUP_ID,TASK_ID,PROJECT_NAME,PROJECT_DE
SCRIPTION,PROJECT_FLAGS,DATE_CREATED,PROJECT_TYPE)VALUES
(58,'c300ba5c-01e8-3727-b305-5dcc9ccae1ee','5f81f1a1-1f7d-3af6-b188-3bac3da5
4580','5f81f1a1-1f7d-3af6-b188-3bac3da54580',58,'Import of module
com.alkacon.documentation.documentation_htmlimport','System generated
project to import module
"com.alkacon.documentation.documentation_htmlimport".',0,1140173072812,1).
12261: at org.opencms.setup.CmsSetupWorkplaceImportThread.run
(CmsSetupWorkplaceImportThread.java:186)
12260: at org.opencms.main.CmsShell.start(CmsShell.java:663)
12259: at
org.opencms.main.CmsShell.executeCommands(CmsShell.java:842)
12258: at org.opencms.main.CmsShell.executeCommand
(CmsShell.java:767)
12257: at
org.opencms.main.CmsShell$CmsCommandObject.executeMethod(CmsShell.java:246)
12256: at java.lang.reflect.Method.invoke(Method.java:324)
12255: at sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessorImpl.java:25)
12254: at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
12253: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
12252: at
org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(CmsSetupBean.java:
952)
12251: at
org.opencms.setup.CmsSetupBean.importModuleFromDefault(CmsSetupBean.java:172
4)
12250: at org.opencms.importexport.CmsImportExportManager.importData
(CmsImportExportManager.java:610)
12249: at
org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportEx
portHandler.java:325)
12248: at org.opencms.file.CmsObject.createProject(CmsObject.java
:566)
12247: at
org.opencms.db.CmsSecurityManager.createProject(CmsSecurityManager.java:1027
)
12246: at org.opencms.db.CmsDbContext.report(CmsDbContext.java:197)
12245: at org.opencms.db.CmsDbContext.throwException
(CmsDbContext.java:213)
12244: at
org.opencms.db.CmsDbSqlException.createException(CmsDbSqlException.java:103)
12243: org.opencms.db.CmsDbSqlException: Error creating project "Import
of module com.alkacon.documentation.documentation_htmlimport ".
12242: ... 16 more
12241: at
org.opencms.db.generic.CmsProjectDriver.createProject(CmsProjectDriver.java:
165)
12240: at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate
(DelegatingPreparedStatement.java:101)
12239: at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delegating
PreparedStatement.java:101)
12238: at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate
(AbstractJdbc1Statement.java:273)
12237: at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.j
ava:50)
12236: at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.j
ava :517)
12235: at
org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
12234: at
org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
12233: at org.postgresql.core.QueryExecutor.executeV3
(QueryExecutor.java:152)
12232: at
org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139)
12231:
12230: Caused by: org.postgresql.util.PSQLException: FEHLER: Wert zu lang
f?Typ character varying(64)
12229: ... 14 more
12228: at
org.opencms.db.CmsSecurityManager.createProject(CmsSecurityManager.java:1024
)
12227: at
org.opencms.db.CmsDriverManager.createProject(CmsDriverManager.java:1398)
12226: at
org.opencms.db.generic.CmsProjectDriver.createProject(CmsProjectDriver.java:
179)
12225: Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred
when executing the following query: INSERT INTO CMS_PROJECTS
(PROJECT_ID,USER_ID,GROUP_ID,MANAGERGROUP_ID,TASK_ID,PROJECT_NAME,PROJECT_DE
SCRIPTION,PROJECT_FLAGS,DATE_CREATED,PROJECT_TYPE)VALUES
(57,'c300ba5c-01e8-3727-b305-5dcc9ccae1ee','5f81f1a1-1f7d-3af6-b188-3bac3da5
4580','5f81f1a1-1f7d-3af6-b188-3bac3da54580',57,'Import of module
com.alkacon.documentation.documentation_flexcache','System generated project
to import module
"com.alkacon.documentation.documentation_flexcache".',0,1140173072109,1).
12224: at org.opencms.setup.CmsSetupWorkplaceImportThread.run
(CmsSetupWorkplaceImportThread.java:186)
12223: at org.opencms.main.CmsShell.start(CmsShell.java:663)
12222: at
org.opencms.main.CmsShell.executeCommands(CmsShell.java:842)
12221: at org.opencms.main.CmsShell.executeCommand
(CmsShell.java:767)
12220: at
org.opencms.main.CmsShell$CmsCommandObject.executeMethod(CmsShell.java:246)
12219: at java.lang.reflect.Method.invoke(Method.java:324)
12218: at sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessorImpl.java:25)
12217: at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
12216: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
12215: at
org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(CmsSetupBean.java:
952)
12214: at
org.opencms.setup.CmsSetupBean.importModuleFromDefault(CmsSetupBean.java:172
4)
12213: at org.opencms.importexport.CmsImportExportManager.importData
(CmsImportExportManager.java:610)
12212: at
org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportEx
portHandler.java:325)
12211: at org.opencms.file.CmsObject.createProject(CmsObject.java
:566)
12210: at
org.opencms.db.CmsSecurityManager.createProject(CmsSecurityManager.java:1027
)
12209: at org.opencms.db.CmsDbContext.report(CmsDbContext.java:197)
12208: at org.opencms.db.CmsDbContext.throwException
(CmsDbContext.java:213)
12207: at
org.opencms.db.CmsDbSqlException.createException(CmsDbSqlException.java:103)
12206: org.opencms.db.CmsDbSqlException: Error creating project "Import
of module com.alkacon.documentation.documentation_flexcache ".
12205: ------ ... the module has been imported
12204: ------ ... the project has been published
12203: ------ ... finished updating search index "Offline project (VFS)"
12202: ( 26 ) Indexing file
/sites/default/alkacon-documentation/links/index.html ... skipped
11655: ( 2 / 26 ) Importing /alkacon-documentation/examples_flex_3/ ...
o.k.
11654: ( 1 / 26 ) Importing /alkacon-documentation/ ... o.k.
11653: ------ Importing module ...
com.alkacon.documentation.examples_flex_3 ... Import Version 4
11652: ... 16 more
11651: at
org.opencms.db.generic.CmsProjectDriver.createProject(CmsProjectDriver.java:
165)
11650: at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate
(DelegatingPreparedStatement.java:101)
11649: at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delegating
PreparedStatement.java:101)
11648: at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate
(AbstractJdbc1Statement.java:273)
11647: at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.j
ava:50)
11646: at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.j
ava :517)
11645: at
org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
11644: at
org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
11643: at org.postgresql.core.QueryExecutor.executeV3
(QueryExecutor.java:152)
11642: at
org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139)
11641:
11640: Caused by: org.postgresql.util.PSQLException: FEHLER: Wert zu lang
f?Typ character varying(64)
11639: ... 14 more
11638: at
org.opencms.db.CmsSecurityManager.createProject(CmsSecurityManager.java:1024
)
11637: at
org.opencms.db.CmsDriverManager.createProject(CmsDriverManager.java:1398)
11636: at
org.opencms.db.generic.CmsProjectDriver.createProject(CmsProjectDriver.java:
179)
11635: Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred
when executing the following query: INSERT INTO CMS_PROJECTS
(PROJECT_ID,USER_ID,GROUP_ID,MANAGERGROUP_ID,TASK_ID,PROJECT_NAME,PROJECT_DE
SCRIPTION,PROJECT_FLAGS,DATE_CREATED,PROJECT_TYPE)VALUES
(52,'c300ba5c-01e8-3727-b305-5dcc9ccae1ee','5f81f1a1-1f7d-3af6-b188-3bac3da5
4580','5f81f1a1-1f7d-3af6-b188-3bac3da54580',52,'Import of module
com.alkacon.documentation.documentation_scriptlet','System generated project
to import module
"com.alkacon.documentation.documentation_scriptlet".',0,1140172937349,1).
11634: at org.opencms.setup.CmsSetupWorkplaceImportThread.run
(CmsSetupWorkplaceImportThread.java:186)
11633: at org.opencms.main.CmsShell.start(CmsShell.java:663)
11632: at
org.opencms.main.CmsShell.executeCommands(CmsShell.java:842)
11631: at org.opencms.main.CmsShell.executeCommand
(CmsShell.java:767)
11630: at
org.opencms.main.CmsShell$CmsCommandObject.executeMethod(CmsShell.java:246)
11629: at java.lang.reflect.Method.invoke(Method.java:324)
11628: at sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessorImpl.java:25)
11627: at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
11626: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
11625: at
org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(CmsSetupBean.java:
952)
11624: at
org.opencms.setup.CmsSetupBean.importModuleFromDefault(CmsSetupBean.java:172
4)
11623: at org.opencms.importexport.CmsImportExportManager.importData
(CmsImportExportManager.java:610)
11622: at
org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportEx
portHandler.java:325)
11621: at org.opencms.file.CmsObject.createProject(CmsObject.java
:566)
11620: at
org.opencms.db.CmsSecurityManager.createProject(CmsSecurityManager.java:1027
)
11619: at org.opencms.db.CmsDbContext.report(CmsDbContext.java:197)
11618: at org.opencms.db.CmsDbContext.throwException
(CmsDbContext.java:213)
11617: at
org.opencms.db.CmsDbSqlException.createException(CmsDbSqlException.java:103)
11616: org.opencms.db.CmsDbSqlException: Error creating project "Import
of module com.alkacon.documentation.documentation_scriptlet ".
11615: ------ ... the module has been imported
11614: ------ ... the project has been published
11613: ------ ... finished updating search index "Offline project (VFS)"
11612: ( 33 ) Indexing file
/sites/default/alkacon-documentation/showsource.jsp ... skipped
11611: ( 32 ) Indexing file
/sites/default/alkacon-documentation/links/index.html ... skipped
11368: ( 3 / 27 ) Importing
/alkacon-documentation/howto_template/editable.html ... o.k.
11367: ( 2 / 27 ) Importing /alkacon-documentation/howto_template/ ...
o.k.
11366: ( 1 / 27 ) Importing /alkacon-documentation/ ... o.k.
11365: ------ Importing module ...
com.alkacon.documentation.howto_template ... Import Version 4
11364: ... 16 more
11363: at
org.opencms.db.generic.CmsProjectDriver.createProject(CmsProjectDriver.java:
165)
11362: at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delegating
PreparedStatement.java:101)
11361: at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delegating
PreparedStatement.java:101)
11360: at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1State
ment.java:273)
11359: at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.j
ava:50)
11358: at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.j
ava:517)
11357: at org.postgresql.core.QueryExecutor.execute
(QueryExecutor.java:43)
11356: at
org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
11355: at
org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152)
11354: at org.postgresql.util.PSQLException.parseServerError
(PSQLException.java:139)
11353:
11352: Caused by: org.postgresql.util.PSQLException: FEHLER: Wert zu lang
f?Typ character varying(64)
11351: ... 14 more
11350: at org.opencms.db.CmsSecurityManager.createProject
(CmsSecurityManager.java:1024)
11349: at
org.opencms.db.CmsDriverManager.createProject(CmsDriverManager.java:1398)
11348: at
org.opencms.db.generic.CmsProjectDriver.createProject(CmsProjectDriver.java:
179)
11347: Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred
when executing the following query: INSERT INTO CMS_PROJECTS
(PROJECT_ID,USER_ID,GROUP_ID,MANAGERGROUP_ID,TASK_ID,PROJECT_NAME,PROJECT_DE
SCRIPTION,PROJECT_FLAGS,DATE_CREATED,PROJECT_TYPE)VALUES
(49,'c300ba5c-01e8-3727-b305-5dcc9ccae1ee','5f81f1a1-1f7d-3af6-b188-3bac3da5
4580','5f81f1a1-1f7d-3af6-b188-3bac3da54580',49,'Import of module
com.alkacon.documentation.documentation_migration','System generated project
to import module
"com.alkacon.documentation.documentation_migration".',0,1140172860370,1).
11346: at org.opencms.setup.CmsSetupWorkplaceImportThread.run
(CmsSetupWorkplaceImportThread.java:186)
11345: at org.opencms.main.CmsShell.start(CmsShell.java:663)
11344: at
org.opencms.main.CmsShell.executeCommands(CmsShell.java:842)
11343: at org.opencms.main.CmsShell.executeCommand
(CmsShell.java:767)
11342: at
org.opencms.main.CmsShell$CmsCommandObject.executeMethod(CmsShell.java:246)
11341: at java.lang.reflect.Method.invoke(Method.java:324)
11340: at sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessorImpl.java:25)
11339: at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)
11338: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
11337: at
org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(CmsSetupBean.java:
952)
11336: at
org.opencms.setup.CmsSetupBean.importModuleFromDefault(CmsSetupBean.java:172
4)
11335: at org.opencms.importexport.CmsImportExportManager.importData
(CmsImportExportManager.java:610)
11334: at
org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportEx
portHandler.java:325)
11333: at org.opencms.file.CmsObject.createProject(CmsObject.java
:566)
11332: at
org.opencms.db.CmsSecurityManager.createProject(CmsSecurityManager.java:1027
)
11331: at org.opencms.db.CmsDbContext.report(CmsDbContext.java:197)
11330: at org.opencms.db.CmsDbContext.throwException
(CmsDbContext.java:213)
11329: at
org.opencms.db.CmsDbSqlException.createException(CmsDbSqlException.java:103)
11328: org.opencms.db.CmsDbSqlException: Error creating project "Import
of module com.alkacon.documentation.documentation_migration ".
11327: ------ ... the module has been imported
11326: ------ ... the project has been published
11325: ------ ... finished updating search index "Offline project (VFS)"
11324: ( 28 ) Indexing file
/sites/default/alkacon-documentation/showsource.jsp ... skipped
11323: ( 27 ) Indexing file
/sites/default/alkacon-documentation/links/index.html ... skipped
11204: ( 3 / 25 ) Importing
/alkacon-documentation/documentation_modules/administrate_modules.html ...
o.k.
11203: ( 2 / 25 ) Importing /alkacon-documentation/documentation_modules/
... o.k.
11202: ( 1 / 25 ) Importing /alkacon-documentation/ ... o.k.
11201: ------ Importing module ...
com.alkacon.documentation.documentation_modules ... Import Version 4
11200: at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportT
hread.java:186)
11199: at org.opencms.main.CmsShell.start(CmsShell.java:663)
11198: at
org.opencms.main.CmsShell.executeCommands(CmsShell.java:842)
11197: at org.opencms.main.CmsShell.executeCommand(CmsShell.java:767)
11196: at
org.opencms.main.CmsShell$CmsCommandObject.executeMethod(CmsShell.java :246)
11195: at java.lang.reflect.Method.invoke(Method.java:324)
11194: at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
11193: at sun.reflect.NativeMethodAccessorImpl.invoke
(NativeMethodAccessorImpl.java:39)
11192: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
11191: at
org.opencms.setup.CmsSetupBean.importModulesFromSetupBean(CmsSetupBean.java:
952)
11190: at
org.opencms.setup.CmsSetupBean.importModuleFromDefault(CmsSetupBean.java:172
4)
11189: at
org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportMa
nager.java:610)
11188: at org.opencms.module.CmsModuleImportExportHandler.importData
(CmsModuleImportExportHandler.java:359)
11187: at
org.opencms.module.CmsModuleImportExportHandler.importModule(CmsModuleImport
ExportHandler.java:499)
11186:
11185: com.alkacon.documentation.howto_httpd_tomcat_modproxy , Version
1.0
11184: ------ Importing module ...
com.alkacon.documentation.howto_multisite ...
org.opencms.configuration.CmsConfigurationException: Import failed. The
module "com.alkacon.documentation.howto_multisite , Version 3.0.2" requires
the following modules:
11183: ------ ... the module has been imported
11182: ------ ... the project has been published
11181: ------ ... finished updating search index "Offline project (VFS)"
11180: ( 91 ) Indexing file
/sites/default/alkacon-documentation/links/index.html ... skipped
11179: ( 90 ) Indexing file
/sites/default/alkacon-documentation/index.html ... skipped
Greetz, Dirk
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20060217/89ddce25/attachment.htm>
More information about the opencms-dev
mailing list