NMAP_SCAN_CRON throwing error about ona HOT 8 CLOSED

On Fri, Apr 3, 2020, 20:30 mike-kll ***@***.***> wrote: I have the same problem is there a solution? My Environment Debian 10.3 Apache 2.4.38 PHP 7.3 When I execute /opt/ona-master/bin/dcm.pl -r ona_sql sql=nmap_subnets_only_yes.sql I get this error: Input array has 1 params, does not match query: '-- List all hosts, including other attributes -- LONG_DESC: -- This query will return a list of FQDN names for all hosts in the database. -- It includes the device type, IP, MAC, Subnet name, and location -- USAGE: -- No options available for this query, just run it -- Your SQL statement would go below this line: select concat(dns.name,".",z.name) fqdn, concat(m.name," ",models.name," (",roles.name,")") device_type, INET_NTOA(i.ip_addr) ip, i.mac_addr mac, s.name netname, l.reference location from interfaces i, dns, domains z, subnets s, manufacturers m, models, roles, device_types, hosts, devices left join locations l on (devices.location_id = l.id) where i.host_id = hosts.id and dns.domain_id = z.id and hosts.primary_dns_id = dns.id and s.id = i.subnet_id and devices.id = hosts.device_id and models.manufacturer_id = m.id and device_types.model_id = models.id and device_types.role_id = roles.id and devices.device_type_id = device_types.id order by i.ip_addr' 3 ERROR => SQL query failed: When i execute the sql statements in the mysql Shel is working. — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#155 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AC6SLCBRKCRG6LSP5HT3JRTRKYTNZANCNFSM4K7AZFGQ> .

On Fri, Apr 3, 2020, 21:07 mike-kll ***@***.***> wrote: Thats it, it works now. Thanks a lot Gankarloo!!! — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#155 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AC6SLCDFZ7FEDCNZQ6XDQIDRKYXYDANCNFSM4K7AZFGQ> .