I use a predefined way to establish an sql database connection with streamlit. This works fine till today, as I had to switch to another server. No connection is possible since then. The error is:
(MySQLdb.OperationalError) (3159, ‘Connections using insecure transport are prohibited while --require_secure_transport=ON.’)
(Background on this error at: Error Messages — SQLAlchemy 2.0 Documentation)
After some research it is due the new server requires secure transport. I tried to change this on server side, but have no rights. So I need a way to pass SSL credentials via st.experimental connection.
Any ideas how to do this?
from sqlalchemy import text import streamlit as st # Establish connection to mysql server, secrets are defined in .streamlit/secrets.toml @st.cache_resource def init_connection(): return st.experimental_connection('mysql',type='sql',autocommit=False) conn = init_connection() # Cache data from mysql database @st.cache_data#(ttl=600) def run_query(): return conn.query('SELECT * from parlist;')#, ttl=600) df = run_query()
Possibility for mysql access.
No access possible due to missing credentials for SSL - don´t know how to pass arguments / files to st.experimental_connection
- Streamlit version: 1.27.2
- Python version: 3.9.17