The 1050 error from django was due to changes in to configuration file 
format. Instead of using the format:
DATABASE_ENGINE = '',
DATABASE_NAME='',
.
.
.

The devs changed the format to:
DATABASES = {
 'default' : {
  'ENGINE': 'django.db.backends,mysql',
  'NAME': '',
  'USER': '',
  'PASSWORD': '',
  'HOST': '',
 },
}

The caches format has changed similarly. 
# Cache backend settings.
CACHES = {
    'default': {
        'BACKEND': 'django.core.cache.backends.memcached.MemcachedCache',
        'LOCATION': 'localhost:11211',
    },
}

Have you verified the integrity of your dump? If so, you should not have to 
drop your tables just convert them all to InnoDB. If you don't convert your 
tables you will see sql errors when the upgrade script attempts to create 
primary keys in the database.

KP

On Wednesday, March 19, 2014 3:09:29 AM UTC-7, Bhaskar Roy wrote:
>
> Hi Kevin,
>
> Can I know how you performed these steps.
>
> 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.
>
> regards
> Bhaskar 
>
> On Friday, 14 March 2014 23:20:27 UTC+5:30, Kevin Phillips 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.

Reply via email to