Page validation errors may occur when opening real time graphs

[majed17]

in 1.2.12, today i opened the real time graphs and got..

 
--
2020/07/21 14:57:12 - CMDPHP Input Validation Not Performed for  'page4' Backtrace:  (/graphs_new.php[67]:graphs(),  /graphs_new.php[463]:load_current_session_value(),  /lib/html_utility.php[887]:get_request_var(),  /lib/html_utility.php[369]:html_log_input_error(),  /lib/html_validate.php[44]:cacti_debug_backtrace())
2020/07/21 14:57:06 - CMDPHP Input Validation Not Performed for  'page4' Backtrace:  (/graphs_new.php[67]:graphs(),  /graphs_new.php[463]:load_current_session_value(),  /lib/html_utility.php[887]:get_request_var(),  /lib/html_utility.php[369]:html_log_input_error(),  /lib/html_validate.php[44]:cacti_debug_backtrace())
2020/07/21 14:56:12 - CMDPHP Input Validation Not Performed for  'page4' Backtrace:  (/graphs_new.php[67]:graphs(),  /graphs_new.php[463]:load_current_session_value(),  /lib/html_utility.php[887]:get_request_var(),  /lib/html_utility.php[369]:html_log_input_error(),  /lib/html_validate.php[44]:cacti_debug_backtrace())
2020/07/21 14:56:07 - CMDPHP Input Validation Not Performed for  'page4' Backtrace:  (/graphs_new.php[67]:graphs(),  /graphs_new.php[463]:load_current_session_value(),  /lib/html_utility.php[887]:get_request_var(),  /lib/html_utility.php[369]:html_log_input_error(),  /lib/html_validate.php[44]:cacti_debug_backtrace())

[majed17]

in 1.2.13, after switching to systemd this appeared:

2020/07/21 15:46:36 - CMDPHP SQL Backtrace:   (/graph_realtime.php[27]:include(),  /include/auth.php[28]:require_once(),  /include/global.php[503]:include_once(),  /include/global_arrays.php[1508]:is_realm_allowed(),  /lib/auth.php[712]:db_table_exists(),  /lib/database.php[771]:db_fetch_cell(),  /lib/database.php[386]:db_fetch_cell_prepared(),  /lib/database.php[402]:db_execute_prepared())
--
2020/07/21 15:46:36 - CMDPHP ERROR: A DB Cell Failed!, Error: MySQL server has gone away
2020/07/21 15:46:36 - CMDPHP SQL Backtrace:   (/graph_realtime.php[27]:include(),  /include/auth.php[28]:require_once(),  /include/global.php[503]:include_once(),  /include/global_arrays.php[1508]:is_realm_allowed(),  /lib/auth.php[711]:is_user_perms_valid(),  /lib/auth.php[2669]:db_fetch_cell_prepared(),  /lib/database.php[402]:db_execute_prepared())
2020/07/21 15:46:36 - CMDPHP ERROR: A DB Cell Failed!, Error: MySQL server has gone away
2020/07/21 15:46:36 - CMDPHP SQL Backtrace:   (/graph_realtime.php[27]:include(),  /include/auth.php[28]:require_once(),  /include/global.php[503]:include_once(),  /include/global_arrays.php[973]:db_table_exists(),  /lib/database.php[771]:db_fetch_cell(),  /lib/database.php[386]:db_fetch_cell_prepared(),  /lib/database.php[402]:db_execute_prepared())
2020/07/21 15:46:36 - CMDPHP ERROR: A DB Cell Failed!, Error: MySQL server has gone away
2020/07/21 15:46:36 - CMDPHP SQL Backtrace:   (/graph_realtime.php[225]:set_user_setting(),  /lib/functions.php[165]:db_table_exists(),  /lib/database.php[771]:db_fetch_cell(),  /lib/database.php[386]:db_fetch_cell_prepared(),  /lib/database.php[402]:db_execute_prepared())
2020/07/21 15:46:36 - CMDPHP ERROR: A DB Cell Failed!, Error: MySQL server has gone away
2020/07/21 15:46:36 - CMDPHP SQL Backtrace:   (/graph_realtime.php[180]:rrdtool_function_graph(),  /lib/rrd.php[1244]:is_graph_allowed(),  /lib/auth.php[448]:get_allowed_graphs(),  /lib/auth.php[1192]:db_fetch_cell(),  /lib/database.php[386]:db_fetch_cell_prepared(),  /lib/database.php[402]:db_execute_prepared())
2020/07/21 15:46:36 - CMDPHP ERROR: A DB Cell Failed!, Error: MySQL server has gone away
2020/07/21 15:46:36 - CMDPHP SQL Backtrace:   (/graph_realtime.php[180]:rrdtool_function_graph(),  /lib/rrd.php[1244]:is_graph_allowed(),  /lib/auth.php[448]:get_allowed_graphs(),  /lib/auth.php[1188]:db_fetch_assoc(),  /lib/database.php[476]:db_fetch_assoc_prepared(),  /lib/database.php[490]:db_execute_prepared())
2020/07/21 15:46:36 - CMDPHP ERROR: A DB Row Failed!, Error: MySQL server has gone away
2020/07/21 15:46:36 - CMDPHP PHP ERROR NOTICE Backtrace:   (/graph_realtime.php[180]:rrdtool_function_graph(),  /lib/rrd.php[1244]:is_graph_allowed(),  /lib/auth.php[448]:get_allowed_graphs(),  /lib/auth.php[1165]:CactiErrorHandler())
2020/07/21 15:46:36 - ERROR PHP NOTICE: Trying to access array  offset on value of type bool in file:  /var/www/localhost/htdocs/cacti/lib/auth.php  on line: 1165
2020/07/21 15:46:36 - CMDPHP PHP ERROR NOTICE Backtrace:   (/graph_realtime.php[180]:rrdtool_function_graph(),  /lib/rrd.php[1244]:is_graph_allowed(),  /lib/auth.php[448]:get_allowed_graphs(),  /lib/auth.php[1164]:CactiErrorHandler())
2020/07/21 15:46:36 - ERROR PHP NOTICE: Trying to access array  offset on value of type bool in file:  /var/www/localhost/htdocs/cacti/lib/auth.php  on line: 1164
2020/07/21 15:46:36 - CMDPHP PHP ERROR NOTICE Backtrace:   (/graph_realtime.php[180]:rrdtool_function_graph(),  /lib/rrd.php[1244]:is_graph_allowed(),  /lib/auth.php[448]:get_allowed_graphs(),  /lib/auth.php[1164]:CactiErrorHandler())
2020/07/21 15:46:36 - ERROR PHP NOTICE: Trying to access array  offset on value of type bool in file:  /var/www/localhost/htdocs/cacti/lib/auth.php  on line: 1164

[netniV]

At first glance, that would appear to be a mysql issue as you are losing connectivity.

[majed17]

well that is for 1.2.13 ..

[bmfmancini]

check to make sure you have enough connections as well
check the stderr for a messge that says too many connections or any mysql related issue

[majed17]

enable mariadb err and i have this:

2020-07-23 16:50:26 10195 [Warning] Aborted connection 10195 to db: 'cacti' user: 'cactiuser' host: 'localhost' (Got timeout reading communication packets)
2020-07-23 16:52:32 10310 [Warning] Aborted connection 10310 to db: 'cacti' user: 'cactiuser' host: 'localhost' (Got timeout reading communication packets)
2020-07-23 16:52:51 10602 [Warning] Aborted connection 10602 to db: 'cacti' user: 'cactiuser' host: 'localhost' (Got timeout reading communication packets)
2020-07-23 16:54:13 10702 [Warning] Aborted connection 10702 to db: 'cacti' user: 'cactiuser' host: 'localhost' (Got timeout reading communication packets)
2020-07-23 16:56:27 10958 [Warning] Aborted connection 10958 to db: 'cacti' user: 'cactiuser' host: 'localhost' (Got timeout reading communication packets)
2020-07-23 16:57:14 11380 [Warning] Aborted connection 11380 to db: 'cacti' user: 'cactiuser' host: 'localhost' (Got timeout reading communication packets)
2020-07-23 16:58:04 11261 [Warning] Aborted connection 11261 to db: 'cacti' user: 'cactiuser' host: 'localhost' (Got timeout reading communication packets)

[TheWitness]

The first error is legit though.

[TheWitness]

Okay, those validation errors should be gone now.