From: Bill Bug Date: 2003-05-13T06:09:36+09:00 Subject: Re: Ruby, OSX and Postgres Hi Simon & Sam, Its well worth sticking with this until you get it working. I think Ruby & PostgreSQL make great partners. I actually use both the ruby-postgres package for access to Postgres dtbs from Ruby code, as well as the plruby-0.3.x package. PLRuby enables you to add Ruby as another procedural language to ProgreSQL for writing functions within database. I ran into the same problem trying to build ruby-postgres. I got help from Marc Liyanage whose wonderful http://www.entropy.ch/software/macosx site contains so many Mac OS X builds of standard Unix tools. Marc helped me to figure out what needed to be added. Marc compiled his version of Postgres v7.3.2 for OS X linking to openssl & the crypto libraries, two libraries that should be present in Mac OS X 10.2.x. If you add the following lines to the top of your extconf.rb file for the ruby-postgres-0.7.x package, it should build without error. $CFLAGS = " -I/usr/include/openssl " $LDFLAGS = " -L/usr/lib -lssl -lcrypto " Using the following command should then successfully build you a functional 'make' file ruby extconf.rb --with-pgsql-include-dir=/usr/local/pgsql/include --with-pgsql-lib-dir=/usr/local/pgsql/lib Best of luck. Cheers, Bill On Monday, May 12, 2003, at 03:24 PM, Simon Strandgaard wrote: > On Mon, 12 May 2003 19:41:04 +0000, Sam Griffith wrote: >> >> Using PostgreSQL include directory: /usr/local/pgsql/include >> Using PostgreSQL lib directory: /usr/local/pgsql/lib >> checking for PQsetdbLogin() in -lpq... no >> Could not find PostgreSQL libraries: Makefile not created > > It cannot link with libpq.so... and this file exists in your lib > directory. This should work! > > Maybe your libpq.so is a symlink which points at nothing (broken).. > Try do a "ls -la" on the library and post the output. > > I don't have postgres installed. But the output should be similar to > this: >> ls -la libcrypt.so > lrwxrwxrwx 1 root wheel 13 22 Feb 01:57 libcrypt.so@ -> > libcrypt.so.2 >> > > > -- > Simon Strandgaard > > Bill Bug Senior Analyst/Ontological Engineer Computer Vision Laboratory for Vertebrate Brain Mapping Department of Neurobiology & Anatomy Drexel University College of Medicine 2900 Queen Lane Philadelphia, PA 19129 215 991 8430 (ph)