Erste schritte.. fürs archiv. zB.
http://einblog.de:8080/antville/axelk/

hier selbige information:
http://help.antville.org/stories/926004/#928484


a) tar xvfz helma-1.4.1.tar.gz
b) cd helma
c) cd apps
d) tar xvfz antville-1.1.tar.gz
e) mv antville-1.1 antville
f) cd antville/code
g) edit db.properties to be able to connect to db
h) edit helma/apps.properties like former config and add .. :
antville.appdir = apps/antville/code
h) cd helma/static; cp -r ../apps/antville/static/* .
i) it is helpful to start mysql with enabled logging to see wether
wether the helma/antville/mysql communication works and what
queries lead to errors.
/usr/sbin/mysqld
--basedir=/usr
--datadir=/var/lib/mysql
--user=mysql
--pid-file=/var/run/mysqld/mysqld.pid
--skip-locking --port=3306
--socket=/var/run/mysqld/mysqld.sock
--log=/var/tmp/mysqllog.deleteme
j) patching mysql:
mysql -v < antville_dbpatch20030303.sql
mysql -v < antville_dbpatch20030728.sql
mysql -v < antville_dbpatch20031031.sql
mysql -v < antville_dbpatch20030728.sql
mysql -v < antville_dbpatch20031031.sql
mysql -v < antville_dbpatch-20031007-skinsets.sql
mysql -v < antville_dbpatch-20031123-layouts.sql
mysql -v < antville_dbpatch-20031128-layouts2.sql
mysql -v < antville_dbpatch-20031229.sql
mysql -v < antville_dbpatch-20040214.sql
mysql -v < antville_dbpatch-20040321.sql
mysql -v < antville_dbpatch-20040428.sql
k) edit helma/apps/antville/Root/actions.js
include convertSites.hac into it
l) call http://your.antville/convertSites
(look in the mysql logfile and see if it works)
m) remove convertSites function form Root/actions.js, not needed anymore
n) mysql -v < antville_dbpatch20030729.sql (droping not needed columns)
o) edit 11pre1_to_pre2.js from update/1.1pre1_to_pre2
line 24: layout -> Layout
line 39: SKIN_F_SITE -> SKIN_F_LAYOUT
p) cp 11pre1_to_pre2.js helma/apps/antville/Root/
p) stop helma
q) cd helma (where launcher.jar is located)
java -cp ./launcher.jar helma.main.launcher.Commandline antville.updateTo11pre2Part1
java -cp ./launcher.jar helma.main.launcher.Commandline antville.updateTo11pre2Part2
(look in the mysql logfile and see if it works)
r) start helma: hop.sh
r) convert the former image directories to the new layout.
See update/1.1pre1_to_pre2/README.txt for that.
s) eventually edit helma/apps/antville/code/app.properties to adjust
the static path.
t) http://thread.gmane.org/gmane.comp.java.helma.antville.devel/87
recent versions of MySQL connector treat tinyint(1) columns as bit/boolean.
https://github.com/antville/helma/bugs/show_bug.cgi?id=383#c2
use antville;
alter table AV_TEXT modify TEXT_ISONLINE tinyint(4);
alter table AV_TEXT modify TEXT_EDITABLEBY tinyint(4);


// for converting the images / files directory
#!/bin/sh


# start in the 'antville' directory
# then move the site directorys in images one up

cd images

for blog in *
do
if [ -d $blog ]; then
echo "creating directories for $blog"
mkdir $blog/images
mkdir $blog/files

for pic in $blog/*
do
if [ -f "$pic" ]; then
echo " mv $pic $blog/images/"
mv "$pic" $blog/images/
fi
done

if [ -d ../files/$blog ]; then
for file in ../files/$blog/*
do
echo " mv $file $blog/files"
mv "$file" $blog/files
done
fi
else
echo "xxxxxx $blog is no directory"
fi
done

-------------------------------------------
#!/usr/bin/perl
# blogger.de/stylesheet -> einblog.de/main.css ( [Macro error in site.url: Macro site.url not allowed in sandbox] main.css

use DBI;
# use strict;

$dbh = DBI->connect ('DBI:mysql:antville:127.0.0.1:3306', 'root', '',
{ RaiseError => 1, AutoCommit => 1 });


$sth = $dbh->prepare( "select skin_id,skin_source from AV_SKIN");
# $sth = $dbh->prepare( "select skin_id,skin_f_layout from AV_SKIN where skin_f_layout=2040");
$sth->execute;


while (($id, $source) = $sth->fetchrow_array)
{
# print "-------------\n";
# print "skin_id: $id\n";
# print "-------------\n";

if($source =~ s/site\.history.*?show/site.history limit/isg){print $id.": ".$source."\n";}

if($source =~ s/this\.author/story\.creator/isg){print $id.": ".$source."\n";}
if($source =~ s/story\.author/story\.creator/isg){print $id.": ".$source."\n";}
if($source =~ s/story\.title/story\.content part=\"title\"/isg){print $id.": ".$source."\n";}
if($source =~ s/storymgr\.storylist/storylist/isg){print $id.": ".$source."\n";}

if($source =~ s/this\.storylist/response\.storylist/isg){print $id.": ".$source."\n";}
if($source =~ s/site\.storylist/response\.storylist/isg){print $id.": ".$source."\n";}
if($source =~ s/topic\.storylist/response\.storylist/isg){print $id.": ".$source."\n";}
if($source =~ s/site\.topiclist/topiclist/isg){print $id.": ".$source."\n";}

# WRONG: skins
# RIGHT: layouts
if($source =~ s/( [Macro error in .*site.link.*?)skins(.*?: Macro .*site.link.*?)skins(.*? not allowed in sandbox] )/\1layouts\2/isg){print $id.": ".$source."\n";}

if($source =~ s/day\.storylist/response\.storylist/isg){print $id.": ".$source."\n";}
if($source =~ s/root\.systitle/root\.title/isg){print $id.": ".$source."\n";}

if($source =~ s/( [Macro error in .*comment.content.*?)width(.*?: Macro .*comment.content.*?)width(.*? not allowed in sandbox] )/\1cols\2/isg){print $id.": ".$source."\n";}
if($source =~ s/( [Macro error in .*comment.content.*?)height(.*?: Macro .*comment.content.*?)height(.*? not allowed in sandbox] )/\1rows\2/isg ){print $id.": ".$source."\n";}

if($source =~ s/( [Macro error in .*)this.text(.*?: Macro .*)this.text(.*? not allowed in sandbox] )/\1story.content part="text"\2/isg ){print $id.": ".$source."\n";}

if($source =~ s/href=\"http:\/\/ [Macro error in site.alias: Macro site.alias not allowed in sandbox] .blogger.de\/stylesheet\"/href=\" [Macro error in site.url: Macro site.url not allowed in sandbox] main.css\"/isg){print $id.": ".$source."\n";}
if($source =~ s/ [Macro error in site.url: Macro site.url not allowed in sandbox] stylesheet/ [Macro error in site.url: Macro site.url not allowed in sandbox] main.css/isg ){print $id.": ".$source."\n";}
if($source =~ s/ [Macro error in site.url: Macro site.url not allowed in sandbox] javascript\">/ [Macro error in site.url: Macro site.url not allowed in sandbox] main.js\">/isg ){print $id.": ".$source."\n";}
#

auja, sie sind fleissig.

*neugierdeerwecktsei*
edit:
ah, update für blogger...