Forgot to mention, please remove the file - /etc/pgAdmin/config_system.py also.
On Mon, Oct 5, 2020 at 3:33 PM Aditya Toshniwal < aditya.toshni...@enterprisedb.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. > > On Mon, Oct 5, 2020 at 3:14 PM Marco Azzalini <mark.azzal...@gmail.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.toshni...@enterprisedb.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.azzal...@gmail.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.toshni...@enterprisedb.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.azzal...@gmail.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.toshni...@enterprisedb.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.azzal...@gmail.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.toshni...@enterprisedb.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.azzal...@gmail.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" > -- Thanks, Aditya Toshniwal pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com* <http://edbpostgres.com> "Don't Complain about Heat, Plant a TREE"
