KonaKart on MAC OSX & .war files

[nickgk]

Since KonaKart is a J2EE application, why is it not possible to deploy it through the use of a .war file?  This would make installation much easier on OSX (or another OS) that already has a J2EE container setup and running. I realize that the database would have to be set up in a separate step.  I need to separate KonaKart from Tomcat so that I can install it on an already established production tomcat installation.  Any ideas about .war files and what I am trying to accomplish?

Many Thanks!

[julie]

Since KonaKart is a J2EE application, why is it not possible to deploy it through the use of a .war file?

http://www.konakart.com/customizationfaq.php#How_do_I_build_the_customisable_java .

Run the make_wars ant target.

C:\Program Files\Kona2220\custom>ant make_wars
Buildfile: build.xml

clean_wars:
     [echo] Cleanup WARs...

make_wars:
    [mkdir] Created dir: C:\Program Files\Kona2220\custom\war
     [echo] Create konakart.war
      [war] Building war: C:\Program Files\Kona2220\custom\war\konakart.war
     [echo] Create konakartadmin.war
      [war] Building war: C:\Program Files\Kona2220\custom\war\konakartadmin.war
     [echo] Create birt-viewer.war
      [war] Building war: C:\Program Files\Kona2220\custom\war\birt-viewer.war

BUILD SUCCESSFUL
Total time: 40 seconds

[BoJo]

I am also trying to MANUALLY install KonaKart on Mac OS X. The provided installer does not run on Mac OS X so I need to do a manual install. Also, I would like to use an servlet container. After downloading the source .zip file, I have;

1) build the .war files and deployed them, and
2) created a database in MySQL

The problem is that I need to run the "standard database install script" refered to here (http://www.konakart.com/downloads.php):
-----------------------------------------------
At installation time you can choose to get the installer to load the database initialisation script for you ...
-----------------------------------------------
I see a lot of .sql files, but none appropriate for initializing the new database (see list of .sql files below).

(Q) Where is the script I need to run to initialize the database?

Any help is greatly appreciated,

Bob

:~/Documents/workspace/konakart bob$ find . -name \*.sql -print
./database/DB2/konakart_demo.sql
./database/DB2/upgrade_2.2.0.4_to_2.2.0.5.sql
./database/DB2/upgrade_2.2.0.5_to_2.2.0.6.sql
./database/DB2/upgrade_2.2.0.6_to_2.2.0.7.sql
./database/DB2/upgrade_2.2.0.7_to_2.2.0.8.sql
./database/DB2/upgrade_2.2.0.8_to_2.2.1.0.sql
./database/DB2/upgrade_2.2.1.0_to_2.2.2.0.sql
./database/MSSqlServer/konakart_demo.sql
./database/MSSqlServer/upgrade_2.2.0.4_to_2.2.0.5.sql
./database/MSSqlServer/upgrade_2.2.0.5_to_2.2.0.6.sql
./database/MSSqlServer/upgrade_2.2.0.6_to_2.2.0.7.sql
./database/MSSqlServer/upgrade_2.2.0.7_to_2.2.0.8.sql
./database/MSSqlServer/upgrade_2.2.0.8_to_2.2.1.0.sql
./database/MSSqlServer/upgrade_2.2.1.0_to_2.2.2.0.sql
./database/MySQL/konakart_demo.sql
./database/MySQL/konakart_supplementary_demo.sql
./database/MySQL/Paolo_Mail.sql
./database/MySQL/upgrade_2.2.0.0_to_2.2.0.1.sql
./database/MySQL/upgrade_2.2.0.1_to_2.2.0.2.sql
./database/MySQL/upgrade_2.2.0.2_to_2.2.0.3.sql
./database/MySQL/upgrade_2.2.0.3_to_2.2.0.4.sql
./database/MySQL/upgrade_2.2.0.4_to_2.2.0.5.sql
./database/MySQL/upgrade_2.2.0.5_to_2.2.0.6.sql
./database/MySQL/upgrade_2.2.0.6_to_2.2.0.7.sql
./database/MySQL/upgrade_2.2.0.7_to_2.2.0.8.sql
./database/MySQL/upgrade_2.2.0.8_to_2.2.1.0.sql
./database/MySQL/upgrade_2.2.1.0_to_2.2.2.0.sql
./database/Oracle/konakart_demo.sql
./database/Oracle/upgrade_2.2.0.3_to_2.2.0.4.sql
./database/Oracle/upgrade_2.2.0.4_to_2.2.0.5.sql
./database/Oracle/upgrade_2.2.0.5_to_2.2.0.6.sql
./database/Oracle/upgrade_2.2.0.6_to_2.2.0.7.sql
./database/Oracle/upgrade_2.2.0.7_to_2.2.0.8.sql
./database/Oracle/upgrade_2.2.0.8_to_2.2.1.0.sql
./database/Oracle/upgrade_2.2.1.0_to_2.2.2.0.sql
./database/PostgreSQL/konakart_demo.sql
./database/PostgreSQL/upgrade_2.2.0.0_to_2.2.0.1.sql
./database/PostgreSQL/upgrade_2.2.0.1_to_2.2.0.2.sql
./database/PostgreSQL/upgrade_2.2.0.2_to_2.2.0.3.sql
./database/PostgreSQL/upgrade_2.2.0.3_to_2.2.0.4.sql
./database/PostgreSQL/upgrade_2.2.0.4_to_2.2.0.5.sql
./database/PostgreSQL/upgrade_2.2.0.5_to_2.2.0.6.sql
./database/PostgreSQL/upgrade_2.2.0.6_to_2.2.0.7.sql
./database/PostgreSQL/upgrade_2.2.0.7_to_2.2.0.8.sql
./database/PostgreSQL/upgrade_2.2.0.8_to_2.2.1.0.sql
./database/PostgreSQL/upgrade_2.2.1.0_to_2.2.2.0.sql
:~/Documents/workspace/konakart bob$

[ming]

Hi,

To create the database run konakart_demo.sql for the database you have chosen.

In your case that will be database/MySQL/konakart_demo.sql


FYI:

The konakart_supplementary_demo.sql files are for upgrading from an existing oscommerce database

The upgrade_{from-version}_{to-version}.sql scripts are for updating the database between versions.

Regards,
Ming

[BoJo]

I imported the script into MySQL using:

mysql -u root -p konakart < /Users/bob/Documents/workspace/konakart/database/MySQL/konakart_demo.sql

and all went well.

KonaKart is now up and running on Mac OS X.

Thank you very much!,

Bob

[ming]

Hi Bob,

Good news;  Thanks for confirming that.

Ming

[hyou]

downloaded KonaKart-2.2.6.0-Linux-Install.zip and unized using stuffit.

ran ./KonaKart-2.2.6.0-Linux-Install

I get the error -bash: ./KonaKart-2.2.6.0-Linux-Install: cannot execute binary file.

Have already installed Java and MySQL.

Thanks for your help.

[heidi]

Are the permissions OK on the file??  (chmod +x)

[hyou]

Yes I did chmod +x on it already.  Any idea what could be wrong?

[heidi]

Are you on Mac OS X?

If you are, you'll have to follow the instructions for manual installation - the installer won't work on Mac OS X.

[heidi]

You can read all about the manual installation in the User Guide: http://www.konakart.com/docs/manualInstallation.html