Magento Notice: Undefined index: 0

Today I got this mysterious error message after moving a Magento website to a new server. Magento Notice: Undefined index: 0  in …/htdocs/app/code/core/Mage/Core/Model/Mysql4/Config.php on line 92 Turns out this was due to a faulty import of the database. Apparently there are a few tables where using an id of 0 in the auto_increment column has […]

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 […]