Hi Ryan, Tried with a path that doesn't contain whitespace, but no change.
I will see if I can persuade the IT department to suspend the Sophos anti-virus for a short while so I can do some tests. In the meantime, can one get any more debugging information out of the python SQLite interface ? The reason for failure isn't terribly helpful as it stands, and I have rechecked that the directory tree and trac.db have modify permissions for all users after creation. Thanks, Greville On Saturday, 17 March 2018 11:19:13 UTC, RjOllos wrote: > > > On Friday, March 16, 2018 at 4:34:20 PM UTC, G Earle wrote: >> >> Hello Ryan, >> >> Below is the output from an attempt to create a new installation in brand >> new directory "C:\Trac Working Area 2", (which I ensured had recursive >> read-write permissions before anything else): >> >> Microsoft Windows [Version 6.1.7601] >> Copyright (c) 2009 Microsoft Corporation. All rights reserved. >> C:\Users\gearle.ASSYSTEM>trac-admin "C:\Trac Working Area 2" initenv >> Creating a new Trac environment at C:\Trac Working Area 2 >> Trac will first ask a few questions about your environment >> in order to initialize and prepare the project database. >> Please enter the name of your project. >> This name will be used in page titles and descriptions. >> Project Name [My Project]> Trac Installation Test >> Please specify the connection string for the database to use. >> By default, a local SQLite database is created in the environment >> directory. It is also possible to use an existing MySQL or >> PostgreSQL database (check the Trac documentation for the exact >> connection string syntax). >> Database connection string [sqlite:db/trac.db]> >> Creating and Initializing Project >> Installing default wiki pages >> CamelCase imported from >> C:\Python27\lib\site-packages\trac\wiki\default-pages\CamelCase >> Initenv for 'C:\Trac Working Area 2' failed. >> unable to open database file >> Traceback (most recent call last): >> File "C:\Python27\lib\site-packages\trac\admin\console.py", line 511, >> in do_initenv >> WikiAdmin(self.__env).load_pages(pages_dir) >> File "C:\Python27\lib\site-packages\trac\wiki\admin.py", line 159, in >> load_pages >> if self.import_page(filename, page, create_only, replace): >> File "C:\Python27\lib\site-packages\trac\wiki\admin.py", line 146, in >> import_page >> title)) >> File "C:\Python27\lib\site-packages\trac\db\util.py", line 128, in >> execute >> cursor.execute(query, params if params is not None else []) >> File "C:\Python27\lib\site-packages\trac\db\util.py", line 72, in >> execute >> return self.cursor.execute(sql_escape_percent(sql), args) >> File "C:\Python27\lib\site-packages\trac\db\sqlite_backend.py", line >> 88, in execute >> result = PyFormatCursor.execute(self, *args) >> File "C:\Python27\lib\site-packages\trac\db\sqlite_backend.py", line >> 64, in execute >> args or []) >> File "C:\Python27\lib\site-packages\trac\db\sqlite_backend.py", line >> 55, in _rollback_on_error >> return function(self, *args, **kwargs) >> OperationalError: unable to open database file >> Microsoft Windows [Version 6.1.7601] >> Copyright (c) 2009 Microsoft Corporation. All rights reserved. >> C:\Users\gearle.ASSYSTEM>trac-admin "C:\Trac Working Area 2" initenv >> Creating a new Trac environment at C:\Trac Working Area 2 >> Trac will first ask a few questions about your environment >> in order to initialize and prepare the project database. >> Please enter the name of your project. >> This name will be used in page titles and descriptions. >> Project Name [My Project]> Trac Installation Test >> Please specify the connection string for the database to use. >> By default, a local SQLite database is created in the environment >> directory. It is also possible to use an existing MySQL or >> PostgreSQL database (check the Trac documentation for the exact >> connection string syntax). >> Database connection string [sqlite:db/trac.db]> >> Creating and Initializing Project >> Installing default wiki pages >> CamelCase imported from >> C:\Python27\lib\site-packages\trac\wiki\default-pages\CamelCase >> Initenv for 'C:\Trac Working Area 2' failed. >> unable to open database file >> Traceback (most recent call last): >> File "C:\Python27\lib\site-packages\trac\admin\console.py", line 511, >> in do_initenv >> WikiAdmin(self.__env).load_pages(pages_dir) >> File "C:\Python27\lib\site-packages\trac\wiki\admin.py", line 159, in >> load_pages >> if self.import_page(filename, page, create_only, replace): >> File "C:\Python27\lib\site-packages\trac\wiki\admin.py", line 146, in >> import_page >> title)) >> File "C:\Python27\lib\site-packages\trac\db\util.py", line 128, in >> execute >> cursor.execute(query, params if params is not None else []) >> File "C:\Python27\lib\site-packages\trac\db\util.py", line 72, in >> execute >> return self.cursor.execute(sql_escape_percent(sql), args) >> File "C:\Python27\lib\site-packages\trac\db\sqlite_backend.py", line >> 88, in execute >> result = PyFormatCursor.execute(self, *args) >> File "C:\Python27\lib\site-packages\trac\db\sqlite_backend.py", line >> 64, in execute >> args or []) >> File "C:\Python27\lib\site-packages\trac\db\sqlite_backend.py", line >> 55, in _rollback_on_error >> return function(self, *args, **kwargs) >> OperationalError: unable to open database file >> >> I have then immediately checked (via DOS) as to whether any files have >> the read-only flag set, and none do: >> >> C:\Users\gearle.ASSYSTEM> >> C:\Users\gearle.ASSYSTEM>dir /A:R /S "C:\Trac Working Area 2" >> Volume in drive C has no label. >> Volume Serial Number is B0E0-B049 >> File Not Found >> >> I have then used the SQLite3 client to see if I can open the Trac >> database file, and there are no errors on that front: >> >> C:\Users\gearle.ASSYSTEM>sqlite3 >> SQLite version 3.22.0 2018-01-22 18:45:57 >> Enter ".help" for usage hints. >> Connected to a transient in-memory database. >> Use ".open FILENAME" to reopen on a persistent database. >> sqlite> .open C:\Trac Working Area 2\db\trac.db >> sqlite> ^Z >> >> C:\Users\gearle.ASSYSTEM> >> >> Not sure what to try next I'm afraid. Is there a greater level of >> debugging on the trac-admin command (I can't see any from the trac-admin >> help) ? >> >> Thanks, Greville >> > > > Please take a look at this comment: > https://trac.edgewall.org/ticket/11734#comment:7 > > Do you have antivirus software running on the computer? > > Could you also try to reproduce for a path that doesn't contain > whitespace? I doubt that is the issue, but worth checking. > > - Ryan > -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to trac-users+unsubscr...@googlegroups.com. To post to this group, send email to trac-users@googlegroups.com. Visit this group at https://groups.google.com/group/trac-users. For more options, visit https://groups.google.com/d/optout.
