Category: MySQL

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

  • (partial) MySQL Proxy API Doc

    I have been working a lot with MySQL proxy lately and trying to figure out how it works is a major PITA. There is virtually no documentation for it and the best way to understand how it actually works is to read the source code. This is a list of API functions discovered by reading […]

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