Power的部落格

vi /etc/sysconfig/network-scripts/ifup-eth

註解掉下面的内容,然后再執行ifup eth0

改為

vi /etc/sysconfig/iptables

# Firewall configuration written by system-config-firewall
# Manual customization of this file is not recommended.
*filter

:INPUT DROP [0:0]
:FORWARD DROP [0:0]
:OUTPUT ACCEPT [0:0]

-A INPUT -m state –state ESTABLISHED,RELATED -j ACCEPT
-A INPUT -p icmp -j ACCEPT
-A INPUT -i lo -j ACCEPT

-A INPUT -i eth0 -p tcp –dport 20:21 -j ACCEPT #vsftpd
-A INPUT -i eth0 -p tcp –dport 22 -j ACCEPT
-A INPUT -i eth0 -p tcp –dport 25 -j ACCEPT #postfix
-A INPUT -i eth0 -p tcp –dport 80 -j ACCEPT
-A INPUT -i eth0 -p tcp –dport 110 -j ACCEPT #postfix
-A INPUT -i eth0 -p tcp –dport 143 -j ACCEPT #postfix
-A INPUT -i eth0 -p tcp –dport 65400:65410 -j ACCEPT #vsftpd

-A INPUT -i eth0 -m state –state RELATED,RELATED -j ACCEPT
-A INPUT -i eth0 -m state –state NEW,INVALID -j DROP

#-A INPUT -m state –state NEW -m tcp -p tcp –dport 22 -j ACCEPT
#-A INPUT -m state –state NEW -m tcp -p tcp –dport 80 -j ACCEPT
#-A INPUT -m state –state NEW -m tcp -p tcp –dport 25 -j ACCEPT
#-A INPUT -m state –state NEW -m tcp -p tcp –dport 110 -j ACCEPT
#-A INPUT -m state –state NEW -m tcp -p tcp –dport 143 -j ACCEPT
#-A INPUT -j REJECT –reject-with icmp-host-prohibited
#-A FORWARD -j REJECT –reject-with icmp-host-prohibited

COMMIT

chkconfig –list |grep iptables

iptables        0:關閉  1:關閉  2:開啟  3:開啟  4:開啟  5:開啟 6:關閉

/etc/rc.d/init.d/iptables start           //啟動 iptables 服務
/etc/rc.d/init.d/iptables stop            //停止 iptables 服務
/etc/rc.d/init.d/iptables restart         //重新啟動 iptables 服務
/etc/rc.d/init.d/iptables status          //查看目前 iptables 規則
/etc/rc.d/init.d/iptables save            //將目前規則存入 iptables 設定檔

telnet: > telnet localhost pop3
telnet: Trying 192.168.1.X
telnet: Connected to pop.example.com.
telnet: Escape character is ‘^]’.
server: +OK InterMail POP3 server ready.
client: USER MyUsername
server: +OK please send PASS command
client: PASS MyPassword
server: +OK MyUsername is welcome here
client: LIST
server: +OK 1 messages
server: 1 1801
server: .
client: RETR 1
server: +OK 1801 octets
server: Return-Path: sender@example.com
server: Received: from client.example.com ([192.0.2.1])
server:        by mx1.example.com with ESMTP
server:        id <20040120203404.CCCC18555.mx1.example.com@client.example.com>
server:        for <recipient@example.com>; Tue, 20 Jan 2004 22:34:24 +0200
server: From: sender@example.com
server: Subject: Test message
server: To: recipient@example.com
server: Message-Id: <20040120203404.CCCC18555.mx1.example.com@client.example.com>
server:
server: This is a test message.
server: .
client: DELE 1
server: +OK
client: quit
server: +OK MyUsername InterMail POP3 server signing off.

useradd USERNAME       增加一名為USERNAME的帳號
userdel USERNAME        刪除USERNAME這個帳號

[root@localhost ~]# useradd power

"useradd" 跟 "userdel" 這兩個指令都只有 root 可以使用

passwd [USERNAME]    更改USERNAME的密碼，若無參數，則改自己的密碼。

[root@localhost ~]# passwd power
Changing password for user power
New UNIX password:
Retype new UNIX password:
passwd: all authentication tokens updated successfully

finger USERNAME[@HOSTNAME]    查詢使用者資料
[root@localhost ~]# finger power  

chfn [USERNAME]        更動使用者USERNAME的資料，若無參數，則改自己的資料。

#vi /etc/sysconfig/network-scripts/ifcfg-eth0

DEVICE=eth0 //網卡的代號

BOOTPROTO=no //是否使用 dhcp

HWADDR=00:1e:8c:1e:64:4f //網卡卡號(MAC)

IPADDR=192.168.1.70 //IP位址

NETMASK=255.255.255.0 //網路遮罩

ONBOOT=yes //是否預設啟動此介面

GATEWAY=192.168.1.1 //通訊閘

NM_CONTROLLED=yes //額外的網管軟體

DNS1=168.95.1.1

DNS2=8.8.8.8

檢視網卡狀態
#ifconfig

啟動與關閉網卡
#ifup eth0
#ifdown eth0

安裝 EPEL 後，幾乎所有套件都可以直接從 yum 安裝

Step 1：
# wget http://dl.fedoraproject.org/pub/epel/6/i386/epel-release-6-8.noarch.rpm

Step 2：
# rpm -ivh epel-release-6-8.noarch.rpm //安裝取得的rpm檔案

Step 3：
# yum update    //更新yum的資源庫

Step 4：
PHP 連 MSSQL要裝三個套件
unixODBC
php-mssql
freetds
執行 yum insatll php-mssql 他會依套件相依性，會自動幫你安裝其他兩個！
# yum install php-mssql //安裝php-mssql

Step 5：
# service httpd restart    //重啟apache伺服器

常見問題：
SQLSTATE[HY000] Unable to connect: Adaptive Server is unavailable or does not exist (severity 9) 提示伺服器不存在
查看host, port是否有誤？是否是被selinux阻擋？
如果是後面一個原因，暫時的處理辦法就是先關掉，關掉方法如下：
打開 /etc/selinux/config ，將SELINUX設置為disabled，然後重新啟動，再試試看，基本就沒什麼問題了。

vi /etc/selinux/config
SELINUX=disabled

參考文件
http://www.pigo.idv.tw/archives/1336
http://blog.csdn.net/chenjiebin/article/details/7278304

資料庫連線測試：使用 PDO
try {
$hostname = "192.168.1.100″;
$port = "1433″;
$dbname = "PG";
$username = "user";
$pw = "123456″;
$dbh = new PDO ("dblib:host=$hostname:$port;dbname=$dbname","$username","$pw");
} catch (PDOException $e) {
echo "DB Error:" . $e->getMessage() . "\n";
exit;
}

$stmt = $dbh->prepare("SELECT * FROM users");
$stmt->execute();
while ($row = $stmt->fetch())
{
print_r($row);
}

解決寫入簡體中文出現亂碼：

1. 把欄位的屬性設定成nvarchar、ntext。
2. 寫入的內容前加上’N‘
   例 INSERT INTO MyTable (content) VALUES ( N‘簡體或亂碼的內容’ )