Tranquil IT Forum

Published: **February 22, 2022 - 5:08 PM**

Good morning,

Here are the error logs when I try to access https://urlduserverwapt/store (error 500):

Feb 22 16:46:15 wapt waptserver[1097]: 2022-02-22 16:46:15,953 [waptserver.app ] ERROR Exception on /store/ [GET]
Feb 22 16:46:15 wapt waptserver[1097]: Traceback (most recent call last):
Feb 22 16:46:15 wapt waptserver[1097]:   File "/opt/wapt/lib/python3.8/site-packages/peewee.py", line 3144, in execute_sql
Feb 22 16:46:15 wapt waptserver[1097]:     cursor.execute(sql, params or ())
Feb 22 16:46:15 wapt waptserver[1097]: psycopg2.errors.UndefinedTable: ERREUR:  la relation « storedownload » n'existe pas
Feb 22 16:46:15 wapt waptserver[1097]: LINE 2:             LEFT JOIN StoreDownload
Feb 22 16:46:15 wapt waptserver[1097]:                               ^
Feb 22 16:46:15 wapt waptserver[1097]: During handling of the above exception, another exception occurred:
Feb 22 16:46:15 wapt waptserver[1097]: Traceback (most recent call last):
Feb 22 16:46:15 wapt waptserver[1097]:   File "/opt/wapt/lib/python3.8/site-packages/flask/app.py", line 2070, in wsgi_app
Feb 22 16:46:15 wapt waptserver[1097]:     response = self.full_dispatch_request()
Feb 22 16:46:15 wapt waptserver[1097]:   File "/opt/wapt/lib/python3.8/site-packages/flask/app.py", line 1515, in full_dispatch_request
Feb 22 16:46:15 wapt waptserver[1097]:     rv = self.handle_user_exception(e)
Feb 22 16:46:15 wapt waptserver[1097]:   File "/opt/wapt/lib/python3.8/site-packages/flask/app.py", line 1513, in full_dispatch_request
Feb 22 16:46:15 wapt waptserver[1097]:     rv = self.dispatch_request()
Feb 22 16:46:15 wapt waptserver[1097]:   File "/opt/wapt/lib/python3.8/site-packages/flask/app.py", line 1499, in dispatch_request
Feb 22 16:46:15 wapt waptserver[1097]:     return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args)
Feb 22 16:46:15 wapt waptserver[1097]:   File "/opt/wapt/waptserver/decorators.py", line 256, in decorated
Feb 22 16:46:15 wapt waptserver[1097]:     r = f(*args, **kwargs)
Feb 22 16:46:15 wapt waptserver[1097]:   File "/opt/wapt/waptserver/decorators.py", line 317, in decorated
Feb 22 16:46:15 wapt waptserver[1097]:     result = f(*args, **kwargs)
Feb 22 16:46:15 wapt waptserver[1097]:   File "/opt/wapt/waptserver/store.py", line 325, in packages
Feb 22 16:46:15 wapt waptserver[1097]:     packages = wapt_db.execute_sql(SQL)
Feb 22 16:46:15 wapt waptserver[1097]:   File "/opt/wapt/lib/python3.8/site-packages/peewee.py", line 3151, in execute_sql
Feb 22 16:46:15 wapt waptserver[1097]:     self.commit()
Feb 22 16:46:15 wapt waptserver[1097]:   File "/opt/wapt/lib/python3.8/site-packages/peewee.py", line 2917, in __exit__
Feb 22 16:46:15 wapt waptserver[1097]:     reraise(new_type, new_type(exc_value, *exc_args), traceback)
Feb 22 16:46:15 wapt waptserver[1097]:   File "/opt/wapt/lib/python3.8/site-packages/peewee.py", line 190, in reraise
Feb 22 16:46:15 wapt waptserver[1097]:     raise value.with_traceback(tb)
Feb 22 16:46:15 wapt waptserver[1097]:   File "/opt/wapt/lib/python3.8/site-packages/peewee.py", line 3144, in execute_sql
Feb 22 16:46:15 wapt waptserver[1097]:     cursor.execute(sql, params or ())
Feb 22 16:46:15 wapt waptserver[1097]: peewee.ProgrammingError: ERREUR:  la relation « storedownload » n'existe pas
Feb 22 16:46:15 wapt waptserver[1097]: LINE 2:             LEFT JOIN StoreDownload

Any idea what the problem might be? For your information, I have enabled the `enable_store=true` parameter

Thank you very much

Published: **March 3, 2022 - 4:40 PM**

Hi Gly,

this is a section that isn't really highlighted and that we were planning to remove. Do you use it internally? What do you use it for?
I think the bug in question was fixed in version 2.2, but I don't know if it will still be present in version 2.3, or at least if it will no longer be directly integrated into the waptserver package (i.e., it might be moved to a third-party script).

Regards,

Denis

Published: **March 7, 2022 - 10:29**

Actually, I'd like a way to share my package list with colleagues from other institutions (who have their own WAPT server).
Simply put, rather than everyone developing their own packages in isolation, especially for common business applications, it would be much better to be able to easily view and download them.
Something like this seemed ideal: https://wapt.lesfourmisduweb.org/tous-les-packages

Thanks in advance for any potential solution.

Published: **March 25, 2022 - 4:33 PM**

Hi Gly,

I'll check with Simon to see if it would be possible to dump the PHP code from the wapt repository of the ants onto GitHub.

Regards,

Denis

Tranquil IT Forum

Local store access

Local store access

Re: Access to local depot store

Re: Access to local depot store

Re: Access to local depot store