Hello everyone,
I am running through the tutorial and setting up my first django
project. Quite exciting! However I have run into trouble connecting to
MySQL. My settings.py file looks like this:
DATABASE_ENGINE = 'mysql' # 'postgresql_psycopg2',
'postgresql', 'mysql', 'sqlite3' or 'oracle'.
DATABASE_NAME = 'test' # Or path to database file if using
sqlite3.
DATABASE_USER = 'root' # Not used with sqlite3.
DATABASE_PASSWORD = '' # Not used with sqlite3.
DATABASE_HOST = '' # Set to empty string for localhost.
Not used with sqlite3.
DATABASE_PORT = '' # Set to empty string for default. Not
used with sqlite3.
Yes, the username is 'root' and there is no password. This is on my
local machine (OS X 10.5) so it doesn't matter.
When I run...
$ python manage.py syncdb
I get the following...
Traceback (most recent call last):
File "manage.py", line 11, in <module>
execute_manager(settings)
File "/Library/Python/2.5/site-packages/django/core/management/
__init__.py", line 340, in execute_manager
utility.execute()
File "/Library/Python/2.5/site-packages/django/core/management/
__init__.py", line 295, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/Library/Python/2.5/site-packages/django/core/management/
base.py", line 192, in run_from_argv
self.execute(*args, **options.__dict__)
File "/Library/Python/2.5/site-packages/django/core/management/
base.py", line 218, in execute
self.validate()
File "/Library/Python/2.5/site-packages/django/core/management/
base.py", line 246, in validate
num_errors = get_validation_errors(s, app)
File "/Library/Python/2.5/site-packages/django/core/management/
validation.py", line 65, in get_validation_errors
connection.validation.validate_field(e, opts, f)
File "/Library/Python/2.5/site-packages/django/db/backends/mysql/
validation.py", line 8, in validate_field
db_version = connection.get_server_version()
File "/Library/Python/2.5/site-packages/django/db/backends/mysql/
base.py", line 277, in get_server_version
self.cursor()
File "/Library/Python/2.5/site-packages/django/db/backends/
__init__.py", line 56, in cursor
cursor = self._cursor(settings)
File "/Library/Python/2.5/site-packages/django/db/backends/mysql/
base.py", line 262, in _cursor
self.connection = Database.connect(**kwargs)
File "/Users/audleman/django_projects/pollster/__init__.py", line
74, in Connect
File "/Library/Python/2.5/site-packages/MySQL_python-1.2.2-py2.5-
macosx-10.5-i386.egg/MySQLdb/connections.py", line 170, in __init__
_mysql_exceptions.OperationalError: (2002, "Can't connect to local
MySQL server through socket '/tmp/mysql.sock' (2)")
I'm not exactly sure what this socket is or why django can't find it.
One thought is that I installed LAMP on my machine using XAMPP, which
puts everything in the /Applications/xampp directory. Poking around, I
managed to find a mysql.sock file here:
/Applications/xampp/xamppfiles/var/mysql/mysql.sock
Assuming this is the correct socket, how do I tell django where to
find it?
Thanks,
Kevin
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
