Re: [fossil-users] Stupid newbie question: attempt to write a readonly database
Thanks heaps. That was a pretty stupid mistake. Just for the next person with the same problem, my Fossil directory and cgi-bin directory were both owned by root for some reason. To fix this I ran $ sudo chown -R USERNAME:GROUP cgi-bin/ $ sudo chown -R USERNAME:GROUP Fossil/ with USERNAME and GROUP, obviously being replaced with my username and group. Thanks again. On 1 July 2012 20:28, Lluís Batlle i Rossell vi...@viric.name wrote: On Sun, Jul 01, 2012 at 12:16:55PM +0200, Stephan Beal wrote: On Sun, Jul 1, 2012 at 12:16 PM, Stephan Beal sgb...@googlemail.com wrote: On Sun, Jul 1, 2012 at 11:47 AM, Robin Shannon r...@robinshannon.netwrote: SQLITE_CANTOPEN: cannot open file at line 27473 of [2677848087] The directory containing the db also has to be writable by the CGI process. PS: that's necessary for the db journaling files. Notice that the user running the cgi may not be the user owning the db file and folder. ___ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users -- http://robinshannon.net ___ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
[fossil-users] Stupid newbie question: attempt to write a readonly database
So I set up a fossil archive on my home machine. No problems. I then tried the same thing on my dreamhost VPS using the cgi method suggested in the user guide. For some reason here I could only do the fossil commands if i put a sudo in front of them (sudo fossil new/open/add/commit). I tried changing permissions for fossil, sqlite, sqlite3, the fossil archive and the folder (and contents) being archived. None of these helped. When I point my browser to the cgi page http://robinshannon.net/cgi-bin/keystone.cgi/index it works fine, but if I try to login it complains: SQLITE_CANTOPEN: cannot open file at line 27473 of [2677848087] SQLITE_CANTOPEN: statement aborts at 31: [REPLACE INTO config(name,value) VALUES('captcha-secret', lower(hex(randomblob(20;] Database Error unable to open database file REPLACE INTO config(name,value) VALUES('captcha-secret', lower(hex(randomblob(20; If you have recently updated your fossil executable, you might need to run fossil all rebuild to bring the repository schemas up to date. Needless to say, fossil all rebuild doesn't fix it. Any ideas? I've tried searching the list archives and google for with the error without much luck. Peace, Robin. -- http://robinshannon.net ___ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
Re: [fossil-users] Stupid newbie question: attempt to write a readonly database
On Sun, Jul 1, 2012 at 11:47 AM, Robin Shannon r...@robinshannon.net wrote: SQLITE_CANTOPEN: cannot open file at line 27473 of [2677848087] The directory containing the db also has to be writable by the CGI process. What i do is stuff all my fsl files in one dir and make that dir writable to the CGI process (which on my hoster just happens to be me - they run CGIs as the account user). Give that a try and let us know. -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal ___ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
Re: [fossil-users] Stupid newbie question: attempt to write a readonly database
On Sun, Jul 1, 2012 at 12:16 PM, Stephan Beal sgb...@googlemail.com wrote: On Sun, Jul 1, 2012 at 11:47 AM, Robin Shannon r...@robinshannon.netwrote: SQLITE_CANTOPEN: cannot open file at line 27473 of [2677848087] The directory containing the db also has to be writable by the CGI process. PS: that's necessary for the db journaling files. -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal ___ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
Re: [fossil-users] Stupid newbie question: attempt to write a readonly database
On Sun, Jul 01, 2012 at 12:16:55PM +0200, Stephan Beal wrote: On Sun, Jul 1, 2012 at 12:16 PM, Stephan Beal sgb...@googlemail.com wrote: On Sun, Jul 1, 2012 at 11:47 AM, Robin Shannon r...@robinshannon.netwrote: SQLITE_CANTOPEN: cannot open file at line 27473 of [2677848087] The directory containing the db also has to be writable by the CGI process. PS: that's necessary for the db journaling files. Notice that the user running the cgi may not be the user owning the db file and folder. ___ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users