Peter Keen <[email protected]> writes: > As promised, here's the blog post about Ledger Web. > > http://bugsplat.info/2012-01-01-a-robust-reporting-system-for-ledger.html
Pete, This looks like a really great step; I've wanted for some time to be able to produce ledger reports using SQL queries and R. Yet one seems to need PostgreSQL and Ruby skills as well as normal ledger and SQL skills, and that's slowing me down. I have run PostgreSQL, but it's been years ago, and I usually use SQLite today. I've never used Ruby; J and R are my preferred scripting languages, but I can read a bit of Python. I'm not opposed to learning something new, but there seem to be a number of moving parts, and a bit of a hint would help. I'm running Debian 6.03, which comes with PostgreSQL 8.04. I've upgraded to PostgreSQL 9.1.2, courtesy of Debian Backports. I've also run the gem command, and I think I've created the database (PostgreSQL complains if I try to recreate it that it's now there), but ledger_web doesn't do anything, and http://localhost:9090/ seems dead. Perhaps it would help someone like me to know dependencies and steps in a bit more detail: Dependencies: - PostgreSQL 9.0 or greater, right? - Ruby xxx or greater? - ledger xxx? (I'm running 2.6.2, which came with my Debian) - anything else? Steps: - Install ledger_web using gem as root? as me? - Create the ledger database as me, postgres, root, ...? - Run ledger_web as me, postgres, root, ...? - Possible interactions with NoScript and ABE and their proper configuration I got confused on the first three steps by seeing the $ in the prompt, suggesting (to me) running them all as me. Given that no one else has asked, I'm sure these are easy questions with obvious answers. I just don't know them, and I hope not to have to learn Ruby and PostgreSQL admin in detail before running ledger_web. Thanks, Bill -- Bill Harris http://makingsense.facilitatedsystems.com/ Facilitated Systems Everett, WA 98208 USA http://www.facilitatedsystems.com/ phone: +1 425 374-1845
