Downloaded Roundcube 1.0.2 and installed it at ProgClub…
Roundcube download 1.0.2
Reply
Category Archives: Sys Admin
NTP on Ubuntu
Read about how to configure NTP server on Ubuntu.
HTML meta refresh
Today I read What is the Meta Refresh Tag? about the HTML Meta Refresh facility, basically:
<meta http-equiv="refresh" content="0;url=https://www.jj5.net/">
Embedding archive.org videos…
Today I read about how to link to archive.org videos…
MySQL convert_tz
Today I used the MySQL convert_tz function.
Before I could use named timezones with convert_tz I had to load the timezones.
Loading MySQL timezone data
Turns out MySQL doesn’t load timezone info by default! As you can read about here.
To load MySQL timezone info:
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql
Disable Apache2 auto-start on Ubuntu
Disabled Apache2 with:
update-rc.d -f apache2 remove
Installing nginx and php5-fpm on Ubuntu
Followed these instructions!
OpenSSL command to view certificate info
From The Most Common OpenSSL Commands to view a certificate:
openssl x509 -text -noout -in certificate.crt
Namecheap SSL CSR and CA Bundle for PostiveSSL certs
CSR generation for PositiveSSL and PositiveSSL WildCard with Apache2/OpenSSL see: CSR Generation: Using OpenSSL (Apache w/mod_ssl, NGINX, OS X):
openssl req -nodes -newkey rsa:2048 -keyout myserver.key -out server.csr
To generate the CA bundle see this article:
cat COMODORSADomainValidationSecureServerCA.crt COMODORSAAddTrustCA.crt AddTrustExternalCARoot.crt > your_domain.ca-bundle