[Health-dev] [bug #62608] health webdav not running

[Feng Shu]

Follow-up Comment #11, bug #62608 (project health):

```
Exception occurred during processing of request from ('::ffff:127.0.0.1',
38532, 0, 0)
Traceback (most recent call last):
  File "/usr/lib/python3.9/socketserver.py", line 650, in
process_request_thread
    self.finish_request(request, client_address)
  File "/usr/lib/python3.9/socketserver.py", line 360, in finish_request
    self.RequestHandlerClass(request, client_address, self)
  File "/usr/lib/python3.9/socketserver.py", line 720, in __init__
    self.handle()
  File "/usr/lib/python3.9/http/server.py", line 427, in handle
    self.handle_one_request()
  File "/usr/lib/python3.9/http/server.py", line 405, in handle_one_request
    if not self.parse_request():
  File
"/home/feng/gnuhealth/tryton/server/trytond-6.0.20/trytond/modules/health_webdav3_server/protocol.py",
line 578, in parse_request
    if not self.get_userinfo(user, password, self.command):
  File
"/home/feng/gnuhealth/tryton/server/trytond-6.0.20/trytond/modules/health_webdav3_server/protocol.py",
line 590, in get_userinfo
    with Transaction().start(dbname, 0, close=True) as transaction:
  File
"/home/feng/gnuhealth/tryton/server/trytond-6.0.20/trytond/transaction.py",
line 107, in start
    database = backend.Database(database_name).connect()
  File
"/home/feng/gnuhealth/tryton/server/trytond-6.0.20/trytond/backend/postgresql/database.py",
line 230, in __new__
    inst._connpool = ThreadedConnectionPool(
  File "/home/feng/.local/lib/python3.9/site-packages/psycopg2/pool.py", line
161, in __init__
    AbstractConnectionPool.__init__(
  File "/home/feng/.local/lib/python3.9/site-packages/psycopg2/pool.py", line
59, in __init__
    self._connect()
  File "/home/feng/.local/lib/python3.9/site-packages/psycopg2/pool.py", line
63, in _connect
    conn = psycopg2.connect(*self._args, **self._kwargs)
  File "/home/feng/.local/lib/python3.9/site-packages/psycopg2/__init__.py",
line 122, in connect
    conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError: connection to server at "localhost" (::1), port
5432 failed: 致命错误:  数据库 "favicon.ico" 不存在
```

what favicon.ico use for?


[comment #9 comment #9:]
> Great :)
> Should be a different issue, I remember this was a problem in 3.8 as well.
This issue here was coming from 4.0 upgrade.
> Let's open another one for that?

agree.

> And commit the changes by end of the week if nobody proposes an alternative
way to handle the cache?
> 
> [comment #8 comment #8:]
> > I have test this diff, webdav seem to work.
> > 
> > I have tested caldav with thunderbird and evolution too,  I think both of
them can not work well.
> > the events created in thunderbird and evolution can be found in
gnuhealth-client, but events created in gnuhealth-client
> > can not be showed in thunderbird or evolution.
> > 
> > Is this the same issue or the different issues? I do not know.
> > 
> > 
> > 
> > [comment #7 comment #7:]
> > > For me using the attached protocol.py it's working (see .diff for
changes)
> > > 
> > > [comment #3 comment #3:]
> > > > 
> > > > [comment #1 comment #1:]
> > > > > Dear Gerald
> > > > > 
> > > > > Thank you for reporting!
> > > > > 
> > > > > I can't reproduce it.. are you actually executing the webdav server
from the "bin" dir (gnuhealth-webdav-server)? Notice the "os" package is
there.
> > > > 
> > > > I think os package is not in health_webdav3_server/bin dir.
> > > > 
> > > > 
> > > > > 
> > > > > It seems to run OK on my box...
> > > > > 
> > > > >
lfm@beastie:~/gnuhealth/tryton/server/modules/health_webdav3_server/bin $
./gnuhealth-webdav-server -vv
> > > > > 2285198 140280141563712 [2022-06-14 12:35:16,322] INFO
trytond.modules.health_webdav3_server.server using
/home/lfm/gnuhealth/tryton/server/config/trytond.conf as configuration file
> > > > > 2285198 140280141563712 [2022-06-14 12:35:16,322] INFO
trytond.modules.health_webdav3_server.server initialising distributed objects
services
> > > > > 2285198 140280141563712 [2022-06-14 12:35:16,357] INFO
trytond.modules.health_webdav3_server.server starting WebDAV protocol on
*:8080
> > > > > 
> > > > 
> > > > I have tested in my machine, when run ./gnuhealth-webdav-server -vv,
no error, but if your browser http://localhost:8080/ in firefox,
> > > > the below error will be exist
> > > > 
> > > > ```
> > > > ----------------------------------------
> > > > Exception occurred during processing of request from
('::ffff:127.0.0.1', 58212, 0, 0)
> > > > Traceback (most recent call last):
> > > >   File "/usr/lib/python3.9/socketserver.py", line 650, in
process_request_thread
> > > >     self.finish_request(request, client_address)
> > > >   File "/usr/lib/python3.9/socketserver.py", line 360, in
finish_request
> > > >     self.RequestHandlerClass(request, client_address, self)
> > > >   File "/usr/lib/python3.9/socketserver.py", line 720, in __init__
> > > >     self.handle()
> > > >   File "/usr/lib/python3.9/http/server.py", line 427, in handle
> > > >     self.handle_one_request()
> > > >   File "/usr/lib/python3.9/http/server.py", line 415, in
handle_one_request
> > > >     method()
> > > >   File
"/home/feng/.local/lib/python3.9/site-packages/pywebdav/lib/WebDAVServer.py",
line 296, in do_GET
> > > >     status_code = self._HEAD_GET(with_body=True)
> > > >   File
"/home/feng/.local/lib/python3.9/site-packages/pywebdav/lib/WebDAVServer.py",
line 262, in _HEAD_GET
> > > >     data = dc.get_data(uri, range)
> > > >   File
"/home/feng/gnuhealth/tryton/server/trytond-6.0.20/trytond/modules/health_webdav3_server/protocol.py",
line 254, in get_data
> > > >     'GNU Health</a> version %s</em>' %
os.environ['GNUHEALTH_VERSION'])
> > > > NameError: name 'os' is not defined
> > > > ----------------------------------------
> > > > 
> > > > 
> > > > ```
> > > > 
> > > > 
> > > > I add 'import os' to protocol.py, 'NameError: name 'os' is not
defined' is dispear. 
> > > > 
> > > > 
> > > > when I vistit http://localhost:8080/gnuhealth1in firefox, the
following error exist:
> > > > 
> > > > ```
> > > > ----------------------------------------
> > > > Exception occurred during processing of request from
('::ffff:127.0.0.1', 57936, 0, 0)
> > > > Traceback (most recent call last):
> > > >   File "/usr/lib/python3.9/socketserver.py", line 720, in __init__
> > > >     self.handle()
> > > >   File "/usr/lib/python3.9/http/server.py", line 427, in handle
> > > >     self.handle_one_request()
> > > >   File "/usr/lib/python3.9/http/server.py", line 405, in
handle_one_request
> > > >     if not self.parse_request():
> > > >   File
"/home/feng/gnuhealth/tryton/server/trytond-6.0.20/trytond/modules/health_webdav3_server/protocol.py",
line 577, in parse_request
> > > >     if not self.get_userinfo(user, password, self.command):
> > > >   File
"/home/feng/gnuhealth/tryton/server/trytond-6.0.20/trytond/modules/health_webdav3_server/protocol.py",
line 622, in get_userinfo
> > > >     Cache.clean(dbname)
> > > > AttributeError: type object 'MemoryCache' has no attribute 'clean'
> > > > 
> > > > During handling of the above exception, another exception occurred:
> > > > 
> > > > Traceback (most recent call last):
> > > >   File "/usr/lib/python3.9/socketserver.py", line 650, in
process_request_thread
> > > >     self.finish_request(request, client_address)
> > > >   File "/usr/lib/python3.9/socketserver.py", line 360, in
finish_request
> > > >     self.RequestHandlerClass(request, client_address, self)
> > > >   File "/usr/lib/python3.9/socketserver.py", line 722, in __init__
> > > >     self.finish()
> > > >   File
"/home/feng/gnuhealth/tryton/server/trytond-6.0.20/trytond/modules/health_webdav3_server/protocol.py",
line 561, in finish
> > > >     Cache.resets(dbname)
> > > > AttributeError: type object 'MemoryCache' has no attribute 'resets'
> > > > ----------------------------------------
> > > > 
> > > > ```
> > > > 
> > > > 
> > > > 
> > > > 
> > > > 


    _______________________________________________________

Reply to this item at:

  <https://savannah.gnu.org/bugs/?62608>

_______________________________________________
Message sent via Savannah
https://savannah.gnu.org/