Re: Failure upgrading to 1.6

2011-09-07 Thread Kannaiyan Natesan
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

2011-09-07 Thread Mak3r
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

2011-09-06 Thread Mak3r
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

2011-09-06 Thread Christian Hammond
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