id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
8585	InterfaceError with MySQLdb set_character_set	khsing	nobody	"I have syncdb and runserver via console mode without any error. but when I want to run it via mod_python, and I got some error like this.
{{{
Environment:

Request Method: GET
Request URL: http://218.30.114.220/infocoll/admin/
Django Version: 1.0-beta_1-SVN-unknown
Python Version: 2.4.3
Installed Applications:
['django.contrib.auth',
 'django.contrib.contenttypes',
 'django.contrib.sessions',
 'django.contrib.admin',
 'infocoll.info',
 'infocoll.log']
Installed Middleware:
('django.middleware.common.CommonMiddleware',
 'django.contrib.sessions.middleware.SessionMiddleware',
 'django.contrib.auth.middleware.AuthenticationMiddleware',
 'django.middleware.doc.XViewMiddleware')


Traceback:
File ""/usr/lib/python2.4/site-packages/django/core/handlers/base.py"" in get_response
  86.                 response = callback(request, *callback_args, **callback_kwargs)
File ""/usr/lib/python2.4/site-packages/django/contrib/admin/sites.py"" in root
  155.         if not self.has_permission(request):
File ""/usr/lib/python2.4/site-packages/django/contrib/admin/sites.py"" in has_permission
  113.         return request.user.is_authenticated() and request.user.is_staff
File ""/usr/lib/python2.4/site-packages/django/contrib/auth/middleware.py"" in __get__
  5.             request._cached_user = get_user(request)
File ""/usr/lib/python2.4/site-packages/django/contrib/auth/__init__.py"" in get_user
  78.         user_id = request.session[SESSION_KEY]
File ""/usr/lib/python2.4/site-packages/django/contrib/sessions/backends/base.py"" in __getitem__
  46.         return self._session[key]
File ""/usr/lib/python2.4/site-packages/django/contrib/sessions/backends/base.py"" in _get_session
  168.                 self._session_cache = self.load()
File ""/usr/lib/python2.4/site-packages/django/contrib/sessions/backends/db.py"" in load
  15.                 expire_date__gt=datetime.datetime.now()
File ""/usr/lib/python2.4/site-packages/django/db/models/manager.py"" in get
  81.         return self.get_query_set().get(*args, **kwargs)
File ""/usr/lib/python2.4/site-packages/django/db/models/query.py"" in get
  295.         num = len(clone)
File ""/usr/lib/python2.4/site-packages/django/db/models/query.py"" in __len__
  151.                 self._result_cache = list(self.iterator())
File ""/usr/lib/python2.4/site-packages/django/db/models/query.py"" in iterator
  266.         for row in self.query.results_iter():
File ""/usr/lib/python2.4/site-packages/django/db/models/sql/query.py"" in results_iter
  200.         for rows in self.execute_sql(MULTI):
File ""/usr/lib/python2.4/site-packages/django/db/models/sql/query.py"" in execute_sql
  1613.         cursor = self.connection.cursor()
File ""/usr/lib/python2.4/site-packages/django/db/backends/__init__.py"" in cursor
  56.         cursor = self._cursor(settings)
File ""/usr/lib/python2.4/site-packages/django/db/backends/mysql/base.py"" in _cursor
  221.             self.connection = Database.connect(**kwargs)
File ""build/bdist.linux-x86_64/egg/MySQLdb/__init__.py"" in Connect
  74.     return Connection(*args, **kwargs)
File ""build/bdist.linux-x86_64/egg/MySQLdb/connections.py"" in __init__
  198.         self.set_character_set(charset)
File ""build/bdist.linux-x86_64/egg/MySQLdb/connections.py"" in set_character_set
  277.                 super(Connection, self).set_character_set(charset)

Exception Type: InterfaceError at /infocoll/admin/
Exception Value: (0, '')
}}}
here is some info of mine
* mysql 
{{{
Server version:		5.1.26-rc-log Source distribution
Protocol version:	10
Connection:		Localhost via UNIX socket
Server characterset:	utf8
Db     characterset:	utf8
Client characterset:	utf8
Conn.  characterset:	utf8
}}}
* host 
{{{
Linux JA_PUBLIC_TEST_114_220 2.6.18-53.el5 #1 SMP Mon Nov 12 02:14:55 EST 2007 x86_64 x86_64 x86_64 GNU/Linux
Python 2.4.3
MySQL-python-1.2.2
}}}

"		closed	contrib.admin	1.0-beta		worksforme			Unreviewed	0	0	0	0	0	0