[opencms-dev] Re: OpenCms Mappings
ddbradley at highlights-corp.com
ddbradley at highlights-corp.com
Wed Sep 3 16:50:00 CEST 2003
Eva,
This is the error I'm Getting during the install:
MSSQL Driver Exception:
admin-user
2090: [com.opencms.file.CmsObject.publishProject()/2] Project:6 Time:Wed
Sep 03 08:51:53 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:Wed
Sep 03 08:51:53 EDT 2003
2085: Publishing /system/bodies/release/
Afterwards I try to login and it willn't accept the user name or password.
I get the following error in the hidden details box:
com.opencms.core.CmsException: 10 Unknown User. Detailed error: [OpenCms
login failed].
at com.opencms.workplace.CmsLoginNew.getContent(CmsLoginNew.java:150)
at
com.opencms.template.cache.CmsElementXml.getContent(CmsElementXml.java:171)
at
com.opencms.template.cache.CmsUri.callCanonicalRoot(CmsUri.java:185)
at
com.opencms.template.cache.CmsElementCache.callCanonicalRoot(CmsElementCache.java:149)
at
com.opencms.launcher.CmsXmlLauncher.generateOutput(CmsXmlLauncher.java:285)
at
com.opencms.launcher.CmsXmlLauncher.launch(CmsXmlLauncher.java:341)
at
com.opencms.launcher.A_CmsLauncher.initlaunch(A_CmsLauncher.java:274)
at com.opencms.core.OpenCms.showResource(OpenCms.java:956)
at
com.opencms.core.OpenCmsHttpServlet.doGet(OpenCmsHttpServlet.java:310)
at
com.opencms.core.OpenCmsHttpServlet.doPost(OpenCmsHttpServlet.java:331)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2396)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:405)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:380)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:508)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:533)
at java.lang.Thread.run(Thread.java:536)
If you have any ideas let me know.
Thanks.
Dean Bradley
Information Systems
Applications Development
________________________________________
"Ars Gratia Artis"
eva
<eva at nofrillsdvd. To: ddbradley at highlights-corp.com
com> cc:
Subject: Re: OpenCms Mappings
09/03/2003 10:01
AM
Hi,
I'm not sure why this is happening. Did the workspace import without
errors when you installed?
You're not getting any errors on the server when cms starts?
I didn't have to do anything extra for it to work... Sorry I can't be of
more help.
-eva
At 9/2/2003 08:57 AM, you wrote:
>Eve,
>
>Thanks for the help. I go OpenCms to install correctly but I get a 404
when
>I try to login. I'm using port 80, is there any additional mappings that
>need to be applied. Please let me know.
>
> http://localhost/opencms/opencms/system/login
>
>Thanks,
>
>
>Dean Bradley
>Information Systems
>Applications Development
>________________________________________
>
>"Ars Gratia Artis"
>
>
>
>
>
> eva
>
> <kaniasty at yahoo.co To:
> opencms-dev at opencms.org
> m> cc:
>
> Sent by: Subject: [opencms-dev]
> SQL Server Install
> opencms-dev-admin@
>
> opencms.org
>
>
>
>
>
> 08/28/2003
> 10:28
>
> AM
>
> Please respond
> to
>
> opencms-dev
>
>
>
>
>
>
>
>
>
>
>Here is how I got it to work with SQL Server:
>
>(the assumption is that you've got your war deployed, and you can run
>ocsetup from your browser.
>
>I used the the free microsoft JDBC driver (only works with SQL 2000
>though).
>I put the driver files in the Tomcat's common\lib (msutil.jar,
>mssqlserver.jar, msbase.jar)
>
>I had to change all references to merant
>in webapps\opencms\WEB-INF\config\opencms.properties
>to microsoft. i.e.
>
>com.microsoft.jdbc.sqlserver.SQLServerDriver
>jdbc:microsoft:sqlserver
>
>
>Then when you run the setup, it still puts merant in the sql server
>connection string during the setup- make sure you change that
>to microsoft. You have to give it the username of the sa db user, and for
>the opencms login, it will
>create a database of the name you enter, and a user of the same name (i.e.
>opencms, with user opencms).
>Another thing, if your setup fails after the database and or/ user have
>been created, you'll have to go into
>SQL server and delete both, or it will give an error when you try to
re-run
>
>it. So _don't_ create a database or user
>in SQL server before you begin!
>
>Once you have the database set up, you can log into CMS with user
>Admin/admin.
>However, there is another bug you have to take care of.
>
>You have to modify the mssql query.properties file in opencms.jar , or
>you'll keep getting an error message about "Invalid parameter binding"
when
>you
>try to do things within the content manager.
>
>To do this, you have to delete a line in the com\opencms\file\mssql
>query.properties file within the
>\webapps\opencms\WEB-INF\lib\opencms.jar. I'm not sure whether this fix
>has no harmful effects of some kind,
>but it's the only way I've gotten it to work.
>
>Here are instructions I found in this mailing list archive for doing it -
>just follow the directions to remove that line - just make sure that you
>get the query.properties back into the
>jar with the correct path, i.e. com\opencms\file\mssql , or it won't
work.
>
> > I traced down the problem to be in the file:
> > com/opencms/file/mssql/query.properties at key
> > C_RESOURCES_GET_FILESINFOLDER
> >=20
> > SELECT CMS_RESOURCES.RESOURCE_ID, CMS_RESOURCES.PARENT_ID, \
> > CMS_RESOURCES.RESOURCE_NAME, CMS_RESOURCES.RESOURCE_TYPE, \
> > CMS_RESOURCES.RESOURCE_FLAGS, CMS_RESOURCES.USER_ID, \
> > CMS_RESOURCES.GROUP_ID, CMS_PROJECTRESOURCES.PROJECT_ID, \
> > CMS_RESOURCES.FILE_ID, CMS_RESOURCES.ACCESS_FLAGS,=20
> > CMS_RESOURCES.STATE, \
> > CMS_RESOURCES.LOCKED_BY, CMS_RESOURCES.LAUNCHER_TYPE, \
> > CMS_RESOURCES.LAUNCHER_CLASSNAME, CMS_RESOURCES.DATE_CREATED, \
> > CMS_RESOURCES.DATE_LASTMODIFIED, CMS_RESOURCES.RESOURCE_SIZE, \
> > CMS_RESOURCES.RESOURCE_LASTMODIFIED_BY, \
> > CMS_RESOURCES.PROJECT_ID LOCKED_IN_PROJECT \
> > FROM CMS_RESOURCES, CMS_PROJECTRESOURCES \
> > WHERE CMS_RESOURCES.PARENT_ID=3D? \
> > AND CMS_RESOURCES.RESOURCE_NAME LIKE
> > RTRIM(CMS_PROJECTRESOURCES.RESOURCE_NAME)+'%' \
> > AND CMS_RESOURCES.RESOURCE_TYPE <> 0 \
> > AND CMS_PROJECTRESOURCES.PROJECT_ID =3D ? \
> > ORDER BY CMS_RESOURCES.RESOURCE_NAME
> >=20
> > As you can see the prepared statment requires 2 parameters=20
> > but only one is
> > set in the source code, so we removed
> > "AND CMS_PROJECTRESOURCES.PROJECT_ID =3D ?" part.
> > The query found in the other file:
> > com/opencms/file/genericSql/query.properties
> > seems to be correct and has only one parameter.
> >=20
> > After rebuilding the jar file opencms worked without errors.
>
>
>After following these steps, everything seems to work, except for the
weird
>
>triplicate issue.I bet there's a sql statement error somewhere that's
>causing it... If anybody has found it,
>please share!
>
>-eva
>
>
>At 8/28/2003 09:47 AM, you wrote:
>
> >Eva,
> >
> >I'm attempting in install OpenCms 5.0 using the Merant driver and mssql.
> >I'm encountering a lot of problems with the install, all of them dealing
> >with the mssql server. I was wondering if you had the same problem and
if
> >so what you did to get around them? what driver you ended up using? Your
> >response would help me out a lot.
> >
> >Thanks.
> >
> >Dean Bradley
> >Information Systems
> >Applications Development
> >________________________________________
> >
> >"Ars Gratia Artis"
> >
> >
> >
> >
> >
> > eva
> >
> > <kaniasty at yahoo.co To:
> > opencms-dev at opencms.org
> > m> cc:
> >
> > Sent by: Subject: [opencms-dev]
> > odd behavior
> > opencms-dev-admin@
> >
> > opencms.org
> >
> >
> >
> >
> >
> > 08/28/2003
> > 09:35
> >
> > AM
> >
> > Please respond
> > to
> >
> > opencms-dev
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >I just installed opencms, and I'm seeing some weird behavior.
> >I added an image to an image gallery, and a link to the link gallery.
> >When I go to view either of them, the images/links show up in
triplicate.
> >
> >I am using MSSql.
> >
> >Anybody know if this is a known bug, and how to fix it?
> >
> >Thanks.
> >
> >-eva
> >
> >
> >_______________________________________________
> >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
>
>
>_______________________________________________
>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
More information about the opencms-dev
mailing list