[Django Code] #5776: Conflict between tutorial and 'Get your database running' section of the 'How to install Django' page

[Django Code]

#5776: Conflict between tutorial and 'Get your database running' section of the
'How to install Django' page
--------------------------------+-------------------------------------------
Reporter:  [EMAIL PROTECTED]  |       Owner:  nobody       
  Status:  new                  |   Component:  Documentation
 Version:  0.96                 |    Keywords:               
   Stage:  Unreviewed           |   Has_patch:  0            
--------------------------------+-------------------------------------------
 This snippet from the 'Get your database running' section of the 'How to
 install Django' page specifies a limited set of permissions needed for the
 database user:

 If you plan to use Django’s manage.py syncdb command to automatically
 create database tables for your models, you’ll need to ensure that Django
 has permission to create tables in the database you’re using; if you plan
 to manually create the tables, you can simply grant Django SELECT, INSERT,
 UPDATE and DELETE permissions. Django does not issue ALTER TABLE
 statements, and so will not require permission to do so. If you will be
 using Django’s testing framework with data fixtures, Django will need
 permission to create a temporary test database.

 ----

 However running through the tutorial caused these errors that were
 corrected by adding ALTER and INDEX permissions:

 prompt:~/development/tutsite XXX$ python2.4 manage.py syncdb
         Creating table auth_message
         Creating table auth_group
         Creating table auth_user
         Traceback (most recent call last):
           File "manage.py", line 11, in ?
             execute_manager(settings)
           File "/opt/local/lib/python2.4/site-
 packages/django/core/management.py", line 1672, in execute_manager
             execute_from_command_line(action_mapping, argv)
           File "/opt/local/lib/python2.4/site-
 packages/django/core/management.py", line 1571, in
 execute_from_command_line
             action_mapping[action](int(options.verbosity),
 options.interactive)
           File "/opt/local/lib/python2.4/site-
 packages/django/core/management.py", line 534, in syncdb
             cursor.execute(statement)
           File "/opt/local/lib/python2.4/site-
 packages/django/db/backends/util.py", line 12, in execute
             return self.cursor.execute(sql, params)
           File "/opt/local/lib/python2.4/site-
 packages/MySQLdb/cursors.py", line 163, in execute
             self.errorhandler(self, exc, value)
           File "/opt/local/lib/python2.4/site-
 packages/MySQLdb/connections.py", line 35, in defaulterrorhandler
             raise errorclass, errorvalue
         _mysql_exceptions.OperationalError: (1142, "ALTER command denied
 to user 'django'@'localhost' for table 'auth_message'")

         ------------------------

         prompt:~/development/tutsite XXX$ python2.4 manage.py syncdb
         Creating table auth_permission
         Creating table django_content_type
         Creating table django_session
         Creating table django_site
         Installing index for auth.Permission model
         Failed to install index for auth.Permission model: (1142, "INDEX
 command denied to user 'django'@'localhost' for table
 'auth_permission'")Loading 'initial_data' fixtures...
         No fixtures found.

-- 
Ticket URL: <http://code.djangoproject.com/ticket/5776>
Django Code <http://code.djangoproject.com/>
The web framework for perfectionists with deadlines
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en
-~----------~----~----~----~------~----~------~--~---