I’m a newbie trying to use the Ubuntu PPA on a VM in AWS. I’ve reviewed the installation notes provided in the PPA, as well as several others regarding the setting up of GVM admin users (specifically to get the scan config downloads working) but find myself unable to follow the instructions exactly because:
md main:MESSAGE:2021-02-26 11h49.03 utc:27398: Greenbone Vulnerability Manager version 20.08.1 (DB revision 233)
md manage:WARNING:2021-02-26 11h49.03 utc:27400: sql_exec_internal: PQexec failed: ERROR: must be owner of aggregate group_concat (7)
md manage:WARNING:2021-02-26 11h49.03 utc:27400: sql_exec_internal: SQL: DROP AGGREGATE IF EXISTS group_concat (text, text);
md manage:WARNING:2021-02-26 11h49.03 utc:27400: sqlv: sql_exec_internal failed
after installation.
Instead of following those instructions, if I allow the PPA packages to perform the createdb, then the gvmd database owner is set to the builtin postgres account, and I can avoid those errors above using commands like sudo -u postgres gvmd --create-user=ubuntu and so on. However, I am unable to get the scan configs to load even after using
to set the Feed Import Owner. In the Web GUI, I can see that all feeds are listed as current, so I guessing that the setting of the Feed Import Owner is not correct.
AFAIK, without the scan configs, I’m pretty much stuck. Any thoughts as to what could be wrong, or what to look at to diagnose further?
That’s a fair point, but I guess what I am hoping for is some insight as to who (user) or what (role) should be the owner of group_concat. I’d then be in a position either fix the configuration myself, or file a bug with the packager with the needed details.
OK, after discussion with the PPA packager about another matter, it seems that the resolution to that solves this problem too.
FWIW, the fix is in openvas 1:20.8.1-2.
In addition, for anybody else who finds this thread, to run a gvmd CLI command such as gvmd --get-users when using the PPA, it is necessary to do something like the following:
in order to load the postgres credentials. However, setting the feed import owner for the “admin” user will be done automatically by the gvmd post-installation script, so this may not be needed at all. With that, I have everything running - except that I have yet to get a scan config to load.