Failed to get objects: Error while connecting to MySQL server. Maybe wrong connection properties in backend? MySQL-Error: . (Backend-ID: ndomy_1)

  • I have a problem.


    When I add host icon over map, appears the following error:

    Failed to get objects: Error while connecting to MySQL server. Maybe wrong connection properties in backend? MySQL-Error: . (Backend-ID: ndomy_1)


    My configuration nagvis.ini.php file is:


    backendtype="ndomy"

    dbhost="localhost"

    dbport=3306

    dbname="nagios"

    dbuser="nagios"

    dbpass="xxxxxxxxxx"

    dbprefix="nagios_"

    dbinstancename="default"

    maxtimewithoutupdate=180

    htmlcgi="/nagios/cgi-bin"


    And Version Information Nagvis is:


    NagVis Version: 1.9b11

    PHP Version: 5.6.29

    MySQL Version: mysql Ver 15.1 Distrib 10.1.20-MariaDB, for Linux (x86_64) using readline 5.1

    OS: Linux, rhel 7

    Webserver

    Version Information


    NagVis Version: 1.9b11

    PHP Version: 5.6.29

    MySQL Version : mysql Ver 15.1 Distrib 10.1.20-MariaDB, for Linux (x86_64) using readline 5.1

    OS: Linux


    Webserver Information

    SERVER_SOFTWARE: Apache/2.4.23 (Unix) OpenSSL/1.0.1e-fips PHP/5.6.29

    Memory_limit: 128M

    Loaded modules: Core, date, ereg, libxml, openssl, pcre, sqlite3, zlib, bz2, ctype, dom, fileinfo, filter, gd, gettext, hash, iconv, json, mbstring, mysql, SPL, mysqli, PDO, pdo_mysql, pdo_sqlite, session, posix, Reflection, standard, SimpleXML, sockets, Phar, tokenizer, xml, xmlreader, xmlwriter, apache2handler



    My mysql and nagios work fine


    MariaDB [nagios]> describe nagios_hosts;


    +-----------------------------------+--------------+------+-----+---------+----------------+

    | Field | Type | Null | Key | Default | Extra |

    +-----------------------------------+--------------+------+-----+---------+----------------+

    | host_id | int(11) | NO | PRI | NULL | auto_increment |

    | instance_id | smallint(6) | NO | MUL | 0 | |

    | config_type | smallint(6) | NO | | 0 | |

    | host_object_id | int(11) | NO | MUL | 0 | |

    | alias | varchar(64) | NO | | | |

    | display_name | varchar(64) | NO | | | |

    | address | varchar(128) | NO | | | |

    | importance | int(11) | NO | | 0 | |

    | check_command_object_id | int(11) | NO | | 0 | |

    | check_command_args | varchar(255) | NO | | | |

    | eventhandler_command_object_id | int(11) | NO | | 0 | |

    | eventhandler_command_args | varchar(255) | NO | | | |

    | notification_timeperiod_object_id | int(11) | NO | | 0 | |

    | check_timeperiod_object_id | int(11) | NO | | 0 | |

    | failure_prediction_options | varchar(64) | NO | | | |

    | check_interval | double | NO | | 0 | |

    | retry_interval | double | NO | | 0 | |

    | max_check_attempts | smallint(6) | NO | | 0 | |

    | first_notification_delay | double | NO | | 0 | |

    | notification_interval | double | NO | | 0 | |

    | notify_on_down | smallint(6) | NO | | 0 | |

    | notify_on_unreachable | smallint(6) | NO | | 0 | |

    | notify_on_recovery | smallint(6) | NO | | 0 | |

    | notify_on_flapping | smallint(6) | NO | | 0 | |

    | notify_on_downtime | smallint(6) | NO | | 0 | |

    | stalk_on_up | smallint(6) | NO | | 0 | |

    | stalk_on_down | smallint(6) | NO | | 0 | |

    | stalk_on_unreachable | smallint(6) | NO | | 0 | |

    | flap_detection_enabled | smallint(6) | NO | | 0 | |

    | flap_detection_on_up | smallint(6) | NO | | 0 | |

    | flap_detection_on_down | smallint(6) | NO | | 0 | |

    | flap_detection_on_unreachable | smallint(6) | NO | | 0 | |

    | low_flap_threshold | double | NO | | 0 | |

    | high_flap_threshold | double | NO | | 0 | |

    | process_performance_data | smallint(6) | NO | | 0 | |

    | freshness_checks_enabled | smallint(6) | NO | | 0 | |

    | freshness_threshold | smallint(6) | NO | | 0 | |

    | passive_checks_enabled | smallint(6) | NO | | 0 | |

    | event_handler_enabled | smallint(6) | NO | | 0 | |

    | active_checks_enabled | smallint(6) | NO | | 0 | |

    | retain_status_information | smallint(6) | NO | | 0 | |

    | retain_nonstatus_information | smallint(6) | NO | | 0 | |

    | notifications_enabled | smallint(6) | NO | | 0 | |

    | obsess_over_host | smallint(6) | NO | | 0 | |

    | failure_prediction_enabled | smallint(6) | NO | | 0 | |

    | notes | varchar(255) | NO | | | |

    | notes_url | varchar(255) | NO | | | |

    | action_url | varchar(255) | NO | | | |

    | icon_image | varchar(255) | NO | | | |

    | icon_image_alt | varchar(255) | NO | | | |

    | vrml_image | varchar(255) | NO | | | |

    | statusmap_image | varchar(255) | NO | | | |

    | have_2d_coords | smallint(6) | NO | | 0 | |

    | x_2d | smallint(6) | NO | | 0 | |

    | y_2d | smallint(6) | NO | | 0 | |

    | have_3d_coords | smallint(6) | NO | | 0 | |

    | x_3d | double | NO | | 0 | |

    | y_3d | double | NO | | 0 | |

    | z_3d | double | NO | | 0 | |

    +-----------------------------------+--------------+------+-----+---------+----------------+

    59 rows in set (0.00 sec)


    Any sugesstion, thanks


    Regards