Ycsoftware.net

Import Microsoft Excel data to Mysql

Import Excel To MySQL

First fire up your MySQL Workbench editor or your chosen Mysql Client editor

CSV

LOAD DATA LOCAL INFILE 'C:\\Users\\ycsoftware\\Desktop\\ycsoftware.csv' INTO 
TABLE `ycsoftware`.`ycsoftware` FIELDS 
TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n' (temp1, temp2, temp3); SHOW WARNINGS

LOAD DATA LOCAL INFILE 'C:\\Users\\ycsoftware\\Desktop\\ycsoftware.csv' INTO 
TABLE `ycsoftware`.`ycsoftware` FIELDS 
TERMINATED BY ',' ENCLOSED BY '' LINES TERMINATED BY '\r\n' (temp1, temp2, temp3); SHOW WARNINGS

TAB SEPARATED

LOAD DATA LOCAL INFILE 'C:\\Users\\ycsoftware\\Desktop\\ycsoftware.csv' INTO 
TABLE `ycsoftware`.`ycsoftware` FIELDS 
terminated by '\t' lines terminated by '\r\n' (temp1, temp2, temp3);  SHOW WARNINGS

Automatically redirect all http traffic to https with .htaccess (Apache)

To automatically redirect all http traffic to https add the following code to your .htaccess file or apache config file

RewriteEngine On 
RewriteCond %{SERVER_PORT} 80 
RewriteRule ^(.*)$ https://www.example.com/$1 [R,L]

Multiple Google Analytics Codes Per Page

“Installing multiple instances of the Google Analytics Tracking code on a single web page is not a supported Implementation.”

http://support.google.com/analytics/bin/answer.py?hl=en-GB&answer=1032400

Invalid ALLOWHIDDENFILE configuration option: Not a file: /dev/.initramfs

This rkhunter software is driving me nuts with all these false positive alerts.
ALLOWHIDDENFILE apparently is not working on symbolic links (version 1.3.8) and I was unable to whitelist this “/dev/.initramfs” file until I found this blog below:

http://digitalcardboard.com/blog/2012/05/24/ubuntu-12-04-rkhunter-1-3-8-false-positives/

Follow the steps that the blogger mentioned above and you will be able to whitelist symbolic links

rkhunter manual
http://rkhunter.sourceforge.net/

Other links:
http://ycsoftware.net/please-inspect-this-machine-because-it-may-be-infectedrkhunter/

Request Tracker 4.0 Apache + FastCGI Virtual Host Configuration

Once FastCGI is setup, you are ready to configure Apache.

Server address format: http://rt.server.com
RT lines added to the virtual host:

DocumentRoot "/var/www/rt/share/html"
AddDefaultCharset UTF-8
Alias /NoAuth/images /var/www/rt/share/html/NoAuth/images/
AddHandler fastcgi-script fcgi
ScriptAlias / /var/www/rt/sbin/rt-server.fcgi/

DO NOT FORGET TO REPLACE /var/www with your root address.
DO NOT FORGET TO RESTART APACHE

That is all you need.

Interesting Websites
Apache Configuration
https://github.com/bestpractical/rt/blob/stable/docs/web_deployment.pod

Upgrading RT
http://blog.bestpractical.com/2011/07/upgrading-to-rt-4.html