Category Archives: Teknoblogia

Microsoft Access

Sudah beberapa hari ini saya menjadi programmer MS-Access 😀
Pengkhianat gerakan open-source ?

Saya punya prinsip bahwa komputer adalah alat bantu, maka harus bisa mempermudah – bukan mempersulit. Kini sudah banyak masalah yang bisa dipecahkan oleh berbagai solusi open-source, namun dalam kasus yang satu ini, kebetulan solusi yang paling tepat ditawarkan oleh MS-Access.

Masalahnya yaitu adalah bagaimana men-develop aplikasi berbasis database dalam waktu yang sesingkat-singkatnya (untuk keperluan perusahaan milik paman saya).

Setelah menilik berbagai alternatif yang ada (PHP, Visual Basic, Open Office, Access, dll), saya berkesimpulan bahwa Access yang paling memungkinkan untuk itu.
Sejak dulu memang ini kelebihan Microsoft – mereka pintar memanjakan developer, sehingga mereka betah di platform Windows. Walhasil penggunanya ya tinggal manut saja.

Jadi akhirnya kini front-end dibuat dengan Access, sementara database/backend-nya menggunakan PostgreSQL.
Berbagai wizard di MS-Access memang sangat membantu untuk kerjaan2 rutin yang memakan waktu – membuat form/report standar, dst.
Untuk menghemat lisensi yang perlu dibeli, rencananya nanti Access akan dijalankan dengan Wine di server, dan lalu diakses via remote X / LTSP session oleh user.

Sekarang saya sedang menunggu apakah Open Office 2 bisa menawarkan fasilitas yang setara / lebih baik dari MS-Access. Atau kalau ada yang lainnya yang sudah ada, silahkan beritahu saya, trims.

Solusi remote access aman, kencang, dan murah

Fasilitas remote access / mobile working kini semakin populer arena berbagai alasan. Ada yang perlu mengakses data-data perusahaan kapan saja, ada yang ingin bekerja dari rumah, ada yang bekerja di akhir pekan, dst. Implementasinya juga bisa bermacam-macam caranya; VPN bisa memberikan akses tak terbatas ke jaringan komputer perusahaan bagi staf Anda, namun cenderung mahal dan butuh staf khusus untuk maintenance-nya. Atau bisa juga layanan-layanan tertentu dibuka aksesnya dari Internet, namun ini berbahaya karena bisa di-crack oleh penjahat di Internet.

Satu solusi lagi adalah dengan menggunakan Remote Administrator. Kelebihannya adalah :

  • Cukup membukakan akses ke satu komputer Remote Administrator server di firewall. Akses ke komputer-komputer lainnya di LAN kemudian jadi bisa dilakukan. Caranya, sewaktu membuat koneksi baru di Remote Administrator Viewer, pilih “Connect through host”, dan kemudian masukkan IP address dari komputer Remote Administrator server ybs. Lalu di “IP address or DNS name” masukkan IP address komputer yang ingin Anda akses – selesai.
  • Aman – Famatech (pembuat Remote Administrator) cukup peduli soal security komputer, dan semua komunikasi antara server – client di-enkrip dengan cukup baik.
  • Kencang – kecepatan akses Remote Administrator hanya kalah dari Terminal Server / Citrix Metaframe. Ini sangat menarik terutama untuk akses via modem, yang notebene tidak terlalu kencang kecepatannya.
  • Murah – dibandingkan dengan berbagai kompetitornya, harga software Remote Administrator sangat murah. Saya sudah membeli lisensinya untuk keperluan saya pribadi.

Semoga bermanfaat.

Goodbye England

Finally, after living in UK for 6 years, it’s time for us to return back to Indonesia. Our parents are now old, so we’d like to be together with them while we still can.
Since we already got UK’s Permanent Resident status, we can always go back to UK pretty much anytime we want to anyway, should we change our minds later in the future.

But for now, goodbye England.

Masalah temperatur

Kebetulan membaca artikel ini, disitu diingatkan mengenai suatu hal yang jarang dibahas – perhatikan temperatur di ruang server Anda.

Kita sudah bersusah-payah membuat server kita tahan banting dengan banyak cara – pasang UPS, RAID, prosedur backup, dst; tapi kita justru sering lupa memikirkan apa yang akan terjadi jika AC di ruang server mati ?

Beberapa server bisa shutdown sendiri otomatis, namun beberapa harus kita konfigurasi untuk demikian terlebih dahulu – kalau tidak, maka server Anda rusak karena kepanasan.

Untungnya, jika AC di ruang server mati, biasanya ada cukup waktu untuk shutdown server secara manual sekalipun, sebelum suhu ruangan menjadi terlalu panas. Tapi kalau Anda tidak tahu, tentu tidak bisa melakukannya. Untuk itu, memasang alarm temperatur adalah ide yang baik, misalnya – [ 1 ] – [ 2 ] – [ 3 ] – dll.

Tapi kalau server Anda terlalu penting dan tidak bisa di-shutdown karena ini, lebih baik Anda juga membeli AC portabel misalnya.

Sekali lagi, jangan lupakan soal temperatur, atau Anda bisa jadi akan sangat menyesal di lain hari.

Public EWS

After observing the late tsunami disaster and events around it, I think only a Public EWS (Early Warning System) will be able to protect us significantly from such thing in the future.

The problem was not because of lack of EWS – there were reports on newspapers that warning has been sent to bureaucrats around the world : Thailand, India, and probably to Indonesia as well.
However, the warning got lost in the bureaucracy – and the tsunami managed to hit the people before they even know what it was.

Therefore, there should be a similar system, but available for public. So in case of another disaster, the bureaucrats won’t cause so much death again anymore – we’ll know straight away, and can take the appropriate action ourselves.

It’s a disgrace really that we have to do this, since we already elected and paid the bureaucrats to serve us. But if we value our lives, looks like we need to take matters into our own hands.

So here’s a list of things to do :

  • Raw data is already available from [ LISS ]. To my knowledge, we can use this freely, especially since this is not a commercial venture.
  • Need to convert raw data to earthquake co ordinate
  • Need to develop a reliable algorithm to find out if the quake will cause tsunami – does the epicenter is on land or sea ? Is it strong enough to cause tsunami ? etc
  • Notifications : SMS, email, pager, efax – make this done as much as possible by the machine, to speed up the process.
  • Security : notifications should only be send after the analysis verified by an on-watch geologist. The geologist will then press the red button – and only then the notifications will be send to all over the world.
  • Need someone to manage the contacts : we don’t want everyone to subscribe because false alarm may then cause chaos. But we also want as many people subscribed as possible – not just the politicians/bureaucrats (which may prioritise a political interest over a warning). Universities and NGOs are good contact points.
  • Need to develop the system to be resilient : make it easy to run multiple servers providing this service, with automatic fail-over when the master suddenly become unavailable.

Those are the requirements that I can think of so far.

Yes, indeed we’ll need to consult a geology expert to create this system, especially to develop the algorithms. I think this would make an excellend PhD thesis *hint* *hint*

What I can offer : I have a dedicated server on USA which can be used to develop and host this service. I may also be able to join in the development soon if it uses PHP/Ruby.

If anyone’s interested, let’s get in touch and co ordinate our efforts.

Computer appliance

I have a feeling that Apple will make another breakthrough again – finally establishing computer as an appliance, with the launch of Mac Mini.

People may finally start looking at computer as yet another household appliance – just like a microwave, fridge, washing machine, DVD player, etc. People will just use it, without needing to know much how it works under the hood.

It’s good because it’ll make computer more ubiquitous, and people will be able to benefit from it. It’ll hopefully enable people to do things they were not able to do before – sell their goods online / work from home, socialize with people on the other part of the world, finding out the knowledge pools on Internet, etc..

However, if that does happen, Apple will also need to think of a way to make sure that they all stay secure, seamlessly / without burdening the users. Something like Windows Update / Debian’s “apt” facility, but making sure that it won’t break things (unlike a few updates from Microsoft). It should be MUCH easier though, because Apple is working on a homogenic environment – unlike PC’s various configurations. So it’d be a complete disgrace if Apple failed to do this.

That said, I still won’t use Apple’s computers, because they’ve had bad track records on customer service – irreplaceable iPod battery, proprietary hardware/software, etc. I don’t like being locked into a certain vendor, it makes me feel like a hostage to their wishes. (and it has happened before)
However, don’t worry, I won’t criticise your personal decisions about this 🙂 I have too much things to do.

I’d be interested to see how the PC camp will react to this though.

Oracle versus MySQL

There have been a quite good discussions regarding Oracle and MySQL in [ this ] particular Slashdot post.

Clearly, in terms of high-end features, MySQL is FAR from matching Oracle.
Example, this is the shortest paragraph that quite nicely explains what Oracle really is. It’s just too mind-boggingly different.

Howeever, MySQL is more popular due to being available for free and good enough for most people. Which I have no problem with, in fact I’m using MySQL myself.

If you’re interested in more comparisons, then click here.

A note on database portability (since I was involved heavily on this topic for months) – even though this poster said that moving from Oracle is the hardest, in reality, I suspect that pretty much all database migration is painful. I’ve migrated a few apps which uses MySQL to Oracle, one of them actually already used ADODB – yet there were still problems that made me pull my hair.
MySQL broke quite a few ANSI-SQL standards – although to be fair, I imagine that Oracle extended quite a lot of them instead; so that if you have apps optimized for Oracle, then you’ll experience hell if you want to migrate it.

Back to the topic – the right way to compare Oracle / MySQL / whatever is not just strictly from performance / feature-set. If you do it this way, be prepared to be nastily surprised.

For example, the potential problem of going with Oracle are quite a lot as well.
First, you may encounter problems with its complex licensing scheme. Second, you need a highly skilled Oracle DBA specialist to be able to fully utilise it – jack-of-all-trade like me just won’t cut it. Third, if you think Oracle is expensive, the support cost may deter you from actually purchasing it (not buying support contract is plain suicide). Etc.

If those still doesn’t stop you from buying Oracle, then here’s a tip to make it easier on your budget.

In the end, the right way to compare (database) software is by comparing it against your own criterias / needs / requirements. Any other way, and you may be disappointed later in the future.

Apache versus IIS

I post this because I remember when I was in a meeting with several managers and other techies regarding a requirement to host an IIS-based web-application. The corporate standards for 5 years have dictated no use of IIS for external-facing web-services.
However, this particular application is specifically coded to run on IIS, and it’s meant to be publicly available over the Internet.

I started the meeting saying that, contrary to popular belief, IIS can actually be hardened to be secure enough to serve on Internet now. I can see rather shocked faces of people in the room, seeing this statement coming from an Apache “specialist” and open source advocate.
But that’s the truth as I know it, and I think nobody would benefit by hiding it.

However, the problem with IIS nowadays lies somewhere else :

  • Cost: Another popular belief is that IIS, being bundled by Windows server, is free. This can be very untrue. So far I’ve found 2 scenarios where using IIS may cost you dearly; for commercial webhosting, and when used to authenticate Internet users against Active Directory. And this may change (God knows for better or worse) in the future if Microsoft feels like it.
    Apache doesn’t and won’t cause you to suffer from these things.
  • Dependencies: I must admit that Microsoft is doing such an excellent job on getting their developers happy and make most of them uses Microsoft products. This is because Microsoft has made it easy to do so, and hard to do otherwise. However, this means that an IIS-application will be, most of the time, dependent to other Microsoft products – Active Directory for authentication, MS-SQL for database server, Exchange for email, and so on. So if one day you’re offered an IIS-application at a bargain price, examine again – it may require you to deploy a plethora of other products, that may cost you an arm and a leg.
  • Support: The dependency issue (see above) brings another issue – support. When you buy IIS and got Active Directory/MS-SQL/Exchange/etc as well; you need to ask yourself, do you have the staff to provide support to those products in case of problem ? If you don’t, then when a problem occured, then it will be you that’ll be under fire from the users – not Microsoft.
    (technical support ? obviously, you still think that paying thousand of dollars for silver level support will enable you to solve all problems in your mission critical apps in minutes – sorry, that’s not the case. Not even in hours in many cases. Yes, I’m being grim, or should I say realistic instead)
  • Security : Hey, didn’t I said that IIS6 is secure now ? OK, so IIS6 isn’t so full of holes like IIS4/5. However, when a hole is found, can you expect Microsoft to promptly patch it ? Unfortunately, this is not always the case. It’s already known that it may take even years sometimes for Microsoft to close a severe security hole. It doesn’t really give you a peace of mind, especially when you know that there are tools available in the underground communities that exploits this.
    Apache, and other open source software, on the other hand have been known to patch their security hole very quickly, sometimes in hours.
  • Lock-in : Miguel de Icaza and his Mono team does a stellar job making sure .NET is available on other platforms – not just Windows. However, the Windows lock is still there – a few months ago I was evaluating a .NET application, and found that it won’t run on Mono because it depends on an ActiveX component. So do be careful.
  • Security : Hey, again ?! Yes, I’ve seen cases where the security administrator wants to significantly secure the IT infrastructure by replacing the browser with alternatives (such as Firefox) – but can’t, because some critical IIS-applications tend to require, guess what, Internet Explorer.

I think there are a few more problems with IIS, but I’m very tired at the moment so that’s it for now. Hope it helps enlighten someone else out there.

MySQL tuning

I’ve been notified of “Too many connections” errors lately (thanks to logcheck), and I just realized that I think I’ve missed a few emails from Yahoogroups.

So looking around, I found out that MySQL’s table_cache was set to 64, and max_connections at 100. While table_cache really should be (max_connections * N), where N is the max number of tables that may be in a JOIN operation at anytime.

No wonder that, when checked with mysqladmin -p status, table_cache always peaked at its maximum.
O-u-c-h.

table_cache has been raised to 512, and the server is running happily now.

For those who suspect that they need to tune their MySQL installation, here are 2 good links :
[ Tuning MySQL ]
[ Tuning MySQL 4 ]

Enjoy.

Uncle Scrooge

Bill Gates of Microsoft loves to be seen as the generous Uncle Bill. However, his true self was revealed recently. We had the biggest, most destructive natural disaster in decades – and Uncle Bill, the richest man in the world, can be only bothered to donate US$ 3 millions.

Compare this to Mr Schumacher, who donated US$ 10 millions straight away.

I think I’ll be watching F1 more often now then buying Microsoft software.

Source: [ Wikipedia ] (see near bottom of the page)

Multi-function device

I’ve been interested in and looking for an ideal multi-function device for years now, partly because it’ll enable me to work anywhere anytime, without getting bogged down with big & heavy equipment.

The Treo 650 looks most interesting now, especially after a series of hacks which increased its capabilities significantly.

However – at this form-factor, I’ve found they’re still not powerful enough, because Li-ion (at that size) simply still doesn’t have enough capacity to power a more powerful processor, for an acceptable length of time.
Various wireless features (bluetooth, WiFi, GSM, etc) also suck on batteries like babies on milk bottle.

So after years of waiting, I must concede defeat, and will forget my dream for now – until a much better battery technology become mainstream.

Aceh disaster information

In the last few days, I was still in shock over the tsunami & quake disaster that hit Aceh. Personally I’ve lost contact with a few friends, and we don’t really expect to hear from them again. Then I looked around, and try to think of what I can do about this.

Being so far away, the easiest thing is to donate money. Since I’m a UK taxpayer, I can make my donations goes further by claiming Gift Aid – which will make the UK gov add 28% from my donation to it.

Looking around, I also see there’s something I can do with my computer. Many existing websites on Aceh Disaster are not easily updated, and only its webmasters can do that. Also I couldn’t find any of them offering information in English – which is vital if we want to keep the world informed about it and thus able to donate/help the victim. Or to help inform English-speakers who happen to have friends/relatives in Aceh.

So I created aceh.abangadek.com, as a complement to other websites that already exist out there.
I based the website on phpWiki, so anyone can put in bits information that they have into it. Also I’ve started providing an English section on it.

I do realise that the most help can be done by being out there on Aceh itself, but being so far away, there’s only so much that I can do. So I’m not expecting much from all of this, even if it can help 1 person then it’s already worth my time.

Let us do all that we could to help the people of Aceh.

Against the Spammers – part 1

Do good – help kill a spammer today.

Recommended link-of-the-day : [ The Lad Vampire ]

The Lad Vampire specially targeted fake bank websites. They seems to be quite careful not to target an innocent victim, and they have actually shut down scammers’ websites.
And they already got many applause – from The Register, Computer Times, Monterey Herald, The New York Times, etc.

Funny links:
# A scammer got scammed and lost his gold
# 419eater.com is a website which, among others, get scammers to make silly photos of themselves, and then posted for the world to see.

I have a feeling this won’t be the last post on this topic, so see you soon.

note:
do NOT use the alternate SpamVampire (the one located at feedbackarchive.com). It seems that they’re not a very careful bunch, at least they’ve targeted one innocent victim (123count.com) – and one victim is one too many already.