[Trac] Re: setup behind firewall

[berny]

Hi Jason,

thank you for that detailed description.

> I highly recommend drinking a Guinness.

I come from Bavaria/Germany, so there are many alternatives. Guiness
is good
and tasty, I personally prefer drinking a dark wheat bock beer. ;-)

I have a similar host with network access at hand. Unfortunately,
the installation fails rather early:

ecs@mchp320a:~/downloads/virtualenv-1.6> ~/dev/bin/virtualenv ~/dev
New python executable in /user/ecs/dev/bin/python
Installing setuptools..
  Complete output from command /user/ecs/dev/bin/python -c "#!python
\"\"\"Bootstra...sys.argv[1:])



" /user/ecs/downloads/...ols-0.6c11-py2.4.egg:
  Traceback (most recent call last):
  File "", line 67, in ?
ImportError: No module named md5

...Installing setuptools...done.
Traceback (most recent call last):
  File "/user/ecs/dev/bin/virtualenv", line 3, in ?
virtualenv.main()
  File "/user/ecs/downloads/virtualenv-1.6/virtualenv.py", line 745,
in main
prompt=options.prompt)
  File "/user/ecs/downloads/virtualenv-1.6/virtualenv.py", line 843,
in create_environment
install_setuptools(py_executable, unzip=unzip_setuptools)
  File "/user/ecs/downloads/virtualenv-1.6/virtualenv.py", line 571,
in install_setuptools
_install_req(py_executable, unzip)
  File "/user/ecs/downloads/virtualenv-1.6/virtualenv.py", line 547,
in _install_req
cwd=cwd)
  File "/user/ecs/downloads/virtualenv-1.6/virtualenv.py", line 811,
in call_subprocess
raise OSError(
OSError: Command /user/ecs/dev/bin/python -c "#!python
\"\"\"Bootstra...sys.argv[1:])



" /user/ecs/downloads/...ols-0.6c11-py2.4.egg failed with error code 1


You know I don't know Python much - I'm usually more into C.
It seems that virtualenv doesn't work with my Python installation,
so I'll try to install Genshi et al manually there.

Have a nice day,
Berny


On Apr 20, 2:51 am, Jason Miller  wrote:
> Typo:
>
> trac-admin /some/path/trac initenv
> tracd --port 8000 /some/path/trac-project
>
> should be:
>
> trac-admin /some/path/trac initenv
> tracd --port 8000 /some/path/trac
>
> On Tue, Apr 19, 2011 at 6:46 PM, Jason Miller wrote:
>
>
>
> > OK, performed the following on a disconnected laptop running openSuSE 11.3
> > (sorry SLES is at work... and I am having a Guinness :) )
> > I highly recommend drinking a Guinness.
>
> > mkdir -p ~/dev/downloads ~/dev/bin ~/dev/lib/python2.6/site-packages
> > ~/dev/projects/TracProjectName
> > export PYTHONPATH=$HOME/dev/lib/python2.6/site-packages
> > cd ~/dev/downloads
> > curl -O
> >http://pypi.python.org/packages/source/v/virtualenv/virtualenv-1.6.ta
> > curl -Ohttp://ftp.edgewall.com/pub/genshi/Genshi-0.6.tar.gz.
> > curl -Ohttp://ftp.edgewall.com/pub/trac/Trac-0.12.2.tar.gz.
>
> > 
>
> > for i in *.tar.gz; do tar -xf $i; done
> > cd virtualenv-1.6
> > python ./setup.py install --prefix=$HOME/dev
> > ~/dev/bin/virtualenv ~/dev
> > . ~/dev/bin/activate
> > cd ~/dev/downloads/Genshi-0.6
> > python ./setup.py install
> > cd ~/dev/downloads/Trac-0.12.2
> > python ./setup.py install
>
> > I wrote those commands as I performed them, no modifications what so ever.
>
> > Once completed, you can copy the contents of
> > ~/dev/lib/python2.6/site-packages/*
> > to where ever your site-packages is located on the SLES machine.
> > (Obviously, python versions need to match, make changes where you need them)
> > You will also need to copy the ~/dev/bin/trac* to some system path. I used
> > /usr/bin
> > Also I noticed ~/dev/lib/python2.6/site-packages/setuptools.pth already
> > mentioned a system path. I ended up just using the exact line mentioned in
> > that file and duplicated it in my actual
> > /usr/lib/python2.6/site-packages/setuptools.pth file.
> > For your information:
>
> > (dev)user@triton:~/>lsb_realse -a
> > LSB Version:    n/a
> > Distributor ID:    SUSE LINUX
> > Description:    openSUSE 11.3 (x86_64)
> > Release:    11.3
> > Codename:    n/a
>
> > Anyways, once I had the virtual environment setup I performed the
> > following:
>
> > (exclude pth to not destroy any other egg you have installed)
> > sudo rsync -av --exclude '*.pth' ~/dev/lib/python2.6/site-packages/*
> > /usr/lib/python2.6/site-packages/
> > sudo chown -R root:root /usr/lib/python2.6/site-packages
> > sudo cp ~/dev/bin/trac* /usr/bin/
>
> > Edit the following file and add the Trac/Genshi egg:
>
> > sudo vi /usr/lib/python2.6/site-packages/easy-install.pth
> > #added the following:
> >   ./Trac-0.12.2-py2.6.egg
> >   ./Genshi-0.7dev_r1150-py2.6.egg
>
> > Edit the following file and made sure setuptools egg was correct:
>
> > sudo vi /usr/lib/python2.6/site-packages/setuptools.pth
> > # added the following (I actually had an older egg listed (as mentioned
> > above), but I noticed I just in-inadvertently upgraded... so I modified it:
> >   ./setuptools-0.6c12dev_r85381-py2.6.egg
>
> > Once this was all complete... I was able to create a new directory of my
> > chooseing, and perform a:
>
> > trac-admin /some

RE: [Trac] Help needed

[Saurav Sagar]

Yes I did..i tried to resync the repos folder then it worked fine for few 
moment and then it again started giving a new error as show below.
Python Traceback
Traceback (most recent call last):
  File "/usr/lib/python2.4/site-packages/trac/web/main.py", line 406, in 
dispatch_request
dispatcher.dispatch(req)
  File "/usr/lib/python2.4/site-packages/trac/web/main.py", line 191, in 
dispatch
chosen_handler = self._pre_process_request(req, chosen_handler)
  File "/usr/lib/python2.4/site-packages/trac/web/main.py", line 263, in 
_pre_process_request
chosen_handler = f.pre_process_request(req, chosen_handler)
  File "/usr/lib/python2.4/site-packages/trac/versioncontrol/api.py", line 73, 
in pre_process_request
self.get_repository(req.authname).sync()
  File "/usr/lib/python2.4/site-packages/trac/versioncontrol/cache.py", line 
175, in sync
for path,kind,action,bpath,brev in cset.get_changes():
  File "/usr/lib/python2.4/site-packages/trac/versioncontrol/svn_fs.py", line 
663, in get_changes
root = fs.revision_root(self.fs_ptr, self.rev, pool())
  File "/usr/lib/python2.4/site-packages/libsvn/fs.py", line 217, in 
svn_fs_revision_root
return apply(_fs.svn_fs_revision_root, args)
SubversionException: ('Revision file lacks trailing newline', 160004)

Can you please suggest something for this..

Regards,
Saurav Sagar

From: trac-users@googlegroups.com [mailto:trac-users@googlegroups.com] On 
Behalf Of Matthew Caron
Sent: Tuesday, April 19, 2011 5:59 PM
To: trac-users@googlegroups.com
Subject: Re: [Trac] Help needed


> This happened when I increased the size of the partition where the reos were 
> stored.

I presume you both increased the partition *and* the filesystem
inhabiting it.

Did you fsck the revised partition?

--
Matthew Caron
Build Engineer
Sixnet | www.sixnet.com
O +1 518 877 5173 Ext. 138
F +1 518 602 9209
matt.ca...@sixnet.com

--
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.



No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1209 / Virus Database: 1500/3583 - Release Date: 04/19/11

-- 
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] setup behind firewall

[Jason Miller]

Typo:

trac-admin /some/path/trac initenv
tracd --port 8000 /some/path/trac-project

should be:

trac-admin /some/path/trac initenv
tracd --port 8000 /some/path/trac




On Tue, Apr 19, 2011 at 6:46 PM, Jason Miller wrote:

> OK, performed the following on a disconnected laptop running openSuSE 11.3
> (sorry SLES is at work... and I am having a Guinness :) )
> I highly recommend drinking a Guinness.
>
> mkdir -p ~/dev/downloads ~/dev/bin ~/dev/lib/python2.6/site-packages
> ~/dev/projects/TracProjectName
> export PYTHONPATH=$HOME/dev/lib/python2.6/site-packages
> cd ~/dev/downloads
> curl -O
> http://pypi.python.org/packages/source/v/virtualenv/virtualenv-1.6.tar.gz.
> curl -O http://ftp.edgewall.com/pub/genshi/Genshi-0.6.tar.gz .
> curl -O http://ftp.edgewall.com/pub/trac/Trac-0.12.2.tar.gz .
>
> 
>
> for i in *.tar.gz; do tar -xf $i; done
> cd virtualenv-1.6
> python ./setup.py install --prefix=$HOME/dev
> ~/dev/bin/virtualenv ~/dev
> . ~/dev/bin/activate
> cd ~/dev/downloads/Genshi-0.6
> python ./setup.py install
> cd ~/dev/downloads/Trac-0.12.2
> python ./setup.py install
>
>
>
> I wrote those commands as I performed them, no modifications what so ever.
>
> Once completed, you can copy the contents of
> ~/dev/lib/python2.6/site-packages/*
> to where ever your site-packages is located on the SLES machine.
> (Obviously, python versions need to match, make changes where you need them)
> You will also need to copy the ~/dev/bin/trac* to some system path. I used
> /usr/bin
> Also I noticed ~/dev/lib/python2.6/site-packages/setuptools.pth already
> mentioned a system path. I ended up just using the exact line mentioned in
> that file and duplicated it in my actual
> /usr/lib/python2.6/site-packages/setuptools.pth file.
> For your information:
>
> (dev)user@triton:~/>lsb_realse -a
> LSB Version:n/a
> Distributor ID:SUSE LINUX
> Description:openSUSE 11.3 (x86_64)
> Release:11.3
> Codename:n/a
>
>
> Anyways, once I had the virtual environment setup I performed the
> following:
>
> (exclude pth to not destroy any other egg you have installed)
> sudo rsync -av --exclude '*.pth' ~/dev/lib/python2.6/site-packages/*
> /usr/lib/python2.6/site-packages/
> sudo chown -R root:root /usr/lib/python2.6/site-packages
> sudo cp ~/dev/bin/trac* /usr/bin/
>
> Edit the following file and add the Trac/Genshi egg:
>
> sudo vi /usr/lib/python2.6/site-packages/easy-install.pth
> #added the following:
>   ./Trac-0.12.2-py2.6.egg
>   ./Genshi-0.7dev_r1150-py2.6.egg
>
>
> Edit the following file and made sure setuptools egg was correct:
>
> sudo vi /usr/lib/python2.6/site-packages/setuptools.pth
> # added the following (I actually had an older egg listed (as mentioned
> above), but I noticed I just in-inadvertently upgraded... so I modified it:
>   ./setuptools-0.6c12dev_r85381-py2.6.egg
>
>
> Once this was all complete... I was able to create a new directory of my
> chooseing, and perform a:
>
> trac-admin /some/path/trac initenv
> tracd --port 8000 /some/path/trac-project
>
> Firefox http://localhost:8000/trac   > success. (you'll obviously want
> something different! (apache) I just like to use tracd as proof of concept)
>
> I really hope this helps! Though, I thank you regardless, as I learned a
> few things along the way.
>
> Jason
>
>
>
> On Tue, Apr 19, 2011 at 5:11 PM, Jason Miller wrote:
>
>> Well, if no outbound connections are allowed, I suppose one option would
>> be to build Trac the way you want it on a different machine. Then rsync the
>> data over.
>>
>> Namely the only item that you should have to rsync is the site-packages
>> folder. Then 'maybe' modify the easy-install.pth file (located inside
>> site-packages), if something got installed in a strange 'out-of-directory'
>> path.
>>
>> Your right in assuming that svn-checkouts/tarball-src downloads of each
>> requirement, should have resulted in a successful local install with out a
>> network connection.
>> If that doesn't work, then you may have to extract the setuptools.egg, and
>> hand-modify egg locations (if easy-install.pth modifications isn't enough).
>>
>> I'll have to attempt one and let you know if I was successful in a local
>> install, then transfer to another machine.  Be right back!
>>
>> Jason
>>
>> On Tue, Apr 19, 2011 at 8:09 AM, Voelker, Bernhard <
>> bernhard.voel...@siemens-enterprise.com> wrote:
>>
>>>  Hi Jason,
>>>
>>> thanks for the hints. However, as long as the installer tries to connect
>>> to the internet,
>>> it will cowardly fail: the machine is actually a virtual machine (SLES)
>>> in the DMZ of a corporate
>>> network. It's not permitted to make any new connections into the
>>> internet, also a proxy
>>> is missing. The only connection permitted is *from* the internet to a
>>> small set of TCP ports
>>> of that host.
>>>
>>> As babel is not strictly required, and as I manually installed genshi, I
>>> was expecting the
>>> "off-line" installation to succeed.
>>>
>>> BTW:
>>> `python ./setup.py --help` does that same 

Re: [Trac] setup behind firewall

[Jason Miller]

OK, performed the following on a disconnected laptop running openSuSE 11.3
(sorry SLES is at work... and I am having a Guinness :) )
I highly recommend drinking a Guinness.

mkdir -p ~/dev/downloads ~/dev/bin ~/dev/lib/python2.6/site-packages
~/dev/projects/TracProjectName
export PYTHONPATH=$HOME/dev/lib/python2.6/site-packages
cd ~/dev/downloads
curl -O
http://pypi.python.org/packages/source/v/virtualenv/virtualenv-1.6.tar.gz .
curl -O http://ftp.edgewall.com/pub/genshi/Genshi-0.6.tar.gz .
curl -O http://ftp.edgewall.com/pub/trac/Trac-0.12.2.tar.gz .



for i in *.tar.gz; do tar -xf $i; done
cd virtualenv-1.6
python ./setup.py install --prefix=$HOME/dev
~/dev/bin/virtualenv ~/dev
. ~/dev/bin/activate
cd ~/dev/downloads/Genshi-0.6
python ./setup.py install
cd ~/dev/downloads/Trac-0.12.2
python ./setup.py install



I wrote those commands as I performed them, no modifications what so ever.

Once completed, you can copy the contents of
~/dev/lib/python2.6/site-packages/*
to where ever your site-packages is located on the SLES machine. (Obviously,
python versions need to match, make changes where you need them)
You will also need to copy the ~/dev/bin/trac* to some system path. I used
/usr/bin
Also I noticed ~/dev/lib/python2.6/site-packages/setuptools.pth already
mentioned a system path. I ended up just using the exact line mentioned in
that file and duplicated it in my actual
/usr/lib/python2.6/site-packages/setuptools.pth file.
For your information:

(dev)user@triton:~/>lsb_realse -a
LSB Version:n/a
Distributor ID:SUSE LINUX
Description:openSUSE 11.3 (x86_64)
Release:11.3
Codename:n/a


Anyways, once I had the virtual environment setup I performed the following:

(exclude pth to not destroy any other egg you have installed)
sudo rsync -av --exclude '*.pth' ~/dev/lib/python2.6/site-packages/*
/usr/lib/python2.6/site-packages/
sudo chown -R root:root /usr/lib/python2.6/site-packages
sudo cp ~/dev/bin/trac* /usr/bin/

Edit the following file and add the Trac/Genshi egg:

sudo vi /usr/lib/python2.6/site-packages/easy-install.pth
#added the following:
  ./Trac-0.12.2-py2.6.egg
  ./Genshi-0.7dev_r1150-py2.6.egg


Edit the following file and made sure setuptools egg was correct:

sudo vi /usr/lib/python2.6/site-packages/setuptools.pth
# added the following (I actually had an older egg listed (as mentioned
above), but I noticed I just in-inadvertently upgraded... so I modified it:
  ./setuptools-0.6c12dev_r85381-py2.6.egg


Once this was all complete... I was able to create a new directory of my
chooseing, and perform a:

trac-admin /some/path/trac initenv
tracd --port 8000 /some/path/trac-project

Firefox http://localhost:8000/trac   > success. (you'll obviously want
something different! (apache) I just like to use tracd as proof of concept)

I really hope this helps! Though, I thank you regardless, as I learned a few
things along the way.

Jason


On Tue, Apr 19, 2011 at 5:11 PM, Jason Miller wrote:

> Well, if no outbound connections are allowed, I suppose one option would be
> to build Trac the way you want it on a different machine. Then rsync the
> data over.
>
> Namely the only item that you should have to rsync is the site-packages
> folder. Then 'maybe' modify the easy-install.pth file (located inside
> site-packages), if something got installed in a strange 'out-of-directory'
> path.
>
> Your right in assuming that svn-checkouts/tarball-src downloads of each
> requirement, should have resulted in a successful local install with out a
> network connection.
> If that doesn't work, then you may have to extract the setuptools.egg, and
> hand-modify egg locations (if easy-install.pth modifications isn't enough).
>
> I'll have to attempt one and let you know if I was successful in a local
> install, then transfer to another machine.  Be right back!
>
> Jason
>
> On Tue, Apr 19, 2011 at 8:09 AM, Voelker, Bernhard <
> bernhard.voel...@siemens-enterprise.com> wrote:
>
>>  Hi Jason,
>>
>> thanks for the hints. However, as long as the installer tries to connect
>> to the internet,
>> it will cowardly fail: the machine is actually a virtual machine (SLES) in
>> the DMZ of a corporate
>> network. It's not permitted to make any new connections into the internet,
>> also a proxy
>> is missing. The only connection permitted is *from* the internet to a
>> small set of TCP ports
>> of that host.
>>
>> As babel is not strictly required, and as I manually installed genshi, I
>> was expecting the
>> "off-line" installation to succeed.
>>
>> BTW:
>> `python ./setup.py --help` does that same as `... install`:
>>
>> $ lsof -p 19738
>> COMMAND   PID USER   FD   TYPE   DEVICESIZENODE NAME
>> python  19738  ecs  cwdDIR253,14096 2146487
>> /user/ecs/berny/depot/trac-0.12.2
>> python  19738  ecs  rtdDIR  8,34096   2 /
>> python  19738  ecs  txtREG  8,55320  208996 /usr/bin/python2.4
>> ...
>> python  19738  ecs0u   CHR136,3   5 /dev/pts/3
>> pyth

Re: [Trac] setup behind firewall

[Jason Miller]

Well, if no outbound connections are allowed, I suppose one option would be
to build Trac the way you want it on a different machine. Then rsync the
data over.

Namely the only item that you should have to rsync is the site-packages
folder. Then 'maybe' modify the easy-install.pth file (located inside
site-packages), if something got installed in a strange 'out-of-directory'
path.

Your right in assuming that svn-checkouts/tarball-src downloads of each
requirement, should have resulted in a successful local install with out a
network connection.
If that doesn't work, then you may have to extract the setuptools.egg, and
hand-modify egg locations (if easy-install.pth modifications isn't enough).

I'll have to attempt one and let you know if I was successful in a local
install, then transfer to another machine.  Be right back!

Jason

On Tue, Apr 19, 2011 at 8:09 AM, Voelker, Bernhard <
bernhard.voel...@siemens-enterprise.com> wrote:

>  Hi Jason,
>
> thanks for the hints. However, as long as the installer tries to connect to
> the internet,
> it will cowardly fail: the machine is actually a virtual machine (SLES) in
> the DMZ of a corporate
> network. It's not permitted to make any new connections into the internet,
> also a proxy
> is missing. The only connection permitted is *from* the internet to a small
> set of TCP ports
> of that host.
>
> As babel is not strictly required, and as I manually installed genshi, I
> was expecting the
> "off-line" installation to succeed.
>
> BTW:
> `python ./setup.py --help` does that same as `... install`:
>
> $ lsof -p 19738
> COMMAND   PID USER   FD   TYPE   DEVICESIZENODE NAME
> python  19738  ecs  cwdDIR253,14096 2146487
> /user/ecs/berny/depot/trac-0.12.2
> python  19738  ecs  rtdDIR  8,34096   2 /
> python  19738  ecs  txtREG  8,55320  208996 /usr/bin/python2.4
> ...
> python  19738  ecs0u   CHR136,3   5 /dev/pts/3
> python  19738  ecs1u   CHR136,3   5 /dev/pts/3
> python  19738  ecs2u   CHR136,3   5 /dev/pts/3
> python  19738  ecs3u  IPv4 43469727 TCP
> ecs.siemens-enterprise.com:33262->pypi.python.org:http (SYN_SENT)
> ... --help doesn't print the usage.
>  Also --verbose doesn't make a difference.
>
> Thanks for your help.
>
> Have a nice day,
> Berny
>
>
>
>
>  --
> *From:* trac-users@googlegroups.com [mailto:trac-users@googlegroups.com] *On
> Behalf Of *Jason Miller
> *Sent:* Tuesday, April 19, 2011 3:16 PM
> *To:* trac-users@googlegroups.com
> *Subject:* Re: [Trac] setup behind firewall
>
>   Out bound connections are made across the HTTP and HTTPS
> protocol. Not sure as to why your DMZ would be blocking that.
> In fact, a DMZ 'should' be firewall free.
>
> Not that this 'should' matter, but have you prepended the 'python'
> interpreter before your commands? :  python ./setup.py install
>
> Still... what happens when you manually svn co
> http:// from the same machine?
>
> Does the DMZ employ a proxy maybe?
>
> What happens when you use: easy_install babel  (I noticed
> you havn't installed babel yet, might as well try through easy_install)
>
> Is this an appliance specific machine with a custom linux flavor
> installed on it? (not exactly a PC, but a product designed to do
> something else like one of these ugly things:
> http://www.landesk.com/docs/manuals/590694501B_screen.pdf)
> I know I have had my fair share of getting one of those working the
> way "WE" wanted. And installing Trac on it, would definitely qualify.
>
> does: dig edgewall.org  return the correct IP address of 88.198.140.129?
>
> Odd bud, and being in the DMZ makes it odder still. You should have no
> firewall/connectivity issues at all. And as for a verbose option yes:
> python ./setup.py --verbose
> FYI, you can see the whole list by doing the following in your 
> location:
>
> python ./setup.py --help
>
> Good luck, let us know what happens!
>
> Jason
>
>
> On Tue, Apr 19, 2011 at 3:09 AM, Voelker, Bernhard <
> bernhard.voel...@siemens-enterprise.com> wrote:
>
>> Hi *,
>>
>> I have problems installing 0.12.2 behind a firewall (in a DMZ).
>> I have installed setuptools and genshi and added them to the PYTHONPATH:
>>
>> $
>> PYTHONPATH=$PYTHONPATH:/user/ecs/opt/setuptools-0.6c11/lib/python2.4/site-packages
>> $
>> PYTHONPATH=$PYTHONPATH:/user/ecs/opt/genshi-0.6/lib64/python2.4/site-packages
>>
>> The setuptools fail (after the firewall timeout) here:
>>
>> $ ./setup.py install --prefix=/user/ecs/opt/trac-0.12.2
>> Download error: (97, 'Address family not supported by protocol') -- Some
>> packages may not be found!
>> Couldn't find index page for 'Genshi' (maybe misspelled?)
>> Download error: (97, 'Address family not supported by protocol') -- Some
>> packages may not be found!
>> No local packages or download links found for Genshi>=0.6
>> Traceback (most recent call last):
>>  File "./setup.py", line 110, in ?
>>entry_points = """

[Trac] Re: Fun with SQLite Manager

[David S]

Chris,

Is this done via the sqlite-manager plugin on Firefox. Or was that a
command line example?

On Apr 18, 6:30 pm, Chris Mulligan  wrote:
> The SQL to do this is pretty easy.
>
> It should work just fine to do it in production, but to be safe you might 
> bring down apache/tracd/whatever so there's no locking contention. If you 
> just want to delete the comments from a specific author on a specific ticket:
>
> delete from ticket_change where ticket = 1700 and field = "comment" and 
> author="davids";
>
> On Apr 18, 2011, at 1:56 PM, David S wrote:
>
> > Ok, now that I've finally have two newly created projects working I'd
> > figure I'd learn on how SQLite Manager works. I've been tasked with
> > either removing a ticket complete (say, ticket #1700) or finding a way
> > to remove a comment that exist within ticket #1700. Is the second
> > option possible or is it better just to delete ticket #1700?
>
> > My question is, is there a problem with removing #1700 on an active
> > Trac db? Currently we're up to 1750 and growing and here I am messing
> > around with ticket #1700! :( Will the db know that #1700 is removed
> > and just keep a "blank" entry for a non-existent #1700 if I choose to
> > delete it (on an active db).
>
> > I'd rather just remove the comment within the ticket rather than
> > remove the whole ticket number, if possible.
>
> > Also, what field do I look for when using the SQLite Manger on the
> > Tables column when I decided on either removing the "comment" or the
> > whole "ticket number?"
>
> > id
> > name
> > source
> > target
> > tempPath
> > startTime
> > endtime
> > state
>
> > Above are just a few example fields I found in the moz_downloads table
> > for downloads.sqlite db. And since I don't have SQLite installed yet
> > on our Trac clients I'm just using the downloads.sqlite as an
> > example.
>
> > --
> > 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 
> > athttp://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-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] setup behind firewall

[Voelker, Bernhard]

Hi Jason,

thanks for the hints. However, as long as the installer tries to connect to the 
internet,
it will cowardly fail: the machine is actually a virtual machine (SLES) in the 
DMZ of a corporate
network. It's not permitted to make any new connections into the internet, also 
a proxy
is missing. The only connection permitted is *from* the internet to a small set 
of TCP ports
of that host.

As babel is not strictly required, and as I manually installed genshi, I was 
expecting the
"off-line" installation to succeed.

BTW:
`python ./setup.py --help` does that same as `... install`:

$ lsof -p 19738
COMMAND   PID USER   FD   TYPE   DEVICESIZENODE NAME
python  19738  ecs  cwdDIR253,14096 2146487 
/user/ecs/berny/depot/trac-0.12.2
python  19738  ecs  rtdDIR  8,34096   2 /
python  19738  ecs  txtREG  8,55320  208996 /usr/bin/python2.4
...
python  19738  ecs0u   CHR136,3   5 /dev/pts/3
python  19738  ecs1u   CHR136,3   5 /dev/pts/3
python  19738  ecs2u   CHR136,3   5 /dev/pts/3
python  19738  ecs3u  IPv4 43469727 TCP 
ecs.siemens-enterprise.com:33262->pypi.python.org:http (SYN_SENT)
... --help doesn't print the usage.
Also --verbose doesn't make a difference.

Thanks for your help.

Have a nice day,
Berny





From: trac-users@googlegroups.com [mailto:trac-users@googlegroups.com] On 
Behalf Of Jason Miller
Sent: Tuesday, April 19, 2011 3:16 PM
To: trac-users@googlegroups.com
Subject: Re: [Trac] setup behind firewall

Out bound connections are made across the HTTP and HTTPS
protocol. Not sure as to why your DMZ would be blocking that.
In fact, a DMZ 'should' be firewall free.

Not that this 'should' matter, but have you prepended the 'python'
interpreter before your commands? :  python ./setup.py install

Still... what happens when you manually svn co
http:// from the same machine?

Does the DMZ employ a proxy maybe?

What happens when you use: easy_install babel  (I noticed
you havn't installed babel yet, might as well try through easy_install)

Is this an appliance specific machine with a custom linux flavor
installed on it? (not exactly a PC, but a product designed to do
something else like one of these ugly things:
http://www.landesk.com/docs/manuals/590694501B_screen.pdf)
I know I have had my fair share of getting one of those working the
way "WE" wanted. And installing Trac on it, would definitely qualify.

does: dig edgewall.org  return the correct IP address of 
88.198.140.129?

Odd bud, and being in the DMZ makes it odder still. You should have no
firewall/connectivity issues at all. And as for a verbose option yes:
python ./setup.py --verbose
FYI, you can see the whole list by doing the following in your 
location:

python ./setup.py --help

Good luck, let us know what happens!

Jason


On Tue, Apr 19, 2011 at 3:09 AM, Voelker, Bernhard 
mailto:bernhard.voel...@siemens-enterprise.com>>
 wrote:
Hi *,

I have problems installing 0.12.2 behind a firewall (in a DMZ).
I have installed setuptools and genshi and added them to the PYTHONPATH:

$ 
PYTHONPATH=$PYTHONPATH:/user/ecs/opt/setuptools-0.6c11/lib/python2.4/site-packages
$ PYTHONPATH=$PYTHONPATH:/user/ecs/opt/genshi-0.6/lib64/python2.4/site-packages

The setuptools fail (after the firewall timeout) here:

$ ./setup.py install --prefix=/user/ecs/opt/trac-0.12.2
Download error: (97, 'Address family not supported by protocol') -- Some 
packages may not be found!
Couldn't find index page for 'Genshi' (maybe misspelled?)
Download error: (97, 'Address family not supported by protocol') -- Some 
packages may not be found!
No local packages or download links found for Genshi>=0.6
Traceback (most recent call last):
 File "./setup.py", line 110, in ?
   entry_points = """
 File "/usr/lib64/python2.4/distutils/core.py", line 110, in setup
   _setup_distribution = dist = klass(attrs)
 File 
"/user/ecs/opt/setuptools-0.6c11/lib/python2.4/site-packages/setuptools-0.6c11-py2.4.egg/setuptools/dist.py",
 line 260, in __init__
   self.fetch_build_eggs(attrs.pop('setup_requires'))
 File 
"/user/ecs/opt/setuptools-0.6c11/lib/python2.4/site-packages/setuptools-0.6c11-py2.4.egg/setuptools/dist.py",
 line 283, in fetch_build_eggs
   for dist in working_set.resolve(
 File 
"/user/ecs/opt/setuptools-0.6c11/lib/python2.4/site-packages/setuptools-0.6c11-py2.4.egg/pkg_resources.py",
 line 563, in resolve
   dist = best[req.key] = env.best_match(req, self, installer)
 File 
"/user/ecs/opt/setuptools-0.6c11/lib/python2.4/site-packages/setuptools-0.6c11-py2.4.egg/pkg_resources.py",
 line 799, in best_match
   return self.obtain(req, installer) # try and download/install
 File 
"/user/ecs/opt/setuptools-0.6c11/lib/python2.4/site-packages/setuptools-0.6c11-py2.4.egg/pkg_resources.py",
 line 811, in obtain
   return installer(requirement)
 File 
"/user/ecs/opt/setuptools-0.6c11/lib/python2.4/site-packages/set

Re: [Trac] setup behind firewall

[Jason Miller]

Out bound connections are made across the HTTP and HTTPS
protocol. Not sure as to why your DMZ would be blocking that.
In fact, a DMZ 'should' be firewall free.

Not that this 'should' matter, but have you prepended the 'python'
interpreter before your commands? :  python ./setup.py install

Still... what happens when you manually svn co
http:// from the same machine?

Does the DMZ employ a proxy maybe?

What happens when you use: easy_install babel  (I noticed
you havn't installed babel yet, might as well try through easy_install)

Is this an appliance specific machine with a custom linux flavor
installed on it? (not exactly a PC, but a product designed to do
something else like one of these ugly things:
http://www.landesk.com/docs/manuals/590694501B_screen.pdf)
I know I have had my fair share of getting one of those working the
way "WE" wanted. And installing Trac on it, would definitely qualify.

does: dig edgewall.org  return the correct IP address of 88.198.140.129?

Odd bud, and being in the DMZ makes it odder still. You should have no
firewall/connectivity issues at all. And as for a verbose option yes:
python ./setup.py --verbose
FYI, you can see the whole list by doing the following in your 
location:

python ./setup.py --help

Good luck, let us know what happens!

Jason


On Tue, Apr 19, 2011 at 3:09 AM, Voelker, Bernhard <
bernhard.voel...@siemens-enterprise.com> wrote:

> Hi *,
>
> I have problems installing 0.12.2 behind a firewall (in a DMZ).
> I have installed setuptools and genshi and added them to the PYTHONPATH:
>
> $
> PYTHONPATH=$PYTHONPATH:/user/ecs/opt/setuptools-0.6c11/lib/python2.4/site-packages
> $
> PYTHONPATH=$PYTHONPATH:/user/ecs/opt/genshi-0.6/lib64/python2.4/site-packages
>
> The setuptools fail (after the firewall timeout) here:
>
> $ ./setup.py install --prefix=/user/ecs/opt/trac-0.12.2
> Download error: (97, 'Address family not supported by protocol') -- Some
> packages may not be found!
> Couldn't find index page for 'Genshi' (maybe misspelled?)
> Download error: (97, 'Address family not supported by protocol') -- Some
> packages may not be found!
> No local packages or download links found for Genshi>=0.6
> Traceback (most recent call last):
>  File "./setup.py", line 110, in ?
>entry_points = """
>  File "/usr/lib64/python2.4/distutils/core.py", line 110, in setup
>_setup_distribution = dist = klass(attrs)
>  File
> "/user/ecs/opt/setuptools-0.6c11/lib/python2.4/site-packages/setuptools-0.6c11-py2.4.egg/setuptools/dist.py",
> line 260, in __init__
>self.fetch_build_eggs(attrs.pop('setup_requires'))
>  File
> "/user/ecs/opt/setuptools-0.6c11/lib/python2.4/site-packages/setuptools-0.6c11-py2.4.egg/setuptools/dist.py",
> line 283, in fetch_build_eggs
>for dist in working_set.resolve(
>  File
> "/user/ecs/opt/setuptools-0.6c11/lib/python2.4/site-packages/setuptools-0.6c11-py2.4.egg/pkg_resources.py",
> line 563, in resolve
>dist = best[req.key] = env.best_match(req, self, installer)
>  File
> "/user/ecs/opt/setuptools-0.6c11/lib/python2.4/site-packages/setuptools-0.6c11-py2.4.egg/pkg_resources.py",
> line 799, in best_match
>return self.obtain(req, installer) # try and download/install
>  File
> "/user/ecs/opt/setuptools-0.6c11/lib/python2.4/site-packages/setuptools-0.6c11-py2.4.egg/pkg_resources.py",
> line 811, in obtain
>return installer(requirement)
>  File
> "/user/ecs/opt/setuptools-0.6c11/lib/python2.4/site-packages/setuptools-0.6c11-py2.4.egg/setuptools/dist.py",
> line 327, in fetch_build_egg
>return cmd.easy_install(req)
>  File
> "/user/ecs/opt/setuptools-0.6c11/lib/python2.4/site-packages/setuptools-0.6c11-py2.4.egg/setuptools/command/easy_install.py",
> line 434, in easy_install
>self.local_index
>  File
> "/user/ecs/opt/setuptools-0.6c11/lib/python2.4/site-packages/setuptools-0.6c11-py2.4.egg/setuptools/package_index.py",
> line 475, in fetch_distribution
>return dist.clone(location=self.download(dist.location, tmpdir))
> AttributeError: 'NoneType' object has no attribute 'clone'
>
> Before I installed Genshi, it said that it tries to download Genshi,
> but now it sits waiting for the firewall timeout - I don't have a
> clue what it's trying to do at this point. Is there something like
> "--verbose"?
>
> Any ideas?
>
> Have a nice day,
> Berny
>
> --
> 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.
>
>

-- 
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-use

Re: [Trac] Help needed

[Matthew Caron]

This happened when I increased the size of the partition where the reos were 
stored.


I presume you both increased the partition *and* the filesystem 
inhabiting it.


Did you fsck the revised partition?

--
Matthew Caron
Build Engineer
Sixnet | www.sixnet.com
O +1 518 877 5173 Ext. 138
F +1 518 602 9209
matt.ca...@sixnet.com

--
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] Relational Tickets Priority

[Cooke, Mark]

> -Original Message-
> From: trac-users@googlegroups.com On Behalf Of Arthur Flores Duarte
> Sent: 18 April 2011 23:10
> To: Trac Users
> Subject: [Trac] Relational Tickets Priority
> 
> Greetings,
> 
> I searched at the FAQ and in the mailing list and I didn't find a
> answer for my doubt, but I think that should be a very common one.
> 
> I've been working with Trac for some years, but this week appeared a
> new need, and I wonder if I can apply this with Trac.
> 
> I need to report the tickets ordered by priority.
> 
> For example, in a report, ticket #100 is more important than #82, that
> is more important than #112, that is more important than #110, and so
> it goes...
> 
> I don't know if "Priority" is the propper field to order this report,
> because it just have some values, and I don't wanna to create a value
> for
> each ticket.
> 
> Thanks for the attention
> 
You could try relating the tickets using a plugin such as the
MasterTicketsPlugin:
http://trac-hacks.org/wiki/MasterTicketsPlugin

~ 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.

RE: [Trac] changeset url not working

[Cooke, Mark]

> -Original Message-
> From: trac-users@googlegroups.com On Behalf Of Marc Simonin
> Sent: 18 April 2011 10:49
> To: trac-users@googlegroups.com
> Subject: [Trac] changeset url not working
> 
> Hello
> 
> I recently migrate from trac 0.11 to trac 0.12.2
> 
> I have one trac server, with two trac environnements (each 
> connect to one different subversion repo)
> The apache2 server use mod_python and the "TracEnvParentDir" 
> option to choose between one or another trac.
> 
> I can do everything (browse repo, add/view tickets, etc) 
> except acces the /changeset url. As it happens on only one
> of the two instances, I assume the installation is correct.
> 
> The only error I got is "No handler matched request to 
> /changeset", when accessing a /changet url
> 
> Do you have some ideas ?
> 
> By the way, i tried to have some debug output, but with no 
> success for now.
> 
> Regards,
> Marc Simonin
> 
0.12 includes support for multiple repositories.  What do you see when
you nivaigate to:-

Admin > Version control > Repositories

...for each of your two environments?

~ mark c

P.S. mod_python is deprecated, if you are making changes, check out
mod_wsgi instead:-
http://trac.edgewall.org/wiki/TracModWSGI

-- 
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] changeset url not working

[Marc Simonin]

Hello

I recently migrate from trac 0.11 to trac 0.12.2

I have one trac server, with two trac environnements (each connect to one
different
subversion repo)
The apache2 server use mod_python and the "TracEnvParentDir" option to
choose
between one or another trac.

I can do everything (browse repo, add/view tickets, etc) except acces the
/changeset url. As it happens on only one of the two instances, I assume the
installation
is correct.

The only error I got is "No handler matched request to /changeset", when
accessing a /changet url

Do you have some ideas ?

By the way, i tried to have some debug output, but with no success for now.

Regards,
Marc Simonin


-- 
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] setup behind firewall

[Voelker, Bernhard]

Hi *,

I have problems installing 0.12.2 behind a firewall (in a DMZ).
I have installed setuptools and genshi and added them to the PYTHONPATH:

$ 
PYTHONPATH=$PYTHONPATH:/user/ecs/opt/setuptools-0.6c11/lib/python2.4/site-packages
$ PYTHONPATH=$PYTHONPATH:/user/ecs/opt/genshi-0.6/lib64/python2.4/site-packages

The setuptools fail (after the firewall timeout) here:

$ ./setup.py install --prefix=/user/ecs/opt/trac-0.12.2
Download error: (97, 'Address family not supported by protocol') -- Some 
packages may not be found!
Couldn't find index page for 'Genshi' (maybe misspelled?)
Download error: (97, 'Address family not supported by protocol') -- Some 
packages may not be found!
No local packages or download links found for Genshi>=0.6
Traceback (most recent call last):
  File "./setup.py", line 110, in ?
entry_points = """
  File "/usr/lib64/python2.4/distutils/core.py", line 110, in setup
_setup_distribution = dist = klass(attrs)
  File 
"/user/ecs/opt/setuptools-0.6c11/lib/python2.4/site-packages/setuptools-0.6c11-py2.4.egg/setuptools/dist.py",
 line 260, in __init__
self.fetch_build_eggs(attrs.pop('setup_requires'))
  File 
"/user/ecs/opt/setuptools-0.6c11/lib/python2.4/site-packages/setuptools-0.6c11-py2.4.egg/setuptools/dist.py",
 line 283, in fetch_build_eggs
for dist in working_set.resolve(
  File 
"/user/ecs/opt/setuptools-0.6c11/lib/python2.4/site-packages/setuptools-0.6c11-py2.4.egg/pkg_resources.py",
 line 563, in resolve
dist = best[req.key] = env.best_match(req, self, installer)
  File 
"/user/ecs/opt/setuptools-0.6c11/lib/python2.4/site-packages/setuptools-0.6c11-py2.4.egg/pkg_resources.py",
 line 799, in best_match
return self.obtain(req, installer) # try and download/install
  File 
"/user/ecs/opt/setuptools-0.6c11/lib/python2.4/site-packages/setuptools-0.6c11-py2.4.egg/pkg_resources.py",
 line 811, in obtain
return installer(requirement)
  File 
"/user/ecs/opt/setuptools-0.6c11/lib/python2.4/site-packages/setuptools-0.6c11-py2.4.egg/setuptools/dist.py",
 line 327, in fetch_build_egg
return cmd.easy_install(req)
  File 
"/user/ecs/opt/setuptools-0.6c11/lib/python2.4/site-packages/setuptools-0.6c11-py2.4.egg/setuptools/command/easy_install.py",
 line 434, in easy_install
self.local_index
  File 
"/user/ecs/opt/setuptools-0.6c11/lib/python2.4/site-packages/setuptools-0.6c11-py2.4.egg/setuptools/package_index.py",
 line 475, in fetch_distribution
return dist.clone(location=self.download(dist.location, tmpdir))
AttributeError: 'NoneType' object has no attribute 'clone'

Before I installed Genshi, it said that it tries to download Genshi,
but now it sits waiting for the firewall timeout - I don't have a
clue what it's trying to do at this point. Is there something like
"--verbose"?

Any ideas?

Have a nice day,
Berny

-- 
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] Help needed

[Saurav Sagar]

Guys please help me resolve the trc error below:
Python Traceback
Traceback (most recent call last):
  File "/usr/lib/python2.4/site-packages/trac/web/main.py", line 406, in 
dispatch_request
dispatcher.dispatch(req)
  File "/usr/lib/python2.4/site-packages/trac/web/main.py", line 191, in 
dispatch
chosen_handler = self._pre_process_request(req, chosen_handler)
  File "/usr/lib/python2.4/site-packages/trac/web/main.py", line 263, in 
_pre_process_request
chosen_handler = f.pre_process_request(req, chosen_handler)
  File "/usr/lib/python2.4/site-packages/trac/versioncontrol/api.py", line 73, 
in pre_process_request
self.get_repository(req.authname).sync()
  File "/usr/lib/python2.4/site-packages/trac/versioncontrol/cache.py", line 
175, in sync
for path,kind,action,bpath,brev in cset.get_changes():
  File "/usr/lib/python2.4/site-packages/trac/versioncontrol/svn_fs.py", line 
666, in get_changes
repos.svn_repos_replay(root, e_ptr, e_baton, pool())
  File "/usr/lib/python2.4/site-packages/libsvn/repos.py", line 230, in 
svn_repos_replay
return apply(_repos.svn_repos_replay, args)
  File "/usr/lib/python2.4/site-packages/svn/repos.py", line 113, in 
delete_entry
if _fs.is_dir(self._get_root(parent_baton[2]), base_path):
  File "/usr/lib/python2.4/site-packages/libsvn/fs.py", line 351, in 
svn_fs_is_dir
return apply(_fs.svn_fs_is_dir, args)
SubversionException: ("Reference to non-existent node 'a82.0.r6864/1851' in 
filesystem '/var/data/projects/svn/project/db'", 160014)

This happened when I increased the size of the partition where the reos were 
stored.

-- 
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] Relational Tickets Priority

[Arthur Flores Duarte]

Greetings,

I searched at the FAQ and in the mailing list and I didn't find a
answer for my doubt, but I think that should be a very common one.

I've been working with Trac for some years, but this week appeared a
new need, and I wonder if I can apply this with Trac.

I need to report the tickets ordered by priority.

For example, in a report, ticket #100 is more important than #82, that
is more important than #112, that is more important than #110, and so
it goes...

I don't know if "Priority" is the propper field to order this report,
because it just have some values, and I don't wanna to create a value
for
each ticket.

Thanks for the attention

-- 
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.