<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content=text/html;charset=ISO-8859-1>
<META content="MSHTML 6.00.6000.16441" name=GENERATOR></HEAD>
<BODY text=#000000 bgColor=#ffffff>
<DIV dir=ltr align=left><SPAN class=513084207-11052007><FONT face=Verdana
size=2>Regarding DB compatibility of the 7.0 RC 1 release, here's whats written
in the release notes that install with RC1:</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV dir=ltr align=left><FONT face=Verdana><FONT size=2><SPAN
class=513084207-11052007>"</SPAN>On the database side, we have tested with
MySQL 4.0, MySQL 4.1, MySQL 5.0, Oracle 9.x and Oracle 10.x. Support for other
DBs still needs to be updated for OpenCms 7.<SPAN
class=513084207-11052007>"</SPAN></FONT></FONT></DIV></BLOCKQUOTE>
<DIV dir=ltr align=left><SPAN class=513084207-11052007><FONT face=Verdana
size=2>Support for other DBs will be provided when the contributors have
finished their work on the drivers. I am confident PostgeSQL will be ready for
RC2. </FONT></SPAN></DIV>
<P><FONT face=Verdana size=2>Kind
Regards,<BR>Alex.<BR><BR>-------------------<BR>Alexander
Kandzior<BR> <BR>Alkacon
Software GmbH - The OpenCms
Experts <BR></FONT><A
href="http://www.alkacon.com/"><FONT face=Verdana
size=2>http://www.alkacon.com</FONT></A><FONT face=Verdana size=2> - </FONT><A
href="http://www.opencms.org/"><FONT face=Verdana
size=2>http://www.opencms.org</FONT></A><FONT face=Verdana
size=2>
</FONT></P>
<DIV> </DIV><BR>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=de dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> opencms-dev-bounces@opencms.org
[mailto:opencms-dev-bounces@opencms.org] <B>On Behalf Of
</B>Marco<BR><B>Sent:</B> Thursday, May 10, 2007 11:21 PM<BR><B>To:</B> The
OpenCms mailing list<BR><B>Subject:</B> Re: [opencms-dev] OpenCms 7 RC 1
available<BR></FONT><BR></DIV>
<DIV></DIV>I got a bit further by creating my own pg.sql (postgresql
create_tables) file.<BR>All files including my pg.sql file can be found on <A
class=moz-txt-link-freetext
href="http://www.weeswel.com/logs/">http://www.weeswel.com/logs/</A><BR><BR>At
the moment I am stuck on the fact that the code depends on Mysql fucking up an
schema constraint by making something up for an not null field<BR>Read on for
the gory details.<BR><BR>P.S. Can the devs shed some light on this and create
a patch or is this a self-service scenario.<BR>P.P.S. Can I trust this code to
work properly on anything else then Mysql. <BR>The fact that you can't even do
a basic install of this 7.0RC1 on an postgresql doesn't inspire
confidence.This is next to the fact that the code is dependant on Mysql
quirks.<BR><BR><BR><BR>In Pseudo language my steps to get something working,
since the original postgresql database template does not
work<BR><BR>1)Download the script mysql2pgsql.perl<BR>2)cp
%opencms%/setup/database/mysql_41/create_tables.sql
/tmp/Mysql_create_tables.sql<BR>3)vi /tmp/Mysql_create_tables.sql
<BR> Strip all indexes from this file<BR>
Strip all Characterset utf 8 from this file<BR> Strip all
TEXT BINARY from this file<BR> Strip all (255) from the
PRIMARY KEY entries<BR><BR>3)./mysql2pgsql.perl --nodrop
/tmp/Mysql_create_tables pg.sql<BR>4)Deploy your opencms.war(7.0RC1)
file wait until it is extracted<BR>5)cp pg.sql
.%OPENCMS%/setup/database/postgresql/create_tables.sql<BR><BR>6) Open the <A
class=moz-txt-link-freetext
href="http://yoursite/opencms/setup">http://yoursite/opencms/setup</A> and
follow the setup routine<BR>7) Choose to install all documentation to exercise
the database table a bit<BR><BR>This import failed, I found the following
problem in the %opencms%/WEB-INF/logs/setup.log file<BR>Important part
follows<BR><I>17: Caused by:
org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the
following query: INSERT INTO CMS_ONLINE_STRUCTURE
(STRUCTURE_ID,RESOURCE_ID,RESOURCE_PATH,STRUCTURE_STATE,DATE_RELEASED,DATE_EXPIRED,PARENT_ID)<BR>VALUES
('04a8d8f6-ff37-11db-964e-2df1a5244f64','04a8d8f7-ff37-11db-964e-2df1a5244f64','/',0,0,9223372036854775807,'00000000-0000-0000-0000-000000000000').<BR>
<BR>23: Caused by: org.postgresql.util.PSQLException:
Parameter index out of range.<BR></I><BR><I><BR></I>So we try to run this
query from the pgsql commandline<I><BR>opencms150=# \d
CMS_ONLINE_STRUCTURE;<BR> Table
"public.cms_online_structure"<BR>
Column | Type |
Modifiers<BR>-------------------+----------+-----------<BR> structure_id
| bytea | not
null<BR> resource_id |
bytea | not
null<BR> parent_id |
bytea | not
null<BR> resource_path |
text | not null<BR> structure_state |
smallint | not null<BR> date_released |
bigint | not
null<BR> date_expired | bigint
| not null<BR> structure_version | integer | not
null<BR>Indexes:<BR> "cms_online_structure_pkey" PRIMARY
KEY, btree (structure_id)<BR>Check constraints:<BR>
"cms_online_structure_structure_state_check" CHECK (structure_state >=
0)<BR><BR>opencms150=# INSERT INTO CMS_ONLINE_STRUCTURE
(STRUCTURE_ID,RESOURCE_ID,RESOURCE_PATH,STRUCTURE_STATE,DATE_RELEASED,DATE_EXPIRED,PARENT_ID)<BR>opencms150-#
VALUES
('04a8d8f6-ff37-11db-964e-2df1a5244f64','04a8d8f7-ff37-11db-964e-2df1a5244f64','/',0,0,9223372036854775807,'00000000-0000-0000-0000-000000000000')<BR>opencms150-#
;</I><BR><I>ERROR: null value in column "structure_version" violates
not-null constraint<BR></I><BR>So what happens is a violation of the database
schema, column structure_version is not filled in the statement so Postgresql
properly refuses to honor the request.<BR><BR><BR>Just to pain myself I
installed the product pretending to be a database server
My-SQL.<BR><I>mysql> describe
CMS_ONLINE_STRUCTURE;<BR>+-------------------+----------------------+------+-----+---------+-------+<BR>|
Field
|
Type
| Null | Key | Default | Extra
|<BR>+-------------------+----------------------+------+-----+---------+-------+<BR>|
STRUCTURE_ID |
varchar(36) |
NO | PRI |
| |<BR>|
RESOURCE_ID |
varchar(36) |
NO | MUL |
| |<BR>|
PARENT_ID |
varchar(36) |
NO | MUL |
| |<BR>|
RESOURCE_PATH |
text
| NO | MUL |
| |<BR>| STRUCTURE_STATE |
smallint(5) unsigned | NO | MUL
|
| |<BR>|
DATE_RELEASED |
bigint(20) |
NO |
|
| |<BR>|
DATE_EXPIRED |
bigint(20) |
NO |
|
| |<BR>| STRUCTURE_VERSION |
int(11)
| NO |
|
|
|<BR>+-------------------+----------------------+------+-----+---------+-------+<BR>8
rows in set (0.01 sec)<BR></I><BR>So the NOT NULL constraint is still with us,
thats great that means it is not a problem caused by my conversion, but what
goes wrong.<BR> Lets try the query in Mysql<BR><BR><I>mysql> INSERT
INTO<BR> -> CMS_ONLINE_STRUCTURE
(STRUCTURE_ID,RESOURCE_ID,RESOURCE_PATH,STRUCTURE_STATE,DATE_RELEASED,DATE_EXPIRED,PARENT_ID
) VALUES (<BR> ->
'95c23c20-ff2c-11db-9bd2-b3972de27f02','95c23c21-ff2c-11db-9bd2-b3972de27f02','/',0,0,9223372036854775807,'000000
00-0000-00<BR> '> 00-0000-000000000000');<BR>Query OK, 1
row affected, 2 warnings (0.05 sec)<BR><BR></I><BR><I>mysql> select * from
CMS_ONLINE_STRUCTURE;<BR>+--------------------------------------+--------------------------------------+--------------------------------------+---------------+-----------------+---------------+---------------------+-------------------+<BR>|
STRUCTURE_ID
|
RESOURCE_ID
|
PARENT_ID
| RESOURCE_PATH | STRUCTURE_STATE | DATE_RELEASED |
DATE_EXPIRED | STRUCTURE_VERSION
|<BR>+--------------------------------------+--------------------------------------+--------------------------------------+---------------+-----------------+---------------+---------------------+-------------------+<BR>|
95c23c20-ff2c-11db-9bd2-b3972de27f02 | 95c23c21-ff2c-11db-9bd2-b3972de27f02 |
00000000-0000-00<BR>00-0000-00000000000 |
/
|
0 | 0
| 9223372036854775807
|
0
|<BR>+--------------------------------------+--------------------------------------+--------------------------------------+---------------+-----------------+---------------+---------------------+-------------------+<BR>1
row in set (0.00 sec)<BR><BR><BR></I>I didn't mention any versions since
My-Sql has a long reputation of mangling data and Postgresl has a long
reputation of honoring these kinds of
constraints.<BR><I><BR></I><BR><BR><BR><BR><BR><BR>Marco schreef:
<BLOCKQUOTE cite=mid:46433B56.2050502@weeswel.com type="cite">It seems like
it, <BR>Caused by: java.sql.SQLException: Column not found message from
server: "Unknown column 'CMS_ONLINE_STRUCTURE.STRUCTURE_VERSION' in 'field
list'" <BR><BR>Same as with me, the Postgresl dump doesn't contain the
STRUCTURE_VERSION field list for the CMS_ONLINE_STRUCTURE table. And
atleast one of the many Mysql dumps does contain a dump which presumably is
correct. <BR><BR><BR><BR>Stéphane Verger schreef: <BR>
<BLOCKQUOTE type="cite">Hi ! <BR><BR>I had an unexpected error trying to
install OpenCms 7 RC1 with the java 1.4 package. <BR>It seems to have a
problem with the sql schemas, is it the same problem as yours, marco ?
<BR><BR>Has anybody already had the same probleme, and got a solution ?
<BR><BR>Ty, <BR><BR>R. <BR><BR><BR><BR>47: Shutdown
completed, total uptime was 00:00:29. <BR>46: Shutting
down OpenCms, version 7 RC 1 (6.9.1) in web application "opencms7beta"
<BR>45: 44:
43: at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:209)
<BR>42: at
org.opencms.setup.CmsSetupWorkplaceImportThread.kill(CmsSetupWorkplaceImportThread.java:118)
<BR>41: at
org.opencms.main.CmsShell.exit(CmsShell.java:557)
<BR>40: java.lang.NullPointerException
<BR>39: at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:194)
<BR>38: at
org.opencms.main.CmsShell.start(CmsShell.java:646)
<BR>37: at
org.opencms.main.CmsShell.executeCommands(CmsShell.java:818)
<BR>36: at
org.opencms.main.CmsShell.executeCommand(CmsShell.java:743)
<BR>35:
${user}@${project}>java.lang.NullPointerException
<BR>34: ${user}@${project}># Turn echo on
<BR>33: ... 9 more
<BR>32: at
org.opencms.db.generic.CmsVfsDriver.readResource(CmsVfsDriver.java:1653)
<BR>31: at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
<BR>30: at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
<BR>29: at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1634)
<BR>28: at
com.mysql.jdbc.Connection.execSQL(Connection.java:2281)
<BR>27: at
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)
<BR>26: at
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1168)
<BR>25: at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2001)
<BR>24: Caused by: java.sql.SQLException: Column not
found message from server: "Unknown column
'CMS_ONLINE_STRUCTURE.STRUCTURE_VERSION' in 'field list'"
<BR>23: ... 5 more
<BR>22: at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2579)
<BR>21: at
org.opencms.db.CmsDriverManager.init(CmsDriverManager.java:4034)
<BR>20: at
org.opencms.db.generic.CmsProjectDriver.fillDefaults(CmsProjectDriver.java:577)
<BR>19: at
org.opencms.db.generic.CmsVfsDriver.createResource(CmsVfsDriver.java:471)
<BR>18: at
org.opencms.db.generic.CmsVfsDriver.readResource(CmsVfsDriver.java:1666)
<BR>17: Caused by: org.opencms.db.CmsDbSqlException: An
SQL error occurred when executing the following query:
com.mysql.jdbc.PreparedStatement@12ce574: SELECT
CMS_ONLINE_STRUCTURE.STRUCTURE_ID,CMS_ONLINE_STRUCTURE.RESOURCE_ID,CMS_ONLINE_STRUCTURE.RESOURCE_PATH,CMS_ONLINE_STRUCTURE.STRUCTURE_STATE,CMS_ONLINE_STRUCTURE.DATE_RELEASED,CMS_ONLINE_STRUCTURE.DATE_EXPIRED,CMS_ONLINE_STRUCTURE.STRUCTURE_VERSION,CMS_ONLINE_RESOURCES.RESOURCE_ID,CMS_ONLINE_RESOURCES.RESOURCE_TYPE,CMS_ONLINE_RESOURCES.RESOURCE_FLAGS,CMS_ONLINE_RESOURCES.RESOURCE_STATE,CMS_ONLINE_RESOURCES.DATE_CREATED,CMS_ONLINE_RESOURCES.DATE_LASTMODIFIED,CMS_ONLINE_RESOURCES.USER_CREATED,CMS_ONLINE_RESOURCES.USER_LASTMODIFIED,CMS_ONLINE_RESOURCES.PROJECT_LASTMODIFIED
LOCKED_IN_PROJECT,CMS_ONLINE_RESOURCES.RESOURCE_SIZE,CMS_ONLINE_RESOURCES.DATE_CONTENT,CMS_ONLINE_RESOURCES.SIBLING_COUNT,CMS_ONLINE_RESOURCES.RESOURCE_VERSION,CMS_ONLINE_RESOURCES.PROJECT_LASTMODIFIED
FROM CMS_ONLINE_STRUCTURE,CMS_ONLINE_RESOURCES WHERE
CMS_ONLINE_STRUCTURE.RESOURCE_PATH='/' AND
CMS_ONLINE_STRUCTURE.RESOURCE_ID=CMS_ONLINE_RESOURCES.RESOURCE_ID ORDER BY
CMS_ONLINE_STRUCTURE.STRUCTURE_STATE ASC.
<BR>16: at
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImportThread.java:155)
<BR>15: at
org.opencms.main.CmsShell.<init>(CmsShell.java:450)
<BR>14: at
org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1684)
<BR>13: at
org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1111)
<BR>12: at
org.opencms.db.CmsSecurityManager.newInstance(CmsSecurityManager.java:168)
<BR>11: at
org.opencms.db.CmsSecurityManager.init(CmsSecurityManager.java:2588)
<BR>10: org.opencms.main.CmsInitException: Critical
error while loading driver manager. <BR>9:
-------------------- <BR>8: Giving up, unable to start
OpenCms. <BR>7: Critical error while loading driver
manager. <BR>6: The following critical error occured:
<BR>5: -------------------- <BR>4:
3: 2: OpenCms property file:
"C:\dev\java\jakarta-tomcat-5.0.30\webapps\opencms7beta\WEB-INF\config\opencms.properties".
<BR>1: OpenCms WEB-INF path:
"C:\dev\java\jakarta-tomcat-5.0.30\webapps\opencms7beta\WEB-INF\".
<BR><BR>Marco a écrit : <BR>
<BLOCKQUOTE type="cite">I just tried to install this release candidat
but couldn't get it to work. <BR>The OpenCms logging mentioned problems
with a query, this had to do with the absence of the group_ou column in
the cms_groups tables. <BR><BR>This field could not be found on the
database server and in the setup/database/postgresql/create_tables file.
<BR>When comparing the oracle, mysql en Postgresql dump I suspect that
the Postgresql dump is horribly out of date. <BR><BR>Hope this helps the
RC phase a bit further. <BR><BR>Cheers,
<BR><BR><BR>_______________________________________________ <BR>This
mail is sent to you from the opencms-dev mailing list <BR>To change your
list options, or to unsubscribe from the list, please visit <BR><A
class=moz-txt-link-freetext
href="http://lists.opencms.org/mailman/listinfo/opencms-dev">http://lists.opencms.org/mailman/listinfo/opencms-dev</A>
<BR><BR><BR></BLOCKQUOTE><BR><BR>_______________________________________________
<BR>This mail is sent to you from the opencms-dev mailing list <BR>To
change your list options, or to unsubscribe from the list, please visit
<BR><A class=moz-txt-link-freetext
href="http://lists.opencms.org/mailman/listinfo/opencms-dev">http://lists.opencms.org/mailman/listinfo/opencms-dev</A>
<BR></BLOCKQUOTE><BR><BR>_______________________________________________
<BR>This mail is sent to you from the opencms-dev mailing list <BR>To change
your list options, or to unsubscribe from the list, please visit <BR><A
class=moz-txt-link-freetext
href="http://lists.opencms.org/mailman/listinfo/opencms-dev">http://lists.opencms.org/mailman/listinfo/opencms-dev</A>
<BR></BLOCKQUOTE><BR></BLOCKQUOTE></BODY></HTML>