Gary Thomas | 1 Feb 01:41 2006

Re: Ticket dump?

On Tue, 2006-01-31 at 15:44 +0200, Toni Timonen wrote:
> On Tue, Jan 31, 2006 at 03:41:08PM +0200, Toni Timonen wrote:
> > On Tue, Jan 31, 2006 at 06:34:36AM -0700, Gary Thomas wrote:
> > > On Tue, 2006-01-31 at 14:26 +0100, Emmanuel Blot wrote:
> > > > > Thanks for any pointers
> > > > 
> > > > You can use the sqlite(3) tool to dump the DB as SQL statements.
> > > 
> > > Thanks.  Given that I know nothing about SQL, could you elucidate
> > > please?
> > 
> > To backup:
> > sqlite your_db_file '.dump wiki' > wikibackup.sql
> > 
> > To restore:
> > sqlite your_db_file < wikibackup.sql
> > 
> > see 
> >  man 3 sqlite
> > for details.
> > 
> 
> Sorry, not "wiki", but "ticket", "ticket_change" and "ticket_custom",
> ofcourse.

Where do the attachments get stored (which table)?

--

-- 
------------------------------------------------------------
Gary Thomas                 |  Consulting for the
(Continue reading)

Emmanuel Blot | 1 Feb 01:50 2006
Picon

Re: Ticket dump?

> Where do the attachments get stored (which table)?

Attachment *descriptions* are stored in the 'attachment' table.

However, the attached files (i.e. data) are stored as regular files in
the 'attachments' sub directory of the project, not in the DB.

--
Manu
Gary Thomas | 1 Feb 01:53 2006

Re: Ticket dump?

On Wed, 2006-02-01 at 01:50 +0100, Emmanuel Blot wrote:
> > Where do the attachments get stored (which table)?
> 
> Attachment *descriptions* are stored in the 'attachment' table.
> 
> However, the attached files (i.e. data) are stored as regular files in
> the 'attachments' sub directory of the project, not in the DB.

Got it, thanks.

--

-- 
------------------------------------------------------------
Gary Thomas                 |  Consulting for the
MLB Associates              |    Embedded world
------------------------------------------------------------
Bas van der Vlies | 1 Feb 12:45 2006
Picon
Picon

Announce new version of email2trac


2006-02-01  Bas van der Vlies <basv@...>:
         * Added Tikcet notification, send email when there is
           a new ticket. Depends on notification setting in
           trac.ini.
           Implemented by: Kilian Cavalotti
         * Can use different template for ticket notification,
           eg: alternate_notify_template: "a_tkt.css"
           Implemented by: Kilian Cavalotti
         * Added reply_all config parameter. If set put all
           CC-addresses from orginal mail in ticket CC-field.
           Suggested by: Kilian Cavalotti
         * Text in ticket description is also properly UTF-8
           encoded
           Implemented by: Kilian Cavalotti
         * Removed reply_address from config file. Is not
           necessary anymore. See Ticket notification.
         * Added support for known users. If email address is
           known then use the trac known username instead
           of the email-address (only for trac version > 0.9)
           Implemented by: Kilian Cavalotti
         * Fixed an error in saving attachments for version < 0.9.
           Sometimes we got bogus attachments.
           Fixed by: Walter de Jong
         * Added support to make an debian package
           Implemented by: Bas van der Vlies

========= Info about the package

http://www.trac-hacks.org/wiki/EmailtoTracScript
(Continue reading)

Terry Dooher | 1 Feb 13:17 2006

Re: Timeline RSS not escaping HTML in 0.9.3

Christian Boos wrote:
> Stefan Freyr Stefansson wrote:
> 
>> Hello.
>>
>> We're having problems with the Trac timeline RSS. It doesn't seem to 
>> be escaping HTML within its tags and therefore the RSS XML is illegal.
>> ...
> 
> This should work in 0.9.4, as the fixes are already in the stable branch.
> Please try it out:
> 
>  svn co http://svn.edgewall.com/repos/trac/branches/0.9-stable

I discivered this same issue when I enabled ticket_details in the RSS feed for 
the timeline in my 0.9.3 install.

I cehcked out and installed the above stable branch (python2.3 setup.py 
install), but I'm still getting validation errors, thanks to a &hellip; entity 
in the  description field (edited to remove certain identifying text):

    <item>
     <title>Ticket #3 (type) updated by person1</title>
     <pubDate>Tue, 31 Jan 2006 15:01:56 GMT</pubDate>
     <link>https://host.example.com/project/ticket/3</link>
     <description>From discussion with the Users: &hellip;</description>
    </item>

Thunderbird calls it an invalid rss feed, and Opera presents me with the 
following error:
(Continue reading)

Luigi Paioro | 1 Feb 14:33 2006
Picon

Re: Reserved wiki pages

Thank you!

I've tried It but I have some trouble...

This is what I did:

1. Downloaded rbac.patch :-)
2. Patched <site-packages>/trac/wiki/web_ui.py
3. Modified trac.ini [wiki] with:

    authz_svn_module_name = tracwiki
    authorization_mode = require_all
    authz_file = <mypath>/auth.trac

4. Created <mypath>/auth.trac file with:

    +-------

    [groups]
    admin = luigi

    [tracwiki:/]
    * = r

    [tracwiki:/TechnicalTips]
    * =
     <at> admin = a #give admin permission to the admin group.

    +-------

(Continue reading)

Daniel Serodio | 1 Feb 14:46 2006
Picon

How do I link to a Windows share?

How can I create a hyperlink to a Windows (SMB) share like
\\deptserver\shared for instance?

Thanks,
Daniel Serodio
Manuzhai | 1 Feb 15:16 2006
Picon

Re: How do I link to a Windows share?

> How can I create a hyperlink to a Windows (SMB) share like
> \\deptserver\shared for instance?

What does this have to do with Trac?

Usually, it would be easiest to just map the share to a drive letter.

Regards,

Manuzhai
Christian Boos | 1 Feb 15:28 2006
Picon

Re: How do I link to a Windows share?

Manuzhai wrote:
>> How can I create a hyperlink to a Windows (SMB) share like
>> \\deptserver\shared for instance?
>>     
>
> What does this have to do with Trac?
>   
I think Daniel is asking for a way to add links to Windows shares.
Like, e.g. DokuWiki does: 
http://wiki.splitbrain.org/wiki:syntax#windows_shares

That's not currently supported in Trac.

-- Christian
Johnson, Rick | 1 Feb 15:28 2006

RE: How do I link to a Windows share?

This has very little to do with Trac but this works in Firefox and IE:
<a href="file://///servername/servershare">this is a link to a file
share</a>

Rick 

> -----Original Message-----
> From: trac-bounces@... 
> [mailto:trac-bounces@...] On Behalf Of Manuzhai
> Sent: Wednesday, February 01, 2006 9:16 AM
> To: trac@...
> Subject: Re: [Trac] How do I link to a Windows share?
> 
> > How can I create a hyperlink to a Windows (SMB) share like 
> > \\deptserver\shared for instance?
> 
> What does this have to do with Trac?
> 
> Usually, it would be easiest to just map the share to a drive letter.
> 
> Regards,
> 
> Manuzhai
> _______________________________________________
> Trac mailing list
> Trac@...
> http://lists.edgewall.com/mailman/listinfo/trac
> 

Gmane