view · edit · sidebar · attach · print · history

Installing de.oddb on Windows via Rubygems

<< Deoddb | Index | DeoddbSnowLeopard >>

Getting started

  • gem install de.oddb
  • gem install rclconv

use

 Smbclient

as

 smbclient //ZDAVATZ-VISTA/Users -U zdavatz

to copy the file

 /home/zeno/.software/de.oddb.org/.git/refs/heads/master

to

 put /home/zeno/.software/de.oddb.org/.git/refs/heads/master master

then copy the file in window like

 copy master C:\Ruby186\lib\ruby\gems\1.8\gems\de.oddb.org-2.0.0\.git\refs\headsstarting up 
 oddbd

results in

 no such file to load facet/string/singular

yes, it is not there because I installed facets-2.9.0 but I need

 gem install -v=1.8.54 facets

this worked. Now I get

 now such file to load -- dbi

I guess this is connected to this

 Dbd-pgDriver

ok, so it seems that

 gem install postgres
 gem install ruby-postgres

both fail on windows.

This installs

 gem install -v=0.4.1 dbi

well and result in a new error

 undefined method 'deprecate' for DBI::date:class <NoMethodError> 

Install

 postgres-8.4.6-1 

from here.

 Postgresql OLE DB

has also been installed via StackBuilder 3.0.0 that was packaged together with the Postgresql Install.

 postgres-pr

seems to be an option as well. Or we have to compile our own driver. I am trying to install

 gem install pg

but that depends on Ruby 1.8.7 on Windows XP.

 gem install -v=0.9.0 pg 

does install on windows XP.

 oddbd

still results in

 C:/Ruby186/lib/ruby/gems/1.8/gems/de.oddb-2.0.0/lib/oddb.rb:4: warning: already initialized constant VERSION
 C:/Ruby186/lib/ruby/gems/1.8/gems/dbi-0.4.1/lib/dbi/utils/date.rb:57: undefined method `deprecate' for DBI::Date:Class (NoMethodError
        from C:/Ruby186/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require'
        from C:/Ruby186/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'
        from C:/Ruby186/lib/ruby/gems/1.8/gems/dbi-0.4.1/lib/dbi/utils.rb:56
        from C:/Ruby186/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require'
        from C:/Ruby186/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'
        from C:/Ruby186/lib/ruby/gems/1.8/gems/dbi-0.4.1/lib/dbi.rb:50
        from C:/Ruby186/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:36:in `gem_original_require'
        from C:/Ruby186/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:36:in `require'
         ... 11 levels...
        from C:/Ruby186/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'
        from C:/Ruby186/lib/ruby/gems/1.8/gems/de.oddb-2.0.0/bin/oddbd:10
        from C:/Ruby186/bin/oddbd:19:in `load'
        from C:/Ruby186/bin/oddbd:19

useful Tips for the Windows Command Shell!

When I try to install

 gem install ruby-postgres

I get

 Building native extensions.  This could take a while...
 ERROR:  Error installing ruby-postgres:
        ERROR: Failed to build gem native extension.

 C:/Ruby186/bin/ruby.exe extconf.rb
 checking for main() in -lpq... no
 *** 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.

Ok, I am tryig it with there drivers here

 http://pgfoundry.org/frs/?group_id=1000085&release_id=539

the README says

 INSTALLATION INSTRUCTIONS
 In order to install this software, copy PGOLEDB.DLL and LIBPQ.DLL into your system
 directory. Next, as administrator, run "regsvr32 PGOLEDB.DLL". You should get a dialog
 message saying "registration succeeded".

this ends with some strange windows error message

 0x8002801c failed installation

Windows lists the following dbi gems

 dbi (0.4.5, 0.4.4, 0.4.3, 0.4.2, 0.4.1, 0.4.0)

Running oddbd on Ruby 1.8.7 on Windows results in

 C:/Ruby187/lib/ruby/gems/1.8/gems/de.oddb-2.0.0/lib/oddb.rb:4: warning: already initialized constant VERSION
 C:/Ruby187/lib/ruby/gems/1.8/gems/dbi-0.4.5/lib/dbi.rb:300:in `load_driver': Unable to load driver 'pg' (underlying error: wrong constant name pg) (DBI::InterfaceError)
        from C:/Ruby187/lib/ruby/1.8/monitor.rb:242:in `synchronize'
        from C:/Ruby187/lib/ruby/gems/1.8/gems/dbi-0.4.5/lib/dbi.rb:242:in `load_driver'
        from C:/Ruby187/lib/ruby/gems/1.8/gems/dbi-0.4.5/lib/dbi.rb:160:in `_get_full_driver'
        from C:/Ruby187/lib/ruby/gems/1.8/gems/dbi-0.4.5/lib/dbi.rb:145:in `connect'
        from C:/Ruby187/lib/ruby/gems/1.8/gems/odba-1.0.0/lib/odba/connection_pool.rb:60:in `_connect'
        from C:/Ruby187/lib/ruby/gems/1.8/gems/odba-1.0.0/lib/odba/connection_pool.rb:59:in `times'
        from C:/Ruby187/lib/ruby/gems/1.8/gems/odba-1.0.0/lib/odba/connection_pool.rb:59:in `_connect'
        from C:/Ruby187/lib/ruby/gems/1.8/gems/odba-1.0.0/lib/odba/connection_pool.rb:56:in `connect'
        from C:/Ruby187/lib/ruby/gems/1.8/gems/odba-1.0.0/lib/odba/connection_pool.rb:56:in `synchronize'
        from C:/Ruby187/lib/ruby/gems/1.8/gems/odba-1.0.0/lib/odba/connection_pool.rb:56:in `connect'
        from C:/Ruby187/lib/ruby/gems/1.8/gems/odba-1.0.0/lib/odba/connection_pool.rb:19:in `initialize'
        from C:/Ruby187/lib/ruby/gems/1.8/gems/de.oddb-2.0.0/lib/oddb/persistence/odba.rb:29:in `new'
        from C:/Ruby187/lib/ruby/gems/1.8/gems/de.oddb-2.0.0/lib/oddb/persistence/odba.rb:29
        from C:/Ruby187/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require'
        from C:/Ruby187/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'
        from C:/Ruby187/lib/ruby/gems/1.8/gems/de.oddb-2.0.0/lib/oddb/persistence.rb:4
        from C:/Ruby187/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require'
        from C:/Ruby187/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'
        from C:/Ruby187/lib/ruby/gems/1.8/gems/de.oddb-2.0.0/bin/oddbd:10
        from C:/Ruby187/bin/oddbd:19:in `load'
        from C:/Ruby187/bin/oddbd:19

Interesting: If I install

 gem instal dbd-pg version 0.3.9

I get a new error

 C:/Ruby187/lib/ruby/gems/1.8/gems/de.oddb-2.0.0/lib/oddb.rb:4: warning: already initialized constant VERSION
 C:/Ruby187/lib/ruby/gems/1.8/gems/dbd-pg-0.3.9/lib/dbd/pg/database.rb:82:in `initialize': 
 FATAL:  Passwort-Authentifizierung f³r Benutzer ╗oddb½ fehlgeschlagen (DBI::OperationalError)
        from C:/Ruby187/lib/ruby/gems/1.8/gems/dbd-pg-0.3.9/lib/dbd/pg.rb:157:in `new'
        from C:/Ruby187/lib/ruby/gems/1.8/gems/dbd-pg-0.3.9/lib/dbd/pg.rb:157:in `connect'
        from C:/Ruby187/lib/ruby/gems/1.8/gems/dbi-0.4.5/lib/dbi/handles/driver.rb:33:in `connect'
        from C:/Ruby187/lib/ruby/gems/1.8/gems/dbi-0.4.5/lib/dbi.rb:148:in `connect'
        from C:/Ruby187/lib/ruby/gems/1.8/gems/odba-1.0.0/lib/odba/connection_pool.rb:60:in `_connect'
        from C:/Ruby187/lib/ruby/gems/1.8/gems/odba-1.0.0/lib/odba/connection_pool.rb:59:in `times'
        from C:/Ruby187/lib/ruby/gems/1.8/gems/odba-1.0.0/lib/odba/connection_pool.rb:59:in `_connect'
        from C:/Ruby187/lib/ruby/gems/1.8/gems/odba-1.0.0/lib/odba/connection_pool.rb:56:in `connect'
        from C:/Ruby187/lib/ruby/gems/1.8/gems/odba-1.0.0/lib/odba/connection_pool.rb:56:in `synchronize'
        from C:/Ruby187/lib/ruby/gems/1.8/gems/odba-1.0.0/lib/odba/connection_pool.rb:56:in `connect'
        from C:/Ruby187/lib/ruby/gems/1.8/gems/odba-1.0.0/lib/odba/connection_pool.rb:19:in `initialize'
        from C:/Ruby187/lib/ruby/gems/1.8/gems/de.oddb-2.0.0/lib/oddb/persistence/odba.rb:29:in `new'
        from C:/Ruby187/lib/ruby/gems/1.8/gems/de.oddb-2.0.0/lib/oddb/persistence/odba.rb:29
        from C:/Ruby187/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require'
        from C:/Ruby187/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'
        from C:/Ruby187/lib/ruby/gems/1.8/gems/de.oddb-2.0.0/lib/oddb/persistence.rb:4
        from C:/Ruby187/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require'
        from C:/Ruby187/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'
        from C:/Ruby187/lib/ruby/gems/1.8/gems/de.oddb-2.0.0/bin/oddbd:10
        from C:/Ruby187/bin/oddbd:19:in `load'
        from C:/Ruby187/bin/oddbd:19

ok, adding the role oddb with the according password oddbd (de.oddb) starts up on windows:

 C:/Ruby187/lib/ruby/gems/1.8/gems/de.oddb-2.0.0/lib/oddb/html/util/known_user.rb:19:in 
 `initialize': invalid encoding ("utf8", "latin1") (Iconv::InvalidEncoding)
        from C:/Ruby187/lib/ruby/gems/1.8/gems/de.oddb-2.0.0/lib/oddb/html/util/known_user.rb:19:in `new'
        from C:/Ruby187/lib/ruby/gems/1.8/gems/de.oddb-2.0.0/lib/oddb/html/util/known_user.rb:19
        from C:/Ruby187/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require'
        from C:/Ruby187/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'
        from C:/Ruby187/lib/ruby/gems/1.8/gems/de.oddb-2.0.0/lib/oddb/util/server.rb:4
        from C:/Ruby187/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require'
        from C:/Ruby187/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'
        from C:/Ruby187/lib/ruby/gems/1.8/gems/de.oddb-2.0.0/lib/oddb/util.rb:9
        from C:/Ruby187/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require'
        from C:/Ruby187/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'
        from C:/Ruby187/lib/ruby/gems/1.8/gems/de.oddb-2.0.0/bin/oddbd:11
        from C:/Ruby187/bin/oddbd:19:in `load'
        from C:/Ruby187/bin/oddbd:19

Add postgres (and all the other stuff) to your path

 C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Ruby187\bin;C:\Ruby186\bin;C:\tools;C:\Program Files\PostgreSQL\8.4\bin;C:\Program Files\7-Zip;

Extract the database with

 7z x oddb_backup.gz

Create the DB

 createdb -U oddb -E UTF8 -T template0 oddb

Load the data

 psql -U oddb oddb < 22_00-postgresql_database-oddb-backup

run again

 oddbd

results in

 C:/Ruby187/lib/ruby/gems/1.8/gems/de.oddb-2.0.0/lib/oddb/html/util/known_user.rb:19:in 
 `initialize': invalid encoding ("utf8", "latin1") (Iconv::InvalidEncoding)
        from C:/Ruby187/lib/ruby/gems/1.8/gems/de.oddb-2.0.0/lib/oddb/html/util/known_user.rb:19:in `new'
        from C:/Ruby187/lib/ruby/gems/1.8/gems/de.oddb-2.0.0/lib/oddb/html/util/known_user.rb:19
        from C:/Ruby187/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require'
        from C:/Ruby187/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'
        from C:/Ruby187/lib/ruby/gems/1.8/gems/de.oddb-2.0.0/lib/oddb/util/server.rb:4
        from C:/Ruby187/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require'
        from C:/Ruby187/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'
        from C:/Ruby187/lib/ruby/gems/1.8/gems/de.oddb-2.0.0/lib/oddb/util.rb:9
        from C:/Ruby187/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `gem_original_require'
        from C:/Ruby187/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in `require'
        from C:/Ruby187/lib/ruby/gems/1.8/gems/de.oddb-2.0.0/bin/oddbd:11
        from C:/Ruby187/bin/oddbd:19:in `load'
        from C:/Ruby187/bin/oddbd:19

Also

 gem install character-encodings

fails with

 Makefile:121: *** target pattern contains no `%'.  Stop.

So now I need the devkit for Ruby

 http://rubyinstaller.org/downloads/

and then follow the instructions how to install devkit in windows

 https://github.com/oneclick/rubyinstaller/wiki/development-kit
 dk.rb init
 dk.rb install
 gem install rdiscount --platform=ruby

Devkit gets me one step further but stops here:

 Ruby-Postgres
 http://pastebin.com/Xqa1V0hR

 Character-Encodings
 http://pastebin.com/jyQEePC9

 Both fail. I have the latest devkit installed for windows.

 Merry X-mas.

this does install on windows

 rkj-character-encodings (0.4.1)

Ok after Windows and Activesupport and Apxs I am off to the Apache error_log that says

 [Fri Jan 14 14:12:24 2011] [error] mod_ruby: failed to require sbsm/trans_handler^M
 [Fri Jan 14 14:12:24 2011] [error] mod_ruby: error in ruby^M
 [Fri Jan 14 14:12:24 2011] [error] mod_ruby: ruby:0:in `require': no such file to load -- sbsm/trans_handler (LoadError)

You must install

 Rockit

in the right directory. Also follow the mod_ruby http.conf instructions

 http://modruby.net/en/index.rbx?mode=search&word=RubyRequire#label-1

Switching Ruby Version on Windows

 gem install pik
 pik_install C:\tools

and then add pik to your windows path where you installed it to.

 pik 187

or

 pik 186

will switch you between Ruby versions 1.8.6 and 1.8.7

view · edit · sidebar · attach · print · history
Page last modified on January 15, 2011, at 04:22 PM