• Welcome to KonaKart Community Forum. Please login or sign up.
 

Open Cms Installation Help

Started by honusurf, September 02, 2008, 09:05:11 am

Previous topic - Next topic

honusurf

Help-I imported the module from my newly installed opencms but I got the errors in red
Importing module ... com.konakart ... Import Version 6
( 1 / 39 ) Importing /konakart-integration/ ... o.k.
( 2 / 39 ) Importing /konakart-integration/index.jsp ... o.k.
( 3 / 39 ) Importing /konakart-integration/index_content.html ... o.k.
( 4 / 39 ) Importing /system/ ... o.k.
( 5 / 39 ) Skipping /system/modules/
( 6 / 39 ) Importing /system/modules/com.konakart/ ... o.k.
( 7 / 39 ) Importing /system/modules/com.konakart/documentation/ ... o.k.
( 8 / 39 ) Importing /system/modules/com.konakart/documentation/KonaKart_OpenCms.pdf ... o.k.
( 9 / 39 ) Importing /system/modules/com.konakart/elements/ ... o.k.
( 10 / 39 ) Importing /system/modules/com.konakart/elements/BestSellersTile.jsp ... o.k.
( 11 / 39 ) Importing /system/modules/com.konakart/elements/Footer.jsp ... o.k.
( 12 / 39 ) Importing /system/modules/com.konakart/elements/Header.jsp ... o.k.
( 13 / 39 ) Importing /system/modules/com.konakart/elements/index.jsp ... o.k.
( 14 / 39 ) Importing /system/modules/com.konakart/elements/NewProductsBody.jsp ... o.k.
( 15 / 39 ) Importing /system/modules/com.konakart/lib/ ... o.k.
( 16 / 39 ) Importing /system/modules/com.konakart/lib/axis.jar ... Exception org.opencms.db.CmsDbSqlException: Error creating resource "/system/modules/com.konakart/lib/axis.jar" on path "/system/modules/com.konakart/lib/axis.jar".
at org.opencms.db.CmsDbSqlException.createException(CmsDbSqlException.java:116)
at org.opencms.db.CmsDbContext.throwException(CmsDbContext.java:238)
at org.opencms.db.CmsDbContext.report(CmsDbContext.java:212)
at org.opencms.db.CmsSecurityManager.importResource(CmsSecurityManager.java:2638)
at org.opencms.file.types.A_CmsResourceType.importResource(A_CmsResourceType.java:495)
at org.opencms.file.CmsObject.importResource(CmsObject.java:2015)
at org.opencms.importexport.CmsImportVersion5.importResource(CmsImportVersion5.java:436)
at org.opencms.importexport.CmsImportVersion5.readResourcesFromManifest(CmsImportVersion5.java:624)
at org.opencms.importexport.CmsImportVersion5.importData(CmsImportVersion5.java:177)
at org.opencms.importexport.CmsImport.importData(CmsImport.java:124)
at org.opencms.module.CmsModuleImportExportHandler.importModule(CmsModuleImportExportHandler.java:604)
at org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportExportHandler.java:381)
at org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportManager.java:680)
at org.opencms.workplace.threads.CmsDatabaseImportThread.run(CmsDatabaseImportThread.java:94)
Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the following query: com.mysql.jdbc.PreparedStatement@111c6e: INSERT INTO CMS_OFFLINE_CONTENTS (RESOURCE_ID,FILE_CONTENT) VALUES ('675c85b1-87d6-11dc-9269-298909d3a566',** STREAM DATA **).
at org.opencms.db.generic.CmsVfsDriver.createContent(CmsVfsDriver.java:176)
at org.opencms.db.generic.CmsVfsDriver.createResource(CmsVfsDriver.java:624)
at org.opencms.db.CmsDriverManager.createResource(CmsDriverManager.java:1743)
at org.opencms.db.CmsSecurityManager.importResource(CmsSecurityManager.java:2636)
... 10 more
Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1690450 > 1047552). You can change this value on the server by setting the max_allowed_packet' variable.
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2691)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1585)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1500)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1485)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at org.opencms.db.generic.CmsVfsDriver.createContent(CmsVfsDriver.java:174)
... 13 more
Exception org.opencms.db.CmsDbSqlException: Error creating resource "/system/modules/com.konakart/lib/axis.jar" on path "/system/modules/com.konakart/lib/axis.jar".
at org.opencms.db.CmsDbSqlException.createException(CmsDbSqlException.java:116)
at org.opencms.db.CmsDbContext.throwException(CmsDbContext.java:238)
at org.opencms.db.CmsDbContext.report(CmsDbContext.java:212)
at org.opencms.db.CmsSecurityManager.importResource(CmsSecurityManager.java:2638)
at org.opencms.file.types.A_CmsResourceType.importResource(A_CmsResourceType.java:495)
at org.opencms.file.CmsObject.importResource(CmsObject.java:2015)
at org.opencms.importexport.CmsImportVersion5.importResource(CmsImportVersion5.java:436)
at org.opencms.importexport.CmsImportVersion5.readResourcesFromManifest(CmsImportVersion5.java:624)
at org.opencms.importexport.CmsImportVersion5.importData(CmsImportVersion5.java:177)
at org.opencms.importexport.CmsImport.importData(CmsImport.java:124)
at org.opencms.module.CmsModuleImportExportHandler.importModule(CmsModuleImportExportHandler.java:604)
at org.opencms.module.CmsModuleImportExportHandler.importData(CmsModuleImportExportHandler.java:381)
at org.opencms.importexport.CmsImportExportManager.importData(CmsImportExportManager.java:680)
at org.opencms.workplace.threads.CmsDatabaseImportThread.run(CmsDatabaseImportThread.java:94)
Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the following query: com.mysql.jdbc.PreparedStatement@111c6e: INSERT INTO CMS_OFFLINE_CONTENTS (RESOURCE_ID,FILE_CONTENT) VALUES ('675c85b1-87d6-11dc-9269-298909d3a566',** STREAM DATA **).
at org.opencms.db.generic.CmsVfsDriver.createContent(CmsVfsDriver.java:176)
at org.opencms.db.generic.CmsVfsDriver.createResource(CmsVfsDriver.java:624)
at org.opencms.db.CmsDriverManager.createResource(CmsDriverManager.java:1743)
at org.opencms.db.CmsSecurityManager.importResource(CmsSecurityManager.java:2636)

... 10 more
Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1690450 > 1047552). You can change this value on the server by setting the max_allowed_packet' variable.
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2691)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1585)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1500)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1485)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
at org.opencms.db.generic.CmsVfsDriver.createContent(CmsVfsDriver.java:174)
... 13 more
Skipping /system/modules/com.konakart/lib/axis.jar
( 17 / 39 ) Importing /system/modules/com.konakart/lib/commons-discovery-0.2.jar ... o.k.
( 18 / 39 ) Importing /system/modules/com.konakart/lib/jaxrpc.jar ... o.k.
( 19 / 39 ) Importing /system/modules/com.konakart/lib/konakart-opencms.jar ... o.k.
( 20 / 39 ) Importing /system/modules/com.konakart/lib/saaj.jar ... o.k.
( 21 / 39 ) Importing /system/modules/com.konakart/lib/wsdl4j-1.5.1.jar ... o.k.
( 22 / 39 ) Importing /system/modules/com.konakart/resources/ ... o.k.
( 23 / 39 ) Importing /system/modules/com.konakart/resources/images/ ... o.k.
( 24 / 39 ) Importing /system/modules/com.konakart/resources/images/arrow_right.gif ... o.k.
( 25 / 39 ) Importing /system/modules/com.konakart/resources/images/header_account.gif ... o.k.
( 26 / 39 ) Importing /system/modules/com.konakart/resources/images/header_cart.gif ... o.k.
( 27 / 39 ) Importing /system/modules/com.konakart/resources/images/header_checkout.gif ... o.k.
( 28 / 39 ) Importing /system/modules/com.konakart/resources/images/logo.png ... o.k.
( 29 / 39 ) Importing /system/modules/com.konakart/resources/images/pixel_black.gif ... o.k.
( 30 / 39 ) Importing /system/modules/com.konakart/resources/images/pixel_trans.gif ... o.k.
( 31 / 39 ) Importing /system/modules/com.konakart/resources/images/table_background_default.gif ... o.k.
( 32 / 39 ) Importing /system/modules/com.konakart/resources/images/infobox/ ... o.k.
( 33 / 39 ) Importing /system/modules/com.konakart/resources/images/infobox/corner_left.gif ... o.k.
( 34 / 39 ) Importing /system/modules/com.konakart/resources/images/infobox/corner_right.gif ... o.k.
( 35 / 39 ) Importing /system/modules/com.konakart/resources/images/infobox/corner_right_left.gif ... o.k.
( 36 / 39 ) Importing /system/modules/com.konakart/resources/styles/ ... o.k.
( 37 / 39 ) Importing /system/modules/com.konakart/resources/styles/stylesheet.css ... o.k.
( 38 / 39 ) Importing /system/modules/com.konakart/templates/ ... o.k.
( 39 / 39 ) Importing /system/modules/com.konakart/templates/konakartdemo.jsp ... o.k.
Parsing links ...
( 1 / 8 ) Parsing links for "/konakart-integration/index.jsp"... o.k.
( 2 / 8 ) Parsing links for "/konakart-integration/index_content.html"... o.k.
( 3 / 8 ) Parsing links for "/system/modules/com.konakart/elements/BestSellersTile.jsp"... o.k.
( 4 / 8 ) Parsing links for "/system/modules/com.konakart/elements/Footer.jsp"... o.k.
( 5 / 8 ) Parsing links for "/system/modules/com.konakart/elements/Header.jsp"... o.k.
( 6 / 8 ) Parsing links for "/system/modules/com.konakart/elements/index.jsp"... o.k.
( 7 / 8 ) Parsing links for "/system/modules/com.konakart/elements/NewProductsBody.jsp"... o.k.
( 8 / 8 ) Parsing links for "/system/modules/com.konakart/templates/konakartdemo.jsp"... o.k.
... The parsing process is finished.
Publishing project ...
Publishing resources ...
Publishing folders ...
( 1 / 11 ) Publishing folder /konakart-integration/ ... o.k.
( 2 / 11 ) Publishing folder /system/ ... o.k.
( 3 / 11 ) Publishing folder /system/modules/com.konakart/ ... o.k.
( 4 / 11 ) Publishing folder /system/modules/com.konakart/documentation/ ... o.k.
( 5 / 11 ) Publishing folder /system/modules/com.konakart/elements/ ... o.k.
( 6 / 11 ) Publishing folder /system/modules/com.konakart/lib/ ... o.k.
( 7 / 11 ) Publishing folder /system/modules/com.konakart/resources/ ... o.k.
( 8 / 11 ) Publishing folder /system/modules/com.konakart/resources/images/ ... o.k.
( 9 / 11 ) Publishing folder /system/modules/com.konakart/resources/images/infobox/ ... o.k.
( 10 / 11 ) Publishing folder /system/modules/com.konakart/resources/styles/ ... o.k.
( 11 / 11 ) Publishing folder /system/modules/com.konakart/templates/ ... o.k.
... finished publishing folders
Publishing files ...
( 1 / 27 ) Publishing file /konakart-integration/index.jsp ... o.k.
( 2 / 27 ) Publishing file /konakart-integration/index_content.html ... o.k.
( 3 / 27 ) Publishing file /system/modules/com.konakart/documentation/KonaKart_OpenCms.pdf ... o.k.
( 4 / 27 ) Publishing file /system/modules/com.konakart/elements/BestSellersTile.jsp ... o.k.
( 5 / 27 ) Publishing file /system/modules/com.konakart/elements/Footer.jsp ... o.k.
( 6 / 27 ) Publishing file /system/modules/com.konakart/elements/Header.jsp ... o.k.
( 7 / 27 ) Publishing file /system/modules/com.konakart/elements/NewProductsBody.jsp ... o.k.
( 8 / 27 ) Publishing file /system/modules/com.konakart/elements/index.jsp ... o.k.
( 9 / 27 ) Publishing file /system/modules/com.konakart/lib/axis.jar ... Error publishing file "/system/modules/com.konakart/lib/axis.jar".

Exception org.opencms.file.CmsDataAccessException: Unable to read file contents with resource ID "675c85b1-87d6-11dc-9269-298909d3a566" (online=false).
at org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:980)
at org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.java:1393)
at org.opencms.db.CmsDriverManager.publishJob(CmsDriverManager.java:5254)
at org.opencms.publish.CmsPublishThread.run(CmsPublishThread.java:141)
Caused by: org.opencms.file.CmsVfsResourceNotFoundException: Unable to read file contents with resource ID "675c85b1-87d6-11dc-9269-298909d3a566" (online=false).
at org.opencms.db.generic.CmsVfsDriver.readContent(CmsVfsDriver.java:1441)
at org.opencms.db.generic.CmsProjectDriver.publishFileContent(CmsProjectDriver.java:1006)
at org.opencms.db.generic.CmsProjectDriver.publishNewFile(CmsProjectDriver.java:2895)
at org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:936)
... 3 more
Statistics: published files: 9, published folders: 11, deleted folders: 0, duration: 00:00:02
Exception org.opencms.file.CmsDataAccessException: Error publishing file "/system/modules/com.konakart/lib/axis.jar".
at org.opencms.file.CmsDataAccessException.createException(CmsDataAccessException.java:77)
at org.opencms.db.CmsDbContext.throwException(CmsDbContext.java:238)
at org.opencms.db.CmsDbContext.report(CmsDbContext.java:212)
at org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.java:1413)
at org.opencms.db.CmsDriverManager.publishJob(CmsDriverManager.java:5254)
at org.opencms.publish.CmsPublishThread.run(CmsPublishThread.java:141)
Caused by: org.opencms.file.CmsDataAccessException: Unable to read file contents with resource ID "675c85b1-87d6-11dc-9269-298909d3a566" (online=false).
at org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:980)
at org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.java:1393)
... 2 more
Caused by: org.opencms.file.CmsVfsResourceNotFoundException: Unable to read file contents with resource ID "675c85b1-87d6-11dc-9269-298909d3a566" (online=false).
at org.opencms.db.generic.CmsVfsDriver.readContent(CmsVfsDriver.java:1441)
at org.opencms.db.generic.CmsProjectDriver.publishFileContent(CmsProjectDriver.java:1006)
at org.opencms.db.generic.CmsProjectDriver.publishNewFile(CmsProjectDriver.java:2895)
at org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:936)

... 3 more
... the resources have been published
Writing export points ...
Writing export point /system/modules/com.konakart/lib/ ... o.k.
... finished writing the export points
Updating search index "Online project EN (VFS)"
( 1 ) Indexing file /sites/default/konakart-integration/index.jsp ... skipped
( 2 ) Indexing file /sites/default/konakart-integration/index_content.html ... o.k.
... finished updating search index "Online project EN (VFS)"
Updating search index "Online project DE (VFS)"
( 1 ) Indexing file /sites/default/konakart-integration/index.jsp ... skipped
( 2 ) Indexing file /sites/default/konakart-integration/index_content.html ... o.k.
... finished updating search index "Online project DE (VFS)"
... the project has been published
... the module has been imported


whats going on I need help :-[
also
I get error javax.servlet.jsp.JspException: Unable to compile class for JSP

An error occurred at line: 24 in the jsp file: /WEB-INF/jsp/offline/system/modules/com.konakart/elements/NewProductsBody.jsp
Generated servlet error:
The type javax.xml.rpc.ServiceException cannot be resolved. It is indirectly referenced from required .class files

Does this have to do with my WSDL?

heres my other page-no bueno??
http://localhost:8780/opencms/opencms/konakart-integration/index_content.html

http://localhost:8780/opencms/opencms/konakart-integration/index.jsp

pete


honusurf

I did read the docs-saw the thing about mysql-Seems like I need to change my setting to increase the max_allowed_packet' variable.

Do I do this through opencms server, or my mysql server?  I use phpmyadmin? Could not find the setting??


pete

We use the MySQL administrator as you can see from the screen shot.

honusurf

It was like the weirdest thing, the same exact second as I posted that last question-like I figured it out man-and someone even responded to my question at the same time-this forum rocks as hard as Corona and Limes-and if you dont like my style-were going to take it to the streets"-this is the magic forumn-just post a question and somehow you will find your answer-swearsys!