Auto Polling and Database lower case tables names

[kenny_ng]

Auto Polling is not working and when i ran ./validate.php:

Running on Docker on MacOS so --lower-case-table-names=1 cannot be 0 otherwise this error occurs: The server option 'lower_case_table_names' is configured to use case sensitive table names but the data directory resides on a case-insensitive file system. Please use a case sensitive file system for your data directory or switch to a case-insensitive table name mode.

Docker Compose File for DB:

  db:
    image: mariadb:10
    container_name: librenms_db
    cap_add:
    - NET_ADMIN
    - NET_RAW
    command:
      - "mysqld"
      - "--innodb-file-per-table=1"
      - "--lower-case-table-names=1"
      - "--character-set-server=utf8mb4"
      - "--collation-server=utf8mb4_unicode_ci"
    volumes:
      - "./db:/var/lib/mysql"
    environment:
      - "TZ=${TZ}"
      - "MARIADB_RANDOM_ROOT_PASSWORD=yes"
      - "MYSQL_DATABASE=${MYSQL_DATABASE}"
      - "MYSQL_USER=${MYSQL_USER}"
      - "MYSQL_PASSWORD=${MYSQL_PASSWORD}"
    restart: always

Tried Looking into this:

Poller doesn't run automatically

Tried that already, it seems that the mysql database just places everything in lower cases: MariaDB [librenms]> RENAME TABLE bgppeers TO _bgppeers; Query OK, 0 rows affected (0.13 sec) MariaDB [librenms]> RENAME TABLE `_bgppeers` TO `bgpPeers`; Query OK, 0 rows affected (0.01 sec) MariaDB [librenms]> show tables ; +--------------------------+ | Tables_in_librenms | +--------------------------+ | access_points | | alert_log | | alert_map | | ale…

[laf]

Unfortunately you need a case sensitive file system, you can create a fake volume in DiskUtility on mac and use a case sensitive filesystem, spin the docker vm up on that new partition. Works fine.