Sqlite3 problems on Debian sid

[GoogleCodeExporter]

Steps to reproduce:
1.download install script
2.download and install dependencies
3.execute installation

Actual result:Fatal error: Ruby SQLite3 support not found. Please install it 
first.

Expected result:

Version of the product:2.0

Server OS:Debian lenny

Browser:NA

Additional information:

sqlite3 installed properly but still error from installer so the issue for me 
is just comment those 2 lines

puts "Checking Ruby SQLite3 support: $RUBY_SQLITE3_CMD"
# sh -c "$RUBY_SQLITE3_CMD" > /dev/null 2>&1
#  [ $? -ne 0 ] && fatal_error "Ruby SQLite3 support not found. Please install 
it first."

after install seems to fonctionnal pannel work :D

Original issue reported on code.google.com by tdcmyst...@gmail.com on 19 Apr 2011 at 6:55

[GoogleCodeExporter]

Looks like you solved dependencies manually, right? Autoinstaller could do it 
for you.

What are the result of commands?
* ruby -e "require 'rubygems'" -e "require 'sqlite3/database'"
* ruby -e "require 'rubygems'" -e "require 'sqlite3'"
* gem list | grep sqlite
* dpkg -l | grep libsqlite

Original comment by sibprogrammer on 20 Apr 2011 at 2:39

• Added labels: Milestone-Release2.1

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

ruby -e "require 'rubygems'" -e "require 'sqlite3/database'"
/usr/lib/ruby/1.8/sqlite3/database.rb:290: undefined method `busy_timeout=' for 
class `SQLite3::Database' (NameError)
        from /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:36:in `gem_original_require'
        from /usr/local/lib/site_ruby/1.8/rubygems/custom_require.rb:36:in `require'
        from -e:2

ruby -e "require 'rubygems'" -e "require 'sqlite3'"

result nothing

gem list | grep sqlite
sqlite3 (1.3.3)
sqlite3-ruby (1.3.3, 1.2.4)

dpkg -l | grep libsqlite
ii  libsqlite3-0                     3.7.5-1                      SQLite 3 
shared library
ii  libsqlite3-dev                   3.7.5-1                      SQLite 3 
development files
ii  libsqlite3-ruby                  1.3.1-2                      SQLite3 
interface for Ruby
ii  libsqlite3-ruby1.8               1.3.1-2                      SQLite3 
interface for Ruby 1.8
ii  libsqlite3-ruby1.9.1             1.3.1-2                      SQLite3 
interface for Ruby 1.9.1

Original comment by tdcmyst...@gmail.com on 20 Apr 2011 at 3:01

[GoogleCodeExporter]

Issue 283 has been merged into this issue.

Original comment by sibprogrammer on 24 Apr 2011 at 1:03

[GoogleCodeExporter]

You're using Debian unstable repository (sid), right? Package 
libsqlite3-ruby1.8 1.3.1-2 looks like broken. Need to use 1.2.2/1.2.4 versions 
of libsqlite3-ruby.  I highly not recommend to use Debian sid for deployment of 
Owp.

Original comment by sibprogrammer on 24 Apr 2011 at 1:12

• Changed title: Sqlite3 problems on Debian sid

[GoogleCodeExporter]

Just before using unstable Repo i try to install 1.2.2/1.2.4 done without 
problems but still the same error on check.

PS: OWP work fine for me 

Original comment by tdcmyst...@gmail.com on 24 Apr 2011 at 1:22

[GoogleCodeExporter]

Remove all libsqlite3-ruby packages and install only libsqlite3-ruby 1.2.2. Owp 
may looks like working ok, but problems with sqlite3 can lead to errors in the 
future.

Original comment by sibprogrammer on 24 Apr 2011 at 1:27

• Changed state: Accepted

[GoogleCodeExporter]

The problem isn't with libsqlite3-ruby, but the Owp installation script.  

ai.sh needs to set RUBY_SQLITE3_CMD (line 6) to include the whole gem as 
opposed to just sqlite3/database.rb:

    RUBY_SQLITE3_CMD="ruby -e \"require 'rubygems'\" -e \"require 'sqlite3'\"

As of recent versions of the gem, `require 'sqlite3/database'` cannot function 
without loading other internal libraries:

A glance into the sqlite3-ruby gem unveils the issue:

https://github.com/luislavena/sqlite3-ruby/blob/master/lib/sqlite3.rb
    # support multiple ruby version (fat binaries under windows)
    begin
      RUBY_VERSION =~ /(\d+.\d+)/
      require "sqlite3/#{$1}/sqlite3_native"
    rescue LoadError
      require 'sqlite3/sqlite3_native'
    end

    require 'sqlite3/database'
    require 'sqlite3/version'

Toying in `irb`, `require 'sqlite3/database'` will fail with the following 
error:

    NameError: undefined method `busy_timeout=' for class `SQLite3::Database'
        from /usr/local/lib/ruby/gems/1.8/gems/sqlite3-1.3.5/lib/sqlite3/database.rb:293
        from /usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:32:in `gem_original_require'
        from /usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:32:in `require'
        from (irb):4

Unless you run the `begin...rescue...end` block above first.

Original comment by faraz.ya...@gmail.com on 14 Jan 2012 at 3:01

[GoogleCodeExporter]

the same here

Original comment by tooxicbu...@gmail.com on 6 Apr 2012 at 1:07

[GoogleCodeExporter]

Support for new versions of SQLite Ruby gem was added.

Original comment by sibprogrammer on 3 May 2012 at 1:00

• Changed state: Fixed

[GoogleCodeExporter]

Issue 354 has been merged into this issue.

Original comment by sibprogrammer on 3 May 2012 at 1:00

[GoogleCodeExporter]

Issue 388 has been merged into this issue.

Original comment by sibprogrammer on 3 May 2012 at 1:04