hi Ed
you have configured the DB with the sqlite3 driver and you point the NAME db to
a mysql folder.
you need to put the folder for your sqlite database.
cheers,
El 10/04/2012, a las 23:15, Ed McLaughlin escribió:
> DATABASES = {
> 'default': {
> 'ENGINE': 'django.db.backends.sqlite3', # Add
> 'postgresql_psycopg2', 'mysql', 'sqlite3' or 'oracle'.
> 'NAME': '/usr/local/mysql/data/mysite', #
> Or path to database file if using sqlite3.
> 'USER': '', # Not used with sqlite3.
> 'PASSWORD': '', # Not used with sqlite3.
> 'HOST': '', # Set to empty string for
> localhost. Not used with sqlite3.
> 'PORT': '', # Set to empty string for
> default. Not used with sqlite3.
> }
> }
>
> On Apr 10, 4:27 am, Ejah <[email protected]> wrote:
>> Can you post the db part of your settings file?
>>
>> On 10 apr, 06:05, Ed McLaughlin <[email protected]> wrote:
>>
>>
>>
>>
>>
>>
>>
>>> _mysql.so is in there. When I try using sqlite I get this:
>>
>>> Eds-MacBook-Air:mysite3 edmclaugh76$ python manage.py syncdb
>>> Traceback (most recent call last):
>>> File "manage.py", line 10, in <module>
>>> execute_from_command_line(sys.argv)
>>> File "/Library/Python/2.7/site-packages/django/core/management/
>>> __init__.py", line 443, in execute_from_command_line
>>> utility.execute()
>>> File "/Library/Python/2.7/site-packages/django/core/management/
>>> __init__.py", line 382, in execute
>>> self.fetch_command(subcommand).run_from_argv(self.argv)
>>> File "/Library/Python/2.7/site-packages/django/core/management/
>>> base.py", line 196, in run_from_argv
>>> self.execute(*args, **options.__dict__)
>>> File "/Library/Python/2.7/site-packages/django/core/management/
>>> base.py", line 232, in execute
>>> output = self.handle(*args, **options)
>>> File "/Library/Python/2.7/site-packages/django/core/management/
>>> base.py", line 371, in handle
>>> return self.handle_noargs(**options)
>>> File "/Library/Python/2.7/site-packages/django/core/management/
>>> commands/syncdb.py", line 57, in handle_noargs
>>> cursor = connection.cursor()
>>> File "/Library/Python/2.7/site-packages/django/db/backends/
>>> __init__.py", line 306, in cursor
>>> cursor = self.make_debug_cursor(self._cursor())
>>> File "/Library/Python/2.7/site-packages/django/db/backends/sqlite3/
>>> base.py", line 281, in _cursor
>>> self._sqlite_create_connection()
>>> File "/Library/Python/2.7/site-packages/django/db/backends/sqlite3/
>>> base.py", line 271, in _sqlite_create_connection
>>> self.connection = Database.connect(**kwargs)
>>> sqlite3.OperationalError: unable to open database file
>>
>>> Any ideas? I really appreciate the help!
>>
>>> On Apr 9, 10:16 pm, Mario Gudelj <[email protected]> wrote:
>>
>>>> Go to
>>>> /Library/Python/2.7/site-packages/MySQL_python-1.2.3-py2.7-macosx-10.7-inte
>>>> l.egg/
>>>> on your Mac and see if _mysql.so is int there. You may need to re-install
>>>> MySQL_python connector. Maybe this can
>>>> helphttp://www.brambraakman.com/blog/comments/installing_mysql_python_mys...
>>
>>>> Otherwise, you can always use SQlite for dev environment until you go to
>>>> production. I find it a lot easier to manage.
>>
>>>> On 10 April 2012 10:54, Ed McLaughlin <[email protected]> wrote:
>>
>>>>> Hello! I am working through the Django tutorial (
>>>>> https://docs.djangoproject.com/en/1.4/intro/tutorial01/) and I have
>>>>> hit a roadblock in the 'database setup' portion of part 1. When I
>>>>> enter the command 'python manage.py syncdb' I get the error below. I
>>>>> believe I properly installed MySQL Community Server and mysqldb....
>>>>> Any help would be GREATLY appreciated.
>>
>>>>> Eds-MacBook-Air:mysite edmclaugh76$ python manage.py syncdb
>>>>> Traceback (most recent call last):
>>>>> File "manage.py", line 10, in <module>
>>>>> execute_from_command_line(sys.argv)
>>>>> File "/Library/Python/2.7/site-packages/django/core/management/
>>>>> __init__.py", line 443, in execute_from_command_line
>>>>> utility.execute()
>>>>> File "/Library/Python/2.7/site-packages/django/core/management/
>>>>> __init__.py", line 382, in execute
>>>>> self.fetch_command(subcommand).run_from_argv(self.argv)
>>>>> File "/Library/Python/2.7/site-packages/django/core/management/
>>>>> __init__.py", line 261, in fetch_command
>>>>> klass = load_command_class(app_name, subcommand)
>>>>> File "/Library/Python/2.7/site-packages/django/core/management/
>>>>> __init__.py", line 69, in load_command_class
>>>>> module = import_module('%s.management.commands.%s' % (app_name,
>>>>> name))
>>>>> File "/Library/Python/2.7/site-packages/django/utils/importlib.py",
>>>>> line 35, in import_module
>>>>> __import__(name)
>>>>> File "/Library/Python/2.7/site-packages/django/core/management/
>>>>> commands/syncdb.py", line 8, in <module>
>>>>> from django.core.management.sql import custom_sql_for_model,
>>>>> emit_post_sync_signal
>>>>> File "/Library/Python/2.7/site-packages/django/core/management/
>>>>> sql.py", line 6, in <module>
>>>>> from django.db import models
>>>>> File "/Library/Python/2.7/site-packages/django/db/__init__.py", line
>>>>> 40, in <module>
>>>>> backend = load_backend(connection.settings_dict['ENGINE'])
>>>>> File "/Library/Python/2.7/site-packages/django/db/__init__.py", line
>>>>> 34, in __getattr__
>>>>> return getattr(connections[DEFAULT_DB_ALIAS], item)
>>>>> File "/Library/Python/2.7/site-packages/django/db/utils.py", line
>>>>> 92, in __getitem__
>>>>> backend = load_backend(db['ENGINE'])
>>>>> File "/Library/Python/2.7/site-packages/django/db/utils.py", line
>>>>> 24, in load_backend
>>>>> return import_module('.base', backend_name)
>>>>> File "/Library/Python/2.7/site-packages/django/utils/importlib.py",
>>>>> line 35, in import_module
>>>>> __import__(name)
>>>>> File "/Library/Python/2.7/site-packages/django/db/backends/mysql/
>>>>> base.py", line 16, in <module>
>>>>> raise ImproperlyConfigured("Error loading MySQLdb module: %s" % e)
>>>>> django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb
>>>>> module: dlopen(/Library/Python/2.7/site-packages/MySQL_python-1.2.3-
>>>>> py2.7-macosx-10.7-intel.egg/_mysql.so, 2): Library not loaded:
>>>>> libmysqlclient.18.dylib
>>>>> Referenced from: /Library/Python/2.7/site-packages/
>>>>> MySQL_python-1.2.3-py2.7-macosx-10.7-intel.egg/_mysql.so
>>>>> Reason: image not found
>>>>> Eds-MacBook-Air:mysite edmclaugh76$
>>
>>>>> Thanks!!!
>>
>>>>> --
>>>>> You received this message because you are subscribed to the Google Groups
>>>>> "Django users" group.
>>>>> To post to this group, send email to [email protected].
>>>>> To unsubscribe from this group, send email to
>>>>> [email protected].
>>>>> For more options, visit this group at
>>>>> http://groups.google.com/group/django-users?hl=en.
>
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected].
> For more options, visit this group at
> http://groups.google.com/group/django-users?hl=en.
>
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
