MRBS -- the steps of installation

@安裝
tar zxvf mrbs-1.4.6.tar.gz
cd mrbs-1.4.6
cp -r web /var/www/mrbs
配置timezone。找到config.inc.php文件。去掉$timezone = "XXXXXXX"的註釋，並修改成$timezone = "Asia/Taipei"。
配置數據庫。還是config.inc.php文件。修改以下參數，分別對應數據庫類型、主機、數據庫實例、用戶名、密碼、表前綴。例如：
$dbsys = "mysql";
$db_host = "localhost";
$db_database = "mrbs";
$db_login = "root";
$db_password = 'xxxxxxxx';
$db_tbl_prefix = "mrbs_";
配置用戶授權類型。
在config.inc.php文件的尾部添加$auth["type"]="db";

@配置mysql數據庫
mysql -uroot -p111111
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '111111' WITH GRANT OPTION;
mysql>FLUSH PRIVILEGES;
mysql>CREATE DATABASE `mrbs` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
退出數據庫，返回到mrbs-1.4.6目錄
mysql -uroot -p111111 mrbs < tables.my.sql
mysql -uroot -p111111 mrbs < sample-data.sql
全部部署完畢。

@LDAP的部分，於config.inc.php內增加
$auth["type"] = "ldap";
$ldap_host = "LDAP的IP位址";
$ldap_port = 389;
$ldap_v3 = true;
$ldap_tls = false;
$ldap_base_dn = "DC=abc,DC=com";
$ldap_user_attrib = "sAMAccountName";
$ldap_dn_search_attrib = "sAMAccountName";
$ldap_dn_search_dn = "CN=adminaccount,CN=Users,DC=abc,DC=com";需使用正確的adminaccount帳號的LDAP distinguishedName
$ldap_dn_search_password = "adminpassword";查詢LDAP的adminaccount密碼不能包含$#@等字眼
@訪問http://localhost/mrbs

VMware vSphere 5.1

http://www.vmware.com/files/pdf/products/vsphere/vmware-what-is-new-vsphere51.pdf

OB2D -- Learning (1) -- Installation

OB2D
http://www.phcno1.net/modules/tad_book3/page.php?tbdsn=292

How to use Virtualbox to build a ob2d server.
http://myip.tw/itsmw/index.php?title=Ob2d_2010

1. Download and install Oracle Virtualbox.
2. Settings for ob2d:
    OS:Linux
    Version:bebian
    RAM: 800MB
    HD:10GB

Powershell -- 1st experience

#Set-ExecutionPolicy RemoteSigned

# VMware vSphere PowerCLI

if (((Get-PSSnapin -Name "VMware.VimAutomation.Core" -ErrorAction SilentlyContinue) -eq $null ) -and ((Get-PSSnapin–registered -Name "VMware.VimAutomation.Core") -ne $null))

{

   Write-Host "Adding VMware vSphere PowerCLI" -ForegroundColor Green

   Add-PSSnapin -name VMware.VimAutomation.Core

   ."C:\Program Files (x86)\VMware\Infrastructure\vSphere PowerCLI\Scripts\Initialize-PowerCLIEnvironment.ps1"

}

$vmmodule = Get-PSSnapin -Name "VMware.VimAutomation.Core"

if (!$vmmodule) {

    [System.Reflection.Assembly]::LoadwithPartialName("System.windows.Forms")

    [System.windows.Forms.MessageBox]::Show("We dont got the VM powerCLI module.")

    exit

} else {

    echo "Module $vmmodule loaded successfully"

}

# SSH-Sessions Module load

$sshmodule = Get-Module -List 'SSH-Sessions'

if (!$sshmodule) {

    [System.Reflection.Assembly]::LoadwithPartialName("System.windows.Forms")

    [System.windows.Forms.MessageBox]::Show("We dont got the SSh-Sessions module.")

    exit

} else {

    Import-Module SSH-Sessions

    echo "Module $sshmodule loaded successfully"

}

#Connect to Vcenter

$Viserver = Connect-VIServer -Server 'IP' -User 'username' -Password 'password'

If (!$viserver) {

   [System.Reflection.Assembly]::LoadwithPartialName("System.windows.Forms")

   [System.windows.Forms.MessageBox]::Show("We dont connect to FTvcenter01.")

   exit

} else {

    echo "Connect to vcenter success"

}

Get-VM | Where-Object {$_.PowerState -eq "PoweredOn"} | Where-Object {$_.Name -ne "vcenter"} | Shutdown-VMGuest -Confirm:$false

Start-

#Get-VM

#Start-Sleep -s 600

#Get-VMHost | Stop-VMHost -Confirm:$false

#Get-VMHost

#Start-Sleep -s 300

#SSH to NetApp

$naserver = New-SshSession -ComputerName 'IP for 1st','IP for 2nd' -Username 'username' -Password 'password'

If (!$naserver) {

    [System.Reflection.Assembly]::LoadwithPartialName("System.windows.Forms")

    [System.windows.Forms.MessageBox]::Show("We dont connect to NetApp Controller.")

   exit

} else {

echo "Connect to NetApp Controller success"

}

exit 

#Invoke-Sshcommand -InvokeOnAll -Command 'halt -t 0 -f'

#Invoke-Sshcommand -InvokeOnAll -Command 'ifconfig -a'

#Remove-SshSession -RemoveAll

SQLSchedule

To Backup SQL Express

Features:

• Supports all versions of SQL Server 2000, 2005, and 2008
• Supports unlimited SQL Server instances with an unlimited number of jobs.
• Allows to easily schedule SQL Server maintenance tasks: backups, index rebuilds, integrity checks, etc.
• Runs as Windows Service
• Email notifications on job success and failure
• And more...

http://www.lazycoding.com/products.aspx

LogParser -- (3)

logparser.exe -o:datagrid "SELECT TimeGenerated, Message FROM security WHERE EventID=680 AND Message LIKE 'username'"

PStool GUI

http://www.davitools.com/fepstools/documentation.aspx