If mysite is a directory, rather than a file, then Daniel is correct.
On Apr 10, 2012 5:33 PM, "andrea mucci" <cingus...@gmail.com> wrote:
> 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 <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.
> >
>
> --
> 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.
