On Ubuntu systems there is a (system) mysql user debian-sys-maint that is used by the system’s init scripts to control the mysql database, e.g. to start or stop the mysql server. The password of this user is stored (in clear text) in /etc/mysql/debian.cnf. If this password does not match the the actual password in the [...]
Read more…Archive for the ‘System administration’ Category
svndumpfilter & svndumpfilter2: Extract svn paths to separated repository
If you have a svn repository and you would like to extract one ore more paths to put them in a separated repository it could be exhausting, especially if the origin svn repository is very big. svndumpfilter svn’s svndumpfilter tool helps you to meet the target: You can create a dump of the origin svn [...]
Read more…CACert.org & Apache2: Create and use free public key certificates
CAcert.org is a certificate authority that offers you free public key certificates. Here is a howto that explains the steps to be taken to create server certificate and how to use them with the Apache2 webserver. 1. Add the domain to your CACert.org account Login in your CACert.org account and add your domain (Domains > [...]
Read more…Ubuntu: Fix slow ssh logins
Slow SSH logins could be caused by DNS lookup on the server side. If it takes (too) long time to be prompted for a password the option UseDNS could by a solution (as suggested in the OpenSSH FAQ). On Ubuntu edit the file /etc/ssh/sshd_config and add the following line: UseDNS no Restart the SSH daemon [...]
Read more…Feeds & IMAP: Feed2Imap aggregates feeds into IMAP folders
Introduction Using the Internet Message Access Protocol (IMAP) for your email account(s) enables you to get an always up-to-date view of your inbox: You can use different mail clients (on different machines) to access your mails and all mails are stored on a server which makes restoring your mails very easy in case of the [...]
Read more…Apache’s mod_rewrite & mod_proxy: Use “Reverse Proxy Request Headers” for rewrite rules
Imagine the following scenario: The URL to your site is your-public-url.com (hosted in a low-priced web package that only supports reroutings to other URLs). The “internal” URL to your site is your-internal-url.com (e.g. an DynDNS-URL to your home server). The hoster of your-public-url.com uses apache’s mod_proxy that acts in a reverse proxy mode to redirect [...]
Read more…