[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