So I am having an Issue migrating my db/old graphs from an existing server to a new server. The old server is running 0.8.8a the new server is running 1.1.38 on Debian 9. I followed the following steps to migrate and everything worked and the db seems to be present with proper credentials and the rrd files are in the right place. I also made sure to convert the rrd to xml on the machine they were created on then sftp them to the new build where they were converted back to rrd and permissions changed. However when I go to my cacti build there is none of my old graphs available. Am I missing something? any help would be awesome. I can provide any other information to help with my troubleshooting. (I added some outputs I though might be helpful)
Guide used:
http://xmodulo.com/migrate-cacti-server.html
Example of path
root@cacti:/var/lib/cacti/rra# ls -l
total 363260
-rw-r--r-- 1 www-data www-data 94816 Mar 1 12:38 atlmx480_traffic_in_492.rrd
-rw-r--r-- 1 root root 634307 Mar 1 12:34 atlmx480_traffic_in_492.rrd.xml
-rw-r--r-- 1 www-data www-data 94816 Mar 1 12:38 atlmx480_traffic_in_493.rrd
-rw-r--r-- 1 root root 634305 Mar 1 12:34 atlmx480_traffic_in_493.rrd.xml
-rw-r--r-- 1 www-data www-data 94816 Mar 1 12:38 atlmx480_traffic_in_494.rrd
-rw-r--r-- 1 root root 634307 Mar 1 12:34 atlmx480_traffic_in_494.rrd.xml
-rw-r--r-- 1 www-data www-data 94816 Mar 1 12:38 atlmx480_traffic_in_495.rrd
-rw-r--r-- 1 root root 634309 Mar 1 12:34 atlmx480_traffic_in_495.rrd.xml
-rw-r--r-- 1 www-data www-data 94816 Mar 1 12:37 atlmx480_traffic_in_496.rrd
-rw-r--r-- 1 root root 634307 Mar 1 12:34 atlmx480_traffic_in_496.rrd.xml
DB output
mysql -u cacti -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 123
Server version: 10.1.26-MariaDB-0+deb9u1 Debian 9.1
Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> use cacti;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
MariaDB [cacti]> select description from host;
+-------------+
| description |
+-------------+
| Localhost |
+-------------+
1 row in set (0.00 sec)
MariaDB [cacti]>
Migrating Cacti 0.8.8a to a new server running 1.1.38 Debian
Moderators: Developers, Moderators
Migrating Cacti 0.8.8a to a new server running 1.1.38 Debian
- Attachments
-
- Screen Shot 2019-03-01 at 12.13.22 PM.png (177.38 KiB) Viewed 1057 times
- camerabob
- Cacti User
- Posts: 386
- Joined: Fri Feb 10, 2017 2:45 pm
- Location: Long Island, New York, USA
- Contact:
Re: Migrating Cacti 0.8.8a to a new server running 1.1.38 De
The only thing coming to mind for me: Are the old files in the correct location? I would insure that they are and being updated.
Prod: Cacti 1.2.15 @ CentOS Linux release 7.9.2009 (Core) & PHP 5.4.16-48.el7
Maint @ 1.2
Monitor @ 2.3.6
Thold @ 1.2.4
Temp: Cacti 1.2.3 @ CentOS Linux release 7.9.2009 (Core) & PHP 5.4.16-48.el7
Flowview @ 2.1
Mactrack @ 4.2
Maint @ 1.2
Monitor @ 2.3.6
Router Configs @ 1.3.4
Syslog Monitoring @ 2.1
Thold @ 1.2.4
Maint @ 1.2
Monitor @ 2.3.6
Thold @ 1.2.4
Temp: Cacti 1.2.3 @ CentOS Linux release 7.9.2009 (Core) & PHP 5.4.16-48.el7
Flowview @ 2.1
Mactrack @ 4.2
Maint @ 1.2
Monitor @ 2.3.6
Router Configs @ 1.3.4
Syslog Monitoring @ 2.1
Thold @ 1.2.4
Re: Migrating Cacti 0.8.8a to a new server running 1.1.38 De
Why go to 1.1.38? I would go straight to 1.2.2.
Either way, look at Data Source Info and Data Source Debug on the data source of the graph.
Either way, look at Data Source Info and Data Source Debug on the data source of the graph.
Cacti Developer & Release Manager
The Cacti Group
Director
BV IT Solutions Ltd
+--------------------------------------------------------------------------+
Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation
The Cacti Group
Director
BV IT Solutions Ltd
+--------------------------------------------------------------------------+
Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation
Who is online
Users browsing this forum: No registered users and 0 guests