Categories
-
Recent Posts
- Configure CentOS Firewall From Command Line
- Add CentOS Package From Command Line
- Consume Web Service With Ruby
- Develop Web Service With Ruby on Rails
- Restore MySQL Database
- Install Ruby 1.8.5, Rails, FastCGI on OpenBSD 4.1
- Install MySQL 5.0 on OpenBSD 4.1
- Install Lighttp 1.4 w/ FastCGI on OpenBSD 4.1
- Quick UNIX Reference
- Backup File Using Amazon S3 And Ruby 1.8.4
- Backup MySQL Database
- Install WordPress on OpenBSD 4.0
- Make An ISO File From a CD in UNIX/Linux
- Install/Configure VMWare Server on CentOS
- Update All CentOS Packages From Command Line
Category Archives: Service
Restore MySQL Database
Quick Way to Restore a MySQL Databse
mysql -p <database> < <dump file>
Also posted in MySQL Leave a comment
Install Ruby 1.8.5, Rails, FastCGI on OpenBSD 4.1
Install Ruby
pkg_add -v ftp://ftp.openbsd.org/pub/OpenBSD/4.1/packages/i386/ruby-1.8.5p6.tgz
Install Gems
pkg_add -v ftp://ftp.openbsd.org/pub/OpenBSD/4.1/packages/i386/ruby-gems-0.9.0.tgz
Install Rails And FCGI
gem install rails
gem install fcgi
Also posted in 4.1, FastCGI, Rails, Ruby Leave a comment
Install MySQL 5.0 on OpenBSD 4.1
Install Package
pkg_add -v ftp://ftp.openbsd.org/pub/OpenBSD/4.1/packages/i386/mysql-server-5.0.33.tgz
Install Default Database
/usr/local/bin/mysql_install_db
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
Also posted in 4.1, MySQL Leave a comment
Install Lighttp 1.4 w/ FastCGI on OpenBSD 4.1
Install Packages
pkg_add -v ftp://ftp.openbsd.org/pub/OpenBSD/4.1/packages/i386/fcgi-2.4.0p2.tgz
pkg_add -v ftp://ftp.openbsd.org/pub/OpenBSD/4.1/packages/i386/lighttpd-1.4.13p2-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 [...]
Backup MySQL Database
Quick Way to Backup a MySQL Databse
mysqldump —opt —user <username> —password="<password>" "<database>" > <output>.dmp
Also posted in MySQL Leave a comment
Install/Configure VMWare Server on CentOS
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
Also posted in CentOS, VMWare Leave a comment
301 Redirect With Lighttp 1.4
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)$” [...]
Also posted in Lighttp, Search Engine Optimization Leave a comment
Install PHP 5.1 w/ FastCGI on OpenBSD 4.0
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
Also posted in 4.0, FastCGI, PHP Leave a comment
Install Lighttp 1.4 w/ FastCGI on OpenBSD 4.0
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 [...]
Configure CentOS Firewall From Command Line