Tuesday, February 23, 2010

pair.com (Indonesian)

Cara perhitungan over-usage untuk bandwidth maupun storage :
Bandwidth usage is the total bandwidth used in the month, in 1GB units, after dropping the highest usage day. All other disk, bandwidth, and mailbox usage numbers are calculated as the average daily usage after dropping the highest usage day.
(source: explanation on support-ticket A7V9O5E)

Lihat histori support-ticket:
Support \ View Support Requests

Agar Main Account [e-mail] tidak bisa dikirimi e-mail [sehingga space tidak penuh] :
E-Mail Settings \ Main Account Mailbox Settings \ (main account e-mail address) Delivery :
change from "E-Mail will be stored ..." to "Discard E-Mail"
also change Global E-Mail Delivery from "E-Mail will be stored..." to "Discard E-Mail"

Kita sewa "lahan" (pilihan lihat di www.pair.com/services/web_hosting/) dan selanjutnya lahan tsb bisa di-kavling untuk banyak (ada batasan?) domain dengan biaya setup (one-time) dan biaya bulanan (JIKA ingin domain tsb memiliki IP sendiri)

Untuk setting Outlook, alamat pop dan smtp bisa dilihat di bagian "Your Hosting Package Details" (setelah login ke Account Control Center)

Thursday, February 18, 2010

Packet-sniffing traffic from/to certain IP address

cara packet-sniffing satu workstation saja
www.forummikrotik.com/general-networking/10312-cara-packet-sniffing-satu-workstation-saja.html (Indonesian)

Reconstruct file from captured packet

Google: reconstruct|rebuild file captured traffic|stream

tool for saving files (html, php etc.) from capture
tools mentioned: assniffer

Packet Capture Rebuilding Utility
http://old.nabble.com/Packet-Capture-Rebuilding-Utility-td21699262.html
Utility mentioned on thread:
NetworkMiner (http://sourceforge.net/projects/networkminer/)

Wednesday, February 17, 2010

Identifying file type from its header/signature

FILE SIGNATURES TABLE
www.garykessler.net/library/file_sigs.html

Google: file header list|lookup

Google hacking

www.i-hacked.com/content/view/23/42/

Tuesday, February 16, 2010

Authenticate Wi-fi clients against IAS/Radius

Note that "Domain Computers" is used to authenticate your computer for "machine authentication" which connects your wireless PC before the user even logs in. This is a very usefuland unique benefit of the Windows Wireless Client since it emulates the fullwired experience for wireless users.

If "machine authentication" isn't implemented, group policies and login scripts won't fire off. Furthermore, only cached users can login to the wireless computer, because users who have never signed on to that PC can't authenticate with the domain.

Source:
Ultimate wireless security guide: Microsoft IAS RADIUS for wireless authentication
www.techrepublic.com/article/ultimate-wireless-security-guide-microsoft-ias-radius-for-wireless-authentication/6148579

Self experience on first setup

If computer is joined to domain:
If you never logged on to domain using this computer before and no wired conn is available, you have no choice but to log on using local account first, set up wireless security and then re-log on using domain credential
If you had logged on to domain using this computer before, you should be able to log on now using cached credential then configure wireless app to use Windows user name and password for next reboot (no need to enter credential twice: one for windows logon, one for wireless security)

If computer is not joined to domain:
No problem then...just use the usual username and password then set up wireless security. One drawback with this case, double credential entry seems inevitable (one for wireless security, one for accessing domain shared resources); storing domain credential is not recommended since it can cause account lockout when password is expired

Related article(s)

How to fix iPad and iPhone Wi-Fi problems
http://searchnetworking.techtarget.com.au/articles/41498-How-to-fix-iPad-and-iPhone-Wi-Fi-problems

BlackBerry Curve Smartphone: WPA2-Enterprise
http://supportforums.blackberry.com/t5/BlackBerry-Curve-Smartphone/WPA2-Enterprise/m-p/41249

Ultimate wireless security guide: Self-signed certificates for your RADIUS server
www.techrepublic.com/article/ultimate-wireless-security-guide-self-signed-certificates-for-your-radius-server/6148560

Sniff/capture on a switched network?

When I use Wireshark to capture packets, why do I see only packets to and from my machine, or not see all the traffic I'm expecting to see from or to the machine I'm trying to monitor?
Source: www.wireshark.org/faq.html#promiscsniff

Monday, February 15, 2010

Installing Windows-version Nmap

Download zip file:
http://nmap.org/download.html

Installation instruction:
http://nmap.org/book/inst-windows.html#inst-win-zip

Remember to install nmap_performance.reg

Error "The system cannot execute the specified program" when run nmap.exe:
Install vcredist_x86.exe included
(http://old.nabble.com/help-about-Nmap-td18787064.html)

Evolution vs Creation

Every discovery [of DNA] reveals a new complexity.
Source:
www.newscientist.com/article/mg20126965.800-we-need-a-satisfactory-metaphor-for-dna.html

The complex structure of the living cell was unknown in Darwin's day.
The technology of the twentieth century ... has revealed that the cell is the most complex system mankind has ever confronted.
Source: www.darwinismrefuted.com/molecular_biology_02.html

Tuesday, February 9, 2010

Can I add calculated field/column on Excel pivot based on OLAP cube?

If you want a calculated field in one of the olap cubes you should use MDX expressions. These are defined on the server and are not too difficult to use. The results of the calculations then form part of the OLAP results and can be included in your pivot tables.

No, you can't. See:
Differences between OLAP and non-OLAP PivotTables in Excel
http://support.microsoft.com/kb/234700
especially on "Calculated Fields and Calculated Items" section
* UPDATE * It can be done with Excel 2010 or later (see "EXCEL HOW-TOs" post)

Pivot: Incorrect figure(s) appear in sub/grand total(s)

Description of problem:
Though cell(s) above the sub/grand total clearly shows empty values, the sub/grand total DOES show a non-zero value

Explanation:
It probably caused by structure change(s) on cube (adding new measure, for example)

Solution:
Create new pivot

Sunday, February 7, 2010

2003: Better Terminal Services Manager

Remote Server Administration Tools for Windows 8.1
Related:
How to use RSAT on a not domain-joined Windows 8.1 client
...might needed:
...Fixing - WinRM Firewall exception rule not working when Internet Connection Type is ... Public
...succeeded but still can't open RDS node (to shadow user session) with error :
..."You are currently logged on as local administrator ..."
Remote Server Administration Tools (RSAT) for Windows Client and Windows Server

TSAdminEx Beta release
www.remkoweijnen.nl/blog/2009/02/20/tsadminex-beta-release/

Terminal Server Utility
http://terminalserverutility.vsdotnet.ch/
*UPDATE: link is dead

Thursday, February 4, 2010

BA: Generated DTS tasks execution throws strange errors

By "strange errors", I mean kind of error messages that make us think that the DTS package contain invalid commands/syntax.

Thing(s) to check when it happens:
1)
Inside NAV, you've deleted a cube definition but forgot to delete dimension(s) related with that cube
2)
...

Wednesday, February 3, 2010

4.0: Accessing pivot table using NAV form

We cannot put the control/OCX directly on the form.
As the Application Developer Guide (section 19.2) says:
Only non-visual controls are supported.

What about "Navision Pivot Table v2" available on Mibuso?
It utilizes a custom-made DLL to display the pivot grid.
It only supports connection using SQL query, no support to Provider=MSOLAP

2003: Creating HTML version of Excel sheet containing pivot table

Select cells containing pivot table.
File > Save as Web Page.
On Save As dialog:
- Save: "Selection: PivotTable"
- Check "Add interactivity"
- Click "Publish...":
-- Add interactivity with: PivotTable functionality

Note:
When the HTML is opened, the layout will always be the same (as the first time the excel file is saved-as HTML), user's changes while using it won't be retained.