Max Filedescriptor SQUID 3.4

2014/04/19 09:18:40 kid1| comm_open: socket failure: (24) Too many open files
2014/04/19 09:18:40 kid1| '/usr/luscaX/share/errors/en-us/ERR_CONNECT_FAIL': (24) Too many open files
2014/04/19 09:18:40 kid1| WARNING: Error Pages Missing Language: en-us

---***---

Solusi

Cek max filedescriptor
root@V:/usr/luscaX# bin/squidclient -h10.20.1.12 -p3399 mgr:info |grep file
Sending HTTP request ... done.
        Maximum number of file descriptors:   1024
        Largest file desc currently in use:   824
        Number of file desc currently in use: 824
        Available number of file descriptors: 100
        Reserved number of file descriptors:   100
        Store Disk files open:                  19

Tambahkan max_filedesc 8192, pada squid.conf
root@V:/usr/luscaX# sbin/squid -k shutdown
root@V:/usr/luscaX# sbin/squid -sYDC

Cek ulang max filedescriptor
root@V:/usr/luscaX# bin/squidclient -h10.20.1.12 -p3399 mgr:info |grep file
Sending HTTP request ... done.
        Maximum number of file descriptors:   8192
        Largest file desc currently in use:   1338
        Number of file desc currently in use:  909
        Available number of file descriptors: 7283
        Reserved number of file descriptors:   100
        Store Disk files open:                  19

dot BAT

Startup Delay

@ECHO OFF

START "" "C:\Mini zonk Server Queue.lnk"
ping -n 20 localhost >nul 2>&1
start "" "c:\Zonk Display.lnk"
ping -n 20 localhost >nul 2>&1
START "" "c:\2 Zonk Display.lnk"

---***---

Shutdown (matikan aplikasi terlebih dahulu, biar nggk hang)

taskkill /f /im zonk*

shutdown.exe -s -t 1

---***---

Static arp Windows7 gateway

netsh interface ipv4 add neighbors "KABEL" 192.168.179.254 00-0C-42-A4-9C-91

---***---

Remove driver printer

You can remove print drivers that are not associated with a local printer or connection using the printui.exe tool , in an admin elevated command prompt type

printui /s /t2

Be sure to remove the driver AND the package.

Cacti Monitoring

JUDUL MANUAL CACTI

GRAPH MANAGEMENT - EDIT - SELECT GRAPH TEMPLATE NONE
TITLE = NAMA DEVICE
AUTO SCALE = TIDAK DI CENTANG
UPPER LIMIT = 1000000 (1MB)

--- ***---

CACTI ERROR @WWW1

04/14/2014 08:15:26 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'145', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (140, 'traffic', '2014-04-14 08:15:25', '614753775')'

---

SOLUSI ~

#mysqlcheck -u root -p --auto-repair -c -o cacti

Enter password:

Install NetFX 3.5 on Windows 8 : Offline way

1. Open run (win key +r ) and, enter: cmd
2. Copy \sources\sxs\ from the mounted operating system build ISO image to dotnet35 or similar folder. For example:
 xcopy e:\sources\sxs\*.* d:\dotnet35 /s
3. Open run (win key +r ) again, and enter: gpedit.msc
4. Expand Computer Configuration, expand Administrative Templates, and then select System.
Open the Specify settings for optional component installation and component repair, and then select Enabled.
5. If you want to specify an alternative source file, in the Alternate source file path box, specify a fully qualified path of a shared folder that contains the contents of the \sources\sxs folder from the installation media.
example: d:\dotnet35

6. Go to Control Panel, select Uninstall or change a program, select Turn windows feature on or off
7. Check the box .NET Framework 3.5 (includes .NET 2.0 and 3.0)
8. OK, and done ...

Remove User Account From Logon Screen

1. Regedit
2. HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\CurrentVersion\Winlogon
3. Right click on the right pane and select New > Key
4. Enter the value: SpecialAccounts
5. Select SpecialAccounts that was just created and then right click on the right pane and select New > Key
6. Enter the value: UserList

7. On the left pane mark User List and then Right click on the right pane and select:
New  > DWORD (32-bit) Value
8. Set the value of the key to the user account name (i.e : share) and click OK
If you have more user accounts that you want to disappear from the logon screen, please repeat steps 7, 8

Show Hidden Shared Folder - Windows

1. Masuk ke cmd
2. Ketikan "net view ip_address /all"

C:\Users\INot>net view 192.168.179.102 /all
Shared resources at 192.168.179.102

Share name                    Type   Used as  Comment
-------------------------------------------------------------------------------
ADMIN$                        Disk            Remote Admin
C$                            Disk            Default share
Canon MP250 series Printer    Print           Canon MP250 series Printer
D$                            Disk            Default share
d1$                           Disk
E$                            Disk            Default share
E1$                           Disk
EPSON LQ-2180 ESCP2 (Copy 1)  Print           EPSON LQ-2180 ESC/P2 (Copy 1)
flash$                        Disk
HP Deskjet D2400 series       Print           HP Deskjet D2400 series
IPC$                          IPC             Remote IPC
print$                        Disk            Printer Drivers
prnproc$                      Disk            Printer Drivers
The command completed successfully.

3. Seluruh folder dan printer yang dishare akan ditampilkan. Untuk sharing yang dihidden, ditandai dengan $ 

Debrick E2500 : Recover Bad Flash

Schema Linksys E2500

Schema rs232-to-ttl

Ada kesalahan firmware dd-wrt yang tertera di http://www.dd-wrt.com/site/support/router-database untuk Linksys E2500, yang mengakibatkan router mengalamin boot loop seteleh kita melakukan upgrade firmware.

Sedangkan firmware yang berjalan dengan baik, dapat didownload di 

http://www.dd-wrt.de/phpBB2/download.php?id=21986

---

Ketika terlanjur mengalami kesalahan pemilihan firmware, E2500 hanya bisa diperbaiki melalui kabel rs232-to-ttl. Solusi 30/30/30 dan tftp tidak dapat digunakan.

1. Buat rs232-to-ttl, alat dan bahan bisa dibaca dari schema disamping ini..

2. Sambungkan kabel rs232-to-ttl ke pin vcc, tx, rx E2500 (disolder ke board)

3. Buka putty, pilih serial dengan speed 115200, Open
4. Nyalakan power E2500
5. Stop boot dengan menekan ctrl+c di layar putty
6. Muncul cfe>
7. Ketikan "nvram erase" kemudian (enter)
8. "reboot"
9. Router akan reboot, kemudian tekan ctrl+c lagi, dan masuk ke cfe>
10. Masukan perintah "flash -ctheader : flash1.trx"  
11. Router sudah siap untuk di flash dengan firmware yang baru. Pada tahap ini, jalankan Tftp client (tftp32.exe) dengan aturan :: - Tftp client , - Hostname router yang akan diflash, - 
11."reboot" lagi
12. ...

Google Docs Website Uptime Monitor

A few months ago a colleague pointed me to a few blogs that were sharing Google Docs spreadsheets that offered free uptime monitoring for websites. Here are the original links that I checked out:

• labnol.org
• techawakening.org

The original spreadsheet (first link above) allowed single-site uptime monitoring. The spreadsheet would email you at a specified interval (every 5 minutes, for example) if the status of the website changed. Another developer made some enhancements to allow monitoring of multiple sites and also to offer SMS reminders. I decided it'd be fun to improve the usability of the spreadsheet, so my version:

• moves settings to separate sheet
• moves sites to separate sheet
• adds "Active/Inactive" toggle
• stores last value var as sitename instead of row number
• cleans up messages
• supports additional sites without having to modify script's loop count
• moves log to separate sheet
• adds README with instructions
• adds Send Email and Send SMS toggles

Try it out for yourself! COPY THE SPREADSHEET

You'll find a README sheet that explains everything. You will find credits to the original authors (that did much of the heavy lifting) as well as a changelog within the script code. I have tested this on 199 websites with a 5 minute trigger interval; it ran for quite a while before giving me an error that "urlfetch" has been invoked too many times in one day. I'll re-post when I figure out what the limit is. I believe I had it run approximately 14,328 times before it quit, but I'll verify.

UPDATE: I have found a page that lists the quota limits per service for Google Apps. The urlFetch action should, at minimum be able to be called 20000 in one day. So, unless my math is off, something is wrong. I'm looking into whether or not this kind of thing (website monitoring) violates Google's TOS.

UPDATE 2: I've asked some questions at StackOverflow re: the quotas and TOS. View the post

UPDATE 3: Just added a few bugfixes re: email/sms notifications.

SOURCE : http://agileadam.com/google-docs-uptime-monitor

EXCEL Formula

Mengubah CASE secara otomatis

= PROPER() - capitalises the first letter of each word (like Title Case)

= UPPER() - forces all letters to be UPPER CASE

= LOWER() - forces all letters to be lower case

Menghitung waktu kadaluarsa

=IF(DATEDIF(TODAY();AB32;"Y")<1;(DATEDIF(TODAY();AB32;"Y") &" TAHUN " &DATEDIF(TODAY();AB32;"YM") &" BULAN "&DATEDIF(TODAY();AB32;"MD")& " HARI LAGI KADALUASA");"Masih Berlaku")

 - Jika BATAS WAKTU (AB) dikurangi hari ini adalah kurang dari 1 tahun, maka akan ditampilkan kurang berapa tahun , bulan dan hari lagi akan kadaluarsa

 - Jika >= 1tahun, maka akan ditampilkan "masih berlaku" monggo di ubah di bagian <1 , disesuaikan kebutuhan

-  sebenarnya kalau valuenya <1, makan nilai tahun yg akan dimunculkan adalah selalu 0 atau, malah nilai tahunnya d hapus sekalian? cuman dtampilkan lama bulan dan hari

- atau kalau memang masih menghendaki tahun jg ditampilkan maka <1 diubah menjadi <=1

VMWare [at] Windows8

Not enough physical memory is available to power this virtual machine with its configured settings.

You must add a setting to the config file to restrict Workstation to using a percentage of the host’s available RAM.

- First Shut down all running virtual machines and exit Workstation.

- Open the config.ini file located at C:ProgramDataVMwareVMware Workstation.

- Add this line to the file: vmmon.disableHostParameters = TRUE

- Save and close the file.

- Restart Windows.

If you are having this trouble and you have not installed SP 1, you might have a look at:

Resolving the error: The virtual machine is unable to reserve memory (1014955).

Source: VMware KB 1036185

SysBench : Mysql Perfoma Benchmark

Dalam melakukan benchmarking MySQL, pengembang MySQL merekomendasikan untuk menggunakan salah satu tool populer yang disebut dengan SysBench (dibuat oleh seorang pengembang MySQL). Software tersebut dapat diperoleh di http://sysbench.sourceforge.net/

SysBench menawarkan beberapa fasilitas yang dapat digunakan oleh administrator database untuk melakukan benchmark terhadap CPU, File I/O dan perfoma MySQL.

SysBench mengukur perfoma MySQL dengan cara membuat sebuah table test di dalam database 'sbtest' dengan 1.000.000 baris data. Perintah yang dijalankan adalah sebagai berikut :

sysbench --test=oltp --oltp-table-size=1000000 --mysql-db=sbtest --mysql-user=root --mysql-password=xxx prepare 

Setelah tahap persiapan, selanjutnya perintah untuk melakukan benchmark adalah sebagai berikut :

sysbench --test=oltp --oltp-table-size=1000000 --mysql-db=sbtest --mysql-user=root --mysql-password=xxx --max-time=60 --oltp-read-only=on --max-requests=0 --num-threads=8 run

Dalam perintah tersebut, SysBench melakukan benchmark perfoma MySQL  melalui table di database  yang bernama 'sbtest' yang telah dipersiapkan pada proses prepare. SysBench melakukan benchmark selama 60s (1 menit) dengan mode read-only dan dengan threads sebanyak 8.

Output dari perintah tersebut adalah :

***

sysbench 0.4.12:  multi-threaded system evaluation benchmark

No DB drivers specified, using mysql

Running the test with following options:

Number of threads: 8 (Jumlah threads)

Doing OLTP test.

Running mixed OLTP test

Doing read-only test (mode benchmark read-only)

Using Special distribution (12 iterations,  1 pct of values are returned in 75 pct cases)

Using "BEGIN" for starting transactions

Using auto_inc on the id column

Threads started!

Time limit exceeded, exiting...

(last message repeated 7 times)

Done.

OLTP test statistics:

    queries performed:

        read:                            443184 (Jumlah query Read pada saat proses benchmark)

        write:                           0 (Jumlah query Write pada saat proses benchmark, 0 karena read only)

        other:                           63312 (Jumlah query lain pada saat proses benchmark)

        total:                           506496 (Jumlah query Read + Write + Other)

    transactions:                        31656  (527.51 per sec.) (31656 =Jumlah transaksi yg dijalakan selama proses benchmark , 527.51= Jumlah Transaksi : Total Time)

    deadlocks:                           0      (0.00 per sec.) (Tidak ditemukan transaksi yang mengalami Deadlocks)

    read/write requests:                 443184 (7385.11 per sec.) (443184=Jumlah query Read+Write, 7385.11= (Read+Write):Total Time)

    other operations:                    63312  (1055.02 per sec.) (63312=Jumlah query Other, 1055.02= Other Operations:Total Time)

Test execution summary: (Penjelasan mengenai eksekusi Test benchmark yg dilakukan)

    total time:                          60.0105s (Total waktu yang dibutuhkan untuk menjalakan benchmark --max-time)

    total number of events:              31656 (Jumlah transaksi yg dijalankan selama proses benchmark)

    total time taken by event execution: 479.8432 (Perkiraan waktu yg dibutuhkan untuk menyelesaikan benchmark seluruh Threads ="Threads*Total Time")

    per-request statistics:

         min:                                  2.22ms (waktu minimal yg dibutuhkan untuk melakukan request)

         avg:                                 15.16ms (waktu minimal yg dibutuhkan untuk melakukan request)

         max:                                105.72ms (waktu minimal yg dibutuhkan untuk melakukan request)

         approx.  95 percentile:              23.08ms (95 prcentile waktu rata-rata yg dibutuhkan untuk melakukan request)

Threads fairness:

    events (avg/stddev):           3957.0000/11.50 (3957.0000 adalah rata-rata transaksi yang diselesaikan oleh setiap Threads "Transactions:Threads", dengan standard deviasai sebesar 11.50)

    execution time (avg/stddev):   59.9804/0.00 ( 59.9804 adalah rata-rata waktu yang dibutuhkan untuk menyelesaikan benchmark setiap Threads "Total time taken by event execution:Threads")

***

Dari Output hasil benchmark, nilai yang paling penting untuk diperhatikan adalah pada bagian transactions:        31656  (527.51 per sec.) . Jumlah transaksi yang dapat dijalankan SysBench setiap detik, merupakan nilai yang nantinya bisa digunakan untuk melakukan pembandingan.

AOMMMMMM!!!

Amazon Access Key ID dan Amazon Secret Access Key,
dari sini http://aws-portal.amazon.com/gp/aws/developer/account/index.html
kemudian http://aws-portal.amazon.com/gp/aws/developer/account/index.html

Menampilkan Categories yang di inginkan 

Cat ID : tablet
Name : Tablet PC
Amazon Category : Elektronics
SDK : UNCHECK!!!
Keyword : tablet
SAVE


Menampilkann produk di halaman depan :
Home Page - Browse Node - Home Node (Pilih Amazon Category dan tentukan filternya di Keyword) - SAVE

Catalist vlan configure

Cat01-OLA#vlan database       
Cat01-OLA(vlan)#vlan 116 na
Cat01-OLA(vlan)#vlan 116 name VLANN_RPL
VLAN 116 modified:
    Name: VLANN_RPL
Cat01-OLA(vlan)#exit
APPLY completed.
Exiting....
Cat01-OLA#conf t
Enter configuration commands, one per line.  End with CNTL/Z.
Cat01-OLA(config)#interface fastEthernet 0/16
Cat01-OLA(config-if)#switchport access vlan 116
Cat01-OLA(config-if)#spanning-tree portfast 
Cat01-OLA(config-if)#exit
Cat01-OLA(config)#interface fastEthernet 0/17
Cat01-OLA(config-if)#switc acc vla 116
Cat01-OLA(config-if)#exit
Cat01-OLA(config)#inter fas 0/48
Cat01-OLA(config-if)#switchport trunk  allowed vlan add 116

Cat01-OLA#write memory 
Building configuration...
[OK]

Beli domain di godaddy.com

1. Buka http://www.adsense-id.com/forums/showthread.php/128946-Jasa-Daftar-Domain-GoDaddy-Murah-Sajah

Nama domain: 123.comUsername GoDaddy: userEmail GoDaddy: user@gmail.com

2. Bayar lewat ebanking\smsbanking\atm
3. Cek mail masuk ..
4. Accept a Domain Name Into Your Account

- login ke mya.godaddy.com

- domains klik launch

- domains tab, klik pending account changes 

- Jika domain sudah muncul di  list — Pilih domain name, dan click Quick Accept.

Layer 7 Extension

Layer7-protocol file extension (Mikrotik 3.x)
---
/ip firewall layer7-protocol
add comment="" name="Extension \" .exe \"" regexp="\\.(exe)"
add comment="" name="Extension \" .rar \"" regexp="\\.(rar)"
add comment="" name="Extension \" .zip \"" regexp="\\.(zip)"
add comment="" name="Extension \" .7z \"" regexp="\\.(7z)"
add comment="" name="Extension \" .cab \"" regexp="\\.(cab)"
add comment="" name="Extension \" .asf \"" regexp="\\.(asf)"
add comment="" name="Extension \" .mov \"" regexp="\\.(mov)"
add comment="" name="Extension \" .wmv \"" regexp="\\.(wmv)"
add comment="" name="Extension \" .mpg \"" regexp="\\.(mpg)"
add comment="" name="Extension \" .mpeg \"" regexp="\\.(mpeg)"
add comment="" name="Extension \" .mkv \"" regexp="\\.(mkv)"
add comment="" name="Extension \" .avi \"" regexp="\\.(avi)"
add comment="" name="Extension \" .flv \"" regexp="\\.(flv)"
add comment="" name="Extension \" .pdf \"" regexp="\\.(pdf)"
add comment="" name="Extension \" .wav \"" regexp="\\.(wav)"
add comment="" name="Extension \" .rm \"" regexp="\\.(rm)"
add comment="" name="Extension \" .mp3 \"" regexp="\\.(mp3)"
add comment="" name="Extension \" .mp4 \"" regexp="\\.(mp4)"
add comment="" name="Extension \" .ram \"" regexp="\\.(ram)"
add comment="" name="Extension \" .rmvb \"" regexp="\\.(rmvb)"
add comment="" name="Extension \" .dat \"" regexp="\\.(dat)"
add comment="" name="Extension \" .daa \"" regexp="\\.(daa)"
add comment="" name="Extension \" .iso \"" regexp="\\.(iso)"
add comment="" name="Extension \" .nrg \"" regexp="\\.(nrg)"
add comment="" name="Extension \" .bin \"" regexp="\\.(bin)"
add comment="" name="Extension \" .vcd \"" regexp="\\.(vcd)"

/ip firewall layer7-protocol
add comment="" name=High regexp="^.*get.+\\.(exe|rar|iso|zip|7zip|0[0-9][1-9]|flv|mkv|avi|mp4|3gp|rmvb|mp3|img|dat|mov).*\$"
add comment="" name=Mid regexp="^.*get.+\\.(zip|rar|7z).*\$"
add comment="" name=End regexp="^.*get.+\\.(pdf|doc|docx|xlsx|xls|rtf|ppt|ppt).*\$"
add comment="" name=Video regexp="http/(0\\.9|1\\.0|1\\.1)[\\x09-\\x0d ][1-5][0-9][0-9][\\x09-\\x0d -~]*(content-type: video)"

----

http://forum.mikrotik.com/viewtopic.php?t=42064&f=9

How to change GRAPH TITLE ?

Graph Management --> selete Graph (Youwant to change)

1.change " Selected Graph Template " to NON --> Save
2.this page have show "Graph Configuration" Now! Can change title.......

Deb NAT

echo 1 > /proc/sys/net/ipv4/ip_forward
iptables -t nat -A POSTROUTING -o vlan509 -j SNAT --to x.x.x.x

php5-snmp-5.3.8 FreeBSD

Ketika terjadi error install php5-snmp pada FreeBSD,  maka uninstall terlebih dahulu php5-snmp
;;pkg_delete php5-snmp-5.3.8;; dan ;;pkg_delete net-snmp-5.7.1_2;;
Setelah itu perintahkan ;;reboot;;
lakukan install melalui port ;;/usr/ports/net-mgmt/net-snmp/;; dan  ;;/usr/ports/net-mgmt/php5-snmp/;;

dd-wrt port forwarding

Administration -- Commands --- "paste script berikut" --- Save Startup


iptables -t nat -I PREROUTING -p tcp --dport 80 -j DNAT --to 192.168.24.11:80
iptables -I FORWARD -p tcp -d 192.168.24.11 --dport 80 -j ACCEPT


@forward port 80

mysql backup - restore

membackup
mysqldump -uroot -p nama_database > nama_file_backup


merestore
mysql -u root -p nama_database < nama_file_backup