Thank you very much! The c:\temp folder is open for Apache and its child processes. This setting is not helpful to the fossil.
When I add the macro definition to build sqlite3.o, the fossil works well. - Liu Chang 2011/8/23 Richard Hipp <[email protected]> > > > 2011/8/23 Liu Chang <[email protected]> > >> Hi: >> >> when I run fossil with an Apache web server on Windows, it complains the >> following message when I click on "Files" >> > > The processes run by Apache appear to not be able to locate and/or open > files in the c:\temp folder. > > One possible workaround - recompile Fossil using -DSQLITE_TEMP_STORE=3 > which will cause Fossil to use RAM for all of its temporary files, rather > than writing to disk. > > >> >> ---- >> >> SQLITE_CANTOPEN: os_win.c:33680: (5) >> winOpen(C:\WINDOWS\etilqs_eNlkUH8yb3Zl1PU) - 拒绝访问。(access deny) >> >> SQLITE_CANTOPEN: os_win.c:33680: (2) >> winOpen(C:\WINDOWS\etilqs_Kt1JdjkQhGT5Grj) - 系统找不到指定的文件。 (can not find >> system file) >> >> SQLITE_CANTOPEN: cannot open file at line 33686 of [9b191bb4c7] >> >> SQLITE_CANTOPEN: statement aborts at 48: [CREATE TEMP TABLE localfiles(x >> UNIQUE NOT NULL, u);] unable to open database file >> Database Error unable to open database file CREATE TEMP TABLE >> localfiles(x UNIQUE NOT NULL, u); >> >> If you have recently updated your fossil executable, you might need to run >> "fossil all rebuild" to bring the repository schemas up to date. >> ---- >> >> When I click on timeline, it complains: >> >> ---- >> >> SQLITE_CANTOPEN: os_win.c:33680: (5) >> winOpen(C:\WINDOWS\etilqs_f946RSzNBHAyFya) - 拒绝访问。 >> >> SQLITE_CANTOPEN: os_win.c:33680: (2) >> winOpen(C:\WINDOWS\etilqs_OLEqQ6kjuA8QmSl) - 系统找不到指定的文件。 >> >> SQLITE_CANTOPEN: cannot open file at line 33686 of [9b191bb4c7] >> >> SQLITE_CANTOPEN: statement aborts at 37: [CREATE TEMP TABLE IF NOT EXISTS >> timeline( rid INTEGER PRIMARY KEY, uuid TEXT, timestamp TEXT, comment TEXT, >> user TEXT, isleaf BOOLEAN, bgcolor TEXT, etype TEXT, taglist TEXT, tagid >> INTEGER, short TEXT, sortby REAL ) ] unable to open database file >> Database Error >> >> unable to open database file >> CREATE TEMP TABLE IF NOT EXISTS timeline( >> rid INTEGER PRIMARY KEY, >> uuid TEXT, >> timestamp TEXT, >> comment TEXT, >> user TEXT, >> isleaf BOOLEAN, >> bgcolor TEXT, >> >> >> >> etype TEXT, >> taglist TEXT, >> tagid INTEGER, >> short TEXT, >> sortby REAL >> ) >> >> ---- >> >> The Apache is running as a normal user instead of administrator (or system). >> >> When I run the apache as an administrator, the problem disappeared. So, the >> problem should be related to the access priviledge. >> >> >> >> However, when I run "fossil server" as the same normal user, it works on >> port 8080 very well. >> >> I hope it can be hosted on behind Apache to provide service on port 80, or >> 443. >> >> Thanks, >> Liu Chang >> >> >> >> >> >> _______________________________________________ >> fossil-users mailing list >> [email protected] >> http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users >> >> > > > -- > D. Richard Hipp > [email protected] > > _______________________________________________ > fossil-users mailing list > [email protected] > http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users > >
_______________________________________________ fossil-users mailing list [email protected] http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users

