Re: [Gnumed-bugs] <bug>: <user did not comment on bug report>

[Karsten Hilbert]

Hello Chalal,

thanks for your report.

> user comment  : <user did not comment on bug report>
> 
> client version: 1.5.10
> 
> sender email  : <Please supply your email address here !>

...

> 2016-11-24 18:06:32  DEBUG     gm.ui 
> (/usr/share/gnumed/Gnumed/wxpython/gmAuthWidgets.py::connect_to_database() 
> #128): login attempt 1 of 3
> 2016-11-24 18:06:55  INFO      gm.ui 
> (/usr/share/gnumed/Gnumed/wxpython/gmAuthWidgets.py::__on_login_button_pressed()
>  #805): debug mode disabled
> 2016-11-24 18:06:56  ERROR     gm.ui 
> (/usr/share/gnumed/Gnumed/wxpython/gmAuthWidgets.py::connect_to_database() 
> #152): login attempt failed: PostgreSQL: fe_sendauth: no password supplied
> DSN: dbname=gnumed_v20 host=publicdb.gnumed.de port=5432 user=any-doc 
> sslmode=prefer
> 2016-11-24 18:07:12  INFO      gm.ui 
> (/usr/share/gnumed/Gnumed/wxpython/gmAuthWidgets.py::__on_login_button_pressed()
>  #816): slave mode disabled
> 2016-11-24 18:07:12  INFO      gm.ui 
> (/usr/share/gnumed/Gnumed/wxpython/gmAuthWidgets.py::GetLoginInfo() #740): 
> backend profile "GNUmed database at publicdb.gnumed.de (PUBLIC)" selected
> 2016-11-24 18:07:12  INFO      gm.ui 
> (/usr/share/gnumed/Gnumed/wxpython/gmAuthWidgets.py::GetLoginInfo() #747):  
> details: <ghani> on address@hidden:5432 (UTF8, public)
> 2016-11-24 18:07:12  INFO      gm.ui 
> (/usr/share/gnumed/Gnumed/wxpython/gmAuthWidgets.py::GetLoginInfo() #749):  
> helpdesk: "GNUmed Development List <address@hidden>"
> 2016-11-24 18:07:12  DEBUG     gm.gui 
> (/usr/share/gnumed/Gnumed/wxpython/gmExceptionHandlingWidgets.py::handle_uncaught_exception_wx()
>  #195): unhandled exception caught:
> Traceback (most recent call last):
>   File "/usr/lib/python2.7/runpy.py", line 174, in _run_module_as_main
>     "__main__", fname, loader, pkg_name)
>   File "/usr/lib/python2.7/runpy.py", line 72, in _run_code
>     exec code in run_globals
>   File "/usr/share/gnumed/Gnumed/gnumed.py", line 691, in <module>
>     gmGuiMain.main()
>   File "/usr/share/gnumed/Gnumed/wxpython/gmGuiMain.py", line 3766, in main
>     app = gmApp(redirect = False, clearSigInt = False)
>   File "/usr/lib/python2.7/dist-packages/wx-3.0-gtk2/wx/_core.py", line 8628, 
> in __init__
>     self._BootstrapApp()
>   File "/usr/lib/python2.7/dist-packages/wx-3.0-gtk2/wx/_core.py", line 8196, 
> in _BootstrapApp
>     return _core_.PyApp__BootstrapApp(*args, **kwargs)
>   File "/usr/share/gnumed/Gnumed/wxpython/gmGuiMain.py", line 3230, in OnInit
>     if not self.__establish_backend_connection():
>   File "/usr/share/gnumed/Gnumed/wxpython/gmGuiMain.py", line 3393, in 
> __establish_backend_connection
>     require_version = not override
>   File "/usr/share/gnumed/Gnumed/wxpython/gmAuthWidgets.py", line 147, in 
> connect_to_database
>     conn = gmPG2.get_raw_connection(dsn = dsn, verbose = True, readonly = 
> True)
>   File "/usr/share/gnumed/Gnumed/pycommon/gmPG2.py", line 1605, in 
> get_raw_connection
>     conn = dbapi.connect(dsn=dsn, 
> connection_factory=psycopg2.extras.DictConnection)
>   File "/usr/lib/python2.7/dist-packages/psycopg2/__init__.py", line 164, in 
> connect
>     conn = _connect(dsn, connection_factory=connection_factory, async=async)
> UnicodeEncodeError: 'ascii' codec can't encode characters in position 73-74: 
> ordinal not in range(128)
> 2016-11-24 18:07:12  DEBUG     gm.cfg 
> (/usr/share/gnumed/Gnumed/pycommon/gmCfg2.py::get() #391): option 
> [internal::debug] found in source [internal]
> 2016-11-24 18:07:12  DEBUG     gm.logging 
> (/usr/share/gnumed/Gnumed/pycommon/gmLog2.py::log_stack_trace() #160): 
> exception: 'ascii' codec can't encode characters in position 73-74: ordinal 
> not in range(128)
> 2016-11-24 18:07:12  DEBUG     gm.logging 
> (/usr/share/gnumed/Gnumed/pycommon/gmLog2.py::log_stack_trace() #161): type: 
> <type 'exceptions.UnicodeEncodeError'>
> 2016-11-24 18:07:12  DEBUG     gm.logging 
> (/usr/share/gnumed/Gnumed/pycommon/gmLog2.py::log_stack_trace() #162): list 
> of attributes:
> 2016-11-24 18:07:12  DEBUG     gm.logging 
> (/usr/share/gnumed/Gnumed/pycommon/gmLog2.py::log_stack_trace() #164):   
> args: ('ascii', u'dbname=gnumed_v20 host=publicdb.gnumed.de port=5432 
> user=ghani password=&\xc8\xc9&"\xc9 sslmode=prefer', 73, 75, 'ordinal not in 
> range(128)')
> 2016-11-24 18:07:12  DEBUG     gm.logging 
> (/usr/share/gnumed/Gnumed/pycommon/gmLog2.py::log_stack_trace() #164):   
> encoding: ascii
> 2016-11-24 18:07:12  DEBUG     gm.logging 
> (/usr/share/gnumed/Gnumed/pycommon/gmLog2.py::log_stack_trace() #164):   end: 
> 75
> 2016-11-24 18:07:12  DEBUG     gm.logging 
> (/usr/share/gnumed/Gnumed/pycommon/gmLog2.py::log_stack_trace() #164):   
> message: 
> 2016-11-24 18:07:12  DEBUG     gm.logging 
> (/usr/share/gnumed/Gnumed/pycommon/gmLog2.py::log_stack_trace() #164):   
> object: dbname=gnumed_v20 host=publicdb.gnumed.de port=5432 user=ghani 
> password=&????&"?? sslmode=prefer
> 2016-11-24 18:07:12  DEBUG     gm.logging 
> (/usr/share/gnumed/Gnumed/pycommon/gmLog2.py::log_stack_trace() #164):   
> reason: ordinal not in range(128)
> 2016-11-24 18:07:12  DEBUG     gm.logging 
> (/usr/share/gnumed/Gnumed/pycommon/gmLog2.py::log_stack_trace() #164):   
> start: 73

You attempted to log into the public database with username
"ghani". However, that database does not contain such entry:

        Ausgabeformat ist »wrapped«.
          db_user   | short_alias 
        ------------+-------------
         any-doc    | LMcC
         test-nurse | CC
         test-doc   | JB
         any-staff  | MoPny
        (4 Zeilen)

For testing against the public database you'll have to use
the user any-doc at first.

OTOH, your bug report showed another instance of the
Python/PostgreSQL/psycopg2 problem that PostgreSQL seems to
return error messages in an underspecified encoding when
problems happen _very_ early, especially when non-ASCII
characters are involved (as in your password).

GNUmed now tries to somewhat mitigate that problem by
attempting to initially force the connection attempt to utf8
encoding in the hope that early connection code in libpq
honors that setting...

Karsten
-- 
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346