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$
> 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+unsubscribe@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/django-users?hl=en.
_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+unsubscribe@googlegroups.com.
> > For more options, visit this group at
> >http://groups.google.com/group/django-users?hl=en.
> _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+unsubscribe@googlegroups.com.
> > > For more options, visit this group at
> > >http://groups.google.com/group/django-users?hl=en.
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:
> 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.
> > > > --
> > > > 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+unsubscribe@googlegroups.com.
> > > > For more options, visit this group at
> > > >http://groups.google.com/group/django-users?hl=en.
On Tuesday, 10 April 2012 22:15:40 UTC+1, Ed McLaughlin wrote:
> 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. > } > }
You haven't given the path to a file in the NAME value, as requested - you've given the path to a directory. -- DR.
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 <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+unsubscribe@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+unsubscribe@googlegroups.com. > For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
Can you try creating a file in that directory at the top of your settings.py file? On Apr 10, 2012 5:15 PM, "Ed McLaughlin" <edmclaug...@gmail.com> wrote:
> 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.
> > > > > -- > > > > > 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+unsubscribe@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+unsubscribe@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/django-users?hl=en.
> 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 <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+unsubscribe@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+unsubscribe@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+unsubscribe@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/django-users?hl=en.
DATABASES = { 'default': { 'ENGINE': 'django.db.backends.sqlite3', # Add 'postgresql_psycopg2', 'postgresql', 'mysql', 'sqlite3' or 'oracle'. 'NAME': os.path.join(SITE_ROOT,'sqlite.db'), # 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. }
}
El 10/04/2012, a las 23:34, william ratcliff escribió:
> Can you try creating a file in that directory at the top of your settings.py file?
> On Apr 10, 2012 5:15 PM, "Ed McLaughlin" <edmclaug...@gmail.com> wrote: > 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.
> > > > > -- > > > > > 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+unsubscribe@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+unsubscribe@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+unsubscribe@googlegroups.com. > For more options, visit this group at http://groups.google.com/group/django-users?hl=en.