壹電視 於12/28日正式開台, 因沒通過 NCC 那一關, 就大手筆地送網樂通 STB 給大家
申請網樂通 (需付 65 元運費, 線上刷卡)
目前只兩個頻道: 壹新聞、壹綜合, 到 1/31 包月電影院免費
限制級預設內容保護密碼: 0282
必需打電話去做開通動作, 會問你 STB 後面的序號及 MAC, 等五分鐘後重開 STB 即可,
第一次開機會做更新的動作
抓了封包來看, 不管是 Live 頻道或 VOD, 都有用到 P2P,
而且上傳速率愈大, 上傳就用得愈多, 經測試要看得順的話最小上傳速率要 64Kbps
STB 開機大概要一分鐘, 應該還有改善的空間
耗電是 5W, 按搖控器的關機感覺只是待機, 把輸出關掉, 耗電是一樣是 5W
根據 STB MAC 前三碼(24:cf:21), Shenzhen State Micro Technology Co., Ltd
應該是大陸這家公司做的 深圳国微技术有限公司
ref. 壹電視 網樂通 試玩報告
2011-01-23 Update: 所有的電影到三月底前免費收看。
網樂通的搖控器實在有夠難用
BuildWidth 可以偵測網站用什麼 OS, 用什麼 Web Server, 用什麼 CMS, 用什麼語言...等資訊
MySQL 5.5 已在 12/15 時 GA
以下環境為 CentOS 5.5 x64
備份資料
把資料庫目錄先搬到其他地方, 讓安裝 RPM 時重建 msyql db, 因為 5.5 有多了一些 table, 例如 slow_log
停止 MySQL Service
service mysql stop
移除 MySQL 舊版 RPM
rpm -qa | grep -i '^mysql-' | xargs rpm --nodeps -ev
下載官方 MySQL 5.5.8 RPM
wget http://mysql.cdpa.nsysu.edu.tw/Downloads/MySQL-5.5/MySQL-client-5.5.8-1.rhel5.x86_64.rpm
wget http://mysql.cdpa.nsysu.edu.tw/Downloads/MySQL-5.5/MySQL-devel-5.5.8-1.rhel5.x86_64.rpm
wget http://mysql.cdpa.nsysu.edu.tw/Downloads/MySQL-5.5/MySQL-server-5.5.8-1.rhel5.x86_64.rpm
wget http://mysql.cdpa.nsysu.edu.tw/Downloads/MySQL-5.5/MySQL-shared-5.5.8-1.rhel5.x86_64.rpm
wget http://mysql.cdpa.nsysu.edu.tw/Downloads/MySQL-5.5/MySQL-shared-compat-5.5.8-1.rhel5.x86_64.rpm
wget http://mysql.cdpa.nsysu.edu.tw/Downloads/MySQL-5.5/MySQL-test-5.5.8-1.rhel5.x86_64.rpm
安裝 MySQL 5.5.8
rpm -ivh MySQL*
把所需的資料庫目錄搬回
啟動 MySQL 5.5
service mysql start
升級後檢查 Tables
mysql_upgrade
最後會遇到幾行 SQL syntax error, 不過不影響
ERROR 1064 (42000) at line 31: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14), Table_priv set('Select','Insert','Update','Delete','Create','Drop','Grant'' at line 1
ERROR 1064 (42000) at line 33: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14), Column_priv set('Select','Insert','Update','References') COLLATE utf8_gene' at line 1
ERROR 1064 (42000) at line 65: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14), PRIMARY KEY (Host,Db,User,Routine_name,Routine_type), KEY Grantor (Grantor' at line 1
ERROR 1064 (42000) at line 417: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) AFTER Proc_priv' at line 2
以下是用 rpm -U 時會出現的提示畫面
******************************************************************
A MySQL server package (MySQL-server-community-5.1.54-1.rhel5) is installed.
Upgrading directly from MySQL 5.1 to MySQL 5.5 may not
be safe in all cases. A manual dump and restore using mysqldump is
recommended. It is important to review the MySQL manual's Upgrading
section for version-specific incompatibilities.
A manual upgrade is required.
- Ensure that you have a complete, working backup of your data and my.cnf
files
- Shut down the MySQL server cleanly
- Remove the existing MySQL packages. Usually this command will
list the packages you should remove:
rpm -qa | grep -i '^mysql-'
You may choose to use 'rpm --nodeps -ev
the package which contains the mysqlclient shared library. The
library will be reinstalled by the MySQL-shared-compat package.
- Install the new MySQL packages supplied by Oracle and/or its affiliates
- Ensure that the MySQL server is started
- Run the 'mysql_upgrade' program
This is a brief description of the upgrade process. Important details
can be found in the MySQL manual, in the Upgrading section.
******************************************************************
2010 中區資訊展 12/17(五)~12/22(三) 上午10點到下午6點
水湳機場展館2號入口 威達雲端電訊(A234)
新版的 VLC 送 Multicast 的選項有點難找, 做個簡單的教學
以下的畫面是 1.1.5 版
Multicast 傳送端 (Sender)
選擇 「Advancded Open File...」
按「Add」加入檔案, 然後選擇「串流」
按「下一項」
選擇「RTP / MPEG Transport Stream」, 按「增加」
輸入 Multicast Address, Port
如果有跨 Router 需輸入 TTL
接收端 (Reciever)
選擇開啟網路串流
輸入 URL
以下 Script 僅在 CentOS 5.5 x64 測試過, 其他 distro 可能需作調整
前幾行變數, 請調整成自己的環境
for Master NIS
NISDOMAIN=pank.org
MASTER=yp1.pank.org
SLAVE=yp2.pank.org
NETWORK=192.168.6.0
NETMASK=255.255.255.0
yum -y install portmap ypbind yp-tools ypserv
nisdomainname $NISDOMAIN
echo NISDOMAIN=$NISDOMAIN >> /etc/sysconfig/network
echo $NETMASK $NETWORK >> /var/yp/securenets
echo $SLAVE > /var/yp/ypservers
/etc/init.d/portmap start
/etc/init.d/ypserv start
/etc/init.d/yppasswdd start
/etc/init.d/ypxfrd start
/usr/lib64/yp/ypinit -m
cd /var/yp
make
for Slave NIS
NISDOMAIN=pank.org
MASTER=yp1.pank.org
SLAVE=yp2.pank.org
NETWORK=192.168.6.0
NETMASK=255.255.255.0
yum -y install portmap ypbind yp-tools ypserv
nisdomainname $NISDOMAIN
echo NISDOMAIN=$NISDOMAIN >> /etc/sysconfig/network
echo $NETMASK $NETWORK >> /var/yp/securenets
/etc/init.d/portmap start
/etc/init.d/ybind start
/etc/init.d/ypserv start
/etc/init.d/yppasswdd start
/etc/init.d/ypxfrd start
/usr/lib64/yp/ypinit -s $MASTER
/etc/init.d/ypserv restart
for NIS client
NISDOMAIN=pank.org
MASTER=yp1.pank.org
SLAVE=yp2.pank.org
yum -y ypbind
echo NISDOMAIN=$NISDOMAIN >> /etc/sysconfig/network
nisdomainname $NISDOMAIN
echo domain $NISDOMAIN >> /etc/yp.conf
echo ypserver $MASTER >> /etc/yp.conf
echo ypserver $SLAVE >> /etc/yp.conf
/etc/init.d/portmap restart
/etc/init.d/ypbind start
若要在 Client 端用 yppasswd 改密碼時立即 Update 資料
在 /usr/lib64/yp/pwupdate 最後加一行
/etc/init.d/ypserv restart > /dev/null
Recent Comments