Re: Syntax error on pgAdmin4 start

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 -