Peter, One other thing... I don't really know much about ruby or postgresql so here I ask:
After importing my ledger file all reports claim there is no data. I looked into the postgresql db using pgadmin and it seems that all lines are there but they are empty! I don't understand, do you have any idea of what is happening? Thanks, Raphael On Saturday, March 17, 2012 6:55:17 PM UTC-3, Peter Keen wrote: > > Hi Bill, > > I'm sorry you've had so many problems with ledger_web! It's completely > my fault, I forgot a line in the gemspec file. If you take a look at > the commit[1] you'll see exactly what I missed. > > I pushed a new version up to rubygems (1.4.2). If you install that you > should find a ledger_web binary in the appropriate bin directory. > > With regards to your postgres problem, it looks like your linux > distribution installed a (very sane) default of requiring passwords > for all accounts. PostgreSQL accounts are separate from system > accounts. To set a password on your database account, run the > following ($ and postgres=# are prompts): > > $ sudo su -u postgres psql > postgres=# alter role your_user_name with password 'your password'; > postgres=# commit; > postgres=# \q > > To change the database URL that ledger_web uses, put the following > into ~/.ledger_web/config.rb: > > ,-- > | LedgerWeb::Config.new do |config| > | config.set :database_url, > "postgres://username:password@hostname/databasename" > | end > `-- > > Replace the username, password, hostname, and databasename with the > appropriate values. > > I hope this helps you get up and running! Again, I'm sorry about the > missed gemspec option. > > --Pete > > [1]: > https://github.com/peterkeen/ledger-web/commit/1335e8aa2fc20f06c5aa9b401e3d2fa25ec58c18#L0R24 > > On Sat, Mar 17, 2012 at 2:18 PM, Bill Harris > <[email protected]> wrote: > > Peter Keen <[email protected]> writes: > > > >> I don't know debian but a few things to check: > >> > >> - is it in /usr/local/bin > >> - is it in /usr/local/share/<something>/? > > > > Peter, > > > > I just installed ruby-full today to make sure I had everything, and > > then, as root, I installed ledger_web, as you describe on your git > > page. > > > > I still get > > > > ,---- > > | $ ledger_web > > | bash: ledger_web: command not found > > `---- > > > > I figured it must have done _something_, so I searched for it. After > > eliding a bunch of "Permission denied lines (e.g., lots of /proc/...), I > > see > > > > ,---- > > | $ find / -name ledger_web* -print > > | /home/myname/.gem/specs/rubygems.org > %80/quick/Marshal.4.8/ledger_web-1.3.gemspec > > | /home/myname/.gem/ruby/1.8/cache/ledger_web-1.3.gem > > | /var/lib/gems/1.8/bin/ledger_web > > | /var/lib/gems/1.8/specifications/ledger_web-1.3.gemspec > > | /var/lib/gems/1.8/doc/ledger_web-1.3 > > | /var/lib/gems/1.8/doc/ledger_web-1.3/rdoc/files/lib/ledger_web_rb.html > > | /var/lib/gems/1.8/doc/ledger_web-1.3/rdoc/files/lib/ledger_web > > | /var/lib/gems/1.8/cache/ledger_web-1.3.gem > > | /var/lib/gems/1.8/gems/ledger_web-1.3 > > | /var/lib/gems/1.8/gems/ledger_web-1.3/ledger_web.gemspec > > | /var/lib/gems/1.8/gems/ledger_web-1.3/lib/ledger_web > > | /var/lib/gems/1.8/gems/ledger_web-1.3/lib/ledger_web.rb > > | /var/lib/gems/1.8/gems/ledger_web-1.3/bin/ledger_web > > `---- > > > > I figure the stuff in ~/.gem is setup material, but the rest went into > > /var -- is that right? > > > > An entry for ledger_web looks like > > > > ,---- > > | -rwxr-xr-x 1 root root 391 Mar 17 13:16 ledger_web > > `---- > > > > so I tried to run it as myself (you said that was the expected mode of > > operation). That gave me > > > > ,---- > > | $ /var/lib/gems/1.8/bin/ledger_web > > | > /var/lib/gems/1.8/gems/sequel-3.32.0/lib/sequel/adapters/postgres.rb:231:in > `initialize': PGError: fe_sendauth: no password supplied > (Sequel::DatabaseConnectionError) > > | from > /var/lib/gems/1.8/gems/sequel-3.32.0/lib/sequel/adapters/postgres.rb:231:in > `connect' > > | from > /var/lib/gems/1.8/gems/sequel-3.32.0/lib/sequel/adapters/postgres.rb:231:in > `connect' > > | from > /var/lib/gems/1.8/gems/sequel-3.32.0/lib/sequel/database/misc.rb:48:in > `initialize' > > | from > /var/lib/gems/1.8/gems/sequel-3.32.0/lib/sequel/connection_pool.rb:92:in > `call' > > | from > /var/lib/gems/1.8/gems/sequel-3.32.0/lib/sequel/connection_pool.rb:92:in > `make_new' > > | from > /var/lib/gems/1.8/gems/sequel-3.32.0/lib/sequel/connection_pool/threaded.rb:127:in > > `make_new' > > | from > /var/lib/gems/1.8/gems/sequel-3.32.0/lib/sequel/connection_pool/threaded.rb:113:in > > `available' > > | from > /var/lib/gems/1.8/gems/sequel-3.32.0/lib/sequel/connection_pool/threaded.rb:103:in > > `acquire' > > | from > /var/lib/gems/1.8/gems/sequel-3.32.0/lib/sequel/connection_pool/threaded.rb:147:in > > `sync' > > | from > /var/lib/gems/1.8/gems/sequel-3.32.0/lib/sequel/connection_pool/threaded.rb:147:in > > `synchronize' > > | from > /var/lib/gems/1.8/gems/sequel-3.32.0/lib/sequel/connection_pool/threaded.rb:147:in > > `sync' > > | from > /var/lib/gems/1.8/gems/sequel-3.32.0/lib/sequel/connection_pool/threaded.rb:102:in > > `acquire' > > | from > /var/lib/gems/1.8/gems/sequel-3.32.0/lib/sequel/connection_pool/threaded.rb:74:in > > `hold' > > | from > /var/lib/gems/1.8/gems/sequel-3.32.0/lib/sequel/database/connecting.rb:225:in > `synchronize' > > | from > /var/lib/gems/1.8/gems/sequel-3.32.0/lib/sequel/adapters/postgres.rb:259:in > `execute' > > | from > /var/lib/gems/1.8/gems/sequel-3.32.0/lib/sequel/adapters/postgres.rb:393:in > `check_database_errors' > > | from > /var/lib/gems/1.8/gems/sequel-3.32.0/lib/sequel/adapters/postgres.rb:257:in > `execute' > > | from > /var/lib/gems/1.8/gems/sequel-3.32.0/lib/sequel/database/query.rb:74:in > `execute_dui' > > | from > /var/lib/gems/1.8/gems/sequel-3.32.0/lib/sequel/database/query.rb:67:in > `execute_ddl' > > | from > /var/lib/gems/1.8/gems/sequel-3.32.0/lib/sequel/database/schema_methods.rb:377:in > > `create_table_from_generator' > > | from > /var/lib/gems/1.8/gems/sequel-3.32.0/lib/sequel/database/schema_methods.rb:97:in > > `create_table' > > | from > /var/lib/gems/1.8/gems/sequel-3.32.0/lib/sequel/extensions/migration.rb:629:in > > `schema_dataset' > > | from > /var/lib/gems/1.8/gems/sequel-3.32.0/lib/sequel/extensions/migration.rb:382:in > > `initialize' > > | from > /var/lib/gems/1.8/gems/sequel-3.32.0/lib/sequel/extensions/migration.rb:542:in > > `initialize' > > | from > /var/lib/gems/1.8/gems/sequel-3.32.0/lib/sequel/extensions/migration.rb:333:in > > `new' > > | from > /var/lib/gems/1.8/gems/sequel-3.32.0/lib/sequel/extensions/migration.rb:333:in > > `run' > > | from > /var/lib/gems/1.8/gems/sequel-3.32.0/lib/sequel/extensions/migration.rb:317:in > > `apply' > > | from /var/lib/gems/1.8/gems/ledger_web-1.3/lib/ledger_web/db.rb:7 > > | from /usr/lib/ruby/1.8/rubygems/custom_require.rb:31:in > `gem_original_require' > > | from /usr/lib/ruby/1.8/rubygems/custom_require.rb:31:in `require' > > | from /var/lib/gems/1.8/gems/ledger_web-1.3/lib/ledger_web.rb:6 > > | from /usr/lib/ruby/1.8/rubygems/custom_require.rb:31:in > `gem_original_require' > > | from /usr/lib/ruby/1.8/rubygems/custom_require.rb:31:in `require' > > | from /var/lib/gems/1.8/gems/ledger_web-1.3/bin/ledger_web:7 > > | from /var/lib/gems/1.8/bin/ledger_web:19:in `load' > > | from /var/lib/gems/1.8/bin/ledger_web:19 > > `---- > > > > I found there was already a ledger db, so I ran as me > > > > ,---- > > | dropdb ledger > > | createdb ledger > > `---- > > > > but I still got that list of messages. > > > > Does this suggest anything? Is it possibly a Ruby 1.8 vs. 1.9 problem? > > Do I need to pass the ledger db a password? If so, how? > > > > Thanks, > > > > Bill > > -- > > Bill Harris > > Facilitated Systems > > http://makingsense.facilitatedsystems.com/ > >
