diff options
| author | David Sommerseth <davids@redhat.com> | 2010-03-25 17:31:23 +0100 |
|---|---|---|
| committer | David Sommerseth <davids@redhat.com> | 2010-03-25 17:31:23 +0100 |
| commit | 45a6c21d69266ec6069eb2b6ef917fc909c68aa3 (patch) | |
| tree | 43a025d6420a41598b73527268eed4da49bfd729 /server/parser | |
| parent | 732a1356a8c6f3913a73a09797f21655f2f4d395 (diff) | |
| download | rteval-45a6c21d69266ec6069eb2b6ef917fc909c68aa3.tar.gz rteval-45a6c21d69266ec6069eb2b6ef917fc909c68aa3.tar.xz rteval-45a6c21d69266ec6069eb2b6ef917fc909c68aa3.zip | |
Don't consider IP address if the value is NULL when looking up registered systems
Diffstat (limited to 'server/parser')
| -rw-r--r-- | server/parser/pgsql.c | 9 |
1 files changed, 7 insertions, 2 deletions
diff --git a/server/parser/pgsql.c b/server/parser/pgsql.c index f89184e..dbf1bc6 100644 --- a/server/parser/pgsql.c +++ b/server/parser/pgsql.c @@ -807,8 +807,13 @@ int db_register_system(dbconn *dbc, xsltStylesheet *xslt, xmlDoc *summaryxml) { // Check if this hostname and IP address is registered snprintf(sqlq, 4096, "SELECT syskey FROM systems_hostname" - " WHERE hostname='%.256s' AND ipaddr='%.64s'", - hostname, ipaddr); + " WHERE hostname='%.256s'", + hostname); + + if( ipaddr ) { + snprintf(sqlq, 4096, " AND ipaddr='%.64s'", ipaddr); + } + dbres = PQexec(dbc->db, sqlq); if( PQresultStatus(dbres) != PGRES_TUPLES_OK ) { writelog(dbc->log, LOG_ALERT, "[Connection %i] SQL %s", |