Postgresql is not my thing.
"""
tasks=> SELECT max(severity) FROM report_counts WHERE report = 4469 AND
override = 1 AND user = 'admin' AND min_qod = 70;
max
-----
(1 row)
"""
It works with user = '' using quotes.
The query for the UUID gives back an integer:
"""
tasks=> SELECT id FROM users WHERE uuid =
'aa9e7cb5-3ad9-41fd-95d5-e15716067b20';
id
----
1
(1 row)
"""
Shouldn't everyone run in to this bug?
"""
tasks=> SELECT max(severity) FROM report_counts WHERE report = 4469 AND
override = 1 AND user = 1 AND min_qod = 70;
ERROR: operator does not exist: name = integer
LINE 1: ...nts WHERE report = 4469 AND override = 1 AND user = 1 AND mi...
^
HINT: No operator matches the given name and argument type(s). You might need
to add explicit type casts.
tasks=> SELECT max(severity) FROM report_counts WHERE report = 4469 AND
override = 1 AND user = '1' AND min_qod = 70;
max
-----
(1 row)
"""
Thijs Stuurman
Quality & Security | KPN Internedservices B.V.
[email protected]<mailto:[email protected]> |
[email protected]<mailto:[email protected]>
T: +31(0)299476185 | M: +31(0)624366778
PGP Key-ID: 0x16ADC048 (https://pgp.surfnet.nl/)
Fingerprint: 2EDB 9B42 D6E8 7D4B 6E02 8BE5 6D46 8007 16AD C048
W: https://www.internedservices.nl<https://www.internedservices.nl/> | L:
https://nl.linkedin.com/in/thijsstuurman
Van: Openvas-discuss <[email protected]> Namens Thijs
Stuurman
Verzonden: vrijdag 31 augustus 2018 11:39
Aan: [email protected]
Onderwerp: [Openvas-discuss] PQexec failed: ERROR: operator does not exist:
name = integer
OpenVAS discuss,
I had some performance issues so I decided to reinstall OpenVAS on all my nodes
from:
openvas-libraries-9.0.1.tar.gz
openvas-manager-7.0.1.tar.gz
openvas-scanner-5.1.1.tar.gz
to:
openvas-libraries-9.0.3.tar.gz
openvas-manager-7.0.3.tar.gz
v5.1.3.tar.gz
(openvas-scanner tar.gz name is wrong but that's how it gets downloaded from
the site).
All good, setup everything again; using my existing database (tried openvasmd
-migrate, does nothing).
Slaves up and running, CA certs replaced etc'.
Now, everything runs very well but when a scan ends there is an SQL error:
"""
event task:MESSAGE:2018-08-31 11h30.40 CEST:16331: Status of task domain_ka -
officeclient (8fb8bc4a-aa53-480a-a4f2-0967864c313f) has changed to Done
md manage:WARNING:2018-08-31 11h30.40 CEST:16331: sql_exec_internal: PQexec
failed: ERROR: operator does not exist: name = integer
LINE 1: ...nts WHERE report = 4469 AND override = 1 AND user = (SELECT ...
^
HINT: No operator matches the given name and argument type(s). You might need
to add explicit type casts.
(7)
md manage:WARNING:2018-08-31 11h30.40 CEST:16331: sql_exec_internal: SQL:
SELECT max(severity) FROM report_counts WHERE report = 4469 AND override = 1
AND user = (SELECT id FROM users WHERE uuid =
'aa9e7cb5-3ad9-41fd-95d5-e15716067b20') AND min_qod = 70 AND (end_time = 0 or
end_time >= m_now ());
md manage:WARNING:2018-08-31 11h30.40 CEST:16331: next: sql_exec_internal failed
md manage:WARNING:2018-08-31 11h30.40 CEST:16331: manage_cleanup_process_error:
Error exit, setting running task to Internal Error
event task:MESSAGE:2018-08-31 11h30.40 CEST:16331: Status of task domain_ka -
officeclient (8fb8bc4a-aa53-480a-a4f2-0967864c313f) has changed to Internal
Error
"""
Looking at my database, "'aa9e7cb5-3ad9-41fd-95d5-e15716067b20'" is the UUID
for the Admin user which I use to start the task:
"""
cat tasks.sql | grep aa9e7cb5-3ad9-41fd-95d5-e15716067b20
1 aa9e7cb5-3ad9-41fd-95d5-e15716067b20 \N admin \N
"""
I don't think I have changed enough to suddenly cause this error so I am not
sure where to even begin on this one.
Everything runs fine, the job results are ok .. but it cannot go from 100% to
status Done on a task because of this error.
Anyone who has an idea or experienced this before?
Thijs Stuurman
Quality & Security | KPN Internedservices B.V.
[email protected]<mailto:[email protected]> |
[email protected]<mailto:[email protected]>
T: +31(0)299476185 | M: +31(0)624366778
PGP Key-ID: 0x16ADC048 (https://pgp.surfnet.nl/)
Fingerprint: 2EDB 9B42 D6E8 7D4B 6E02 8BE5 6D46 8007 16AD C048
W: https://www.internedservices.nl<https://www.internedservices.nl/> | L:
https://nl.linkedin.com/in/thijsstuurman
_______________________________________________
Openvas-discuss mailing list
[email protected]
https://lists.wald.intevation.org/cgi-bin/mailman/listinfo/openvas-discuss
