Local store access

Questions about WAPT Server / Requests and help related to the WAPT server
Forum Rules
Community Forum Rules
* English support on www.reddit.com/r/wapt
* French community support is available on this forum
* Please prefix the topic title with [RESOLVED] if it is resolved.
* Please do not edit a topic that is tagged [RESOLVED]. Open a new topic referencing the old one.
* Specify the installed WAPT version, full version, and build number (2.2.1.11957 / 2.2.2.12337 / etc.) as well as the Enterprise/Discovery edition.
* Versions 1.8.2 and earlier are no longer supported. The only questions accepted regarding version 1.8.2 are related to upgrading to a supported version (2.1, 2.2, etc.).
* Specify the server OS (Linux/Windows) and version (Debian Buster/Bullseye - CentOS 7 - Windows Server 2012/2016/2019).
* Specify the OS of the administration/package creation machine and the machine with the problematic agent, if applicable (Windows 7/10/11/Debian 11/etc.).
* Avoid asking multiple questions when opening a topic, otherwise it may be ignored. If there are multiple topics, open separate topics, preferably one after the other and not all at the same time (i.e., do not spam the forum).
* Include code snippets, screenshots, and other images directly in the post. Links to Pastebin, Bitly, and other third-party sites will be systematically removed.
* As with any community forum, support is provided voluntarily by members. If you require commercial support, you can contact Tranquil IT's sales department at 02.40.97.57.55
Locked
gly
Messages: 24
Registration: May 30, 2019 - 11:45

February 22, 2022 - 5:08 PM

Good morning,

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

Code: Select all

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
High
User avatar
dcardon
WAPT Expert
Messages: 1930
Registration: June 18, 2014 - 09:58
Location: Saint Sébastien sur Loire
Contact :
Contact dcardon

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
Denis Cardon - Tranquil IT
Share your experiences on WAPT! Send us your blog and article URLs in the "Your Opinion of the forum, and we'll feature them on the WAPT
High
gly
Messages: 24
Registration: May 30, 2019 - 11:45

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.
High
User avatar
dcardon
WAPT Expert
Messages: 1930
Registration: June 18, 2014 - 09:58
Location: Saint Sébastien sur Loire
Contact :
Contact dcardon

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
Denis Cardon - Tranquil IT
Share your experiences on WAPT! Send us your blog and article URLs in the "Your Opinion of the forum, and we'll feature them on the WAPT
High
Locked

Return to "WAPT Server"


  • To go further with WAPT