On Fri, Mar 21, 2014 at 11:10 AM, Max van Biezen <mvanb...@gmail.com> wrote:
> Hi,
>
> Unfortunately I am not sure how I got this result. I was editing fields of
> parts in menu "goods & services" in LSMB 1.3.38 using postgres 9.1. I using
> a fresh new database so there is no old data from previous installations.
>
> After I had logged on as a different user with less privileges I went back
> to my full permission account to LSMB and when I select a part from the
> search list in goods&services (search simply on everything) then I get
> "access denied" in the browser.
>
This was a renamed database?
>
> What does this mean and what can I do to make this work? Any tips on how
> to debug further?
>
For now you can:
grant select on file_links to public;
>
> for any part I select the postgres log shows:
>
> 2014-03-21 16:46:53 CET ERROR: permission denied for relation file_links
> 2014-03-21 16:46:53 CET CONTEXT: SQL function "file__list_links"
> statement 1
> 2014-03-21 16:46:53 CET STATEMENT: SELECT * FROM
> "public"."file__list_links"('45', '3')
> 2014-03-21 16:52:33 CET ERROR: permission denied for relation file_links
> 2014-03-21 16:52:33 CET CONTEXT: SQL function "file__list_links"
> statement 1
> 2014-03-21 16:52:33 CET STATEMENT: SELECT * FROM
> "public"."file__list_links"('42', '3')
> 2014-03-21 16:54:20 CET ERROR: permission denied for relation file_links
> 2014-03-21 16:54:20 CET CONTEXT: SQL function "file__list_links"
> statement 1
> 2014-03-21 16:54:20 CET STATEMENT: SELECT * FROM
> "public"."file__list_links"('16', '3')
>
> The apache error log shows:
>
> 2014/03/21 19:03:44 - INFO - LedgerSMB::new -- setting dbh from argstr
> $self->{dbh}=DBI::db=HASH(0x313e918)
> DBD::Pg::st execute failed: ERROR: permission denied for relation
> file_links
> CONTEXT: SQL function "file__list_links" statement 1 at LedgerSMB.pm line
> 834.
> 2014/03/21 19:03:44 - ERROR - LedgerSMB::dberror LedgerSMB.pm (1100) --
> Logging SQL State 42501, error 7, string ERROR: permission denied for
> relation file_links
> CONTEXT: SQL function "file__list_links" statement 1
> Died at LedgerSMB.pm line 954.
> Compilation failed in require at /usr/share/ledgersmb/ic.pl line 7.
>
> Regards,
>
> Max
>
>
> ------------------------------------------------------------------------------
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and their
> applications. Written by three acclaimed leaders in the field,
> this first edition is now available. Download your free book today!
> http://p.sf.net/sfu/13534_NeoTech
> _______________________________________________
> Ledger-smb-users mailing list
> Ledger-smb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
