Hi Kevin,

The first red flag is that you had to do anything special with the
database. Working around those issues is going to likely just result in new
issues down the line, so for the moment, let's consider the workarounds as
not a real solution, and dig into what went wrong there.

Can you reproduce the original steps and show me exactly what errors you
hit?

Something important to watch out for is that your database dump is
consistent with regards to the table type (MyISAM vs. InnoDB). If they're
not, you will have problems importing the dump. This is the usual cause of
the problems.

You also need to be sure your database is completely wiped before
importing, so that there aren't any conflicts there.

I don't remember which version of django-evolution we depended on back in
1.7.14, but make sure you have django-evolution 0.6.9 installed before
upgrading the database. (Also, why not run a more modern 1.7.x? Lots of bug
fixes since 1.7.14.)

As far as the last error goes, mod_python is completely unsupported now, by
both us and Django (and, really, the project itself, last I heard). You
should be using mod_wsgi for any installations now.

Christian


-- 
Christian Hammond - chip...@chipx86.com
Review Board - http://www.reviewboard.org
Beanbag, Inc. - http://www.beanbaginc.com


On Fri, Mar 14, 2014 at 10:50 AM, Kevin Phillips <
kevin.grenville.phill...@gmail.com> wrote:

> All;
>
> I'm having some issues performing a site migration of RB 1.5.2 to 1.7.14
> from an EOL server to a VM. Here are the steps I preformed:
>
> 1. Took SQL dump of reviewboard database and restored on new system
> 2. Took copy of application web root and copied to new system
> 3. Configured memcached on new system.
> 3. Installed Reviewboard==1.7.14 Django==1.4.10 python-memcached
> MySQL-python + deps via easy_install (Python 2.7.3)
> 4. Preformed a rb-site upgrade of application web root.
> 5. Upgrade failed with a 1050 (or similar) error because it couldn't
> access some table. So I temporarily overrode django's default database
> handler to use mysql + client configs in my.cnf (only a single site will
> reside on this VM) via django's conf/global_settings.py, I then ran
> './reviewboard/manage.py syncdb'.
> 6. syncdb also failed, so I dropped all my tables and re-ran the syncdb.
> 7. The second syncdb after dropping my tables worked, then I re-ran the
> rb-site upgrade
> 8. The second rb-site upgrade was successful but prompted me to modify my
> apache vhost config and validate the site settings.
> 9. I actioned the changes and restarted the web server.
>
> After this I get the error 500 page but I get a mod_python stack trace
> (yes I know mod_python is simply in there for legacy purposes, but the old
> site ran it and I cannot figure out how to cut-over to mod_wsgi).
>
> STACKTRACE:
> [Fri Mar 14 09:48:18 2014] [error] [client 10.12.21.48] mod_python
> (pid=2342, interpreter='reviewboard_review_vmem_com',
> phase='PythonHandler', handler='django.core.handlers.modpython'):
> Application error, referer: http://reviewboard.sub.domain/review/
> [Fri Mar 14 09:48:18 2014] [error] [client 10.12.21.48] ServerName:
> 'reviewboard.sub.domain', referer: http://reviewboard.sub.domain/review/
> [Fri Mar 14 09:48:18 2014] [error] [client 10.12.21.48] DocumentRoot:
> '/var/www/review.vmem.com/htdocs', referer:
> http://reviewboard.sub.domain/review/
> [Fri Mar 14 09:48:18 2014] [error] [client 10.12.21.48] URI: '/review/',
> referer: http://reviewboard.sub.domain/review/
> [Fri Mar 14 09:48:18 2014] [error] [client 10.12.21.48] Location:
> '/review/', referer: http://reviewboard.sub.domain/review/
> [Fri Mar 14 09:48:18 2014] [error] [client 10.12.21.48] Directory: None,
> referer: http://reviewboard.sub.domain/review/
> [Fri Mar 14 09:48:18 2014] [error] [client 10.12.21.48] Filename:
> '/var/www/review.vmem.com/htdocs/review', referer:
> http://reviewboard.sub.domain/review/
> [Fri Mar 14 09:48:18 2014] [error] [client 10.12.21.48] PathInfo: '/',
> referer: http://reviewboard.sub.domain/review/
> [Fri Mar 14 09:48:18 2014] [error] [client 10.12.21.48] Traceback (most
> recent call last):, referer: http://reviewboard.sub.domain/review/
> [Fri Mar 14 09:48:18 2014] [error] [client 10.12.21.48]   File
> "/usr/lib/python2.7/dist-packages/mod_python/importer.py", line 1537, in
> HandlerDispatch\n    default=default_handler, arg=req,
> silent=hlist.silent), referer: http://reviewboard.sub.domain/review/
> [Fri Mar 14 09:48:18 2014] [error] [client 10.12.21.48]   File
> "/usr/lib/python2.7/dist-packages/mod_python/importer.py", line 1202, in
> _process_target\n    module = import_module(module_name, path=path),
> referer: http://reviewboard.sub.domain/review/
> [Fri Mar 14 09:48:18 2014] [error] [client 10.12.21.48]   File
> "/usr/lib/python2.7/dist-packages/mod_python/importer.py", line 304, in
> import_module\n    return __import__(module_name, {}, {}, ['*']), referer:
> http://reviewboard.sub.domain/review/
> [Fri Mar 14 09:48:18 2014] [error] [client 10.12.21.48] ImportError: No
> module named django.core.handlers.modpython, referer:
> http://reviewboard.sub.domain/review/
>
> VHOST CONFIG
> <VirtualHost *:80>
> ServerName reviewboard.sub.domain
> DocumentRoot "/var/www/reviewboard/htdocs"
>
> # Error handlers
> ErrorDocument 500 /errordocs/500.html
>
> # Serve django pages
>  <Location "/review/">
> PythonPath "['/var/www/reviewboard/conf'] + sys.path"
>  SetEnv DJANGO_SETTINGS_MODULE reviewboard.settings
> SetEnv PYTHON_EGG_CACHE "/var/www/reviewboard/tmp/egg_cache"
>  SetHandler mod_python
> PythonHandler django.core.handlers.modpython
> PythonAutoReload Off
>  PythonDebug Off
> # Used to run multiple mod_python sites in the same apache
> PythonInterpreter reviewboard_reviewboard
>  </Location>
>
> # Serve static without running it through mod_python
> # Required for upgrade from Reviewboard 1.5.2 to 1.7.14
>  <Location "/review/static">
> SetHandler None
> </Location>
>
> Alias /review/static "/var/www/reviewboard/htdocs/static"
>
> # Serve static media without running it through mod_python
>  # (overrides the above)
> <Location "/review/media">
> SetHandler None
>  </Location>
> <Location "/review/errordocs">
> SetHandler None
>  </Location>
>
> <Directory "/var/www/reviewboard/htdocs">
> AllowOverride All
>  </Directory>
>
> # Alias static media requests to filesystem
> Alias /review/media "/var/www/reviewboard/htdocs/media"
>  Alias /review/errordocs "/var/www/reviewboard/htdocs/errordocs"
> </VirtualHost>
>
> Any suggestions would be much appreciated. If you live in the bay area,
> I'll buy you a six pack.
>
> Thanks,
>
> Kevin
>
> --
> Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/
> ---
> Sign up for Review Board hosting at RBCommons: https://rbcommons.com/
> ---
> Happy user? Let us know at http://www.reviewboard.org/users/
> ---
> You received this message because you are subscribed to the Google Groups
> "reviewboard" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to reviewboard+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/
---
Sign up for Review Board hosting at RBCommons: https://rbcommons.com/
---
Happy user? Let us know at http://www.reviewboard.org/users/
--- 
You received this message because you are subscribed to the Google Groups 
"reviewboard" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to reviewboard+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to