Prev: Counting a string
Next: Execute a stub written in plsql
From: Reid Thompson on 3 Mar 2010 11:01 On Wed, 2010-03-03 at 23:59 +0900, Saeed Bhuta wrote: > Reid Thompson wrote: > > On 3/3/2010 3:11 AM, Saeed Bhuta wrote: > >> Reid Thompson wrote: > >>> what does this return > >>> $ pg_config --includedir > >> > >> pg_config --includedir > >> /usr/include/postgresql > > > > actually, make that > > > > $ ls -lrt /usr/include/postgresql > > ls -lrt /usr/include/postgresql > total 172 > -rw-r--r-- 1 root root 20694 2009-09-09 17:49 postgres.h > -rw-r--r-- 1 root root 790 2009-09-09 17:49 postgres_fe.h > -rw-r--r-- 1 root root 1837 2009-09-09 17:49 postgres_ext.h > -rw-r--r-- 1 root root 12805 2009-09-09 17:49 port.h > -rw-r--r-- 1 root root 349 2009-09-09 17:49 pg_trace.h > -rw-r--r-- 1 root root 766 2009-09-09 17:49 pg_config_os.h > -rw-r--r-- 1 root root 7583 2009-09-09 17:49 pg_config_manual.h > -rw-r--r-- 1 root root 24739 2009-09-09 17:49 pg_config.h > -rw-r--r-- 1 root root 19646 2009-09-09 17:49 libpq-fe.h > -rw-r--r-- 1 root root 2270 2009-09-09 17:49 libpq-events.h > -rw-r--r-- 1 root root 24599 2009-09-09 17:49 c.h > drwxr-xr-x 2 root root 4096 2010-03-02 10:12 libpq > drwxr-xr-x 3 root root 4096 2010-03-02 10:12 internal > drwxr-xr-x 2 root root 4096 2010-03-02 10:12 catalog > drwxr-xr-x 2 root root 4096 2010-03-02 10:12 utils > drwxr-xr-x 2 root root 4096 2010-03-02 10:12 nodes > drwxr-xr-x 2 root root 4096 2010-03-02 10:12 mb > drwxr-xr-x 3 root root 4096 2010-03-02 10:13 8.4 hmm -- until today, on my box $ sudo gem install pg resulted in 0.8.0 being installed today, it installed 0.9.0. try this in your gems directory, remove the 0.9.0 directory (on my box this is at /usr/lib/ruby/gems/1.8/gems/pg-0.9.0) then try the install again $ sudo gem install pg
From: Saeed Bhuta on 3 Mar 2010 11:18 Reid Thompson wrote: > On Wed, 2010-03-03 at 23:59 +0900, Saeed Bhuta wrote: >> > >> -rw-r--r-- 1 root root 7583 2009-09-09 17:49 pg_config_manual.h >> drwxr-xr-x 3 root root 4096 2010-03-02 10:13 8.4 > hmm -- until today, on my box > > $ sudo gem install pg > > resulted in 0.8.0 being installed > > today, it installed 0.9.0. > > try this > > in your gems directory, remove the 0.9.0 directory > (on my box this is at /usr/lib/ruby/gems/1.8/gems/pg-0.9.0) > > then try the install again > > $ sudo gem install pg Deleted the directory and tried the install again but no luck; sudo gem install pg Building native extensions. This could take a while... ERROR: Error installing pg: ERROR: Failed to build gem native extension. /usr/bin/ruby1.8 extconf.rb checking for pg_config... yes checking for libpq-fe.h... yes checking for libpq/libpq-fs.h... yes checking for PQconnectdb() in -lpq... no checking for PQconnectdb() in -llibpq... no checking for PQconnectdb() in -lms/libpq... no Can't find the PostgreSQL client library (libpq) *** extconf.rb failed *** Could not create Makefile due to some reason, probably lack of necessary libraries and/or headers. Check the mkmf.log file for more details. You may need configuration options. Provided configuration options: --with-opt-dir --without-opt-dir --with-opt-include --without-opt-include=${opt-dir}/include --with-opt-lib --without-opt-lib=${opt-dir}/lib --with-make-prog --without-make-prog --srcdir=. --curdir --ruby=/usr/bin/ruby1.8 --with-pg --without-pg --with-pg-config --without-pg-config --with-pg-dir --without-pg-dir --with-pg-include --without-pg-include=${pg-dir}/include --with-pg-lib --without-pg-lib=${pg-dir}/lib --enable-static-build --disable-static-build --with-pqlib --without-pqlib --with-libpqlib --without-libpqlib --with-ms/libpqlib --without-ms/libpqlib Gem files will remain installed in /var/lib/gems/1.8/gems/pg-0.9.0 for inspection. Results logged to /var/lib/gems/1.8/gems/pg-0.9.0/ext/gem_make.out -- Posted via http://www.ruby-forum.com/.
From: Tor Erik Linnerud on 4 Mar 2010 09:35 > checking for pg_config... yes > checking for libpq-fe.h... yes > checking for libpq/libpq-fs.h... yes > checking for PQconnectdb() in -lpq... no > checking for PQconnectdb() in -llibpq... no > checking for PQconnectdb() in -lms/libpq... no > Can't find the PostgreSQL client library (libpq) I am having the exact same problem on a fresh install on Snow Leopard with Ruby 1.9.1p376 and postgres installed via homebrew. This is the last entry from mkmf.log gcc -o conftest -I/Users/tel/.rvm/rubies/ruby-1.9.1-p376/include/ruby-1.9.1/i386-darwin10.2.0 -I/Users/tel/.rvm/rubies/ruby-1.9.1-p376/include/ruby-1.9.1/ruby/backward -I/Users/tel/.rvm/rubies/ruby-1.9.1-p376/include/ruby-1.9.1 -I. -D_XOPEN_SOURCE -D_DARWIN_C_SOURCE -I/usr/local/homebrew/Cellar/postgresql/8.4.2/include -O2 -g -Wall -Wno-parentheses -pipe -fno-common -arch i386 conftest.c -L. -L/Users/tel/.rvm/rubies/ruby-1.9.1-p376/lib -L. -L/usr/local/homebrew/Cellar/postgresql/8.4.2/lib -arch i386 -lruby-static -lms/libpq -lpthread -ldl -lobjc " conftest.c: In function 't': conftest.c:5: warning: implicit declaration of function 'PQconnectdb' ld: library not found for -lms/libpq collect2: ld returned 1 exit status checked program was: /* begin */ 1: #include "ruby.h" 2: 3: /*top*/ 4: int main() {return 0;} 5: int t() { PQconnectdb(); return 0; } /* end */ Tor Erik -- Posted via http://www.ruby-forum.com/.
From: Luis Lavena on 4 Mar 2010 11:23 On Mar 3, 5:18 pm, Saeed Bhuta <saeed.bh...(a)placr.co.uk> wrote: > Reid Thompson wrote: > > On Wed, 2010-03-03 at 23:59 +0900, Saeed Bhuta wrote: > > >> -rw-r--r-- 1 root root 7583 2009-09-09 17:49 pg_config_manual.h > >> drwxr-xr-x 3 root root 4096 2010-03-02 10:13 8.4 > > hmm -- until today, on my box > > > $ sudo gem install pg > > > resulted in 0.8.0 being installed > > > today, it installed 0.9.0. > > > try this > > > in your gems directory, remove the 0.9.0 directory > > (on my box this is at /usr/lib/ruby/gems/1.8/gems/pg-0.9.0) > > > then try the install again > > > $ sudo gem install pg > > Deleted the directory and tried the install again but no luck; > sudo gem install pg > Building native extensions. This could take a while... > ERROR: Error installing pg: > ERROR: Failed to build gem native extension. > > /usr/bin/ruby1.8 extconf.rb > checking for pg_config... yes > checking for libpq-fe.h... yes > checking for libpq/libpq-fs.h... yes > checking for PQconnectdb() in -lpq... no > checking for PQconnectdb() in -llibpq... no > checking for PQconnectdb() in -lms/libpq... no > Can't find the PostgreSQL client library (libpq) > Can you post the contents of mkmf.log that are located here: /var/lib/ gems/1.8/gems/pg-0.9.0/ext Seems that it finds the headers, the pg_config tool, but It cannot link to it, which may be related to 32/64 bits binaries. -- Luis Lavena
From: Tor Erik Linnerud on 4 Mar 2010 13:26
Luis Lavena wrote: > Can you post the contents of mkmf.log that are located here: /var/lib/ > gems/1.8/gems/pg-0.9.0/ext Here is mine find_executable: checking for pg_config... -------------------- yes -------------------- have_header: checking for libpq-fe.h... -------------------- yes "gcc -o conftest -I/Users/tel/.rvm/rubies/ruby-1.9.1-p376/include/ruby-1.9.1/i386-darwin10.2.0 -I/Users/tel/.rvm/rubies/ruby-1.9.1-p376/include/ruby-1.9.1/ruby/backward -I/Users/tel/.rvm/rubies/ruby-1.9.1-p376/include/ruby-1.9.1 -I. -D_XOPEN_SOURCE -D_DARWIN_C_SOURCE -I/usr/local/homebrew/Cellar/postgresql/8.3.9/include -O2 -g -Wall -Wno-parentheses -pipe -fno-common -arch i386 conftest.c -L. -L/Users/tel/.rvm/rubies/ruby-1.9.1-p376/lib -L. -L/usr/local/homebrew/Cellar/postgresql/8.3.9/lib -arch i386 -lruby-static -lpthread -ldl -lobjc " ld: warning: in /Users/tel/.rvm/rubies/ruby-1.9.1-p376/lib/libruby-static.a, file is not of required architecture checked program was: /* begin */ 1: #include "ruby.h" 2: 3: int main() {return 0;} /* end */ "gcc -E -I/Users/tel/.rvm/rubies/ruby-1.9.1-p376/include/ruby-1.9.1/i386-darwin10.2.0 -I/Users/tel/.rvm/rubies/ruby-1.9.1-p376/include/ruby-1.9.1/ruby/backward -I/Users/tel/.rvm/rubies/ruby-1.9.1-p376/include/ruby-1.9.1 -I. -D_XOPEN_SOURCE -D_DARWIN_C_SOURCE -I/usr/local/homebrew/Cellar/postgresql/8.3.9/include -O2 -g -Wall -Wno-parentheses -pipe -fno-common -arch i386 conftest.c -o conftest.i" checked program was: /* begin */ 1: #include "ruby.h" 2: 3: #include <libpq-fe.h> /* end */ -------------------- have_header: checking for libpq/libpq-fs.h... -------------------- yes "gcc -E -I/Users/tel/.rvm/rubies/ruby-1.9.1-p376/include/ruby-1.9.1/i386-darwin10.2.0 -I/Users/tel/.rvm/rubies/ruby-1.9.1-p376/include/ruby-1.9.1/ruby/backward -I/Users/tel/.rvm/rubies/ruby-1.9.1-p376/include/ruby-1.9.1 -I. -D_XOPEN_SOURCE -D_DARWIN_C_SOURCE -I/usr/local/homebrew/Cellar/postgresql/8.3.9/include -O2 -g -Wall -Wno-parentheses -pipe -fno-common -arch i386 conftest.c -o conftest.i" checked program was: /* begin */ 1: #include "ruby.h" 2: 3: #include <libpq/libpq-fs.h> /* end */ -------------------- have_library: checking for PQconnectdb() in -lpq... -------------------- no "gcc -o conftest -I/Users/tel/.rvm/rubies/ruby-1.9.1-p376/include/ruby-1.9.1/i386-darwin10.2.0 -I/Users/tel/.rvm/rubies/ruby-1.9.1-p376/include/ruby-1.9.1/ruby/backward -I/Users/tel/.rvm/rubies/ruby-1.9.1-p376/include/ruby-1.9.1 -I. -D_XOPEN_SOURCE -D_DARWIN_C_SOURCE -I/usr/local/homebrew/Cellar/postgresql/8.3.9/include -O2 -g -Wall -Wno-parentheses -pipe -fno-common -arch i386 conftest.c -L. -L/Users/tel/.rvm/rubies/ruby-1.9.1-p376/lib -L. -L/usr/local/homebrew/Cellar/postgresql/8.3.9/lib -arch i386 -lruby-static -lpq -lpthread -ldl -lobjc " conftest.c: In function 't': conftest.c:5: error: 'PQconnectdb' undeclared (first use in this function) conftest.c:5: error: (Each undeclared identifier is reported only once conftest.c:5: error: for each function it appears in.) checked program was: /* begin */ 1: #include "ruby.h" 2: 3: /*top*/ 4: int main() {return 0;} 5: int t() { void ((*volatile p)()); p = (void ((*)()))PQconnectdb; return 0; } /* end */ "gcc -o conftest -I/Users/tel/.rvm/rubies/ruby-1.9.1-p376/include/ruby-1.9.1/i386-darwin10.2.0 -I/Users/tel/.rvm/rubies/ruby-1.9.1-p376/include/ruby-1.9.1/ruby/backward -I/Users/tel/.rvm/rubies/ruby-1.9.1-p376/include/ruby-1.9.1 -I. -D_XOPEN_SOURCE -D_DARWIN_C_SOURCE -I/usr/local/homebrew/Cellar/postgresql/8.3.9/include -O2 -g -Wall -Wno-parentheses -pipe -fno-common -arch i386 conftest.c -L. -L/Users/tel/.rvm/rubies/ruby-1.9.1-p376/lib -L. -L/usr/local/homebrew/Cellar/postgresql/8.3.9/lib -arch i386 -lruby-static -lpq -lpthread -ldl -lobjc " conftest.c: In function 't': conftest.c:5: warning: implicit declaration of function 'PQconnectdb' ld: warning: in /Users/tel/.rvm/rubies/ruby-1.9.1-p376/lib/libruby-static.a, file is not of required architecture ld: warning: in /usr/local/homebrew/Cellar/postgresql/8.3.9/lib/libpq.dylib, file is not of required architecture Undefined symbols: "_PQconnectdb", referenced from: _t in ccQWN7dm.o ld: symbol(s) not found collect2: ld returned 1 exit status checked program was: /* begin */ 1: #include "ruby.h" 2: 3: /*top*/ 4: int main() {return 0;} 5: int t() { PQconnectdb(); return 0; } /* end */ -------------------- have_library: checking for PQconnectdb() in -llibpq... -------------------- no "gcc -o conftest -I/Users/tel/.rvm/rubies/ruby-1.9.1-p376/include/ruby-1.9.1/i386-darwin10.2.0 -I/Users/tel/.rvm/rubies/ruby-1.9.1-p376/include/ruby-1.9.1/ruby/backward -I/Users/tel/.rvm/rubies/ruby-1.9.1-p376/include/ruby-1.9.1 -I. -D_XOPEN_SOURCE -D_DARWIN_C_SOURCE -I/usr/local/homebrew/Cellar/postgresql/8.3.9/include -O2 -g -Wall -Wno-parentheses -pipe -fno-common -arch i386 conftest.c -L. -L/Users/tel/.rvm/rubies/ruby-1.9.1-p376/lib -L. -L/usr/local/homebrew/Cellar/postgresql/8.3.9/lib -arch i386 -lruby-static -llibpq -lpthread -ldl -lobjc " conftest.c: In function 't': conftest.c:5: error: 'PQconnectdb' undeclared (first use in this function) conftest.c:5: error: (Each undeclared identifier is reported only once conftest.c:5: error: for each function it appears in.) checked program was: /* begin */ 1: #include "ruby.h" 2: 3: /*top*/ 4: int main() {return 0;} 5: int t() { void ((*volatile p)()); p = (void ((*)()))PQconnectdb; return 0; } /* end */ "gcc -o conftest -I/Users/tel/.rvm/rubies/ruby-1.9.1-p376/include/ruby-1.9.1/i386-darwin10.2.0 -I/Users/tel/.rvm/rubies/ruby-1.9.1-p376/include/ruby-1.9.1/ruby/backward -I/Users/tel/.rvm/rubies/ruby-1.9.1-p376/include/ruby-1.9.1 -I. -D_XOPEN_SOURCE -D_DARWIN_C_SOURCE -I/usr/local/homebrew/Cellar/postgresql/8.3.9/include -O2 -g -Wall -Wno-parentheses -pipe -fno-common -arch i386 conftest.c -L. -L/Users/tel/.rvm/rubies/ruby-1.9.1-p376/lib -L. -L/usr/local/homebrew/Cellar/postgresql/8.3.9/lib -arch i386 -lruby-static -llibpq -lpthread -ldl -lobjc " conftest.c: In function 't': conftest.c:5: warning: implicit declaration of function 'PQconnectdb' ld: library not found for -llibpq collect2: ld returned 1 exit status checked program was: /* begin */ 1: #include "ruby.h" 2: 3: /*top*/ 4: int main() {return 0;} 5: int t() { PQconnectdb(); return 0; } /* end */ -------------------- have_library: checking for PQconnectdb() in -lms/libpq... -------------------- no "gcc -o conftest -I/Users/tel/.rvm/rubies/ruby-1.9.1-p376/include/ruby-1.9.1/i386-darwin10.2.0 -I/Users/tel/.rvm/rubies/ruby-1.9.1-p376/include/ruby-1.9.1/ruby/backward -I/Users/tel/.rvm/rubies/ruby-1.9.1-p376/include/ruby-1.9.1 -I. -D_XOPEN_SOURCE -D_DARWIN_C_SOURCE -I/usr/local/homebrew/Cellar/postgresql/8.3.9/include -O2 -g -Wall -Wno-parentheses -pipe -fno-common -arch i386 conftest.c -L. -L/Users/tel/.rvm/rubies/ruby-1.9.1-p376/lib -L. -L/usr/local/homebrew/Cellar/postgresql/8.3.9/lib -arch i386 -lruby-static -lms/libpq -lpthread -ldl -lobjc " conftest.c: In function 't': conftest.c:5: error: 'PQconnectdb' undeclared (first use in this function) conftest.c:5: error: (Each undeclared identifier is reported only once conftest.c:5: error: for each function it appears in.) checked program was: /* begin */ 1: #include "ruby.h" 2: 3: /*top*/ 4: int main() {return 0;} 5: int t() { void ((*volatile p)()); p = (void ((*)()))PQconnectdb; return 0; } /* end */ "gcc -o conftest -I/Users/tel/.rvm/rubies/ruby-1.9.1-p376/include/ruby-1.9.1/i386-darwin10.2.0 -I/Users/tel/.rvm/rubies/ruby-1.9.1-p376/include/ruby-1.9.1/ruby/backward -I/Users/tel/.rvm/rubies/ruby-1.9.1-p376/include/ruby-1.9.1 -I. -D_XOPEN_SOURCE -D_DARWIN_C_SOURCE -I/usr/local/homebrew/Cellar/postgresql/8.3.9/include -O2 -g -Wall -Wno-parentheses -pipe -fno-common -arch i386 conftest.c -L. -L/Users/tel/.rvm/rubies/ruby-1.9.1-p376/lib -L. -L/usr/local/homebrew/Cellar/postgresql/8.3.9/lib -arch i386 -lruby-static -lms/libpq -lpthread -ldl -lobjc " conftest.c: In function 't': conftest.c:5: warning: implicit declaration of function 'PQconnectdb' ld: library not found for -lms/libpq collect2: ld returned 1 exit status checked program was: /* begin */ 1: #include "ruby.h" 2: 3: /*top*/ 4: int main() {return 0;} 5: int t() { PQconnectdb(); return 0; } /* end */ -------------------- Tor Erik -- Posted via http://www.ruby-forum.com/. |