View Ticket
Not logged in
Ticket UUID: c1cb47f0f9c60d33054a244fdf9fb8c62e953f21
Title: Can't login. Server is Ubuntu 10.10
Status: Closed Type: Code_Defect
Severity: Severe Priority:
Subsystem: Resolution: Not_A_Bug
Last Modified: 2011-02-19 15:24:13
Version Found In: [356e877cea] 2011-01-13 19:55:28.947 UTC
Description & Comments:
I managed to have the cgi script to work. However, when I attempt login and enter the correct password I receive this: SQLITE_CANTOPEN: cannot open file at line 27669 of [b0888047bb]

SQLITE_CANTOPEN: statement aborts at 28: [UPDATE user SET cookie='1/8579937B866245F2BB11D3510E25234DF3D88E520F015DADB6', ipaddr='82.81.34.46', cexpire=julianday('now')+31557600/86400.0 WHERE uid=1]

Database Error

unable to open database file UPDATE user SET cookie='1/8579937B866245F2BB11D3510E25234DF3D88E520F015DADB6', ipaddr='82.81.34.46', cexpire=julianday('now')+31557600/86400.0 WHERE uid=1 If you have recently updated your fossil executable, you might need to run "fossil all rebuild" to bring the repository schemas up to date.


anonymous added on 2011-02-07 10:25:49 UTC:
I am the same anonymous that placed this issue. Googling for "unable to open database file sqlite" yielded the solution: the directory that contains the repository (as well as the repository itself) has to be owned by www-data. chown www-data FOSSIL solved the problem.


anonymous claiming to be anonymous - alberto bottoni added on 2011-02-19 15:22:44 UTC:
as change [8e83c2307f] pointed out, it was an installation detail problem (file permission), so not a bug

(I love fossile!)


anonymous claiming to be alberto bottoni added on 2011-02-19 15:24:13 UTC:
and status is closed - hemm...