KonaKart Integration

KonaKart is a Java based eCommerce Shopping Cart Software.

KonaKart supports various databases, but the following step-by-step instruction is based on PostgreSQL (and MySQL)

Install PostgreSQL on a Linux server

• uname -a
• sudo bash
• aptitude search postgres
• aptitude install postgresql-8.2
• ls /var/lib/postgresql/8.2/
• /etc/init.d/postgresql-8.2 stop
• /etc/init.d/postgresql-8.2 start
• su - postgres
• psql -U postgres
• List/show all databases contained by this instance: select * from pg_database;
• select * from pg_tables;
• \q

Install PostgreSQL on Mac OS X (Snow Leopard)

• http://www.postgresql.org/download/macosx
• sudo bash
• su - postgres
• In the case of 9.0 one has to init the DB after installing, e.g. /Library/PostgreSQL/9.0/bin/initdb -D /Library/PostgreSQL/9.0/data
• /Library/PostgreSQL/8.4/bin/pg_ctl -D /Library/PostgreSQL/8.4/data stop
• /Library/PostgreSQL/8.4/bin/pg_ctl -D /Library/PostgreSQL/8.4/data start

Install MySQL on Mac OS X (Snow Leopard)

• http://dev.mysql.com/downloads/mysql/
  • Download Community Server DMG Archive: mysql-5.1.47-osx10.6-x86_64.dmg
• Open DMG
  • Double-click mysql-5.1.47-osx10.6-x86_64.pkg
  • Will be installed to /usr/local/...
  • Double-click MySQLStartupItem.pkg
  • Will be installed to /Library/StartupItems/...
• sudo /Library/StartupItems/MySQLCOM/MySQLCOM start
• sudo /Library/StartupItems/MySQLCOM/MySQLCOM stop
• In order to disable automatic startup during system boot: vi /etc/hostconfig (set MYSQLCOM=-YES- to NO)
• Test mysql: /usr/local/mysql/bin/mysqlshow -uroot -p
  
  • (also see http://dev.mysql.com/doc/refman/5.0/en/unix-post-installation.html)
  • OR: /usr/local/mysql/bin/mysql -uroot -p
    • show databases;
    • quit
• Display version: /usr/local/mysql/bin/mysqladmin version
• Import MySQL dump:
  • /usr/local/mysql/bin/mysql -uroot -p < /Users/michaelwechner/dump.sql
  • The initial root account passwords are empty, hence just hit enter when being asked for the password
• Assuming that the dump created a database called 'my-database', which contains a table 'my-table':
  • /usr/local/mysql/bin/mysql -uroot -p my-database
  • show tables;
  • select * from my-table;
  • quit
• ...

Install KonaKart

• Also see the KonaKart manual installation FAQ (Previous: KonaKart manual installation FAQ
  )

• Download KonaKart, e.g. the ZIP version of the community edition (e.g. KonaKart-4.2.0.1.zip)

• Unpack by running 'unzip KonaKart-4.2.0.1.zip' which should create a directory called 'konakart'
• The next steps are described below
  • Import sample data into the database
  • Configure the database connection
• ...

Import KonaKart sample data into PostgreSQL

• Create a KonaKart database within PostgreSQL:
  • sudo bash
  • /etc/init.d/postgresql-8.2 start
  • su - postgres
  • dropdb -U postgres konakart
  • createdb -U postgres --encoding unicode konakart
• Import the sample data (e.g. a dump):
  • Depending on what web-server port you want to run KonaKart, you might have to change the port within the KonaKart sample data:
    • grep 8780 konakart/database/PostgreSQL/konakart_demo.sql
    • Replace the port number 8780 for example by 8080: vi: 1,$s/8780/8080/g
    • grep localhost:8780 konakart/database/PostgreSQL/konakart_demo.sql
    • Replace localhost by the actual server host name
  • Import the data: psql -U postgres -d konakart -f konakart/database/PostgreSQL/konakart_demo.sql
  • Test the data:
    • psql -U postgres -d konakart
    • select * from products;
    • \q
  • ...
• ...

Configure the database connection within KonaKart and PostgreSQL

• cd konakart
• webapps/konakart/WEB-INF/classes/konakart.properties
  • torque.database.store1.adapter              = postgresql
  • torque.dsfactory.store1.connection.driver   = org.postgresql.Driver
  • torque.dsfactory.store1.connection.url      = jdbc:postgresql://localhost:5432/konakart
  • torque.dsfactory.store1.connection.user     = postgres
  • torque.dsfactory.store1.connection.password =
• webapps/konakartadmin/WEB-INF/classes/konakartadmin.properties
• Make sure that postgreSQL is listening
  • vi /etc/postgresql/8.2/main/postgresql.conf
  • listen_addresses = 'localhost,127.0.0.1'
  • netstat -nt -l | grep 5432
• Make sure that you can connect without password from localhost:
  • vi /etc/postgresql/8.2/main/pg_hba.conf
  • host    all         all         127.0.0.1/32          trust
  • host    all         all         ::1/128               trust

Running KonaKart

• Either run the Tomcat which is part of the distribution
  • cd konkart
  • OPTIONAL: To be on the safe reconfigure the port 8005 within conf/server.xml by for example 8705
  • OPTIONAL: Enable SOAP: webapps/konakart/WEB-INF/server-config.wsdd (<parameter name="allowedMethods" value="*"/>)
  • chmod -R 775 bin
  • ./bin/startup.sh
  • http://127.0.0.1:8780/konakart/
  • SOAP: http://127.0.0.1:8780/konakart/services/KKWebServiceEng
• Or build war files
  • cd konakart/custom
  • ant make_wars
  • cp war/* MY_TOMCAT/webapps/.
  • OPTIONAL: Make sure that database connection is configured correctly (as described above)
• Frontend: http://127.0.0.1:8080/konakart/
• Backend: http://127.0.0.1:8080/konakartadmin/
  
  • Login Credentials: http://www.konakart.com/installationfaq.php#Default_Admin_App_Credentials
  • U: admin@konakart.com, P: princess

Alternative: Use the silent installer on Linux (WARNING: Does not work on Mac OS X)

• Download the Linux installer: http://www.konakart.com/downloads/community_edition
• ./konakart-linux-install -S -DInstallationDir /home/wyona/konakart -DDatabaseType postgresql -DDatabaseUrl jdbc:postgresql://localhost:5432/konakart -DDatabaseDriver org.postgresql.Driver -DDatabaseUsername postgres
• Startup: It seems that the silent installer starts Tomcat automatically on port 8780
  • netstat -nt -l | grep
  • http://195.226.6.73:8780
  • Otherwise use /home/wyona/konakart/bin/startup.sh
• IMPORTANT: Make sure that your data within the database is also using the port 8780

Installing the Enterprise Edition (manually)

• Also see http://www.konakart.com/docs/manualInstallation_EE.html
• Assume we have installed the community edition at /home/foo/konakart
• ./bin/shutdown.sh
• Unzip konkart enterprise package (e.g. KonaKart-Enterprise-4.2.0.1.zip) within some temporary directory, e.g. /home/foo/tmp/konakart
• Copy (overwrite) all files and directories from the enterrpise to the community directory, e.g. cp -r /home/foo/tmp/konakart/* /home/foo/konakart/.
• ./bin/startup.sh
• Try using a feature which is only supported by the enterprise edition, e.g. switching the language within konakartadmin.

Help

• http://www.konakart.com/forum/index.php

Misc

• Backup and restore data: http://www.postgresql.org/docs/8.1/static/backup.html
  • sudo bash
  • su - postgres
  • pg_dump konakart > konakart_demo.sql.DUMP_2010.05.31T09.09
  • Or instead using sudo: pg_dump -U postgres konakart > konakart_demo.sql.DUMP_2010.05.31T09.09