Forum Discussion

DPO's avatar
DPO
Level 6
7 years ago

NetBackup 8.1 MYSQL backups


master server 5240 appliance with 3.1 and clients with 8.1 . The mysql config is binded with an IP address instead of localhost or 127.0.0.1. But it seems NetBackup is trying to connect as "localhost" only. Can we tell somewhere NetBackup to not to use localhost for connecting . This occurs when i try to initiate a backup. 

As a work around when we add x.x.x.x localhost in /etc/hosts it works .

#/usr/NBMySQLAgent/nbmysql -o backup 
Failed to connect to MySQL. Error: Can't create TCP/IP socket (97)
Failed to connect to the MySQL server as backup1@ 'localhost' using port 3306


tail /usr/NBMySQLAgent/nbmysql.log
2018-04-17 08:12:17 DEBUGS: MYSQL_LIB_INSTALL_PATH => /mysqlbin/system/mysql/lib
2018-04-17 08:12:17 DEBUGS: NBMYSQL_LOG_LEVEL => 4
2018-04-17 08:12:17 DEBUGS: OPERATION => backup
2018-04-17 08:12:17 DEBUGS: POLICY_NAME => MySQL_Backup
2018-04-17 08:12:17 DEBUGS: SCHEDULE_NAME => Daily_Full
2018-04-17 08:12:17 DEBUGS: SNAPSHOT_SIZE => 78G
2018-04-17 08:12:17 DEBUGS: Loading MySQL library - /mysqlbin/system/mysql/lib/libmysqlclient.so
2018-04-17 08:12:17 ERR: Failed to connect to MySQL. Error: Can't create TCP/IP socket (97)
2018-04-17 08:12:17 ERR: Failed to connect to the MySQL server as backup1 @ 'localhost' using port 3306
2018-04-17 08:12:17 ERR: An error occurred while performing backup

1 Reply

  • I'm particulary interested in the following statement. Document says ,

    (Linux) Users of the agent must be a superuser or have superuser privileges

    Is it OK to create a user to perform backups only at the MySQL level or does the user needs to be present at OS level too with superuser privileges ?