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 build PHP with MySQL functionality. [...]

You are running an ASP or ASP.NET web application on IIS on Windows 2008 R2 from a remote web browser and you constantly see following error message. While this is the proper results for a production server (you never want to show remote users the details of an error), it is not helpful while testing [...]

Run #/usr/local/directadmin/scripts/fstab.sh

ต้องเพิ่ม Code นี้เข้าไปใน Header X-Confirm-Reading-To: email@email.com คือ Auto Confirm Reading Disposition-Notification-To: email@email.com หรือ Return-Receipt-To: email@email.com คือ Confirm Delivery อ้างอิง : http://en.wikipedia.org/wiki/Email_tracking

tcpkill came with the dsniff in Debian/Ubuntu, you need to install it manually. # sudo apt-get install dsniff    ( Ubuntu ) # yum -y install dsniff    ( CentOS ) Usages: 1. Kill all outgoing web (port 80) connection: # tcpkill -i eth0 port 80 2. Kill all connection by IP # tcpkill -i eth0 host [...]

it may already be enabled as scsi says. i’m not sure how experienced you are with modrewrite if you are experienced with it please ignore the following. i’m not an expert on modrewrite but you can try this: change in your httpd.conf : allowoverride None to allowoverride All make a .htaccess file in the directory [...]

command-line PHP error Getting this every time i run Drush or anything else PHP on the command line: PHP Warning: PHP Startup: Unable to load dynamic library ‘/usr/lib/php5/20090626/sqlite.so’ – /usr/lib/php5/20090626/sqlite.so: cannot open shared object file: No such file or directory in Unknown on line 0 Fix: sudo rm /etc/php5/conf.d/sqlite.ini อ้างอิง : http://data.agaric.com/php-warning-unable-load-dynamic-library-sqliteso

213.171.222.48 173.19.0.10 64.31.56.219 203.238.190.19 173.19.0.109 208.106.56.33 223.207.88.24 49.49.80.112 31.24.207.138 113.110.189.63 46.166.135.207 113.116.216.146 194.75.205.149 77.95.228.11 194.75.205.149 77.95.228.11 31.24.207.138 211.90.241.58 200.207.9.0/24 200.207.9.236 218.204.61.0/24 218.204.61.243 217.70.39.155 218.80.215.216 64.220.94.194 81.149.59.67 218.80.0.0/16 95.143.198.47 218.80.215.216 208.106.56.33 223.207.88.24 49.49.80.112 31.24.207.138 113.110.189.63 46.166.135.207 113.116.216.146 194.75.205.149 77.95.228.111 94.75.205.149 77.95.228.11 31.24.207.138 211.90.241.58 200.207.9.0/24 200.207.9.236 218.204.61.0/24 218.204.61.243 217.70.39.155 218.80.215.216 64.220.94.194 81.149.59.67 218.80.0.0/16 95.143.198.47 218.80.215.216 64.220.94.194 95.171.126.17 [...]

#pecl install json   or   /usr/local/bin/pecl install json อ้างอิง : http://www.directadmin.com/forum/showthread.php?t=14348 ######################### ถ้าเจอะ Error #pecl install zip downloading zip-1.8.0.tgz … Starting to download zip-1.8.0.tgz (59,749 bytes) …………..done: 59,749 bytes 58 source files, building running: phpize Configuring for: PHP Api Version: 20041225 Zend Module Api No: 20050922 Zend Extension Api No: 220051025 /usr/local/bin/phpize: /tmp/tmpnkcW3i/zip-1.8.0/build/shtool: /bin/sh: bad interpreter: [...]

Netstat is an extremely useful Linux command line tool that allows you to check which service is connecting to a port on your machine. It is very useful to analyze what’s going on on your machine when you are facing or trying to to prevent an attack on it. You can find information such as how [...]

NETSTAT.exe TCP/IP Network Statistics Displays protocol statistics and current TCP/IP network connections. NETSTAT [-a] [-e] [-n] [-s] [-p proto] [-r] [interval] -a Displays all connections and listening ports. -e Displays Ethernet statistics. This may be combined with the -s option. -n Displays addresses and port numbers in numerical form. -p proto Shows connections for the [...]

สามารถดูได้จาก Link นี้    http://www.computerhope.com/msdos.htm

at ->  Schedule commands and programs to run at a specified time/date. finger -> Display user information on a system running the finger service. hostname  -> Print the name of the current host. ipconfig  ->Display/refresh network configuration settings for network adapters. nbtstat  -> Display system NetBIOS information. net continue ->Resume a paused service. net file [...]

In this tutorial I will describe how to install and configure mod_deflate on an Apache2 web server. mod_deflate allows Apache2 to compress files and deliver them to clients (e.g. browsers) that can handle compressed content which most modern browsers do. Withmod_deflate, you can compress HTML, text or XML files to approx. 20 – 30% of their original sizes, thus [...]

#swapoff -a   //Off Swap #swapon -a   // On Swap อ้างอิง : http://www.commandlinefu.com/commands/view/1665/clean-swap-area-after-using-a-memory-hogging-application

This command will delete one specific email from the mailq (taken from the postsuper man page) mailq | tail +2 | grep -v ‘^ *(‘ | awk  ’BEGIN { RS = “” } { if ($8 == “email@address.com” && $9 == “”) print $1 } ‘ | tr -d ‘*!’ | postsuper -d – I [...]

Traditionally you use the “sendmail -q” command to flush mail queue under Sendmail MTA. Under Postfix MTA, just enter the following command to flush the mail queue: # postfix flush OR # postfix -f To see mail queue, enter: # mailq To remove all mail from the queue, enter: # postsuper -d ALL To remove [...]

ใน ClearOS เวลา ServiceEmail มีปัญหาจะพบอาการสั่ง Start Service POP/IMAP ใน ControlPanel ไม่ได้บ่อยๆ ขั้นแรกตรวจสอบคิวเมล์ว่าเยอะแค่ไหนอาจจะโดน Spam คิวเยอะจัดจน Service หยุดทำงานไปได้แต่เมื่อแก้ไขแล้วก้จะยังไม่สามารถ Start POP/IMAP ได้ ต้องใช้คำสั่ง #ldapsync แต่ถ้ายังไม่ได้อีกให้ใช้คำสั่ง #service cyrus-imapd restart แล้วลองไปดูใน POP/IMAP ของ ControlPanel อีกครั้ง อ้างอิง : http://www.clearfoundation.com/component/option,com_kunena/Itemid,232/catid,14/func,view/id,4097/