Re: Syntax error on pgAdmin4 start

I installed pgAdmin, as usual using Suse YAST Software manager. I just
reinstalled it manually (ie, rpm -i pgadmin4-4.26-2.1.x86_64.rpm) with same
result.
I checked the documentation page you mentioned and, yes, I have a file
/etc/pgAdmin/config_system.py.
It has one single line: SERVER_MODE = True

Do I have to switch it to false?

Marco

Il giorno lun 5 ott 2020 alle ore 11:13 Aditya Toshniwal <
aditya(dot)toshniwal(at)enterprisedb(dot)com> ha scritto:

> Hi Marco,
>
> How did you install pgAdmin ? Your application is running under server
> mode - https://www.pgadmin.org/docs/pgadmin4/4.26/config_py.html
>
> On Mon, Oct 5, 2020 at 2:20 PM Marco Azzalini <mark(dot)azzalini(at)gmail(dot)com>
> wrote:
>
>> Hi, the bug is that now pgAdmin4 start page is the following
>> [image: image.png]
>> and it asks for a login name and password, both related to an account of
>> which I have no idea and there seems to be no way to create one.
>>
>> I am going to remove it and reinstall through command line to see if it
>> ask me for create a new account.
>>
>> Marco
>>
>> Il giorno lun 5 ott 2020 alle ore 10:41 Aditya Toshniwal <
>> aditya(dot)toshniwal(at)enterprisedb(dot)com> ha scritto:
>>
>>> Hi Marco,
>>>
>>> Can you give more details on the bug and screenshot ?
>>> There is no major change between 4.22 to 4.26 related to this.
>>>
>>> On Mon, Oct 5, 2020 at 1:58 PM Marco Azzalini <mark(dot)azzalini(at)gmail(dot)com>
>>> wrote:
>>>
>>>> hi Aditya, thanks a lot. It worked! :-) But... :-(
>>>> I hit a bug related to the fact that pgAdmin4 now is asking for a
>>>> username and password, as described here:
>>>>
>>>> https://forums.opensuse.org/showthread.php/545053-How-to-get-pgadmin4-working-while-waiting-for-a-new-update
>>>> The proposed workaround seem a little bit tricky so I think I am going
>>>> to try to downgrade to 4.22 version...
>>>>
>>>> Do you know if is there a way to create the account that pgAdmin4 is
>>>> asking for?
>>>> thanks,
>>>> Marco
>>>>
>>>> Il giorno lun 5 ott 2020 alle ore 09:40 Aditya Toshniwal <
>>>> aditya(dot)toshniwal(at)enterprisedb(dot)com> ha scritto:
>>>>
>>>>> Hi Marco,
>>>>>
>>>>> The file has contents which are not shipped with pgAdmin installation.
>>>>> It is tampered somehow in your installation. I would suggest uninstall and
>>>>> install again.
>>>>>
>>>>> On Mon, Oct 5, 2020 at 12:57 PM Marco Azzalini <
>>>>> mark(dot)azzalini(at)gmail(dot)com> wrote:
>>>>>
>>>>>> Thanks Aditya, attached you can find the file __init__.py
>>>>>>
>>>>>> many thanks,
>>>>>> Marco
>>>>>>
>>>>>>
>>>>>> Il giorno lun 5 ott 2020 alle ore 07:02 Aditya Toshniwal <
>>>>>> aditya(dot)toshniwal(at)enterprisedb(dot)com> ha scritto:
>>>>>>
>>>>>>> Hi Marco,
>>>>>>>
>>>>>>> Can you share the contents of file - /usr/lib/python3.8/site-
>>>>>>> packages/pgadmin4-web/pgadmin/browser/server_groups/servers/
>>>>>>> databases/schemas/tables/row_security_policies/tests/__init__.py ?
>>>>>>> There is no such select statement in the original source code.
>>>>>>>
>>>>>>> On Fri, Oct 2, 2020 at 10:29 PM Marco Azzalini <
>>>>>>> mark(dot)azzalini(at)gmail(dot)com> wrote:
>>>>>>>
>>>>>>>> Hi, this is my first message here.
>>>>>>>> Today my pgAdmin4 console doesn't start anymore... it takes lots of
>>>>>>>> time and then a pop up appears complaining that pgAdmin server could not be
>>>>>>>> contacted
>>>>>>>>
>>>>>>>> at the end of the log there is this error:
>>>>>>>>
>>>>>>>> * File
>>>>>>>> "/usr/lib/python3.8/site-packages/pgadmin4-web/pgadmin/browser/server_groups/servers/databases/schemas/tables/row_security_policies/tests/__init__.py",
>>>>>>>> line 1*
>>>>>>>>
>>>>>>>> * SELECT rel.oid, rel.relname AS name,*
>>>>>>>>
>>>>>>>> * ^*
>>>>>>>>
>>>>>>>> *SyntaxError: invalid syntax*
>>>>>>>>
>>>>>>>> My system is Linux OpenSuse Tumbleweed and the pgAdmin version
>>>>>>>> is 4.26-2.1 (the latest available for my system)
>>>>>>>> Recently I got some updates for python subsystem... now I have
>>>>>>>> Python 3.8.5
>>>>>>>>
>>>>>>>> may be this be the source of the problem?
>>>>>>>> How can I fix it?
>>>>>>>>
>>>>>>>> thanks in advance for any hint
>>>>>>>> Marco
>>>>>>>>
>>>>>>>> Full log :
>>>>>>>> ----------------------------------------
>>>>>>>>
>>>>>>>> Traceback (most recent call last):
>>>>>>>>
>>>>>>>> File "/usr/lib/python3.8/site-packages/pgadmin4-web/pgAdmin4.py",
>>>>>>>> line 93, in <module> app = create_app()
>>>>>>>>
>>>>>>>> File
>>>>>>>> "/usr/lib/python3.8/site-packages/pgadmin4-web/pgadmin/__init__.py", line
>>>>>>>> 618, in create_app app.register_blueprint(module)
>>>>>>>>
>>>>>>>> File "/usr/lib/python3.8/site-packages/flask/app.py", line 98, in
>>>>>>>> wrapper_func return f(self, *args, **kwargs)
>>>>>>>>
>>>>>>>> File "/usr/lib/python3.8/site-packages/flask/app.py", line 1168, in
>>>>>>>> register_blueprint blueprint.register(self, options, first_registration)
>>>>>>>>
>>>>>>>> File
>>>>>>>> "/usr/lib/python3.8/site-packages/pgadmin4-web/pgadmin/utils/__init__.py",
>>>>>>>> line 71, in register app.register_blueprint(module)
>>>>>>>>
>>>>>>>> File "/usr/lib/python3.8/site-packages/flask/app.py", line 98, in
>>>>>>>> wrapper_func return f(self, *args, **kwargs)
>>>>>>>>
>>>>>>>> File "/usr/lib/python3.8/site-packages/flask/app.py", line 1168, in
>>>>>>>> register_blueprint blueprint.register(self, options, first_registration)
>>>>>>>>
>>>>>>>> File
>>>>>>>> "/usr/lib/python3.8/site-packages/pgadmin4-web/pgadmin/utils/__init__.py",
>>>>>>>> line 71, in register app.register_blueprint(module)
>>>>>>>>
>>>>>>>> File "/usr/lib/python3.8/site-packages/flask/app.py", line 98, in
>>>>>>>> wrapper_func return f(self, *args, **kwargs)
>>>>>>>>
>>>>>>>> File "/usr/lib/python3.8/site-packages/flask/app.py", line 1168, in
>>>>>>>> register_blueprint blueprint.register(self, options, first_registration)
>>>>>>>>
>>>>>>>> File
>>>>>>>> "/usr/lib/python3.8/site-packages/pgadmin4-web/pgadmin/browser/server_groups/servers/__init__.py",
>>>>>>>> line 309, in register super(ServerModule, self).register(app, options,
>>>>>>>> first_registration)
>>>>>>>>
>>>>>>>> File
>>>>>>>> "/usr/lib/python3.8/site-packages/pgadmin4-web/pgadmin/utils/__init__.py",
>>>>>>>> line 71, in register app.register_blueprint(module)
>>>>>>>>
>>>>>>>> File "/usr/lib/python3.8/site-packages/flask/app.py", line 98, in
>>>>>>>> wrapper_func return f(self, *args, **kwargs)
>>>>>>>>
>>>>>>>> File "/usr/lib/python3.8/site-packages/flask/app.py", line 1168, in
>>>>>>>> register_blueprint blueprint.register(self, options, first_registration)
>>>>>>>>
>>>>>>>> File
>>>>>>>> "/usr/lib/python3.8/site-packages/pgadmin4-web/pgadmin/utils/__init__.py",
>>>>>>>> line 71, in register app.register_blueprint(module)
>>>>>>>>
>>>>>>>> File "/usr/lib/python3.8/site-packages/flask/app.py", line 98, in
>>>>>>>> wrapper_func return f(self, *args, **kwargs)
>>>>>>>>
>>>>>>>> File "/usr/lib/python3.8/site-packages/flask/app.py", line 1168, in
>>>>>>>> register_blueprint blueprint.register(self, options, first_registration)
>>>>>>>>
>>>>>>>> File
>>>>>>>> "/usr/lib/python3.8/site-packages/pgadmin4-web/pgadmin/utils/__init__.py",
>>>>>>>> line 71, in register app.register_blueprint(module)
>>>>>>>>
>>>>>>>> File "/usr/lib/python3.8/site-packages/flask/app.py", line 98, in
>>>>>>>> wrapper_func return f(self, *args, **kwargs)
>>>>>>>>
>>>>>>>> File "/usr/lib/python3.8/site-packages/flask/app.py", line 1168, in
>>>>>>>> register_blueprint blueprint.register(self, options, first_registration)
>>>>>>>>
>>>>>>>> File
>>>>>>>> "/usr/lib/python3.8/site-packages/pgadmin4-web/pgadmin/utils/__init__.py",
>>>>>>>> line 71, in register app.register_blueprint(module)
>>>>>>>>
>>>>>>>> File "/usr/lib/python3.8/site-packages/flask/app.py", line 98, in
>>>>>>>> wrapper_func return f(self, *args, **kwargs)
>>>>>>>>
>>>>>>>> File "/usr/lib/python3.8/site-packages/flask/app.py", line 1168, in
>>>>>>>> register_blueprint blueprint.register(self, options, first_registration)
>>>>>>>>
>>>>>>>> File
>>>>>>>> "/usr/lib/python3.8/site-packages/pgadmin4-web/pgadmin/utils/__init__.py",
>>>>>>>> line 64, in register self.submodules =
>>>>>>>> list(app.find_submodules(self.import_name))
>>>>>>>>
>>>>>>>> File
>>>>>>>> "/usr/lib/python3.8/site-packages/pgadmin4-web/pgadmin/__init__.py", line
>>>>>>>> 67, in find_submodules module = import_module(module_name)
>>>>>>>>
>>>>>>>> File "/usr/lib64/python3.8/importlib/__init__.py", line 127, in
>>>>>>>> import_module return _bootstrap._gcd_import(name[level:], package, level)
>>>>>>>>
>>>>>>>> File "<frozen importlib._bootstrap>", line 1014, in _gcd_import
>>>>>>>>
>>>>>>>> File "<frozen importlib._bootstrap>", line 991, in _find_and_load
>>>>>>>>
>>>>>>>> File "<frozen importlib._bootstrap>", line 975, in
>>>>>>>> _find_and_load_unlocked
>>>>>>>>
>>>>>>>> File "<frozen importlib._bootstrap>", line 671, in _load_unlocked
>>>>>>>>
>>>>>>>> File "<frozen importlib._bootstrap_external>", line 779, in
>>>>>>>> exec_module
>>>>>>>>
>>>>>>>> File "<frozen importlib._bootstrap_external>", line 916, in get_code
>>>>>>>>
>>>>>>>> File "<frozen importlib._bootstrap_external>", line 846, in
>>>>>>>> source_to_code
>>>>>>>>
>>>>>>>> File "<frozen importlib._bootstrap>", line 219, in
>>>>>>>> _call_with_frames_removed
>>>>>>>>
>>>>>>>> File
>>>>>>>> "/usr/lib/python3.8/site-packages/pgadmin4-web/pgadmin/browser/server_groups/servers/databases/schemas/tables/row_security_policies/tests/__init__.py",
>>>>>>>> line 1
>>>>>>>>
>>>>>>>> SELECT rel.oid, rel.relname AS name,
>>>>>>>>
>>>>>>>> ^
>>>>>>>>
>>>>>>>> SyntaxError: invalid syntax
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> Thanks,
>>>>>>> Aditya Toshniwal
>>>>>>> pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com*
>>>>>>> <http://edbpostgres.com>
>>>>>>> "Don't Complain about Heat, Plant a TREE"
>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>>
>>>>>> https://ilmilione.org
>>>>>> ----
>>>>>> Anche sogliono essere odiatissimi i buoni e i generosi perché ordinariamente sono sinceri, e chiamano le cose coi loro nomi.
>>>>>> Colpa non perdonata dal genere umano, il quale non odia mai tanto chi fa male, né il male stesso, quanto chi lo nomina.
>>>>>> - Leopardi -
>>>>>>
>>>>>>
>>>>>
>>>>> --
>>>>> Thanks,
>>>>> Aditya Toshniwal
>>>>> pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com*
>>>>> <http://edbpostgres.com>
>>>>> "Don't Complain about Heat, Plant a TREE"
>>>>>
>>>>
>>>>
>>>> --
>>>>
>>>> https://ilmilione.org
>>>> ----
>>>> Anche sogliono essere odiatissimi i buoni e i generosi perché ordinariamente sono sinceri, e chiamano le cose coi loro nomi.
>>>> Colpa non perdonata dal genere umano, il quale non odia mai tanto chi fa male, né il male stesso, quanto chi lo nomina.
>>>> - Leopardi -
>>>>
>>>>
>>>
>>> --
>>> Thanks,
>>> Aditya Toshniwal
>>> pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com*
>>> <http://edbpostgres.com>
>>> "Don't Complain about Heat, Plant a TREE"
>>>
>>
>>
>> --
>>
>> https://ilmilione.org
>> ----
>> Anche sogliono essere odiatissimi i buoni e i generosi perché ordinariamente sono sinceri, e chiamano le cose coi loro nomi.
>> Colpa non perdonata dal genere umano, il quale non odia mai tanto chi fa male, né il male stesso, quanto chi lo nomina.
>> - Leopardi -
>>
>>
>
> --
> Thanks,
> Aditya Toshniwal
> pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com*
> <http://edbpostgres.com>
> "Don't Complain about Heat, Plant a TREE"
>

--

https://ilmilione.org
----
Anche sogliono essere odiatissimi i buoni e i generosi perché
ordinariamente sono sinceri, e chiamano le cose coi loro nomi.
Colpa non perdonata dal genere umano, il quale non odia mai tanto chi
fa male, né il male stesso, quanto chi lo nomina.
- Leopardi -