<< Deoddb | Index | DeoddbSnowLeopard >>
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
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
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