Ingres Technology Blog

So I'm trying to work a bit on the Mac OS X port of Ingres that's had a recent update and some important changes. There's a few things that don't just come "out of the box":

1. You'll have to install as root
   
   To do this the easy way, just open a term and run the command "su -". This will prompt you for your current user password to make sure that you really mean it.
    
2. You need to set DYLD_LIBRARY_PATH
   
   Mine is set to /lib:/usr/lib:/usr/local/lib:$II_SYSTEM/ingres/lib
   
   You can safely replace any directives to set LD_LIBRARY_PATH with setting DYLD_LIBRARY_PATH
    
3. You need to up your shared memory kernel settings
   
   Create the file /etc/sysctl.conf and add the following lines if you have 4G memory:
   
   kern.sysv.shmall=4096000
   
   kern.sysv.shmseg=8
   
   kern.sysv.shmmni=256
   
   kern.sysv.shmmin=1
   
   kern.sysv.shmmax=1024000000
    
4. You need to be running Leopard
   
   We know this may be a bit of a hassle, and it could be remedied with some work, but the current people working on the port are all running Leopard and we're trying to focus time on getting the port working well on Leopard first. If you're interested in helping out, please let me know!

Here's a few things I did that just make life easier based on my experience:

• Create an "ingres" user via the good old System Preferences app's Accounts section
• Install in /opt
• Permanently change my term's option for termcap interaction with the function keys to "Strict VT-100 keypad behavior" on the Advanced tab of my preferences

To make your life easy, but maybe slightly bloated, run the ingres_express_install.sh script and let it rip by. Once finished, login as the ingres user, set your env (including DYLD_LIBRARY_PATH), and create your first database:

• createdb -umsale mymacdb

Replace the msale with the username you use to do development on the local box and then that user will be able to perform DBA actions for that database. If you want to do your development/dba work as ingres, just leave out the -u option.

You can now connect to your database via the JDBC tool of your choice to interact via ANSI-friendly SQL (I use SQuirrel due to its Toad-like UI) using the JDBC driver at $II_SYSTEM/ingres/lib/iijdbc.jar.

Let us know if you have any issues with the install and we’ll do the best we can to help out. We know there is plenty of work that still needs to be done to get this port reliable and ready as a solid development platform on the Mac.

If you are a student with experience developing C or Obj-C on the Mac, we would love to get you involved in our Google Summer of Code project to get Ingres healthy on Leopard.

Share This