Re: [Ledger-smb-devel] DBD::Pg::st execute failed: ERROR: permission denied for relation...

2009-10-28 Thread blck shp
pl On Tue, Oct 27, 2009 at 2:43 PM, Chris Travers wrote: > > > On Tue, Oct 27, 2009 at 12:11 PM, blck shp wrote: >> >> Hmmm...OK. >> >> Looking back when I applied the pre-processed roles sql: >> su - postgres -c "psql -U ledgersmb -d ledgersmb1

Re: [Ledger-smb-devel] DBD::Pg::st execute failed: ERROR: permission denied for relation...

2009-10-27 Thread blck shp
like spelling. What values were to be inserted between 1090 and 1091? And I am supposing that "account_link_id_seq" has a different name for the other two. On Tue, Oct 27, 2009 at 2:43 PM, Chris Travers wrote: > > > On Tue, Oct 27, 2009 at 12:11 PM, blck shp wrote: >&g

Re: [Ledger-smb-devel] DBD::Pg::st execute failed: ERROR: permission denied for relation...

2009-10-27 Thread blck shp
x27;m seeing? On Tue, Oct 27, 2009 at 1:53 PM, Chris Travers wrote: > > > On Tue, Oct 27, 2009 at 11:40 AM, blck shp wrote: >> >> I named it ledgersmb13. >> > > I wonder if somehow the permissions didn't get applied to the tables. > > Best Wishe

Re: [Ledger-smb-devel] DBD::Pg::st execute failed: ERROR: permission denied for relation...

2009-10-27 Thread blck shp
I named it ledgersmb13. On Tue, Oct 27, 2009 at 1:35 PM, Chris Travers wrote: > > > On Tue, Oct 27, 2009 at 11:29 AM, blck shp wrote: >> >> > Ok.  And the errors are still tied to the relations?  Which relations >> > specifically are triggered? >> >

Re: [Ledger-smb-devel] DBD::Pg::st execute failed: ERROR: permission denied for relation...

2009-10-27 Thread blck shp
u create a customer or vendor? No, I get "Error! Access Denied" when trying to create a customer. On Tue, Oct 27, 2009 at 1:07 PM, Chris Travers wrote: > > > On Tue, Oct 27, 2009 at 10:46 AM, blck shp wrote: >> >> > If you try to access using the normal user, you

Re: [Ledger-smb-devel] DBD::Pg::st execute failed: ERROR: permission denied for relation...

2009-10-27 Thread blck shp
gersmb13__part_translation_create,lsmb_ledgersmb13__project_translation_create,lsmb_ledgersmb13__all_manual_translation,lsmb_ledgersmb13__users_manage,lsmb_ledger smb13__draft_edit,lsmb_ledgersmb13__voucher_delete} On Tue, Oct 27, 2009 at 12:07 PM, Chris Travers wrote: > > > On Tue, Oct 27, 2009 at 9

Re: [Ledger-smb-devel] DBD::Pg::st execute failed: ERROR: permission denied for relation...

2009-10-27 Thread blck shp
$> postgres --version postgres (PostgreSQL) 8.3.8 On Tue, Oct 27, 2009 at 11:37 AM, Chris Travers wrote: > > > On Tue, Oct 27, 2009 at 6:54 AM, blck shp wrote: >> >> OK, an update... > > What version of PostgreSQL are you using? &g

Re: [Ledger-smb-devel] DBD::Pg::st execute failed: ERROR: permission denied for relation...

2009-10-27 Thread blck shp
mb13/admin.pl line 3., referer: http://192.168.1.1/ledgersmb13/admin.pl?action=edit_user&user_id=1 Line 605 at LedgerSMB.pm doesn't look unusual, what do you think? On Mon, Oct 26, 2009 at 4:27 PM, Chris Travers wrote: > > > On Mon, Oct 26, 2009 at 1:01 PM, blck shp wrote: &

Re: [Ledger-smb-devel] DBD::Pg::st execute failed: ERROR: permission denied for relation...

2009-10-27 Thread blck shp
reate a user to test with, they will not get these errors? I don't think I should make everyone a superuser, right? On Mon, Oct 26, 2009 at 4:27 PM, Chris Travers wrote: > > > On Mon, Oct 26, 2009 at 1:01 PM, blck shp wrote: >> >> OK, first, can you confirm that I am

Re: [Ledger-smb-devel] DBD::Pg::st execute failed: ERROR: permission denied for relation...

2009-10-26 Thread blck shp
opcguy" (modify_user div.) BTW, I also get an auth dialog box pop up, even when I log in to the UI. That seems strange and unnecessary. Thought I'd mention it. Could help ID problem I'm facing. I'm kinda stuck. What course of action should I take? On Mon, Oct 26, 2009 at 4:2

Re: [Ledger-smb-devel] DBD::Pg::st execute failed: ERROR: permission denied for relation...

2009-10-26 Thread blck shp
plpgsql;" psql -U postgres -d ledgersmb13 -t -c "SELECT grant_all_roles('copcguy');" Is this not the correct procedure? What did I miss/not do? On Mon, Oct 26, 2009 at 2:24 PM, Chris Travers wrote: > > > On Mon, Oct 26, 2009 at 12:16 PM, blck shp wrote:

Re: [Ledger-smb-devel] DBD::Pg::st execute failed: ERROR: permission denied for relation...

2009-10-26 Thread blck shp
n Mon, Oct 26, 2009 at 1:55 PM, Chris Travers wrote: > > > On Mon, Oct 26, 2009 at 11:41 AM, blck shp wrote: >> >> Man, do I just have bad luck or what? >> > > This is in trunk, right? > > Sounds like you don't have permissions set up.  Try reading &g

[Ledger-smb-devel] DBD::Pg::st execute failed: ERROR: permission denied for relation...

2009-10-26 Thread blck shp
Man, do I just have bad luck or what? I get the following error when accessing the AR=>Add Transaction link: http://192.168.5.13/ledgersmb13/ar.pl?login=UNAME&module=ar.pl&action=add&; [Mon Oct 26 12:01:00 2009] [error] [client 192.168.1.1] DBD::Pg::st execute failed: ERROR: permission denied f

[Ledger-smb-devel] ~/INSTALL mistakes to be confirmed and changed:

2009-10-26 Thread blck shp
While working on setting up ledger 1.2.99 from trunk, I came across a few mistakes in the INSTALL text file in ledgersmb root directory. : Line 330 missing country_id: $ psql -U postgres -d mycompany -t -c "INSERT INTO entity (name, entity_class, created) VALUES ('myuser', 3, NOW()) RETURNING nam

Re: [Ledger-smb-devel] Premature end of script headers: login.pl - Am I on the right track? - Another Problem

2009-10-26 Thread blck shp
Never mind. Screwed up the command before. Oops. -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take Blac

Re: [Ledger-smb-devel] Premature end of script headers: login.pl - Am I on the right track? - Another Problem

2009-10-23 Thread blck shp
Premature, damn it! Had to install perl Template with: cpan Template I'm officially perl initiated. Man, what a PITA! OK, new problem...I can log in to the web UI as the user I created to the company I created, but when I try do do anything I get permission errors. the last little bit of the I

[Ledger-smb-devel] Premature end of script headers: login.pl - Am I on the right track?

2009-10-23 Thread blck shp
I thought I followed the instructions fairly well. I just finished up the install and config and when I go to the http://localhost/ledgersmb/ I first get what I'm assuming to be the default index.html page with a login link then refreshes a page with this message: Server error! The server encount

Re: [Ledger-smb-devel] Serialized Inventory

2009-10-21 Thread blck shp
, Oct 21, 2009 at 12:46 PM, Jeff Kowalczyk wrote: > blck shp writes: >> O.K., stupid question. How does this work? I mean, where do I >> customize? Should I make another .pl and/or .pm and mod the existing >> .pl's, etc.? Then what? How do my changes get into a release or

Re: [Ledger-smb-devel] Serialized Inventory

2009-10-21 Thread blck shp
rstood, that, like item notes, is one of those fields which does > not appear until there is an item on the invoice. > > Actually, I do understand it for itemnotes, but not for serial number, at > least in the way things currently work. > > Luke > > On Wed, 21 Oct 2009, blck shp

Re: [Ledger-smb-devel] Serialized Inventory

2009-10-21 Thread blck shp
Hmm. I don't see a "serial number" field in either the AP--Vendor Invoice ir.pl) or AR--Sales Invoice (is.pl) on my version 1.2.18. Has this been changed? On Tue, Oct 20, 2009 at 4:54 PM, Jeff Kowalczyk wrote: > blck shp writes: >> Are there plans for serial tr

Re: [Ledger-smb-devel] Serialized Inventory

2009-10-20 Thread blck shp
butter? :D Are there constraints or procedures I need to follow? What are the guidelines? Thanks for your time, Jeff. On Tue, Oct 20, 2009 at 4:54 PM, Jeff Kowalczyk wrote: > blck shp writes: >> Are there plans for serial tracking in lsmb? >> Had a possible solution, >> bu

[Ledger-smb-devel] Serialized Inventory

2009-10-19 Thread blck shp
Are there plans for serial tracking in lsmb? Had a possible solution, but didn't know if there were any GAAP guidelines to follow. I have the basic idea, but do not know the existing business logic and program flow. Is there a clear outline of modules and scripts and how they work concerning COGS,