Re: Syntax error on pgAdmin4 start

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"