[opencms-dev] OpenCMS 5.0 and SQL Server 2000 problem

[Martin Alley]

Is importing workspace the thing you need to do if you want to upgrade
from an older version of opencms? - it's a while since I ran the setup
wizard.

I didn't need to upgrade from an older version, and have successfully
run the setup wizard against sql2000.

Martin


-----Original Message-----
From: opencms-dev-admin at opencms.org
[mailto:opencms-dev-admin at opencms.org] On Behalf Of Cory L Hubert
Sent: 30 December 2003 14:37
To: opencms-dev at opencms.org
Subject: RE: [opencms-dev] OpenCMS 5.0 and SQL Server 2000 problem

	I ran into the same issue.   I didn't here a response from
anyone on the
list.

	I used both the Opta2000 Driver, Microsoft's JDBC Driver, and
the Mercant
driver and recieved the same error message consistantly.

	Does anyone have a solution?  If not an ETA on when OpenCMS will
be working
with SQLServer would be great.


-----Original Message-----
From: opencms-dev-admin at opencms.org
[mailto:opencms-dev-admin at opencms.org]On Behalf Of Michael Goodwin
Sent: Tuesday, December 30, 2003 9:32 AM
To: opencms-dev at opencms.org
Subject: [opencms-dev] OpenCMS 5.0 and SQL Server 2000 problem







This is to follow up my last email. The 'import workspace' infact does
log
an error. Judging by the history log someone else had this same
identical
problem about one month ago, but it didn't appear to be resolved.

The last few lines of the log are:


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:Tue
Dec 30 14:57:13 CET 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:Tue
Dec 30 14:57:13 CET 2003
2085:        Publishing /system/bodies/release/
2084:        Publishing /system/bodies/release/
2083:        Publishing /release/



>I'm a new user trying to install opencms:
>system:
>     win 2000 server
>     MS SQL server
>     tomcat 5.0
>
>Having overcome all the problems listed below (with solutions) the
setup
completes and points to ..../index.jsp,  which doesn't seem to exist.
>
>Mike.
>
>
> It's been a little bit of a nightmare so far (this is probably
familiar
to some)
>1.fix character encoding ,
>- under startmenu Tomcat->configure->JVM tag add in line
"-Dfile.encoding=ISO-8859-1"
>2.get microsoft jdbc driver (from ms website)
> -put the 3 jars in %tomcat%\webapps\web-inf\lib
> -modify all occurances merant in the opencms.properties file , like
below.
>     "merant.datadirect"->"microsoft"
>               "merant"->"microsoft"
>3.change lost 'sa' password.
>     a) logon as local admin
>     b) open a cmd promt
>     c) osql -E -Q "sp_password NULL,password,sa"
>4.stop/start everything lots of times/ faf around in the SQL Server
enterprise manager/reimport, reinstall...

_______________________________________________
This mail is send to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please
visit
http://mail.opencms.org/mailman/listinfo/opencms-dev

_______________________________________________
This mail is send to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please
visit
http://mail.opencms.org/mailman/listinfo/opencms-dev