python012/guest

Web project for web programming and interface testing practice.

Guest

A Web project based on Django, used for Web programming and Web API testing practice.

Installed apps:

• sign

Commands

• python3 manage.py runserver or python3 manage.py runserver 127.0.0.1:8001 to launch the site.
• python3 manage.py shell to enable Django shell console

How to install Mysql in Ubuntu 16.04 and enable remote-access

1. sudo apt-get install mysql-server, sudo apt isntall mysql-client, sudo apt install libmysqlclient-dev.
2. Use sudo netstat -tap | grep mysql to check whether mysql is running, open mysql console using mysql -uroot -p.
3. To enable remote-access, sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf and comment the line of bind-address = 127.0.0.1.
4. Open mysql console again, execute grant all on *.* to root@'%' identified by 'ROOT-PASSWORD' with grant option; and flush privileges;.
5. Quit mysql console and restart mysql service by service mysql restart.

Setup

• Mysql service is required, IP address, user name and password need be configured in guest/settings.py as part of DATABASES configuraiton.
• mysql> create database guest character set utf8; to init guest database in Mysql at very beiginning.
• python3 manage.py createsuperuser to create super user account.

Note for Testing

• To support interface API test and avoid CSRF varification failed error, the line of django.middleware.csrf.CsrfViewMiddleware of MIDDLEWARE in settings.py is disabled.
• Django rest framework is imported to implement interface API, try this(with HTTPie):

C:\Users\admin>http -a admin:admin01234 http://127.0.0.1:8000/rest/
HTTP/1.1 200 OK
Allow: GET, HEAD, OPTIONS
Content-Length: 183
Content-Type: application/json
Date: Tue, 26 Jun 2018 09:01:51 GMT
Server: WSGIServer/0.2 CPython/3.6.4
Vary: Accept, Cookie
X-Frame-Options: SAMEORIGIN

{
    "events": "http://127.0.0.1:8000/rest/events/",
    "groups": "http://127.0.0.1:8000/rest/groups/",
    "guests": "http://127.0.0.1:8000/rest/guests/",
    "users": "http://127.0.0.1:8000/rest/users/"
}

guest's Issues

django.db.utils.OperationalError: (1045:Access denied for user 'root'@'localhost' (using password: NO)

Got error django.db.utils.OperationalError: (1045:Access denied for user 'root'@'localhost' (using password: NO) when python3 manage.py migrate to init tables in Mysql