http://www.penguinlinux.com/blog Linux and Open Source Software tips and hacks Thu, 03 Dec 2009 18:44:04 +0000 http://backend.userland.com/rss092 en HOW TO UPGRADE TO PHP 5.3 ON A CENTOS 5 DISTRO I am trying to install cahoots a StackOverflow clone but I am running Centos 5 and by default it comes with php 5.1.6 and I needed to install the Zend Framework. If you tried to install the Zend framework you will ... http://www.penguinlinux.com/blog/lamp/how-to-upgrade-to-php-53-on-a-centos-5-distro/ This is a reminder of how to backup the schema of a complete database mysqldump --no-data -h localhost -u root -ppassword mydatabase > mydatabase_backup This is if you want to only backup certain tables schema. mysqldump --no-data -h localhost -u root -ppassword mydatabase table1 table2 > mydatabase_backup.sql More info at http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_no-data http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html Here is a cool ... http://www.penguinlinux.com/blog/databases/mysql-backup-table-schema-structure-and-backup-only-data/ The Most Common OpenSSL Commands One of the most versatile SSL tools is OpenSSL which is an open source implementation of the SSL protocol. There are versions of OpenSSL for nearly every platform, including Windows, Linux, and Mac OS X. OpenSSL is commonly used to create the CSR and private key ... http://www.penguinlinux.com/blog/general-linux/the-most-common-openssl-commands/ Introduction OpenSSL deserves a lot of credit. It is an extremely useful, valuable Open Source project. When people talk about how successful Apache is, rock-solid crypto toolkits like OpenSSL and OpenSSH should also be mentioned. Here are a few (of the many) functions that I have found ... http://www.penguinlinux.com/blog/general-linux/useful-openssl-tricks/ A day will eventually come when your need to find and replace a string of text in your database. You don’t know which row, or which column, or which table. Heck, you may not even know which database. Your options are: spend the rest of the summer hunting down the ... http://www.penguinlinux.com/blog/databases/search-and-replace-string-mysql/ Linux create your own GnuPG private and public key GNU gpg is encryption and signing tool. The GNU Privacy Guard (GnuPG or GPG) is a free software replacement for the PGP suite of cryptographic software. GnuPG encrypts messages using asymmetric keypairs individually generated by GnuPG users. The resulting public keys can be ... http://www.penguinlinux.com/blog/advanced-stuff/create-your-own-pgp-public-key/ Let's say you need to drop all tables in a mysql database. How do you do that? You could use a gui, but that's not fun. You're a shell jockey so you want a commandline: mysql -u uname dbname -e "show tables" | grep -v Tables_in | grep -v "+" | \ gawk ... http://www.penguinlinux.com/blog/bash-scripting/how-to-drop-all-tables-on-a-mysql-database/ At work we have a few routers, switches and servers that if they go down we want to know right away. The last thing we want is the CEO coming to our desk asking why the mail server is down or why the webserver it not responding. I ... http://www.penguinlinux.com/blog/bash-scripting/a-simple-monitor-script/ If your system abruptly loses power, or if a RAID card is beginning to fail, you might see an ominous message like this within your logs: EXT3-fs error (device hda3) in start_transaction: Journal has aborted Basically, the system is telling you that it’s detected a filesystem/journal mismatch, and it can’t utilize ... http://www.penguinlinux.com/blog/general-linux/your-file-system-became-read-only-what-gives/ At work i setup a programming environment for developers. The server is on a natted IP address range and could not send email to our internal mail server because of some weird firewall issues. All email going to external sites was working fine but to send to our ... http://www.penguinlinux.com/blog/email-servers-and-spam/configure-postfix-with-smart-host/