Well, I attempted it because http://www.fossil-scm.org/index.html/doc/tip/www/custom_ticket.wiki suggested it was possible.
"it might be good to automatically scoop up the user's email and put it here" On Wed, Oct 1, 2014 at 12:02 AM, Andreas Kupries <andre...@activestate.com> wrote: > On Tue, Sep 30, 2014 at 11:23 AM, Stephan Beal <sgb...@googlemail.com> > wrote: > > On Tue, Sep 30, 2014 at 8:14 PM, Gaurav M. Bhandarkar > > <gaurav.a...@gmail.com> wrote: > >> > >> I get following error while creating new ticket : > >> ERROR: SQL error: access to table "user" is restricted > >> error code 23: access to user.info is prohibited > >> > >> How can I resolve this? > > > > > > i can't answer that one, but i suspect that Joe M. will be able to. > > The restriction is coded in fossil as a special sqlite authorizer callback. > It also ensures that reports can only do SELECTS and not INSERT, UPDATE, > etc. > > I believe/speculate that access to the user table is restricted to > prevent accidental (or malicious) exposure of the password hashes for > the users. > > AFAIK the only way around that is to use direct sqlite3 access to the > repository to create a table "fx_users" [1] or some such which is > partial copy of the "users" table and will be accessible in reports, > and other TH1 code. > > Of course, creating such a shadow then creates the need to somehow > track changes to the users table and copy them over into the shadow. > > [1] While the name in general can be as you like the "fx" prefix > ensures that the fossil app will consider it an extension table it has > to ignore at all times. Not using the "fx" prefix means that a > 'rebuild' will wipe the shadow table, for example. > > If JoeM has better ideas I will be interested in them as well. > > > -- > Andreas Kupries > Senior Tcl Developer > Code to Cloud: Smarter, Safer, Faster™ > F: 778.786.1133 > andre...@activestate.com, http://www.activestate.com > Learn about Stackato for Private PaaS: http://www.activestate.com/stackato > > 21'st Tcl/Tk Conference: Nov 10-14, Portland, OR, USA -- > http://www.tcl.tk/community/tcl2014/ > Send mail to tclconfere...@googlegroups.com, by Sep 8 > Registration is open. > _______________________________________________ > fossil-users mailing list > fossil-users@lists.fossil-scm.org > http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users >
_______________________________________________ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
