Re: [Gnumed-bugs] <bug>: Program didnt open

[Karsten Hilbert]

Hi Baruch,

thanks for your report.

> user comment  : Program didnt open
>
> client version: 1.7.6
>
> system account: baruch
> staff member  : baruch
> sender email  : Please supply your email address here !

Unfortunately, you did not provide an e-mail address here so
we can only help via the mailing list, so here goes:

The problem you are seeing:

> 2019-10-23 13:47:13  DEBUG     gm.gui        [140529749563200 MainThread]  
> (/usr/share/gnumed/Gnumed/wxpython/gmExceptionHandlingWidgets.py::handle_uncaught_exception_wx()
>  #252): 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 786, in <module>
>     exit_code = run_gui()
>   File "/usr/share/gnumed/Gnumed/gnumed.py", line 660, in run_gui
>     gmGuiMain.main()
>   File "/usr/share/gnumed/Gnumed/wxpython/gmGuiMain.py", line 4110, in main
>     app = gmApp(redirect = False, clearSigInt = False)
>   File "/usr/lib/python2.7/dist-packages/wx-3.0-gtk3/wx/_core.py", line 8628, 
> in __init__
>     self._BootstrapApp()
>   File "/usr/lib/python2.7/dist-packages/wx-3.0-gtk3/wx/_core.py", line 8196, 
> in _BootstrapApp
>     return _core_.PyApp__BootstrapApp(*args, **kwargs)
>   File "/usr/share/gnumed/Gnumed/wxpython/gmGuiMain.py", line 3565, in OnInit
>     if not self.__establish_backend_connection():
>   File "/usr/share/gnumed/Gnumed/wxpython/gmGuiMain.py", line 3737, in 
> __establish_backend_connection
>     require_version = not override
>   File "/usr/share/gnumed/Gnumed/wxpython/gmAuthWidgets.py", line 150, in 
> connect_to_database
>     conn = gmPG2.get_raw_connection(dsn = dsn, verbose = True, readonly = 
> True)
>   File "/usr/share/gnumed/Gnumed/pycommon/gmPG2.py", line 2124, 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 129, in 
> connect
>     dsn = _ext.make_dsn(dsn, **kwargs)
>   File "/usr/lib/python2.7/dist-packages/psycopg2/extensions.py", line 155, 
> in make_dsn
>     parse_dsn(dsn)
> ProgrammingError: invalid dsn: missing "=" after "Arias" in connection info 
> string

happens because GNUmed does not handle whitespace in the
PostgreSQL account name. You are, however, trying to connect
as "Jorge Arias"

        dsn = dbname=gnumed_v22 port=5432 user=Jorge Arias 
password=12b41c878b4a3a5c sslmode=prefer fallback_application_name=GNUmed 
client_encoding=utf8 application_name=GNUmed-[MainThread]

which does contain a Space character.

Now, the doctor/nurse name *inside* GNUmed can contain pretty
much any character but you'll have to use a database account
without whitespace in it.

Use the account name "any-doc" with "any-doc" as password for
a first connect, then create a new user for yourself and
disable the any-doc account inside the GNUmed client.

Best,
Karsten
--
GPG  40BE 5B0E C98E 1713 AFA6  5BC0 3BEA AC80 7D4F C89B