James's BLOG

FreeBSD FreeTDS MSSQL Connect setting

設定PHP連MSSQL的問題
FreeBSD放在/usr/local/etc/freetds.conf.dist
cp一份新的為freetds.conf再加入設定

ex:
freetds.conf 
[mshost]
    host = 172.0.0.1
    port = 1433
    tds version = 7.0
    client charset = UTF-8

mssql.php
    $ms_host = "mshost"; //172.0.0.1
    $ms_user = "msuser";
    $ms_pass = "mspass";
    $ms_db   = "msdb";

PHP的$ms_host設定要和freetds.conf的括號內名稱一樣, 就可以順利連上MSSQL了.

FreeBSD rsync without symlinks

不想同步軟連結在 -links前加上 --no

rsync [options] --no-links [src] [desc]

FreeBSD rsync

# Local file to Local file
rsync [option]... Source [Source]... Dest
# Local to Remote
rsync [option]... Source [Source]... [user@]host:Dest
rsync [option]... Source [Source]... [user@]host::Dest
# Remote to Local
rsync [option]... [user@]host::Source [Dest]
rsync [option]... [user@]host:SourceDest
rsync [option]... rsync://[user@]host[:PORT]/Source [Dest]