A try2 Install 0.8.7i with PIA over previous apt-get install

[Chilloutfaktor]

Hey guys,

i got a ubuntu 10.10 server with cacti installed via "apt-get install cacti".
As i read in many posts there is no official updatepacket to 0.8.7i.
Because there was no Documentation or Howto how to get 0.8.7i with PIA to work over a packet install, i'm writing this.
And there is also no pia 3.1 build to merge with the ubuntu packet.....

First i updatet my previous 0.8.7g cacti to i. You can get builded .deb files here:
https://launchpad.net/ubuntu/precise/+package/cacti

for me it was:
cd /tmp/
wget http://launchpadlibrarian.net/90419990/ ... u1_all.deb
dpkg -i cacti_0.8.7i-2ubuntu1_all.deb

check on the website if everything is working. (this is without PIA, so you dont see your plugins)
then backup/copy all files of /usr/share/cacti. maybe you will need them later.

now get official cacti with pia integrated:
cd /tmp/
wget http://www.cacti.net/downloads/cacti-0. ... 3.1.tar.gz
tar xzfv cacti-0.8.7i-PIA-3.1.tar.gz
cd /cacti-0.8.7i-PIA-3.1/site
# Copy Files over existing Installation
rsync -avh * /usr/share/cacti/site/
cd /usr/share/cacti/site/
# Fix Permission
chown root:root -R *
# now go to /usr/share/cacti/site/include and get your config.php back
cd /usr/share/cacti/site/include
mv config.php config.php.oldorig
mv config.php.orig config.php

At this moment you should be able to connect to your cacti website again.
But you will have some path errors with the pollers.
To fix this, check your old global.php(from packet install) and compare it with the new one. (source) - take notepad++ open both files and "extension -> Compare"
i merged the paths and uploaded it again.

Code: Select all

include("/usr/share/php/adodb/adodb.inc.php");
was some different path for me

full file is attached.

global.php.txt

(8.08 KiB) Downloaded 135 times

if using the cmd poller - i can view the graphs. If using the spine poller im getting some sql errors when trying to view graphs:

Code: Select all

02/09/2012 01:26:37 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
02/09/2012 01:26:37 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id="
02/09/2012 01:26:33 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
02/09/2012 01:26:33 PM - CMDPHP: Poller[0] ERROR: SQL Row Failed!, Error:'1064', SQL:"select policy_trees from user_auth where id=" 
02/09/2012 01:26:37 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name"
02/09/2012 01:26:37 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1064', SQL:"select graph_tree.id, graph_tree.name, user_auth_perms.user_id from graph_tree left join user_auth_perms on (graph_tree.id=user_auth_perms.item_id and user_auth_perms.type=2 and user_auth_perms.user_id=) order by graph_tree.name" 

so, now im stuck - maybe someone can help me to fix this up. its maybe a problem cause i have not yet installed cacti-spine 0.8.7i ?

some additional question: are the paths stored in any other file, or sql table? My plugins are working, but using some wrong displaypath like:
http://Servername/cacti/plugins/mactrac ... w_macs.gif

best regards,
Chill

[gandalf]

You should not do that. Overwriting a package install will yield strange results sooner or later.
Recommendation is to save custom stuff, remove old install, install fresh and restore custom stuff
R.

[Chilloutfaktor]

mh yeah your right. if it is that easy i would like to do this. but how can i save my graphs & data ?
there is at the moment no real option to migrate or correctly export graph data - or?

[gandalf]

mh yeah your right. if it is that easy i would like to do this. but how can i save my graphs & data ?
there is at the moment no real option to migrate or correctly export graph data - or?

Sure, there is. I just responded to that in a similar thread.
What you should save is
- the ./rra ./scripts ./resources directories
- the mysql tables
That's it.
And there's a thread (I can't judge whether this is a good one) which may be of interested for Ubuntu users during install. I know, that Ubuntu install differs a bit from what we explain at 1st link of my sig
R.

[Chilloutfaktor]

wow - i didnt thought it is that easy. i've exported the old db and merget it using mysql workbench with my clean install.
then pushed rra files, ressource and scripts to new install.
fixed permissions and changed paths of "cacti_poller_item.sql" to new install paths. then fixing paths in cacti settings. and lets give it some time over weekend so i can see whats working.
but it seems very good.

thanks for the hint.