Messages

[upgrade_2.2.0.0_to_2.2.0.1.sql]

Hi Shaheem,

You may have seen the new release posted today, version 2.2.0.1.

For this release and all future releases there will be a database upgrade script with the following format:  upgrade_old-version_to_new-version.sql  for all directly-supported databases (currently MySQL and PostgreSQL).

For example the script for the 2.2.0.1 release is:

upgrade_2.2.0.0_to_2.2.0.1.sql

You find these upgrade scripts under the installation home directory under ./database/<db>/ provided in each release.

This will upgrade the db from the previous version to the next without wiping all your precious data!

Regards,
John

Hello Adam,

I'm not excatly sure where you've got to.   Are you talking about the KonaKart demo store application or the KonaKart Admin Application?   

If you're running the Admin Application the default username is "KonaKart" and the default password is "prince".   Did you use the Windows installation wizard?  If so there's a page there for you to define your own username and password.

If you're using the KonaKart demo store application you have to register a new user using the application.

Does that help?
John

Hi,

Yes, we have noted that problem.  Sorry for the inconvenience caused.  We will make sure the application can handle missing data from all such tables in the next release.

Thanks for reporting it, please don't hesitate to report anything else you see.

Regards,
John

Hi Shaheem,

Thanks for the encouraging feedback.

Yes, we have plans to add Reporting but in order that we could get a useful administration facility out in the shortest possible time, some things were missed off!   (As you know, the data is of course easily accessible from any reporting tool of your choice in the mean time).

Yes, we fully appreciate the data migration issues and will make sure we provide the necessary migration utilities as we move forward.

Any other suggestions are always gratefully received.

Thanks,

John

Hello Wynand,

There are various techniques possible here - including renaming the konakart directory under webapps - but perhaps the simplest of all is to add these lines (in red) to your conf/server.xml file just before the closing </Host>

        <!--
        <Valve className="org.apache.catalina.valves.FastCommonAccessLogValve"
                 directory="logs"  prefix="localhost_access_log." suffix=".txt"
                 pattern="common" resolveHosts="false"/>
        -->

   <Context path="/mystore"
       docBase="C:\Program Files\KonaKart\webapps\konakart">
   </Context>
      </Host>

This would allow you to enter http://yourhost:8780/mystore to run konakart.

Regards,
John

Hi sfsylz (that's hard to pronounce  ),

Thanks very much for your kind offer but we're very close now and things are looking good for a release in 2/3 weeks.  Hopefully this will be a very solid first release but any feedback that you have at that time would be most welcome.

Regards,
John

Hi Gery,

The KonaKart Admin App is coming along nicely but it will be two or three weeks from now before we release it.

It's undergoing some beta trials at the moment and looking very promising.   

I hope the delay won't cause you too many problems.

Regards,
John

Your site is coming along nicely - good luck with it!
John

Hi Shaheem,

Here's one, but I've never used it http://oscommerce-manager.magneticone.qarchive.org/ so I can't say whether it's good or bad.

It's a shame you can't solve the email problem.  You could always try using a local smtp server - that doesn't require authentication.

The sendmail_from rejection could be due to that SMTP server guarding against spammers.  Can you try setting that to something else that it will accept (eg. the sent-from email address you would usually use when sending through that SMTP server).

You won't have to wait too much longer for the KonaKart Admin App which is only a few weeks away.
John

Hi Oleg,

If I understand you correctly, using MySQL tools you were able to log in to your oscommerce database using user root, with no password?   Is that correct?   Did you see all the oscommerce tables?

This is tricky to diagnose from here. The error clearly reports that it cannot connect to the database - so this should be a big clue.   If you can log in using MySQL tools then you should be able to log in using exactly the same parameters in the KonaKart properties file.

John

Oleg,

Your settings look good.   Have you verified that you can access your database (that you've called "oscommerce") using MySQL tools using that username and password?

John

Hi Shaheem,

It sounds like you are well on your way!

I'm no expert on osCommerce email setup but here are some things to check:

php.ini  - check that this is configured as you require, look under [email function]:

[mail function]
SMTP = yourSMTPserver
smtp_port = 25

Check the email configuration parameters in the Admin App itself.
- Check Configuration Options/Email Options
- Check Configuration Options/My Store

If you can't get it to work after verifying these there are probably many other people who have had the same problems as you... so I suggest that you check the osCommerce forum at http://forums.oscommerce.com/index.php?showforum=1

Good luck,
John

Hi,

These are set in the database in the configuration table.

There's an sql script that you'll find under the database directory in the kit that shows you all the inserts.   You will have to set the values that work for you of course!

Here's an extract of the email-related configuration values:


INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES                ('SMTP Server',          'SMTP_SERVER',        'ENTER_YOUR_SMTP_SERVER_HERE', 'The SMTP server',                                         '21', '1', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, set_function) VALUES  ('SMTP Secure',          'SMTP_SECURE',        'false',                       'Whether or no the SMTP server needs user authentication', '21', '2', now(), 'tep_cfg_select_option(array(\'true\', \'false\'), ');
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES                ('SMTP User',            'SMTP_USER',          'user@yourdomain.com',         'The SMTP user',                                           '21', '2', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES                ('SMTP Password',        'SMTP_PASSWORD',       '',                           'The SMTP password',                                       '21', '4', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES                ('Email Reply To',       'EMAIL_REPLY_TO',      'user@yourdomain.com',        'The Reply To Address',                                    '21', '5', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, set_function) VALUES  ('Debug Email Sessions', 'DEBUG_EMAIL_SESSIONS','true',                       'Debug email sessions',                                    '21', '6', now(), 'tep_cfg_select_option(array(\'true\', \'false\'), ');

Good luck,
john

You're very welcome  .  Please let us know if you run into any other problems.
John

[all]

Hi,

You shouldn't change all the oscommerce references.   Only change the values for these parameters:

torque.database.oscommerce.adapter              = mysql
torque.dsfactory.oscommerce.connection.driver   = com.mysql.jdbc.Driver
torque.dsfactory.oscommerce.connection.url      = jdbc:mysql://localhost:3306/dbname?zeroDateTimeBehavior=convertToNull
torque.dsfactory.oscommerce.connection.user     = username
torque.dsfactory.oscommerce.connection.password = password

It is most likely you will only need to change the last three shown above.

Good luck,
John