spine rev 5705 "Table 'cacti.host' doesn't exist"

ruff · **Posted:** Mon Mar 22, 2010 4:43 am

Hi there,

Seems host was renamed to device, but still referenced as host in two lines of spine.c
Following diff shows and fixes it

Code:

ruff@toolbox ~/spine $ svn diff spine.c
Index: spine.c
===================================================================
--- spine.c     (revision 5705)
+++ spine.c     (working copy)
@@ -463,9 +463,9 @@

        /* obtain the list of hosts to poll */
        if (set.device_threads_exists) {
-               qp += sprintf(qp, "SELECT id, device_threads FROM host");
+               qp += sprintf(qp, "SELECT id, device_threads FROM device");
        }else{
-               qp += sprintf(qp, "SELECT id, '1' as device_threads FROM host");
+               qp += sprintf(qp, "SELECT id, '1' as device_threads FROM device");
        }
        qp += sprintf(qp, " WHERE disabled=''");
        if (!strlen(set.device_id_list)) {

TheWitness · **Posted:** Mon Mar 22, 2010 4:55 am

Thanks. Fixed.

kr0n0s · **Joined:** Sun May 09, 2010 5:22 pm **Posts:** 4

Is this problem still existing in the current 0.8.7f svn checkout?
I just upgraded my cacti installation and db to the current 0.8.7 from svn, then compiled spine, but it always gives me errors upon execution.

Code:

Message:'Unknown column 'host_id

or

Code:

table .host doesn't exist

Are there any other patches to spine.c?

TheWitness · **Posted:** Sun May 09, 2010 6:40 pm

You checked out main I would think.

TheWitness · **Posted:** Sun May 09, 2010 6:41 pm

You have to be at 0.8.7f of cacti to run the current spine. It is not compatible with earlier versions of Cacti.

kr0n0s · **Joined:** Sun May 09, 2010 5:22 pm **Posts:** 4

after my upgrade to ubuntu 10.04 cacti gave me ugly errors due to some changes in php5:

Code:

Deprecated: Function ereg_replace() is deprecated

I checked out the complete svn

Code:

svn checkout svn://svn.cacti.net/cacti .

then I compiled spine from branches/0.8.7 which is 0.87f.
and copied the contents of cacti/branches/0.8.7 to my webserver dir. it's also 0.87f.
cacti updates my database to the new version and everything looks fine, but the freshly compiled spine can't seem to work with it, because spine.c still contains references to the .host table and cacti changed the.host table to the .device table during the upgrade of the database.
everything else looks fine.

TheWitness · **Posted:** Sun May 09, 2010 7:49 pm

devices table is main and is 088, which is quite a bit out yet. It's not even alpha yet.

TheWitness

kr0n0s · **Joined:** Sun May 09, 2010 5:22 pm **Posts:** 4

Thanks for the information.
I experimented with 0.8.8 before but it didnt work. So I reverted to 0.8.7 and chose 'new install' from database installation options. But this didnt drop the existing tables. And therefore the database was messed up. I manually deleted the tables and imported cacti.sql.
Now it works fine.

Thanks for the help.

spine rev 5705 "Table 'cacti.host' doesn't exist"

Who is online