Re: [fossil-users] cherry picking issues

2011-02-03 Thread Stephen De Gabrielle
Iadded a column[internal/external], and did two different reports. I can't hide the 'internal' tickets and reports without using a second repository with a different local configuration. S. On Tue, Feb 1, 2011 at 7:16 AM, Ron Wilson ronw.m...@gmail.com wrote: We have been thinking it might

Re: [fossil-users] possible? pushing from ui mode...

2011-02-03 Thread Stephen De Gabrielle
How about a cron job that runs every 10 minutes? - you could get it to check if there have been any changes, but sync does that anyway. (and doesn't cause much network traffic) I seem to remember a sync function appearing in the ui, but it seems to have gone? Stephen On Tue, Feb 1, 2011 at 7:21

Re: [fossil-users] possible? pushing from ui mode...

2011-02-03 Thread Richard Hipp
On Thu, Feb 3, 2011 at 10:39 AM, Stephan Beal sgb...@googlemail.com wrote: On Thu, Feb 3, 2011 at 2:38 PM, Stephen De Gabrielle stephen.degabrie...@acm.org wrote: How about a cron job that runs every 10 minutes? - you could get it to check if there have been any changes, but sync does

Re: [fossil-users] ticket lists over json working

2011-02-03 Thread Stephen De Gabrielle
This looks great, Is it just from the command line, or is it available from the server 'live' - I'm keen to try it with http://www.simile-widgets.org/exhibit/ (if not I can always do a cron job to run it on the server, and commit the report to the repository) cheers, Stephen On Sat, Jan 29,

[fossil-users] arbitary SQL in fossil reports

2011-02-03 Thread Stephen De Gabrielle
Hi, I noticed you can query other tables in the report definitions: SELECT  date(mtime) AS 'mtime',  type,  user,  comment,  brief FROM event Not all of them, but I imagine this would be useful combined with json output. BTW what is the purpose of tablist=1 in

Re: [fossil-users] ticket lists over json working

2011-02-03 Thread Stephan Beal
On Thu, Feb 3, 2011 at 5:32 PM, Stephen De Gabrielle stephen.degabrie...@acm.org wrote: This looks great, :) The code is here if you want it: http://fossil.wanderinghorse.net/repos/fossil-sgb/ in the sgb-cson branch. that is just a clone of core fossil repo, and i merge in the fossil

Re: [fossil-users] ticket lists over json working

2011-02-03 Thread Stephen De Gabrielle
Thanks. I'll give it a go tonight. S. On Thursday, February 3, 2011, Stephan Beal sgb...@googlemail.com wrote: On Thu, Feb 3, 2011 at 5:32 PM, Stephen De Gabrielle stephen.degabrie...@acm.org wrote: This looks great, :) The code is here if you want it:

[fossil-users] newbie failing to log into server...

2011-02-03 Thread Mike Meyer
[This didn't show up in the archives; I'm assuming a filter ate it. Apologies if you saw it twice.] Hello, I've just started with fossil, so this is probably a simple problem - but googling for it hasn't turned up anything. I'm setting up a cgi server inside a firewall. I access it by ssh'ing

Re: [fossil-users] newbie failing to log into server...

2011-02-03 Thread Lluís Batlle i Rossell
On Thu, Feb 03, 2011 at 01:36:59PM -0500, Mike Meyer wrote: However, if I try and log in using the userid/password from the repo, I get SQLITE_CANTOPEN: cannot open file at line 27596 of [fabcb6b95e] SQLITE_CANTOPEN: statement aborts at 28: [UPDATE user SET

Re: [fossil-users] newbie failing to log into server...

2011-02-03 Thread Stephan Beal
2011/2/3 Lluís Batlle i Rossell virik...@gmail.com If you don't use a root account for your CGI, you can use a setuid program for it to have such access to your files. Something like this here explained, but applied to fossil:

Re: [fossil-users] newbie failing to log into server...

2011-02-03 Thread Lluís Batlle i Rossell
On Thu, Feb 03, 2011 at 08:15:26PM +0100, Stephan Beal wrote: 2011/2/3 Lluís Batlle i Rossell virik...@gmail.com If you don't use a root account for your CGI, you can use a setuid program for it to have such access to your files. Something like this here explained, but applied to

[fossil-users] HTSQL for SQLite? Was: ticket lists over json working

2011-02-03 Thread Richard Hipp
I just ran across HTSQL (http://htsql.org/) a few moments ago. I haven't looked at it much, yet, but it seems like an intriguing idea. Suppose we did this: (1) Add a small assortment of VIEWs and/or VIRTUAL TABLEs to Fossil that allow things like timelines and branch lists to be queried as if

Re: [fossil-users] HTSQL for SQLite? Was: ticket lists over json working

2011-02-03 Thread Ron Wilson
On Thu, Feb 3, 2011 at 8:53 PM, Richard Hipp d...@sqlite.org wrote: Suppose we did this: (1) Add a small assortment of VIEWs and/or VIRTUAL TABLEs to Fossil that allow things like timelines and branch lists to be queried as if they were plain old tables. This would make report queries easier

Re: [fossil-users] HTSQL for SQLite? Was: ticket lists over json working

2011-02-03 Thread Gour
On Thu, 3 Feb 2011 23:43:58 -0500 Ron Wilson wrote: This would make report queries easier to write. Indeed. Never heard of HTSQL before now, but making it easier to get alternative formats for results should be useful. I'm just exploring about HTSQL. Thank you for bringing it up. It looks