Thanks you. I don't mind booger hunting. :D
Speaking of, tried to apply the updated preprocessed Roles.sql and got this:
psql:/usr/share/ledgersmb13/sql/modules/ledgersmb13_roles.sql:1086:
ERROR: relation "acount_heading_id_seq" does not exist
psql:/usr/share/ledgersmb13/sql/modules/ledgersmb13_
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 ledgersmb13 -f
> /usr/share/ledgersmb13/sql/modules/ledgersmb13_roles.sql"
>
>
> I now see several of the following:
>
> psql:/usr/s
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: relat
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 Wishes,
Chris Travers
--
Come build with us! The BlackBerry(R) De
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?
>>
>> >From my apache logs. when I try adding a
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?
>
> >From my apache logs. when I try adding a customer, it shows it is
> "DBD::Pg::st execute failed: ERROR: permission denied for relation
On Tue, Oct 27, 2009 at 11:20 AM, shaker Khzym wrote:
>
> Dear Chris,
>I have many samples , this is one from them.
>Thank you so much for your quick replay.
>
>
Ok. Can you also send the info on the relevant part from the invoice?
Something seems rather screwed up with that part.
> 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 vendo
On Tue, Oct 27, 2009 at 10:46 AM, blck shp 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=ad
> 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 als
On Tue, Oct 27, 2009 at 9:59 AM, blck shp wrote:
> $> postgres --version
> postgres (PostgreSQL) 8.3.8
>
>
Hmm 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 sam
$> 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?
>
> Best Wishes,
> Chris Travers
>
>
> -
On Tue, Oct 27, 2009 at 9:10 AM, wrote:
> Dear All,
>I need to discuss a point that I face now.
>Some Sales invoices have a lot of records in the acc_trans. These
> records are not belong to it but share the same trans_id.
>If I repost it, everything will be corrected.
>
On Tue, Oct 27, 2009 at 6:54 AM, blck shp 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 on
Dear All,
I need to discuss a point that I face now.
Some Sales invoices have a lot of records in the acc_trans. These
records are not belong to it but share the same trans_id.
If I repost it, everything will be corrected.
I don't know the reason until now, any help
And to add...
This is my apache log for the admin.pl errors:
DBD::Pg::st execute failed: ERROR: cannot find user 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
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
17 matches
Mail list logo
