Andrew Choi

2025
- 二月
2022
- 二月
2021
- 十月
2017
- 十二月
- 七月
- 五月
- 二月
2016
- 十一月
- 三月
- 二月
2015
- 十月
- 九月
2013
- 六月
- 五月
2012
- 六月
- 五月
- 二月
2011
- 十二月
- 十月
- 九月
- 八月
- 七月
  - MySQL IP Sorting Command
    07/26/11
    mysql> SELECT INET_ATON('209.207.224.40');
    -> 3520061480
    
    mysql> SELECT INET_NTOA(3520061480);
    -> '209.207.224.40'
    
    e.g.
    SELECT `ipaddress` FROM `blockip` ORDERBY INET_ATON(`ipaddress`)
  - MailScanner Auto Block and Release IP
    07/14/11
    crontab -e
    0,5,10,15,20,25,30,35,40,45,50,55 * * * * /usr/local/bin/php /opt/mailscanner_sql_blockip.php
    #!/usr/local/bin/php
    <?php
    $linkptr = mysql_pconnect ("192.168.50.172","mailwatch","");
    mysql_select_db("mailscanner",$link
  - Mailscanner maillog SQL auto cleanup script
    07/12/11
    #!/usr/local/bin/php
    <?php
    $host = "localhost";
    $user = "mailwatch";
    $pass = "";
    $db = "mailscanner";
    $linkptr = mysql_pconnect ($host,$user,$pass);
    mysql_select_db($db,$linkptr);
    
    $DATENOW="-3 MONTH&
  - Solaris ps berkley version, 'ps ax'
    07/11/11
    Solaris does support the x option, you're just not using the right ps to get it to work, you need the berkley version;
    
    use /usr/ucb/ps and you'll be able to use the x option.
  - Solaris 10 SendMail service modify SMF for MailScanner
    07/06/11
    # svcadm disable smtp:sendmail
    # cd /lib/svc/method
    # cp smtp-sendmail smtp-sendmail.orig
    # {Editor} smtp-sendmail <- use your Editor Program.
    
    ----------------
    Find
    ----------------
    $SENDMAIL $MODE -q$QUEUEOPTION$QUEUEINTERVAL $OPTIONS &
    ----
- 六月
- 五月
- 四月
- 三月
- 一月
2010
- 十一月
- 十月
- 九月
- 八月
- 七月
2009
- 十一月
- 七月
- 六月
- 五月
- 四月
- 三月
- 二月
- 一月
2008