Re: Failure upgrading to 1.6
I would recommend to do a check by the software to verify permissions on DB before performing the upgrade, if the requirements are missing it can inform the user to get the requirements done before it performs the upgrade. Also, It can avoid database getting into a fuzzy state (neither downgraded nor upgraded) during the upgrade. Thanks, Kannaiyan On Tue, Sep 6, 2011 at 12:19 PM, Christian Hammond chip...@chipx86.comwrote: On Tue, Sep 6, 2011 at 10:08 AM, Kannaiyan Natesan gbpnk...@gmail.comwrote: INDEX command denied to user 'rb'@'localhost' for table 'accounts_localsiteprofile') Seems a Database Issue. Did you verify permissions for this user on Database? Kannaiyan Right, it looks like the user just doesn't have all the necessary permissions. Quickest thing to do is: GRANT ALL ON yourdbname.* to rb@localhost; You could instead do INDEX instead of ALL, I think, but might be safest to just give the user the permissions it needs to manipulate that database. Your database isn't corrupt, but you're probably not at a spot now where you'd be able to downgrade. Christian -- Christian Hammond - chip...@chipx86.com Review Board - http://www.reviewboard.org VMware, Inc. - http://www.vmware.com -- Want to help the Review Board project? Donate today at http://www.reviewboard.org/donate/ Happy user? Let us know at http://www.reviewboard.org/users/ -~--~~~~--~~--~--~--- To unsubscribe from this group, send email to reviewboard+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/reviewboard?hl=en -- Want to help the Review Board project? Donate today at http://www.reviewboard.org/donate/ Happy user? Let us know at http://www.reviewboard.org/users/ -~--~~~~--~~--~--~--- To unsubscribe from this group, send email to reviewboard+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/reviewboard?hl=en -- The best things in life are free -- Want to help the Review Board project? Donate today at http://www.reviewboard.org/donate/ Happy user? Let us know at http://www.reviewboard.org/users/ -~--~~~~--~~--~--~--- To unsubscribe from this group, send email to reviewboard+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/reviewboard?hl=en
Re: Failure upgrading to 1.6
Thanks for the help. I granted INDEX to user rb. I'm not sure why I would have granted USAGE, which is what it was. Anyhow, problem solved. Thanks again. On Sep 6, 2:19 pm, Christian Hammond chip...@chipx86.com wrote: On Tue, Sep 6, 2011 at 10:08 AM, Kannaiyan Natesan gbpnk...@gmail.comwrote: INDEX command denied to user 'rb'@'localhost' for table 'accounts_localsiteprofile') Seems a Database Issue. Did you verify permissions for this user on Database? Kannaiyan Right, it looks like the user just doesn't have all the necessary permissions. Quickest thing to do is: GRANT ALL ON yourdbname.* to rb@localhost; You could instead do INDEX instead of ALL, I think, but might be safest to just give the user the permissions it needs to manipulate that database. Your database isn't corrupt, but you're probably not at a spot now where you'd be able to downgrade. Christian -- Christian Hammond - chip...@chipx86.com Review Board -http://www.reviewboard.org VMware, Inc. -http://www.vmware.com -- Want to help the Review Board project? Donate today athttp://www.reviewboard.org/donate/ Happy user? Let us know athttp://www.reviewboard.org/users/ -~--~~~~--~~--~--~--- To unsubscribe from this group, send email to reviewboard+unsubscr...@googlegroups.com For more options, visit this group athttp://groups.google.com/group/reviewboard?hl=en -- Want to help the Review Board project? Donate today at http://www.reviewboard.org/donate/ Happy user? Let us know at http://www.reviewboard.org/users/ -~--~~~~--~~--~--~--- To unsubscribe from this group, send email to reviewboard+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/reviewboard?hl=en
Failure upgrading to 1.6
I am trying to upgrade reviewboard 1.5.5 to 1.6 and have failed with the errors below when I run the site upgrade (sudo rb-site upgrade / var/www/rb) . I am able to visit the reviewboard site and see that 1.5.5 is still installed. Will the database update have been rolled back or aborted? How can I tell if my site is now corrupted? Also, do you have suggestions to repair my system and resolve this issue? == UPDATE RB - success, (included for completeness) == user@rb:/var/www$ sudo easy_install -U ReviewBoard install_dir /usr/local/lib/python2.6/dist-packages/ Searching for ReviewBoard Reading http://pypi.python.org/simple/ReviewBoard/ Reading http://www.reviewboard.org/ Reading http://downloads.reviewboard.org/releases/ReviewBoard/1.5/ Reading http://downloads.reviewboard.org/releases/ReviewBoard/1.6/ Reading http://downloads.reviewboard.org/releases/ReviewBoard/1.0/ Reading http://www.review-board.org/ Reading http://downloads.review-board.org/releases/ Reading http://downloads.review-board.org/releases/ReviewBoard/1.0/ Best match: ReviewBoard 1.6 Downloading http://downloads.reviewboard.org/releases/ReviewBoard/1.6/ReviewBoard-1.6-py2.6.egg Processing ReviewBoard-1.6-py2.6.egg creating /usr/local/lib/python2.6/dist-packages/ReviewBoard-1.6- py2.6.egg Extracting ReviewBoard-1.6-py2.6.egg to /usr/local/lib/python2.6/dist- packages Removing ReviewBoard 1.5.5 from easy-install.pth file Adding ReviewBoard 1.6 to easy-install.pth file Installing rb-site script to /usr/local/bin Installing rbssh script to /usr/local/bin Installed /usr/local/lib/python2.6/dist-packages/ReviewBoard-1.6- py2.6.egg Reading http://downloads.reviewboard.org/mirror/ Processing dependencies for ReviewBoard Searching for Pygments=1.4 Reading http://pypi.python.org/simple/Pygments/ Reading http://pygments.org/ Reading http://pygments.pocoo.org/ Best match: Pygments 1.4 Downloading http://pypi.python.org/packages/2.6/P/Pygments/Pygments-1.4-py2.6.egg#md5=306241dd68799753cdb4a2c9ce8e883a Processing Pygments-1.4-py2.6.egg creating /usr/local/lib/python2.6/dist-packages/Pygments-1.4-py2.6.egg Extracting Pygments-1.4-py2.6.egg to /usr/local/lib/python2.6/dist- packages Removing Pygments 1.3.1 from easy-install.pth file Adding Pygments 1.4 to easy-install.pth file Installing pygmentize script to /usr/local/bin Installed /usr/local/lib/python2.6/dist-packages/Pygments-1.4- py2.6.egg Searching for Djblets=0.6.10 Reading http://pypi.python.org/simple/Djblets/ Reading http://www.review-board.org/wiki/Djblets Reading http://downloads.review-board.org/releases/Djblets/0.6/ Reading http://downloads.review-board.org/releases/Djblets/0.5/ Best match: Djblets 0.6.10 Downloading http://downloads.reviewboard.org/releases/Djblets/0.6/Djblets-0.6.10-py2.6.egg Processing Djblets-0.6.10-py2.6.egg creating /usr/local/lib/python2.6/dist-packages/Djblets-0.6.10- py2.6.egg Extracting Djblets-0.6.10-py2.6.egg to /usr/local/lib/python2.6/dist- packages Removing Djblets 0.6.7 from easy-install.pth file Adding Djblets 0.6.10 to easy-install.pth file Installed /usr/local/lib/python2.6/dist-packages/Djblets-0.6.10- py2.6.egg Reading http://downloads.review-board.org/mirror/ Searching for django-evolution=0.6.5 Reading http://pypi.python.org/simple/django_evolution/ Reading http://code.google.com/p/django-evolution/ Best match: django-evolution 0.6.5 Downloading http://pypi.python.org/packages/2.6/d/django_evolution/django_evolution-0.6.5-py2.6.egg#md5=2d710049fb1f2ce78e3c3 a4c0d3e0783 Processing django_evolution-0.6.5-py2.6.egg creating /usr/local/lib/python2.6/dist-packages/django_evolution-0.6.5- py2.6.egg Extracting django_evolution-0.6.5-py2.6.egg to /usr/local/lib/ python2.6/dist-packages Removing django-evolution 0.6.2 from easy-install.pth file Adding django-evolution 0.6.5 to easy-install.pth file Installed /usr/local/lib/python2.6/dist-packages/ django_evolution-0.6.5-py2.6.egg Searching for Django=1.3 Reading http://pypi.python.org/simple/Django/ Reading http://www.djangoproject.com/ Best match: Django 1.3 Downloading http://pypi.python.org/packages/source/D/Django/Django-1.3.tar.gz#md5=1b8f76e91c27564708649671f329551f Processing Django-1.3.tar.gz Running Django-1.3/setup.py -q bdist_egg --dist-dir /tmp/easy_install- Fwze7Y/Django-1.3/egg-dist-tmp-3LfoS9 zip_safe flag not set; analyzing archive contents... django.test.simple: module references __file__ django.test._doctest: module references __file__ django.test._doctest: module MAY be using inspect.getsourcefile django.conf.__init__: module references __file__ django.conf.project_template.manage: module references __file__ django.contrib.admindocs.views: module references __file__ django.contrib.sitemaps.tests.basic: module references __file__ django.contrib.gis.geometry.test_data: module references __file__ django.contrib.gis.tests.layermap.tests: module references __file__ django.contrib.gis.tests.geo3d.tests: module
Re: Failure upgrading to 1.6
On Tue, Sep 6, 2011 at 10:08 AM, Kannaiyan Natesan gbpnk...@gmail.comwrote: INDEX command denied to user 'rb'@'localhost' for table 'accounts_localsiteprofile') Seems a Database Issue. Did you verify permissions for this user on Database? Kannaiyan Right, it looks like the user just doesn't have all the necessary permissions. Quickest thing to do is: GRANT ALL ON yourdbname.* to rb@localhost; You could instead do INDEX instead of ALL, I think, but might be safest to just give the user the permissions it needs to manipulate that database. Your database isn't corrupt, but you're probably not at a spot now where you'd be able to downgrade. Christian -- Christian Hammond - chip...@chipx86.com Review Board - http://www.reviewboard.org VMware, Inc. - http://www.vmware.com -- Want to help the Review Board project? Donate today at http://www.reviewboard.org/donate/ Happy user? Let us know at http://www.reviewboard.org/users/ -~--~~~~--~~--~--~--- To unsubscribe from this group, send email to reviewboard+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/reviewboard?hl=en -- Want to help the Review Board project? Donate today at http://www.reviewboard.org/donate/ Happy user? Let us know at http://www.reviewboard.org/users/ -~--~~~~--~~--~--~--- To unsubscribe from this group, send email to reviewboard+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/reviewboard?hl=en