Linux

Simple Bash Backup Script

I just started a backup script to maintain a simple configurable, daily backup script for linux that holds 1 month history of backuped data and has host dependant configuration to update the script in a central repository. I published it under github: https://github.com/mbogner/backup_script Features: logging of all output configuration file in /etc/backup.conf to override default

Simple Bash Backup Script Read More »

Openssl

here is a list of often needed openssl commands to work with ssl keys: Create new private key + CSR: openssl req -new -newkey rsa:2048 -nodes -keyout common_name.key -out common_name.csr Create CSR from existing private key: openssl req -new -key common_name.key -out common_name.csr Check CSR: openssl req -text -noout -verify -in common_name.csr Check private key:

Openssl Read More »

Magento – Column ‘option_id’ in where clause is ambiguous.

This problem should be fixable by changing app/code/core/Mage/Eav/Model/Resource/Entity/Attribute/Option/Collection.php line 117. Just insert “main_table.” (without “) before option_id. The line shoul look like the following after that: return $this->addFieldToFilter(‘main_table.option_id’, array(‘in’ => $optionId));

Magento – Column ‘option_id’ in where clause is ambiguous. Read More »

Install Tomcat under Debian

Download Tomcat. Create /etc/init.d/tomcat as listed below and change properties in it as needed. Execute the following commands as root. cd /opt tar -xf apache-tomcat-7.0.25.tar.gz ln -s apache-tomcat-7.0.25 tomcat groupadd tomcat useradd -g tomcat -d /opt/tomcat tomcat usermod -G www-data tomcat chown tomcat:tomcat /opt/apache-tomcat-7.0.25 -R chmod +x /etc/init.d/tomcat update-rc.d tomcat defaults /etc/init.d/tomcat #!/bin/sh CATALINA_HOME=/opt/tomcat export

Install Tomcat under Debian Read More »