Re: Non-clinical staff login crash

[Maria Scappini]

Hola, Karsten! :)

On 3/9/25 19:25, Karsten Hilbert wrote:

> I have added a workaround to be included in the next 1.8
> minor release. Meanwhile you can edit line 667 in
>
> 	/home/jessie/Desktop/GNUmed_ES/gnumed-client.1.8.19/Gnumed/pycommon/gmPG2.py
>
> to be commented out by putting a '#' in front of it such
> that it reads:
>
> 	# ("SELECT count(1) FROM clin.episode", "Episodes"),
>

Through trial and error, according to the errors I got (specified below) and going along with the workaround you gave me, I have commented lines 667 to 670, and 673 to 676 of the file you mentioned (gmPG2.py). 

This results in being able to login, with some limitations (attached short video):

- After login, I get many "Access denied" warnings/pop-ups listing the plugins that I cannot have access to.
- After all that, the client goes first to the 'Inbox' plugin (which any-staff doesn't have access to), so I get stuck in a warning pop-up loop, eventually crashing. Only sometimes if I'm fast enough, I can switch plugin tabs to 'Waiting list' between each pop-up and can use the client.
- I cannot search for patients if there is no exact match (i.e: if i write 'Kirk', i can access him, but if I write my last name, for which I have many test patients, I cannot get the list of the matching patients to choose from - I get access denied error again). But if there's an exact match, I can access the patient and add them to the waiting list.

- Plugins any-staff can access with no warnings: waiting list (gmWaitingListPlugin), attach documents (gmScanIdxMedDocsPlugin), print manager (gmPrintManagerPlugin), reports (gmDataMiningPlugin), appointments (gmKOrganizerPlugin), xDT viewer (gmXdtViewer).
- Plugins any-staff can "see" (appear in the client) but cannot access: inbox (gmProviderInboxPlugin) and demographics (gmNotebookedPatientEditionPlugin).

These are the errors (apart from the one on my first message) I got, in order, before commenting the lines I mentioned:

type: <class 'psycopg2.errors.InsufficientPrivilege'>
value: permission denied for table health_issue

  File "/home/jessie/Desktop/GNUmed_ES/gnumed-client.1.8.19/Gnumed/wxpython/gmGuiMain.py", line 3460, in OnInit
    if not self.__establish_backend_connection():
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/jessie/Desktop/GNUmed_ES/gnumed-client.1.8.19/Gnumed/wxpython/gmGuiMain.py", line 3639, in __establish_backend_connection
    connected = gmAuthWidgets.connect_to_database (
                ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/jessie/Desktop/GNUmed_ES/gnumed-client.1.8.19/Gnumed/wxpython/gmAuthWidgets.py", line 285, in connect_to_database
    text = gmPG2.get_db_fingerprint(eol = '\n')
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/jessie/Desktop/GNUmed_ES/gnumed-client.1.8.19/Gnumed/pycommon/gmPG2.py", line 699, in get_db_fingerprint
    curs.execute(cmd)
  File "/usr/lib/python3/dist-packages/psycopg2/extras.py", line 146, in execute
    return super().execute(query, vars)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
--------------------------------------------------

type: <class 'psycopg2.errors.InsufficientPrivilege'>
value: permission denied for table test_result

(...rest of the error same as the first one, same file and line)

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

type: <class 'psycopg2.errors.InsufficientPrivilege'>
value: permission denied for table vaccination

(...rest of the error same as the first one, same file and line)

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

type: <class 'psycopg2.errors.InsufficientPrivilege'>
value: permission denied for table org

(...rest of the error same as the first one, same file and line)

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

type: <class 'psycopg2.errors.InsufficientPrivilege'>
value: permission denied for table org_unit

(...rest of the error same as the first one, same file and line)

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

type: <class 'psycopg2.errors.InsufficientPrivilege'>
value: permission denied for schema audit
LINE 1: SELECT max(modified_when) FROM audit.audit_fields
                                       ^
(...rest of the error same as the first one, same file and line)

--------------------------------------------------
type: <class 'psycopg2.errors.InsufficientPrivilege'>
value: permission denied for schema audit
LINE 1: SELECT max(audit_when) FROM audit.audit_trail
                                    ^
(...rest of the error same as the first one, same file and line)

gnumed_any-staff_crash.mp4
Description: video/mp4