tag:blogger.com,1999:blog-86602623732961995342012-01-25T04:42:30.887-08:00mtnoreply@blogger.comBlogger30125tag:blogger.com,1999:blog-8660262373296199534.post-47580583503594270352012-01-25T04:42:00.000-08:002012-01-25T04:42:30.894-08:002012-01-25T04:42:30.894-08:00

Simply iptables rules can be added to secure memcached server from the out sources. /sbin/iptables -A INPUT -m tcp -p tcp -s 127.0.0.1 --dport 11221 -j ACCEPT/sbin/iptables -A INPUT -m tcp -p tcp -s CLIENT_IP_2 --dport 11221 -j ACCEPT/sbin/iptables -A INPUT -m tcp -p tcp -s CLIENT_IP_1 --dport 11221 -j ACCEPT/sbin/iptables -A INPUT -m tcp -p tcp --dport 11221 -j DROPTo make it run when system

mtnoreply@blogger.com0http://vpslife.blogspot.com/2012/01/securing-memcache.htmltag:blogger.com,1999:blog-8660262373296199534.post-65761644509640067442011-10-16T05:07:00.000-07:002011-10-16T05:07:25.425-07:002011-10-16T05:07:25.425-07:00

To find the shell type of current user: echo $SHELL To find the paths of current user: echo $PATH

mtnoreply@blogger.com0http://vpslife.blogspot.com/2011/10/learn-path-and-shell-of-current-user-on.htmltag:blogger.com,1999:blog-8660262373296199534.post-35843096379372279992010-07-09T14:10:00.000-07:002010-07-09T14:19:20.572-07:002010-07-09T14:19:20.572-07:00

I wrote near a year ago a sh script to see my traffic information which can be used to see basic connection counts like unix connection count, tcp connection count, http inbound and outgoing request counts and ftp connection count, ssh connection count. Save as mycons.sh then run the command chmod +x mycons.shFor short access run ln mycons.sh /bin/mycons Sample usage after shortcut mycons -hlHere

mtnoreply@blogger.com0http://vpslife.blogspot.com/2010/07/simple-sh-script-to-monitor-basic.htmltag:blogger.com,1999:blog-8660262373296199534.post-66411133827714025532010-07-09T13:49:00.000-07:002010-07-09T14:21:33.111-07:002010-07-09T14:21:33.111-07:00

Vnstat is a network stats software, an opensource project for *nix systems and can be downloaded from http://humdi.net/vnstat/. For more than a year I am using Vnstat and it works silently without using too much resources and gives required stats when it is needed. In details, it is possible to see your network adapters' traffic data based on years, months, weeks, days, hours and even real time

mtnoreply@blogger.com0http://vpslife.blogspot.com/2010/07/vnstat-network-traffic-monitor-for-nix.htmltag:blogger.com,1999:blog-8660262373296199534.post-9402332467511611402010-02-26T08:33:00.000-08:002010-02-26T08:33:44.296-08:002010-02-26T08:33:44.296-08:00

Here is my NGINX configuration for DDOS Attacks to PHP and my lovely NGINX server: nginx.conf user www-data www-data; worker_processes 10; error_log /var/log/nginx/error.log; pid /var/run/nginx.pid; events { worker_connections 1024; } http { include /etc/nginx/mime.types; default_type application/octet-stream; access_log /var/log/nginx/access.log; sendfile on; #keepalive_timeout 0;

mtnoreply@blogger.com0http://vpslife.blogspot.com/2010/02/anti-ddos-nginx-server-configuration.htmltag:blogger.com,1999:blog-8660262373296199534.post-86080732581105572612010-02-01T09:33:00.001-08:002010-02-01T09:33:59.365-08:002010-02-01T09:33:59.365-08:00

lsb_release -a

mtnoreply@blogger.com0http://vpslife.blogspot.com/2010/02/findout-linux-distrubution-name-of-your.htmltag:blogger.com,1999:blog-8660262373296199534.post-41408266805534475482010-02-01T05:38:00.000-08:002010-02-01T05:38:04.488-08:002010-02-01T05:38:04.488-08:00

ln -sf /usr/share/zoneinfo/Europe/Berlin /etc/localtimeIn this command important part is giving the path of your timezone(bold one in example).

mtnoreply@blogger.com0http://vpslife.blogspot.com/2010/02/change-timezone-date-time-on-linux.htmltag:blogger.com,1999:blog-8660262373296199534.post-88027848204598143732010-01-18T14:26:00.000-08:002010-01-18T14:26:46.813-08:002010-01-18T14:26:46.813-08:00

#set | grep EDITOREDITOR=/bin/pico # which vi/usr/bin/vi # export EDITOR=/usr/bin/vi# set | grep EDITOREDITOR=/usr/bin/vi _=EDITOR

mtnoreply@blogger.com0http://vpslife.blogspot.com/2010/01/change-default-editor-on-linux.htmltag:blogger.com,1999:blog-8660262373296199534.post-82422196519194890042009-10-21T08:47:00.000-07:002009-10-21T08:47:28.918-07:002009-10-21T08:47:28.918-07:00

Today I needed to delete files based on date and time: Here is the command I used for deleting file last modified on 21 Oct 2009 16:30: ls -lh | sed -n '/Oct\ 21\ 16:30/p' | awk '{print $9}' >> 1.txt rm -f `cat 1.txt` Explanations:  ls -lh (lists all files) sed -n  '/Oct\ 21\ 16:30/p' (find files at given date from list) awk '{print $9}' (print only file names on list) and >> 1.txt put list of

mtnoreply@blogger.com0http://vpslife.blogspot.com/2009/10/deleting-files-based-on-date-time.htmltag:blogger.com,1999:blog-8660262373296199534.post-16694637371130570142009-10-14T07:23:00.000-07:002009-10-14T07:23:47.609-07:002009-10-14T07:23:47.609-07:00

Sometimes, you may need to move one server to another. At that time, you may use wget command to move your files without any pain. Here is the command for recursive download on ftp via wget: wget -r ftp://username:password@ftp.example.com/ Yes, thats all folks!

mtnoreply@blogger.com0http://vpslife.blogspot.com/2009/10/recursively-download-ftp.htmltag:blogger.com,1999:blog-8660262373296199534.post-76604570849619726902009-10-08T09:48:00.001-07:002009-10-08T09:48:56.760-07:002009-10-08T09:48:56.760-07:00

To list the users in linux you may use following command: cat /etc/passwd | cut -d ":" -f1

mtnoreply@blogger.com0http://vpslife.blogspot.com/2009/10/list-of-users-on-linux.htmltag:blogger.com,1999:blog-8660262373296199534.post-12661064068327158382009-09-16T05:47:00.000-07:002009-09-16T09:11:25.413-07:002009-09-16T09:11:25.413-07:00

Setup is done under a clean Centos 5.2 32bit serveryum -y updateyum -y upgradePART 0###################################################### start with php-5 setup and mysql setup ######################################################yum -y install mysql-server mysql-clientyum -y install php-cgi php-mysql php-curl php-gd php-idn php-pear php-imagick php-imap php-mcrypt php-memcache php-mhash

mtnoreply@blogger.com2http://vpslife.blogspot.com/2009/09/nginx-php-cgi-spawn-fci-ftp-vhosts.htmltag:blogger.com,1999:blog-8660262373296199534.post-65746315866042931572009-09-16T05:36:00.000-07:002009-09-16T05:46:51.576-07:002009-09-16T05:46:51.576-07:00

################################################## setting up a ftp server ## http://vpslife.blogspot.com/ & http://vpswatch.com/#################################################wget ftp://vsftpd.beasts.org/users/cevans/vsftpd-2.2.0.tar.gztar zxvf vsftpd-2.2.0.tar.gzcd vsftpd-2.2.0makeadduser nobodyadduser: user nobody existsmkdir /var/ftp/useradd -d /var/ftp ftp(the next two are useful to

mtnoreply@blogger.com0http://vpslife.blogspot.com/2009/09/setting-up-secure-fast-ftp-server-for.htmltag:blogger.com,1999:blog-8660262373296199534.post-22826406886114137172009-04-04T14:14:00.000-07:002009-04-04T14:23:10.146-07:002009-04-04T14:23:10.146-07:00

This article covers installation of PHP Upload Progress extension.#SETUP guide is done by Mustafa TURAN(http://vpslife.blogspot.com/)##SETUP Software:##--PHP 5.2 or more##--Any OS#Downloadwget http://pecl.php.net/get/uploadprogress-*.tgzUntartar zxvf uploadprogress-*.tgzGo to dircd uploadprogress-*Setupphpize./configuremakemake installLearn php ini pathphp --ini;to ini file add these two lines:[

mtnoreply@blogger.com0http://vpslife.blogspot.com/2009/04/php-uploadprogress-installion.htmltag:blogger.com,1999:blog-8660262373296199534.post-22288303510387299942009-04-04T14:08:00.000-07:002009-04-04T14:11:14.189-07:002009-04-04T14:11:14.189-07:00

Just run the command/etc/webmin/uninstall.shIf you have installed the RPM version of Webmin, you can also use rpm -e webminOr if you have installed the Solaris package you can use pkgrm WSwebminWebmin FAQ: http://www.webmin.com/faq.html

mtnoreply@blogger.com0http://vpslife.blogspot.com/2009/04/how-to-uninstall-webmin.htmltag:blogger.com,1999:blog-8660262373296199534.post-7473428554613430462009-04-04T13:48:00.000-07:002009-04-04T14:11:42.520-07:002009-04-04T14:11:42.520-07:00

Sometimes, we need to uninstall current Apache Mysql PHP collections and re install them. In this article I will show how to remove a LAMP system(for RHEL,Fedora, CENTOS):Check the existence of LAMP system:rpm -qa | grep -i mysqlrpm -qa | grep -i apacherpm -qa | grep -i httpdrpm -qa | grep -i phpIf you get list then remove via rpmrpm -e "file name"or with "yum -y uninstall"yum remove "file

mtnoreply@blogger.com0http://vpslife.blogspot.com/2009/04/how-to-uninstall-lamp.htmltag:blogger.com,1999:blog-8660262373296199534.post-55373107601151048282009-03-17T17:02:00.000-07:002009-03-17T17:44:12.195-07:002009-03-17T17:44:12.195-07:00

Do not use mysql nested queries for performance. Here I will share a little database table and two queries and their response times:#Experiment is done by Mustafa TURAN(http://vpslife.blogspot.com/)##Experiment purpose to see how a nested query affects MYSQL Performance ##Experiment Hardware:##--RAM: 1.5GB##--CPU: AMD Athlon(tm) 64 X2 Dual Core Processor 4000##Experiment Software:##--MYSQL 5(

mtnoreply@blogger.com0http://vpslife.blogspot.com/2009/03/mysql-nested-query-tweak.htmltag:blogger.com,1999:blog-8660262373296199534.post-25379025964178732752009-03-16T14:57:00.000-07:002009-03-16T15:05:47.964-07:002009-03-16T15:05:47.964-07:00

To learn system(hardware,sofware) properties linux has such commands:Operating System Version:uname -rMemory Information:cat /proc/meminfoCPU Information:cat /proc/cpuinfoEasy Way(smart info):uname -rs;less /proc/meminfo grep MemTotal;less /proc/cpuinfo grep"model name"Aktive System Resource Usages:(all users and all activity)top -s(specified user)top -u username

mtnoreply@blogger.com0http://vpslife.blogspot.com/2009/03/how-to-learn-linux-systemhardware.htmltag:blogger.com,1999:blog-8660262373296199534.post-91749351787504759602009-03-15T16:42:00.000-07:002009-03-15T16:50:31.254-07:002009-03-15T16:50:31.254-07:00

On terminal screen apply the commands:vi /etc/sysconfig/networkThen change HOSTNAME=xxxx.xxx line to HOSTNAME=your_desired_hostnameYou have to save the data and quit(thats all!):wq!

mtnoreply@blogger.com0http://vpslife.blogspot.com/2009/03/change-hostname-on-centos-5x.htmltag:blogger.com,1999:blog-8660262373296199534.post-42038403306972254722009-03-10T10:02:00.000-07:002009-03-10T10:11:12.473-07:002009-03-10T10:11:12.473-07:00

Remote mysqldumpRun this one line command as a user:mysqldump --opt --compress --user=REMOTE_DB_USERNAME --password=REMOTE_DB_PASS --host=REMOTE_DB_HOSTNAME REMOTE_DB_NAME mysql --user=LOCAL_DB_USERNAME --password=LOCAL_DB_PASSWORD --host=LOCAL_DB_HOSTNAME -D LOCAL_DB_NAME -C LOCAL_DB_NAME Notes: You have to enable remote mysql on remote computer! (To do this you have to add ip address of local

mtnoreply@blogger.com0http://vpslife.blogspot.com/2009/03/copy-remote-database-to-local-database.htmltag:blogger.com,1999:blog-8660262373296199534.post-4088891922463676532008-10-07T07:18:00.000-07:002008-10-07T07:27:10.025-07:002008-10-07T07:27:10.025-07:00

Pass the root mode on terminal.To stop mysql:# /etc/init.d/mysql stopAccess without privalages to mysql# mysqld_safe --skip-grant-tables &Pass to the mysql# mysql -u root# use mysql;# mysql -u root# mysql>INSERT INTO user (Host, User, Password, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv,

mtnoreply@blogger.com0http://vpslife.blogspot.com/2008/10/how-to-reset-root-password-on-mysql.htmltag:blogger.com,1999:blog-8660262373296199534.post-29053603100142998272008-10-06T09:10:00.000-07:002008-10-06T09:18:56.268-07:002008-10-06T09:18:56.268-07:00

Today I faced a problem about running my stored procedure code and I got the error message :#1436: Thread stack overrun: 4136 bytes used of a 131072 byte stack, and 131072 bytes needed. Use 'mysqld -O thread_stack=#' to specify a bigger stack.I tried the command mysqld -O thread_stack=# but it did not worked. Then I entered my.cnf file which is at /etc/my.cnf I found the value of thread_stack

mtnoreply@blogger.com0http://vpslife.blogspot.com/2008/10/how-to-fix-mysql-threadstack-overrun.htmltag:blogger.com,1999:blog-8660262373296199534.post-51337790966052498912008-10-04T05:51:00.000-07:002008-10-04T06:00:42.227-07:002008-10-04T06:00:42.227-07:00

Configurations will be good for 64Mb - 256Mb RAM If you would like to convert your InnoDB tables to MyISAM, you can use the shell script to automatically convert InnoDB tables to MyISAM. #!/bin/bashMYSQLCMD=mysqlfor db in `echo show databases | $MYSQLCMD | grep -v Database`; do for table in `echo show tables | $MYSQLCMD $db | grep -v Tables_in_`; do TABLE_TYPE=`echo show create

mtnoreply@blogger.com0http://vpslife.blogspot.com/2008/10/low-memory-mysql-apache-configurations.htmltag:blogger.com,1999:blog-8660262373296199534.post-91386340810571937542008-10-02T17:00:00.000-07:002008-10-02T17:05:02.438-07:002008-10-02T17:05:02.438-07:00

Apache Module (mod_php)Most administrations tools (e.g. Plesk) need mod_php in order to work properly.Advantages: * speed * needs less memory (RAM) than CGI * php.ini values can be changed via PHP scripts, vhost files, .htaccess filesDisadvantages: * Scripts are being executed with Apache privileges, which might lead to some security related problems * Only one version of PHP can

mtnoreply@blogger.com0http://vpslife.blogspot.com/2008/10/php-installation-differences-suphp.htmltag:blogger.com,1999:blog-8660262373296199534.post-50458894037351635052008-10-02T16:15:00.000-07:002008-10-02T16:21:18.551-07:002008-10-02T16:21:18.551-07:00

Selecting a database:# mysql USE database;Listing databases:# mysql SHOW DATABASES;Listing tables in a db:# mysql SHOW TABLES;Describing the format of a table:# mysql DESCRIBE table;Creating a database:# mysql CREATE DATABASE db_name;Creating a table:# mysql CREATE TABLE table_name (field1_name TYPE(SIZE), field2_name TYPE(SIZE));# mysql CREATE TABLE pet (name VARCHAR(20), sex CHAR(1), birth DATE

mtnoreply@blogger.com0http://vpslife.blogspot.com/2008/10/mysql-cheat-sheet.html