[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

weird problem



so, im still having this weird problem when i try to do any additions to
the Northstar db via the webinterface. i continuously get:

The following error has occured during your request.
You do not have permission to execute this function
Please contact the site administrator for more details.
NorthStar:NorthStar.cgi:176 

Below is my postgres debug... Does anyone have any ideas?

Thanks,
Troy




/usr/local/bin/postmaster: ServerLoop:          handling reading 5
/usr/local/bin/postmaster: ServerLoop:          handling reading 5
/usr/local/bin/postmaster: ServerLoop:          handling writing 5
/usr/local/bin/postmaster: BackendStartup: pid 18853 user northstar db
northstar socket 5
/usr/local/bin/postmaster child[18853]: starting with (postgres -d3
-v131072 -p northstar )
FindExec: found "/usr/local/bin/postgres" using argv[0]
DEBUG:  connection: host=127.0.0.1 user=northstar database=northstar
DEBUG:  InitPostgres
DEBUG:  StartTransactionCommand
DEBUG:  query: SELECT id,realname FROM users WHERE username ~* '^admin$'
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0
:into <> :isPortal false :isBinary false :isTemp false :hasAggs false
:hasSubLinks false :rtable ({ RTE :relname users :relid 20909  :subquery
<> :alias <> :eref { ATTR :relname users :attrs ( "id"   "username"
"passwd"   "realname"   "enabled"   "perm_addnet"   "perm_updnet"
"perm_delnet"   "perm_addaddr"   "perm_updaddr"   "perm_deladdr"
"perm_adddev"   "perm_upddev"   "perm_deldev"   "perm_adduser"
"perm_upduser"   "perm_deluser"   "perm_addowner"   "perm_updowner"
"perm_delowner"   "perm_addloc"   "perm_updloc"   "perm_delloc" )} :inh
true :inFromCl true :checkForRead true :checkForWrite false :checkAsUser
0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR
:typeOid 16  :opType op :oper { OPER :opno 1232 :opid 0 :opresulttype 16 }
:args ({ VAR :varno 1 :varattno 2 :vartype 1043 :vartypmod 36
:varlevelsup 0 :varnoold 1 :varoattno 2} { CONST :consttype 25 :constlen
-1 :constbyval false :constisnull false :constvalue  11 [ 11 0 0 0 94 97
100 109 105 110 36 ] })}} :rowMarks () :targetList ({ TARGETENTRY :resdom
{ RESDOM :resno 1 :restype 23 :restypmod -1 :resname id :reskey 0
:reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1
:varattno 1 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1
:varoattno 1}} { TARGETENTRY :resdom { RESDOM :resno 2 :restype 1043
:restypmod 132 :resname realname :reskey 0 :reskeyop 0 :ressortgroupref 0
:resjunk false } :expr { VAR :varno 1 :varattno 4 :vartype 1043 :vartypmod
132  :varlevelsup 0 :varnoold 1 :varoattno 4}}) :groupClause <>
:havingQual <> :distinctClause <> :sortClause <> :limitOffset <>
:limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  ProcessQuery
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: SELECT perm_addloc FROM users WHERE id = '0'
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0
:into <> :isPortal false :isBinary false :isTemp false :hasAggs false
:hasSubLinks false :rtable ({ RTE :relname users :relid 20909  :subquery
<> :alias <> :eref { ATTR :relname users :attrs ( "id"   "username"
"passwd"   "realname"   "enabled"   "perm_addnet"   "perm_updnet"
"perm_delnet"   "perm_addaddr"   "perm_updaddr"   "perm_deladdr"
"perm_adddev"   "perm_upddev"   "perm_deldev"   "perm_adduser"
"perm_upduser"   "perm_deluser"   "perm_addowner"   "perm_updowner"
"perm_delowner"   "perm_addloc"   "perm_updloc"   "perm_delloc" )} :inh
true :inFromCl true :checkForRead true :checkForWrite false :checkAsUser
0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR
:typeOid 16  :opType op :oper { OPER :opno 96 :opid 0 :opresulttype 16 }
:args ({ VAR :varno 1 :varattno 1 :vartype 23 :vartypmod -1  :varlevelsup
0 :varnoold 1 :varoattno 1} { CONST :consttype 23 :constlen 4 :constbyval
true :constisnull false :constvalue  4 [ 0 0 0 0 ] })}} :rowMarks ()
:targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 16
:restypmod -1 :resname perm_addloc :reskey 0 :reskeyop 0 :ressortgroupref
0 :resjunk false } :expr { VAR :varno 1 :varattno 21 :vartype 16
:vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 21}}) :groupClause <>
:havingQual <> :distinctClause <> :sortClause <> :limitOffset <>
:limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  ProcessQuery
DEBUG:  CommitTransactionCommand
DEBUG:  proc_exit(0)
DEBUG:  shmem_exit(0)
DEBUG:  exit(0)
/usr/local/bin/postmaster: reaping dead processes...
/usr/local/bin/postmaster: CleanupProc: pid 18853 exited with status 0