From: Adrian <adr...@ie...> - 2007-01-01 02:49:12
|
I created a new user as suggested by Torben. I could then access an empty dataset. Then a restore: psql -U sql-ledger dbname < backup.sql Bingo! everything works. Adrian On Sunday 31 December 2006 21:06, you wrote: > Adrian, > > SL saves passwords in files, if you did not copy over the files from the > original server, you might not have any users. If possible, start your > new installation by using your old SL files, and then upgrade (if > needed). That's the only way I know of to restore old users. If that > doesn't work for you, you could probably safely add new ones (with > different login spelling) without affecting the original ones while you > find a solution in the interim. > > If you have a blank user slate, try logging into the admin area without > a password.. > > Adrian wrote: > > I am submitting this a second time as the previous post was possibly > > forgotten in the Christmas e-mails. > > > > The details: > > Mandriva 2007 > > Postgres 8.1 > > Latest SQL-Ledger > > Backed up on one computer and restored on new machine > > > > Error message in bowser is: > > Error > > Access Denied > > > > # tail /var/log/httpd/error_log > > [Sat Dec 23 05:05:19 2006] [crit] (20019)DSO load failed: DBD: failed to > > initialise > > [Sat Dec 23 05:05:19 2006] [crit] (20019)DSO load failed: DBD: can't > > find driver for [DBDriver unset] > > > > Is it a permissions problem or a software problem or database user > > problem. Either something is missing or I have forgotten something in the > > installation. > > > > Adrian -- Adrian Blake Molonglo Radio Observatory 1152 Hoskinstown Rd Bungendore NSW, 2621, Australia ph 02 62382262 mobile 0407 232 978 skype vk2alf |