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. Thanks again Tim Wade Penguin Products Ph: (021) 797-0725 Fax: (021) 762-4644 [image: Picture] On Mon, Oct 8, 2012 at 10:48 PM, Penguin Products <[email protected] > wrote: > Thank you for your help thus far. > > I am now up and running and can get as far as the login pages... but it > wont let me create datasets on admin.pl having said that it has does > create a database of sorts as the name appears at the top in brackets but > it doesn't seem to recognise them or allow you to use them and returns an > error when you press "create dataset" > > any ideas? > > > Tim Wade > Penguin Products > Ph: (021) 797-0725 > Fax: (021) 762-4644 > > [image: Picture] > > > > On Fri, Oct 5, 2012 at 4:23 PM, Rolf Stöckli <[email protected]> wrote: > >> Am 05.10.2012 13:07, schrieb Penguin Products: >> >>> 1. It couldn't find /usr/local/sql-ledger.conf I did find one under >>> >>> /usr/local/sql-ledger/sql-**ledger.conf but there was nothing about >>> "#available printers" in there. >>> >> >> You find a sql-ledger.conf.default in the installation and you have to >> copy it to sql-ledger.conf. >> Printers are configured inside the program in version 3. >> >> >>> On the Database setup >>> >>> 1. The Postgresql database that was downloaded was 9.1 not 8.4. in the >>> >>> pg_hba.conf file There was no "local all all ident" line. there >>> was a "local all all peer" line though.. must the word "peer" be >>> replaced with "trust" >>> >> >> Ubuntu 12.04 ships with 9.1, and yes, replace "peer" with "trust". >> >> 2. When I executed the su postgres -c "createuser -d -S -R >>> >>> sql-ledger" line it told me it "could not change directory to root" >>> but it had created the role sql-ledger when I ran the command again. >>> >> >> You were in /root when you called this command. Don't worry. >> >> >>> On the Web Server Setup >>> >>> 1. the wget http://remine etc..etc.. command got me a 404 page not >>> >>> found error, has this changed? >>> 2. I finished off the rest of the commands but going into the web >>> >>> browser and trying to open 192.168.1.109/sql-ledger >>> <http://192.168.1.109/sql-**ledger <http://192.168.1.109/sql-ledger>> >>> (in my case) got me a not found >>> >>> reply.. its happy with the 192.168.1.109 part, not the /sql-ledger >>> part >>> >> >> The Redmine server is offline. I've added a Apache config file to my >> Github repo and updated the wiki: >> http://www.sql-ledger-network.**com/wiki/doku.php/step_by_** >> step_installation/ubuntu?&#**web_server_set_up<http://www.sql-ledger-network.com/wiki/doku.php/step_by_step_installation/ubuntu?&#web_server_set_up> >> >> Regards >> Rolf >> >> ______________________________**_________________ >> SQL-Ledger mailing list >> [email protected] >> http://lists.ledger123.com/**mailman/listinfo/sql-ledger<http://lists.ledger123.com/mailman/listinfo/sql-ledger> >> > >
_______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
