You are here

Error on mysql when migrated to another server

2 posts / 0 new
Last post
cmiranda
cmiranda's picture
Error on mysql when migrated to another server
Today i need migrate opsview from one to another server, i follow these instructions: http://docs.opsview.com/doku.php?id=opsview3.0:dbs-on-diff-server (yes i have old version, but i need migrate before upgrade)   When restart opsview on /var/log/opsview/opsviewd.log i see this error:     [2013/09/23 13:07:17] [ndoutils_configdumpend] [INFO] Start [2013/09/23 13:07:18] [ndoutils_configdumpend] [FATAL] DBD::mysql::db do failed: Column 'markdown_filter' cannot be null [for Statement " INSERT INTO opsview_host_services_tmp  SELECT s.host_object_id, o.name1, o.object_id, o.name2, (s.notes_url != ''), sc.markdown_filter, sc.id, sc.servicegroup, hosts.icon_filename  FROM  nagios_objects o LEFT JOIN opsview.servicechecks sc   ON o.name2 = sc.name JOIN nagios_services s  ON o.object_id = s.service_object_id JOIN opsview_hosts_tmp hosts  ON s.host_object_id = hosts.id WHERE   o.objecttype_id=2 AND s.config_type = 1 "] [2013/09/23 13:07:20] [ndoutils_configdumpend] [INFO] End   All permissions are ok (checked with /usr/local/nagios/installer/upgradedb.pl) Anyone can help me please...?   Regards  
cmiranda
cmiranda's picture
Re: Error on mysql when migrated to another server

table runtime.opsview_host_services_tmp does not exists in old & new server