Oxidized reload nodes

[samucabrave]

Hello,

The oxidized reload node options not working on my LibreNMS. When I click on this option, the message appears that it has been updated but none of the devices appear. Bellow my config.php

# Enable Oxidized
$config['oxidized']['enabled'] = TRUE;
$config['oxidized']['url'] = 'https://myhostnamehere/nodes';
$config['oxidized']['features']['versioning'] = true;
$config['oxidized']['reload_nodes'] = true;

The page from LibreNMS

The page from Oxidized

And the last, my config from oxidized

username: 
password:
model: cisco
resolve_dns: true
interval: 3600
use_syslog: false
debug: true
run_once: false
threads: 5
timeout: 120
retries: 0
prompt: !ruby/regexp /^([\w.@-]+[#>]\s?)$/
extensions:
  oxidized-web:
    load: true
    listen: '[::]'
    vhosts:
     - myhostnamehere
     - vshostshere
#rest: 127.0.0.1:8888
next_adds_job: false
vars: {}
ssh_no_keepalive: true
auth_methods: [ "none", "publickey", "password", "keyboard-interactive" ]
groups: {}
group_map: {}
models: {}
pid: "/home/oxidized/.config/oxidized/pid"
crash:
  directory: "/home/oxidized/.config/oxidized/crashes"
  hostnames: false
stats:
  history_size: 10
input:
  default: ssh, telnet
  debug: false
  ssh:
    secure: false
  ftp:
    passive: true
  utf8_encoded: true
output:
   default: git
   git:
     user: 
     email: 
     repo: /home/oxidized/.config/oxidized/default.git
source:
  default: http
  debug: false
  http:
    url: https://myhostnamehere/api/v0/oxidized
    secure: false
    map:
      name: hostname
      model: os
      group: group
    headers:
      X-Auth-Token: ''
# source:
#   default: csv
#   csv:
#     file: "/home/oxidized/.config/oxidized/router.db"
#     delimiter: !ruby/regexp /:/
#     map:
#       name: 0
#       model: 1
#     gpg: false
model_map:
  juniper: junos
  cisco: ios
  gaia: gaiaos

[laf]

If they are in oxidized but not showing in LibreNMS, run validate in the webui under settings to see if anything is flagged there.

[gil.obradors]

@samucabrave try to remove nodes from url:

$config['oxidized']['url'] = 'https://myhostnamehere';

At least in my installation it is working perfectly, and I have it that way.

[RR1]

@ samucabrave

What is the URL used to directly access the nodes from oxidized

[samucabrave]

In webui show some errors in database scheme, but, when i’ll run the fix, nothing happens. this is the error in my Librenms

usgin the validate.php in pod to fix error, nothing happens too

[samucabrave]

i try do this and nothing happens… finally, i commented the oxidized integration in config.php to set in librenms web

[samucabrave]

Update:

I know what happens… as I use Azure MySQL, the lower_case_table_names parameter defaults to 1 to be lowercase and some tables use sensitive case.

I’ll try using another database and do a new tests.