hoffentlich gibts keinen komplikationen ..x

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

da bearbeite ich ein bild mit fotoschop auf dem mac und speichere das ergebnis als .jpg ab, dann sind die farben viel blasser als beim original. und das ist nur auf dem mac so ?! hmm .. das verstehe ich nicht.

finder -> apfel-k -> http://mediacenter.gmx.net
mit gmx account einloggen.. fertig ist das aus dem internet gemountete filesystem. 1gigabyte platz und kostet nüscht.

Leider scheint der mac keine verschlüsselte verbindung (https) herstellen zu können..

Web developer extension für firefox/mozilla.. (via typ.o). Sehr hilfreich für html/css dilletanten wie mich. Änderungen am stylesheet zB. werden sofort dargestellt.

-Queue ID- --Size-- ----Arrival Time---- -Sender/Recipient-------
A4D0353602      327 Wed Jul 21 11:33:25  axelk@xxxxx.de
      (lost connection with mx-ha01.web.de[217.72.192.149] while sending HELO)
                                         irgendjemand@web.de

-- 0 Kbytes in 1 Request.

Einfach irgendwelche ip nummern ohne grund auszusperren ist scheiße.