http://edvanta.com/knowledgebase Journaling the journey... Thu, 23 Sep 2010 19:41:08 +0000 http://backend.userland.com/rss092 en Good post Vikram!! To add to it, a single computer using apache web server can serve as multiple websites as if they are on separate hosts using the same concept. There are two ways to do it. 1. Creating a name-based virtual host 2. Creating an ip based virtual host What you just ... http://edvanta.com/knowledgebase/2010/09/24/apache-virtual-hosts/ # Turn on rewrites. RewriteEngine on # Only apply to URLs on this domain RewriteCond %{HTTP_HOST} ^(www.)?mysite.com$ # Only apply to URLs that aren't already under folder. RewriteCond %{REQUEST_URI} !^/moodledir/ # Don't apply to URLs that go to existing files or folders. RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d # Rewrite all those to insert /folder. RewriteRule ^(.*)$ /moodledir/$1 # Also redirect ... http://edvanta.com/knowledgebase/2010/05/23/moodle-mod-rewrite/ 1. Copy all files from the root of your Moodle installation and the moodle data directory. #rsync -av -e ssh sourse/ username@newserver.com:/path/to/destination/ 2. Dump your Moodle database and import it it new server #mysqldump --allow-keywords --opt -uMySQL_USERNAME -pPASSWORD DATABASE | ssh username@newserver.com "mysql -uMySQL_USERNAME -pPASSWORD DATABASE" 3. Edit config.php to update all database access ... http://edvanta.com/knowledgebase/2010/05/23/moodle-migration-in-3-steps/ Enable Directory Browsing Options +Indexes ## block a few types of files from showing IndexIgnore *.wmv *.mp4 *.avi Disable Directory Browsing Options All -Indexes Customize Error Messages ErrorDocument 403 /forbidden.html ErrorDocument 404 /notfound.html ErrorDocument 500 /servererror.html Get SSI working with HTML/SHTML AddType text/html .html AddType text/html .shtml AddHandler server-parsed .html AddHandler server-parsed .shtml # AddHandler server-parsed .htm Change Default Page (order is followed!) DirectoryIndex myhome.htm index.htm index.php Block Users ... http://edvanta.com/knowledgebase/2010/05/12/htaccess-cheatsheet/ Sshfs is used for viewing and exploring remote file system as if it was your local machine. It is pretty simple to setup #yum install sshfs fuse-sshfs Once you have installed sshfs we can use it to connect to any server which allows ssh access #mkdir /mnt/moodle_server #sshfs user@server.com:/home/abcd/public_html/moodle /mnt/moodle_server/ Enter password and you re ... http://edvanta.com/knowledgebase/2010/05/12/sshfs-and-remote-php-debugging/ As a security check. $.load and $.get are not allowed to make cross-domain requests to pull and include files/data, which means that residing sitea.com you can't pull file/data from siteb.com. DOM doesn't allow it. However using YQL its a piece of cake ;) Here is how. <div id="containerdiv1"></div> <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.4/jquery.min.js" type="text/javascript" charset="utf-8"></script> ... http://edvanta.com/knowledgebase/2010/05/12/pulling-data-from-cross-domain-url-using-jquery-and-yql/ MYSQL Statements and clauses ALTER DATABASE ALTER TABLE ALTER VIEW ANALYZE TABLE BACKUP TABLE CACHE INDEX CHANGE MASTER TO CHECK TABLE CHECKSUM TABLE COMMIT CREATE DATABASE CREATE INDEX CREATE TABLE CREATE VIEW DELETE DESCRIBE DO DROP DATABASE DROP INDEX DROP TABLE DROP USER DROP VIEW EXPLAIN FLUSH GRANT HANDLER INSERT JOIN KILL LOAD DATA FROM MASTER LOAD DATA INFILE LOAD INDEX INTO CACHE LOAD TABLE...FROM MASTER LOCK TABLES OPTIMIZE TABLE PURGE MASTER LOGS RENAME TABLE REPAIR TABLE REPLACE RESET RESET MASTER RESET SLAVE RESTORE TABLE REVOKE ROLLBACK ROLLBACK TO SAVEPOINT SAVEPOINT SELECT SET SET PASSWORD SET SQL_LOG_BIN SET TRANSACTION SHOW BINLOG EVENTS SHOW CHARACTER ... http://edvanta.com/knowledgebase/2010/04/27/mysql-statements-clauses/ This is a list of handy MySQL commands that I use time and time again. At the bottom are statements, clauses, and functions you can use in MySQL. Below that are PHP and Perl API functions you can use to interface with MySQL. To use those you will need to ... http://edvanta.com/knowledgebase/2010/04/27/mysql-commands/ We were an SVN Fan over CVS for the fact that it was so simple to use until we found Git which was faster and much powerful. Git allows faster version control in a distributed development environment. It has full fledged repository and efficient tracking capabilities. Branching, Merging or Cloning; ... http://edvanta.com/knowledgebase/2010/03/12/working-with-git/ List all the packages #yum list | grep "postgres*" #yum install -y "postgres*" To initialize the postgresql #service postgresql initdb To start the postgresql service #service postgresql start Editing config files and creating new databases using pgadmin3 gui #yum install -y pgadmin3 pgadmin gets install in /usr/bin/pgadmin3 To run pgadmin3 #pgadmin3 Add server, choose any name, host = localhost, user= postgres, password ... http://edvanta.com/knowledgebase/2009/10/19/installing-postgresql-on-fedora/