hns, July 16, 2002 6:49:57 PM CEST
Current antville/antclick package out for testing
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!
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)
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
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
Win2000 Pro local, great
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.
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.
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.
...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.
You can access the Mckoi Antville db using the Mckoi JDBC Query Tool. From the Antclick directory, issue the following command:
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!
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.
that was quick & helpful.
oder so ähnlich.
The Antville Server Fund has been a great success. Thanks to everybody who contributed!
online for 5506 Days
last updated: 1/4/11 10:22 AM
Youre not logged in ... Login
... about antville
... translate antville!
... antville home
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 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)