Export failure

[brianr]

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

[kate]

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