Set up MySQL server using a Mac Mini Server with Lion and a Promise Pegasus R6

Recently, I set up a Mac Mini server (with Mac OS X Lion) and a Promise Pegasus R6 Thunderbolt disk array as a mysql server for a client of mine. I had to learn few things in the process and I thought I would share the details for those who may need them in the future.

Setting up the server was fairly simple. It’s a Mac, few questions answered and the server is set up.

However, when I started with the Pegasus, I hit few snags.

Read the rest of this article

Turning on compression in Mac OS X Snow Leopard Server’s Apache

I received a couple of MacMini servers, with Snow Leopard Server installed, as a donation for the site. I went ahead and added them to the server farm as web servers. However, testing showed that no compression of web pages was happening and requests served from those servers were consuming far too much bandwidth. The management software for those servers didn’t seem to allow one to configure mod_deflate to turn on compression.

Read the rest of this article

Hotmail access using POP3 protocol

Finally, Microsoft follows the industry standards and has a reasonable mail service. It is now possible to use the POP protocol to send and receive email from hotmail.

Instructions for Apple’s Mail application on Leopard:

In Mail go to Preferences, and click on Accounts

Click the plus button (lower left) to add a new account

In the Add Account panel, enter your Name and your hotmail (or live) email address and your password and click ‘Continue…’

In the ‘Incoming Mail Server’ panel select ‘POP’ from the Account Type menu, and give the account a description

You must fill in the following information correctly:

Incoming Mail Server: pop3.live.com
Username: Your Hotmail address (with @hotmail.com, @live.com extension included)
Password: Your Hotmail password
Click on Continue

Set the Outgoing Server to smtp.live.com, then click Continue, and click ‘Create’.

On the other hand, I use PowerMail instead of Mail, which makes things a little more interesting.

In PowerMail do this:

From the Setup menu select ‘Mail Accounts…’
In the ‘Mail Accounts’ panel, click the ‘New’ button on the top left.
Give the account a description.

Under the ‘Identity’ tab, enter your hotmail email address and your name.

Under the Receiving tab:
Protocol: POP3
User account ID: your complete hotmail/live address
Incoming mail server: pop3.live.com
check the save password box and enter your password.
Under Advanced, check the ‘Use secure connection (SSL/TLS) box and make sure the ‘On a dedicated secure port’ radio button is selected.

Under the Sending tab:

Outgoing SMTP server: smtp.live.com
check the Authenticate as user box and enter your full email
password: your hotmail password.

Under ‘Advanced’ check the ‘Use secure connection (SSL/TLS) box and make sure the ‘Using the STARTTLS command’ radio button is checked.

Changing the system’s default settings for html files (safe)

With Leopard 10.5.1, Apple’s developers changed the default status of html files downloaded from the internet from ‘safe’ to ‘Unsafe’.

While this may make sense from a security standpoint, for somebody like me that processes hundreds of html files downloaded every day, it’s a big annoyance.

I filed a bug with Apple, asking for a workaround. I was hoping that they would implement a preference somehow to enable me to either override the default settings or allow me to specify trusted servers.

Tonight, three months later, I received an answer and the workaround that I was looking for.

I turned out that you could have a user specific file to override the system’s default settings. The file is not there normally, so you would need to create it. It is:

~/Library/Preferences/com.apple.DownloadAssessment.plist

The contents of the file need to be:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
	<key>LSRiskCategorySafe</key>
	<dict>
		<key>LSRiskCategoryContentTypes</key>
		<array>
			<string>public.html</string>
			<string>public.xml</string>
			<string>public.php-script</string>
			<string>com.microsoft.windows-media-wmv</string>
		</array> 
		<key>LSRiskCategoryExtensions</key>
		<array>
			<string>xhtml</string>
		</array> 
	</dict>
</dict> 
</plist>

Download Sample File

Hopefully that helps somebody else with this type of problem.

If you need to change the settings of other file types, here are the system-declared file types:

System-Declared Uniform Type Identifiers

For each type you add another <string></string> item to the above array.

For example, for jpeg2000 files you add:

	<string>public.jpeg-2000</string>

Right below the other <string> line in the first array.

To declare files by extension, you add:

	<string>odf</string>

Right below the other <string> line in the second array.

Update 2011-08-01: Safari 5.1.0 Ignores com.apple.DownloadAssessment.plist.