Thanks for the response. Does the user logging into the Ledger control-panel need to be the same username as the database user? Also, do these usernames need to be the same as the exisiting users on the server being migrated from?
-m On Tue, Sep 27, 2011 at 10:00 AM, Chris Travers <[email protected]> wrote: > On Tue, Sep 27, 2011 at 6:58 AM, Matt Abernathy <[email protected]> > wrote: >> Hi All, >> >> I'm trying to migrate my SQL-ledger installation from an in-house >> server to an external server. I tried making a dump of the database, >> setting up SQL-ledger, adding a user, importing a database, and >> logging on. >> >> Upon login, I receive the following error. Does anyone have any ideas? >> >> Error! >> >> SELECT * FROM defaults >> ERROR: permission denied for relation defaults > > Log in to the admin console and make sure each of your users is > logging in under the account you loaded the database under. > > Best Wishes, > Chris Travers > _______________________________________________ > 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
