Re: [Trac] Howto move and update a server ?!?
Am 15.02.2012 16:09, schrieb Rainer Sokoll: Am 15.02.2012 um 14:00 schrieb koch.peerjoac...@googlemail.com: 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@X.X.X.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.10Telefon: ++49 3641 57-6705 D-07745 Jena Telefax: ++49 3641 57-7705 <> smime.p7s Description: S/MIME Kryptografische Unterschrift
Re: [Trac] Howto move and update a server ?!?
Am 15.02.2012 um 14:00 schrieb koch.peerjoac...@googlemail.com: > 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@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] Howto move and update a server ?!?
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@googlegroups.com > [mailto:trac-users@googlegroups.com] On Behalf Of Dr.Peer-Joachim Koch > Sent: 15 February 2012 14:43 > To: trac-users@googlegroups.com > 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.peerjoac...@googlemail.com 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-01-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.10Telefon: ++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@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] 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.peerjoac...@googlemail.com 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-01-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.10Telefon: ++49 3641 57-6705 D-07745 Jena Telefax: ++49 3641 57-7705 <> smime.p7s Description: S/MIME Kryptografische Unterschrift
RE: [Trac] Howto move and update a server ?!?
Matthew Caron wrote: > On 02/15/2012 08:00 AM, koch.peerjoac...@googlemail.com 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@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] Howto move and update a server ?!?
On 02/15/2012 08:00 AM, koch.peerjoac...@googlemail.com 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@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] 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@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.