[opencms-dev] Problem installing w/IIs and MSSQL2000

[mcyr at maine.edu]

Hi,

Don't know if this is a bug or operator error but here's what happenned to me
when trying to install OpenCMS this weekend on a W2K server with IIs and
MSSQL2000 (on another server on the same subnet)

After getting java1.4 installed and the microsoft jdbc driver, I edited the
opencms file to replace the merant driver reference with microsoft reference
(as noted in some other posts here).  Also I replaced the query.properties file
in the opencms.war archive with the one posted here recently (in the mssql
directory.. yes I think I got the path right).  

I was then able to run ocsetup.  The db and tables get created.  I select to
import the workspace.  The installation completed and appeared to go well but I
noticed the following SQL error (about 2000 lines in)

2101:	[mssql.CmsDbAccess] Destroyed
2100:	[com.opencms.dbpool.CmsPool] mssql: destroyed
2099:	[com.opencms.dbpool.CmsPool] mssqlbackup: destroyed
2098:	[com.opencms.dbpool.CmsPool] mssqlonline: destroyed
2097:	[CmsCronScheduler] Destroyed
2096:	{Admin at Online}> exit 
2095:	[FlexCache] Complete cache cleared - clear() called
2094:	------ .. filesystem link check finished
2093:	------ Checking filesystem links ...
2092:	[com.opencms.file.CmsObject.publishProject()/2] Vector was null or empty
2091:	[com.opencms.file.CmsObject.publishProject()/2] User: [User]:Admin , Id=2
, flags=0 , type=0 :the admin-user
2090:	[com.opencms.file.CmsObject.publishProject()/2] Project:6 Time:Mon Sep 15
13:11:01 EDT 2003
2089:	root cause was java.sql.SQLException: [Microsoft][SQLServer 2000 Driver
for JDBC][SQLServer]Violation of UNIQUE KEY constraint
'UQ__CMS_BACKUP_RESOU__1CF15040'. Cannot insert duplicate key in object
'CMS_BACKUP_RESOURCES'.
2088:	[com.opencms.file.CmsObject.publishProject()/1] Exception:
com.opencms.core.CmsException: 4 Sql exception. Detailed error:
[com.opencms.file.mssql.CmsDbAccess] [Microsoft][SQLServer 2000 Driver for
JDBC][SQLServer]Violation of UNIQUE KEY constraint
'UQ__CMS_BACKUP_RESOU__1CF15040'. Cannot insert duplicate key in object
'CMS_BACKUP_RESOURCES'.. 
2087:	[com.opencms.file.CmsObject.publishProject()/1] User: [User]:Admin , Id=2
, flags=0 , type=0 :the admin-user
2086:	[com.opencms.file.CmsObject.publishProject()/1] Project:6 Time:Mon Sep 15
13:11:01 EDT 2003
2085:	Publishing /system/bodies/release/
2084:	Publishing /system/bodies/release/



At that point I click to continue in ocsetup and the link from the next page to
"opencms" did not work; ie., returned a 404 error. 
http://localhost:81/opencms/opencms/index.jsp

However, the management applet runs:
http://localhost:81/opencms/opencms/system/login 

and I am able to login as admin.  However, the "release" folder is empty.


Questions:

1. Does the sql error during ocsetup matter?
2. If not, is there some other reason I don't see anything in "release" folder?


Mike Cyr
mcyr at maine.edu


--