Android Flet App accessing Detabase in the cloud error message: [SSL: CERTIFICATE_VERIFY_FAILED]

[fsmosca]

Question

I built an android sample todo app using flet build apk, see also the full codes in the Code sample section. The App just takes an input from the users and save it in Detabase in Deta space cloud.

This setup worked in windows 10 without issues.

I have three files namely: .env, requirements.txt and main.py.

In my android device Samsung Galaxy A14 with latest update installed, I got this error message:

[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1006)

This is triggered in the following code, when I try to fetch entries in the Detabase, and is captured by the SnackBar.

    def build_table_cells(db):
        """Gets entries from detabase."""
        try:
            response = db.fetch()
        except Exception as err:
            page.snack_bar = ft.SnackBar(
                content=ft.Text(f'error message: {err}'),
                action="Alright!",
                duration=10000,
            )
            page.snack_bar.open = True
            page.update()
        else:
            return [ft.DataRow(cells=[ft.DataCell(ft.Text(v['task']))]) for v in response.items]
        return []

Does this issue related to my device, or deta space or from the flet's built apk?

Code sample

.env

DATA_KEY = 'XXXXXXXX'

requirements.txt

flet
deta
python-dotenv

main.py

import os

import flet as ft
from deta import Deta
from dotenv import load_dotenv


load_dotenv()


def main(page: ft.Page):
    # Initialize deta
    deta = Deta(os.getenv('DATA_KEY'))
    db = deta.Base("todo_db")

    def get_data_key(e):
        """Show data key."""
        page.snack_bar = ft.SnackBar(
            content=ft.Text(os.getenv('DATA_KEY')),
            action="Alright!",
            duration=5000,
        )
        page.snack_bar.open = True
        page.update()

    def add_task(e):
        """Adds task from user input."""
        page.add(ft.Checkbox(label=new_task.value))

        # Update detabase and table.
        try:
            db.put({"task": new_task.value})
        except Exception as err:
            page.snack_bar = ft.SnackBar(
                content=ft.Text(f'error message: {err}'),
                action="Alright!",
                duration=10000,
            )
            page.snack_bar.open = True
            page.update()
        else:
            dcell = build_table_cells(db)
            table.rows = dcell

        new_task.value = ""
        page.update()

    def build_table_cells(db):
        """Gets entries from detabase."""
        try:
            response = db.fetch()
        except Exception as err:
            page.snack_bar = ft.SnackBar(
                content=ft.Text(f'error message: {err}'),
                action="Alright!",
                duration=10000,
            )
            page.snack_bar.open = True
            page.update()
        else:
            return [ft.DataRow(cells=[ft.DataCell(ft.Text(v['task']))]) for v in response.items]
        return []
    
    # Init table.
    table = ft.DataTable(
        columns=[
            ft.DataColumn(ft.Text("Task")),
        ]
    )

    # Add data cells in table from detabase.
    dcell = build_table_cells(db)
    table.rows = dcell

    new_task = ft.TextField(hint_text="Whats needs to be done?")

    # Build the UI
    page.add(
        ft.Column(
            controls=[
                ft.ElevatedButton("Query Deta Key", on_click=get_data_key),
                ft.Row(
                    controls=[
                        new_task,
                        ft.FloatingActionButton(icon=ft.icons.ADD, on_click=add_task)
                    ]
                ),
                ft.Text('Task List', weight=ft.FontWeight.BOLD),  # table header
                ft.Column(
                    controls=[                        
                        table
                    ],
                    scroll=ft.ScrollMode.ADAPTIVE,
                    height=200
                )
            ]
        )
    )


ft.app(target=main)

### Error message

```bash
[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1006)

------------------------------------------------------

• I have searched for answers to my question both in the issues and in previous discussions.

[FeodorFitsner]

Add the following code to main.py of your Flet app to "fix" SSL issue on both iOS and Android:

import certifi
import os

os.environ["REQUESTS_CA_BUNDLE"] = certifi.where()
os.environ["SSL_CERT_FILE"] = certifi.where()

if os.getenv("FLET_PLATFORM") == "android":
    import ssl

    def create_default_context(
        purpose=ssl.Purpose.SERVER_AUTH, *, cafile=None, capath=None, cadata=None
    ):
        return ssl.create_default_context(
            purpose=purpose, cafile=certifi.where(), capath=capath, cadata=cadata
        )

    ssl._create_default_https_context = create_default_context

Hope that helps.

I'm going to document that.

[fsmosca]

Thanks a lot, it worked.

[ingdesarr1]

I have the same issue but my app is for Windows. I create the exe with auto-py-to-exe and then create a installer with Inno setup. How ca I resolve the problem?