[opencms-dev] Installation problem OpenCMS 6.0.3 under Windows XP

Tue Dec 6 21:17:49 CET 2005

Michael,

Wow, tough problem!

I believe the solution is that your user table in mysql is lacking one
more permission. For some reason a GRANT statement wouldn't work 100%
for me on my install of OpenCms, but I thought that was just me. 

Log into your MySQL server, open up the user table and view the
permissions for your OpenCms DB user. Make sure that ALL the columns are
reporting a 'Y' and absolutely no 'N' 's!!!

You may have to write an INSERT statement with a bunch of 'Y','Y' 's in
it to successfully change the last 'N'.

If that's not it,...

Well, post again; I'll see what else I can find!

Clayton Corbey

-----Original Message-----
From: opencms-dev-bounces at opencms.org
[mailto:opencms-dev-bounces at opencms.org] On Behalf Of Zambra
Sent: Tuesday, December 06, 2005 13:31
To: opencms-dev at opencms.org
Subject: [opencms-dev] Installation problem OpenCMS 6.0.3 under Windows
XP

Hello Clayton, Jakob and Arash,

thanks again for your help regarding my install problem. I have:

- upgraded to Java SDK 1.5
- downgraded to MySQL 4.1
- created a user "admin" (is there a mention to this in the docs?) and 
granted him all the privileges

Then I have restarted the setup. As Clayton pointed out, the setup could

not log in as admin, and now it can. Nevertheless I keep getting other 
exceptions, as the one pasted below (it is the first one that appears in

the setup log:

===================
86:    Exception while calling method "publishProject".
87:    org.opencms.db.CmsDbSqlException: Error reading the publish list 
for project "_setupProject".
88:        at 
org.opencms.db.CmsDbSqlException.createException(CmsDbSqlException.java:
103)
89:        at 
org.opencms.db.CmsDbContext.throwException(CmsDbContext.java:213)
90:        at org.opencms.db.CmsDbContext.report(CmsDbContext.java:197)
91:        at 
org.opencms.db.CmsSecurityManager.getPublishList(CmsSecurityManager.java
:2085)
92:        at
org.opencms.file.CmsObject.getPublishList(CmsObject.java:1292)
93:        at
org.opencms.file.CmsObject.publishProject(CmsObject.java:1966)
94:        at
org.opencms.file.CmsObject.publishProject(CmsObject.java:1923)
95:        at
org.opencms.file.CmsObject.publishProject(CmsObject.java:1909)
96:        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
97:        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown
Source)
98:        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown 
Source)
99:        at java.lang.reflect.Method.invoke(Unknown Source)
100:        at 
org.opencms.main.CmsShell$CmsCommandObject.executeMethod(CmsShell.java:2
46)
101:        at
org.opencms.main.CmsShell.executeCommand(CmsShell.java:767)
102:        at
org.opencms.main.CmsShell.executeCommands(CmsShell.java:842)
103:        at org.opencms.main.CmsShell.start(CmsShell.java:663)
104:        at 
org.opencms.setup.CmsSetupWorkplaceImportThread.run(CmsSetupWorkplaceImp
ortThread.java:186)
105:    Caused by: org.opencms.db.CmsDbSqlException: An SQL error 
occurred when executing the following query: 
com.mysql.jdbc.PreparedStatement at 158f1fa: SELECT 
CMS_OFFLINE_STRUCTURE.STRUCTURE_ID,CMS_OFFLINE_STRUCTURE.RESOURCE_ID,CMS
_OFFLINE_STRUCTURE.RESOURCE_PATH,CMS_OFFLINE_STRUCTURE.STRUCTURE_STATE,C
MS_OFFLINE_STRUCTURE.DATE_RELEASED,CMS_OFFLINE_STRUCTURE.DATE_EXPIRED,CM
S_OFFLINE_RESOURCES.RESOURCE_ID,CMS_OFFLINE_RESOURCES.RESOURCE_TYPE,CMS_
OFFLINE_RESOURCES.RESOURCE_FLAGS,CMS_OFFLINE_RESOURCES.RESOURCE_STATE,CM
S_OFFLINE_RESOURCES.DATE_CREATED,CMS_OFFLINE_RESOURCES.DATE_LASTMODIFIED
,CMS_OFFLINE_RESOURCES.USER_CREATED,CMS_OFFLINE_RESOURCES.USER_LASTMODIF
IED,CMS_OFFLINE_RESOURCES.PROJECT_LASTMODIFIED 
LOCKED_IN_PROJECT,CMS_OFFLINE_RESOURCES.RESOURCE_SIZE,CMS_OFFLINE_RESOUR
CES.SIBLING_COUNT,CMS_OFFLINE_RESOURCES.PROJECT_LASTMODIFIED 
FROM CMS_OFFLINE_STRUCTURE,CMS_OFFLINE_RESOURCES WHERE 
CMS_OFFLINE_RESOURCES.RESOURCE_ID=CMS_OFFLINE_STRUCTURE.RESOURCE_ID AND 
(CMS_OFFLINE_RESOURCES.PROJECT_LASTMODIFIED='2')  AND 
(CMS_OFFLINE_RESOURCES.RESOURCE_SIZE > -1)  AND NOT 
(((CMS_OFFLINE_STRUCTURE.STRUCTURE_STATE='0' AND 
CMS_OFFLINE_STRUCTURE.STRUCTURE_STATE >= 
CMS_OFFLINE_RESOURCES.RESOURCE_STATE) OR 
(CMS_OFFLINE_RESOURCES.RESOURCE_STATE='0' AND 
CMS_OFFLINE_RESOURCES.RESOURCE_STATE >= 
CMS_OFFLINE_STRUCTURE.STRUCTURE_STATE)))  ORDER BY 
CMS_OFFLINE_STRUCTURE.RESOURCE_PATH.
106:        at 
org.opencms.db.generic.CmsVfsDriver.readResourceTree(CmsVfsDriver.java:1
708)
107:        at 
org.opencms.db.CmsDriverManager.getPublishList(CmsDriverManager.java:324
8)
108:        at 
org.opencms.db.CmsSecurityManager.getPublishList(CmsSecurityManager.java
:2078)
109:        ... 13 more
110:    Caused by: java.sql.SQLException: General error message from 
server: "Can't create/write to file 
'c:\docume%1\czerny\config%1\temp\#sql_780_0.MYI' (Errcode: 2)"
111:        at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997)
112:        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167)
113:        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278)
114:        at com.mysql.jdbc.Connection.execSQL(Connection.java:2247)
115:        at 
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:158
6)
116:        at 
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegat
ingPreparedStatement.java:92)
117:        at 
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegat
ingPreparedStatement.java:92)
118:        at 
org.opencms.db.generic.CmsVfsDriver.readResourceTree(CmsVfsDriver.java:1
701)
119:        ... 15 more

Thanks in advance for any hints.

Best regards,

Michael
zambra.com

_______________________________________________
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

CONFIDENTIALITY NOTICE:  This message is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law.  If the reader of this message is not the intended recipient you are hereby notified that any distribution, copying, disclosure and use of, or reliance on the contents of this transmission is strictly prohibited.  If you have received this transmission in error, please notify us immediately by return e-mail and destroy the transmission by deleting the original message, attachments and all copies.