blog.icod.de

Öffentliche IPv6 im Gast mit libvirt bei Hetzner

9. April 2017 | 3 min read

So, ich habe mir einige Blogposts angesehen und auch die Hetzner Wiki verschlungen und nichts klappte so richtig. Damit hat es geklappt: Um das Grundlegende zu verstehen, wir haben ein frisch aufgesetztes System das systemd nutzt und deshalb die ifaces z.B. enp5s0 oder eno1 nennt. eth0, enp5s0, enp4s0, eno1 usw. ist hier in diesem Kontext…

Read Article

Firefox sperrt Youtube Unblocker

2. March 2016 | 1 min read

Gerade eben, vor ca. 5 Minuten öffnete sich eine Meldung das der Youtube unblocker gesperrt wurde. Es ist jetzt 10:44 Uhr. Angeblich wegen “Sicherheitsbedenken”. Der Youtube unblocker tut was der Name vermutet. Er entsperrt regional gesperrte Videos und umgeht so ohne viel Aufwand die GEMA-Zensur. Ist es reine Willkür von Firefox, die in letzter Zeit…

Read Article

postfix dovecot vmail virtual mailserver

26. January 2016 | 1 min read

my dovecot.conf

## Dovecot configuration file

protocols = imap pop3
auth_mechanisms = plain
passdb {
driver = sql
args = /etc/dovecot/dovecot-sql.conf
}
userdb sql {
driver = sql
args = /etc/dovecot/dovecot-sql.conf
}

service auth {
unix_listener auth-client {
group = postfix
mode = 0660
user = postfix
}
user = root
}

mail_home = /home/vmail/%d/%u
mail_location = maildir:~

ssl_cert = </etc/ssl/private/postfix.crt
ssl_key = </etc/ssl/private/postfix.key

listen = *, ::
login_greeting = Dovecot ready.

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

## Dovecot configuration file

protocols = imap pop3

auth_mechanisms = plain

passdb {

driver = sql

args = /etc/dovecot/dovecot-sql.conf

}

userdb sql {

driver = sql

args = /etc/dovecot/dovecot-sql.conf

}

service auth {

unix_listener auth-client {

group = postfix

mode = 0660

user = postfix

}

user = root

}

mail_home = /home/vmail/%d/%u

mail_location = maildir:~

ssl_cert = </etc/ssl/private/postfix.crt

ssl_key = </etc/ssl/private/postfix.key

listen = *, ::

login_greeting = Dovecot ready.

dovecot-sql.conf

driver = mysql
connect = host=127.0.0.1 dbname=postfix_db user=postfix_user password=the_password
# The new name for MD5 is MD5-CRYPT so you might need to change this depending on version
default_pass_scheme = SHA512-CRYPT
# Get the mailbox
user_query = SELECT '/home/vmail/%d/%u' as home, 'maildir:/home/vmail/%d/%u' as mail, 5000 AS uid, 5000 AS gid, concat('dirsize:storage=',  quota) AS quota FROM mailbox WHERE username = '%u' AND active = '1'
# Get the password
password_query = SELECT username as user, password, '/home/vmail/%d/%u' as userdb_home, 'maildir:/home/vmail/%d/%u' as userdb_mail, 5000 as  userdb_uid, 5000 as userdb_gid FROM mailbox WHERE username = '%u' AND active = '1'
# If using client certificates for authentication, comment the above and uncomment the following
#password_query = SELECT null AS password, ‘%u’ AS user

1

2

3

4

5

6

7

8

9

10

driver = mysql

connect = host=127.0.0.1 dbname=postfix_db user=postfix_user password=the_password

# The new name for MD5 is MD5-CRYPT so you might need to change this depending on version

default_pass_scheme = SHA512-CRYPT

# Get the mailbox

user_query = SELECT '/home/vmail/%d/%u' as home, 'maildir:/home/vmail/%d/%u' as mail, 5000 AS uid, 5000 AS gid, concat('dirsize:storage=', quota) AS quota FROM mailbox WHERE username = '%u' AND active = '1'

# Get the password

password_query = SELECT username as user, password, '/home/vmail/%d/%u' as userdb_home, 'maildir:/home/vmail/%d/%u' as userdb_mail, 5000 as userdb_uid, 5000 as userdb_gid FROM mailbox WHERE username = '%u' AND active = '1'

# If using client certificates for authentication, comment the above and uncomment the following

#password_query = SELECT null AS password, ‘%u’ AS user

Read Article

A laptop for my mom

11. January 2016 | 2 min read

I’d like to buy a laptop for my mom. I’m thinking cheap base, like some 300€ (which is expensive enough) 1366×768, which is good enough for browsing *most* sites, although a bit outdated. And just buy a USB HDD for her photos. Should be like 500€ alltogether. But then she isn’t exactly an expert. And…

Read Article

Fuck mod_perl

30. September 2015 | 1 min read

Old image I found in my old old old backups

Read Article