17 Nov 2009 Create a temporary “Site Down” notice in Apache
This post describes how to make a “Site down for maintenance” notice using Apache .htaccess and the mod_rewrite module.
I assume you know how to enable the Apache htaccess directive and the mod_rewrite module.
First you need to create a .htaccess file in your root level of your website.
Next you add the following lines to it
Options +FollowSymlinks
RewriteEngine on
RewriteCond %{REQUEST_URI} !/sitedown.html$
RewriteRule $ /sitedown.html [R=302,L]
The .htaccess file should be “active” immediately and you should see the content of your sitedown.html file. If not, try clearing your browsers cache.
If you as a maintenance user would like to access the site without seeing the sitedown.html file, add the following line to enable IP address exception
RewriteCond %{REMOTE_HOST} !^192\.168\.0\.12
Remember to replace the IP address with your address.
The .htaccess file should now look something like this.
Options +FollowSymlinks
RewriteEngine on
RewriteCond %{REQUEST_URI} !/sitedown.html$
RewriteCond %{REMOTE_HOST} !^192\.168\.0\.12
RewriteRule $ /sitedown.html [R=302,L]
Just delete the .htaccess file when you are done with your maintenance and your site will be available again.
Posted by Hans-Henry Jakobsen
17 Nov 2009 Zimbra distribution list commands
This is just a short post describing Zimbra distribution list (mailinglist) commands.
These commands should be run as the zimbra user
# su - zimbra
List all distribution lists
# zmprov gadl
Print only members addresses of a distribution list
# zmprov gdl mailinglist@example.com | grep zimbraMailForwardingAddress: | awk {'print $2'}
Show if a list is member of another distribution list(s)
# zmprov gdlm mailinglist@example.com
Posted by Hans-Henry Jakobsen
02 Nov 2009 Howto backup mysql stored functions and stored procedures
This is how you can backup you MySQL database(s) and stored procedures
# mysqldump --routines <dbname>
Or you can backup only the stored procedures
# mysqldump --no-create-db --no-create-info --no-data --routines <dbname>
Tags: backup, howto, MySQL, stored functions
Posted by Hans-Henry Jakobsen
