Current antville/antclick package out for testing

hns, July 16, 2002 at 6:49:57 PM CEST

Hi there, I updated the antville/antclick build environment and put out up-to-date packages:

Gotta run and cook dinner now, so I'll keep it short: Antclick is an integrated Helma/Antville package. It comes with an integrated web server and SQL database. It should run out of the box although you may have to modify the start script. All you need to run it is Java 1.3 or higher.

This version of Antclick comes with Mckoi as embedded database now, which should be able to scale to a few hundred megs of data (I said should, haven't tried yet). Basically, the only weak spot left now is the embedded web server. I'm currently investigating into what it would take to replace it with Jetty.

Please let me know what you find!

Update: Just to avoid a common misunderstanding, although Antcklick comes preconfigured with the Mckoi database, it is perfectly possible to reconfigure it to run it with other databases (just as it is possible to configure it to run in a servlet container like Tomcat instead of the built-in web server). All you have to do is update the db.properties file in the apps/antville directory and add the JDBC-driver for your database to the classpath. Currently, Antville supports MySQL and Oracle out of the box, but there's no reason why it shouldn't be possible to add support for other db products.

Update 2 (July 31): The Mckoi database that was packaged with this Antclick prerelease has a bug that causes trouble with large text items. If you do anything serious with it, please replace the lib/mckoidb.jar file in your installation with this patched version (right click and save-as):

mckoidb (application/octet-stream, 647 KB)

Make sure that you stop and restart Antclick if you update to the patched version!

comment

rist, July 16, 2002 at 7:24:49 PM CEST

again strange tar-error

first - antclick works nice and smoothly (mac os x 10.1.5) - i just got again an error-message while untaring (tar -xvf) the file - "tar: Invalid header, starting valid header search.tar: End of archive volume 1 reached" - antclick starts without any problems - so this error message is just a cosmetic issue (i hope the source of the problem is not my bad command line knowledge - if it is I promise to learn the tar-manpage by heart)

link

hns, July 17, 2002 at 10:25:56 AM CEST

no error message for me

Also on Mac OS X 10.1.5, I can untar the file without problems. I use "tar zxvf filename.tar.gz" (the z option does the gunzip). My version of tar is 1.13.19, maybe you have a different one?

[localhost:~] hannes% tar --version tar (GNU tar) 1.13.19 (....)

link

rist, July 17, 2002 at 11:22:14 AM CEST

probably a different version of tar

hi hannes

if i try "tar --version" - i just get an error message (tar: Failed open to read on /dev/nrst0 ) -so i checked the manpage again and it refers to BSD and not GNU i found gnutar installed on my machine as well and it works without any problemes - so the (cosmetic) problem is solved - i'm just wondering why we are using different versions of tar?

link

... comment

seewolf, July 16, 2002 at 8:50:34 PM CEST

Es läuft

Win2000 Pro local, great Gleich morgen in der Firma ausprobieren, gibt schon mehrere Ideen Vielen Dank

link

... comment

robert, July 16, 2002 at 11:22:28 PM CEST

yes!!

works right out of the box! didn't have any problems (winXP). you made my day, henso. i'll check it on my linux-box soon.

link

... comment

hr, July 17, 2002 at 11:18:46 AM CEST

cool, works great.

one question: is it possible to bring the data of an older antville setup with mysql to antclick with mckoi?

link

hns, July 17, 2002 at 12:45:43 PM CEST

MySQL -> Mckoi

First, it is still possible to run this version of Antville with MySQL. If you have MySQL configured, it should be very easy to change Antclick to access it (see the update to the main posting above).

The problem is that the database scheme changed considerably between the version you're running and the new release. You should be able to update the scheme by applying all the Antville-dbpaches that came out since the snapshot of Antville you're running. Be careful though and make a backup before you try.

link

robert, July 17, 2002 at 12:54:33 PM CEST

be aware

that all database-patches existing for antville are changing only the schema, not the skins/stories itself. that means that if you update the database and use antclick most of the customized skins won't work like they should do. i'm currently working on a script that should fix that, but i'll need some more time for testing.

link

... comment

Chronistin, July 30, 2002 at 11:42:32 PM CEST

I don't have a new computer yet, but...

...I just could not stand it any longer... so I made room on my harddisk, threw some fine utilities out of my memory and installed "antclick" instead. It worked flawlessly from the very first moment (except that console shows a Java I/O error when creating new weblogs, but as they are created anyway, i don't care).

Now I try to adapt it to my needs. Everything is running smoothly so far, but I just can't figure out how to access the integrated database. I need a new column - can I add it in this setup or do I have to use an external database? And while we're at it, would you recommend to use the integrated database for a real-life scenario, or should I switch it to MySQL anyway?

I know these questions are not strictly project-log related, but I couldn't think of a better place to ask them, sorry.

link

hns, July 31, 2002 at 9:12:30 AM CEST

Accessing Mckoi

You can access the Mckoi Antville db using the Mckoi JDBC Query Tool. From the Antclick directory, issue the following command:

java -cp lib/mckoidb.jar com.mckoi.tools.JDBCQueryTool 

-url "jdbc:mckoi:local://./db.conf" 

-u "admin" -p "entwil"

Be sure that you don't have Antclick running when doing this, since you risk corrupting the database if two processes are accessing it at the same time!

link

hns, July 31, 2002 at 9:24:18 AM CEST

Mckoi vs. MySQL

MySQL is an extremely mature product, while Mckoi is pretty young in comparison. In fact the current version is tagged 0.93 beta, although it is used in production environments by many.

If you want a trouble-free installation with proven components, use MySQL. If you stick with Mckoi, consider it beta software, don't store important data in it or make even more regular backups than you would with MySQL ;-)

For example, I'm using Antclick/Mckoi on frau.helma.at and have encountered a bug where stories with very long texts ended up with texts from other stories. I've spent the whole day yesterday trying to reproduce and then locate this bug. Once problems like these are cleared, Mckoi should be a good choice. Until then, if you want trouble-free operation, you should go with MySQL.

link

Chronistin, July 31, 2002 at 10:28:31 AM CEST

thx, hns!

that was quick & helpful.

link

hns, July 31, 2002 at 11:01:12 AM CEST

yo welcome

oder so ähnlich.

link

... comment

The Antville Server Fund has been a great success. Thanks to everybody who contributed!

online for 8330 Days
last updated: 1/4/11, 10:22 AM