按月存檔:十一月 2012

IT線上客服/ IT MSN customer service


 






當你不想讓別人加入你的MSN,反之你也不想加別人時,如何在公私之間取得平衡??
這是一個很好的解決方案
只要做個連結在網站上,讓大家可以透過網頁與你聯繫即可
想要試嗎?
點選上面的MSN ICON即可與我對談 (大概因為在部落格裡的語法,無法對齊)

居家即渡假

請觀看我們騎腳踏車那一段(DORA1),居家即渡假

多年以前 一直在尋找2HOME 另一個休閒住所

後來乾脆搬來田邊住 享受居家即渡假的美好時光

[SlideDeck2 id=325]

Pfsense SIP PROXY DEMO

[wpfilebase tag=file id=53 tpl=filebrowser /]

意外的發現,如果用PFSENSE外掛的套件來安裝SIP PROXY,它已內建提供簡單的設定界面來使用!!

這是一個簡單的DEMO

裝好SIP PROXY後,使用簡單的SIP PHONE來使用

OK,用途

讓兩地的人,可以用網路互通電話

那如果是公司的應用呢

然後又想讓在外面的人可以節省手機費用

可以在電話交換機及SIP PROXY間架一台VOICE GATEWAY

然後此VOICE GATEWAY再註冊到SIP PROXY

這樣應該就可以用IP電話再下車一般電話

How to let your Openmeetings authenticate with AD account and password? 如何使openmeetings系統可用AD帳號登入??

First of all, you should edit a file to prepare for upload to Openmeetings.

Please updates the information as below and save it as a file. choosing a file name whatever you like to save.

below is a sample, please especially notice those sections in red. and change your local environmental parameters.

#ConfigurationFile for LDAP Auth
#ConfigKey ‘ldap_config_path’ must be set in DataBase Configration of OM and point to this file
#o.becherer,14.01.2009

#specify the LDAP Server type
ldap_server_type=AD
#ldap_server_type=ActiveDirectory
#LDAP URL
# This is the URL used to access your LDAP server.
ldap_conn_url=ldap://Your_IP_Address_change_here:389

#Login distinguished name (DN) for Authentification on LDAP Server – keep emtpy if not required

#once your administrator account is admin, and AD domain URL is test.com
ldap_admin_dn=CN:admin,CN:Users,DC:TEST,DC:COM

#Loginpass for Authentification on LDAP Server – keep emtpy if not requiered
ldap_passwd= input_your_admin_password_here

#base to search for userdata(of user, that wants to login)
ldap_search_base=DC:TEST,DC:COM

# Fieldnames (can differ between Ldap servers)
field_user_principal=userPrincipalName
#field_user_principal=sAMAccountName
# Ldap auth type(SIMPLE,NONE)
ldap_auth_type=SIMPLE

# Ldap-password synchronization to OM DB
ldap_sync_password_to_om=no
# Ldap user attributes mapping
# Set the following internal OM user attributes to their corresponding Ldap-attribute
ldap_user_attr_lastname=sn
ldap_user_attr_firstname=givenName
ldap_user_attr_mail=mail
ldap_user_attr_street=streetAddress
ldap_user_attr_additionalname=description
ldap_user_attr_fax=facsimileTelephoneNumber
ldap_user_attr_zip=postalCode
ldap_user_attr_country=co
ldap_user_attr_town=l
ldap_user_attr_phone=telephoneNumber

and then, find the configuration section on your administrative interface of openmeetings as below image:

upload your saved file, and suggest you select “add domain to username”, and input your domain over there, in this example, test.com on it.

if you select this, your user don’t need to input domain name behind ad account like this username@test.com.

How to rebuild mysql replication once it disasters? 如何重建MYSQL資料庫複製?

由於我的SLAVE MYSQL是不經常開機的PC,偶爾未正常關閉SLAVE,就會有同步異常的現象發生

Due to my slave mysql located at my PC that’s not always persistent online, sometimes, I forget to shutdown slave normally, and then sync job will occur error.

當你show slave status G;時,沒看到兩個YES, 就是出問題了

when you execute show slave status G; on Slave, you did not see two lines “YES”, it should be gotten problems between master and slave.

下圖是正常的狀況,當出問題時,可能其中一個會變NO

Below image shows you a normal situation, you can see two lines “YES”, once one of it turns into “NO”, you should got any problem on your Mysql replication.

 

 

 

 

 

 

那發生問題時,怎麼辦呢? 以下是處理的步驟

And once happen, how can you do? below is some procedures for your reference.

在SLAVE機台上的mysql console,執行以下步驟:

on Slave Mysql console, please follow up the procedures as below.

1. STOP SLAVE;

2. RESET SLAVE;

3. 停止MYSQL服務

after stop and reset slave, please shutdown your Mysql service on your slave side.

在MASTER的機台上, DUMP一次資料庫,如下圖指令:

and on your Master, dump all of the databases you would like to replicate as below image.

然後把它LOAD回SLAVE裡,如下圖

and then load it into Slave as below.

在SLAVE上的MYSQL CONSOLE,再輸入以下指令:

and then on the Mysql Console of Slave, execute the command as below.

CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
MASTER_USER=<user>, MASTER_PASSWORD=<password> ;

where you replace <host>, <user>, <password> by quoted strings and
<port> by the master’s port number (3306 by default).

Example:

CHANGE MASTER TO MASTER_HOST=’125.564.12.1′, MASTER_PORT=3306, MASTER_USER=’joe’, MASTER_PASSWORD=’secret’;

然後, 重新啟動複製

and then, restart replication.

start slave;

一切即恢復正常

and finally, You should get your mysql replication back to normal.

another way is you use phpmyadmin to bypass the error, and reload your slave.