首页
学习
活动
专区
圈层
工具
发布
首页
学习
活动
专区
圈层
工具
MCP广场
社区首页 >问答首页 >为PostgreSQL安装gem pg,openssl库

为PostgreSQL安装gem pg,openssl库
EN

Stack Overflow用户
提问于 2013-03-03 14:54:34
回答 1查看 3.1K关注 0票数 3

我使用RVM和ruby 2.0.0。当我尝试安装pg gem用于PostgreSQL时,我会得到以下响应。

gem安装pg

代码语言:javascript
运行
复制
Building native extensions.  This could take a while...
ERROR:  Error installing pg:
    ERROR: Failed to build gem native extension.

    /usr/local/rvm/rubies/ruby-2.0.0-p0/bin/ruby extconf.rb
checking for pg_config... yes
Using config values from /usr/bin/pg_config
checking for libpq-fe.h... yes
checking for libpq/libpq-fs.h... yes
checking for pg_config_manual.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
    --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/local/rvm/rubies/ruby-2.0.0-p0/bin/ruby
    --with-pg
    --without-pg
    --with-pg-dir
    --without-pg-dir
    --with-pg-include
    --without-pg-include=${pg-dir}/include
    --with-pg-lib
    --without-pg-lib=${pg-dir}/
    --with-pg-config
    --without-pg-config
    --with-pg_config
    --without-pg_config
    --with-pqlib
    --without-pqlib
    --with-libpqlib
    --without-libpqlib
    --with-ms/libpqlib
    --without-ms/libpqlib


Gem files will remain installed in /usr/local/rvm/gems/ruby-2.0.0-p0/gems/pg-0.14.1 for inspection.
Results logged to /usr/local/rvm/gems/ruby-2.0.0-p0/gems/pg-0.14.1/ext/gem_make.out

显然,问题在于OpenSSL库,因为在mkmf.log输出中

代码语言:javascript
运行
复制
have_library: checking for PQconnectdb() in -lpq... -----------------$

"gcc -o conftest -I/usr/local/rvm/rubies/ruby-2.0.0-p0/include/ruby-2$
conftest.c: In function 't':
conftest.c:8:32: warning: variable 'p' set but not used [-Wunused-but$
/usr/lib/libpq.so: undefined reference to `SSL_get_error@OPENSSL_1.0.$
/usr/lib/libpq.so: undefined reference to `SSL_get_peer_certificate@O$
/usr/lib/libpq.so: undefined reference to `SSL_CTX_load_verify_locati$
/usr/lib/libpq.so: undefined reference to `SSL_set_ex_data@OPENSSL_1.$
/usr/lib/libpq.so: undefined reference to `SSL_use_certificate_file@O$
/usr/lib/libpq.so: undefined reference to `ENGINE_free@OPENSSL_1.0.0'
/usr/lib/libpq.so: undefined reference to `SSL_write@OPENSSL_1.0.0'
/usr/lib/libpq.so: undefined reference to `ERR_get_error@OPENSSL_1.0.$
/usr/lib/libpq.so: undefined reference to `ENGINE_by_id@OPENSSL_1.0.0'
/usr/lib/libpq.so: undefined reference to `SSL_use_PrivateKey@OPENSSL$
/usr/lib/libpq.so: undefined reference to `X509_get_subject_name@OPEN$
/usr/lib/libpq.so: undefined reference to `ENGINE_init@OPENSSL_1.0.0'
/usr/lib/libpq.so: undefined reference to `SSL_load_error_strings@OPE$
/usr/lib/libpq.so: undefined reference to `X509_STORE_set_flags@OPENS$
/usr/lib/libpq.so: undefined reference to `SSL_new@OPENSSL_1.0.0'

然后,我使用在

代码语言:javascript
运行
复制
openssl version -d
OPENSSLDIR: "/usr/lib/ssl"
rvm reinstall 2.0.0 --with-openssl-dir=/usr/lib/ssl

还是同样的问题。

尝试使用--with-pg-config标志插入gem。同样的问题。

在许多网站上尝试了常见的解决方法

代码语言:javascript
运行
复制
mv $rvm_path/usr/lib $rvm_path/usr/rvm_lib
gem install pg
mv $rvm_path/usr/rvm_lib $rvm_path/usr/lib

不过,这次的错误是不同的。

gem安装pg

代码语言:javascript
运行
复制
Error loading RubyGems plugin "/usr/local/rvm/gems/ruby-2.0.0-p0@global/gems/rubygems-bundler-1.1.1/lib/rubygems_plugin.rb": /usr/local/rvm/rubies/ruby-2.0.0-p0/lib/ruby/2.0.0/x86_64-linux/openssl.so: undefined symbol: SSLv2_method - /usr/local/rvm/rubies/ruby-2.0.0-p0/lib/ruby/2.0.0/x86_64-linux/openssl.so (LoadError)
ERROR:  Loading command: install (LoadError)
    /usr/local/rvm/rubies/ruby-2.0.0-p0/lib/ruby/2.0.0/x86_64-linux/openssl.so: undefined symbol: SSLv2_method - /usr/local/rvm/rubies/ruby-2.0.0-p0/lib/ruby/2.0.0/x86_64-linux/openssl.so
ERROR:  While executing gem ... (NoMethodError)
    undefined method `invoke_with_build_args' for nil:NilClass

假设它仍然试图从Ruby目录中获取openssl.so --问题在于Ruby使用了错误的openssl.so文件。但事实是,我已经用--with-openssl-dir标志重新编译了它。

对此有什么建议吗?在过去的10个小时里,我一直在尝试我能找到的每一个解决办法。

EN

回答 1

Stack Overflow用户

回答已采纳

发布于 2013-03-03 14:59:05

为什么总是发生这种事?一旦你把你的问题张贴在这里,你就自己解决它。

解决方案很简单--我在重新安装ruby时忽略了"--“。

代码语言:javascript
运行
复制
openssl version -d
OPENSSLDIR: "/usr/lib/ssl"
rvm reinstall 2.0.0 -- --with-openssl-dir=/usr/lib/ssl

这解决了问题。希望它能帮到别人。

票数 6
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/15186924

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档