11 February 2008 is start date Keterampilan Komputer dan Pengelolaan Informasi (KKPI), Java for Edu In Indonesia I (JENI I), JENI II and Cisco Certified Network Associate (CCNA) certification for Jardiknas student at AKATEL. All certification need internet connection. Until now AKATEL has 3 (three) internet connectivity, 2 Speedy and 1 connetion come from Diknas, before i decide to use Mikrotik, when one connection is drop some people complaint that and i ask they for change they gateway. And it’s all make me sick. Everyday i always find complain about internet connection. I try to give 2 gateway in DHCP server, but it’s not work. Well then i hear about mikrotik load balancing & two gateway failover with load balancing which will allow route from two internet connection to one private network. With that there is no problem when one internet connection drop. Lucky me

When i download mikrotik, i’m cause mikrotik file size < 15 MB. How impressive. After i install it to PIII with 256 MB RAM, i found new problem, how to configure mikrotik. Cause i’m blank in command line then i decide to use Winbox to configure Microtic from Windows. I try to find the right way to setting mikrotik use winbox and i find zero result. I’m stuck and for few days i forget about mikrotik. Mikrotik is suck.

In other day, i must to finish the internet connection problem. Then i try to find another tutor. I found that 2 things. I try it and it’s all done. It’s so easy. On that day i change my mind about command line Goodbye Winbox

Here the example page come from wiki.mirotik.com …

/ ip address
add address=192.168.0.1/24 network=192.168.0.0 broadcast=192.168.0.255 interface=Local comment=”" disabled=no
add address=10.111.0.2/24 network=10.111.0.0 broadcast=10.111.0.255 interface=wlan2 comment=”" disabled=no
add address=10.112.0.2/24 network=10.112.0.0 broadcast=10.112.0.255 interface=wlan1 comment=”" disabled=no
/ ip firewall mangle
add chain=prerouting in-interface=Local connection-state=new nth=1,1,0 action=mark-connection new-connection-mark=odd passthrough=yes comment=”" disabled=no
add chain=prerouting in-interface=Local connection-mark=odd action=mark-routing new-routing-mark=odd passthrough=no comment=”" disabled=no
add chain=prerouting in-interface=Local connection-state=new nth=1,1,1 action=mark-connection new-connection-mark=even passthrough=yes comment=”" disabled=no
add chain=prerouting in-interface=Local connection-mark=even action=mark-routing  new-routing-mark=even passthrough=no comment=”" disabled=no
/ ip firewall nat
add chain=srcnat src-address=192.168.0.0/24 action=masquerade
/ ip route
add dst-address=0.0.0.0/0 gateway=10.111.0.1 scope=255 target-scope=10 routing-mark=odd check-gateway=ping
add dst-address=0.0.0.0/0 gateway=10.112.0.1 scope=255 target-scope=10 routing-mark=even check-gateway=ping

add dst-address=0.0.0.0/0 gateway=10.112.0.1 scope=255 target-scope=10

add dst-address=0.0.0.0/0 gateway=10.111.0.1 scope=255 target-scope=10 distance=2

Hari minggu sampai selasa merupakan hari-hari yang menyebalkan. Minggu malam, lembur sampe jam 5 update data Sistem Informasi Manajemen, Akademik dan Kemahasiswaan AKATEL (SIMAK) , nambah sedikit script & upload ke server. Harus kelar malam itu, karena hari sebelumnya saya sudah informasikan ke mahasiswa, pengisian KRS Online mulai hari senin sampai sabtu. Yang bikin sebel, saya jatuh di lubang yang sama. Dulu waktu pertama kali kenal dengan yang namanya web hosting padahal dah ngalamin, klo di Linux itu CASE SENSITIVE. Eh … kemarin kq malah error lagi.

Senin, mahasiswa ada yg komplain ngga bisa login, setelah di cek ternyata, file permissionnya di masih otomatis di reset ma admin disana. Jadi session ga bisa disimpan di folder yang sudah saya tentukan. Setelah saya disable fungsi itu beres. Session bisa disimpan.

Selasa, saya pikir semua dah kelar, tapi ternyata ada mahasiswa komplain lagi.  :mad: Katanya ga bisa input KRS setelah di cek, saya baru ingat Case Sensitive PHP MySql di Linux Server. Beu …  :cry:

Semua dah tau kan apa itu case sensitive ?

Intinya klo case sensitive itu, Variabel1 dan variabel1 itu berbeda, penulisan huruf besar dan kecil itu dibedakan.

Yang saya alami, saya buat script PHP dan dicoba di windows, saya punya tabel yang namanya mahasiswa dimana didalamnya terdapat field NIM, waktu tulis script saya tulis

$sql=”select NIM, NAMA from MAHASISWA”;

Waktu dicoba di windows, script ngga masalah, tapi setelah di upload ke server yg menggunakan LINUX, tidak dikenali tabel yang namanya MAHASISWA. Sial … Alhasil saya harus sesuaikan semua script dengan nama tabel dan field di MySql.  :cry: Semoga tidak lagi jatuh di lubang yang sama. Ada yang punya pengalaman menarik waktu implementasi di OS yang berbeda ngga ?? Dishare ya boss  :mrgreen: