[Trac] Few questions regarding software version

[Ala Maison]

Hi all,

We have a trac server but it's been abandoned for a long time and we would
like to "restart" it but on an other server.
Since i never used it myself, i don't know the first thing about this
software, how can i know what version of trac is running on the server.
And most importantly, is it possible to take all running tickets and
archived ones to the new server without loosing any datas in the process ?
Sorry for my bad english,

[Matthew Caron]

Post by Ala Maison
Hi all,
We have a trac server but it's been abandoned for a long time and we
would like to "restart" it but on an other server.
Since i never used it myself, i don't know the first thing about this
software, how can i know what version of trac is running on the server.

It should tell you in the bottom of every trac page, left hand side,
right by the "trac powered" logo. It will say "Powered by Trac", and
then some version.

Post by Ala Maison
And most importantly, is it possible to take all running tickets and
archived ones to the new server without loosing any datas in the process ?

Yes. Generally, what you want to do is:
1. Move all the trac project storage (the files on disk)
2. Move all the database bits

How to do this depends specifically on how your system is set up. I
would suggest:

1. Locate your trac.ini. Generally, the directory in which it exists
is the trac data directory. You want this.
2. Read through the trac.ini, and see if you can find out what
database it's using. If it's sqlite, just copy that over. If it's MySQL
or PostgreSQL, then you'll need to dump the database contents and move
that (consult the appropriate DB docs on how to do this).

Post by Ala Maison
Sorry for my bad english,

It's not so bad.
--
Matthew Caron, Software Build Engineer
Red Lion Controls | www.redlion.net
[phone] x138 office

[Ala Maison]

Hello Matthew,

Thanks a lot, for both the technical advices and for saying that my english
isn't so bad ;)
I'll try that as soon as i can

cheers

[Ala Maison]

One more thing, if i want to transfer my trac serv and update it to current
version, what should i do 1st, the transfer or the update ?

[Matthew Caron]

Post by Ala Maison
One more thing, if i want to transfer my trac serv and update it to
current version, what should i do 1st, the transfer or the update ?

Well, we didn't discuss any updates, because all you've done is transfer
the data. The trac version will be whatever it is you've installed on
the new server, and it will likely complain that the DB needs an
upgrade, so you need to do that. Then you'll need to correct or replace
any plugins which no longer work.
--
Matthew Caron, Software Build Engineer
Red Lion Controls | www.redlion.net
[phone] x138 office

[Ala Maison]

So just to see if i got this,
I install trac on the new serv, do the transfer and then i update or delete
content that requires either "option" ?

[Matthew Caron]

Post by Ala Maison
So just to see if i got this,
I install trac on the new serv, do the transfer and then i update or
delete content that requires either "option" ?

I don't understand what you mean by this question.
--
Matthew Caron, Software Build Engineer
Red Lion Controls | www.redlion.net
[phone] x138 office

[Ala Maison]

It is just a recap of what i have to do in order to install trac on a new
serv without loosing all tickets. And to be more specific in what order i
have to do all the steps you told me.

1- install trac on new serv

2- move trac from old to new server machine

3- upgrade whatever needs to be updated

is this the right order ??

[Matthew Caron]

Post by Ala Maison
It is just a recap of what i have to do in order to install trac on a
new serv without loosing all tickets. And to be more specific in what
order i have to do all the steps you told me.
1- install trac on new serv
2- move trac from old to new server machine
3- upgrade whatever needs to be updated
is this the right order ??

Yes, and, if you notice - you still have the copy on the old server. So,
even if you mess it up, you can start over, as long as you don't change
anything on the old server.
--
Matthew Caron, Software Build Engineer
Red Lion Controls | www.redlion.net
[phone] x138 office

[Ala Maison]

Ok, thanks for all your answers, i'll try this out tomorrow.

[Ala Maison]

Hello,
Sorry for these probably dumb questions but i'm way out of my comfort zone
with this and i don't want to mess the existing and working original
server...
the "trac" folder contains 4 directories but only for plugins so no
projects of any kind :/
I can't find any trac.ini file neither any data files, just the plugins....
there is a sqlite_trac.sql file so i guess that's the one i'll need to move
later on...

is it possible that the project files could be stored somewhere else in the
company network ? (please say no, please say no...:p)

[Matthew Caron]

Post by Ala Maison
Hello,
Sorry for these probably dumb questions but i'm way out of my comfort
zone with this and i don't want to mess the existing and working
original server...
the "trac" folder contains 4 directories but only for plugins so no
projects of any kind :/

Assuming Linux (not sure if you stated what the host OS was or not)?

Can you paste in the result of ls -l for that dir?

(or, possibly, attach the output of tree run from that dir?)

That would help us find what we're dealing with.

Post by Ala Maison
I can't find any trac.ini file neither any data files, just the plugins....
there is a sqlite_trac.sql file so i guess that's the one i'll need to
move later on...

Have you tried:

locate trac.ini

?

It may be in another directory.

Post by Ala Maison
is it possible that the project files could be stored somewhere else in
the company network ? (please say no, please say no...:p)

Well, that depends on if you've network mounted some volume or not.

You could also try looking in the apache config (or subconfig if you
have it broken up by site), specifically DocumentRoot and ScriptAlias lines.
--
Matthew Caron, Software Build Engineer
Red Lion Controls | www.redlion.net
[phone] x138 office

[Ala Maison]

You RULE !!! I used the find command, didn't find anything... locate did
the job perfectly

My trac directory seems to be in /var/lib/trac, i found the projects and
everything so i'll try to copy stuff on the new serv and then i'll try this
out.

The trac version on the old server is 0.10, i hope i will be able to update
and make it work, new to trac, new to python, new to network
troubleshooting... thanks a lot !!!

Now i have to set up the new apache serve, new to this too :D

Thanks again

[Matthew Caron]

Post by Ala Maison
You RULE !!! I used the find command, didn't find anything... locate did
the job perfectly

Find recurses from where you start on down. Locate builds an index of
all files on disk (nightly, IIRC), then searches that. They each have
their uses.

Post by Ala Maison
My trac directory seems to be in /var/lib/trac, i found the projects and
everything so i'll try to copy stuff on the new serv and then i'll try
this out.

Sounds like a plan.

Post by Ala Maison
The trac version on the old server is 0.10, i hope i will be able to
update and make it work, new to trac, new to python, new to network
troubleshooting... thanks a lot !!!

There's no substitute for immersion.

Post by Ala Maison
Now i have to set up the new apache serve, new to this too :D

If you're on something debian-ish (and possibly others), the key is to
put config fragments in /etc/apache2/sites-available, then enable them
with a2ensite sitename.

You may find my collection of notes of use in your journey of learning:

https://github.com/mattcaron/misc_notes

I'm a compulsive documenter, and this has gotten worse over time (as in,
the need to produce better documentation), so you'll find the more
recent versions of things to be more complete and explanatory. Grabbing
the whole repo and using grep to search for keywords is likely best.

Nothing I have covers Trac (I use it at work, these are notes from
home), but there is discussion of setting up other websites, which may
help with apache.
--
Matthew Caron, Software Build Engineer
Red Lion Controls | www.redlion.net
[phone] x138 office

[Ala Maison]

At the end of the install, i get an error message:

"AH00558: httpd: Could not reliably deterninbe the server's fully qualified
domain name, using 127.0.1.1. Set the 'ServerName' directive globally to
supress this message"

I did all you suggest in on your github (thanks by the way) and more, like
adding manually ServerName localhost as suggested in other forums but
nothing works.

In the error message, it says "127.0.1.1" os i tried that instead of
"127.0.0.1" as suggested in your doc as well as everywhere else on the
internet, any ideas why my default IP is different ??

[Matthew Caron]

Post by Ala Maison
"AH00558: httpd: Could not reliably deterninbe the server's fully
qualified domain name, using 127.0.1.1. Set the 'ServerName' directive
globally to supress this message"
I did all you suggest in on your github (thanks by the way) and more,
like adding manually ServerName localhost as suggested in other forums
but nothing works.
In the error message, it says "127.0.1.1" os i tried that instead of
"127.0.0.1" as suggested in your doc as well as everywhere else on the
internet, any ideas why my default IP is different ??

I *think* the solution is to set ServerName outside of a VirtualHost
directive, but I don't recall. One of these days, that error will annoy
me enough that I'll actually fix it, but for now, all my servers
complain about that, and everything works (because 127.0.1.1 is
localhost and therefore things work just fine).
--
Matthew Caron, Software Build Engineer
Red Lion Controls | www.redlion.net
[phone] x138 office

[Ala Maison]

I hate warnings but i guess it works now :D
On i go with the trac projets environements copies :D
Wish me luck :D

[Ala Maison]

Hello again,
I did manage to set up the new trac server and i could start a new project
there, it works fine. But problems came when i tried to migrate old
projects on it.
I followed instructions described over here
http://trac.edgewall.org/wiki/TracMigrate but i can't even access trac
anymore when i used to be able to :/

Thanks

[Steffen Hoffmann]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Post by Ala Maison
Hello again,
I did manage to set up the new trac server and i could start a new
project there, it works fine. But problems came when i tried to migrate
old projects on it.
I followed instructions described over here
http://trac.edgewall.org/wiki/TracMigrate but i can't even access trac
anymore when i used to be able to :/

Most likely issues arise from version mismatch, when new Trac install is
newer than the Trac install used to create and utilize the projects in
question before. TracUpgrade [1] has a lot of useful information on the
matter.

Enable DEBUG logging and follow-up with seemingly relevant log messages,
please. See TracLogging [2] for details.

Steffen Hoffmann


[1] http://trac.edgewall.org/wiki/TracUpgrade
[2] http://trac.edgewall.org/wiki/TracLogging
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAlKnErwACgkQ31DJeiZFuHeApgCgqa3id0Y3rgFacifQcra3/NYC
uFUAnAtPdiAlaASqzr1r2gnneDgL7t5M
=Ilkn
-----END PGP SIGNATURE-----

[Ala Maison]

Hello,
Thanks for your answer but i think my problem is more apache related since
i can't even access it anymore, a simple url like this
"http://localhost:8000/" doesn't work when it used to display the "test"
project i created on the new server.

[Matthew Caron]

Post by Ala Maison
Hello,
Thanks for your answer but i think my problem is more apache related
since i can't even access it anymore, a simple url like this
"http://localhost:8000/" doesn't work when it used to display the "test"
project i created on the new server.

Is apache still running?

ps -ef | grep apache

?

or, nmap the machine to see what's listening on what ports.

netstat -t is also useful when looking at these.

Perhaps most importantly - what do the apache logs say?
--
Matthew Caron, Software Build Engineer
Red Lion Controls | www.redlion.net
[phone] x138 office

[Ala Maison]

Apache is running, everything seems as it was last friday...:/
My logs file "access" and "error" are empty...

[Ethan Jucovy]

Post by Ala Maison
Hello,
Thanks for your answer but i think my problem is more apache related since
i can't even access it anymore, a simple url like this "
http://localhost:8000/" doesn't work when it used to display the "test"
project i created on the new server.

"http://localhost:8000" doesn't sound like a Apache URL on a remote server
at all, unless (a) you've established an SSH tunnel to forward localhost to
the remote server (or you are wget'ing that address from a terminal on the
server itself) and (b) you've configured Apache to run on port 8000.

More likely the Apache server is running on port 80 (the HTTP default) and
listening for connections to its IP address or a particular domain. What
happens (both in the browser, and also in the apache log files) when you
type in the server's public IP address in a browser window?

Apologies if I'm misunderstanding your setup.

-Ethan

[Ala Maison]

My mistake, 8000 is the default port used by trac when ran in a stand alone
server (tracd) if you follow the installation guide on the trac website.
So my bad, it's normal that i wasn't able to access it.

Back in the installation guide http://trac.edgewall.org/wiki/TracInstall
when they say :

"Add the following snippet to Apache configuration *before* the ScriptAliasor
WSGIScriptAlias (which map all the other requests to the Trac application),
changing paths to match your deployment:

Alias /trac/chrome/common /path/to/trac/htdocs/common
Alias /trac/chrome/site /path/to/trac/htdocs/site

<Directory "/path/to/www/trac/htdocs">
Order allow,deny
Allow from all
</Directory>"

What file is that because i looked in all apache configuration files and i couldn't find the Scriptalias or WSGIScriptAlias they are talking about :/

thanks again

[Matthew Caron]

Post by Ala Maison
What file is that because i looked in all apache configuration files
and i couldn't find the Scriptalias or WSGIScriptAlias they are
talking about :/

It would be in the apache config for that site. Here's mine for
reference (with appropriate parts redacted, naturally):

# Redirect plain requests to the https://
<VirtualHost *:80>
ServerName trac.fqdn
ServerAlias trac
RewriteEngine on
RewriteRule . https://trac.fqdn/%{REQUEST_URI}
</VirtualHost>

# Rewritelocks can't be in a VirtualHost section
RewriteLock /var/run/apache2.rewritelock

# trac serves trac
<VirtualHost *:443>
ServerName trac.fqdn
ServerAlias trac

# Serve (relatively) static chrome files directly from the
# filesystem. Use trac-admin's deploy command to create the
# static-htdocs directory:
Alias /trac/chrome /opt/trac/eng/static-htdocs/htdocs
<Directory "/opt/trac/eng/static-htdocs/htdocs">
Order allow,deny
Allow from all
</Directory>

WSGIDaemonProcess trac user=www-data group=www-data threads=50
WSGIScriptAlias /trac /opt/trac/eng/static-htdocs/cgi-bin/trac.wsgi
RewriteEngine on

# RewriteLog /var/log/apache2/rewrite.log
# RewriteLogLevel 9

# SSL stuff
SSLEngine on
SSLCertificateFile /etc/apache2/ssl/server_cert.pem
SSLCertificateKeyFile /etc/apache2/ssl/private.key
SSLCertificateChainFile /etc/apache2/ssl/cert_chain.pem

# It would be far better if mod_fcgid respected the setting of LANG
# in the actual environment, but I don't know how to do that easily.
# It seems mod_fcgid includes _only_ the environment values
# specifically set below, so we do need to set LANG here explicitly.
# See ticket #1352
DefaultInitEnv LANG "en_US.UTF-8"
DefaultInitEnv TRAC_ENV "/opt/trac/eng"

# Redirect bare requests to /trac
RewriteCond %{REQUEST_URI} ^/$
RewriteRule ^(.*)$ https://trac.fqdn/trac%{REQUEST_URI}

# force fully qualified domain name
RewriteCond %{HTTP_HOST} !^trac\.fqdn
RewriteCond %{HTTP_HOST} !^$
RewriteRule ^/(.*) https://trac.fqdn/$1

<Directory /opt/trac/eng/static-htdocs/cgi-bin/>
WSGIProcessGroup trac
WSGIApplicationGroup %{GLOBAL}
Order deny,allow
Allow from all
</Directory>

# It's very likely that this section does nothing since mod_fcgid
# appears to only pass variables set via DefaultInitEnv, but why fix
# something that isn't broken?
<Location "/trac">
SetEnv TRAC_ENV "/opt/trac/eng"
</Location>

# This is likely redundant with the http redirect, above, but
# let's be explicit about not sending credentials in plain text,
# shall we?
<Location "/trac/login">
SSLRequireSSL
</Location>
</VirtualHost>
--
Matthew Caron, Software Build Engineer
Red Lion Controls | www.redlion.net
[phone] x138 office

[Ala Maison]

In what files do you have this ?!!?!?!?! plz

[Matthew Caron]

Post by Ala Maison
In what files do you have this ?!!?!?!?! plz

Since you didn't quote context, we don't know of whom you are asking
this question.

If you meant me, it's in my /etc/apache2/sites-available/trac file,
which is a config file I wrote in apache, for trac, so its location is
irrelevant.
--
Matthew Caron, Software Build Engineer
Red Lion Controls | www.redlion.net
[phone] x138 office

[Ala Maison]

Sorry Matthew, but yes it was your file i was talking about and thanks for
your answer.
I guess i'll have to write it at some point.
Sorry about that, i got kind of pissed yesterday...

Thanks again

[Ala Maison]

Hello,
I finished the installation (according the trac installation guide
available on trac website) but it's not working, i can't load it. I've been
searching all over the place.
Thanks Matt for your conf file for trac, i used it to make my own
# Redirect plain requests to the https://
<VirtualHost*:80>
ServerName trac.fdqn
ServerAlias lmtrac
RewriteEngine on
RewriteRule . https://trac.fdqn/%{REQUEST_URL}
</VirtualHost>

# Rewritelocks can't be in a VirtualHost section
RewriteLock /var/run/apache2.rewritelock

# trac serves trac
<VirtualHost*:443>
ServerName trac.fdqn
ServerAlias lmtrac
# Serve (relatively) static chrome files directly from the
# filesystem. Use trac-admin's deploy command to create the
# htdocs directory
Alias /trac/chrome /var/lib/trac-www/htdocs
<Directory "/var/lib/trac-www/htdocs">
Order allow,deny
Allow from all
</Directory>


ScriptAlias /trac /var/lib/trac-www/cgi-bin/trac.fcgi/
RewriteEngine on
# SSL config

SSLEngine on
SSLCertificateFile /etc/apache2/ssl/server_cert.perm
SSLCertificateKeyFile /etc/apache2/ssl/private.key
SSLCertificateChainFile /etc/apache2/sss/cert_chain.perm

# Language settings
DefaultInitEnv LANG "en_US.UTF-8"
DefaultInitEnv TRAC_ENV "/var/lib/trac"

RewriteCond %{REQUEST_URL}^/$
ReWriteRule ^(.*)$ https://trac.fdqn/trac%{REQUEST_URL}

# Force fully qualified domain name
RewriteCond %{HTTP_HOST} !^trac\.fdqn
ReWritecond %{HTTP_HOST} !^$
ReWriteRule ^/(.*) https://trac.fdqn/$1

</VirtualHost>

Every thing else i did what is written in the install guid mentionned
ealier so it's supposed to work now, the only part i didn't do yet is the
authentification part but i'll do it when i'll be able to access the site
itself. :p

Thanks

[Ethan Jucovy]

Post by Ala Maison
Hello,
I finished the installation (according the trac installation guide
available on trac website) but it's not working, i can't load it.

When you say "it's not working" and you "can't load it", what specifically
are you doing to try to access the trac site, and what is the result?


I've been searching all over the place.

Post by Ala Maison
Thanks Matt for your conf file for trac, i used it to make my own
# Redirect plain requests to the https://
<VirtualHost*:80>
ServerName trac.fdqn

Just to make sure: did you leave this line "ServerName trac.fdqn" (and the
various other references to "trac.fdqn") in place literally? This is the
line that tells Apache what domain name is active for the configuration, so
"trac.fdqn" needs to be replaced with a real domain name that resolves to
the server where Apache is running.

Also making sure: did you reload Apache after installing your Apache conf
file? What was the console output when you reloaded it?

-Ethan

[Matthew Caron]

Post by Ethan Jucovy
Also making sure: did you reload Apache after installing your Apache
conf file? What was the console output when you reloaded it?

Also, where did you put it? If you put it in
`/etc/apache2/sites-available/trac`, but didn't `sudo a2ensite trac`,
then it never got symlinked to `/etc/apache2/sites-enabled/trac` which
is *actually* what is included by the default debianish apache config.
--
Matthew Caron, Software Build Engineer
Red Lion Controls | www.redlion.net
[phone] x138 office

[Ala Maison]

Hello,

After enabling the trac website, i checked that it worked so now i have
000-default and trac in my sites-enabled directory.
Then the a2ensite trac command asked me to reload the service by executing
service apache2 reload, but this command gives me the following output,

"Usage: /usr/local/apache2/bin/httpd" and the a bunch of options.
It ends by "httpd: abnormal exit 1"

I don't know what any of this means :/

Thanks

[Matthew Caron]

Post by Ala Maison
Hello,
After enabling the trac website, i checked that it worked so now i have
000-default and trac in my sites-enabled directory.
Then the a2ensite trac command asked me to reload the service by
executing service apache2 reload, but this command gives me the
following output,

Make sure you're doing:

sudo service apache2 reload

Post by Ala Maison
"Usage: /usr/local/apache2/bin/httpd" and the a bunch of options.
It ends by "httpd: abnormal exit 1"
I don't know what any of this means :/

Well, if sudo doesn't fix it, it means you've somehow managed to break
the Ubuntu apache install, by somehow feeding the startup script bad
data. Assuming you didn't outright alter the startup script, did you,
perhaps, add some options in /etc/defaults/apache2 (or similar?).
Basically, something sourced by the init script which starts httpd is
doing something wrong, hence why httpd is complaining.

If all else fails,

sudo apt-get install --reinstall apache2

may very well set you right.
--
Matthew Caron, Software Build Engineer
Red Lion Controls | www.redlion.net
[phone] x138 office