django mysql not working on pythonanywhere

Question

I have tried 3 ways to access the database:

[WORKS] from bash shell: ~$ mysql -u <username> -h mysql.server -p '<username>$<db_name>'
[WORKS] ~$ python manage.py syncdb
[DOES NOT WORK]
- Syncdb
- Reload app
- Go to url

Error:

_mysql_exceptions.OperationalError: (1045, "Access denied for user '<username>'@'ip-10-186-190-7.ec2.internal' (using password: NO)")

Settings:

DATABASES = {
  'default': {
    'ENGINE': 'django.db.backends.mysql',
    'NAME': '<username>$<db_name>',
    'USER': '<username>',
    'PASSWORD': <password>,
    'HOST': 'mysql.server',
    'PORT': '3306',
  }
}

Pythonanywhere's wsgi module is loading the correct settings script. The database password has been set and checked in the 'Databases' tab.

I am using Django 1.7, Python 3.4, mysqlclient 1.3.4, inside a virtualenv.

Thanks for your help.

[Edit]:

The first error is actually:

AttributeError: 'SessionStore' object has no attribute '_session_cache'

I don't know if this is meaningful.

arkaeologic · Accepted Answer · 2015-01-09 01:28:11Z

4

The problem was the lack of database connection, and not related specifically to the session backend. I was providing the password for the database though an os.environ variable. This has to be set in the python anywhere wsgi script:

os.environ['DB_PWD'] = '<password>'

All fixed.

edited Jan 9, 2015 at 1:28

answered Jan 8, 2015 at 11:20

arkaeologic

859 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

arkaeologic Over a year ago

Haha. Yes. Thanks for spotting that. My mac thinks it knows best.

Dmitry Over a year ago

Thanks @arkaeologic for the tip on how to setup wsgi file. In my settings.py I'm grabbing all my database info from env. variables like so:

DATABASES = {     'default': {         'ENGINE': 'django.db.backends.mysql',         'NAME': environ['DB_NAME'],         'USER': environ['DB_USERNAME'],         'PASSWORD': environ['DB_PASSWORD'],         'HOST': environ['DB_HOST'],         'PORT': '',     } }

Dmitry Over a year ago

This instructions also helped me

Collectives™ on Stack Overflow

django mysql not working on pythonanywhere

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related