Category Archives: Apple Mac

installing postgres and tomcat on the mac

Posted on by
3

Back when I was setting up my Mac, I installed Eclipse 3.7.  I also installed Postgres and Tomcat so I could run locally.  Postgres was either unnecessarily frustrating or it required knowledge I didn’t know I was missing.  The whole shared memory thing should have been a clue.  The good news is that I think I did almost everything wrong one could so I have a nice list of problems.  I wrote this up two months ago, but waited to post until I understood better what was going on.

I learned I didn’t know where the applications folder is on the hard drive.   First I learned you can view the path of a file in the finder. Which is all well and good.  It tells me the path is Macintosh HD > Applications > Eclipse.  Awesome.  On a UNIX file system, a directory has a slash up front.  Ok.  So I’m now at a UNIX prompt looking for it.  No Mac HD at the root level.  Volumes looks promising so I cd there and see Macintosh HD as a choice.  Great.  And there’s even an Applications folder under it with my apps!  I found it without having to use “find.”  That wasn’t bad, but it was more surprising than I expected.  I also noticed there is /Applications which will be more convenient next time.

Also, the “one click installer that doesn’t tell you what it is doing” installs some things by unzipping to the directory you are in, some files to /Library and presumably some files to who knows where.  Now I see the scripts I was expecting.

initdb doesn’t have enough privileges as me so I tried root and got initdb cannot be run as root.  Ok so it’s a real UNIX install where I need a user to run as.  I wasn’t expecting this because all my previous installs on the Mac have shielded me from a real UNIX install.

I thought I needed to create a  postgres user to run the database.  In Apple’s system preferences it tells me an id with that name already exists.  But /etc/passwd says nothing about it.  Running

dscl . -list /Users UniqueID

does turn up a postgres id. I need to figure out how the Mac Directory Service thing works.  Anyway, now that I know the postgres users exists I did “sudo passwd postgres” to reset the password to something I know.  Turns out the “sorry” message when trying to sudo to postgres wasn’t from an incorrect password.  Eureka!  I needed to type “sudo su postgres” and then type *my* admin password to switch.  Which kind of makes sense because my regular id isn’t allowed to switch user but my sudo admin user is.

I then changed owner of /Library/PostgreSQL recursively to postgres user.  A nice easy step.  (sudo chown -R postgres /Library/Post*)

Finally, I could run initdb and get prompted for the new superuser password!

I then tried to start the database and got a complaint the lock file already exists.

FATAL:  lock file “/tmp/.s.PGSQL.5432.lock” already exists

HINT:  Is another postmaster (PID 94) using socket file “/tmp/.s.PGSQL.5432”?bash-3.2$

Tried rebooting.  Error still there.  Turns out postgres automatically starts up.  I went on to create a user and database using the usual commands.

Then I opened pgadmin to see if I could access the database.

Connected – maintenance db is database name.

Almost there.  I used the wrong password for the id I created in postgres.  (This matters because the coderanch integration tests assume a certain password.  And because the one I picked I will never remember.)

alter user postgres with password ‘better_password’;

Importing data from file went smoothly.

Ongoing Little problems

  1. Copy paste from Eclipse doesn’t work.  You have to go through textedit.
  2. Postgres uses shift arrow key to select a line.  I wish Apple apps would all use the same convention.

Resources

  • http://developer.apple.com/internet/opensource/postgres.html
  • http://zanshin.net/2009/09/07/installing-postgresql-on-mac-10-6-snow-leopard/ – except for the building from source parts this was useful

Tomcat

Given how many problems I had with Postgres, I decided to follow a tutorial for Tomcat.  This one was easy to understand.  I know enough about the Mac to understand what the sudo is for (to be an admin.)  And the rest is pure UNIX – permissions, making a symbolic link, etc.

virtualbox between mac lion and ubuntu

Posted on by
3

I installed VirtualBox a few weeks ago.   A few wrinkles when actually using it.

Copy/paste

By default, you can’t copy/paste between your Mac and VirtualBox VM machine.  It’s easy to enable though:

  1. Devices > Install Guest Addons
  2. Wait a few minutes for a terminal window to open and install
  3. When prompted, press return to close terminal window
  4. Restart the VM
  5. Now copy and paste works naturally.
Keyboard shortcuts
On the Mac, you use command c to copy and on Ubuntu you use ctrl c.  It was a bit annoying to switch between the two frequently.  I don’t really have a good way of dealing with this other than press command c and wonder why nothing happens.  Ideas?
Command tab
I’m big on command tab.  The problem is that Virtualbox eats/disables it.  Which means every time I switched from my browser or Open Office to the VirtualBox install, it was awkward to get back.  I would up solving this by creating three desktops on Lion (spaces.)  One was VirtualBox Ubuntu Linux.  The second was the Open Office document with the book I was technical proofreading (Well Grounded Java Developer.)  The third was my browser/finder windows/etc.  This was helpful.  It let me three finger swipe as I was reading and command tab for the “little swaps” within my main desktop.  This fit my mental model well.  The only thing I didn’t like was that I had to put Open Office back in desktop #2 each time I opened a new chapter.

Apple OS X Lion Review – Part 2

Posted on by
Reply

In my release-day review of Apple’s Mac OS X Lion, I shared my initial impressions of the operating system while highlighting the key differences from previous versions. I also pointed some features users might not like. Now, two weeks later, I am much more appreciative of OS X Lion and wondering how I lived without certain features, such as full-screen mode. There are still some things I am not too fond of, but overall I have a much more favorable view of the new OS X after spending two weeks with it.

1. Full-Screen & Spaces Magic

Apple originally released Spaces with Mac OS Leopard 10.5, but until OS X Lion 10.7 I had never really used it. Spaces utilizes multiple virtual desktops in which to launch applications. The beauty of Apple’s implementation of full-screen mode is that it auto-magically creates and removes Spaces as the user switches into and out of full-screen mode. As a developer, I’m impressed by the clever re-use of existing functionality in an entirely new way. As a user, I like the new interface and beauty with which it works.

I was in the Apple Store over the weekend and compared the new 11″ MacBook Air running Safari in full-screen mode with a 13″ MacBook Air running the same application in windowed mode. Surprisingly, the height of the window was nearly the same. By introducing full-screen mode, Apple has essentially increased the screen size of all existing Macs, making the 11″ feasible as a true laptop replacement for the first time.

The addition of full-screen mode throughout the OS is probably the single most important feature Apple has release in OS X Lion. I only wish more third party applications, such as Microsoft Office and TextMate (the best Mac text editor) supported it automatically, but we will have to wait for a software update from the vendors. For those using Eclipse, Alex Blewitt has provided an unofficial update to support full-screen mode in OS X Lion that works perfectly in Eclipse 3.7 Indigo, although unfortunately not in previous versions of Eclipse. There is some concern that large manufacturers, like Adobe and Microsoft, could charge an upgrade fee for the next version that includes full-screen support, but this is up the individual vendors to decide.

2. New Mail App

In my initial Mac OS X Lion review, I indicated that I liked the Mail application, but did not go into much detail. After two weeks of using it, I’ve come to the realization that I love the streamlined, full-screen interface. It makes reading mail much simpler and less cumbersome than most modern mail applications, such as Mozilla Thunderbird or Microsoft Outlook. Also, I really like the conversations interface, borrowed a bit from Google’s Gmail web interface, which shows related messages, including your replies, in a single vertical view. Overall, this makeover makes for a much more solid, user-friendly application.

3. New Multi-Touch Gestures

The new 3-finger gestures are quite fun to use, such as pinching to make the Launchpad appear, or sliding the current page back in Safari, as an alternative to the back button. While it is getting a little difficult to remember all the different gestures available, they are playful and add a new level to the Mac. I have noticed some novice users trip up on multi-touch gestures though. For example, a particular family member of mine accidentally zoomed out on her Desktop resulting in all of the desktop icons shrinking to an unusable size. I would recommend that Apple turns off many of the advanced multi-touch gestures and enables them gradually and with the user’s permission, so that less skilled users understand how they work better.

4. All My Files: The Onion Prophecy Comes True!

Over two years ago, The Onion released a video showing a mock MacBook Wheel laptop, in which the entire keyboard is replaced by a single button, in part to mock Apple’s reliance on single-button hardware. In the video [at 1:06], they show a user searching their computer with all of the files in a single folder. Apparently, someone at Apple was taking notes, because the new version OS X Lion comes with an “All My Files” option in the finder menu. If you are like me, and have thousands of documents, I have no idea when this feature would ever be useful. In fact, if you use iPhoto and iTunes to manage all of your photos and music, there is never a reason to include them in this window. Overall, this feature seems like a last minute addition by an unskilled developer that probably should have never made it to the final build. You can turn this feature off by either right-clicking on it and removing it from the Sidebar, or unchecking the option in Finder -> Preferences -> Sidebar. Since it found thousands of useless icons and web files, I turned this feature off after a week as I decided it was a complete waste of time for anyone with more than a few dozen content items on their computer.

5. The Leftovers: What’s still bad

After reflecting on the topic, I’ve come to realize Mission Control, while useful, is so much like Exposé, that Apple really shouldn’t be highlighting this as a brand new feature. Perhaps not enough people were using Exposé, but this feels like a completely recycled feature with nothing of value added.

As for Natural Scrolling, in which they reversed horizontal and vertical scroll directions in OS X Lion, one person suggested they were trying to make a consistent interface with the iPad. If Apple ever does release a touch-screen Mac, this would certainly be the ground work for it. I decided to re-enable the natural scrolling following launch day and ultimately, it makes no difference to me which method I use. I still contend changing a major component of a user interface without explicitly informing the user is a horrible idea, as it tends to confuse the less-informed user base.

Finally, if you are Rosetta user who depends on older versions of applications, you may want to postpone upgrading at this time. I still content Microsoft Office 2004, which no longer works in OS X Lion, is the best version of Office released for Mac in the last decade due to its exclusion of the annoying ribbon, and inclusion of scripting support removed in Microsoft Office 2008. Users of Adobe CS2 or earlier, or those Photoshop CS3/CS4 users that rely on Droplets for batch processing, should likewise wait, as these products no longer function in OS X Lion and Adobe products can be quite pricey to replace. Unfortunately, Adobe has announced that it will not be providing Droplet support for CS3/CS4 users.

Minor Installation Woes

Having experienced serious installations issues on release day with Snow Leopard, I am pleased to report the installation of OS X Lion amongst my family members went almost entirely without problems. One computer did have a minor issue in which it restarted in Lion Recovery mode following the first reboot part of the installation. I needed to select the built-in hard drive as the Start Up disk, reboot the computer, then restart the entire installation. This solution worked, and have not seen any other installation issues.

Conclusion

The performance issues that I reported in my first review of OS X Lion eventually subsided, although it took all day. Between Spotlight indexing the entire hard drive and Time Machine backing up all of the changes, my computer was so hot I couldn’t touch it for hours after installation. Since then, the performance has been about the same as in 10.6 Snow Leopard, the previous version of Mac OS X. At this point, I am changing my satisfaction with OS X Lion from 35% previously reported to 90%, with the bulk of it stemming from the new full-screen mode that makes an 11″ MacBook Air perform like a 13″ MacBook Air.

There are still some rough edges, but overall this update is a welcome change and, unless you are one of those unfortunate users dependent on a Rosetta application, it is no-brainer upgrade at a $30 per household and a nearly error-free installation.