gmane.comp.version-control.subversion.trac.general

Re: [Trac] [trac] Problem with PrivateTicketsPlugin / VirtualTicketsPermissions

Olaf Meeuwissen — 2012-05-24T23:12:27


Just shooting in the dark but does the `anonymous` user have TICKET_VIEW
permissions by any chance?

Hope this helps,

Re: [Trac] remove attachments

2012-05-24T17:07:06

I'll try that. Thanks!

Sent wirelessly from my BlackBerry device on the Bell network.
Envoyé sans fil par mon terminal mobile BlackBerry sur le réseau de Bell.

-----Original Message-----
From: Chris Shelton <cshelton-Pls0fCm8YjYbalU/voNBTqxOck334EZe< at >public.gmane.org>
Sender: trac-users-/JYPxA39Uh5TLH3MbocFFw< at >public.gmane.org
Date: Thu, 24 May 2012 12:46:44 
To: <trac-users-/JYPxA39Uh5TLH3MbocFFw< at >public.gmane.org>
Reply-To: trac-users-/JYPxA39Uh5TLH3MbocFFw< at >public.gmane.org
Subject: Re: [Trac] remove attachments

Have someone with the TICKET_ADMIN permission access the attachment page on
a ticket, and click the Delete Attachment button.

chris

On Thu, May 24, 2012 at 10:37 AM, Alana Dalley
<alanamariedalley-Re5JQEeQqe8AvxtiuMwx3w< at >public.gmane.org>wrote:

Re: [Trac] remove attachments

Chris Shelton — 2012-05-24T16:46:44

Have someone with the TICKET_ADMIN permission access the attachment page on
a ticket, and click the Delete Attachment button.

chris

On Thu, May 24, 2012 at 10:37 AM, Alana Dalley
<alanamariedalley-Re5JQEeQqe8AvxtiuMwx3w< at >public.gmane.org>wrote:

[Trac] remove attachments

Alana Dalley — 2012-05-24T14:37:37

Hi there,

Just wondering if anyone knows how to delete an attachment once it has
been posted in TRAC.

[Trac] [trac] Problem with PrivateTicketsPlugin / VirtualTicketsPermissions

jhNz — 2012-05-24T09:08:10

First of all I have to state that I'm pretty new to trac. I was instructed 
to set it up for our company and until now everything worked well during 
the setup.
The point is, we want to use a single trac instance for multiple companies. 
Each company representative will get an account to post tickets and view
their status. It is important that the guy of company A wont be able to 
read the tickets the guy of company B submitted. That's where these plugins 
comes into play.

I am using trac 0.12.3 and PrivateTicketsPlugin 1.1.1

I installed it properly I guess since it appears in the Plugins menu of the 
trac-administration. I also have the new permissions that come with the 
plugins in
the dropdown-box in the permissions menu. So I guess this all worked well.
I added the PrivateTicketsPolicy to the trac.ini file and obviously enabled 
the plugin there as well. The PrivateTicketsPolicy is placed before the 
existing Policies:

permission_policies = PrivateTicketsPolicy, DefaultPermissionPolicy, 
LegacyAttachmentPolicy

In short: I followed the configuration instructions provided on 
trac-hacks.org step by step.

To test it I created a guest-user and granted him the 
permission TICKET_VIEW_REPORTER, since I want him to only see the tickets 
he reported himself. 
Beside that guest doesn't have any other permissions since the 
guest-account inherits all permissions from "authenticated" which are at 
the moment: 
TICKET_CREATE, TICKET_MODIFY, TICKET_VIEW, WIKI_CREATE, WIKI_MODIFY and 
WIKI_VIEW.

As you can see, the user- and permission-configuration is as basic as it 
gets.

The problem is that it doesn't seem to work at all. My guest user is still 
able to see all tickets. Are there any errors regarding my permission 
configuration or
do you see any other things that I might have missed? I'm a bit at a loss 
about that at the moment since it doesn't seem to be a "real" error with a 
corresponding
error message providing some kind of information about the issue. It's 
probably a wrong configuration of the permissions right now I guess.

I tried both plugins stated in the title of this post and both seem to have 
the same non-existing effect on my trac system ;/

Any help about that issue is greatly appreciated.

// Johannes

[Trac] Re: TracError: Cannot load Python bindings for PostgreSQL

David Genest — 2012-05-24T10:25:20

Ok, I found a fix for my problem. I removed my setuptools.pth file on my 
host (webfaction)

On Wednesday, 23 May 2012 21:41:56 UTC-4, David Genest wrote:

[Trac] Re: UnicodeDecodeError: 'utf8' codec can't decode bytes in position 85-88: invalid data

Reinhard Wobst — 2012-05-24T08:20:48

Sorry, this was a quick shot - the value would be lost and can cause
the next error. Replace the line by

value = unicode(value.value, 'utf-8', 'ignore')

(cf. Python manual on unicode() builtin function) if this is
permissible (no try-catch).
I don't know yet what 'value' is used for, so it depends on the
purpose what to do with that in error case.
At least, the error was generated here and not in the plugin.

Reinhard

[Trac] TracError: Cannot load Python bindings for PostgreSQL

David Genest — 2012-05-24T01:41:56

Hi, 

Not sure what changed in my hosting environment, but when I upgraded an 
extension (mercurial plugin that was failing), trac ceased to work saying 
it cannot load Python bindings for PostgreSQL. But everything was workihg 
before. 

I have psycopg2 installed. Trac was working.

Tried upgrading to latest trac. Still broken.

Note that I can load psycopg2 from a python prompt. I can also run without 
errors when I create an environment manually in a python shell.

The log posted below mentions exception while checking for upgrade. Is it 
possible to disable the upgrade checking to see if it's related to that? 
There is also an AttributeError in AdminModule. 

Can anybody help ? Thanks.

David.

Here is the relevant part of my log:

2012-05-23 20:11:24,790 Trac[env] ERROR: Exception caught while checking 
for upgrade: 
Traceback (most recent call last):
  File "/home/iekho/lib/python2.7/trac/env.py", line 667, in 
open_environment
    needs_upgrade = env.needs_upgrade()
  File "/home/iekho/lib/python2.7/trac/env.py", line 497, in needs_upgrade
    db = self.get_db_cnx()
  File "/home/iekho/lib/python2.7/trac/env.py", line 329, in get_db_cnx
    return get_read_db(self)
  File "/home/iekho/lib/python2.7/trac/db/api.py", line 90, in get_read_db
    return _transaction_local.db or DatabaseManager(env).get_connection()
  File "/home/iekho/lib/python2.7/trac/db/api.py", line 150, in 
get_connection
    connector, args = self.get_connector()
  File "/home/iekho/lib/python2.7/trac/db/api.py", line 195, in 
get_connector
    raise TracError(connector.error)
TracError: Cannot load Python bindings for PostgreSQL
2012-05-23 20:11:24,790 Trac[env] WARNING: base_url option not set in 
configuration, generated links may be incorrect
2012-05-23 20:11:24,790 Trac[main] DEBUG: Dispatching <Request "GET '/'">
2012-05-23 20:11:24,804 Trac[chrome] DEBUG: Prepare chrome data for request
2012-05-23 20:11:24,808 Trac[session] DEBUG: Retrieving session for ID 
'david'
2012-05-23 20:11:24,809 Trac[main] ERROR: can't retrieve session: 
TracError: Cannot load Python bindings for PostgreSQL
2012-05-23 20:11:24,810 Trac[chrome] ERROR: Error with navigation 
contributor AdminModule: AttributeError: 'FakePerm' object has no attribute 
'has_permission'
2012-05-23 20:11:24,811 Trac[api] INFO: Synchronized '(default)' repository 
in 0.01 seconds
2012-05-23 20:11:24,812 Trac[main] WARNING: HTTPInternalError: 500 Trac 
Error (Cannot load Python bindings for PostgreSQL)

Thanks.

RE: [Trac] Re: Trac/SVN Post Commit Hook only partially working

Cooke, Mark — 2012-05-24T06:08:40

I'm not a *nix user but it looks to me like there might be one of two issues: a) the www-data user (who is running the hook script) needs permission to /opt/ubersvn (i.e. add www-data to ubersvn group?) and you allowed only the other way round?  ...and/or b) you need to consider where `log.txt` is going to end up, apache will run the hook with a very minimal (empty!) environment...

~ mark c

[Trac] Re: UnicodeDecodeError: 'utf8' codec can't decode bytes in position 85-88: invalid data

Reinhard Wobst — 2012-05-23T22:58:41

This seems not to be a problem with your plugin but with Trac in the
line

value = unicode(value.value, 'utf-8')

in trac/web/api.py in the Trac source (are you using Trac 0.12? Which
version exactly?).

Some illegal unicode value occured here. I am not a Trac developer and
do not know the circumstances, but before developer explain this error
in detail, a quick and dirty help may be to
catch this error:

try:
    value = unicode(value.value, 'utf-8')
except:
    # issue some warning here if you want or:
   pass

Of course, you have to change the Trac source code to this purpose but
this should be no problem if you have the permissions.

HTH, Reinhard

[Trac] Re: Trac/SVN Post Commit Hook only partially working

Christian — 2012-05-23T20:42:51

Okay,

     So, I have tracked this down to a permissions problem. If I run:

*chmod -R o+rw /var/trac*

The ticket gets updated successfully. One can easily see why I wouldn't 
want to do this.

My permissions are set up as follows.

Everything under* /opt/ubersvn* is set to group *ubersvn *and owner *ubersvn
*
Everything under */var/trac* is set to group *www-data* and owner *www-data*
The user *ubersvn *is a member of the *www-data* group so it has permission 
to write to the *trac.db* file */var/trac/sites/web/db/trac.db* and it's 
directory. Thus the commit hook appears to work and refreshes the 
repository on the trac installation (i.e. I can see the commit message in 
the timeline)

Now, in my commit hook script I attempted to add some logging like this: */var/trac/sites/web 
changeset added "/opt/ubersvn/repositories/web" "refs #270" >> log.txt*

I got a permissions error.

So I guess the question is what user needs permission to what in my trac 
installation to update the dang tickets OR which directory can I set to 777 
to accomplish this instead of the whole /var/trac tree?

*Any help would be GREATLY appreciated!*

On Wednesday, May 16, 2012 1:33:25 PM UTC-7, Christian wrote:

Re: [Trac] Custom ticket query for new and reassigned tickets

Benjamin Lau — 2012-05-23T16:19:52

This triggered something in the back of my mind...
http://stackoverflow.com/questions/1991697/mysql-date-and-time-functions-dont-exist

I'm guessing they're running sqlite not mysql as the DB backend for
Trac. But that should help you with composing queries better.

I don't use the custom sql reports in trac usually... I've generally
tried to make do with the capabilities of the TicketQuery macro
embedded in a wiki page for my needs regarding reporting. What I have
setup looks like this:
== My Tickets ==

{{{#!td style="vertical-align: top; width: 33%;" align=center
[[TicketQuery(owner=$USER,status!~=closed,list,group=priority)]]
}}}
{{{#!td style="vertical-align: top; width: 33%;" align=center
[[TicketQuery(owner=$USER,status=in_QA,list)]]
}}}
{{{#!td style="vertical-align: top; width: 33%;" align=center
[[TicketQuery(owner=$USER,status=closed,list)]]
}}}

And let's me at a glance see my open tickets, ones that have been
assigned to QA for assessment and my closed tickets. I usually key
this additional by whatever milestone I'm currently working towards...
but this example is from a test Trac instance I had set up where I'm
not tracking a real project... so it doesn't have any milestones.
Maybe you could get the ordering you want by sorting with output using
the order field set to time (create) or changetime (modified).

Ben

[Trac] Custom ticket query for new and reassigned tickets

Michael — 2012-05-23T16:01:09

Hello everybody,

I hope to find some help here with custom ticket queries in sql for trac 
that will make my life easier ;)

First of all, we are using a hosted trac on hosted-projects.com. So my 
possibilities may be limited or some functionality may be missing but 
custom ticket queries in sql seem to work, although not fully as I would 
expect e.g. CURDATE() function is not working.

I would like to have two queries:

1) All my new tickets

When I try a custom query without sql with owner=michael and status=new, it 
just gives all the tickets that are assigned to me. 

But what I consider new tickets are
- tickets that have me as the owner and there was no change in the 
ownership, so basically all tickets that are created with me as the owner 
and are not touched again
or
- tickets that I own that have been assigned to me for the first time 
(which means that I have not been owner of the ticket before)

2) All tickets reassigned to me

This query should show me tickets that I own and have been assigned back to 
me, which means that I have been owner of the ticket before.

I think that for these queries I have to join the ticket and ticket_change 
table somehow, but that is exactly where I am stuck... 

Can someone help me with these sql queries?

Regards,
Michael

[Trac] UnicodeDecodeError: 'utf8' codec can't decode bytes in position 85-88: invalid data

didley — 2012-05-23T07:32:11

Hi,

I'm using plugin tracflexwiki from http://trac-hacks.org/wiki/FlexibleWikiPlugin.
This project is not maintained anymore.

With this plugin I get following error

{{{

2012-05-22 13:21:15,628 Trac[main] ERROR: Internal Server Error:
Traceback (most recent call last):
  File "build\bdist.win32\egg\trac\web\main.py", line 522, in
_dispatch_request
  File "build\bdist.win32\egg\trac\web\main.py", line 208, in dispatch
  File "build\bdist.win32\egg\trac\web\main.py", line 350, in
_pre_process_request
  File "build\bdist.win32\egg\tracflexwiki\navigation.py", line 22, in
pre_process_request
    node = TracFlexWikiNode(self.env, name=req.args.get('page', ''),
req=req)
  File "build\bdist.win32\egg\trac\web\api.py", line 216, in
__getattr__
  File "build\bdist.win32\egg\trac\web\api.py", line 199, in <lambda>
  File "build\bdist.win32\egg\trac\web\api.py", line 216, in
__getattr__
  File "build\bdist.win32\egg\trac\web\api.py", line 573, in
_parse_arg_list
UnicodeDecodeError: 'utf8' codec can't decode bytes in position 85-88:
invalid data
}}}

My logfile is growing till 3-4 MB every day. Knows anybody which
section, position I have to change around the code.

I want and I have to use this plugin further otherwise I would have to
change a lot of wiki pages.

 didley

[Trac] Re: Auto close "new" tickets?

RjOllos — 2012-05-23T00:04:34

I think you could script this pretty quickly using the XmlRpcPlugin, and 
TracCronPlugin might be useful as well. You might also want to look at 
DailyReminderScriptForTracScript if you are looking at writing a plugin to 
do this.

http://trac-hacks.org/wiki/TracCronPlugin
http://trac-hacks.org/wiki/DailyReminderScriptForTracScript

Re: [Trac] Auto close "new" tickets?

Nelson Brown — 2012-05-22T13:47:35

Hrm, I don't know if trac has a plugin to perform scheduled operations.  I
am thinking the query is simple, and you could do this yourself with batch
modify.

http://trac-hacks.org/wiki/BatchModifyPlugin

Though it would be neat if there was such a scheduled ops plugin that
worked with batch modify...

-Nelson
On May 22, 2012 6:46 AM, "Frank Murphy" <frankly3d-Re5JQEeQqe8AvxtiuMwx3w< at >public.gmane.org> wrote:

[Trac] Auto close "new" tickets?

Frank Murphy — 2012-05-22T10:42:23

Is it possible to autoclose tickets marked "new"
after a set number of days. (thinking 60)

Re: [Trac] Workflow-specific permissions

Jingda Wang — 2012-05-21T11:54:34

Hi Mark, Thanks for your advice! I will try !

Sent from my iPhone

On May 21, 2012, at 5:20, "Cooke, Mark" <mark.cooke-kv7WeFo6aLtBDgjK7y7TUQ< at >public.gmane.org> wrote:

RE: [Trac] Workflow-specific permissions

Cooke, Mark — 2012-05-21T09:20:04

I upgraded our projects from 0.11 to 0.12 and I do not remember having many problems.  It may depend on how many projects you have and more importantly on the plugins that you have installed (i.e. if the plugins work with 0.12 or have a version that does).  We do not use many plugins.

I am not sure what you mean by "change the layout" ~ there were a few cosmetic enhancements but nothing that caused any problems for me or my users.

I would recommend you try out an offline upgrade of a few projects rather than invest time in supporting the old version in parallel.

Good luck,

~ mark c

Re: [Trac] Workflow-specific permissions

jingda wang — 2012-05-18T16:48:44

Because the project under old version (0.11) are in use, and the
update(0.12 or 13) will change the layout right? The designing of new
version uses some new feature in 0.12. so I wonder that if it is
possible to have different version under the same system

2012/5/18 Olaf Meeuwissen <olaf.meeuwissen-U90acDNpsFV4Eiagz67IpQ< at >public.gmane.org>:

Re: [Trac] Workflow-specific permissions

Olaf Meeuwissen — 2012-05-18T09:46:54


Conflicting requirements for the plugins used by the various projects?
Separation of access privileges to project data?

Just some thoughts,