Cleaning the log tables and rebuilding indexes with shell scripts

Based on the same idea as my “cache clearing script“ (but 10x better), Magento now includes some handy scripts to clean the log tables, to compile source files and to rebuild indexes. For people with very large databases (10k+ products) this is sometimes the only way to actually accomplish something without running out of memory or exceeding execution time […]

Netbeans Preparing Commit

If you ever tried to SVN commit a big project using Netbeans (Magento?) you have most likely seen that “Preparing Commit” message doing seemingly absolutely nothing for several minutes. Apparently the commit takes forever because Netbeans is scanning the entire projet to localize any changes done by external applications before committing. This is not really an […]

Running MySQL Proxy as a daemon

I had to figure out how to setup mySQL Proxy to run as a daemon (system service). The original information came from this page and has been slightly modified. It is assumed that mySQL Proxy has been installed and the mysql-proxy executable is located at /usr/local/sbin/mysql-proxy. The first file is the init.d launch script: /etc/init.d/mysql-proxy […]

Add a self-generated SSL certificate to the list of trusted certificates

Usually Java only accepts SSL certificates that can be validated with one of the CA providers in JRE’s internal cacerts keystore. The cacerts keystore is a file located at $JAVA_HOME/lib/security/cacerts How to import a self generated SSL certificate First, export the self-generated key ‘mywebsite.com’ to a file called mywebsite.com.cert on the server keytool -export -keystore […]