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.
What does this mean and what can I do to make this work? Any tips on how to
debug further?
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
