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

Ingres get’s more and more into the GPL swing of things with our participation this year in the Google Summer of Code. You can check out our project proposals here. Students should check out this URL for more information.

If you have a suggestion for another proposal that you would like to contribute to, please let us know soon and we will work to get it included if at all viable.

One of the new things (for us) we have up and running now for instant help and feedback is an IRC #ingres channel on freenode.net. If you’re interested in jumping on, but are not sure what IRC is and how to use it, check out wikipedia or for something a little more practically directed to getting you started, check out this FAQ.

Share This

Ingres has joined forces with Alfresco to provide true open source alternative to Enterprise Content Management. Alfresco is the leading open source provider for document, records, knowledge, and web content management. In addition to traditional content management services, Alfresco enables collaboration support for the internet way of business.

The benefits of Alfresco and Ingres as a combined solution:

• Availability – out of the box online backup and recovery
• Security – a centralized repository requires proper data protection
• Scalability – users can start small and grow to enterprise wide deployments
• Mission critical experience - applied to content management solutions
• Open source – total enterprise grade open source solution

Ingres and Alfresco Bundle

Ingres and Alfresco want developers and end users to get up and running quickly and easily. That’s why we built an integrated bundle of Alfresco with Ingres so users can install both technologies in one easy install.

Download now!

For More Information:

• Visit our Alfresco & Ingres community project page

Share This

Over the past year we have had quite a bit of interest in the Eclipse dtp bundle and this has spurred interest in building an integrated developer’s stack. Ingres CAFE is such a project that was spearheaded by Samrat Dhillon, a graduate student at Carleton University in Ottawa.

Ingres CAFE bundles the Eclipse IDE, Ingres Database, Apache Tomcat, Hibernate Libraries, and JSF libraries into a single installable package complete with documentation and integrated maintenance. There is also a demo included to help developers get started with the tool.

Check out Ingres CAFE and let us know what you think and future developer tools you would like to see working with Ingres.

Great job to the students at Carleton University in Ottawa, Canada.

deb woods

Share This