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.

Mon 03 Sep 2012

New Preference Panes for our SQL Databases

Category : Technology/NewSQLPrefPanes.txt

I've wanted to be able to run both MySQL and MariaDB databases concurrently. So, since they both can't run on the same port 3306, which is the default for both, I need to be able to allow one of them to start up on an alternate port.

So, this is our new MariaDB Pref Pane. And I've changed the MySQL and PostgreSQL Preference panes to make them work the same way.

MariaDBPrefPaneWithPortField.gif

These Pref Panes are included in each of the respective SQL installers that we've built : MySQL_Installer_For_MacOSX, MariaDB_Installer_For_MacOSX, and PostgreSQL_Installer_For_MacOSX. 

I've tweaked the installers so they'll work well with the new Preference Panes.

Note: When you run MariaDB off a different port from MySQL, you also need to change the location of MariaDB's socket. Our Pref Pane does that for you (it creates a socket for MariaDB at /tmp/mariadb.sock so that it avoids clashing with MySQL's /tmp/mysql.sock). 

When you access MariaDB (or MySQL for that matter because they work exactly the same way) over localhost, the client doesn't use TCP ports. Instead the client and server connect over Unix sockets. 

So, if you have either MySQL or MariaDB running on a non-standard port, and you want to access it via localhost, you need a way to specify the non-standard socket location. 

This necessitates a change to Liya. So Liya 2.0.9 now has a feature whereby the user can specify the socket location, as shown below :

MariaDBSocket.gif

So, all in all, I've had a rather busy week.

Posted at 12:43AM UTC | permalink

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.