Installing Lighttpd with mod_h264_streaming and mod_magnet

December 18, 2009 by myitsolutions

First: Install LUA:

http://bluescripts.net/tag/lighttpd/

Second: Instal Lighttpd

Third: http://h264.code-shop.com/trac/wiki/Mod-H264-Streaming-Lighttpd-Version2

4th: Make sure autoconf, automake, libtool are the latest versions.

If you encounter problems, http://h264.code-shop.com/trac/discussion/1/85

Make wordpress search work

December 7, 2009 by myitsolutions

If you are having problems with wordpress search form in Lighttpd, it’s because it does not directly support the QSA parameter from mod_rewrite.

To overcome this problem, instead of:

“.” => “index.php”

use

“.(?:\?(.*))?” => “index.php?$1″

This simulates QSA and makes your search work

PostgreSQL – how to make the first function work

June 7, 2009 by myitsolutions

In order to make a simple function, you must first create a new language, called plpgsql. After that, create the function using plpgsql language, not the sql function.

Postgre SQL – autonumber – serial

June 7, 2009 by myitsolutions

To be able to set the serial pseudo-data-type, you must first set that field as primary key and then that type will appear for usage in Navicat PostgreSQL.

ExtJS – In IE, grid column headers are not shown, but ok in Firefox

May 12, 2009 by myitsolutions

Add this to your css

.x-grid3-header {position: relative;}

Have /m/* and also /* with mod rewrite

April 23, 2009 by myitsolutions

Options -Indexes

RewriteEngine On
RewriteBase /
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^m/(.*)        /index.php?u=$1&m=1 [L]

RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)         /index.php?u=$1 [L]

Dump a database into a gzip file

April 23, 2009 by myitsolutions

mysqldump –user=dbuser –password=dbpass dbname | gzip -9 > backup-`date +”%Y-%m-%d_%H-%M-%S”`.sql.gz

How to archive a folder and timestamp the name of the file

April 23, 2009 by myitsolutions

tar zcfv backup-`date +”%Y-%m-%d_%H-%M-%S”`.tgz /root/code

Install JSON on a VPS server CentOS

April 2, 2009 by myitsolutions

http://forums.crm.saeven.net/showthread.php?t=128

How to correctly setup permissions in Lunarpages webhosting

March 30, 2009 by myitsolutions

The folder containing the files should be 0755, and the files inside 0644 (in order not to yield “is writable by the group” error)

To do this, just call the following functions

find . -type f -print0 | xargs -0 chmod 644;find . -type d -print0 | xargs -0 chmod 755