Antville Project

Current antville/antclick package out for testing

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

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 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!


rist, July 16, 2002 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)


hns, July 17, 2002 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


rist, July 17, 2002 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 <No such file or directory>) -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?


... comment
seewolf, July 16, 2002 8:50:34 PM CEST

Es läuft

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


... comment
robert, July 16, 2002 11:22:28 PM CEST


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.


... comment
hr, July 17, 2002 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?


hns, July 17, 2002 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.


robert, July 17, 2002 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.


... comment
Chronistin, July 30, 2002 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.


hns, July 31, 2002 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:

<pre>java -cp lib/mckoidb.jar \
<!--av-code--> -url "jdbc:mckoi:local://./db.conf" \
<!--av-code--> -u "admin" -p "entwil"</pre>

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!


hns, July 31, 2002 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 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.


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

thx, hns!

that was quick & helpful.


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

yo welcome

oder so ähnlich.


... comment

The Antville Server Fund has been a great success. Thanks to everybody who contributed!
online for 5720 Days
last updated: 1/4/11 10:22 AM
Youre not logged in ... Login
February 2017
zfuture's house here is zfuture's
by zfuture (7/31/03 2:59 AM)
i understand your concerns however,
i hardly can think of a solution. certainly, if the...
by tobi (7/29/03 9:47 AM)
Found several more similar sites
listed This is getting to be quite a concern to...
by cobalt123 (7/27/03 7:56 PM)
Second Post Alert on Referrer
bug livecatz I put this into "help" and now here:...
by cobalt123 (7/26/03 7:14 PM)
well it's not easy to
find from here, anyway. think we should include a link,...
by tobi (7/24/03 11:25 AM)
So finally I found
the helma Bugzilla - stupid me.
by mdornseif (7/24/03 10:28 AM)
clock not that it's particularly
earthshattering but the antclock is running slow by about 15...
by kohlehydrat (7/23/03 8:25 PM)
but isn't can't really
be rated as spam can it?
by kohlehydrat (7/23/03 8:08 PM)
More referrer spam
by Irene (7/23/03 7:55 PM)
How to log skin names
I accessed to console?? Hi, I would like to know...
by winson (7/23/03 4:12 PM)

Click here to get an XML version of this weblog.

Made with Antville
powered by
Helma Object Publisher