The
Ultimate
Business Machine

Technology, business
and innovation.

And, not least, about
the Mac.

Weblog Archive Cutedge

by: Bernard Teo








Creative Commons License

Copyright © 2003-2012
Bernard Teo
Some Rights Reserved.

Sun 19 Aug 2012

Universal Lion & Mountain Lion SQL Installers

Category : Technology/UniversalSQLInstallers.txt

I've finally managed to build new MySQL and PostgreSQL installers that will work on both Lion and Mountain Lion.

The MySQL installer includes the latest 5.5.27 release, while PostgreSQL is now at 9.1.4.

These installers will also upgrade your current MySQL and PostgreSQL installations and bring the old databases over. You can choose to do a clean install or upgrade a previous version.

The MySQL 5.5.27 Installer is available here, and the PostgreSQL 9.1.4 Installer is available here. Remember they work on both Lion and Mountain Lion.

Posted at 6:32AM UTC | permalink

Fri 17 Aug 2012

New PostgreSQL 9.1.4 Installer for Mountain Lion

Category : Technology/PostgreSQL914Installer.txt

Okay, after quite a bit of trial and tribulation, I have a new PostgreSQL 9.1.4 database installer that will work on Mountain Lion. 

To edit these databases, just use Liya, an easy-to-use GUI for creating databases, tables, fields and data on these databases.

It's now ready for download by following the link, above.

Unfortunately version doesn't work on Lion. I'll have to find out why.

Also, I'm trying to build a new MySQL 5.5.27 installer but I keep having problems with cmake 2.8.8. I hate cmake.

Posted at 2:13PM UTC | permalink

PostgreSQL Installer for Mountain Lion

Category : Technology/PostgresInstallerForMLProgress.txt

My PostgreSQL Installer doesn't work on Mountain Lion. I've worked two weeks to find out that the problem is caused by a security measure taken by Apple to quarantine an object that it thinks has been downloaded from the Internet.

Let's say my friend, Hai Hwee, sends me the working files for the Postgres installer over the web. I open one of the scripts using TextEdit. Now, if I make a change to the script, TextEdit will most helpfully (not!) mark that script as quarantined, so it will refuse to run if executed from the Unix command line. But it does this marking most surreptitiously, as an extended file attribute, so you can't find anything amiss just by looking at the file or even listing it in Terminal.

That's what's causing my Postgres installer to fail in Mountain Lion. The installer couldn't run one script in the package - because it had been quarantined after being edited in TextEdit. 

Somehow, only TextEdit does that. TextWrangler doesn't. I wanted to remove TextEdit totally from my Mac, but I can't. The Mac says "it's needed by OS X".

So, I might as well work on a new version of the Installer. It'll include the very latest version of PostgreSQL.


Posted at 4:50AM UTC | permalink

Fri 10 Aug 2012

WebMon for Mountain Lion 6.0.1

Category : Technology/WebMon6dot0dot1.txt

There are bugs all over the place whenever we move from one major OS X version to the next.

This time it's WebMon. Somehow, delegate connections between a table view and its controller has to be deleted and re-created when we move from Lion to Mountain Lion. I don't know if this is pervasive or if this only hit that one unfortunate NSTableView in WebMon but it's a warning we've got to peek at every corner of our code when we move our apps to Mountain Lion.

So, the problem in WebMon's case manifests itself like this : you need to create an SSL certificate, so you change the default domain name from "localhost" to that of your main domain in the lists of domains. For convenience, I will automatically change the domain name that gets matched into the SSL cert. But in Mountain Lion, the SSL cert's domain name remains stuck at "localhost". Very fun. This has now been fixed in version 6.0.1.

I also took the opportunity to update the IP address-to-country lookup mechanism with the latest mappings, as of 10th August 2012.

WebMon for Mountain Lion version 6.0.1 is here.

I've finally found the time to update the documentation with the screen shots from the Mountain Lion version and also did some editing. But I'm really planning to build on top of this version, as soon as as these ML teething problems subside. I have still to update the Luca and MailServe documentation, though. But one step at a time.

Posted at 4:24AM UTC | permalink

Thu 09 Aug 2012

Apple Must Share?

Category : Technology/AppleMustShare.txt

Samsung’s 2010 Report Says its Galaxy Would Be Better If it Were Just More Like the iPhone.

Actually this is all pretty depressing. 

How can Samsung not have been copying Apple, with "slavishly" being a most appropriate word to describe all that? 

But I think Apple could still lose, the way they lost the last one with Microsoft. 

Because it's Apple against the whole of human nature. It reminds me of the scene in that Ayn Rand novel, Atlas Shrugged, when the protagonist Hank Rearden succeeded in developing a high grade metal that could be used, among other things, to build good strong railway tracks. One would have thought the rail company would be excited but, no, it organised a consortium of his antagonists, the other metallurgy companies, to deprive him of the fruits of this success and, not coincidentally, the power that could fall to him, though honestly earned. How? By claiming that his invention is so good, so important to the good of mankind, that it has to be shared. 

Sounds familiar? Google actually made that same argument about Apple rather recently.

So, read the comments that accompany such articles. All the Android (and ex-Microsoft) techies are praying for Apple to lose.

Posted at 12:56AM UTC | permalink

Liya 2.0.7, finally released on the Mac App Store

Category : Technology/Liya207OnMacAppStore.txt

Liya 2.0.7 is finally available from the Mac App Store

It's almost three weeks since I submitted it for review (and three weeks since I made 2.0.7 available on my own web site). So it shows the perils for a developer depending solely on the App Store mechanism for distribution to end users.

I believe the way forward is to still concentrate on building the quality of the software offering that I make available on my own web site.

If I build it (well), experience tells me the users will come.

Posted at 12:49AM UTC | permalink

Wed 08 Aug 2012

MailServe for Mountain Lion 6.0.3

Category : Technology/MailServeForMountainLion6dot0dot3.txt

In the previous version, 6.0.2, I changed the way de-install works by forcing the user to stop Postfix and Dovecot manually before they can do a de-install. This was to ensure I have given every Postfix process sufficient time to finish their work before I delete the Postfix directory that was set up by MailServe. 

However that wasn't very popular and so I have reverted it. The users are not used to having to stop Postfix and Dovecot manually before they do a de-install. They expect the system to do it for them. I will have to find some other ways of ensuring the completion of Postfix processes before I kill the system.

So I have a new version 6.0.3 of MailServe for Mountain Lion for download.

This version of MailServe also introduces a new field to allow Dovecot users to control the number of concurrent connections a user can make to the server. The default is 10 but the administrator can increase it when it has multiple clients accessing the server from multiple devices. 

Finally this version fixes a bug in the Spam panel whereby the procmailrc file gets saved to the system with environment variables, like $HOME, etc... getting unintentionally expanded to hard-coded paths.

Posted at 4:03PM UTC | permalink

More Mountain Lion Differences

Category : Technology/NSTextFieldsInMountainLion.txt

Luca has been hit by another stealth change Apple made to Mountain Lion. 

NSTextFields in Mountain Lion now appear to have auto-formatting turned on (which is not the case with previous versions of OS X). In other words, when a number value is entered into a text field, the text field will automatically format its appearance according to the number display format the user had chosen in System Preferences. 

For example if 2012 is entered into a text field, NSTextField will automatically format it as 2,012, as shown below. 

NumberTextField.png

If you entered "abcd" into the text field, that will of course be displayed as "abcd". All very convenient. But if 2012 stands for the year we want to capture data for, then displaying it as 2,012 looks rather odd. Worse, when we take the value back as a string value and use it to compare against another string value like "2012", we find we're comparing "2,012" against "2012", thus throwing a lot of the embedded (and assumed) programming logic out of whack. 

And Luca isn't the only app that sits uncomfortably with this latest change that Apple deems fit to make. Look at Network Preferences, when you try to enter a port number for a network proxy :

NetworkPrefsProxy.png

Look at how the port number 8080 ends up looking like 8,080.

So, in Mountain Lion, we've had to go through a lot of our code to clean up stuff like that. There may be more lurking that we have not yet spotted. So let us know as soon as you see something that isn't working as it should.

Luca for Mountain Lion has now been updated to 5.0.1. Available now.

Posted at 2:57AM UTC | permalink

Tue 07 Aug 2012

MailServe on Upgraded Mountain Lion Macs

Category : Technology/MailServe6dot0dot2.txt

If yours is an upgraded Mountain Lion machine, as opposed to one that has been clean installed, you may see this problem in the log :
Aug  6 07:57:41 iMac.local postfix/postmap[2571]: fatal: bad string length 0 < 1: mydomain_fallback = 
Aug  6 07:56:54 iMac.local postfix/postqueue[2537]: fatal: chdir /Library/Server/Mail/Data/spool: No such file or directory
A clean-installed machine is OK - it doesn't exhibit this problem.

If yours was an upgraded Mountain Lion machine, the problem is that Apple assumes that it is doing a Mountain Lion Server upgrade and gives it the "wrong" main.cf file (meant for Mountain Lion Server).

Don't believe? Look at this in Startup Disk, Systems Preferences :

StartUpDiskAfterMtnLionUpgrade.png

My Lion partition on the left was upgraded to Mountain LIon, as opposed to clean-installed, unlike the partition on the right. The upgraded one shows OS X Server, 10.8, while the clean-installed showed OS X, 10.8, as it should.

I have a new version of MailServe, 6.0.2, that attempts to fix what Apple has wrought.

It attempts to give you a main.cf file in /etc/postfix that is meant for Mountain Lion client. I don't use /etc/postfix (I have my own installation directory in /usr/local/cutedge/postfix) but built-in commands like sendmail, PHP mail, and the mail command line still use the postfix config file in /etc/postfix, and that's the one emitting all these messages.

To fix this, run MailServe 6.0.2 and do a de-install from the Help menu. You must first make sure that Postfix and Dovecot are not running. Option-Click on their respective buttons to stop them. (Note :You may want save the current config from the File menu first). I patch the faulty /etc/postfix/main.cf in the de-install process.

After starting postfix again in MailServe, Mail.app should work with your server, plus all the other command line tools.

Posted at 12:26AM UTC | permalink

Mon 30 Jul 2012

DNS Enabler for Mountain Lion ver 6.0.1

Category : Technology/DNSEnabler6dot0dot1ForMountainLion.txt

I have a new version of DNS Enabler for Mountain Lion out. The Allow Dynamic DNS Updates check box in version 6.0 wasn't being synchronised with the actual state of the system, due to some new case-sensitivity issues in Mountain Lion. Version 6.0.1 fixes that.

Posted at 2:27AM UTC | permalink

MailServe on Mountain Lion Server

Category : Technology/MailServeOnMLServer.txt

Looks like MailServe will work on Mountain Lion Server also. Just leave Server's own mail service turned off. The Fetchmail that's bundled into MailServe will also work correctly then.

I'll test Lion Server more thoroughly when I can find the time, in a couple more weeks.

Posted at 12:28AM UTC | permalink

Fri 27 Jul 2012

Upgrade to Mountain Lion

Category : Technology/UpgradeToML.txt

I've got every one of my apps now running on Mountain Lion. There's a lot of powerful technologies underneath in every level of Mac OS X Mountain Lion (and in iOS 6). So it's something that I really want to build on (if only Apple could slow the pace of the changes so that we can actually build more new features, than re-tooling stuff to fit the changes they wrought).

So I want to encourage every one to get on board Mountain Lion by making any previous version of our apps upgradeable to its Mountain Lion version at the same standard upgrade price of $15 (except for Luca which is a bit more but I'm also thinking about that one), even all the way back to Postfix Enabler.

This way I can focus all our energies on this single latest version of OS X (and on iOS6) and integrating the features across all the Apple devices. Do check out the whole range of all our apps on our main Cutedge web site. Thanks to all the people who're upgrading – it's like seeing old friends once again.

Posted at 11:13PM UTC | permalink

Read more ...

Mac@Work
Put your Mac to Work

Sivasothi.com? 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.