Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: Trac: Users

Howto move and update a server ?!?

 

 

Trac users RSS feed   Index | Next | Previous | View Threaded


koch.peerjoachim at googlemail

Feb 15, 2012, 5:00 AM

Post #1 of 7 (410 views)
Permalink
Howto move and update a server ?!?

Hi,

we are running a rather old system with svn (1.6) and trac 0.11.x .
I want to replace the system with new hard and software. The trac
system is using our mysql server.

So I've already installed a new system with svn 1.7 and trac 0.12.2.
I could create new repository's, but how do I transfer the old
projects
from the old host to the new one ?

The svn stuff is easy
svnadmin dump on the old side
svnadmin load on the new side

This seem's to work.
But who do I get the corresponding trac stuff from the old (0.11.x) to
the new system ?
I tried to dump the sql table and import it into the new table,
but trac is showing nothing.

What's the best way to transfer everything AND doing and upgrade ?

Bye, Peer

--
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 [at] googlegroups
To unsubscribe from this group, send email to trac-users+unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.


Matt.Caron at sixnet

Feb 15, 2012, 5:58 AM

Post #2 of 7 (398 views)
Permalink
Re: Howto move and update a server ?!? [In reply to]

On 02/15/2012 08:00 AM, koch.peerjoachim [at] googlemail wrote:
> What's the best way to transfer everything AND doing and upgrade ?

1. Dump/load SQL tables.
2. Copy over your trac env.

If that doesn't work, you'll have to be more specific as to your config,
etc. and what part doesn't work.

--
Matthew Caron, Build Engineer
Sixnet, a Red Lion business | www.sixnet.com
+1 (518) 877-5173 x138 office

--
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 [at] googlegroups
To unsubscribe from this group, send email to trac-users+unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.


bernhard.voelker at siemens-enterprise

Feb 15, 2012, 6:18 AM

Post #3 of 7 (399 views)
Permalink
RE: Howto move and update a server ?!? [In reply to]

Matthew Caron wrote:

> On 02/15/2012 08:00 AM, koch.peerjoachim [at] googlemail wrote:
> > What's the best way to transfer everything AND doing and upgrade ?
>
> 1. Dump/load SQL tables.
> 2. Copy over your trac env.
>
> If that doesn't work, you'll have to be more specific as to your config,
> etc. and what part doesn't work.

see also:
http://trac.edgewall.org/wiki/TracUpgrade

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 [at] googlegroups
To unsubscribe from this group, send email to trac-users+unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.


pkoch at bgc-jena

Feb 15, 2012, 6:42 AM

Post #4 of 7 (405 views)
Permalink
Re: Howto move and update a server ?!? [In reply to]

Hi,
Am 15.02.2012 15:18, schrieb Voelker, Bernhard:
> Matthew Caron wrote:
>
>> On 02/15/2012 08:00 AM, koch.peerjoachim [at] googlemail wrote:
>>> What's the best way to transfer everything AND doing and upgrade ?
>> 1. Dump/load SQL tables.
>> 2. Copy over your trac env.
What does belong to the trac env ?
Everything below .../trac/ ? - sorry I'm not used to trac.
>>
>> If that doesn't work, you'll have to be more specific as to your config,
>> etc. and what part doesn't work.
> see also:
> http://trac.edgewall.org/wiki/TracUpgrade
>
> Have a nice day,
> Berny
>
yes, I've looked at this page.

When I've tried to resync everything on the new server I only get

15:35:57 Trac[console] ERROR: Exception in trac-admin command:
Traceback (most recent call last):
File "/usr/lib64/python2.6/site-packages/trac/admin/console.py", line
107, in onecmd
rv = cmd.Cmd.onecmd(self, line) or 0
File "/usr/lib64/python2.6/cmd.py", line 218, in onecmd
return self.default(line)
File "/usr/lib64/python2.6/site-packages/trac/admin/console.py", line
266, in default
return cmd_mgr.execute_command(*args)
File "/usr/lib64/python2.6/site-packages/trac/admin/api.py", line
123, in execute_command
return f(*fargs)
File
"/usr/lib64/python2.6/site-packages/trac/versioncontrol/admin.py", line
153, in _do_resync
self._sync(reponame, rev, clean=True)
File
"/usr/lib64/python2.6/site-packages/trac/versioncontrol/admin.py", line
139, in _sync
repos.sync(self._sync_feedback, clean=clean)
File
"/usr/lib64/python2.6/site-packages/trac/versioncontrol/cache.py", line
242, in sync
@self.env.with_transaction()
File "/usr/lib64/python2.6/site-packages/trac/db/api.py", line 77, in
transaction_wrapper
fn(ldb)
File
"/usr/lib64/python2.6/site-packages/trac/versioncontrol/cache.py", line
283, in do_transaction
brev))
File "/usr/lib64/python2.6/site-packages/trac/db/util.py", line 65,
in execute
return self.cursor.execute(sql_escape_percent(sql), args)
File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line
174, in execute
self.errorhandler(self, exc, value)
File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py",
line 36, in defaulterrorhandler
raise errorclass, errorvalue
IntegrityError: (1062, "Duplicate entry
'1-0000000001-trunk/src/include/make_dummies/advection_bgc.h-A' for key
'PRIMARY'")
Trac [/var/projects/TEST/trac]> quit

Maybe the ENV is not complete. I just looked at the trac.ini settings.

I see nothing from the sources in the trac page.



--
Bye,
Peer
_________________________________________________________
Max-Planck-Institut fuer Biogeochemie
Dr. Peer-Joachim Koch
Hans-Knöll Str.10 Telefon: ++49 3641 57-6705
D-07745 Jena Telefax: ++49 3641 57-7705
Attachments: pkoch.vcf (0.28 KB)
  smime.p7s (4.49 KB)


mark.cooke at siemens

Feb 15, 2012, 6:49 AM

Post #5 of 7 (400 views)
Permalink
RE: Howto move and update a server ?!? [In reply to]

Not directly answering your original question but did you have any plugins installed? Did any of them update the database schema? Have you re-installed them in the new instance?

~ cheers ~ mark c

> -----Original Message-----
> From: trac-users [at] googlegroups
> [mailto:trac-users [at] googlegroups] On Behalf Of Dr.Peer-Joachim Koch
> Sent: 15 February 2012 14:43
> To: trac-users [at] googlegroups
> Subject: Re: [Trac] Howto move and update a server ?!?
>
> Hi,
> Am 15.02.2012 15:18, schrieb Voelker, Bernhard:
> > Matthew Caron wrote:
> >
> >> On 02/15/2012 08:00 AM, koch.peerjoachim [at] googlemail wrote:
> >>> What's the best way to transfer everything AND doing and upgrade ?
> >> 1. Dump/load SQL tables.
> >> 2. Copy over your trac env.
> What does belong to the trac env ?
> Everything below .../trac/ ? - sorry I'm not used to trac.
> >>
> >> If that doesn't work, you'll have to be more specific as
> to your config,
> >> etc. and what part doesn't work.
> > see also:
> > http://trac.edgewall.org/wiki/TracUpgrade
> >
> > Have a nice day,
> > Berny
> >
> yes, I've looked at this page.
>
> When I've tried to resync everything on the new server I only get
>
> 15:35:57 Trac[console] ERROR: Exception in trac-admin command:
> Traceback (most recent call last):
> File
> "/usr/lib64/python2.6/site-packages/trac/admin/console.py", line
> 107, in onecmd
> rv = cmd.Cmd.onecmd(self, line) or 0
> File "/usr/lib64/python2.6/cmd.py", line 218, in onecmd
> return self.default(line)
> File
> "/usr/lib64/python2.6/site-packages/trac/admin/console.py", line
> 266, in default
> return cmd_mgr.execute_command(*args)
> File "/usr/lib64/python2.6/site-packages/trac/admin/api.py", line
> 123, in execute_command
> return f(*fargs)
> File
> "/usr/lib64/python2.6/site-packages/trac/versioncontrol/admin.
> py", line
> 153, in _do_resync
> self._sync(reponame, rev, clean=True)
> File
> "/usr/lib64/python2.6/site-packages/trac/versioncontrol/admin.
> py", line
> 139, in _sync
> repos.sync(self._sync_feedback, clean=clean)
> File
> "/usr/lib64/python2.6/site-packages/trac/versioncontrol/cache.
> py", line
> 242, in sync
> @self.env.with_transaction()
> File "/usr/lib64/python2.6/site-packages/trac/db/api.py",
> line 77, in
> transaction_wrapper
> fn(ldb)
> File
> "/usr/lib64/python2.6/site-packages/trac/versioncontrol/cache.
> py", line
> 283, in do_transaction
> brev))
> File "/usr/lib64/python2.6/site-packages/trac/db/util.py",
> line 65,
> in execute
> return self.cursor.execute(sql_escape_percent(sql), args)
> File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line
> 174, in execute
> self.errorhandler(self, exc, value)
> File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py",
> line 36, in defaulterrorhandler
> raise errorclass, errorvalue
> IntegrityError: (1062, "Duplicate entry
> '1-0000000001-trunk/src/include/make_dummies/advection_bgc.h-A
> ' for key
> 'PRIMARY'")
> Trac [/var/projects/TEST/trac]> quit
>
> Maybe the ENV is not complete. I just looked at the trac.ini settings.
>
> I see nothing from the sources in the trac page.
>
>
>
> --
> Bye,
> Peer
> _________________________________________________________
> Max-Planck-Institut fuer Biogeochemie
> Dr. Peer-Joachim Koch
> Hans-Knöll Str.10 Telefon: ++49 3641 57-6705
> D-07745 Jena Telefax: ++49 3641 57-7705
>
>

--
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 [at] googlegroups
To unsubscribe from this group, send email to trac-users+unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.


rainer at sokoll

Feb 15, 2012, 7:09 AM

Post #6 of 7 (393 views)
Permalink
Re: Howto move and update a server ?!? [In reply to]

Am 15.02.2012 um 14:00 schrieb koch.peerjoachim [at] googlemail:


> The svn stuff is easy
> svnadmin dump on the old side
> svnadmin load on the new side

Nope. This will only dump/load your svn repo, but not all your hooks for example.
Better use svnadmin hotcopy.

Rainer

--
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 [at] googlegroups
To unsubscribe from this group, send email to trac-users+unsubscribe [at] googlegroups
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.


pkoch at bgc-jena

Feb 16, 2012, 4:59 AM

Post #7 of 7 (389 views)
Permalink
Re: Howto move and update a server ?!? [In reply to]

Am 15.02.2012 16:09, schrieb Rainer Sokoll:
> Am 15.02.2012 um 14:00 schrieb koch.peerjoachim [at] googlemail:
>
>
>> The svn stuff is easy
>> svnadmin dump on the old side
>> svnadmin load on the new side
> Nope. This will only dump/load your svn repo, but not all your hooks for example.
> Better use svnadmin hotcopy.
>
> Rainer
>

OK,

I've started from scratch again and now it seem's to work.
The following steps where done:

*) Delete everything (svn/trac)

*) svnsync --username svnsyn init file:///var/svn/projects/NEW_PRO
svn+ssh://root [at] X/var/svn/projects/OLD_PRO

*) svnsync --username svnsyn --non-interactive
file:///var/svn/projects/NEW_PRO

*) rsync of the tarc-folder from old -> new

*) dump of the mysql table, edit the file (table name) and reimport it
into a new table

*) change the mysql statement (trac.ini) - pointing now to the new table
- the old one is still active, it's just a test -

*) trac-admin /var/projects/NEW_PRO/trac/ upgrade --no-backup
-> OK
*) trac-admin /var/projects/NEW_PRO/trac/ wiki upgrade
-> OK
*) trac-admin /var/projects/NEW_PRO/trac/ repository resync
failed !

*) the collation type of the mysql table node_change has to be change
into utf8-bin !

*) trac-admin /var/projects/NEW_PRO/trac/ repository resync
-> OK


Test: svn -> OK
Test: trac -> seem's to be ok (I'm not working with the repository ...)

Maybe it's helpful for other as well ...

Thanks and bye,

Peer





--
Mit freundlichem Gruß
Peer-Joachim Koch
_________________________________________________________
Max-Planck-Institut fuer Biogeochemie
Dr. Peer-Joachim Koch
Hans-Knöll Str.10 Telefon: ++49 3641 57-6705
D-07745 Jena Telefax: ++49 3641 57-7705
Attachments: pkoch.vcf (0.28 KB)
  smime.p7s (4.49 KB)

Trac users RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.