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:

helma.org (*nix)
helma.org (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 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 7:24:49 PM CEST

again strange tar-error

hi

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

link  


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

link  


... comment
 
robert, July 16, 2002 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 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 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 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 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 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 com.mckoi.tools.JDBCQueryTool \
<!--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!

link  

 
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 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 10:28:31 AM CEST

thx, hns!

that was quick & helpful.

link  

 
hns, July 31, 2002 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 5569 Days
last updated: 1/4/11 10:22 AM
status
Youre not logged in ... Login
menu
September 2016
SunMonTueWedThuFriSat
123
45678910
11121314151617
18192021222324
252627282930
July
recent
zfuture's house here is zfuture's
house
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 blogosphere.us isn't can't really
be rated as spam can it?
by kohlehydrat (7/23/03 8:08 PM)
More referrer spam www.webfrost.com
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