KonaKart Community Forum

Installation / Configuration => Liferay, Magnolia, Hippo, dotCMS, OpenCms Integration => Topic started by: honusurf on September 02, 2008, 09:05:11 am

Title: Open Cms Installation Help
Post by: honusurf on September 02, 2008, 09:05:11 am
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_content.html)

http://localhost:8780/opencms/opencms/konakart-integration/index.jsp (http://localhost:8780/opencms/opencms/konakart-integration/index.jsp)
Title: Re: Open Cms Installation Help
Post by: pete on September 02, 2008, 09:11:49 am
Looks like you haven't read the documentation http://www.konakart.com/documents/KonaKart_OpenCms.pdf .
Title: Re: Open Cms Installation Help
Post by: honusurf on September 02, 2008, 09:15:22 am
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??

Title: Re: Open Cms Installation Help
Post by: pete on September 02, 2008, 09:20:24 am
We use the MySQL administrator as you can see from the screen shot.
Title: Re: Open Cms Installation Help
Post by: honusurf on September 03, 2008, 09:03:49 am
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!