VPS at lowest price

Do not wonder.. it is true. you can buy a VPS from 7.95 USD / Month

vps1
vps2

How to insert a CSV file in to mysql database through mysql console

When you want to insert larger CSV file in to a mysql database using  PhpMyadmin or any other GUI tools it may take long time or even it  may be stopped. You can easily Import the CSV file in to mysql database using mysql command.  Log on to the server and  open mysql command and log on to the console and do run the following command. I guess the Db name is  testdb

use testdb;
load data local infile ‘CSVFILE.CSV’ into table TABLENAME fields terminated by ‘,’ enclosed by ‘”‘ lines terminated by ‘\n’;

XCart

XCart

install mod ssl on apache

I am going to give you the steps to install mod_ssl on an Apache server by compiling the source.
Download the following packages
1. apache_1.3.14.tar.gz   http://www.apache.org
2. openssl-0.9.6.tar.gz http://www.openssl.org
3.  mod_ssl-2.7.1-1.3.14.tar.gz http://www.modssl.org
I have created a folder called  /downloads/src and downloaded all packages here
Go to Apache source files and  compile it as shown below
# ./configure –enable-module=so –enable-module=ssl –enable-module=mod_rewrite
Youc an add whatever module you needed
Now go to openssl folder and compile and install ( you can do this same by  using yum or apt-get command)
To compile and install OpenSSL do the following commands
# sh config -fPIC
# make
# make install
At this time you can compile your PHP also. To do that run following commands
# ./configure –with-apache=../apache_1.3.41  –with-gd –with-zlib-dir –with-jpeg-dir –with-png-dir –with-freetype-dir –enable-gd-native-ttf –with-freetype-dir=/usr/lib/ –with-ttf –with-mysql=/usr/local/mysql –with-curl –disable-soap –with-openssl –with-xmlrpc –enable-ftp –with-xsl –with-mysqli=/usr/local/mysql/bin/mysql_config
# make
# make install
Compile Apache and install
Go to the apache Directory and runn following commands
#  ./config.status
#  make
#  make certificate  ( This step will be asked  some inputs  from you for your self signed SSL certificate)
# $ make install
Now you have installed the apache server with a self signed SSL certificate. Now it is the time to add the location of the .CRT file and .KEY file in your apache configuration file.  From the above steps you can see the location of these files. Copy those paths.
Now open your httpd.conf file and  add the following line
Listen 443
Now create a virtual directory which will listen the port 443
<VirtualHost XXX.XXX.XXX.XXX:443>
ServerName  www.example.com
SSLEngine on
SSLCertificateFile  /usr/local/apache/conf/ssl.crt/server.crt
SSLCertificateKeyFile /usr/local/apache/conf/ssl.key/server.key
</VirtualHost>
Now save the file and restart your Apache server
# apachectl stop
# apachectl startssl
Enjoy :)

skype automatically sends messages to all contacts

Recently we have faced a Skye virus attack on a LAN. One of the users received a message

Do you think this is the definition of SEXY? I do.
http://www.xxxxxxxxxx.com/uploads/94603/NewPicture004.JPG.zip

Now the same message was started to send from this machine to all his skype contacts. Also sent email through email client.  In a couple of minutes all systems were infected.  We have done the following steps to fix it

1. Cleaned the hosts file
We have noticed that the hosts file  located in c:\windows\sysetm32\drivers\etc\ was edited by the virus and it added many lines to the file at the very bottom.  We  scrolled down to the end and removed all unwanted entries.  Remember  this file is read only and you need to change the file attribute to save it.

2. Cleaned the System using ComboFix

Download this and run the file.  Follow the instructions and complete the steps. In some cases you need to do with something on the Network Card. Go to Device manager and you will find two copies of the same network card. One with an Yellow color and other is normal. Now remove the Normal card and click on Scan for hardware changes and your card will be automatically installed. Note that you may also to set the IP address if you are using static IP address

3.  complete System scan using a good Anti Virus

Use any good anti virus program to do a full system scan. I recommend Avast Antivirus and do a boot time scan with that


Fatal error: Call to undefined function wp_list_addonn() in /home/sites/customers/aneesh/systemadmin/blog/wp-content/themes/Grante/sidebar.php on line 106