Author Archives: Chris Koehler

Backup MySQL Database

By Chris Koehler | Published: May 6, 2007
Quick Way to Backup a MySQL Databse mysqldump —opt —user <username> —password="<password>" "<database>" > <output>.dmp
Posted in MySQL | Leave a comment

Install WordPress on OpenBSD 4.0

By Chris Koehler | Published: May 5, 2007
Install Ports http://www.tucsonconsulting.com/software/operating-system/unix/openbsd/40/how-to-install-openbsd-40-ports/ Install MySQL http://www.tucsonconsulting.com/software/service/database/mysql/install-mysql-50-on-openbsd-40/ Install Lighttp http://www.tucsonconsulting.com/software/language/ruby/install-lighttp-w-fastcgi-14-on-openbsd-40/ Install PHP With FastCGI http://www.tucsonconsulting.com/software/operating-system/unix/openbsd/40/install-php-51-w-fastcgi-on-openbsd-40/ Download And Extract Wordpress mkdir /www mkdir /www/sites mkdir /www/sites/<example>.com mkdir /www/sites/<example>.com/www lynx -source “http://wordpress.org/latest.tar.gz” > /www/sites/<example>.com/www/wordpress.tar.gz cd /www/sites/<example>.com/www/ tar zxvf wordpress.tar.gz Configure MySQL Database For Wordpress mysql -p create database `www-<example>-com`; grant all on `www-<example>-com`.* to ‘wordpress’@'localhost’ identified by <password>’; flush privileges; exit Configure /etc/lighttpd.conf For New Site http://www.tucsonconsulting.com/software/language/ruby/install-lighttp-w-fastcgi-14-on-openbsd-40/
Posted in 4.0, WordPress | Leave a comment

Make An ISO File From a CD in UNIX/Linux

By Chris Koehler | Published: May 4, 2007
Mount The CD-ROM mount /dev/cdrom Issue The Disk Dump Command dd if=/dev/cdrom of=/software/<filename>.iso
Posted in Linux, Unix | Leave a comment

Install/Configure VMWare Server on CentOS

By Chris Koehler | Published: May 4, 2007
Stop VM Servers /etc/init.d/vmware stop Install VMWare Package rpm -Uhv /tmp/VMware-server-<version>.i386.rpm Run Installation Script vmware-config.pl
Posted in CentOS, VMWare | Leave a comment

Update All CentOS Packages From Command Line

By Chris Koehler | Published: May 4, 2007
Run YUM update, answer yes to all prompts yum update -y
Posted in CentOS | Leave a comment

301 Redirect With Lighttp 1.4

By Chris Koehler | Published: May 2, 2007
Direct all clean traffic using an exact match on the host. $HTTP["host"] == “www.<example>.com” {    server.document-root = “/www/sites/<example>.com/www/” } Trap all traffic not directed to the main site (regex non-match), then filter remaining traffic headed to the correct domain with the wrong host (regex) and redirect to the main site. $HTTP["host"] !~ “^(www|mail)\.(<example>\.com)$” [...]
Posted in Lighttp, Search Engine Optimization | Leave a comment

Install PHP 5.1 w/ FastCGI on OpenBSD 4.0

By Chris Koehler | Published: May 2, 2007
Download, Compile And Install Package lynx -source “http://download.pureftpd.org/OpenBSD/misc/ports/php5.1-with-fastcgi-openbsd-4.0.tar.gz” > /tmp/php5.1-with-fastcgi-openbsd-4.0.tar.gz Unfortunately, as of OpenBSD 4.0 there isn’t a standard package for PHP with FastCGI support. cd /tmp tar xzf /tmp/php5.1-with-fastcgi-openbsd-4.0.tar.gz cd /tmp/php5 && make install clean …wait a long, long time… Install Subsequent PHP Support Packages pkg_add -v /usr/ports/packages/i386/all/php5-mysql-5.1.6.tgz /usr/local/sbin/phpxs -a mysql
Posted in 4.0, FastCGI, PHP | Leave a comment

Install Lighttp 1.4 w/ FastCGI on OpenBSD 4.0

By Chris Koehler | Published: May 2, 2007
Install Packages pkg_add -v ftp://ftp.openbsd.org/pub/OpenBSD/4.0/packages/i386/fcgi-2.4.0p1.tgz pkg_add -v ftp://ftp.openbsd.org/pub/OpenBSD/4.0/packages/i386/lighttpd-1.4.11-mysql.tgz Example /etc/lighttpd.conf For PHP $HTTP["host"] == “www.<example>.com” {    server.document-root = “/www/sites/<example>.com/www/”    index-file.names = ( “index.php” )    server.error-handler-404 = “/index.php” fastcgi.server = ( “.php” =>    ( “localhost” =>       (          ”socket” => “/tmp/php-fastcgi.socket”,          ”bin-path” => “/usr/local/bin/php-fcgi”       )    ) ) } Example /etc/lighttpd.conf For Ruby on Rails $HTTP["host"] == “www.<example>.com” {    server.indexfiles [...]
Posted in 4.0, FastCGI, Lighttp, PHP, Rails, Ruby | Leave a comment

Create New MySQL Database And Assign Administrator

By Chris Koehler | Published: May 2, 2007
Create New Database create database <database>; Create Administrator Account grant all on <database>.* to ‘<user>’@'localhost’ identified by ‘<password>’; Reset Privileges flush privileges;
Posted in MySQL | Leave a comment

Install MySQL 5.0 on OpenBSD 4.0

By Chris Koehler | Published: May 2, 2007
Install Package pkg_add -v ftp://ftp.openbsd.org/pub/OpenBSD/4.0/packages/i386/mysql-server-5.0.22.tgz Start Service And Set Root Password /usr/local/bin/mysqld_safe & /usr/local/bin/mysqladmin -u root password ‘<password>’ Start Daemon on Server Startup, Add to /etc/rc.local if [ -x /usr/local/bin/mysqld_safe ]; then   echo ‘MySQL’   /usr/local/bin/mysqld_safe & fi
Posted in 4.0, MySQL | Leave a comment

  • 4.0 (5)
    4.1 (3)
    CentOS (4)
    FastCGI (4)
    Lighttp (3)
    Linux (2)
    MySQL (5)
    Network (1)
    PHP (2)
    Rails (4)
    Ruby (6)
    S3 (1)
    Search Engine Optimization (1)
    Unix (2)
    VMWare (2)
    Web Services (2)
    WordPress (1)

    WP Cumulus Flash tag cloud by Roy Tanck requires Flash Player 9 or better.

  • Categories

  • Recent Posts