Re: weird problem

[Troy Corbin <troyc@titan.communitech.net>]

here is the requested info, pre and post-change:

northstar=# SELECT * FROM users WHERE id = '0';
 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 
----+----------+--------+---------------+---------+-------------+-------------+-------------+--------------+--------------+--------------+-------------+-------------+-------------+--------------+--------------+--------------+---------------+---------------+---------------+-------------+-------------+-------------
  0 | admin    | UNUSED | Administrator | t       | t           | t
| t           | t            | t            | t            | t           |
t           | t           | t            | t            | t            | t
| t             | t             | t           | t           | t
(1 row)

northstar=# UPDATE users SET perm_addloc = 't' WHERE id = '0';
UPDATE 1
northstar=# SELECT * FROM users WHERE id = '0';
 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 
----+----------+--------+---------------+---------+-------------+-------------+-------------+--------------+--------------+--------------+-------------+-------------+-------------+--------------+--------------+--------------+---------------+---------------+---------------+-------------+-------------+-------------
  0 | admin    | UNUSED | Administrator | t       | t           | t
| t           | t            | t            | t            | t           |
t           | t           | t            | t            | t            | t
| t             | t             | t           | t           | t
(1 row)


darn that didnt post right at all!

even after the change, i get the same problem.

You do not have permission to execute this function
Please contact the site administrator for more details.
NorthStar:NorthStar.cgi:176 

thanks,
troy


On Mon, 19 Nov 2001, Hitesh Patel wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> On Monday 19 November 2001 18:44 pm, Troy Corbin wrote:
> > 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
> >
> 
> Ok.. well it looks like the permissions for  admin user got messed up 
> somehow.. if you can do a "SELECT * FROM users WHERE id = '0'" in psql for me 
> and send the results we can see for sure.  Doing this:
> 
> UPDATE users SET perm_addloc = 't' WHERE id = '0';
> 
> should fix your specific problem.  Let us know if this fixes the problem or 
> not.
> 
> - -- 
> Hitesh Patel
> hitesh@presys.com
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.0.6 (GNU/Linux)
> Comment: For info see http://www.gnupg.org
> 
> iD8DBQE7+dPFCws8KqPtd2URApxOAKCAjBs2ENJ3GT+yAec13Nv6KxA1agCeMUVq
> Is52jjbPAf89xhLThwFyEuQ=
> =y5p7
> -----END PGP SIGNATURE-----
>