Re: Permission error updating chart of accounts

[Leah Kubik <..hidden..>]

On Wednesday 02 May 2007 13:15, Chris Travers wrote:
> Ok, Check the user record (in admin.pl) to see if you are logging in
> as ledgersmb.

So I failed to copy my last reply to the list, but I did check and the user is 
loggin in as ledgersmb.  I have tried creating a new database using this one 
as a template as the ledgersmb user, but I get the same errors with the new 
db.  Doe anyone have an idea of how I can migrate this database data into a 
clean DB that doesn't have this permission error, or where to look?

Leah

> On 5/2/07, Leah Kubik <..hidden..> wrote:
> > On Wednesday 02 May 2007 00:51, Chris Travers wrote:
> > > On 5/1/07, Leah Kubik <..hidden..> wrote:
> > > > Ok, so even though ledgersmb was the owner, it turned you you were
> > > > correct, the admin privs weren't set...  I've gotten past that and
> > > > now I'm getting an error with the relation 'chart'
> > >
> > > Are you logging into the db as ledgersmb?
> >
> > In ledgersmb.conf I have:
> >
> > DBUserName   = ledgersmb
> >
> > Also when I use the psql command, I was using the root user, but it seems
> > fine with ledgersmb as well:
> >
> > frauerpower-accounts=> \z chart
> >  Access privileges for database "frauerpower-accounts"
> >  Schema | Name  | Type  |       Access privileges
> > --------+-------+-------+-------------------------------
> >  public | chart | table | {ledgersmb=arwdRxt/ledgersmb}
> > (1 row)
> >
> > I seem to be able to do selects on the chart table, I haven't tried doing
> > an insert.
> >
> > Is there anything I can try?  I'm kind of at a loss as to where
> > permissions could be borked... I don't mind exporting the database and
> > trying to re-import it, if that might help, but was a little unclear on
> > how I could properly do that with this existing data.  I also seem to be
> > having a similar error in other areas of the application, so it's not
> > just charts.  I can't add a new invoice, and so on...  It seems I can
> > view everything, just no inserts or updates.  I'm sure it is a
> > permissions problem, but I don't know where to look.
> >
> > Is there a way to get any more detailed logs to verify the web
> > application is logging in as ledgersmb, more details on the error, etc?
> >
> > The ledgersmb user itself does not have super user privilages in
> > postgres, but I did not think that that should matter..?  Sorry, when it
> > comes to the user privilage stuff in PostgreSQL, I seem to have issues.

-- 
Leah Kubik : d416-585-9971x692 : d416-703-5977 : m416-559-6511
Frauerpower! Co. : www.frauerpower.com : Toronto, ON Canada
MSN: ..hidden.. | AIM: frauerpower | Yahoo: h3inous
F9B6 FEFE 080B 8299 D7EA  1270 005C EC73 47C9 B7A6