Skip to content
This repository has been archived by the owner on Oct 2, 2020. It is now read-only.

The data in MySQL is unavailable in the website. #12

Open
sysulawliet opened this issue Jul 4, 2017 · 4 comments
Open

The data in MySQL is unavailable in the website. #12

sysulawliet opened this issue Jul 4, 2017 · 4 comments

Comments

@sysulawliet
Copy link

I have run the website and can visit the website but the data in MySQL is unavailable. So, how can I connect the website with MySQL?

@apavlo
Copy link
Member

apavlo commented Jul 4, 2017

I have run the website and can visit the website but the data in MySQL is unavailable.

What does that mean? Can you provide the error message?

@sysulawliet
Copy link
Author

I can open the website by the port 8000 but I can not see any data from MySQL shown in the website. So, are there some things wrong in the connection between the website and MySQL. I have edited the credentials.py file:

# SECURITY WARNING: keep the secret key used in production secret!
SECRET_KEY = '123'

## ==============================================
## DATABASE CONFIGURATION
## ==============================================

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'ottertune', 
        'USER': 'root',
        'PASSWORD': '123321',
        'HOST': '',
        'PORT': '',
        'OPTIONS': {
            'init_command': "SET sql_mode='STRICT_TRANS_TABLES',innodb_strict_mode=1",
        },
    }
}

@dvanaken
Copy link

dvanaken commented Jul 5, 2017

Can you sign up as a new user and login successfully?

@sysulawliet
Copy link
Author

Yes, I can.
I can create my project and know the Application Info. But there are no data available in the table of Filtered Results. How can I use ottertune to adjust the parameters of MySql by the website automatically?

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants