Re: ValueError: unsupported format character 'D'

Hi

On Fri, Nov 20, 2020 at 4:16 PM Sekretarka Rafala <
sekretarka(dot)rafala(at)gmail(dot)com> wrote:

> Hello
>
> I went through the installation description of pgAdmin on
> https://computingforgeeks.com/how-to-install-pgadmin-4-on-centos-linux/
>
> Installation was done on Centos8.
>
> After connecting to pgAdmin web site I got "server error" in browser and
> following messages in the error_log of Apache
>
> Are you able to advise what can be done?
>

I would strongly recommend using the packages the pgAdmin team produce, as
they are quite different from the ones installed if you follow that web
page. See https://www.pgadmin.org/download/pgadmin-4-rpm/

>
> [Fri Nov 20 16:26:44.074222 2020] [wsgi:error] [pid 38774:tid
> 139824286275328] [remote ::1:55110] mod_wsgi (pid=38774): Exception
> occurred processing WSGI script
> *'/usr/lib/python3.6/site-packages/pgadmin4-web/pgAdmin4.wsgi'.*
> [Fri Nov 20 16:26:44.077629 2020] [wsgi:error] [pid 38774:tid
> 139824286275328] [remote ::1:55110] Traceback (most recent call last):
> [Fri Nov 20 16:26:44.077673 2020] [wsgi:error] [pid 38774:tid
> 139824286275328] [remote ::1:55110] File
> "/usr/lib/python3.6/site-packages/pgadmin4-web/flask/app.py", line 2309, in
> __call__
> [Fri Nov 20 16:26:44.077677 2020] [wsgi:error] [pid 38774:tid
> 139824286275328] [remote ::1:55110] return self.wsgi_app(environ,
> start_response)
> [Fri Nov 20 16:26:44.077682 2020] [wsgi:error] [pid 38774:tid
> 139824286275328] [remote ::1:55110] File
> "/usr/lib/python3.6/site-packages/pgadmin4-web/pgAdmin4.py", line 72, in
> __call__
> [Fri Nov 20 16:26:44.077684 2020] [wsgi:error] [pid 38774:tid
> 139824286275328] [remote ::1:55110] return self.app(environ,
> start_response)
> [Fri Nov 20 16:26:44.077687 2020] [wsgi:error] [pid 38774:tid
> 139824286275328] [remote ::1:55110] File
> "/usr/lib/python3.6/site-packages/pgadmin4-web/werkzeug/middleware/proxy_fix.py",
> line 228, in __call__
> [Fri Nov 20 16:26:44.077690 2020] [wsgi:error] [pid 38774:tid
> 139824286275328] [remote ::1:55110] return self.app(environ,
> start_response)
> [Fri Nov 20 16:26:44.077693 2020] [wsgi:error] [pid 38774:tid
> 139824286275328] [remote ::1:55110] File
> "/usr/lib/python3.6/site-packages/pgadmin4-web/flask/app.py", line 2295, in
> wsgi_app
> [Fri Nov 20 16:26:44.077695 2020] [wsgi:error] [pid 38774:tid
> 139824286275328] [remote ::1:55110] response = self.handle_exception(e)
> [Fri Nov 20 16:26:44.077698 2020] [wsgi:error] [pid 38774:tid
> 139824286275328] [remote ::1:55110] File
> "/usr/lib/python3.6/site-packages/pgadmin4-web/flask/app.py", line 1741, in
> handle_exception
> [Fri Nov 20 16:26:44.077700 2020] [wsgi:error] [pid 38774:tid
> 139824286275328] [remote ::1:55110] reraise(exc_type, exc_value, tb)
> [Fri Nov 20 16:26:44.077703 2020] [wsgi:error] [pid 38774:tid
> 139824286275328] [remote ::1:55110] File
> "/usr/lib/python3.6/site-packages/pgadmin4-web/flask/_compat.py", line 35,
> in reraise
> [Fri Nov 20 16:26:44.077706 2020] [wsgi:error] [pid 38774:tid
> 139824286275328] [remote ::1:55110] raise value
> [Fri Nov 20 16:26:44.077709 2020] [wsgi:error] [pid 38774:tid
> 139824286275328] [remote ::1:55110] File
> "/usr/lib/python3.6/site-packages/pgadmin4-web/flask/app.py", line 2292, in
> wsgi_app
> [Fri Nov 20 16:26:44.077711 2020] [wsgi:error] [pid 38774:tid
> 139824286275328] [remote ::1:55110] response =
> self.full_dispatch_request()
> [Fri Nov 20 16:26:44.077714 2020] [wsgi:error] [pid 38774:tid
> 139824286275328] [remote ::1:55110] File
> "/usr/lib/python3.6/site-packages/pgadmin4-web/flask/app.py", line 1808, in
> full_dispatch_request
> [Fri Nov 20 16:26:44.077716 2020] [wsgi:error] [pid 38774:tid
> 139824286275328] [remote ::1:55110]
> self.try_trigger_before_first_request_functions()
> [Fri Nov 20 16:26:44.077719 2020] [wsgi:error] [pid 38774:tid
> 139824286275328] [remote ::1:55110] File
> "/usr/lib/python3.6/site-packages/pgadmin4-web/flask/app.py", line 1855, in
> try_trigger_before_first_request_functions
> [Fri Nov 20 16:26:44.077721 2020] [wsgi:error] [pid 38774:tid
> 139824286275328] [remote ::1:55110] func()
> [Fri Nov 20 16:26:44.077724 2020] [wsgi:error] [pid 38774:tid
> 139824286275328] [remote ::1:55110] File
> "/usr/lib/python3.6/site-packages/pgadmin4-web/pgadmin/utils/__init__.py",
> line 48, in create_module_preference
> [Fri Nov 20 16:26:44.077727 2020] [wsgi:error] [pid 38774:tid
> 139824286275328] [remote ::1:55110] self.register_preferences()
> [Fri Nov 20 16:26:44.077730 2020] [wsgi:error] [pid 38774:tid
> 139824286275328] [remote ::1:55110] File
> "/usr/lib/python3.6/site-packages/pgadmin4-web/pgadmin/browser/__init__.py",
> line 272, in register_preferences
> [Fri Nov 20 16:26:44.077732 2020] [wsgi:error] [pid 38774:tid
> 139824286275328] [remote ::1:55110] register_browser_preferences(self)
> [Fri Nov 20 16:26:44.077735 2020] [wsgi:error] [pid 38774:tid
> 139824286275328] [remote ::1:55110] File
> "/usr/lib/python3.6/site-packages/pgadmin4-web/pgadmin/browser/register_browser_preferences.py",
> line 461, in register_browser_preferences
> [Fri Nov 20 16:26:44.077741 2020] [wsgi:error] [pid 38774:tid
> 139824286275328] [remote ::1:55110] 'Supported placeholders are
> %DATABASE%, %USERNAME%, and %SERVER%. '
> [Fri Nov 20 16:26:44.077745 2020] [wsgi:error] [pid 38774:tid
> 139824286275328] [remote ::1:55110] File
> "/usr/lib/python3.6/site-packages/pgadmin4-web/flask_babelex/__init__.py",
> line 623, in gettext
> [Fri Nov 20 16:26:44.077747 2020] [wsgi:error] [pid 38774:tid
> 139824286275328] [remote ::1:55110] return get_domain().gettext(*args,
> **kwargs)
> [Fri Nov 20 16:26:44.077750 2020] [wsgi:error] [pid 38774:tid
> 139824286275328] [remote ::1:55110] File
> "/usr/lib/python3.6/site-packages/pgadmin4-web/flask_babelex/__init__.py",
> line 534, in gettext
> [Fri Nov 20 16:26:44.077753 2020] [wsgi:error] [pid 38774:tid
> 139824286275328] [remote ::1:55110] return t.ugettext(string) %
> variables
> [Fri Nov 20 16:26:44.077765 2020]* [wsgi:error] [pid 38774:tid
> 139824286275328] [remote ::1:55110] ValueError: unsupported format
> character 'D' (0x44) at index 28*
>
> Regards
> Rafal
>

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

EDB: http://www.enterprisedb.com