Install Remote :1146 Table 'centreon.nagios_macro'

Hi @sdouce, which version of Centreon do you used?

Hello,

I am currently encountering the same error on my centreon server in version 24.10 during installation. For your information, we want to set up a remote database. 

Has anyone found a solution ? 

Thanks a lot !

Hi, this table is describe in the SQL file to create all needed tables;

https://github.com/centreon/centreon/blob/develop/centreon/www/install/createTables.sql#L1617

Can tou try to create it manually:

CREATE TABLE `nagios_macro` (
  `macro_id` int(11) NOT NULL AUTO_INCREMENT,
  `macro_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`macro_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Hello,

I apologize for the late reply. Manually adding the table to the database solved the problem.
Thank you very much.

Have a nice day!