Hello Tim, and congratulations to your successful install. I think it is very honorable of you that you took the time to thank all of those in our community who have helped you and accompanied your on your path to a new SQL-Ledger 3.0 install. Rolf, Armaghan and Jean Pierre are certainly all very fine neighbors! More of them and the world would definitely have less wars.
I also want to take this opportunity to invite you and everyone else who is interested in the further support and development of SQL-Ledger to join our fine International SQL-Ledger Network Association: http://www.sql-ledger-network.com/wiki/doku.php Regards, Sebastian On Thu, 2012-10-11 at 18:53 +0200, Penguin Products wrote: > Finally sorted it all out, thanks so much, the bottom line is you > shouldn't let a part time person who THINKS he might be able to do > something like this near a command line.....(that person being me)... > Bottom line was that I was trying to access the pg database as > sql-ledger and I had not set sql-ledger up correctly as a user, as you > all guessed, (please excuse the laymans terms... thats what I am when > it comes to this) so Postgres wasn't me letting in. Also the syntax > has changed slightly from psql 8.3 to 9.1 which is what Ubuntu 12.04 > is running... finally got that figured out with a little help from a > friend (ie sat and watched him do it on teamview), applied Armaghan's > Custom tables to the database and it looks like I'm in business. > > http://www.ledger123.com/archives/msg05860.html is what got us on the > right track and then a quick google of > http://www.ledger123.com/archives/msg05860.html got us the right > syntax. and it all finally worked > > I am indebted especially to Rolf who took the time to look at my > initial disaster of an install and so stopped me wasting days trying > to make something work that was broken, to Amarghan for his advice and > help and to Jean Pierre who offered to sort out my databse for me if > we didn't come right. I am very grateful to you all > > I've learnt a huge amount over the last few days and am in awe at your > abilities to make computers do things I only dream about!! > > Tim Wade > Penguin Products > Ph: (021) 797-0725 > Fax: (021) 762-4644 > > Picture > > > > > On Wed, Oct 10, 2012 at 5:33 PM, Penguin Products > <[email protected]> wrote: > > Hi Armaghan > > We ran the Pg-custom_tables.sql on the database after > importing the dataset. no errors were reported during that > process, but we still have the same error on login into > sql-ledger > > > Error! > > SELECT * FROM defaults > ERROR: permission denied for relation defaults > > If I login using a test database Sql-ledger runs fine. > > > > Thanks again > > > Tim Wade > Penguin Products > Ph: (021) 797-0725 > Fax: (021) 762-4644 > > Picture > > > > > On Wed, Oct 10, 2012 at 2:38 AM, Armaghan Saqib > <[email protected]> wrote: > > On Wed, Oct 10, 2012 at 2:10 PM, Penguin Products > <[email protected]> wrote: > > Thank you to all who helped, I now have a > working version of Ledger123 (2.8.33) up and > running. > > How do I restore the backup from Sql Ledger > 2.8.14 onto this current version. When I > import the penguin.sql file, I get an error on > login that's a SQL error which means it's > looking for something that doesn't exist or > the sql is different. > > > to do the import I did: psql [database] < > databasename.sql > so psql penguin < penguin.sql > if I create the dataset in sql-ledger the > import gives errors but still completes > if i create an empty database and import there > are no errors on import > > but either way they give the same error on > login. > > > Please run sql/Pg-custom_tables.sql on the database > after importing your dataset. This should fix the > problem. > > > If not, post the error message. > > Regards > Armaghan > > > > _______________________________________________ > SQL-Ledger mailing list > [email protected] > http://lists.ledger123.com/mailman/listinfo/sql-ledger > > > > > > > > _______________________________________________ > SQL-Ledger mailing list > [email protected] > http://lists.ledger123.com/mailman/listinfo/sql-ledger
_______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
