.. und richtig klasse gespielt haben die heute. vor allem in der ersten hälfte ..

Schön wie einsam es nun an der elbe ist. auch der herbst hat seine vorteile.. die letzten urlaubstage lassen mich schon wieder mit sorge an die kommende arbeitszeit denken.

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";}
#