DBD::Pg::st execute failed: ERROR: permission denied for relation...

[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 for relation
entity_credit_account at LedgerSMB/Form.pm line 1788., referer:
http://192.168.1.1/ledgersmb13/menu.pl?login=UNAME&action=expanding_menu&path=bin/mozilla&js=1
[Mon Oct 26 12:01:00 2009] [error] [client 192.168.1,1] DBD::Pg::st
fetchrow_array failed: no statement executing at LedgerSMB/Form.pm
line 1790., referer:
http://192.168.1.1/ledgersmb13/menu.pl?login=cUNAME&action=expanding_menu&path=bin/mozilla&js=1
[Mon Oct 26 12:01:00 2009] [error] [client 192.168.1.1] DBD::Pg::st
execute failed: ERROR:  current transaction is aborted, commands
ignored until end of transaction block at LedgerSMB/Form.pm line
1651., referer:
http://192.168.1.1/ledgersmb13/menu.pl?login=UNAME&action=expanding_menu&path=bin/mozilla&js=1
[Mon Oct 26 12:01:00 2009] [error] [client 192.168.1.1] DBD::Pg::st
fetchrow_array failed: no statement executing at LedgerSMB/Form.pm
line 1652., referer:
http://192.168.1.1/ledgersmb13/menu.pl?login=UNAME&action=expanding_menu&path=bin/mozilla&js=1
[Mon Oct 26 12:01:00 2009] [error] [client 192.168.1.1] DBD::Pg::st
execute failed: ERROR:  current transaction is aborted, commands
ignored until end of transaction block at LedgerSMB/Form.pm line
1976., referer:
http://192.168.1.1/ledgersmb13/menu.pl?login=UNAME&action=expanding_menu&path=bin/mozilla&js=1


Surely this isn't normal behavior. Are these permission problems
associated with Roles.sql, or supposed to be fixed by it? What is
r2693 and where can I get it?:

http://sourceforge.net/mailarchive/message.php?msg_id=5ed37b140906161353h4e8eb0c7y894089d0cc215ab4%40mail.gmail.com

>Working in r2693. Please review for correctness in the LedgerSMB security
>model.

>Jeff

------------------------------------------------------------------------------
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 BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

[Chris Travers-5]

On Mon, Oct 26, 2009 at 11:41 AM, blck shp <blckshp.sp@...> 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 sql/modules/README if you haven't done this first, and preprocessing/loading Roles.sql.  If you loaded via the admin.pl, then this is unnecessary and should be complete.

If you have done this, you need to assign permissions to your user before you can proceed.

Best Wishes
Chris Travers

------------------------------------------------------------------------------
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 BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

[blck shp]

I thought it was trunk. git svn clone
https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk/
right? Please confirm.

I read the README, pre-processed the Roles.sql and executed. I did not
use the admin.pl. The user I created using the INSTALL which indicated
to run the command: createuser --no-superuser --createdb
--no-createrole -U postgres --pwprompt --encrypted UNAME, and then
INSERT commands to enter into various tables, not the admin.pl. The
user I created, does he need to be a member of all the groups? Will
this assign  permissions, or do I need to do something else? He is not
a member of any of the groups ie.  lsmb_ledgersmb13__account_all,
lsmb_ledgersmb13__account_create, lsmb_ledgersmb13__account_edit,
lsmb_ledgersmb13__all_gl, etc., etc.

I'm looking now and the admin.pl and I do not see an employee number
for the user I created (that could be a problem.)



On Mon, Oct 26, 2009 at 1:55 PM, Chris Travers <chris.travers@...> wrote:

>
>
> On Mon, Oct 26, 2009 at 11:41 AM, blck shp <blckshp.sp@...> 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
> sql/modules/README if you haven't done this first, and preprocessing/loading
> Roles.sql.  If you loaded via the admin.pl, then this is unnecessary and
> should be complete.
>
> If you have done this, you need to assign permissions to your user before
> you can proceed.
>
> Best Wishes
> Chris Travers
>
>
> ------------------------------------------------------------------------------
> 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 BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> Ledger-smb-devel mailing list
> Ledger-smb-devel@...
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
>
>

------------------------------------------------------------------------------
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 BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

[Chris Travers-5]

On Mon, Oct 26, 2009 at 12:16 PM, blck shp <blckshp.sp@...> wrote:

I thought it was trunk. git svn clone
https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk/
right? Please confirm.

I read the README, pre-processed the Roles.sql and executed. I did not
use the admin.pl. The user I created using the INSTALL which indicated
to run the command: createuser --no-superuser --createdb
--no-createrole -U postgres --pwprompt --encrypted UNAME, and then
INSERT commands to enter into various tables, not the admin.pl. The
user I created, does he need to be a member of all the groups? Will
this assign  permissions, or do I need to do something else? He is not
a member of any of the groups ie.  lsmb_ledgersmb13__account_all,
lsmb_ledgersmb13__account_create, lsmb_ledgersmb13__account_edit,
lsmb_ledgersmb13__all_gl, etc., etc.

If you did not not assign any groups and did this manually, that is your problem.

There are functions you can use to grant to all roles along with queries but I would want to know what you want first.

Best Wishes,
Chris Travers
 

I'm looking now and the admin.pl and I do not see an employee number
for the user I created (that could be a problem.)

On Mon, Oct 26, 2009 at 1:55 PM, Chris Travers <chris.travers@...> wrote:
>
>
> On Mon, Oct 26, 2009 at 11:41 AM, blck shp <blckshp.sp@...> 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
> sql/modules/README if you haven't done this first, and preprocessing/loading
> Roles.sql.  If you loaded via the admin.pl, then this is unnecessary and
> should be complete.
>
> If you have done this, you need to assign permissions to your user before
> you can proceed.
>
> Best Wishes
> Chris Travers
>
>

> ------------------------------------------------------------------------------
> 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 BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> Ledger-smb-devel mailing list
> Ledger-smb-devel@...
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
>
>

------------------------------------------------------------------------------
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 BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

------------------------------------------------------------------------------
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 BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

[blck shp]

OK, first, can you confirm that I am using trunk? The VERSION says it is 1.2.99.

Next, I cannot add a user from admin.pl: "Error! Required input not provided"

I cannot edit data for user I created manually. I try to enter a
password or employee number: "Error! Error from Function: ERROR:
cannot find user "

Nor does it appear user is apart of a group or can be saved to a group.

I would like to start developing and contributing to the project. I'm
a little confused as to where I went wrong. I'm pretty sure I followed
INSTALL as it was laid out. This is basically what I did not including
any dependencies or modules not loaded:

git svn clone https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk/

Created DB:
createdb ledgersmb13
createlang plpgsql ledgersmb13
psql ledgersmb13 < /usr/share/ledgersmb13/sql/Pg-database.sql

Loaded "module" in order:
psql -U ledgersmb -d ledgersmb13 -f
/usr/share/ledgersmb13/sql/modules/Drafts.sql
psql -U ledgersmb -d ledgersmb13 -f /usr/share/ledgersmb13/sql/modules/chart.sql
psql -U ledgersmb -d ledgersmb13 -f
/usr/share/ledgersmb13/sql/modules/Account.sql
psql -U ledgersmb -d ledgersmb13 -f
/usr/share/ledgersmb13/sql/modules/Session.sql
psql -U ledgersmb -d ledgersmb13 -f
/usr/share/ledgersmb13/sql/modules/Business_type.sql
psql -U ledgersmb -d ledgersmb13 -f
/usr/share/ledgersmb13/sql/modules/Location.sql
psql -U ledgersmb -d ledgersmb13 -f
/usr/share/ledgersmb13/sql/modules/Company.sql
psql -U ledgersmb -d ledgersmb13 -f
/usr/share/ledgersmb13/sql/modules/Customer.sql
psql -U ledgersmb -d ledgersmb13 -f /usr/share/ledgersmb13/sql/modules/Date.sql
psql -U ledgersmb -d ledgersmb13 -f
/usr/share/ledgersmb13/sql/modules/Defaults.sql
psql -U ledgersmb -d ledgersmb13 -f
/usr/share/ledgersmb13/sql/modules/Settings.sql
psql -U ledgersmb -d ledgersmb13 -f
/usr/share/ledgersmb13/sql/modules/Employee.sql
psql -U ledgersmb -d ledgersmb13 -f
/usr/share/ledgersmb13/sql/modules/Entity.sql
psql -U ledgersmb -d ledgersmb13 -f
/usr/share/ledgersmb13/sql/modules/Payment.sql
psql -U ledgersmb -d ledgersmb13 -f
/usr/share/ledgersmb13/sql/modules/Person.sql
psql -U ledgersmb -d ledgersmb13 -f
/usr/share/ledgersmb13/sql/modules/Report.sql
psql -U ledgersmb -d ledgersmb13 -f
/usr/share/ledgersmb13/sql/modules/Voucher.sql
psql -U ledgersmb -d ledgersmb13 -f /usr/share/ledgersmb13/sql/modules/admin.sql
psql -U ledgersmb -d ledgersmb13 -f
/usr/share/ledgersmb13/sql/modules/Reconciliation.sql

Loaded COA:
psql -U ledgersmb -d ledgersmb13 -f
/usr/share/ledgersmb13/sql/coa/us/chart/General.sql

Replaced with DB name:
sed -e 's/<?lsmb dbname ?>/ledgersmb13/g' Roles.sql > ledgersmb13_roles.sql

Ran:
psql -U ledgersmb -d ledgersmb13 -f
/usr/share/ledgersmb13/sql/modules/ledgersmb13_roles.sql

Created user:
createuser --no-superuser --createdb --no-createrole -U postgres
--pwprompt --encrypted copcguy

Added to tables and set role:
psql -U postgres -d ledgersmb13 -t -c "INSERT INTO entity (name,
entity_class, created, country_id) VALUES ('copcguy', 3, NOW(), 232)
RETURNING name, entity_class, created, country_id;"
psql -U postgres -d ledgersmb13 -t -c "INSERT INTO person (entity_id,
first_name, last_name, created) VALUES (1, 'Nick', 'Burns', NOW())
RETURNING entity_id, first_name, last_name, created;"
psql -U postgres -d ledgersmb13 -t -c "INSERT INTO entity_employee
(manager_id, entity_id, startdate, role) VALUES (1, 1, NOW(),
'copcguy') RETURNING manager_id, entity_id, startdate, role;"
psql -U postgres -d ledgersmb13 -t -c "INSERT INTO users (username,
entity_id) VALUES ('copcguy', 1) RETURNING username, entity_id;"
psql -U postgres -d ledgersmb13 -t -c "INSERT INTO user_preference
(id) VALUES (1) RETURNING id;"
psql -U postgres -d ledgersmb13 -t -c "CREATE OR REPLACE FUNCTION
grant_all_roles(in_login varchar) RETURNS INT as \$\$ DECLARE
role_info RECORD; BEGIN FOR role_info IN select * from pg_roles WHERE
rolname LIKE 'lsmb%' LOOP EXECUTE 'GRANT ' || role_info.rolname || '
TO ' || in_login; END LOOP; RETURN 1; END; \$\$ language 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 <chris.travers@...> wrote:

>
>
> On Mon, Oct 26, 2009 at 12:16 PM, blck shp <blckshp.sp@...> wrote:
>>
>> I thought it was trunk. git svn clone
>> https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk/
>> right? Please confirm.
>>
>> I read the README, pre-processed the Roles.sql and executed. I did not
>> use the admin.pl. The user I created using the INSTALL which indicated
>> to run the command: createuser --no-superuser --createdb
>> --no-createrole -U postgres --pwprompt --encrypted UNAME, and then
>> INSERT commands to enter into various tables, not the admin.pl. The
>> user I created, does he need to be a member of all the groups? Will
>> this assign  permissions, or do I need to do something else? He is not
>> a member of any of the groups ie.  lsmb_ledgersmb13__account_all,
>> lsmb_ledgersmb13__account_create, lsmb_ledgersmb13__account_edit,
>> lsmb_ledgersmb13__all_gl, etc., etc.
>
>
> If you did not not assign any groups and did this manually, that is your
> problem.
>
> There are functions you can use to grant to all roles along with queries but
> I would want to know what you want first.
>
> Best Wishes,
> Chris Travers
>
>>
>> I'm looking now and the admin.pl and I do not see an employee number
>> for the user I created (that could be a problem.)
>>
>>
>>
>> On Mon, Oct 26, 2009 at 1:55 PM, Chris Travers <chris.travers@...>
>> wrote:
>> >
>> >
>> > On Mon, Oct 26, 2009 at 11:41 AM, blck shp <blckshp.sp@...> 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
>> > sql/modules/README if you haven't done this first, and
>> > preprocessing/loading
>> > Roles.sql.  If you loaded via the admin.pl, then this is unnecessary and
>> > should be complete.
>> >
>> > If you have done this, you need to assign permissions to your user
>> > before
>> > you can proceed.
>> >
>> > Best Wishes
>> > Chris Travers
>> >
>> >
>> >
>> > ------------------------------------------------------------------------------
>> > 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 BlackBerry mobile applications to market and
>> > stay
>> > ahead of the curve. Join us from November 9 - 12, 2009. Register now!
>> > http://p.sf.net/sfu/devconference
>> > _______________________________________________
>> > Ledger-smb-devel mailing list
>> > Ledger-smb-devel@...
>> > https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
>> >
>> >
>>
>>
>> ------------------------------------------------------------------------------
>> 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 BlackBerry mobile applications to market and stay
>> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
>> http://p.sf.net/sfu/devconference
>> _______________________________________________
>> Ledger-smb-devel mailing list
>> Ledger-smb-devel@...
>> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
>
>
> ------------------------------------------------------------------------------
> 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 BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> Ledger-smb-devel mailing list
> Ledger-smb-devel@...
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
>
>

------------------------------------------------------------------------------
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 BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

[Chris Travers-5]

On Mon, Oct 26, 2009 at 1:01 PM, blck shp <blckshp.sp@...> wrote:

OK, first, can you confirm that I am using trunk? The VERSION says it is 1.2.99.

That's trunk.
 

Next, I cannot add a user from admin.pl: "Error! Required input not provided"

What boxe are you filling in?

Best Wishes,
Chris Travers

------------------------------------------------------------------------------
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 BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

[blck shp]

>Next, I cannot add a user from admin.pl: "Error! Required input not provided"
This error is from
http://192.168.1.1/ledgersmb13/admin.pl?action=new_user after filling
out any or all input boxes and executing "Save User"


>I cannot edit data for user I created manually. I try to enter a
>password or employee number: "Error! Error from Function: ERROR:
>cannot find user "
For this error, I click on the user link
http://192.168.1.1/ledgersmb13/admin.pl?action=edit_user&user_id=1 and
add text to any, all or no input boxes on "Editing User copcguy"
(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:27 PM, Chris Travers <chris.travers@...> wrote:

>
>
> On Mon, Oct 26, 2009 at 1:01 PM, blck shp <blckshp.sp@...> wrote:
>>
>> OK, first, can you confirm that I am using trunk? The VERSION says it is
>> 1.2.99.
>
> That's trunk.
>
>>
>> Next, I cannot add a user from admin.pl: "Error! Required input not
>> provided"
>
> What boxe are you filling in?
>
> Best Wishes,
> Chris Travers
>
>
> ------------------------------------------------------------------------------
> 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 BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> Ledger-smb-devel mailing list
> Ledger-smb-devel@...
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
>
>

------------------------------------------------------------------------------
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 BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

[blck shp]

OK, an update...

I think there are two separate problems. I first was getting a
permission error when accessing the AR=>Add Transaction link:
http://192.168.1.1/ledgersmb13/ar.pl?login=UNAME&module=ar.pl&action=add&.
After I changed my user to a postgres superuser, I was able to access
it without error, but I still have problems with the admin.pl. Is the
admin.pl broken/ not working properly?

BTW, my user was apart of the groups lsmb_ledgersmb13__% all along. It
just wasn't showing in admin.pl that way.

So, the question is, what changes need to be made so that if I create
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 <chris.travers@...> wrote:

>
>
> On Mon, Oct 26, 2009 at 1:01 PM, blck shp <blckshp.sp@...> wrote:
>>
>> OK, first, can you confirm that I am using trunk? The VERSION says it is
>> 1.2.99.
>
> That's trunk.
>
>>
>> Next, I cannot add a user from admin.pl: "Error! Required input not
>> provided"
>
> What boxe are you filling in?
>
> Best Wishes,
> Chris Travers
>
>
> ------------------------------------------------------------------------------
> 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 BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> Ledger-smb-devel mailing list
> Ledger-smb-devel@...
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
>
>

------------------------------------------------------------------------------
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 BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

[blck shp]

And to add...

This is my apache log for the admin.pl errors:

DBD::Pg::st execute failed: ERROR:  cannot find user <NULL> at
LedgerSMB.pm line 605., referer:
http://192.168.1.1/ledgersmb13/admin.pl?action=edit_user&user_id=1
[Tue Oct 27 09:24:54 2009] [error] [client 192.168.1.1] Logging SQL
State P0001, error 7, string ERROR:  cannot find user <NULL>, referer:
http://192.168.1.1/ledgersmb13/admin.pl?action=edit_user&user_id=1
[Tue Oct 27 09:24:54 2009] [error] [client 192.168.1.1] Issuing
rollback() for database handle being DESTROY'd without explicit
disconnect() at /usr/share/ledgersmb13/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 <chris.travers@...> wrote:

>
>
> On Mon, Oct 26, 2009 at 1:01 PM, blck shp <blckshp.sp@...> wrote:
>>
>> OK, first, can you confirm that I am using trunk? The VERSION says it is
>> 1.2.99.
>
> That's trunk.
>
>>
>> Next, I cannot add a user from admin.pl: "Error! Required input not
>> provided"
>
> What boxe are you filling in?
>
> Best Wishes,
> Chris Travers
>
>
> ------------------------------------------------------------------------------
> 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 BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> Ledger-smb-devel mailing list
> Ledger-smb-devel@...
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
>
>

------------------------------------------------------------------------------
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 BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

[Chris Travers-5]

On Tue, Oct 27, 2009 at 6:54 AM, blck shp <blckshp.sp@...> wrote:

OK, an update...

What version of PostgreSQL are you using?

Best Wishes,
Chris Travers

------------------------------------------------------------------------------
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 BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

[blck shp]

$> postgres --version
postgres (PostgreSQL) 8.3.8




On Tue, Oct 27, 2009 at 11:37 AM, Chris Travers <chris.travers@...> wrote:

>
>
> On Tue, Oct 27, 2009 at 6:54 AM, blck shp <blckshp.sp@...> wrote:
>>
>> OK, an update...
>
> What version of PostgreSQL are you using?
>
> Best Wishes,
> Chris Travers
>
>
> ------------------------------------------------------------------------------
> 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 BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> Ledger-smb-devel mailing list
> Ledger-smb-devel@...
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
>
>

------------------------------------------------------------------------------
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 BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

[Chris Travers-5]

On Tue, Oct 27, 2009 at 9:59 AM, blck shp <blckshp.sp@...> wrote:

$> postgres --version
postgres (PostgreSQL) 8.3.8

Hmmmmmm....  I am thinking about this.  Users should not be superuser because one can't enforce permissions in those cases.

If you try to access using the normal user, you still get the same errors?

It sounds to me like you need to grant roles.    Or maybe there is some odd issue with 8.3 I hadn't seen before.  I am going to try upgrading one of my dev instances and see what happens.  Stay tuned.

Best Wishes,
Chris Travers
 

On Tue, Oct 27, 2009 at 11:37 AM, Chris Travers <chris.travers@...> wrote:
>
>
> On Tue, Oct 27, 2009 at 6:54 AM, blck shp <blckshp.sp@...> wrote:
>>
>> OK, an update...
>
> What version of PostgreSQL are you using?
>
> Best Wishes,
> Chris Travers
>
>

> ------------------------------------------------------------------------------
> 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 BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> Ledger-smb-devel mailing list
> Ledger-smb-devel@...
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
>
>

------------------------------------------------------------------------------
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 BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

------------------------------------------------------------------------------
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 BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

[blck shp]

> If you try to access using the normal user, you still get the same errors?

Yes. As superuser, I do not get permission errors pulling up AR=>Add
Transaction link:
http://192.168.1.1/ledgersmb13/ar.pl?login=UNAME&module=ar.pl&action=add&.

As a non-superuser, I still get permission errors.

I also still get the errors like: "ERROR: cannot find user " from
admin.pl no matter if I'm superuser or not.

IDK what more roles to grant to this user:

Role name | Superuser | Create role | Create DB | Connections | Member of

 copcguy  |  no        | no          | yes       | no limit    |
{lsmb_ledgersmb13__contact_read,lsmb_ledgersmb13__contact_create,lsmb_ledgersmb13__contact_edit,lsmb_ledgersmb13__contact_all_rights,lsmb_ledgersmb13__batch_create,lsm
b_ledgersmb13__batch_post,lsmb_ledgersmb13__ar_transaction_create,lsmb_ledgersmb13__ar_transaction_create_voucher,lsmb_ledgersmb13__ar_invoice_create,lsmb_ledgersmb13__ar_invoice_create_voucher,lsmb_ledgersmb13__ar_transaction_list,lsmb_ledgersmb13__ar_voucher_all,lsmb_
ledgersmb13__ar_transaction_all,lsmb_ledgersmb13__sales_order_create,lsmb_ledgersmb13__sales_quotation_create,lsmb_ledgersmb13__sales_order_list,lsmb_ledgersmb13__sales_quotation_list,lsmb_ledgersmb13__ar_all,lsmb_ledgersmb13__ap_transaction_create,lsmb_ledgersmb13__ap_
transaction_create_voucher,lsmb_ledgersmb13__ap_invoice_create,lsmb_ledgersmb13__ap_invoice_create_voucher,lsmb_ledgersmb13__ap_transaction_list,lsmb_ledgersmb13__ap_all_vouchers,lsmb_ledgersmb13__ap_all_transactions,lsmb_ledgersmb13__purchase_order_create,lsmb_ledgersm
b13__rfq_create,lsmb_ledgersmb13__purchase_order_list,lsmb_ledgersmb13__rfq_list,lsmb_ledgersmb13__ap_all,lsmb_ledgersmb13__pos_enter,lsmb_ledgersmb13__close_till,lsmb_ledgersmb13__list_all_open,lsmb_ledgersmb13__pos_cashier,lsmb_ledgersmb13__pos_all,lsmb_ledgersmb13__r
econciliation_enter,lsmb_ledgersmb13__reconciliation_approve,lsmb_ledgersmb13__all_reconciliation_enter,lsmb_ledgersmb13__payment_process,lsmb_ledgersmb13__receipt_process,lsmb_ledgersmb13__cash_all,lsmb_ledgersmb13__part_create,lsmb_ledgersmb13__part_edit,lsmb_ledgersm
b13__inventory_reports,lsmb_ledgersmb13__pricegroup_create,lsmb_ledgersmb13__pricegroup_edit,lsmb_ledgersmb13__assembly_stock,lsmb_ledgersmb13__inventory_ship,lsmb_ledgersmb13__inventory_receive,lsmb_ledgersmb13__inventory_transfer,lsmb_ledgersmb13__warehouse_create,lsm
b_ledgersmb13__warehouse_edit,lsmb_ledgersmb13__inventory_all,lsmb_ledgersmb13__gl_transaction_create,lsmb_ledgersmb13__gl_voucher_create,lsmb_ledgersmb13__gl_reports,lsmb_ledgersmb13__yearend_run,lsmb_ledgersmb13__batch_list,lsmb_ledgersmb13__all_gl,lsmb_ledgersmb13__p
roject_create,lsmb_ledgersmb13__project_edit,lsmb_ledgersmb13__project_timecard_add,lsmb_ledgersmb13__project_timecard_list,lsmb_ledgersmb13__orders_generate,lsmb_ledgersmb13__project_order_generate,lsmb_ledgersmb13__orders_sales_to_purchase,lsmb_ledgersmb13__orders_pur
chase_consolidate,lsmb_ledgersmb13__orders_sales_consolidate,lsmb_ledgersmb13__orders_manage,lsmb_ledgersmb13__financial_reports,lsmb_ledgersmb13__print_jobs_list,lsmb_ledgersmb13__print_jobs,lsmb_ledgersmb13__system_settings_list,lsmb_ledgersmb13__system_settings_chang
e,lsmb_ledgersmb13__taxes_set,lsmb_ledgersmb13__account_create,lsmb_ledgersmb13__account_edit,lsmb_ledgersmb13__gifi_create,lsmb_ledgersmb13__gifi_edit,lsmb_ledgersmb13__account_all,lsmb_ledgersmb13__department_create,lsmb_ledgersmb13__department_edit,lsmb_ledgersmb13__
department_all,lsmb_ledgersmb13__business_type_create,lsmb_ledgersmb13__business_type_edit,lsmb_ledgersmb13__business_type_all,lsmb_ledgersmb13__sic_create,lsmb_ledgersmb13__sic_edit,lsmb_ledgersmb13__sic_all,lsmb_ledgersmb13__tax_form_save,lsmb_ledgersmb13__template_ed
it,lsmb_ledgersmb13__system_admin,lsmb_ledgersmb13__language_create,lsmb_ledgersmb13__language_edit,lsmb_ledgersmb13__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 <chris.travers@...> wrote:

>
>
> On Tue, Oct 27, 2009 at 9:59 AM, blck shp <blckshp.sp@...> wrote:
>>
>> $> postgres --version
>> postgres (PostgreSQL) 8.3.8
>>
>
> Hmmmmmm....  I am thinking about this.  Users should not be superuser
> because one can't enforce permissions in those cases.
>
> If you try to access using the normal user, you still get the same errors?
>
> It sounds to me like you need to grant roles.    Or maybe there is some odd
> issue with 8.3 I hadn't seen before.  I am going to try upgrading one of my
> dev instances and see what happens.  Stay tuned.
>
> Best Wishes,
> Chris Travers
>
>>
>>
>> On Tue, Oct 27, 2009 at 11:37 AM, Chris Travers <chris.travers@...>
>> wrote:
>> >
>> >
>> > On Tue, Oct 27, 2009 at 6:54 AM, blck shp <blckshp.sp@...> wrote:
>> >>
>> >> OK, an update...
>> >
>> > What version of PostgreSQL are you using?
>> >
>> > Best Wishes,
>> > Chris Travers
>> >
>> >
>> >
>> > ------------------------------------------------------------------------------
>> > 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 BlackBerry mobile applications to market and
>> > stay
>> > ahead of the curve. Join us from November 9 - 12, 2009. Register now!
>> > http://p.sf.net/sfu/devconference
>> > _______________________________________________
>> > Ledger-smb-devel mailing list
>> > Ledger-smb-devel@...
>> > https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
>> >
>> >
>>
>>
>> ------------------------------------------------------------------------------
>> 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 BlackBerry mobile applications to market and stay
>> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
>> http://p.sf.net/sfu/devconference
>> _______________________________________________
>> Ledger-smb-devel mailing list
>> Ledger-smb-devel@...
>> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
>
>
> ------------------------------------------------------------------------------
> 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 BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> Ledger-smb-devel mailing list
> Ledger-smb-devel@...
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
>
>

------------------------------------------------------------------------------
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 BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

[Chris Travers-5]

On Tue, Oct 27, 2009 at 10:46 AM, blck shp <blckshp.sp@...> wrote:

> If you try to access using the normal user, you still get the same errors?

Yes. As superuser, I do not get permission errors pulling up AR=>Add

Transaction link:
http://192.168.1.1/ledgersmb13/ar.pl?login=UNAME&module=ar.pl&action=add&.

As a non-superuser, I still get permission errors.

I also still get the errors like: "ERROR: cannot find user " from
admin.pl no matter if I'm superuser or not.

IDK what more roles to grant to this user:

Ok.  And the errors are still tied to the relations?  Which relations specifically are triggered?

Can you create a customer or vendor?

Best Wishes,
Chris Travers

------------------------------------------------------------------------------
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 BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

[blck shp]

> Ok.  And the errors are still tied to the relations?  Which relations
> specifically are triggered?

>From my apache logs. when I try adding a customer, it shows it is
"DBD::Pg::st execute failed: ERROR:  permission denied for relation
entity_credit_account."


>Can you 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 <chris.travers@...> wrote:

>
>
> On Tue, Oct 27, 2009 at 10:46 AM, blck shp <blckshp.sp@...> wrote:
>>
>> > If you try to access using the normal user, you still get the same
>> > errors?
>>
>> Yes. As superuser, I do not get permission errors pulling up AR=>Add
>> Transaction link:
>> http://192.168.1.1/ledgersmb13/ar.pl?login=UNAME&module=ar.pl&action=add&.
>>
>> As a non-superuser, I still get permission errors.
>>
>> I also still get the errors like: "ERROR: cannot find user " from
>> admin.pl no matter if I'm superuser or not.
>>
>> IDK what more roles to grant to this user:
>
> Ok.  And the errors are still tied to the relations?  Which relations
> specifically are triggered?
>
> Can you create a customer or vendor?
>
> Best Wishes,
> Chris Travers
>
>
> ------------------------------------------------------------------------------
> 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 BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> Ledger-smb-devel mailing list
> Ledger-smb-devel@...
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
>
>

------------------------------------------------------------------------------
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 BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

[Chris Travers-5]

On Tue, Oct 27, 2009 at 11:29 AM, blck shp <blckshp.sp@...> wrote:

> Ok.  And the errors are still tied to the relations?  Which relations
> specifically are triggered?

>From my apache logs. when I try adding a customer, it shows it is

"DBD::Pg::st execute failed: ERROR:  permission denied for relation

entity_credit_account."

Ok/  What's the name of the db you are connected to?

Best Wishes,
Chris Travers

------------------------------------------------------------------------------
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 BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

[blck shp]

I named it ledgersmb13.





On Tue, Oct 27, 2009 at 1:35 PM, Chris Travers <chris.travers@...> wrote:

>
>
> On Tue, Oct 27, 2009 at 11:29 AM, blck shp <blckshp.sp@...> wrote:
>>
>> > Ok.  And the errors are still tied to the relations?  Which relations
>> > specifically are triggered?
>>
>> >From my apache logs. when I try adding a customer, it shows it is
>> "DBD::Pg::st execute failed: ERROR:  permission denied for relation
>> entity_credit_account."
>
> Ok/  What's the name of the db you are connected to?
>
> Best Wishes,
> Chris Travers
>
> ------------------------------------------------------------------------------
> 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 BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> Ledger-smb-devel mailing list
> Ledger-smb-devel@...
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
>
>

------------------------------------------------------------------------------
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 BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

[Chris Travers-5]

On Tue, Oct 27, 2009 at 11:40 AM, blck shp <blckshp.sp@...> wrote:

I named it ledgersmb13.

I wonder if somehow the permissions didn't get applied to the tables.

Best Wishes,
Chris Travers

------------------------------------------------------------------------------
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 BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

[blck shp]

Hmmm...OK.

Looking back when I applied the pre-processed roles sql:
su - postgres -c "psql -U ledgersmb -d ledgersmb13 -f
/usr/share/ledgersmb13/sql/modules/ledgersmb13_roles.sql"


I now see several of the following:

psql:/usr/share/ledgersmb13/sql/modules/ledgersmb13_roles.sql:10:
ERROR:  relation "entity_craccount_edit" does not exist
psql:/usr/share/ledgersmb13/sql/modules/ledgersmb13_roles.sql:59:
ERROR:  relation "entity_craccount_edit" does not exist
psql:/usr/share/ledgersmb13/sql/modules/ledgersmb13_roles.sql:60:
ERROR:  relation "entity_craccount_edit_id_seq" does not exist
psql:/usr/share/ledgersmb13/sql/modules/ledgersmb13_roles.sql:108:
ERROR:  relation "entity_craccount_edit" does not exist
psql:/usr/share/ledgersmb13/sql/modules/ledgersmb13_roles.sql:692:
ERROR:  relation "entity_craccount_edit" does not exist
psql:/usr/share/ledgersmb13/sql/modules/ledgersmb13_roles.sql:705:
ERROR:  relation "entity_craccount_edit" does not exist
psql:/usr/share/ledgersmb13/sql/modules/ledgersmb13_roles.sql:1083:
ERROR:  relation "chart_id_seq" does not exist


Are the above reason for phenomenon I'm seeing?




On Tue, Oct 27, 2009 at 1:53 PM, Chris Travers <chris.travers@...> wrote:

>
>
> On Tue, Oct 27, 2009 at 11:40 AM, blck shp <blckshp.sp@...> wrote:
>>
>> I named it ledgersmb13.
>>
>
> I wonder if somehow the permissions didn't get applied to the tables.
>
> Best Wishes,
> Chris Travers
>
>
> ------------------------------------------------------------------------------
> 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 BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> Ledger-smb-devel mailing list
> Ledger-smb-devel@...
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
>
>

------------------------------------------------------------------------------
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 BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

[Chris Travers-5]

On Tue, Oct 27, 2009 at 12:11 PM, blck shp <blckshp.sp@...> wrote:

Hmmm...OK.

Looking back when I applied the pre-processed roles sql:
su - postgres -c "psql -U ledgersmb -d ledgersmb13 -f

/usr/share/ledgersmb13/sql/modules/ledgersmb13_roles.sql"

I now see several of the following:

psql:/usr/share/ledgersmb13/sql/modules/ledgersmb13_roles.sql:10:
ERROR:  relation "entity_craccount_edit" does not exist

Crap.................

Ok, fixing this :-).

Committed a fix.  (Why this is pre-beta still).

Best Wishes,
Chris Travers

------------------------------------------------------------------------------
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 BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel