SELECT email,COUNT(email) AS NumOccurrencesFROM usersGROUP BY emailHAVING ( COUNT(email) > 1 )
SELECT emailFROM usersGROUP BY emailHAVING ( COUNT(email) = 1 )
If you guys looking for an iOS app which can connect via SSH to your NIX servers, here’s your answer 
Link : http://itunes.apple.com/us/app/prompt/id421507115?mt=8
More Info : https://www.panic.com/blog/2011/04/introducing-prompt-ssh-for-ios/
Default partition size for /var normally not enough to store databases, so we need to store it somewhere bigger (/usr). The steps will show how to transfer database from /var/db/mysql (default path installation for MySQL in FreeBSD) to /usr/local/mysql/data (suggested path). Steps as follows :-
DONE!
Some of my friends asked how my squid.conf looks like. Here’s how it looks like. Feel free to comment so that i can improve on the configuration
[root@squid ~]# cat /usr/local/etc/squid/squid.conf
P/S : The service is listening on port 5190 so please make sure the firewall allows it.
Official Site : http://bjango.com/apps/istat/
More info : http://www.google.com.my/search?client=safari&rls=en&q=istats+remote+monitoring&ie=UTF-8&oe=UTF-8&redir_esc=&ei=NN37S9ftMI-trAfhz-GuAg
There are 2 ways u can do this. For example if u want to delete directory older than 7 days :
First method :
find /path/dir -type d -mtime +7 -exec rm -rf {} \;
Second method :
find /path/dir -type d -mtime +7 | xargs rm -rf {} \;
You can always change the +7 value to any number of days preferred.
FYI, this command is only for directory deletion, if u want to delete files, u can change the “-type d” (d means directory) to “-type f” (f means files).
Example :
find /path/dir/unl.txt -type f -mtime +7 | xargs rm -f {} \;
P/S : There’s an alternative command which we can use, tmpwatch (more info : http://linux.about.com/library/cmd/blcmdl8_tmpwatch.htm)
Running Ubuntu 10.04 & Fedora 12 on Mac OSX Snow Leopard via Parallels Desktop. Cool huh~!
mod_dosevasive is an evasive maneuvers module for Apache to provide evasive action in the event of an HTTP DoS or DDoS attack or brute force attack. It is also designed to be a detection and network management tool, and can be easily configured to talk to ipchains, firewalls, routers, and etcetera. mod_dosevasive presently reports abuses via email and syslog facilities.
Open the config file (/usr/local/etc/proftpd.conf)
add these lines into the config
<Global> IdentLookups off </Global> UseReverseDNS off
and restart your proFTPd services. Tadaa~!
Ubuntu 9.10 - Karmic Koala running on Snow Leopard Parallels Desktop
Recent Comments