Wednesday, May 31, 2017

see outlook email details include internet headers

1) double click the email in outlook
2) click file menu in top
3) make sure info is selected in left menu list
4) click the Properties button in right side
5)  open up the properties window include all information we need to check

Thursday, May 18, 2017

simulate http post with difference tools

1)curl
1       curl -A "Mozilla/5.0" -verbose -X POST http://xxx.yyy.com/Sale/BillOfSaleExport --ntlm --negotiate -u domain\\Test.msmanager1:Password -d@data1.txt --trace log1.log
2   2)wget
w   wget -d -S --post-file=data_sale_bill1.txt --http-user=domain\\Test.msmanager1 --http-password=Password http://xxx.yyy.com/Sale/BillOfSaleExport
3     3)FireFox with Firebug
c    change the request header and body make sure they are match the log from curl/wget,we will get same binary data as curl and wget, since NTLM/kerberos need noegiate, so user will get two time 401 http code, finally get 200 code and data back.



p

44) SOAPUI
55) other browser like chrome/IE



3

3

Monday, May 15, 2017

oracle db table lock

in oracle db, some time we need lock a table for long time db update, here is the command
lock table table_name in exclusive mode;

after update, we need commit or rollbak to release the lock

other application can use following code to check the lock

SELECT
    B.Owner,
    B.Object_Name,
    A.*
FROM
    V$Locked_Object A,
    All_Objects B
WHERE
    A.Object_ID = B.Object_ID and A.OBJECT_ID=1211103;

object_id is the table's object_id in table all_objects

create a short name for long name executable file in windows 7 64bit

when create a  link for executable file in 64bits windows, we should use hard link
ln -P "notepad++.exe" npp.exe

sybbolic linked will result a error says unsupported 16 bits application

Thursday, May 11, 2017

Format xml output from curl

curl -s http://localhost:8983/solr/gettingstarted/select?q=video |tidy -xml -i -