Re: Syntax error on pgAdmin4 start

On Mon, Oct 5, 2020 at 11:04 AM Aditya Toshniwal <
aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:

> Hi Marco,
>
> Please follow the steps here -
> https://www.pgadmin.org/download/pgadmin-4-rpm/ and install the desktop
> mode of pgAdmin. You must have installed the web mode, which is generally
> used for server deployment and has users who can log in.
>

Those steps are for our repos, which do not include Suse support.

It seems like the Suse RPMs are basically broken. They shouldn't blindly
set a username/password.

>
> On Mon, Oct 5, 2020 at 3:14 PM Marco Azzalini <mark(dot)azzalini(at)gmail(dot)com>
> wrote:
>
>> 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 -
>>
>>
>
> --
> Thanks,
> Aditya Toshniwal
> pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com*
> <http://edbpostgres.com>
> "Don't Complain about Heat, Plant a TREE"
>

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EDB: http://www.enterprisedb.com