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
|
