Failed to create user: Invalid characters in user name (CU-8ghxga)

iamklaus commented 4 years ago

Dear all,

I am running docker on my OpenmediaVault installation.

Any ideas why it does not finally work? Here the logs where I start to get into a loop:

Creating Greenbone Vulnerability Manager admin user Failed to create user: Invalid characters in user name

Here the detailed logs:

Starting Open Scanner Protocol daemon for OpenVAS... 2020-06-21 08:34:48.348 UTC [96] LOG: autovacuum: dropping orphan temp table "gvmd.pg_temp_5.current_credentials" 2020-06-21 08:34:48.351 UTC [96] LOG: autovacuum: dropping orphan temp table "gvmd.pg_temp_4.current_credentials" 2020-06-21 08:34:48.353 UTC [96] LOG: autovacuum: dropping orphan temp table "gvmd.pg_temp_6.current_credentials" Starting Greenbone Vulnerability Manager... Creating Greenbone Vulnerability Manager admin user Failed to create user: Invalid characters in user name 8:C 21 Jun 2020 08:35:32.359 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo 8:C 21 Jun 2020 08:35:32.359 # Redis version=5.0.7, bits=64, commit=00000000, modified=0, pid=8, just started 8:C 21 Jun 2020 08:35:32.359 # Configuration loaded Wait for redis socket to be created... Testing redis status... Redis ready. Starting PostgreSQL... pg_ctl: another server might be running; trying to start server anyway waiting for server to start....2020-06-21 08:35:33.407 UTC [20] LOG: starting PostgreSQL 12.3 (Ubuntu 12.3-1.pgdg20.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.3.0-10ubuntu2) 9.3.0, 64-bit 2020-06-21 08:35:33.407 UTC [20] LOG: listening on IPv4 address "127.0.0.1", port 5432 2020-06-21 08:35:33.407 UTC [20] LOG: could not bind IPv6 address "::1": Cannot assign requested address 2020-06-21 08:35:33.407 UTC [20] HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry. 2020-06-21 08:35:33.413 UTC [20] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 2020-06-21 08:35:33.431 UTC [21] LOG: database system was interrupted; last known up at 2020-06-21 08:33:48 UTC 2020-06-21 08:35:33.546 UTC [21] LOG: database system was not properly shut down; automatic recovery in progress 2020-06-21 08:35:33.551 UTC [21] LOG: redo starts at 0/1FF78E0 2020-06-21 08:35:33.620 UTC [21] LOG: invalid record length at 0/2623390: wanted 24, got 0 2020-06-21 08:35:33.620 UTC [21] LOG: redo done at 0/2623368 2020-06-21 08:35:33.667 UTC [20] LOG: database system is ready to accept connections done server started Updating NVTs... Updating CERT data... Updating SCAP data... Starting Open Scanner Protocol daemon for OpenVAS... 2020-06-21 08:36:33.741 UTC [102] LOG: autovacuum: dropping orphan temp table "gvmd.pg_temp_5.current_credentials" 2020-06-21 08:36:33.744 UTC [102] LOG: autovacuum: dropping orphan temp table "gvmd.pg_temp_4.current_credentials" 2020-06-21 08:36:33.745 UTC [102] LOG: autovacuum: dropping orphan temp table "gvmd.pg_temp_6.current_credentials" Starting Greenbone Vulnerability Manager... Creating Greenbone Vulnerability Manager admin user Failed to create user: Invalid characters in user name

pixelsquared commented 4 years ago

Do you have the username variable set to anything?

any2names commented 4 years ago

I got the same error

2020-06-22 15:28:09.612 UTC [43] LOG: stats_timestamp 2020-06-22 15:28:09.636039+00 is later than collector's time 2020-06-22 15:28:09.612155+00 for database 13425 Updating CERT data... Updating SCAP data... Starting Open Scanner Protocol daemon for OpenVAS... Starting Greenbone Vulnerability Manager... 2020-06-22 15:34:25.158 UTC [560] ERROR: relation "public.meta" does not exist at character 19 2020-06-22 15:34:25.158 UTC [560] STATEMENT: SELECT value FROM public.meta WHERE name = 'database_version'; Creating Greenbone Vulnerability Manager admin user Failed to create user: Invalid characters in user name

any2names commented 4 years ago

More detail

Starting Greenbone Vulnerability Manager... 2020-06-22 15:44:43.026 UTC [556] ERROR: relation "public.meta" does not exist at character 19 2020-06-22 15:44:43.026 UTC [556] STATEMENT: SELECT value FROM public.meta WHERE name = 'database_version'; 2020-06-22 15:44:47.534 UTC [609] ERROR: relation "cves" does not exist at character 385 2020-06-22 15:44:47.534 UTC [609] STATEMENT: CREATE OR REPLACE VIEW vulns AS SELECT id, uuid, name, creation_time, modification_time, cast (cvss_base AS double precision) AS severity, qod, 'nvt' AS type FROM nvts WHERE uuid IN (SELECT nvt FROM results WHERE (results.severity != -3.0)) UNION SELECT id, uuid, name, creation_time, modification_time, cvss AS severity, 75 AS qod, 'cve' AS type FROM cves WHERE uuid IN (SELECT nvt FROM results WHERE (results.severity != -3.0)) UNION SELECT id, uuid, name, creation_time, modification_time, max_cvss AS severity, 75 AS qod, 'ovaldef' AS type FROM ovaldefs WHERE uuid IN (SELECT nvt FROM results WHERE (results.severity != -3.0)) Creating Greenbone Vulnerability Manager admin user Failed to create user: Invalid characters in user name

antoninoferrara commented 4 years ago

The problem seems to be the double quotes for ${USERNAME} and ${PASSWORD}, in scripts/start.sh line 227 su -c 'gvmd --role="Super Admin" --create-user="${USERNAME}" --password="${PASSWORD}"' gvm

Best regards Thanks