Using PythonAnywhere with XL Routes Static IP's

PythonAnywhere can present a problem for our usual QGTunnel/Procfile solution because it doesn’t allow users to run their own binaries, so we created a monkey patch solution that has worked for quite a few customers.

Here is an example using MySQL and some pips we selected for the patch. If you already have other pips setup, please contact our Support if this solution doesn’t work so we can figure out a way to make it work for you.

Our test: Tested to work with Python 3 using mysql-connector-python through PySocks

1) Download https://github.com/xlroutes/pymysql-example.

2) Please read the README.md file for details on how to use the test application.

3) Install the pips in the requirements.txt file: pip install -r requirements.txt

4) Setup the environment variables xlroutesSTATIC_URL or xlroutesSHIELD_URL from the xlroutes dashboard.

For example: http://username:password@hostname.xlroutes.com:9293

NOTE: HTTP and SOCKS URL’s are fine, app.py will handle either.

5) Setup your database connection environment variable DATABASE.

For example: mysql://username:password@database.hostname.com:3306/database-name

6) Run the application: python app.py

If this doesn’t work, just write us at Support. We’ll figure it out for you so you can get running.

---