January 2016

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.

## 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

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

Continue reading “postfix dovecot vmail virtual mailserver”

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 I’d like her to just plug in her camera and transfer her photos.
But that doesn’t work that well with Linux.
And I’m not exposing her to the dangers and spyware of Windows.
Android just doesn’t have the programs she needs, it’s basically a client for “the cloud” and I don’t want that, I don’t want her to store her stuff on other people’s computers.

Crap ass laptops are way too expensive.
I’m not paying 700€ for a freaking laptop that’s used to Skype, Facebook and browse cooking recipes and stuff like email and photo storage.

Then there’s the Dell Inspirion 3000 with a Celeron N3050 for 280€. 1366×768
Then there are those 4th gen U cpu laptops. They suck. 480€
Next step 630€
Too expensive. I don’t care.

And btw why does a 1920×1080 display that costs 77 USD make for an increased price of 300 € compared to 1600×900 or 1366×768 displays? I understand they want to make a buck but holy fucking shit, 300€ ? For what? Hot air?

And if you buy this crap it’s bound to break after 2 years.
That’s the thing. I wouldn’t mind paying more if I knew it would last 10 years. But that’s not the case. Today’s technology breaks after 2 years.
Where are the products that lasted a lifetime?

So what should I get?
There is no “buy refurbished” with laptops.
You know, then I see laptops, built in GPU, Intel only and they sell for 1500€ WTF
For what again?

The search continues…

Month: January 2016

postfix dovecot vmail virtual mailserver

A laptop for my mom