wget -O /usr/share/keyrings/riot-im-archive-keyring.gpg https://packages.riot.im/debian/riot-im-archive-keyring.gpg
echo "deb [signed-by=/usr/share/keyrings/riot-im-archive-keyring.gpg] https://packages.riot.im/debian/ default main" | sudo tee /etc/apt/sources.list.d/riot-im.list

apt-get update
apt-get install element-desktop


Voilà mes slides de mon exposé court de SOTM-FR à Montpellier 2019.

Remplacez l’envergure par les dimensions et le mesure par l’échelle.

Git Server einrichten

gitolite installieren:

apt-get install gitolite3


gitolite-key bereistellen:

/home/gitolite/gitolite.pub


setup

gitolite@localhost> gitolite setup -pk gitolite.pub


.ssh/config

Host gitserver
User gitolite
Hostname xyz
Port 22
IdentityFile ~/.ssh/gitkey


gitolite-admin Repository initial auschecken


git clone gitserver:gitolite-admin


Git Repository auf dem Server einrichten

Zuerst das neue Repository in conf/gitolite.conf hinzufuegen. Dann:


mkdir myapp
cd myapp
git init
touch dummy.txt && git add dummy.txt && git commit -m 'dummy file'
git remote add origin gitserver:myapp.git
git push origin master:refs/heads/master


Repository auf den Git Server hochladen


git add .
git commit -m "initial commit"
git push


Repository irgendwo anders auschecken

git clone gituser@gitserver:myapp.git

Repository aktualisieren

git pull

Geloeschtes File wieder herstellen


rm blub
git checkout -f


Bestimmte Files oder Verzeichnisse ausklammern


vim .gitignore
*.swp
log/


add-apt-repository ppa:vincent-vandevyvre/vvv
apt-get update
apt-get install qarte

Installation

https://rvm.beginrescueend.com/rvm/install/

2 Wege

=> als user ins eigene home
~/.rvm

=> als root fuer alle global
adduser christine rvm
/usr/local/rvm

bash < <(curl -s https://rvm.beginrescueend.com/install/rvm)

update
$ curl -s https://rvm.beginrescueend.com/install/rvm -o rvm-installer ; chmod +x rvm-installer ; ./rvm-installer –version lastest

setup RVM

https://rvm.beginrescueend.com/rvm/basics/
Aenderungen in .bashrc
rvm settings ganz unten sonst gehts kaputt beim ruby-switch

Gemsets erzeugen

rvm install 1.8.7
rvm install 1.9.2

rvm –create 1.8.7@rails2first
rvm –create use 1.9.2@rails3first

rvm –default use 1.9.2@rails3first

check ob es funktioniert

ruby -v
rvm use system
ruby -v
rvm default
ruby -v

# zurueck zum system ruby als „default“
rvm reset

# System .rvmrc
https://rvm.beginrescueend.com/workflow/rvmrc/
cd project
echo „rvm ruby-1.9.2-p180@rails3first“ > .rvmrc
ruby -v

# check ob es funktioniert:
cd ..
rvm system
ruby -v
cd project
ruby -v
rvm default
rvm info
rvm gemdir
cd $(rvm gemdir)

Export/Import

https://rvm.beginrescueend.com/gemsets/exporting/

rvm ruby-1.9.2-p180@rails3first gemset export => rails3first.gems
rvm gemset export => default.gems

rvm –create ruby-1.9.2-p180@rails3first
rvm gemset import rails3first

# copy gemset from one ruby to another
rvm gemset copy 1.9.2@rails3 1.9.2@railsblub

Links

• https://rvm.beginrescueend.com/
• http://rubylearning.com/blog/2010/12/20/how-do-i-keep-multiple-ruby-projects-separate/

The problem

select t.id from tmplay as t, postpl as p where p.zip = t.zip;

ERROR 1267 (HY000): Illegal mix of collations (latin1_swedish_ci,IMPLICIT) 
and (latin1_german1_ci,IMPLICIT) for operation '='

There is the rub

select 
    table_schema, 
    table_name, 
    column_name, 
    character_set_name, 
    collation_name 
from information_schema.columns 
   where collation_name = 'latin1_swedish_ci';

The quick and dirty solution

Fuer den Fall, dass man an der collation Sache kein Interesse hat, d.h. es keine Rolle spielt ob das Ö schwedisch ist oder deutsch. In meinem Beispiel ist das der Fall, da es um Postleitzahlen geht, also nur Ziffern im String vorkommen.

alter table postpl convert to character set latin1 collate 'latin1_german1_ci';

Links

Getting started

Read getting started tutorial http://www.symfony-project.org/getting-started/1_4/en/.

Generate Yaml Schema from existing DB

./symfony doctrine:build-schema

Generate Model from Yaml

./symfony doctrine:build-model

Links

http://www.symfony-project.org/getting-started/1_4/en/

Tutorial zu canvas

malen-nach-zahlen

lalalaaa

cd /etc/apache2
. ./envvars
apache2ctl stop
strace -f -s 512 apache2 -X 2> /tmp/blub

I made some experiments with mapnik rendering. Have a look a the slippy map of Reykjavik with funny colours.