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 <ej.huijb...@gmail.com> wrote:
> Can you post the db part of your settings file?
>
> On 10 apr, 06:05, Ed McLaughlin <edmclaug...@gmail.com> 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 <mario.gud...@gmail.com> 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 <edmclaug...@gmail.com> 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 django-users@googlegroups.com.
> > > > To unsubscribe from this group, send email to
> > > > django-users+unsubscr...@googlegroups.com.
> > > > 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 django-users@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
