i cant get litespeed django venv to wrok .

Hi @haujo01 @healthzoneriyadh @bgv ,

I have updated the doc FAQ here in case you need more information.

https://docs.litespeedtech.com/cloud/images/django/#how-do-i-switch-sqlite-to-mysql

For some reason you got 500/503, also No module named ‘encodings’ cases, please try updating the environment variable via Web Admin > Virtual Hosts > Context like below:

• Ubuntu 18:

PYTHONPATH=/usr/local/lsws/Example/html/lib/python3.6:/usr/local/lsws/Example/html/demo
LS_PYTHONBIN=/usr/local/lsws/Example/html/bin/python

• Ubuntu 20:

PYTHONPATH=/usr/local/lsws/Example/html/lib/python3.8:/usr/local/lsws/Example/html/demo
LS_PYTHONBIN=/usr/local/lsws/Example/html/bin/python

Let us know if you need any help.

Best, Eric

Hi,

It’s been a while so I tried to setup mysql with OLS Django again, and it still works.

Here’s my steps.

1. Launch OpenLiteSpeed Django Image
2. Active virtual environment by command

source /usr/local/lsws/Example/html/bin/activate

3. Follow DigitalOcean guide to

• Install packages

apt install mysql-server -y
apt install python3-dev libmysqlclient-dev default-libmysqlclient-dev -y
pip3 install mysqlclient

• Create the Database

sudo mysql -u root
mysql>

CREATE DATABASE blog_data;
CREATE USER 'djangouser'@'%' IDENTIFIED WITH mysql_native_password BY 'password';
GRANT ALL ON blog_data.* TO 'djangouser'@'%';
FLUSH PRIVILEGES;

• Edit django DB settings

/usr/local/lsws/Example/html/demo/demo/settings.py

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'OPTIONS': {
            'read_default_file': '/etc/mysql/my.cnf',
        },
    }
}

• Create MySQL credentials

nano /etc/mysql/my.cnf

[client]
database = blog_data
user = djangouser
password = password
default-character-set = utf8

• Reload DB

systemctl daemon-reload
systemctl restart mysql

• Apply changes to Django

python3 manage.py migrate

We can try to verify the mysql DB

1. mv db.sqlite3 to other place

2. Create superuser

python3 manage.py createsuperuser

Now you should see an entry generated under blog_data.auth_user

I have this exact same problem.

It specifically has to do with the PYTHON environment. When I remove that it works fine. When I keep it in, it doesn’t.

Any progress on a solution? It’s been over a year!

I have the same problem please your support community

Hi,

I followed your steps , however I noticed that you miss one conf

below context setting up “Application Type”, the line “startup file” , could you please add this ?

testapp/wsgi.py

this is my settings.py , the part about DB

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'django',
        'USER': 'django',
        'PASSWORD': '123456789',
        'HOST': 'localhost',
        'PORT': '',
        'OPTIONS': {
        'autocommit': True,
        'charset': 'utf8mb4',
    },
}

Did you run manage.py migrate?

no 500 or 503 error , however if I remove that startup file line , I do have 500 error

(venv) root@openlitespeed-django-s-1vcpu-1gb-ams3-01:/usr/local/lsws/Example/testapp# curl -I -XGET http://xxx.xxx.xxx/testapp/admin/
HTTP/1.1 302 Found
Content-Type: text/html; charset=utf-8
Location: /testapp/admin/login/?next=/testapp/admin/
Expires: Thu, 09 May 2019 13:40:58 GMT
Cache-Control: max-age=0, no-cache, no-store, must-revalidate
X-Frame-Options: SAMEORIGIN
Vary: Cookie
Content-Length: 0
Date: Thu, 09 May 2019 13:40:58 GMT
Server: LiteSpeed
Connection: Keep-Alive

Best regards,

Below are the steps to break it. I just tried this whit the same results. Can you provide the context of you tested and the settings.py. I would like to see it.

Here are the steps.

cd /usr/local/lsws/Example/

virtualenv -p python3 venv

source venv/bin/activate

pip install django

django-admin startproject testapp

vi testapp/testapp/settings.py

change ALLOWED_HOSTS = [‘*’]

add STATIC_URL = ‘/testapp/static/’ STATIC_ROOT = ‘/usr/local/lsws/Example/testapp/public/static’

cd testapp

mkdir -p public/static python manage.py collectstatic

chown -R nobody:nogroup /usr/local/lsws/Example/testapp

Set up Context Type = App Server

URI = /testapp/

Location = /usr/local/lsws/Example/testapp

Binary Path = /usr/local/lsws/fcgi-bin/lswsgi

Application Type = WSGI

save and recycle litespeed

goto http://xxxx/testapp/admin

test and it will work

edit Context add

Environment = PYTHONHOME=/usr/local/lsws/Example/venv/

save and recycle litespeed

test and it will work

Now for the fun.

vi testapp/testapp/settings.py

comment out the sqllite3.

add

DATABASES = { ‘default’: { ‘NAME’: ‘testappdb’, ‘ENGINE’: ‘mysql.connector.django’, ‘USER’: ‘testuser’, ‘PASSWORD’: ‘testuser’, ‘HOST’: ‘10.10.10.10’, ‘OPTIONS’: { ‘autocommit’: True, ‘charset’: ‘utf8mb4’, }, } }

pip install django-mysql

pip install mysql-connector-python==8.0.5 (I use this version because the newer ones have too many problems)

test and it will give 503 or 500 or just spin.

python manage.py runserver 0.0.0.0:8000

goto http://xxxx:8000/testapp/admin

This will work.

Hi,

Could you please provide a detail step for how to trigger/reproduce it ?

All I need to do to break it is set the example to use Mysql.

I set it to mysql , but it works on my test server.

Best regards,

The only way I could get things to work was to remove PYTHONHOME=/usr/local/lsws/Example/venv/ then copy all my modules to /usr/local/lib/python3.6/dist-packages. This is a work around and not using venv.

Understood, we will try to reproduce it locally first and update you soon.

Hi,

Yes that was the 1 st thing I did. I just tried again and I get the same result.