RE: [Trac] Access the SQLite database outside Trac
I just use the sqlite3 command line interface to do small work, and for larger things I use the PHP PDO package to access the db. Sqlite has programming interfaces for a number of common languages. It's true that intensive work will intermittently lock the db for others, as sqlite3 uses file locking to ensure integrity, but it's very easy to write your code so that the lock is only for a short time. The usual way of dealing with a db lock is to merely retry the operation. You do not have to leave the db to unlock it, just have the select or update or whatever transaction you are in end. Dan Winslow Director of Information Technology, AIM INSTITUTE 1905 Harney Street, Suite 700 Omaha, NE 68102 402-345-5025 x156 dwins...@aiminstitute.org www.aiminstitute.org From: trac-users@googlegroups.com [mailto:trac-us...@googlegroups.com] On Behalf Of Scott Mead Sent: Sunday, January 10, 2010 10:16 AM To: trac-users@googlegroups.com Subject: Re: [Trac] Access the SQLite database outside Trac On Sun, Jan 10, 2010 at 2:59 PM, pederalm peder@eis.semcon.com wrote: I'm used to MySQL. With MySQL (like many db engines) you can access the db outside the server where the db engine is installed using a db client and a SQL command. I want to access the SQLite db in that way, but I don't know if it works. Does it? Or is there any other way to access the db? Or do I have to change the Trac db engine to MySQL? You can do that, BUT if you are doing writes to the database, nobody else can read from it at the same time. So your trac and reporting program will 'bump' into each other. If you have the ability to switch to mysql or postgresql and you think it's worth the effort, I'd personally say go for it. It will make things much easier if you're going to be doing a lot of data-intensive work. --Scott -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to trac-us...@googlegroups.com. To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
Re: [Trac] Re: trac-post-commit-hook runs mannaully not by TSVN commit
On Fri, Jan 8, 2010 at 6:28 PM, lynda lyndali...@gmail.com wrote: When I print out some data from trac-post-commit-hook, I found out the rev number and error msg are always the same: trac.versioncontrol.cache.CachedChangeset object at 0x02F222D0 line 160 changeset is trac.versioncontrol.cache.CachedChangeset object at 0x02F222D0 line 168 self.rev is 3 line 170 self.msg is (In [3]) scriptmanager error is fixed due to to ajax dependency My commit revision is 150, and msg is fixed #5: test post commit hook I have never seen something like this ... perhaps you should create a new ticket @ the Trac project site ? -- Regards, Olemis. Blog ES: http://simelo-es.blogspot.com/ Blog EN: http://simelo-en.blogspot.com/ Featured article: -- You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-us...@googlegroups.com. To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
Re: [Trac] Re: error: could not create 'TracHTTPAuth.egg-info': Access is denied
Thank you! yes, it is permission problem. I went to enable read-access ability. In windows I can select the diretory or file, then uncheck the read mark. Best regards lynda On Mon, Jan 11, 2010 at 8:09 AM, CM Lubinski cmc333...@gmail.com wrote: Sounds like permission issues. I know that all of the trac hacks I try to install start off with read-access disabled for everyone, but I'm not too sure how this works on Windows. Try putting this in your home directory (or your Desktop), and run the python commands there. If you still get Access Denied, right click on some of the files within the http_auth folder go to properties and check that the 'Read' permission is on. Good Luck! CM Lubinski On Jan 9, 4:42 am, lynda lyndali...@gmail.com wrote: I installed bitNami Trac Stack in my Program files/BitNamiTrac. I'd like to install some plugins. For example: httpauthplugin. I download the httpauthplugin zip file to my E driver, and unzipped it to trac_source\plugins\http_auth\ then I run this command to try to build egg file, then install it: C:\Program Files\BitNamiTrac\python\Scripts python E:\trac_source\plugins\http_auth\setup.py bdist_egg then result is: running bdist_egg running egg_info creating TracHTTPAuth.egg-info error: could not create 'TracHTTPAuth.egg-info': Access is denied How can I resolve it? Thank you for your help Best Regards Lynda -- You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-us...@googlegroups.com. To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.comtrac-users%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/trac-users?hl=en. -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to trac-us...@googlegroups.com. To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
[Trac] new wiki page lost contents when it's submitted
Hi all. Now I use trac 0.11.4 with sqlite 3.6.14.2 on small Linux box. Sometimes, after new wiki page is submitted, I mean, after first submit for a page, the page loses all contents which is entered and blank page is shown (create this page button is shown). I logged at debug level, but I couldn't find anything from the log. So anyone has some ideas to debug this error? (It might be related to sqlite's loading time. But I don't know.) Thank you. -- nac -- You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-us...@googlegroups.com. To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
[Trac] Installing on Unix: Cannot load Python bindings for SQLite
Hey all, I'm trying to set up a Trac installation on my Unix server, and followed the steps on http://trac.edgewall.org/wiki/TracInstall. I've reached the step where an environment is created. I entered $ trac-admin /path/to/myproject initenv, and answered the questions presented. Trac-admin however, stalls after answering the last question with the error: TracError: Cannot load Python bindings for SQLite I'm using Python 2.6.4 since I believe SQLite was preinstalled in that version. What am I missing? -- You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-us...@googlegroups.com. To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
[Trac] Print a gant chart page
Hello, Is there any facility to print out the gantt chart that this plugin provide ? http://trac-hacks.org/wiki/GanttCalendarPlugin I couldn't manage a working gantt chart with this plugin: http://trac-hacks.org/wiki/SchedulingToolsPlugin Well, I'd like a working and normal grantt chart for trac tickets that can be printed, is there any facility for it ? Thanks in advance, Laszlo Papp -- You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-us...@googlegroups.com. To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
[Trac] Re: Installing on Unix: Cannot load Python bindings for SQLite
Hi Squrler, You should double check that you have sqlite installed, it should come with python 2.6.4 to check in a shell window type python import sqlite3 sqlite3.version pressing enter after each line, it should bring up a version number if that doesn't work try python import sqlite sqlite.version If neither bring up a number you don't have sqlite (or at least python can't find it) you should check if you an install it with your Unix distributions package manager, (what OS are you using specifically?) ~Rowan On Jan 10, 9:19 am, Squrler coen.war...@gmail.com wrote: Hey all, I'm trying to set up a Trac installation on my Unix server, and followed the steps onhttp://trac.edgewall.org/wiki/TracInstall. I've reached the step where an environment is created. I entered $ trac-admin /path/to/myproject initenv, and answered the questions presented. Trac-admin however, stalls after answering the last question with the error: TracError: Cannot load Python bindings for SQLite I'm using Python 2.6.4 since I believe SQLite was preinstalled in that version. What am I missing? -- You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-us...@googlegroups.com. To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
Re: [Trac] new wiki page lost contents when it's submitted
Hi. Now I use trac 0.11.4 with sqlite 3.6.14.2 on small Linux box. Sometimes, after new wiki page is submitted, I mean, after first submit for a page, the page loses all contents which is entered and blank page is shown (create this page button is shown). Bling guess: are you using the Tags plugin, and did you specify one or more tags in those cases where the content of the new page gets lost? If yes, that's a known issue, see http://trac-hacks.org/ticket/3206 (which contains a patch that fixes it). Bye, Mike -- You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-us...@googlegroups.com. To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
[Trac] Adding new extensions to mime types
Hi there As per Perl conventions, .t files contain application tests. How do I tell trac that files with this extension should be treated as perl? Thanks -- You received this message because you are subscribed to the Google Groups Trac Users group. To post to this group, send email to trac-us...@googlegroups.com. To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.