Create a Self-signed SSL Certificate on Windows

SSL (Secure Socket Layer) is used for encryption and decryption, processing of S/MIME signed or encrypted mails, generation of certificates, and more. To use it on Windows (32 and 64 bit versions), download the OpenSSL tools from code.google.com/p/openssl-for-windows/downloads/list. Uncompress it anywhere you like and start it by double-clicking the openssl.exe executable in the \bin folder. ... Read more

How to renew the SSL certificate for dovecot on CentOS

Make a backup of the old key and certificate file mv /etc/ssl/certs/dovecot.pem /etc/ssl/certs/dovecot.pem.old mv /etc/ssl/private/dovecot.key /etc/ssl/private/dovecot.key.old Create the new SSL certificate openssl genrsa -out /etc/ssl/private/dovecot.key 1024 openssl req -new -x509 -key /etc/ssl/private/dovecot.key -out /etc/ssl/certs/dovecot.pem -days 730 Restart Dovecot: service dovecot restart

How to Disable quota for a Linux User or Group on the Shell

Linux user quotas can be edited with the commands edquota or setquota on the shell. While edquota opens the quota settings in an editor like vim, setquota allows you to specify the quota settings on the command line. Example for disabling the quota for the user "testuser": setquota -u testuser 0 0 0 0 -a ... Read more

How to enable port 465 (smtps) in postfix mailserver

More and more internet access providers are closing port 25 to reduce spam except for connections to their own mail servers. If you run your own email server and have problems connecting to it on port 25, you can enable port 465 (SMTPS) in postfix as a workaround. Edit the /etc/postfix/master.cf file: nano /etc/postfix/master.cf and ... Read more

Change PostgreSQL Locale

wrote by Rafael Marangoni, from Suporte Linux team. This article explains how to change the default PostgreSQL Locale. Be careful, because we're considering that you do not have data on the PostgreSQL instance. First, we need to stop the Postgres service (if was not already stopped): service postgresql stop Then we need to remove all ... Read more

Configure PostgreSQL to accept connections from network

wrote by Rafael Marangoni, from Consultoria Linux team. By default, on some distros, PostgreSQL will only accept connections from localhost. When you have only access from localhost (from localhost Apache, by example) everything is ok, but when you need that postgresql accepts connections for other hosts, you need to make some configs. First of all, ... Read more