RubyForge: Ruby/DBI: open-discussion

Discussion Forums: open-discussion

Unable to load driver 'pg' [ reply ]
2010-02-08 06:37

I have a ruby script that accesses a postgresql db,
and has worked for years. Recently, I rebuilt this
machine from the ground up, and now the script fails:

$ ./spend_entry_09.rb
/usr/lib64/ruby/gems/1.8/gems/dbi-0.4.3/lib/dbi.rb:300:in `load_driver': Unable to load driver 'pg' (underlying error: wrong constant name pg) (DBI::InterfaceError)
from /usr/lib64/ruby/1.8/monitor.rb:242:in `synchronize'
from /usr/lib64/ruby/gems/1.8/gems/dbi-0.4.3/lib/dbi.rb:242:in `load_driver'
from /usr/lib64/ruby/gems/1.8/gems/dbi-0.4.3/lib/dbi.rb:160:in `_get_full_driver'
from /usr/lib64/ruby/gems/1.8/gems/dbi-0.4.3/lib/dbi.rb:145:in `connect'
from ./spend_entry_09.rb:461:in `set_dbh'
from ./spend_entry_09.rb:607

this script has the following:

# if you require a gem, you have to require 'rubygems' first
require 'rubygems'

# overall database interface
require 'dbi'

# new postgres lib
# this is a gem
require 'pg'

here is some additional information:

# ruby -v
ruby 1.8.7 (2010-01-10 patchlevel 249) [x86_64-linux]

localhost new_soft # gem environment
RubyGems Environment:
- RUBYGEMS VERSION: 1.3.5
- RUBY VERSION: 1.8.7 (2010-01-10 patchlevel 249) [x86_64-linux]
- INSTALLATION DIRECTORY: /usr/lib64/ruby/gems/1.8
- RUBY EXECUTABLE: /usr/bin/ruby18
- EXECUTABLE DIRECTORY: /usr/bin
- RUBYGEMS PLATFORMS:
- ruby
- x86_64-linux
- GEM PATHS:
- /usr/lib64/ruby/gems/1.8
- /root/.gem/ruby/1.8
- GEM CONFIGURATION:
- :update_sources => true
- :verbose => true
- :benchmark => false
- :backtrace => false
- :bulk_threshold => 1000
- REMOTE SOURCES:
- http://gems.rubyforge.org/
localhost new_soft # gem specification dbi
--- !ruby/object:Gem::Specification
name: dbi
version: !ruby/object:Gem::Version
version: 0.4.3
platform: ruby
authors:
- Erik Hollensbe
- Christopher Maujean
autorequire:
bindir: bin
cert_chain: []

date: 2009-09-12 00:00:00 -07:00
default_executable:
dependencies:
- !ruby/object:Gem::Dependency
name: deprecated
type: :runtime
version_requirement:
version_requirements: !ruby/object:Gem::Requirement
requirements:
- - ">="
- !ruby/object:Gem::Version
version: 2.0.0
version:
description: A vendor independent interface for accessing databases, similar to Perl's DBI
email: ruby-dbi-users@rubyforge.org /> executables:
- dbi
- test_broken_dbi
extensions: []

extra_rdoc_files:
- README
- LICENSE
- ChangeLog
files:
- examples/xmltest.rb
- examples/test1.pl
- examples/test1.rb
- bin/dbi
- build/Rakefile.dbi.rb
- lib/dbi.rb
- lib/dbi/typeutil.rb
- lib/dbi/handles.rb
- lib/dbi/sql_type_constants.rb
- lib/dbi/exceptions.rb
- lib/dbi/columninfo.rb
- lib/dbi/sql.rb
- lib/dbi/utils.rb
- lib/dbi/utils/tableformatter.rb
- lib/dbi/utils/timestamp.rb
- lib/dbi/utils/date.rb
- lib/dbi/utils/xmlformatter.rb
- lib/dbi/utils/time.rb
- lib/dbi/base_classes.rb
- lib/dbi/sql/preparedstatement.rb
- lib/dbi/trace.rb
- lib/dbi/handles/driver.rb
- lib/dbi/handles/database.rb
- lib/dbi/handles/statement.rb
- lib/dbi/base_classes/driver.rb
- lib/dbi/base_classes/database.rb
- lib/dbi/base_classes/statement.rb
- lib/dbi/binary.rb
- lib/dbi/types.rb
- lib/dbi/row.rb
- test/ts_dbi.rb
- test/dbi/tc_sqlbind.rb
- test/dbi/tc_dbi.rb
- test/dbi/tc_statementhandle.rb
- test/dbi/tc_row.rb
- test/dbi/tc_timestamp.rb
- test/dbi/tc_columninfo.rb
- test/dbi/tc_types.rb
- test/dbi/tc_time.rb
- test/dbi/tc_date.rb
- README
- LICENSE
- ChangeLog
- bin/test_broken_dbi
has_rdoc: true
homepage: http://www.rubyforge.org/projects/ruby-dbi
licenses: []

post_install_message:
rdoc_options: []

require_paths:
- lib
required_ruby_version: !ruby/object:Gem::Requirement
requirements:
- - ">="
- !ruby/object:Gem::Version
version: 1.8.0
version:
required_rubygems_version: !ruby/object:Gem::Requirement
requirements:
- - ">="
- !ruby/object:Gem::Version
version: "0"
version:
requirements: []

rubyforge_project: ruby-dbi
rubygems_version: 1.3.5
signing_key:
specification_version: 2
summary: A vendor independent interface for accessing databases, similar to Perl's DBI
test_files:
- test/ts_dbi.rb

localhost new_soft #

If you need any further information, please let
me know.

Thank you for your help.

- Martin -