Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Fri Aug 17, 2018 12:12 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 4 posts ] 
Author Message
 Post subject: [solved] Migrate data to new server
PostPosted: Fri Aug 25, 2017 11:18 am 
Offline

Joined: Sun Dec 20, 2009 10:22 pm
Posts: 10
Location: USA
Hello.

I want to build a new 2012 windows CACTI server and migrate my CACTI data from an old 2008 server install.

i did find some migrating instructions, but they are for linux install (http://xmodulo.com/migrate-cacti-server.html). I assume the jist is the same for windows, but if somebody knows of a instruction set specific to windows - that would be great.

However, my question is really in a different area:

The reason for my upgrading to a newer server is that a in-place migration attempt from CACTI 0.8.8d to the newest version broke the installation ("This page cannot be displayed" kinda problem).

Rather than trying to fix it - i might as well just bring everything up-to-par.

So - can i build a new server, do a fresh CACTI install and then just copy/restore the mySQL data and the rrd files from the old 0.8.8d into the new 1.1.17?

Thanks for your advise and instruction sets (if you have some).


Top
 Profile  
 
 Post subject: Re: Migrate data to new server
PostPosted: Wed Aug 30, 2017 11:47 am 
Offline

Joined: Sun Dec 20, 2009 10:22 pm
Posts: 10
Location: USA
So I have build a new 2012r2 Windows Server, installed the new CACTI using the Windows install package with version 1.1.17, and used the migration technique specced in this site (http://xmodulo.com/migrate-cacti-server.html).

However, I don't see my devices, or the graph tree, etc.

What am I missing?


Thanks for your help.


Top
 Profile  
 
 Post subject: Re: Migrate data to new server
PostPosted: Wed Aug 30, 2017 12:42 pm 
Offline

Joined: Sun Dec 20, 2009 10:22 pm
Posts: 10
Location: USA
so i installed the mySQL Workbench - come to find out that the restor of the CACTI DB failed - the tables are all empty

while i am trying to find the reason....

anyone have a clue already?


Top
 Profile  
 
 Post subject: Re: Migrate data to new server
PostPosted: Wed Aug 30, 2017 4:57 pm 
Offline

Joined: Sun Dec 20, 2009 10:22 pm
Posts: 10
Location: USA
i got it working

so basic strategy as mentioned in the link above works, except:

the dump command for the mySQL CACTI database created a faulty sql file (at some point on the restore command it errors with mismatched column count)

the fix is to install mySQL Workbench and use the built in export and import option, i used the single file option. - that will create and import everything (i did check the 3 check boxes to include triggers, etc, and the create shema). i also dropped the existing database before the import which was created by the new cacti install.

once i started cacti, it recognized the old data and converted it to the new 1.1.17 version. On my end there were 2 conversion errors (i think it was on some snmp table), but everything was there (devices, graphs, etc) and fully functional.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 8 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group