The
Ultimate
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


BookJetty


Creative Commons License

Copyright © 2003-2012
Bernard Teo
Some Rights Reserved.

Wed 02 Jan 2013

Luca in Chinese

Category : Technology

Hai Hwee has been working on a Chinese-localised version of Luca:

LucaChinese_1.png

That's how it will look like.

LucaChinese_2.png

This version includes various bug fixes and speed improvements. It's a version we hope we'll be able to sell on the Mac App Store.

And then onwards to a version of Luca for the iPad.

Posted at 12:38PM SGT | permalink

Thu 29 Nov 2012

Bug Fixes for Liya and LDAP Enabler

Category : Technology

I've fixed some bugs for Liya and LDAP Enabler for Mountain Lion.

Liya is now at version 2.0.11 (while the Mac App Store version remains stuck at version 2.0.9). I've fixed Liya so it'll handle SQLite fields declared as Bool. Liya will treat it as an integer, and map it to the NSNumber Cocoa data type.

LDAP Enabler is now at 2.0.2. In version 2.0.1, the password was not set correctly when a user was first created. You had to do a Change & Save Password explicitly to set the password correctly. Version 2.0.2 fixes this bug.

Posted at 10:37PM SGT | permalink

New PostgreSQL 9.2.1 Installer

Category : Technology

I've built a new PostgreSQL 9.2.1 Installer. It's available here: PostgreSQL_Installer_For_MacOSX.zip

I've built it, this time, with these configuration parameters : '--with-pam' '--with-ldap' '--with-krb5' '--with-gssapi' '--with-bonjour' '--with-openssl' '--with-libxml' '--with-libxslt' '--with-perl' '--with-python' '--with-tcl'

And it should work on both Mac OS X 10.7 (Lion) and 10.8 (Mountain Lion).

I've tested that this latest build of Postgres can now authenticate against an LDAP database (set up by LDAP Enabler for Mountain Lion) via PAM. 

I have still to make all this PAM/LDAP goodness work with just one click but at least the mechanisms work and I'll get there eventually. The idea is that you can set up a single logon mechanism via the LDAP database, and with that one userID/password combination, a user can get into the email, database and any other system. Next - I've got to make this work also with MySQL, which surprisingly, is harder to do than with Postgres.

One more thing - I've been troubled that with I've had to create a postgres user in order to run my previous installers. There's already a _postgres user built into every Lion and Mountain Lion system and I ought to be using it. So I've finally figured out how to make everything work with that built-in _postgres user. So, if you use this latest 9.2.1 Postgres Installer, you can safely delete the postgres user from your users' list in the Users & Groups Preference Pane, after you've run the installer and upgraded your current Postgres installation to 9.2.1.

Posted at 4:58PM SGT | permalink

Wed 21 Nov 2012

MailServe for Mountain Lion ver 6.0.6

Category : Technology

SMTP authentication via the sasldb password mechanism stopped working at some point in Mountain Lion.

I just released version 6.0.6 of MailServe to fix this problem.

It feels like deja vu. I had exactly this same problem when Apple upgraded the OS many years before : see http://www.cutedgesystems.com/weblog/index.php?entry=/Technology/panthersmtp-auth.txt. I solved the problem this time in exactly the same way - picking up the missing binaries from the previous OS, which, in our case now, is Lion. But for the long term, I must figure out how to build the sasl binaries myself. But that's hard.

Posted at 1:05AM SGT | permalink

Tue 20 Nov 2012

LDAP with JPEG Photos

Category : Technology

I've finally figured out how to get the LDAP Server to accept JPEG photos (tagged by the jpegPhoto attribute). Yay!

You will never understand how long I struggled, how much pain I had to endure :-)

LDAPSetup.png

And, more importantly, I've figured out how to get these photos to show up in the Contacts app when the LDAP record is displayed :

ContactsApp.png 

And LDAP Enabler works with all the drag and drop goodness we expect from the Mac, when you're matching photos to people. 

LDAP only supports (only?) the JPEG format. So drag and drop files with a .jpeg or .jpg extension.

LDAP Enabler for Moumtain Lion 2.0.1 is available for download now.

Posted at 9:57AM SGT | permalink

Thu 15 Nov 2012

Liya 2.0.10 for Mountain Lion

Category : Technology

I've also quietly released a new version (2.0.10) of Liya for Mountain Lion

Tabular data from Liya can be dragged and dropped onto a spreadsheet like Numbers but the number of columns brought over was always one short because of a stupid bug. This has been fixed in version 2.0.10. 

So let's see how long this will take to show up on the Mac App Store.

Posted at 10:51PM SGT | permalink

MailServe 6.0.5 and LDAP Enabler 2.0 for Mountain Lion Released

Category : Technology

I've released a new version of MailServe that will allow Postfix and Dovecot to authenticate against the passwords stored in an LDAP Server set up by LDAP Enabler.

This is what LDAP Enabler for Mountain Lion looks like :

LDAPEnablerMountainLion.png

And this is how it works with MailServe to allow Dovecot and Postfix to authenticate against LDAP :

DovecotLDAP.pngMailServeLDAP.png

In the coming months, I'll work at making the integration between MailServe and LDAP Enabler even tighter, in terms of the ease with which user records can be created and passwords set.

I've also used the chance to clean up the code related to the use of MailServe's Access field, which controls which IP addresses, domain names, and email addresses can be allowed to send mail to or through the server. Prior to this latest version, the Access field didn't work too well. Now it's a lot more accurate in implementing what the user's intentions are, as stated in the Access field.

So, MailServe for Mountain Lion 6.0.5 and LDAP Enabler 2.0, available now.

Posted at 10:46PM SGT | permalink

Thu 01 Nov 2012

MailServe and LDAP

Category : Technology

If you're waiting for news on the LDAP front, I've got news for you. I've managed to get the mail server authenticating against the LDAP Server database. 

LDAPAndMailServe444.png

Basically, what I have is Dovecot authenticating against the passwords stored in the LDAP Server, rather than the built-in OS X accounts' password system. And then I get Postfix to use the LDAP authentication so set up, for its own SMTP authentication. And it works, with or without SSL.

I did so many things and tried so many variations, so now I have to take a step back and figure out just what I did to make this work. Then I will make new versions of MailServe and the LDAP Enabler that will do all this for the user with just one click on their respective Enablers.

Actually I might have gotten most of this working in Chengdu last week, so it was a pretty productive week, even though I was traipsing around Chengdu. 

I think what I didn't realise, until I got back to Singapore, was that the PAM module for LDAP that I was using, pam_ldap.so, needs to be built again for the x86_64 processor that is the default in Mountain Lion. I was using a pam_ldap.so that was a fat PPC/i386 binary - absolutely useless on Mountain Lion - and that explains the crashes whenever PAM was called which was whenever a user tries to authenticate against the LDAP Server. I banged my head against the wall so many times in Chengdu. It only cleared when I got back to Singapore, and then it became crystal clear what the problem was. It's a mystery how the mind works.

Posted at 7:10PM SGT | permalink

Tue 23 Oct 2012

LDAP Enabler for Mountain Lion

Category : Technology

Here I am, sitting in a backpackers' hostel in Chengdu, China, and I've just built a working version of LDAP Enabler for Mountain Lion.

LDAPEnablerForML.png

Now that I have an LDAP Server running on my Mountain Lion MacBook Air, I can now move on to the next phase—getting a version of MailServe to work that will authenticate the mail server against an LDAP Server.

Posted at 10:56PM SGT | permalink

Sun 14 Oct 2012

Fetchmail & sslfingerprints

Category : Technology

I'm trying to Google for how to get the sslfingerprint for imap.mail.me.com

This is so Fetchmail can pull the mail down without a bunch of warnings that the communication is in cleartext.

If I can find a way, I'll post the method here. I'd like to set up a list of sslfingerprints for commonly used mail server certificates (sort of like an FAQ), or at least a usable method that can be followed by mere mortals to set up Fetchmail.

Posted at 11:17AM SGT | permalink

WebMon 6.0.2 for Mountain Lion, including Server

Category : Technology

I've just released WebMon for Mountain Lion 6.0.2. This is the first version of WebMon that will also work on Mountain Lion Server. 

You can use this single version of WebMon on both Mountain Lion client and Mountain Lion Server to set up WebDav, Apache, PHP, Server-Side Includes, Exec CGI, SSL certs, etc.

P.S. : With this release, I can confirm that the latest versions of my complete set of "Enablers"—MailServe, WebMon, DNS Enabler, DNS Agent—now also work on Mountain Lion Server.

Posted at 9:26AM SGT | permalink

Sat 13 Oct 2012

MailServe for Mountain Lion 6.0.4

Category : Technology

Updated MailServe for Mountain Lion to include Fetchmail 6.3.22. 

If you're having trouble fetching from a site that requires SSL, you should upgrade to this bundled version. To obtain this latest version of Fetchmail, do a De-Install from MailServe 6.0.4's Help menu, and then restart all the mail services.

PS : don't forget to save your config using the File menu, so that you can re-use the saved config before you restart the mail services.

Posted at 7:22AM SGT | 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

MailServe for Mountain Lion

DNS Enabler for Mountain Lion

DNS Agent for Mountain Lion

WebMon for Mountain Lion

Luca for Mountain Lion

Liya for Lion & Mountain Lion

Postfix Enabler for Tiger and Panther

Sendmail Enabler for Jaguar

Services running on this server, an iMac 2.66 GHz Intel Core 2 Duo, 4 GB RAM, 320 GB hard disk, Ethernet, Airport Extreme, Mac OS X 10.6.7 Snow Leopard:

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

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