Business Machine

Technology, business
and innovation.

And, not least, about
the Mac.

Weblog Archive Cutedge

by: Bernard Teo

Latest Joy of Tech!

Joy of Tech ... from Geek Culture

Creative Commons License

Copyright © 2003-2012
Bernard Teo
Some Rights Reserved.

Tue 08 Dec 2015

MariaDB for El Capitan

Category : Technology

I’ve given up trying to build MariaDB 10.1.9 from source for El Capitan. It’s too difficult and they don’t seem interested. I’m not interested in using HomeBrew. I want to be able to build it from source cleanly, without using an intermediary, like on other Unixes. Life is too short to waste on unnessary complexity.

Posted at 6:55PM SGT | permalink

Mon 07 Dec 2015

New SQL Installers for El Capitan

Category : Technology

I’ve built the latest MySQL 5.7.9 Installer for Mac OS X El Capitan, as well as the latest PostgreSQL 9.4.5 Installer.

Both are available from my home page at :


Posted at 11:47PM SGT | permalink

Sat 21 Nov 2015

MailServe for El Capitan 9.0.5 with Dovecot Replication

Category : Technology

I love the Dovecot Replication feature. I have always wanted to set up a backup of my live server, that is ready to go if (and when) my live server goes down.

I thought the hardest problem that I’ll need to solve to solve is to find a way to do a live backup of the mail server, so that one is a perfect, totally up-to-date replica of the other. 

That was until I discovered that Dovecot has a most excellent replication feature. It took me some time to figure out how to do all the Unix incantation to make it work – the documentation being quite sketchy. But here it is, in all its glory :)

I’ve implemented the user interface for the replication feature in MailServe 9.0.5.


Just 4 steps : 

1) enter the address of the replica server (that is also running Dovecot, as set up by MailServe), 
2) enter a shared secret between the two servers, 
3) turn the replication feature on, 
4) Restart Mail Server. 

And you need to mirror the same steps on the replica server. 

That’s it.

If one fails, you’ve got all your users’ mail folders completely backed up on the other. And it runs automatically. When new mail comes, or when a user rerranges the contents of his mail folders, the backup mail server gets all the changes, within seconds. And it works in both directions. Make changes in one server – the changes will all automatically show up on the other. Great?!

Dovecot and its author(s) – they’re so brilliant.


Posted at 7:05PM SGT | permalink

WebMon For El Capitan 9.0.2 • new version released

Category : Technology

I have a new version of WebMon for El Capitan. Details are on :


Posted at 6:19PM SGT | permalink

Wed 14 Oct 2015

El Capitan Server Upgrading

Category : Technology

I’ve finished moving my live server to El Capitan. It took too long. This is the first time I’ve done an upgrade instead of a clean install. I upgraded from Mavericks, actually, rather than Yosemite, and I’m already seeing quite a few problems.

For example, the Apache files on my upgraded Mac Mini look to be different from the Apache files on my development machines, which I’ve always kept clean by doing clean installs (mostly). So my web server couldn’t start up and it took a while to debug it. Mail and the DNS server both started up fine.

But I’m having problems with the Keychain. My apps can’t seem to be able to save passwords onto the upgraded Mac Mini’s keychain.

So, quite a few puzzles to sort out.  It wasn’t as smooth as I hoped it would be.

Posted at 12:56PM SGT | permalink

Upgrading to El Capitan

Category : Technology

I’m upgrading my live server to El Capitan. As in, right now. If you see the server disappear, it’ll hopefully be only for a while.

I’ve only got this Mac Mini that I’m using as a server because I’ve been saving my money for the next incarnation of the Mac Mini from Apple and that’s taking too long to appear. So if I want to move my one and only server right now to El Capitan, I’ve got to move it in-situ.

Once I finish typing and uploading this post, I’m going to start the upgrade process. 

And then start up all my Internet services using my own “enabler” apps. Time to eat my own dog food...

Posted at 8:44AM SGT | permalink

Mon 05 Oct 2015

El Capitan News

Category : Technology

If you happen to be looking for El Capitan versions of my apps ...

Posted at 4:59PM SGT | permalink

Mon 27 Oct 2014

Liya 3.0.5 now works with iCloud Drive on Yosemite

Category : Technology

I have a new version of Liya on the Mac App Store. This latest version, 3.0.5, when run on Yosemite, now works with the iCloud Drive :


Liya’s iCloud folder now appears with other iCloud-compatible apps’ folders (like Pages and Keynote) inside the iCloud Drive folder, allowing you to easily share SQLite files with other apps, on both Mac OS X and iOS devices.

Posted at 10:25PM SGT | permalink

Tue 21 Oct 2014

Free iOS Apps

Category : Technology

If you’ve been to our home page, you might see that I’ve featured two free iOS apps you can download:


WordScanner is the OCR scannning app I’ve always wanted to have on my iPhone. I read a lot of books and I often want to share what I’ve found on my Facebook page. So, what I wanted was to have an app on my iPhone where I can simply take a shot of the page I’m reading and then hope to lift the text right out of it so I can paste it onto Facebook or the Notes app or an email message.

And I wanted it all to be so drop-dead easy — I wanted it to work even if I can’t position the page precisely on the iPhone camera viewer, or if the lighting is not particularly good. And I need to be able to crop out my fingers holding the edges of the page. And I wanted it to work so fast that I can get the text onto Facebook before I lose inspiration for whatever I wanted to write about that I was reading.

I want it to never crash because OCR is particularly finicky and memory intensive. So I decided to write the app myself, using the open-source Tesseract OCR engine and some image editing code I found on the web. The result is WordScanner. I’ve had this app for a couple of months and I’ve used it to share a lot of stuff I’ve read on Facebook. And it hasn’t yet crashed, so that’s what I’m very happy about. When I first did this, it would crash every short while.

I really love this app, maybe because I had built it myself, but I’m happy to share it. It’s available for free.

BookNapper is another app for a book lover, but in this case it would only be really useful if you’re in Singapore. We’ve got this lovely, first-class public library that I always think of as our national treasure. It’s very current, so if you’re in a nice book shop and you see a nice book, chances are that our library would have it.

So what I do is, I scan the book’s ISBN number into BookNapper, which will then keep a list of books I want to read. BookNapper tells me if this book is available in our library’s collection , and if so, in which particular branches of the library system. (It also gives me the Amazon and Goodreads reviews). Then when I step into any branch of the library, Booknapper tells me which of the books I want to read is available in that library for borrowing, right then. And leads me precisely to the right shelves.

So it’s like a precision heat-seeking missile for taking out good books! And it’s available also for free.

WordScanner and BookNapper are both available on the iOS App Store now.

Posted at 6:26PM SGT | permalink


Category : Technology

New Yosemite versions of all our apps (except for Luca which will take a bit longer) are out now. 

MailServe has a new Dovecot binary (version 2.2.14). And so does DNS Enabler with a new BIND binary (version 9.10.1).

Actually I would be happier if Apple slows down the OS X releases because this way, we are struggling just to stay in place — we’ll never get much time to build new stuff if we keep going back to the apps to fix things that used to work on the previous releases.

Anyway, you get to all the Yosemite apps by going to our home page:


Posted at 5:45PM SGT | permalink

Thu 29 May 2014

Liya 3.0.4 does Chinese and UTF8 better

Category : Technology

I’ve released Liya 3.0.4.

Bug fix: Custom SQL Command field didn't allow the use of the Character Input Menu, e.g., to choose Pinyin to enter Chinese characters into the SQL query string. This has been fixed. 


Made MySQL connections work more like PostgreSQL connections, in terms of the choice of character set used. The character set used in each connection to the database follows that of the database. If at the point of the connection, no database has been chosen, then the connection defaults to using UTF8. New databases in Liya are created using UTF8 as the default character set. 

Also fixed a crash while importing and exporting databases that occurred after version 3.0.3, when Liya was made to be Sandbox-compliant.

Posted at 6:40PM SGT | permalink

Sat 03 May 2014

Liya 2.0.1 for iOS

Category : Technology

Liya on iOS is now a Universal binary that works for both iPhone and iPad, thanks to the AutoLayout feature in Xcode. 

With AutoLayout in place, it’s getting to the point where it really doesn’t matter what exact size an iOS device is anymore. Even if the iPhone gets larger, or we get an iPad that is intermediate in size between the iPad mini and the classic iPad, or even a giant iPad, it’ll all just (mostly) work. I love having just that single code-base to work with on iOS. Already I’m able to share a lot of code between the iOS and OS X versions of Liya (as with Hai Hwee on Luca). I have an idea to do a web app framework, something like PHP but in Objective-C—something like WebObjects. Then I can do a project that straddles iOS, OS X and the web—all accessing the same database libs to get to SQL databases.

There’s this Steve Jobs quote: "We used to dream about this stuff. Now, we get to build it. It's pretty neat."


Oh, and I’ve added an option for the port number to be given as a connection parameter.

The iCloud part continues to work well. We’ve been told that SQLite on iCould is not recommended. But it’s worked OK so far. So much so that I’m now quite far along with an iCould version of my BookNapper app (available on the iOS App Store), where you can run BookNapper on both your iPhone and iPad, accessing the same list of books on iCloud, to organise your search for good books to read. That’s also almost done now.



Posted at 4:09PM SGT | permalink

Read more ...

Put your Mac to Work Now how would you do something like that?

Weblogs. Download and start a weblog of your own.

A Mac Business Toolbox
A survey of the possibilities

A Business Scenario
How we could use Macs in businesses

VPN Enabler for Mavericks

MailServe for Mavericks

DNS Enabler for Mavericks

DNS Agent for Mavericks

WebMon for Mavericks

Luca for Mavericks

Liya for Mountain Lion & Mavericks

Postfix Enabler for Tiger and Panther

Sendmail Enabler for Jaguar

Services running on this server, a Mac Mini running Mac OS X 10.9.2 Mavericks:

  • Apache 2 Web Server
  • Postfix Mail Server
  • Dovecot IMAP Server
  • Fetchmail
  • SpamBayes Spam Filter
  • Procmail
  • BIND DNS Server
  • DNS Agent
  • WebDAV Server
  • VPN Server
  • PHP-based weblog
  • MySQL database
  • PostgreSQL database

all set up using MailServe, WebMon, DNS Enabler, DNS Agent, VPN Enabler, Liya and our SQL installers, all on Mavericks.