Permission denied: Cannot write in table 'pi3server' from client code

Anvil Q&A
1

I try to monitor a tempsensor running through my RaspberryPi.
I made the Anvil the Form and the Data tables with the permissions Read and Search for the Form and to search,edit and delete for the Server modules.
When is start my pythonprgram (through a VNC connection) in my PI, i get the error message:
InternalError: Permission denied: Cannot write in table ‘pi3server’ from client code

Python code on Client
Python code on Client3245×2035 662 KB

Please help to solve my problem, thanks in advance

2

You can actually check this yourself.

In your Anvil IDE for this App, what permissions do you have set on this Table? Are Clients allowed to access this Table? The default is no access, as shown below:
image

For more details, see Data Security and Uplink Security.

1 Like
3

Thanks for your reply. I made the Anvil the Form and the Data tables with the permissions Read and Search for the Form and to search,edit and delete for the Server modules.
What else must i do to make it possible for a Client to access the Datatables?

Datatable on Anvil
Datatable on Anvil2752×1827 290 KB

4

Hi @robkoopman,

Looks like you’re using the client uplink key. This gives your script the more restricted privileges of client-side code. Because you have only granted your Forms search permissions on Data Tables, you cannot use your Uplink script to write to your Data Table.

If you use the server uplink key instead, your script will be given the privileges of Server-side code, which you have configured to include the ability to search, edit and delete Data Table data.

5

Hi Bridget, i’am learning.
You solved my problem, thank you very much.