RE: [Trac] Why does workflow change require environment upgrade?

2011-01-14 Thread Cooke, Mark
 

> -Original Message-
> From: trac-users@googlegroups.com On Behalf Of Remy Blank
> Sent: 13 January 2011 18:31
> Subject: Re: [Trac] Why does workflow change require 
> environment upgrade?
> 
> Cooke, Mark wrote:
> > 2011-01-13 10:23:10,038 Trac[env] WARNING: Component
> >  > 0x02B7AD50> requires environment upgrade
> 
> Oh, now I see. The ConfigurabelTicketWorkflow component has 
> some upgrade code that triggers if no workflow is defined at
> all in trac.ini (or any included files). If you run the
> upgrade, it adds a workflow that corresponds to how Trac
> managed tickets before configurable workflows were introduced
> (you can find it in the file original-workflow.ini).
> 
> So you either have to run the upgrade, or add some kind of
> workflow yourself.
> 
> -- Remy
> 
Thanks again Remy.  This means that the same-directory [inherit] 'file =
' in my shared conf was working and explains why all envs went bad when
I renamed the workflow conf file under the mistaken impression it wasn't
being read.  I have also solved the 'not working' bit as well (the
workflow I had downloaded and edited was adding 'testing' as a
resolution instead of a state and most of the envs did not have this
'resolution').

Anyway, I now have 0.11.7 working again and 0.12.1 running under test...

Many thanks for the clarification.

~ mark c

-- 
You received this message because you are subscribed to the Google Groups "Trac 
Users" group.
To post to this group, send email to trac-users@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] Migrating from SQLite to Postgres

2011-01-14 Thread Coalescence
Hi,

Posting this to the list as #trac on freenode doesn't seem to want to
let me speak (authenticated etc.. so don't know what's up!)

I'm handling a database migration from sqlite to postgres, however
using the script (1) leads me to this error

--

trac:~/work/sqlitetopgscript/0.10# ./sqlite2pg -e /home/sahana/trac -p
'postgres://:x@localhost/trac'
/usr/local/lib/python2.6/dist-packages/TracScreenshots-0.8dev-
py2.6.egg/tracscreenshots/core.py:13: DeprecationWarning: the sets
module is deprecated
  import sets
Traceback (most recent call last):
  File "./sqlite2pg", line 335, in 
sys.exit(main(sys.argv[1:]))
  File "./sqlite2pg", line 331, in main
Main(opts)
  File "./sqlite2pg", line 244, in Main
pgenv = getPostgreSQLEnvironment(opts)
  File "./sqlite2pg", line 209, in getPostgreSQLEnvironment
cnx = env.get_db_cnx()
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.1-py2.6.egg/
trac/env.py", line 328, in get_db_cnx
return get_read_db(self)
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.1-py2.6.egg/
trac/db/api.py", line 90, in get_read_db
return _transaction_local.db or
DatabaseManager(env).get_connection()
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.1-py2.6.egg/
trac/db/api.py", line 150, in get_connection
connector, args = self.get_connector()
  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.1-py2.6.egg/
trac/db/api.py", line 192, in get_connector
scheme=scheme))
trac.core.TracError: Unsupported database type "postgres"



We've migrated from an older version also, but the initial migration
work seems to have worked ok for sqlite

We ran..

trac-admin /home/xxx/trac upgrade
trac-admin /home/xxx/trac wiki upgrade
trac-admin /home/xxx/trac repository resync '*'

I have the relevant modules installed from what I can see. Would
appreciate any pointers!

Running:

Debian Squeeze
ii  python2.6   2.6.6-8+b1  An
interactive high-level object-oriented language (version 2.
ii  python-psycopg2 2.2.1-1
Python module for PostgreSQL
ii  postgresql-8.4  8.4.5-0squeeze2
object-relational SQL database, version 8.4 server




Thanks
Joel

-- 
You received this message because you are subscribed to the Google Groups "Trac 
Users" group.
To post to this group, send email to trac-users@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] ANNOUNCE: Trac-jsGantt 0.2

2011-01-14 Thread Chris Nelson
Roger Oberholtzer wrote:
> On Mon, 2010-12-13 at 10:17 -0500, Chris Nelson wrote:
>> I announced the Trac-jsGantt plugin on 12/6.  Since then I've gotten
>> some valuable feedback from Roger Oberholtzer and "yoheeb" (Thanks,
>> guys!) and refined a few features.  
> 
> I have finally had time to install the latest. We are moving forward.
> 
> I have a milestone that is due March 1, 2011. It is the only milestone
> defined that is not already completed and closed. In the chart, for
> the milestone, a triangle is placed at Dec 31. 2010. Shouldn't the
> triangle be at Match 1, 2011?

Yes, I'd expect so.  Can you show me?  Maybe a screen shot of the Gantt
with the End Date column shown and the diamond in the wrong place?

> I still need to play with the actual entries. But I think that is
> more a matter of me adding dates and such to the tickets.

We've put this in our production environment this week so I may be
making a round of tweaks soon based on my users' feedback.

-- 
You received this message because you are subscribed to the Google Groups "Trac 
Users" group.
To post to this group, send email to trac-users@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] Using mod_wsgi with multiple trac instances and mysql

2011-01-14 Thread mark ardiente
Hi!

I'm using Trac 0.12  with mod_wsgi adapter and mysql as backend db server.

I currently have multiple trac instances and as time passes by the response 
time 
for each request tends to become slow.

Don't know if it has something to do the server getting a lot of open db 
connections

Does anyone have the same problem as me?

Regards,
Mark

-- 
You received this message because you are subscribed to the Google Groups "Trac 
Users" group.
To post to this group, send email to trac-users@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.