Device not getting added using add_device.php from CLI

[phil-1666]

Describe the bug

Device not getting added using add_device.php from CLI

To Reproduce

php add_device.php --description=test2023-02-10 --ip=10.10.10.12 Adding test2023-02-10 (10.10.10.12) as "Generic SNMP-enabled Host" using SNMP v0 with community "" Success - new device-id: (0)

Can not find device searching under devices in GUI

Expected behavior

Should be able to find device.

Desktop (please complete the following information)

• OS: [e.g. iOS] opensuse

• Browser [e.g. chrome, safari] firefox

• Version [e.g. 22] 109.0.1

Additional context

Cacti logs show: 2023/02/10 14:26:16 - CMDPHP ERROR: A DB Exec Failed!, Error: Column 'monitor' cannot be null 2023/02/10 14:26:16 - CMDPHP SQL Backtrace: (/cli/add_device.php[452]:api_device_save(), /lib/api_device.php[749]:sql_save(), /lib/database.php[1472]:_db_replace(), /lib/database.php[1402]:db_execute(), /lib/database.php[238]:db_execute_prepared())

I do have the thold and monitor plugins installed and activated.

To me, this sounds similar to issue #3111.

[phil-1666]

I just tried it on an older install we have, 1.2.16, on a SLES server. This install has the thold and monitor plugins installed but both are disabled. The command ran okay:

php add_device.php --description=test2023-02-10 --ip=10.10.10.12 Adding test2023-02-10 (10.10.10.12) as "Generic SNMP-enabled Host" using SNMP v0 with community ""

and I was able to find device in the GUI.

Version of our current Cacti is 1.2.18.

[bmfmancini]

Disable the monitor plugin see if that works first

If it does then we can narrow it down

On Fri, Feb 10, 2023, 2:47 p.m. phil-1666 @.***> wrote:

Describe the bug

Device not getting added using add_device.php from CLI To Reproduce

php add_device.php --description=test2023-02-10 --ip=10.10.10.12 Adding test2023-02-10 (10.10.10.12) as "Generic SNMP-enabled Host" using SNMP v0 with community "" Success - new device-id: (0)

Can not find device searching under devices in GUI Expected behavior

Should be able to find device. Desktop (please complete the following information)

-

OS: [e.g. iOS] opensuse

Browser [e.g. chrome, safari] firefox

Version [e.g. 22] 109.0.1

Additional context

Cacti logs show: 2023/02/10 14:26:16 - CMDPHP ERROR: A DB Exec Failed!, Error: Column 'monitor' cannot be null 2023/02/10 14:26:16 - CMDPHP SQL Backtrace: (/cli/add_device.php[452]:api_device_save(), /lib/api_device.php[749]:sql_save(), /lib/database.php[1472]:_db_replace(), /lib/database.php[1402]:db_execute(), /lib/database.php[238]:db_execute_prepared())

I do have the thold and monitor plugins installed and activated.

To me, this sounds similar to issue #3111 https://github.com/Cacti/cacti/issues/3111.

— Reply to this email directly, view it on GitHub https://github.com/Cacti/cacti/issues/5234, or unsubscribe https://github.com/notifications/unsubscribe-auth/ADGEXTE4VGUOXRDIPDNVCI3WW2LODANCNFSM6AAAAAAUYFLX3Y . You are receiving this because you are subscribed to this thread.Message ID: @.***>

[phil-1666]

I just tried it again on our newer install, with the monitor plugin disabled. Seems like it worked: php add_device.php --description=test2023-02-10 --ip=10.10.10.12 Adding test2023-02-10 (10.10.10.12) as "Generic SNMP-enabled Host" using SNMP v0 with community "" Success - new device-id: (569)

and I can find the device in the GUI.

[TheWitness]

The monitor plugin does make some changes. I'm going to close this one, and maybe look to see if there is something in Monitor that needs attention.

[phil-1666]

Thanks - temporarily disabling monitor seems to be a pretty good work around.