When a user has been deleted, checking permissions can cause errors

[bmfmancini]

Not sure if this is new but I don't see any bug reports

2023/01/11 11:07:02 - CMDPHP ERROR: A DB Row Failed!, Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND type = 1) OR h.id IN (SELECT item_id FROM user_auth_group_perms WHERE group_' at line 1
2023/01/11 11:07:02 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/intropage/poller_intropage.php[107]:intropage_gather_stats(), /plugins/intropage/poller_intropage.php[222]:maint(), /plugins/intropage/panellib/misc.php[173]:intropage_get_allowed_devices(), /plugins/intropage/include/functions.php[42]:get_allowed_devices(), /lib/auth.php[2685]:get_policy_where(), /lib/auth.php[1922]:CactiErrorHandler())
2023/01/11 11:07:02 - ERROR PHP NOTICE: Undefined index: id in file: /var/www/html/cacti/lib/auth.php on line: 1922
2023/01/11 11:07:02 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/intropage/poller_intropage.php[107]:intropage_gather_stats(), /plugins/intropage/poller_intropage.php[222]:maint(), /plugins/intropage/panellib/misc.php[173]:intropage_get_allowed_devices(), /plugins/intropage/include/functions.php[42]:get_allowed_devices(), /lib/auth.php[2685]:get_policy_where(), /lib/auth.php[1919]:CactiErrorHandler())
2023/01/11 11:07:02 - ERROR PHP NOTICE: Undefined index: policy_graph_templates in file: /var/www/html/cacti/lib/auth.php on line: 1919
2023/01/11 11:07:02 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/intropage/poller_intropage.php[107]:intropage_gather_stats(), /plugins/intropage/poller_intropage.php[222]:maint(), /plugins/intropage/panellib/misc.php[173]:intropage_get_allowed_devices(), /plugins/intropage/include/functions.php[42]:get_allowed_devices(), /lib/auth.php[2685]:get_policy_where(), /lib/auth.php[1914]:CactiErrorHandler())
2023/01/11 11:07:02 - ERROR PHP NOTICE: Undefined index: id in file: /var/www/html/cacti/lib/auth.php on line: 1914
2023/01/11 11:07:02 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/intropage/poller_intropage.php[107]:intropage_gather_stats(), /plugins/intropage/poller_intropage.php[222]:maint(), /plugins/intropage/panellib/misc.php[173]:intropage_get_allowed_devices(), /plugins/intropage/include/functions.php[42]:get_allowed_devices(), /lib/auth.php[2685]:get_policy_where(), /lib/auth.php[1911]:CactiErrorHandler())
2023/01/11 11:07:02 - ERROR PHP NOTICE: Undefined index: policy_hosts in file: /var/www/html/cacti/lib/auth.php on line: 1911

[xmacan]

It isn't Intropage issue. It is in cacti auth functions. Maybe @TheWitness will know more.

[TheWitness]

Oh my gosh. This looks like an old bug. not even sure it's still relevant. Let me grab the latest intropage develop and take a peak.

[xmacan]

I think that it isn't intropage issue. Intropage has function intropage_get_allowed_devices which call get_allowed_devices from auth.php. We don't know Cacti version which @bmfmancini used. ...

[TheWitness]

Just added this. I'm move this bug to the Cacti side shortly, if I can. Otherwise, we can refer to the bug and close. Basically, it's a deleted user.

[bmfmancini]

This is on 1.2.22