Sunday, December 7, 2014

Batch file to resolve DNS name to IP address and add (or update) it to HOSTS file


Firefox: Can't find "Load images automatically" setting

In Firefox 23 and later you no longer have the "Load images automatically" setting
There is a setting in "Tools > Page Info > Permissions" for individual domains
source: Permissions.default.image

Friday, December 5, 2014

HTTrack related

Default behaviour:

Imagine you want to capture the following site:
www.someweb.com/gallery/flowers/

HTTrack, by default, will capture all links encountered in www.someweb.com/gallery/flowers/ or in lower directories, like www.someweb.com/gallery/flowers/roses/.
It will not follow links to other websites, because this behaviour might cause to capture the Web entirely!
It will NOT follow links located in higher directories, too (for example, www.someweb.com/gallery/flowers/ itself) because this might cause to capture too much data.

This is the default behaviour of HTTrack
source: FAQ
---

A list of filters works from least important to most important (latter filters take precedence over previous filters)
source: Filters (section: Priorities)
---

Howto tell httrack to start finishing .tmp files?

You can cancel the mirror (WinHTTrack or WebHTTrack versions only), and let all pending downloads to be finished. Then, httrack will move all tmp files into regular ones.
---


Mirror specific thread on forum website
Example:
http://www.website.com/printthread.php?t=24680&page=1
http://www.website.com/printthread.php?t=24680&page=2
etc.

Scan rules:
-*
+*t=24680*
---


How to log into the Blitz Research website
http://httrack.kauler.com/help/CatchURL_tutorial

Note to self:
Didn't work with Hotmail
Error on Firefox7:
Firefox is configured to use a proxy server that is refusing connections
---

Thursday, November 13, 2014

Terkait operator seluler

4G yang Merugikan
ternyata taraaaaaa Pulsa Rp 0;. Saya telpon Customer Service Si Kuning menanyakan hal itu, dan ternyata jawaban dari CS terebut bahwa penggunaan akses data di jaringan bukan 4G
ika SmartPhone Anda Dual SIM/Kartu Ganda, ada baiknya Anda membeli Kartu Perdana baru khusus untuk paket internet saja, jangan menggunakan Nomor utama untuk daftar paket Internet. Karena kuatir Nomor Anda tidak bisa dihubungi melalui telpon saat pengaturan jaringan di 4G Only.

Cara Menambah Atau Memperpanjang Masa Aktif Kartu Tri Dengan Voucher Masa Aktif
Masa aktif bakal langsung diperpanjang dari masa aktif terakhir kartu tri Anda.
(jadi bukan dari tanggal memasukkan kode voucher)
Voucher masa aktif ini bersifat akumulatif, jadi Anda bisa sekaligus mengaktifkan 2 voucher untuk mendapatkan penambahan masa aktif selama 8 bulan. Tidak ada aturan khusus untuk voucher masa aktif ini, Anda hanya perlu membeli dan akitfkan vouchernya dengan cara dial *111*KodeVoucher# dan tidak ada masa berlaku untuk voucher ini, jadi Anda bisa simpan untuk stock.

Cara Transfer Pulsa (Semua Operator)
Pengirim dan penerima transfer pulsa harus berada dalam masa aktif

[Tips] Cara Murah dan Kreatif menambah masa aktif kartu Indosat

Telkomsel Halo
cek Rp pemakaian hingga saat ini: *888#
cek nomor sendiri: *808# (cara mengetahui nomor telkomsel kita sendiri)


Cara Mengetahui Nomor Ponsel Sendiri (ALL OPERATOR)
UPDATE XL: *123*7*2*1*1#

Sunday, October 26, 2014

Telnet related

Testing SMTP Authentication Using OpenSSL
Note to self: Not working with dnet's (cpanel1 ...), session disconnected too fast

OpenSSH
+ Working on computer where freeSSHd has "Access Denied" issue
- tab (for autocomplete), backspace (for delete), up arrow (for previous command) not working
* login name is CASE SENSITIVE

Setup SSH Server with freeSSHD
(Note to self) The article contains solution for the following issues:
1.No tray icon
...when FreeSSHDService.exe is re-run, it gives error "The specified address is already in use"
2. Connecting using puTTY "Access Denied" even with the correct username and password
*UPDATE* found 1 situation with win7 when "Access Denied" keep happening even after following the solution

There's more explanation of the behaviour on the last comment of this article:
freeSSHd administrator stupidity, and fix (May 2, 2014 at 5:26 AM by jim jones)

How install fresssshd as service after installation:
run "freeftpdservice.exe /service" from command prompt

PuTTY: How to copy and paste to and from a PuTTY window
To copy from:

..All you have to do is left click and drag to make a selection
..As soon as you let go of the mouse button, the selection is instantly copied to your clipboard and ready to
..be pasted

To paste to:
..Simply right-click to paste
To select and copy a rectangular region:
..Hold down ALT, then click and drag from the top left corner to the bottom right

Monday, October 13, 2014

Android firewall related

AFWall+: app with wifi permission still can't connect to network
give explicit permission using custom script:
..using SManager, create file named (example) afplus.sh on /data/local folder
..give permissions 0755 (Group/User 0) to the file

..content of file (example):
# Necessary at the beginning of each script!
IP6TABLES=/system/bin/ip6tables
IPTABLES=/system/bin/iptables

$IPTABLES -A "afwall" -p TCP --destination-port 3389 -j ACCEPT || exit

..on AFWall+, choose "Set custom script" and fill:
. /data/local/afplus.sh
---
reference: CustomScripts

ALTERNATIVE: XPrivacy - The ultimate, yet easy to use, privacy manager
* for Lollipop, see Installation section
+ [it can] revoke permission to internet access

Firewall for NON-ROOTED...is it good?
I'm finding that Grey Shirts NoRoot Firewall is being shut down (I guess by VPN conflict) too frequently to be a reliable FW. (source)
NoRoot Firewall privacy concerns, manipulation possible?

Wednesday, October 8, 2014

Buat/perpanjang paspor online


Cara Buat Paspor Online yang Mudah dan Cepat
Setelah itu Anda akan diminta mengisi alamat rumah dan alamat kantor, kemudian alamat orangtua dan alamat lama yang tidak wajib diisi.
Selain biaya yang sudah tercantum tadi, ada tambahan biaya administrasi bank sebesar Rp5.000, sehingga total menjadi Rp360.000. Bukti atau struk pembayaran agar difotokopi sebanyak 3 lembar
Yang juga perlu dipersiapkan menurut ini:
Bukti Pembayaran
Lampiran PDF pada “Email Konfirmasi Kehadiran” yang telah dicetak menggunakan kertas ukuran A4
KTP ASLI
AKTA KELAHIRAN ASLI
KARTU KELUARGA ASLI
Foto Kopi 1 lembar KTP di cetak di kertas ukuran A4, dimana KTP telah diperbesar sekian kali lipat, sehingga dapat dengan mudah dapat dibaca. Disarankan foto kopi di Koperasi yang disediakan di belakang Kantor Imigrasi.
Foto Kopi 1 lembar Akta Kelahiran di kertas ukuran A4, tidak boleh ditekuk atau di potong. Jika terlalu kecil maka harus diperbesar. Jika terlalu besar maka harus diperkecil. Disarankan bawa dari rumah.
Foto Kopi 1 lembar Kartu Keluarga di kertas ukuran A4, tidak boleh ditekuk atau di potong. Jika terlalu kecil maka harus diperbesar. Jika terlalu besar maka harus diperkecil. Disarankan bawa dari rumah.
1 buah materai Rp. 6000. Untuk Haji, diperlukan 2 materai. Jika beli di sana (dijual oleh seseorang sprti PKL), harganya Rp. 8000/materai
Bolpoin warna hitam. Kalau beli di sana (dijual oleh seseorang sprti PKL), harganya Rp. 3000/bolpoin.

*UPDATE* Meskipun banyak artikel menyebutkan bahwa kita harus menyiapkan scan berbagai dokumen, tampaknya telah terjadi perubahan prosedur karena di menu "Petunjuk pengisian Layanan Paspor Online" yang ada di website disebutkan bahwa:

"Pemohon tidak melakukan proses upload lampiran persyaratan, pemohon harus bawa
dokumen persyaratan asli dan fotocopy saat jadwal kedatangan ke Kanim tujuan"

Artikel yg sesuai dg perubahan tsb:
Bikin Paspor via Online Tanpa Upload Dokumen
---

Cara Perpanjang Paspor Online
Sehabis foto, saya diberikan copy slip bukti bayar dan dicap untuk pengambilan paspor baru adalah 3 hari kerja setelah foto pada jam 13.00-15.30 jadi saya harus ambilnya di hari Senin membawa kertas pengambilan paspor dan slip bukti bayar tersebut
---

Bagaimana jika ada salah input data saat daftar online?
Baca pengalaman orang di SISTEM PASPOR ONLINE MASIH LEMAH

kemarin juga berfikir seperti itu akan hangus kalau penulisan via online saya ... salah input tanggal lahir. Alhamdulillah saat saya ke kantor imigrasi saya dikasih form lagi sehingga saya bisa menuliskan dengan benar.
Jadi form yang diisi di internet itu sebernarnya hanya formalitas sebagai bukti untuk di bawa ke imigrasi. Walhasil saya bisa mengubah sesuai dengan KTP

Berarti ... paspor br naik cetak setelah kita isi form manual di kanim yang bersangkutan.
---



Mengurus Paspor
Persyaratan untuk di-submit secara online:
Hasil scan Kartu Keluarga (JPEG, grey scale)
Hasil scan Akte Kelahiran (JPEG, grey scale)
Hasil scan KTP (untuk anak/bayi, KTP yang diperlukan adalah KTP ayah atau ibunya, salah satu saja) (JPEG, grey scale)
Hasil scan paspor lama (bila sudah punya paspor sebelumnya/habis berlaku) (JPEG, grey scale)
Ukuran tinggi badan (dalam cm)


Format hasil scan harus dalam format JPEG dan grey scale. Meskipun tertulis “file tidak boleh lebih dari 1000 KB”, alangkah lebih baik jika ukuran file di bawah 250 KB untuk memudahkan. Karena pengalamanku, file yang berukuran hampir 300 KB saja tidak diizinkan diunggah karena dianggap terlalu besar.
---

Cara Pembuatan Paspor Anak dan bayi secara ONLINE
---

Kelemahan Sistem Pendaftaran Paspor Online
[Sebelum memilih Kanim ada baiknya telepon dulu memastikan apa ada stok buku 24h krn di website] Tidak menampilkan paspor apa saja yang tersedia di Kanim. Contohnya saja, sebenarnya ada paspor 24H tapi stoknya habis, sedangkan sudah bayar kan jadinya rugi. Jadi semoga nanti semakin lama, si programmer bisa ngubah sistemnya lebih baik, misalkan memilih kanim terlebih dahulu, sehingga bisa menampilkan paspor apa yang tersedia di Kanim tersebut.

Bila pendaftar paspor masih memiliki status Belum Kawin, maka dibutuhkan surat ijin dari orang tua. Itu juga tidak ditulis di webnya. Dan di surat tersebut perlu tanda tangan ortu pasti menggunakan materai. Setidaknya kalau tau itu, kan bisa ke imigrasi dulu untuk minta surat ijin orang tua, biar bisa dibawa pulang, dan beberapa hari kemudian kembali lagi dengan syarat yang sudah lengkap, biar enggak bolak balik. [atau lihat format surat ijin orang tua di google dengan keyword "form surat ijin orang tua paspor"]

Yang udah kerja, buat surat keterangan kerja, formatnya sudah ada di Kanim.
[atau cari di google dengan keyword "surat keterangan kerja paspor"]

Monday, October 6, 2014

Pertimbangkan sebelum beli apartemen

YLKI punya enam catatan kelam perihal penyelenggaraan apartemen di Indonesia. Pertama, soal pembentukan P3SRS. “Sejumlah pengembang sengaja tidak menjual semua unit rumah susun, sehingga ada kecenderungan dari pengembang untuk menempatkan orang-orangnya duduk dalam kepengurusan P3RS,”
Kedua, masalah kenaikan tarif service charge, yang sering jadi tarik menarik antara penghuni dengan P3SRS yang dikuasai pengembang atau pengelola. Ketiga, kenaikan besaran tarif listrik yang di atas tarif PLN. Keempat, praktik monopoli layanan akses internet yang biasanya disediakan oleh provider yang terafiliasi dengan pengembang. Kelima, persoalan sertifikasi satuan apartemen. Terakhir terkait peraturan daerah tentang rincian untuk jadi dasar pembuatan sertifikat satuan apartemen.



Apakah apartemen seken bisa KPA ?
Jangan kira fasilitas KPA hanyalah untuk pembelian apartemen baru saja. Apartemen bekas atau second-pun bisa Anda miliki dengan KPA. Namun, hanya beberapa apartemen yang menawarkan fasilitas KPA untuk pembelian unit apartemen second, Jadi jika berminat untuk membeli apartemen second dengan KPA, pastikan dahulu apakah apartemen tersebut menyediakan fasilitas ini atau tidak. Anda juga bisa bertanya pada bank mengenai tawaran KPA apartemen second yang ada saat ini
sumber: 6 Hal Penting Seputar Kredit Pemilikan Apartemen

Lakukan Ini Kalau Sudah Akad Kredit dengan Bank tapi Developer Ingkar Janji
wajib hukumnya bagi kita untuk memastikan keprofesionalan developer sebelum membeli rumah yang dipasarkannya. Salah satunya lewat Perjanjian Pengikatan Jual Beli (PPJB) yang dikeluarkan pihak developer.
Untuk berjaga-jaga, simpanlah segala sesuatu yang berkaitan dengan iklan rumah yang ditawarkan. Misalnya brosur, pamflet, atau bahkan pesan BBM dari developer. Dokumen itu bisa dijadikan senjata jika kelak developer mau main-main!

Ask - memperkarakan developer yang ingkar janji
Pendapat:
1. Seharusnya developer (marketing) dalam memasarkan produknya akan
menjelaskan fasilitas2 apa saja yang didapat dari pembelian rumah
tersebut. Kalau konsumen masih belum jelas biasanya dipersilahkan untuk
bertanya. (malu bertanya sesat dijalan) \)b
2. Sbg modal tambahan untuk pembangunan, developer akan mempercepat
penjualan produknya sebelum dibangun proyeknya. Biasanya
media yang digunakan melalui brosur, iklan dan media2 lainnya. Brosur
biasanya berisi proyeksi/ rencana2 developer atas produknya (rumah)
tersebut. (biasanya dicantumkan "dapat berubah sewaktu-waktu dan
bukan merupakan bukti penjualan/ perjanjian"). capedes
3. Dalam tahap proyek pembangunan rumah membutuhkan yang lama.
4. Guna mempersiapkan proses balik nama ke konsumen juga membutuhkan
waktu yang lama (pengurusan ijin2, pemecahan sertipikat, dll).
5. Berkaitan dengan poin 3 & 4, karena membutuhkan waktu yang lama
melengkapi syarat2nya, proses penandatanganan AJB tidak dapat
serta merta dilakukan, meskipun konsumen membayar tunai/ cash.
6. Untuk mengatasi hal dalam poin 5, pada saat pembelian, konsumen
diberikan bukti pemesanan yang berisi produk yang dibeli konsumen.
7. Bukti pemesanan dalam poin 6 diatas akan dikuatkan dengan pengikatan
/ penandatanganan perjanjian (Perjanjian Pengikatan Jual Beli/ PPJB) antara
developer dengan konsumen. PPJB berisi hak dan kewajiban, perbuatan2
yang boleh/ tidak boleh dilakukan oleh developer dan konsumen. PPJB inilah 
yang menjadi pegangan konsumen atas produk yang dibelinya.
8. Setelah syarat2 dalam poin 3 & 4 dan syarat lainnya dianggap lengkap,
maka dilakukan penandatanganan AJB didepan Pejabat Pembuat Akta Tanah
(PPAT), sebagai bukti bahwa kepemilikan produk tersebut telah berpindah ke
konsumen. Dalam AJB biasanya tercantum: pihak2 yg
melakukan pengikatan, objek pengikatan (hanya tanah dan/atau bangunan),
hak atas objek pengikatan, harga pengikatan, dll).
9. AJB sebagai dasar dilakukannya perubahan nama (balik nama) dalam
sertipikat.


Bagaimana memahami Strata Title dengan cara yang mudah?
Membahas MITOS: JANGAN MEMBELI APARTEMEN KARENA ANDA PUNYA RUMAH TAPI TIDAK PUNYA TANAH!
kekuatirannya adalah takut kalau-kalau terjadi musibah gempa, kebakaran atau apapun yang membuat gedung tersebut runtuh maka muncul dikepala bahwa akhirnya H. Sarusun (Hak Satuan Rumah Susun atau sertifikat Hak Strata Title) yang dimiliki menjadi hanya selembar kertas saja tanpa Unit!
[ada yang namanya] asuransi Business Interuption ―Asuransi yang mengcover kehilangan pendapatan sewa selama masa pembangunan kembali gedung yang runtuh

Kami tidak sarankan beli unit apartemen yang tanahnya HGB tapi diatas HPL.
HPL = Hak Pengelolaan(?)


---

Status Kepemilikan Apartemen SHM, HGB Murni atau HPL?
Status yang paling aman adalah pihak developer mengantongi status HGB Hak Milik yang artinya tanah yang dibangun adalah milik developer dan perlu diperjelas apakah tanah apartemen tersebut menjadi pemilik unit dengan perbandingan rata-rata luas unit yang dimiliki dengan total unit yang ada, atau tidak. Biasanya jika pemilik unit menjadi pemilik tanah maka harga apartemen tersebut akan menjadi sangat mahal.


Status yang aman kedua adalah HGB Murni karena tanah apartemen milik negara yang mana jika negara meminta tanah tersebut dikembalikan maka negara akan membayar sebesar 80% dari harga tanah saat itu dan masing masing pemilik akan mendapatkan proporsional berdasarkan luas unit yang dimiliki dibagi dengan total luas unit yang ada.

Status yang sangat tidak aman adalah developer hanya mengantongi ijin HGB HPL saja yang mana jika pemilik tanah (pihak ketiga) meminta tanahnya kembali setelah masa HGB berakhir maka pemilik unit rumah susun tidak akan mendapatkan penggantian sepeserpun.

Alangkah baiknya jika anda di saat akan membeli sebuah apartemen baru, di usahakan agar bisa mendapatkan no registrasi HGB, IMB & SIPPT yang mana bisa di cek sendiri legalitasnya di BPN & BPP Pemda agar lebih yakin lagi status kepemilikan mana yang ingin anda peroleh.
---

- Cuci kendaraan harus ke tempat cuci
- Ke parkir "jauh"
- Cuma dapet hak bangunan, ga ada tanah, jadi kalo (amit2) gempa dan ancur abis
tidak ada sst u/ di-claim
- Keamanan bila terjadi bencana gempa
* Operational cost
* Suara/keributan tetangga terdengar jelas?
* Kerusakan bangunan/instalasi(air,listrik) tanggung jawab siapa?

Wednesday, September 24, 2014

Postgres related

Forgotten PostgreSQL Windows password

[database vs] schema

Log changes made by users:
Audit trigger 91plus
Note to self:
From experience with idempiere database on Postgres 9.4, the code need to be changed:
from "quote_ident(target_table::text)" to "target_table"
Related to that matter:
Define table and column names as arguments in a plpgsql function?
SQL injection in Postgres functions vs prepared queries
Unexpected behavior of dynamic SQL using regclass

Function to activate audit trigger on several tables at one (related to Audit trigger 91plus):
--- code start ---
CREATE OR REPLACE FUNCTION audit.mass_on(
    _schema_ character varying,
    _table_regexp_ character varying)
  RETURNS SETOF character varying AS
$BODY$
DECLARE
    result  VARCHAR := '';
BEGIN
    FOR result IN SELECT table_name FROM information_schema.tables
        WHERE table_schema = $1 AND table_name ~* $2 and table_type = 'BASE TABLE' ORDER BY table_name
    LOOP
perform audit.audit_table($1 || '.' || result);
        RETURN NEXT result;
    END LOOP;
    RETURN;
END;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100
  ROWS 1000;
ALTER FUNCTION audit.mass_on(character varying, character varying)
  OWNER TO postgres;
--- code finish ---
Sample usage:
select audit.mass_on('adempiere','_');

Function to de-activate audit trigger on several tables at one (related to Audit trigger 91plus):
--- code start ---
CREATE OR REPLACE FUNCTION audit.mass_off(
    _schema_ character varying,
    _table_regexp_ character varying)
  RETURNS SETOF character varying AS
$BODY$
DECLARE
    result  VARCHAR := '';
BEGIN
    FOR result IN SELECT table_name FROM information_schema.tables
        WHERE table_schema = $1 AND table_name ~* $2 and table_type = 'BASE TABLE' ORDER BY table_name
    LOOP
EXECUTE 'DROP TRIGGER IF EXISTS audit_trigger_row ON ' || $1 || '.' || result;
EXECUTE 'DROP TRIGGER IF EXISTS audit_trigger_stm ON ' || $1 || '.' || result;
        RETURN NEXT result;
    END LOOP;
    RETURN;
END;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100
  ROWS 1000;
ALTER FUNCTION audit.mass_off(character varying, character varying)
  OWNER TO postgres;
--- code finish ---
Sample usage:
select audit.mass_off('adempiere','pa_');

Function to search schema for specified table name (partial name supported, related to Audit trigger 91plus):
--- code start ---
CREATE OR REPLACE FUNCTION audit.list_tables(
    _schema_ character varying,
    _table_regexp_ character varying)
  RETURNS SETOF character varying AS
$BODY$
DECLARE
    result  VARCHAR := '';
BEGIN
    FOR result IN SELECT table_name FROM information_schema.tables
        WHERE table_schema = $1 AND table_name ~* $2 ORDER BY table_name
    LOOP
        RETURN NEXT result;
    END LOOP;
    RETURN;
END;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100
  ROWS 1000;
ALTER FUNCTION audit.list_tables(character varying, character varying)
  OWNER TO postgres;
--- code finsh ---
Sample usage:
select audit.list_tables('adempiere','ad_');

Debug PostgreSQL function using pgAdmin
picture

Re-add database from files on disk:
Recover postgreSQL databases from raw physical files

Physical location of database files:
Where does PostgreSQL store the database?

Database backup using SQL Dump
An important advantage of pg_dump over the other backup methods described later is that pg_dump's output can generally be re-loaded into newer versions of PostgreSQL, whereas file-level backups and continuous archiving are both extremely server-version-specific. pg_dump is also the only method that will work when transferring a database to a different machine architecture, such as going from a 32-bit to a 64-bit server

How do I specify a password to psql non-interactively?
Set the PGPASSWORD environment variable ... before calling psql


Tuesday, September 23, 2014

Eclipse related

Use existing workspace with newer version of Eclipse?
In theory, new versions of Eclipse should update your workspace and project files just fine. In practice, they can become corrupted. My new rule is to create a new workspace for every major version upgrade of Eclipse (maybe more often if you’re cautious). Then I copy those projects and import the copy. This ensures I have a backup plan should something go awry. You may need to reimport your project(s) if there’s a problem that won’t go away after an upgrade.
(from ECLIPSE “CANNOT BE RESOLVED TO A TYPE” ERROR)

How to find out if an installed Eclipse is 32 or 64 bit version?

Hit Ctrl+Alt+Del to open the Windows Task manager and switch to the processes tab, OR
Open eclipse.ini in the installation directory, and observe the 4th line

32-bit programs should be marked with *32

Running 32 bit applicayion on 64 bit Eclipse
Using a 32-bit JRE with a 64-bit eclipse:
Just include the 32bit JRE as an additional Java runtime in the configuration and use it for your project.
How?
...

Tuesday, September 16, 2014

"Net send" related

To send messages to all users currently open documents stored on server XYZ :
from Command prompt on XYZ, type : NEt SEND /USERS "message"
---

Could not send to ANY computer with error "message alias could not be found"

SOLUTION:
Messenger service is probably stopped
---

suddenly not working

SYMPTOM:
An error occured while sending a message to ...
A general network error occured
...NET HELPMSG 2136

SOLUTION:
Restart Messenger service
---

Free client (receive only): Winsent Innocenti
---

how to send multi-line message
Press CTRL+T after the last character of a line.
see How can I NET SEND a multi-line message? for alternative ways
---

Maximum allowed length of a broadcast message is 128 characters. Maximum allowed length of a personal message is 1600 characters.
source: NET SEND command reference
---

Wednesday, September 10, 2014

“Insufficient storage available” related

Fastest/easy way to move ALL apps back to [original] internal storage/memory prior to changing/formatting:
Multi-select \ Select all \ Move to phone (and/or Remove Link?)
NOTE:
Uninstalling Link2SD will NOT do the trick (see FAQ: What happens to my linked apps if I uninstall the Link2SD app?)

Free up /system storage
Q: Looking at the storage info within Link2SD I see that I only have 2% of my /system storage free
A:
removing system apps will NOT give you anymore user available space, but integrating updates of system app will, link2sd can [do] this now. Low "/system" storage should not give you any problems since items in there are pretty much static

Better not upgrade to KitKat if still want to use Link2SD
Note from Link2SD 3.5.2 version (click "View page source" on "Reviews" section):
KITKAT NOTICE In Android KitKat is not legally possible to write files to any location on external SD card. So the functionality of the app limits to internal storage on KitKat. If you have a rooted device you can try a fix: https://play.google.com/store/apps/details?id=nextapp.sdfix
*UPDATE Jan 8, 2015 Found this:
Unlock external SD Card writing for all apps in Android 4.4 KitKat
Comment by SonicX (search string "Link2SD") might be useful; never tried it though

Link2SD - missing apps after reboot
Posted on Nov 13, 2014:
The "Link Internal Data" option in the paid version seems to be the culprit. This is buggy and stopped using it after a few apps disappeared after using this option.
Another suggestion from this:
Start link2sd and click menu button>more>quickreboot and all the "missing apps" are going to be available again for all your needs!

Increase internal memory in Android Mobiles in easy steps

Is it safe to resize 2nd partition (ext2) used by Link2SD after some time?

seriously to say i wouldn't recommend to restore that ext partition.. As you are saying you want to restore your config of Link2sd.. Well to say it will not work cz the system links get disturbed due to removal of partition or modify..
well best to say i would recommend to take a backup of your ROM then partition the card..
Well to say i would recommend to you first switch off your phone.. Put it in card reader then partition it..
Restore the backup then see if it works.. I think you are on stock rom..

You can try this method:
1. Make a backup of your current ROM Using the recovery..
2. Switch off the phone then put it in card reader.. Re partition your card using card reader..
3. Then restore the backup..
See if this works..
source: Extend EXT2 partition without losing data
---


Link2SD: mount script created but link2sd.log says "No such file..." or "Device or resource busy"
(NOT TRIED YET) Problem with link2sd

Important topics from Link2SD FAQ
You need to use a non-FAT file system (ext2, ext3, ext4 or f2fs) on your second partition in order to link app's private data files. Because the FAT file system (FAT16, FAT32 or exFAT) does not support UNIX file ownership or permissions and will cause a security breakdown of app's private files. Link2SD Plus can move app's private data files if you have a non-FAT partition.
What is the difference between “Move To SD Card (Native to Android)" and “Create (Symbolic) Link” in Link2SD?
Click "Create Link":
..move and link applications to 2nd partition with Link2SD.
..You can see "Linked -> SD card" label for linked apps
click "Move to SD":
..app will be moved to first partition with native app2sd method of Android OS.
..You can see "on SD Card" label for those apps
What does it mean to freeze an app - what is the benefit of doing that?
 I see -Updated- label on some applications, what does it mean?

“Insufficient Storage Available” even there is lot of free space in device memory
Dial *#9900# (for Samsung only?)
see rhlee's answer for how to do the same thing if you get the "invalid MMI" error when you try this on a rooted, modded phone.
Basically, Delete dumpstate/logcat in SysDump clears out the log files in /data/log. But you can also do this manually without SysDump
...

Increase Internal Storage of Micromax A110 and any MTK Device

'Insufficient Storage Available' is one of Android's greatest annoyances. Here's how to fix it.
You can get a big-picture look at what is using up your internal and external space by installing DiskUsage, a free app that visualizes what's sitting around in storage.
Self experience: Cache of Download Manager

“Insufficient storage available”. Ok, but where?

Related
--------
[GUIDE] [FAT32] [EXT4] [SWAP] [2.3+] How to Partition your Android MicroSD Card

Tuesday, September 9, 2014

List all characters for certain pinyin

Xiaoma
Use "Search by pinyin" on the left pane

Click on pinyin and link to characters will appear on top of the page

Related
--------
Tips: How to Use Google Pinyin Chinese Input Method
Download link:
Link 1
Link 2
To show/hide google pinyin toolbar: press ‘Alt’ + ‘Shift’

Wednesday, September 3, 2014

Hunt for tablet with 10" display and minimum of 4GB RAM

Xiaomi Mi Pad 4 Plus Phablet Review MAR 8, 2019
What Works for Mi Pad 4 Plus
   Sleek design
   10.1-inch Full HD IPS-LCD screen
   Fingerprint sensor
   Impressive battery performance
Where Xiaomi Mi Pad 4 Plus fails
   Subpar speakers
   Lack of Google Play Store

The Google Play Store is missing from the tablet but it can be installed from the Mi App Store with ease.
The brightness, contrast, and color reproduction are good enough to support usage in indoor settings as well as outdoors as long as you are using it in the shadows without straining the eyes. The screen does get quite dark in direct sunlight. For those who prefer customized color and contrast settings, there is plenty of room adjust the setting to one’s personal liking.

Tablet Xiaomi Mi Pad 4 Plus 4/64 GB 10.1 inch - Garansi 1 Tahun - Hitam Rp 4.300.000

GSMArena review/opinions/discussion

Kaskus
Q: Dapat Rom abal abal. Mipad jalan tetapi sering system crash notif. Miui version ndak muncul. Tidak ada developer option. Bootloader device unlock tetapi jika dicek dg pc ternyata lock.
Sudah semua cara sy ikuti untuk unlock bootloader munculnya token salah. Langsung coba flashrom pakai twrp gagal, recovery img tidak terdeteksi, padahal sudah matikan pengenalan info device di windows. Memakai cara miflash tool gagal mengenali.
Adakah petunjuk cara selain test point? Trims
A: Kalau gak mau ribet sih tinggal test point aja gan. Tapi sebelum flashing, Pastikan akun mi ente adalah yg "authorized account"

Ga ada global stable resmi gan, ROM resmi cuma official China aja. Ane pake ROM official China OK ko, ga ada masalah. Tapi sekarang pake Xiaomi EU lebih mantap lagi, ga ada aplikasi China bawaan, semuanya lancarrrrrrr jaya.
---

htcmania
Q: Today I received the Xiaomi MiPad 4 purchased on Aliexpress with the multilanguage room and the Bootloader unlocked, I was going to enter the room xiaomi.eu but getting into settings and going to the installed version I put that is the MIUI BY XIAOMI .EU 10.3 Stable. MIUI 10.3.1.0 (odjcnfi) Android version 8.1.0
This means that it already comes with that room and that I do not have to do anything anymore?
A: It seems that you have the Xiaomi.eu ROM , it remains to be seen if they have installed it by means of the recovery, or they have only booted in recovery to flash the ROM and then continue the tablet with the original recovery of MIUI.
Turn off the tablet and turn it on in the recovery mode. Vol + and power button, when you turn on the tablet you release the power button but continue pressing vol + until you access the recovery. That's when you'll have to check which recovery starts, original, or the TWRP.
If you do not have TWRP, you should install it to continue using the Xiaomi.eu ROM correctly .

Monday, September 1, 2014

Unsolved cases

How to configure Windows Firewall to allow EXPLORER.EXE's outbound connection to LAN but not to Internet

Sunday, August 24, 2014

TabunganKu

TabunganKu Yang Paling Bagus Dapat ATM

TabunganKu Mandiri dapat ATM yang bisa utk bayar BPJS?


Tuesday, August 12, 2014

WinPCap related

Change auto-start-at-boot setting:
[Winpcap-users] question about NPF driver
just type "sc config npf start= " to see available options and values
Note that "A space is required between the equal sign and the value"

Stopping the WinPcap Packet capture service
net stop npf

Where to find WinPcap in system control? (on Windows 8.1 Pro 64bit)
How can I directly confirm that this "service" is running on Windows 8?
WinPcap is a service (but mainly a driver), named NetGroup Packet Filter Driver. The fact is that it cannot be seen in the Windows Services Manager

Sunday, August 10, 2014

Selalu muncul popup stok tidak cukup saat input SO padahal "Item Availibility" cukup

Salah satu tambahan code di bawah ini akan memudahkan penelusuran:

Codeunit 5790 Available to Promise:
di function QtyAvailabletoPromise:
IF (UPPERCASE(USERID)='YOURNAME') THEN
MESSAGE('%1**%2**%3**%4',Item.Inventory,Item."Reserved Qty. on Inventory", ScheduledReceipt,GrossRequirement);

ATAU, di function CalcGrossRequirement:

IF (UPPERCASE(USERID)='YOURNAME') THEN BEGIN
MESSAGE('%1**%2',Item."Scheduled Need (Qty.)",Item."Res. Qty. on Prod. Order Comp.");
MESSAGE('%1**%2**%3',Item."Planning Issues (Qty.)",Item."Qty. on Sales Order",Item."Reserved Qty. on Sales Orders");
MESSAGE('%1**%2**%3',Item."Trans. Ord. Shipment (Qty.)",Item."Res. Qty. on Outbound Transfer", QtyOnPurchReturn);

Yang pernah terjadi adalah banyak PRO outstanding dimana hal tsb tidak diperhitungkan (tidak tampak) bila dilihat dari menu/form "Item Availibility"

Related
--------
Rumus utk kolom "Projected Available Balance" di report "Item Availibility":

Inventory + PlannedOrderReceipt + ScheduledReceipt - GrossRequirement
    = Planning Receipt (Qty.) +   = ("Scheduled Receipt (Qty.)" - "Reserved Qty. on Prod. Order") +   = ("Scheduled Need (Qty.)" - "Res. Qty. on Prod. Order Comp.") +
    Planned Order Receipt (Qty.) +   ( Purch. Req. Receipt (Qty.) - "Res. Qty. on Req. Line") +   Planning Issues (Qty.) +
    Purch. Req. Receipt (Qty.)   ("Qty. on Purch. Order" - "Reserved Qty. on Purch. Orders") +   ("Qty. on Sales Order" - "Reserved Qty. on Sales Orders") +
        ("Trans. Ord. Receipt (Qty.)" - "Res. Qty. on Inbound Transfer") +   ("Qty. on Service Order" - "Res. Qty. on Service Orders") +
        "Qty. in Transit" +   ("Trans. Ord. Shipment (Qty.)" - "Res. Qty. on Outbound Transfer") +
        QtyOnSalesReturn   QtyOnPurchReturn
Qty. on Purch. Order Sum("Purchase Line"."Outstanding Qty. (Base)" WHERE (Document Type=CONST(Order),Type=CONST(Item),No.=FIELD(No.),Shortcut Dimension 1 Code=FIELD(Global Dimension 1 Filter),Shortcut Dimension 2 Code=FIELD(Global Dimension 2 Filter),Location Code=FIELD(Location Filter),Drop Shipment=FIELD(Drop Shipment Filter),Variant Code=FIELD(Variant Filter),Expected Receipt Date=FIELD(Date Filter)))
Reserved Qty. on Purch. Orders Sum("Reservation Entry"."Quantity (Base)" WHERE (Item No.=FIELD(No.),Source Type=CONST(39),Source Subtype=CONST(1),Reservation Status=CONST(Reservation),Location Code=FIELD(Location Filter),Variant Code=FIELD(Variant Filter),Expected Receipt Date=FIELD(Date Filter)))
Res. Qty. on Outbound Transfer -Sum("Reservation Entry"."Quantity (Base)" WHERE (Item No.=FIELD(No.),Source Type=CONST(5741),Source Subtype=CONST(0),Reservation Status=CONST(Reservation),Location Code=FIELD(Location Filter),Variant Code=FIELD(Variant Filter),Shipment Date=FIELD(Date Filter)))
Scheduled Receipt (Qty.) Sum("Prod. Order Line"."Remaining Qty. (Base)" WHERE (Status=FILTER(Planned..Released),Item No.=FIELD(No.),Variant Code=FIELD(Variant Filter),Shortcut Dimension 1 Code=FIELD(Global Dimension 1 Filter),Shortcut Dimension 2 Code=FIELD(Global Dimension 2 Filter),Location Code=FIELD(Location Filter),Due Date=FIELD(Date Filter)))
Scheduled Need (Qty.) Sum("Prod. Order Component"."Remaining Qty. (Base)" WHERE (Status=FILTER(Planned..Released),Item No.=FIELD(No.),Variant Code=FIELD(Variant Filter),Shortcut Dimension 1 Code=FIELD(Global Dimension 1 Filter),Shortcut Dimension 2 Code=FIELD(Global Dimension 2 Filter),Location Code=FIELD(Location Filter),Due Date=FIELD(Date Filter)))
Reserved Qty. on Prod. Order Sum("Reservation Entry"."Quantity (Base)" WHERE (Item No.=FIELD(No.),Source Type=CONST(5406),Source Subtype=FILTER(1..3),Reservation Status=CONST(Reservation),Location Code=FIELD(Location Filter),Variant Code=FIELD(Variant Filter),Expected Receipt Date=FIELD(Date Filter)))
Res. Qty. on Prod. Order Comp. -Sum("Reservation Entry"."Quantity (Base)" WHERE (Item No.=FIELD(No.),Source Type=CONST(5407),Source Subtype=FILTER(1..3),Reservation Status=CONST(Reservation),Location Code=FIELD(Location Filter),Variant Code=FIELD(Variant Filter),Shipment Date=FIELD(Date Filter)))
Res. Qty. on Req. Line Sum("Reservation Entry"."Quantity (Base)" WHERE (Item No.=FIELD(No.),Source Type=CONST(246),Source Subtype=FILTER(0),Reservation Status=CONST(Reservation),Location Code=FIELD(Location Filter),Variant Code=FIELD(Variant Filter),Expected Receipt Date=FIELD(Date Filter)))
Qty. in Transit Sum("Transfer Line"."Qty. in Transit (Base)" WHERE (Derived From Line No.=CONST(0),Item No.=FIELD(No.),Transfer-to Code=FIELD(Location Filter),Variant Code=FIELD(Variant Filter),Shortcut Dimension 1 Code=FIELD(Global Dimension 1 Filter),Shortcut Dimension 2 Code=FIELD(Global Dimension 2 Filter),Receipt Date=FIELD(Date Filter)))
Trans. Ord. Receipt (Qty.) Sum("Transfer Line"."Outstanding Qty. (Base)" WHERE (Derived From Line No.=CONST(0),Item No.=FIELD(No.),Transfer-to Code=FIELD(Location Filter),Variant Code=FIELD(Variant Filter),Shortcut Dimension 1 Code=FIELD(Global Dimension 1 Filter),Shortcut Dimension 2 Code=FIELD(Global Dimension 2 Filter),Receipt Date=FIELD(Date Filter)))
Planning Issues (Qty.) Sum("Planning Component"."Expected Quantity (Base)" WHERE (Item No.=FIELD(No.),Due Date=FIELD(Date Filter),Location Code=FIELD(Location Filter),Variant Code=FIELD(Variant Filter),Shortcut Dimension 1 Code=FIELD(Global Dimension 1 Filter),Shortcut Dimension 2 Code=FIELD(Global Dimension 2 Filter),Planning Line Origin=CONST(" ")))
Planning Receipt (Qty.) Sum("Requisition Line"."Quantity (Base)" WHERE (Type=CONST(Item),No.=FIELD(No.),Due Date=FIELD(Date Filter),Location Code=FIELD(Location Filter),Variant Code=FIELD(Variant Filter),Shortcut Dimension 1 Code=FIELD(Global Dimension 1 Filter),Shortcut Dimension 2 Code=FIELD(Global Dimension 2 Filter)))
Planned Order Receipt (Qty.) Sum("Prod. Order Line"."Remaining Qty. (Base)" WHERE (Status=CONST(Planned),Item No.=FIELD(No.),Variant Code=FIELD(Variant Filter),Shortcut Dimension 1 Code=FIELD(Global Dimension 1 Filter),Shortcut Dimension 2 Code=FIELD(Global Dimension 2 Filter),Location Code=FIELD(Location Filter),Due Date=FIELD(Date Filter)))
Purch. Req. Receipt (Qty.) Sum("Requisition Line"."Quantity (Base)" WHERE (Type=CONST(Item),No.=FIELD(No.),Variant Code=FIELD(Variant Filter),Location Code=FIELD(Location Filter),Shortcut Dimension 1 Code=FIELD(Global Dimension 1 Filter),Shortcut Dimension 2 Code=FIELD(Global Dimension 2 Filter),Due Date=FIELD(Date Filter),Planning Line Origin=CONST(" ")))
Reserved Qty. on Inventory Sum("Reservation Entry"."Quantity (Base)" WHERE (Item No.=FIELD(No.),Source Type=CONST(32),Source Subtype=CONST(0),Reservation Status=CONST(Reservation),Serial No.=FIELD(Serial No. Filter),Lot No.=FIELD(Lot No. Filter),Location Code=FIELD(Location Filter),Variant Code=FIELD(Variant Filter)))
// Qty. on Sales Return
WITH SalesLine DO BEGIN
  SETCURRENTKEY("Document Type",Type,"No.","Variant Code","Drop Shipment","Location Code","Shipment Date");
  SETRANGE("Document Type","Document Type"::"Return Order");
  SETRANGE(Type,Type::Item);
  SETRANGE("No.",Item."No.");
  SETFILTER("Location Code",Item.GETFILTER("Location Filter"));
  SETFILTER("Drop Shipment",Item.GETFILTER("Drop Shipment Filter"));
  SETFILTER("Variant Code",Item.GETFILTER("Variant Filter"));
  SETRANGE("Shipment Date",Item.GETRANGEMIN(Item."Date Filter"),Item.GETRANGEMAX(Item."Date Filter"));
  CALCSUMS("Outstanding Qty. (Base)");
  QtyOnSalesReturn := "Outstanding Qty. (Base)";
  RESET;
END;
WITH ReservationEntry DO BEGIN
  SETCURRENTKEY(
    "Item No.","Source Type","Source Subtype","Reservation Status",
    "Location Code","Variant Code","Shipment Date","Expected Receipt Date");
  SETRANGE("Item No.",Item."No.");
  SETRANGE("Source Type",DATABASE::"Sales Line");
  SETRANGE("Source Subtype",5);
  SETRANGE("Reservation Status","Reservation Status"::Reservation);
  SETFILTER("Location Code",Item.GETFILTER("Location Filter"));
  SETFILTER("Variant Code",Item.GETFILTER("Variant Filter"));
  SETRANGE("Shipment Date",Item.GETRANGEMIN(Item."Date Filter"),Item.GETRANGEMAX(Item."Date Filter"));
  CALCSUMS("Quantity (Base)");
  QtyOnSalesReturn -= "Quantity (Base)";
  RESET;
END;
// Qty. on Purchase Return
WITH PurchLine DO BEGIN
  SETCURRENTKEY("Document Type",Type,"No.","Variant Code","Drop Shipment","Location Code","Expected Receipt Date");
  SETRANGE("Document Type","Document Type"::"Return Order");
  SETRANGE(Type,Type::Item);
  SETRANGE("No.",Item."No.");
  SETFILTER("Location Code",Item.GETFILTER("Location Filter"));
  SETFILTER("Drop Shipment",Item.GETFILTER("Drop Shipment Filter"));
  SETFILTER("Variant Code",Item.GETFILTER("Variant Filter"));
  SETRANGE("Expected Receipt Date",Item.GETRANGEMIN(Item."Date Filter"),Item.GETRANGEMAX(Item."Date Filter"));
  CALCSUMS("Outstanding Qty. (Base)");
  QtyOnPurchReturn := "Outstanding Qty. (Base)";
  RESET;
END;
WITH ReservationEntry DO BEGIN
  SETCURRENTKEY(
    "Item No.","Source Type","Source Subtype","Reservation Status",
    "Location Code","Variant Code","Shipment Date","Expected Receipt Date");
  SETRANGE("Item No.",Item."No.");
  SETRANGE("Source Type",DATABASE::"Purchase Line");
  SETRANGE("Source Subtype",5);
  SETRANGE("Reservation Status","Reservation Status"::Reservation);
  SETFILTER("Location Code",Item.GETFILTER("Location Filter"));
  SETFILTER("Variant Code",Item.GETFILTER("Variant Filter"));
  SETRANGE("Expected Receipt Date",Item.GETRANGEMIN(Item."Date Filter"),Item.GETRANGEMAX(Item."Date Filter"));
  CALCSUMS("Quantity (Base)");
  QtyOnPurchReturn += "Quantity (Base)";
  RESET;
END;

Wednesday, August 6, 2014

Check pending file deletion on boot

A handy WMI script to check for pending file rename operations
Registry key:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\"PendingFileRenameOperations"

Wednesday, July 23, 2014

Free VM/VPS on Internet/cloud

www.vps.me
* linux only
* from Connect to Ubuntu Unity Remote Desktop:
...If you are using Free VPS it do not have enough resources to run remote desktop connection. You should
...use paid plans to run this connection.

[Share] Free trial VPS without credit card
instantappz.com: Your credit card will be charged $15 / mo only after 7 days
menurut post ini: Dah kagak Update Lagi yaa ?? ada tapi kbanyakan pakai CC

OpenShift
* free version has no GUI?

Related
--------
Run firefox on headless ubuntu
How to run GUI applications remotely on a headless server

Install Ubuntu With Lightweight Desktop on 128mb vps!
for more, googling: what is lightest|lightweight os centos|ubuntu for vps with low|small RAM|memory

For X11 forwarding, use Xming
Required setting on PuTTY (after Xming is active):
Connection \ SSH \ X11 \ Enable X11 forwarding=Yes; X display location=localhost:0

Another way to access some site through your VPS:
Set it up as tunneling (or proxy? or vpn?) server
How To Set Up A Proxy Server In Ubuntu Linux




Thursday, July 17, 2014

Mini PC

MINIX NEO Z83-4 PRO RAM 4GB ROM 32GB Mini PC Windows 10 Pro 64 Bit
Rp2.572.000 (June 19, 2019)
Cons:
- not enough space to run the full Windows feature upgrade. Had to download and re-install Windows and all the drivers from a flash drive. Was a bit tricky to find the drivers on their website and get them installed correctly.
- I wanted to switch to using a microSD card as the boot device, but the drivers are flaky and the microSD won't stay mounted. Company claims it is not their problem in the support forums.
- I'm using a USB drive as external storage. About once a week the USB drive "disappears" (is unmounted) and I have to unplug and replug it. Seems to be a driver problem, because a reboot also recovers it.
- Connecting to Wi-Fi using 5.8 GHz, the drivers frequently crash (they are specifically identified in the Windows Event Log) and a reboot is required before Wi-Fi works again. I had to create a 2.4GHz ssid and connect to that. At least that connection is stable.
(more reviews)

8 Things I Wish I Knew Before Building My First HTPC

ZOTAC
Mulai 2,7 juta

* No price yet
+ support Windows

Tuesday, July 1, 2014

IIS related

WIN8: enable browing directory content
Directory Browse

WIN8: website can be opened locally but not from another computer
Windows Firewall \ Inbound Rules \ World Wide Web Services (HTTP Traffic-In) \ Enable=Yes


Wednesday, June 4, 2014

Keep health while working with computers

Google: salt|ion health working computer|server room radiation|exposure

Jadi Ini Toh Yang Bikin Mata Kita Cepet Rusak?

10 blue light filters to relieve computer eye strain, help you sleep better, etc
Tinted protective eyewear is a relatively cheap (under $10) and durable solution that may filter up to 100% of blue light. (It is not ideal for tasks that require fine vision, like reading, sowing, etc…, because they generally don’t have AR (anti-reflective) coatings – hence they optically distort the image more than better/pricier eyewear and make your eyes strain more.

Why I Killed My Standing Desk, and What I Do Instead

What Are the Health Benefits of Negative Ions?
For your home or office, I highly recommend a negative ion generator. Many of them aren’t terribly expensive. For, say, 50 bucks you can enrich your stale office in negative ions and filter out impurities to boot. Give it a shot, especially if you don’t spend time in the natural settings where negative ions predominate. If you’re stuck inside all day, bathed in air conditioning, a negative ion generator is worthy of serious consideration.



My 9 Tips To Cut Down On Exposure To Computer Radiation

About negative and positive ion:
NEGATIVE ION

Tanaman Pencegah Sick Building Syndrome dan Heat Island Effect

Tuesday, June 3, 2014

Word spelling on communication (Eja kata/nama di telepon)

A : Alpha
B : Bravo
C : Charlie
D : Delta
E : Echo
F : Foxtrot / Fanta
G : Golf
H : Hotel
I : India
J : Juliet / Jakarta
K : Kilo
L : Lima / London
M : Mike / Mama
N : November / Nano
O : Oscar
P : Papa
Q : Quebec / Queen
R : Romeo
S : Sierra
T : Tango
U : Uniform / Ultra
V : Victor
W : Whiskey
X : X-ray
Y : Yankee
Z : Zulu / Zebra

Thursday, May 22, 2014

Direct file transfer via Internet

CCFile as server
+ free
+ support resume (as long as client is using download manager that supports it as well)
* transfer speed can be adjusted on client side download manager
* requires port forwarding if server is behind firewall


Thursday, May 8, 2014

Import table Item

Item Master Data Import
with automatically create "Item Unit of Measure" record for Base UoM

Tuesday, May 6, 2014

AWAS HATI-HATI penipuan oleh JualKomputerOnline.com

URL 1: jualkomputeronline.com
URL 2: pusatjualkomputerbarusurabaya.blogspot.com

Alamat (palsu?):
Pakuwon City Lt. 4c Jln. Kejawen
Putih Mutiara No. 17 A - 60112
SURABAYA - JAWA TIMUR

Nama di penawaran:
Mitra Komputer

No. rekening:
Mandiri cab. Madiun 1710000276959
a/n Rahmad Ramdani

Hp. 082244557677

Alamat e-mail: cs.pembayaran@gmail.com (Adiyanto Purnama)
YM: cs_online77

Ane sudah transfer tapi barang gak dikirim
Nomor dihubungi tidak diangkat

Thursday, April 24, 2014

Penjual token PLN online

Token PLN / Listrik Prabayar Murah

Java (JRE) related

Q: Firefox/Mozilla keep saying that Java is out of date although you've followed download link
A:
The Firefox link send you to the wrong Java version (outdated) and you have to find the correct Oracle webpage that now has Java version 8 (actually v.1.8.0 plug in 11.0.2.132) and download and install THAT.

You can find the latest Java version on the Oracle website.
See Java Platform \ Java SE 8 (JRE 8 Download)
also: version 7
---

Q: On 64bit Windows, which Java to download? 32bit or 64bit?
A:
Note that because some web content may not work properly in a 64-bit browser, we recommend using the default 32-bit browser and downloading 32-bit Java.
source: Which Java download should I choose for my 64-bit Windows operating system?

Monday, April 7, 2014

Friday, April 4, 2014

Can't remote reboot Windows Server 2003

error: A system shutdown is in progress.(1115)

pskill \\servername winlogon

source: Unstick a remote reboot

Thursday, April 3, 2014

Jadikan laptop menjadi full/semi touch screen

Jual Touch Screen Overlay Murah!
bukan buat laptop karena...
layar monitor laptop kan tipis & "lemes", sedangkan overlay-nya agak berat, nanti ga kuat layar laptop agan

Magic Stick Touchscreen Creator Pen

APEN Touch8, Aksesori Konverter LCD menjadi Layar Sentuh – Touch Screen

Monday, March 31, 2014

UEFI related

Warning - UEFI install and secondary hard drive with Extended/Logical partitions.
a UEFI installed system, will fail to boot if a secondary drive is attached which contains logical partitions. This would have to be an MBR configured drive, of course, but if it has at least one primary and one extended partition, it will stop Windows 7 and Windows 8 from booting

Wednesday, March 26, 2014

OpenVPN on Mikrotik with Windows 7 client

Configuring a Windows OpenVPN client or server

Using a text editor, create an xxxx.ovpn file and save in C:\Program Files\OpenVPN\config e.g. C:\Program Files\OpenVPN\config\client.ovpn
Here is an example of an OpenVPN Windows client configuration file:
...


From Manual:Interface/OVPN, this can only be done with RouterOS v5+
...if you don't have milrotik version 5+, use PC as server
...use OpenVPN on both server and client PC
...use Community Edition (free) and Static Key for simplest setup

Mikrotik OpenVPN server / Windows 7 client
to create certificates and keys, follow guide below (section A.)
before importing server.key to mikrotik, it has to be converted to text:
...on lubuntu
...navigate to easy-rsa\keys
...openssl
...rsa -in server.key -text -out server.key.txt

A.
Setting up your own Certificate Authority (CA) and generating certificates and keys for an OpenVPN server and multiple clients
...Generate the master Certificate Authority (CA) certificate [and] key
......For PKI management, we will use easy-rsa, a set of scripts which is bundled with OpenVPN 2.2.x and
......earlier. If you're using OpenVPN 2.3.x, you need to download easy-rsa separately from here.
......NOTE to self: download and install easy-rsa using guide from Openvpn 2.3 on Ubuntu VPS:
......As of OpenVPN 2.3, Easy-RSA is no longer a part of the OpenVPN install, so we have to get it
......separately.  We will download it in our home directory.  Note: the latest version of Easy-RSA is version
......3, we needed the older release version 2.

......$ cd ~
......$ wget https://github.com/OpenVPN/easy-rsa/archive/release/2.x.zipwget ......https://github.com/OpenVPN/easy-rsa/archive/release/2.x.zip
......$ unzip 2.x.zip

......We now put it all together, transferring a copy of Easy-RSA to the openvpn directory.

......$ mkdir /etc/openvpn/easy-rsa
......$ cp -R ~/easy-rsa-release-2.x/easy-rsa/2.0/* /etc/openvpn/easy-rsa/
......$ cd /etc/openvpn/easy-rsa
...Generate certificate [and] key for server
...Generate certificates [and] keys for 3 clients
......no need to follow these steps(?)

Alternative(s)
-----------------
FreeLAN
- doesn't support Windows Server (?)


Tuesday, March 18, 2014

Filtering on temp table

SETSELECTIONFILTER in temporary records
Regular record variables are looking at the actual table, so you can take the filter from one variable, copy them to another variable, and you get the same results, because the variable goes to the table and retrieves records from the physical table. No brainer right. You'd think that the same applies to temporary records right? Well that's where you are wrong, because temporary records don't have any values in them when you instantiate them, so when you fill only one of them, set filters, and copy the filters to the other one, it comes as no surprise that there are no values in there, BECAUSE IT DOESNT HAVE ANY VALUES.

You have a temporary record variable, which is empty when it is instantiated. You fill it up. Now it has records, temporary records that only exist in this memory space that is occupied by this single record variable. Now you apply a filter on this set of records. Now you want to apply the same filter to another temporary record, but you are surprised that you don't see anything in the other one. The other one hasn't been filed yet, it is uninstantiated!!! The second variable doesn't just read from the first variable, you have to actually put the records into the variable.

Think of a temporary record variable as a collection of objects. Rec (the temporary record variable that your form is based on) and NewRec (which is a global or local variable somewhere in your logic) are two different collections. One of them has been filled, but the other one has not been filled. The selectionfilter from Rec is properly applied to NewRec, but since there is nothing in there, you don't see anything.

Lookup form on temp table

FORM.RunModal(FormID, MyRecord) vs MyForm.RunModal
For showing temporary records, my observation is that:
- FORM.RUNMODAL will allow a temporary record to show up correctly, but
- MyForm.RUNMODAL will only show the main table even if SETTABLEVIEW is issued with the temporary rec as the variable.
...
but this raises another issue to watch for: if the form identified by FormID is a tabular form with the LOOKUPMODE property set to FALSE and EDITABLE to Yes (look at F100 Accounting Periods, for instance, compare with F89 Job List), then you would need to either change the Form properties LOOKUPMODE to Yes and EDITABLE to No (bad idea! this is an invitation to problems due to unforeseen side-effects), or better yet, create a copy of the form in which the properties are set as appropriate for a Lookup Form and use that form instead.

Thursday, March 13, 2014

MySQL related

Backup then restore to another db
How to Import and Export a MySQL database using HeidiSQL
- using version 9 of portable app, "Load SQL file" is located under File menu

How to Reset the Root Password

Moving an InnoDB Database to Another Machine
You can move an InnoDB database simply by copying all the relevant files listed in Section 14.2.6, “Backing Up and Recovering an InnoDB Database

What is the exact location of Mysql database tables in XAMPP folder?
I think the matter is your tables engine. I guess you are using InnoDB for your table. So you can not copy files easily to make a copy.
Take a look at these links:
...

Attaching an existing database with MySQL
simply copy the folder into the data folder for MySQL and restart the service the database will show up

TOAD: Error "Physical Memory is low (Paging)" when exporting [to Excel file]
Use Tools \ Export \ Export Wizard instead
On "Select Output Format" step, UNCHECK "Check system resources" option

Visually build query (table drag-and-drop): Toad for MySQL
Note to self:
For query containing datetime column, use "Export data to an Excel file"
"Export data to an Excel instance" seems buggy (datetime column exported as mysterious big number)

How to remove 1000-row limit in MySQL Workbench queries?

To enable access from remote computer
MySQL Workbench \ Management \ Users and Privilages \ Add Account
...note: "Limit Connectivity to Hosts Matching" can accept hostname

How install and configure mysql 5.6.16 in windows 7

Connect [Excel 2010] to a MySQL database
Download Microsoft Power Query for Excel
On Excel:
Power Query \ From Database \ From MySQL Database \ type at least servername ("localhost" will do) and  one of the schema exists then click OK


Thursday, March 6, 2014

PBX call duration restriction related

[Panasonic KX-TDA] Conversation Features
----------------------------------------------
Extension-to-Trunk Call Duration:
If a call between an extension user and an outside party is established, the call duration can be restricted by a system timer selected for each trunk group (→ Extension-to-Trunk Call Duration [472]). Both parties will hear an alarm tone 15 seconds before the time-limit at five-second intervals. If the timer expires, the line will be disconnected.
COS programming determines to enable or disable this feature (→ Trunk Call Duration Limitation [502]). Whether this feature is applied to outgoing calls only or all calls (how?) is also programmable.

Wednesday, February 26, 2014

[LINUX/UBUNTU] Administrative tasks related

“gzip: stdin has more than one entry--rest ignored” and “gzip: tmp.gz has more than one entry — unchanged”
this can happen if it's actually a ZIP-file rather than a gz-file, just with a misleading extension, and it contains multiple files. (gzip -d does support ZIP-files that contain only one file.)

In my case, that's exactly right:
$ file tmp.gz
tmp.gz: Zip archive data, at least v2.0 to extract

and using unzip rather than gzip -d worked perfectly.
---

How do I change the computer name?
do "sudo gedit" on /etc/hosts and /etc/hostname

Understanding File Permissions: What Does “Chmod 777″ Means?
for permissions, there are 3 type of actions that you can perform on a file/folder. You can either read, write or execute

Read is equivalent to ‘4’.
Write is equivalent to ‘2’.
Execute is equivalent to ‘1’


How do I mirror a directory with wget without creating parent directories?
self experience with
"wget --no-parent --no-host-directories --cut-dirs 1 -r -e robots=off http://host/dir1/XYZ":
when targetting directory XYZ, several files on "dir1" were downloaded too

How can I check disk space used in a partition using the terminal in Ubuntu 12.04 LTS?
df -h

How to edit files in a terminal with nano?

Launch app from menu as root
How to launch application as root from Unity Launcher?
NOTE: use 'nano' instead of 'vi' for easier operation
............if cursor not visible, try to perform string search ("Where Is") first
............when editing config files, use "-w" (source)

Checking version of application/package installed on Ubuntu
dpkg -s (packagename)

MOUNTING WINDOWS SHARE IN UBUNTU SERVER TERMINAL
Mount Windows Share on Ubuntu - Command Line
if you get "error(13): Permission denied", try using this syntax for credential:
"...-o username=someone,password=123456,domain=mydomain..."

Unlock The Root Account, Reset The Root Password, Change Username In Ubuntu 13.04

Xubuntu how to check used and free disk space
command: df -h

List xrdp (=xvnc?) sessions:
netstat -tulpn | grep Xvnc
to kill session, just type "kill" following by pid (righmost number return from above command)

Manageable switch related

HP V1910
-----------
(Web) View MAC addresses learned:
Network \ MAC

Even if your user has Telnet access enabled, you still have to explicitly enable Telnet service at:
Network \ Service

How to Mirror Ports on HP V1910 Series Switch - Tutorial on How to Configure
---

Allied Telesis AT-8000S
-------------------------
View complete MAC address table:
Web: Layer 2 \ MAC Address \ View Dynamic \ View
.........if it shows empty results, logout-login then try again
.........or, use different browser
CLI: in privileged (enable) mode, type "show bridge address-table"

Search a MAC address:

Web: Layer 2 \ MAC Address \ View Dynamic \ View MAC Address \ View


View next-hop switches/routers:
Web: LLDP \ Neighbors Information
CLI: show lldp neighbors (type "show lldp ?" to see other options)

Configuring Port Mirroring
---

Related
--------
Scenario: using wireshark to monitor traffic between voip gateway 192.168.0.1 and 0.2
- enable "Use promiscuous..."
- capture filter: (host 192.168.0.1 or host 192.168.0.2) and not broadcast and not multicast



Monday, February 17, 2014

Things to configure on fresh Windows installation

Change Computer Name
Add standard user
System Properties \ Advanced \ Performance Settings: Adjust for best performance
System Properties \ System Protection
gpedit.msc to configure Windows Update (if not join domain)

Softwares to install
-----------------------
PassDlg
Drivers
Note regarding Intel and NVidia:
...

Archiver (7zip)
Teamviewer
...How to hide the notifications of the Teamviewer (silent use)
FoxIt Reader
Realpopup
Antivirus (No need if there's Windows Defender already?)
Office
Firefox/Chrome
Download Manager

Printer

ffmpeg
freeSSHd

Monday, February 3, 2014

Sales entry: default Type to Item

go to sales line table->design-> view properites on field "Type" & Set the InitValue to "Item"

BUT...

The default value do not solve all cases, because do not forget that in Cronus there is modification, which copy the type from previous line (and overriding the default value)
See OnNewRecord on form 46
(in other word, if you have a line on Sales Line table with Type=(blank), InitValue will be useless)

source:
default type in sales order lines

Usage of NextControl property to speed up data entry

I have a customer who wants the following in Sales lines:

After entering the Quantity he wants teh system to automatically jump to the next line and lands on the "No." field to enter another Item number if available.

Any ideas on how to do that??

Just change the NextControl on the columns. So Control 1 will jump to Control 3, Control 3 will jump to Control 1.

set the NextControl of the QTY field to the ID of the No. field

source:
How to jump to the Next Line in Sales Lines?