postgreSQL integration
I'm currently trying to setup schleuder with postgres instead of sqlite. Unfortunately, to me it seems like there is a sqlite3 dependency even after installation.
Here is how I setup the things so far:
- Installed all the dependencies
- Created the necessary postgres database
- Downloaded and installed the schleuder gem (
schleuder-3.0.0.beta14.gem
) - Adjusted the database section of
schleuder.yml
to respect my postgres database - Installed the
pg
andpostgresql
gems - Reran the schleuder installation with the new database config (went fine)
- Removed sqlite from my system
However, if I run schleuder-api-daemon
as a non-root user now, I receive the following error message:
/usr/lib/ruby/2.1.0/rubygems/core_ext/kernel_require.rb:126:in `require': cannot load such file -- sqlite3 (LoadError)
from /usr/lib/ruby/2.1.0/rubygems/core_ext/kernel_require.rb:126:in `require'
from /var/lib/gems/2.1.0/gems/backports-3.6.8/lib/backports/std_lib.rb:9:in `require_with_backports'
from /var/lib/gems/2.1.0/gems/activesupport-4.2.8/lib/active_support/dependencies.rb:274:in `block in require'
from /var/lib/gems/2.1.0/gems/activesupport-4.2.8/lib/active_support/dependencies.rb:240:in `load_dependency'
from /var/lib/gems/2.1.0/gems/activesupport-4.2.8/lib/active_support/dependencies.rb:274:in `require'
from /var/lib/gems/2.1.0/gems/schleuder-3.0.0.beta14/lib/schleuder.rb:65:in `<top (required)>'
from /var/lib/gems/2.1.0/gems/schleuder-3.0.0.beta14/bin/schleuder-api-daemon:10:in `require_relative'
from /var/lib/gems/2.1.0/gems/schleuder-3.0.0.beta14/bin/schleuder-api-daemon:10:in `<top (required)>'
from /usr/local/bin/schleuder-api-daemon:23:in `load'
from /usr/local/bin/schleuder-api-daemon:23:in `<main>'
Consistently, running schleuder
itself as the same user, I get a similar error:
/usr/lib/ruby/2.1.0/rubygems/core_ext/kernel_require.rb:126:in `require': cannot load such file -- sqlite3 (LoadError)
from /usr/lib/ruby/2.1.0/rubygems/core_ext/kernel_require.rb:126:in `require'
from /var/lib/gems/2.1.0/gems/activesupport-4.2.8/lib/active_support/dependencies.rb:274:in `block in require'
from /var/lib/gems/2.1.0/gems/activesupport-4.2.8/lib/active_support/dependencies.rb:240:in `load_dependency'
from /var/lib/gems/2.1.0/gems/activesupport-4.2.8/lib/active_support/dependencies.rb:274:in `require'
from /var/lib/gems/2.1.0/gems/schleuder-3.0.0.beta14/lib/schleuder.rb:65:in `<top (required)>'
from /var/lib/gems/2.1.0/gems/schleuder-3.0.0.beta14/lib/schleuder/cli.rb:5:in `require_relative'
from /var/lib/gems/2.1.0/gems/schleuder-3.0.0.beta14/lib/schleuder/cli.rb:5:in `<top (required)>'
from /var/lib/gems/2.1.0/gems/schleuder-3.0.0.beta14/bin/schleuder:7:in `require_relative'
from /var/lib/gems/2.1.0/gems/schleuder-3.0.0.beta14/bin/schleuder:7:in `<top (required)>'
from ./schleuder:23:in `load'
from ./schleuder:23:in `<main>'
On the other hand, running schleuder-api-daemon
as root seems to work fine:
Warning: Without TLS, schleuder-api-daemon enforces binding to localhost only!
Execute `schleuder cert generate` and follow the instructions.
== Sinatra/1.4.0 has taken the stage on 4443 for production with backup from Thin
>> Thin web server (v1.3.1 codename Triple Espresso)
>> Maximum connections set to 1024
>> Listening on localhost:4443, CTRL+C to stop
What could be causing schleuder
to fail under the non-root user?
This seems to be one of the last problems to stop schleuder from being used with postgres as I see things.