[opencms-dev] missing cms_module_forum tables / Step 6th install problems

[Ilya Botvinnikov]

Has anyone had trouble with the installation procedure missing two tables?  The installation gets past step 5, which creates the tables.  But there are two tables, cms_module_forum and cms_module_forum_comment that seem to be missing.  I cannot find any reference to these tables outsideof the install docs.
And when i ran step 6th i'm getting the following output:


|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||

[oracle at oracle opencms_4.2]$ java -mx64M com.opencms.core.CmsShell config/opencms.properties < config/cmssetup.txt
[OpenCms] creating first cms-object
[OpenCms] initializing the main resource-broker
[CmsRbManager] ressourcebroker-name: genericsql
[CmsRbManager] ressourcebroker-classname: com.opencms.file.genericSql.CmsResourceBroker
[CmsRbManager] got rb-class
[CmsRbManager] created rb-instance
[CmsResourceBroker] init the dbaccess-module.
[CmsDbAccess] init the dbaccess-module.
[CmsDbAccess] read pool-name from configurations: jdbc:opencmspool:genericsql
[CmsDbAccess] read digest from configurations: MD5
[CmsDbAccess] digest created, using: sun.security.provider.MD5 Message Digest <incomplete>

[com.opencms.dbpool.CmsPool] genericsql: creating new connection. Current Amount is:0
[com.opencms.dbpool.CmsPool] genericsql: creating new connection. Current Amount is:1
[com.opencms.dbpool.CmsPool] genericsql: creating new connection. Current Amount is:2
[com.opencms.dbpool.CmsPool] genericsql: creating new connection. Current Amount is:3
[com.opencms.dbpool.CmsPool] genericsql: creating new connection. Current Amount is:4
[com.opencms.dbpool.CmsPool] genericsql: creating new connection. Current Amount is:5
[com.opencms.dbpool.CmsPool] genericsql: creating new connection. Current Amount is:6
[com.opencms.dbpool.CmsPool] genericsql: creating new connection. Current Amount is:7
[com.opencms.dbpool.CmsPool] genericsql: creating new connection. Current Amount is:8
[com.opencms.dbpool.CmsPool] genericsql: creating new connection. Current Amount is:9
[com.opencms.dbpool.CmsPool] genericsql: created
[com.opencms.dbpool.CmsPool] genericsql: starting connection-guard
[CmsDbAccess] fill default resources
[CmsDbAccess] fillDefaults() starting NOW!
[CmsRbManager] Critical error while loading resourcebroker.
[OpenCms] Critical error while loading resourcebroker.
[CmsException]: 33 Resourcebroker-init error. Detailed Error: Critical error while loading resourcebroker. . Caught Exception: >[CmsException]: 4 Sql exception. Detailed Error: [com.opencms.dbpool.Cms
IdGenerator]ORA-00942: table or view does not exist
. Caught Exception: >java.sql.SQLException: ORA-00942: table or view does not exist
<<
        at com.opencms.file.CmsRbManager.init(CmsRbManager.java:98)
        at com.opencms.core.OpenCms.<init>(OpenCms.java:123)
        at com.opencms.core.CmsShell.<init>(CmsShell.java:85)
        at com.opencms.core.CmsShell.main(CmsShell.java:196)
>[CmsException]: 4 Sql exception. Detailed Error: [com.opencms.dbpool.CmsIdGenerator]ORA-00942: table or view does not exist
>. Caught Exception: >java.sql.SQLException: ORA-00942: table or view does not exist
><
>       at com.opencms.dbpool.CmsIdGenerator.readId(CmsIdGenerator.java:150)
>       at com.opencms.dbpool.CmsIdGenerator.generateNextId(CmsIdGenerator.java:101)
>       at com.opencms.dbpool.CmsIdGenerator.nextId(CmsIdGenerator.java:80)
>       at com.opencms.file.genericSql.CmsDbAccess.nextId(CmsDbAccess.java:4112)
>       at com.opencms.file.genericSql.CmsDbAccess.addSystemProperty(CmsDbAccess.java:275)
>       at com.opencms.file.genericSql.CmsDbAccess.fillDefaults(CmsDbAccess.java:2371)
>       at com.opencms.file.genericSql.CmsDbAccess.<init>(CmsDbAccess.java:244)
>       at com.opencms.file.genericSql.CmsResourceBroker.createDbAccess(CmsResourceBroker.java:1577)
>       at com.opencms.file.genericSql.CmsResourceBroker.init(CmsResourceBroker.java:3632)
>       at com.opencms.file.CmsRbManager.init(CmsRbManager.java:86)
>       at com.opencms.core.OpenCms.<init>(OpenCms.java:123)
>       at com.opencms.core.CmsShell.<init>(CmsShell.java:85)
>       at com.opencms.core.CmsShell.main(CmsShell.java:196)
>>java.sql.SQLException: ORA-00942: table or view does not exist
>>      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
>>      at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java)
>>      at oracle.jdbc.ttc7.Oall7.receive(Oall7.java)
>>      at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java)
>>      at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java)
>>      at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java)
>>      at oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java)
>>      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java)
>>      at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java)
>>      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java)
>>      at com.opencms.dbpool.CmsPreparedStatement.executeQuery(CmsPreparedStatement.java:167)
>>      at com.opencms.dbpool.CmsIdGenerator.readId(CmsIdGenerator.java:143)
>>      at com.opencms.dbpool.CmsIdGenerator.generateNextId(CmsIdGenerator.java:101)
>>      at com.opencms.dbpool.CmsIdGenerator.nextId(CmsIdGenerator.java:80)
>>      at com.opencms.file.genericSql.CmsDbAccess.nextId(CmsDbAccess.java:4112)
>>      at com.opencms.file.genericSql.CmsDbAccess.addSystemProperty(CmsDbAccess.java:275)
>>      at com.opencms.file.genericSql.CmsDbAccess.fillDefaults(CmsDbAccess.java:2371)
>>      at com.opencms.file.genericSql.CmsDbAccess.<init>(CmsDbAccess.java:244)
>>      at com.opencms.file.genericSql.CmsResourceBroker.createDbAccess(CmsResourceBroker.java:1577)
>>      at com.opencms.file.genericSql.CmsResourceBroker.init(CmsResourceBroker.java:3632)
>>      at com.opencms.file.CmsRbManager.init(CmsRbManager.java:86)
>>      at com.opencms.core.OpenCms.<init>(OpenCms.java:123)
>>      at com.opencms.core.CmsShell.<init>(CmsShell.java:85)
>>      at com.opencms.core.CmsShell.main(CmsShell.java:196)

java.lang.NullPointerException
        at com.opencms.core.CmsShell.printPrompt(CmsShell.java:266)
        at com.opencms.core.CmsShell.commands(CmsShell.java:153)
        at com.opencms.core.CmsShell.main(CmsShell.java:199)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20010625/b51b4f90/attachment.htm>