Hi experts,
Using the default Community Edition I'm trying my hand at performing an export using the ExportFromKKUsingEng.sh
facility but it seems to choke on some kind of security problem. I'm using MySQL, the database name is 'konakart'
and it seems to be accessing it ok until it tries to do a write of a session id:
br@br-laptop:~/konakart/import_export$ ./ExportFromKKUsingEng.sh 0 konakart true
======================================================================================================
Create a file containing product data from the KonaKart database using the KK Engine
======================================================================================================
Properties file found = /home/br/konakart/import_export/classes/kkImporter.properties
log4j:WARN No appenders could be found for logger (org.apache.commons.configuration.ConfigurationUtils).
log4j:WARN Please initialize the log4j system properly.
19-Feb 10:59:49 INFO (KKAdminBase.java:init:167) Finished Initialising Log4j
19-Feb 10:59:49 INFO (KKAdminBase.java:init:173) The configuration file being used is /home/br/konakart/import_export/classes/konakartadmin.properties
19-Feb 10:59:49 INFO (KKAdminBase.java:init:181) Initialising KKAdmin
19-Feb 10:59:49 INFO (KKAdminBase.java:initKonakart:582) KonaKart Admin V3.2.0.0 built 9:06PM 1-Feb-2009 GMT
19-Feb 10:59:49 INFO (KKAdminBase.java:init:186) Finished Initialising KonaKartAdmin
19-Feb 10:59:49 INFO (KKAdminBase.java:init:195) Initialising Torque
19-Feb 10:59:49 INFO (AdminMgrFactory.java:getConstructor:1282) Getting class by name for AdminCommunityStoreMgr
19-Feb 10:59:50 INFO (AdminMgrFactory.java:getConstructor:1282) Getting class by name for AdminSecurityMgr
19-Feb 10:59:50 INFO (AdminSecurityMgr.java:refreshConfigs:2185) Refresh configs for AdminSecurityMgr of storeId konakart
19-Feb 10:59:50 INFO (AdminMgrFactory.java:getConstructor:1282) Getting class by name for AdminConfigurationMgr
19-Feb 10:59:50 INFO (AdminMgrFactory.java:getConstructor:1282) Getting class by name for AdminMultiStoreMgr
19-Feb 10:59:50 INFO (AdminMgrFactory.java:instantiateAdminMultiStoreMgr:1025) Detected that the AdminMultiStoreMgr is not present
19-Feb 10:59:50 WARN (AdminMgrFactory.java:instantiateAdminMultiStoreMgr:1026) Admin Multi-Store functionality has not been installed
19-Feb 10:59:51 DEBUG (QueryDataSet.java:<init>:115) SELECT configuration.configuration_id, configuration.configuration_key, configuration.configuration_value FROM configuration WHERE configuration.configuration_key='ADMIN_LOGIN_INTEGRATION_CLASS'
19-Feb 10:59:51 DEBUG (QueryDataSet.java:<init>:115) SELECT customers.customers_password, customers.customers_type, customers.customers_id, customers.customers_enabled FROM customers WHERE customers.customers_email_address='admin@konakart.com'
19-Feb 10:59:51 ERROR (?:doExport:?) Exception Message = null<br><br>Exception Stack Trace = <br> at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:496)<br> at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:431)<br> at com.konakartadmin.bl.AdminSecurityMgr.insertSessionId(AdminSecurityMgr.java:332)<br> at com.konakartadmin.bl.AdminSecurityMgr.login(AdminSecurityMgr.java:274)<br> at com.konakartadmin.bl.KKAdmin.login(KKAdmin.java:757)<br> at com.konakart.importer.BaseController.setupEngine(Unknown Source)<br> at com.konakart.importer.BaseController.init(Unknown Source)<br> at com.konakart.importer.ExportController.init(Unknown Source)<br> at com.konakart.importer.ExportController.doExport(Unknown Source)<br> at com.konakart.importer.ExportRunner.main(Unknown Source)
Exception in thread "main" com.konakartadmin.app.KKAdminException: Exception Message = null<br><br>Exception Stack Trace = <br> at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:496)<br> at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:431)<br> at com.konakartadmin.bl.AdminSecurityMgr.insertSessionId(AdminSecurityMgr.java:332)<br> at com.konakartadmin.bl.AdminSecurityMgr.login(AdminSecurityMgr.java:274)<br> at com.konakartadmin.bl.KKAdmin.login(KKAdmin.java:757)<br> at com.konakart.importer.BaseController.setupEngine(Unknown Source)<br> at com.konakart.importer.BaseController.init(Unknown Source)<br> at com.konakart.importer.ExportController.init(Unknown Source)<br> at com.konakart.importer.ExportController.doExport(Unknown Source)<br> at com.konakart.importer.ExportRunner.main(Unknown Source)
at com.konakartadmin.bl.KKAdminBase.manageException(KKAdminBase.java:1363)
at com.konakartadmin.bl.KKAdmin.login(KKAdmin.java:769)
at com.konakart.importer.BaseController.setupEngine(Unknown Source)
at com.konakart.importer.BaseController.init(Unknown Source)
at com.konakart.importer.ExportController.init(Unknown Source)
at com.konakart.importer.ExportController.doExport(Unknown Source)
at com.konakart.importer.ExportRunner.main(Unknown Source)
The kkimporter.properties file wasn't touched while the following changes were made to the konakartadmin.properties file:
torque.applicationRoot = .
torque.database.default = konakart
torque.database.konakart.adapter = mysql
torque.dsfactory.konakart.connection.driver = com.mysql.jdbc.Driver
torque.dsfactory.konakart.connection.url = jdbc:mysql://localhost:3306/konakart?zeroDateTimeBehavior=convertToNull
torque.dsfactory.konakart.connection.user = root
torque.dsfactory.konakart.connection.password = password
Basically wherever it mentioned 'store1' in the properties file I replaced it with 'konakart' for my single store setup, is this correct?
Launching the export without the final two arguments "./ExportFromKKUsingEng.sh 0" causes the same result.
What am I doing wrong?
Thx,
Brian
Hi Brian,
The problem is that I think you've changed a few too many "store1"s in the properties file.
It should be like this:
torque.database.default = store1
torque.database.store1.adapter = mysql
torque.dsfactory.store1.connection.driver = com.mysql.jdbc.Driver
torque.dsfactory.store1.connection.url = jdbc:mysql://localhost:3306/konakart?zeroDateTimeBehavior=convertToNull
torque.dsfactory.store1.connection.user = root
torque.dsfactory.store1.connection.password = password
In fact... the only one you need to change is in the database connection URL.
You can copy a good one from webapps/konakartadmin/WEB-INF/classes assuming you used the wizard installer successfully.
For the command line, in the Commmunity Edition, you should use something like this:
./ExportFromKKUsingEng.sh 0 store1 false
(or you could change the script to remove the arguments completely).
--Kate