SQL Select Errors in Fresh 87g install

[gandalf]

I was going to ask this.
But I'm running 087g fine on F12/64 bit. So I suppose it's not only the 64bit thingy.
R.

[gandalf]

This seems to be a problem with the PIA.

How come? On a pure cacti install, without PIA, do you get the same error?
When using PIA, you know that you have to copy config.php.dist to config.php and apply the required database settings and url_path?

If problem still applies:
If you have an old 087e install at hand, please replace ./lib/adodb of 087g by the code from 087e and retry.

Please post results.
R.

[TheWitness]

This is a PHP issue. You can aleviate if you simply back off the lib/database.php to the 0.8.7e version of that file.

However, tools like syslog v1.04 will not work properly if the syslog database is maintained separately from the Cacti database.

TheWitness

[phreakocious]

Thanks for getting back on this... I am going to try your solution, as I'm not using the syslog plugin.

[dononeil]

This is a PHP issue. You can aleviate if you simply back off the lib/database.php to the 0.8.7e version of that file.

However, tools like syslog v1.04 will not work properly if the syslog database is maintained separately from the Cacti database.

TheWitness

Which version od PHP does not have this issue? Is it an issue with a new verision of PHP where we need to roll back to an older one, or vice versa?

I haven't had a chance to try the fresh install yet, but I will post results once I do.

[TheWitness]

We are not sure the versions yet as we have not identified the specific issue other than to know it has to do with assigning a class to a variable and only affects some versions of PHP. I have seen it in 5.2.1 for sure. Not sure if it affects all builds.

TheWitness

[dononeil]

We are not sure the versions yet as we have not identified the specific issue other than to know it has to do with assigning a class to a variable and only affects some versions of PHP. I have seen it in 5.2.1 for sure. Not sure if it affects all builds.

I was never able to ger 87e to work either, same problem. I figured it was something with 87e so I just waited until f/g came out.

What version of PHP are you running? What extensions/patches? Since my machine is basically a scratch machine, maybe I can try re-creating the issue with different versions of PHP.

[TheWitness]

I can't reproduce the problem. If you want to try, that would be good. My version varies.

Works fine on Debian Lenny:

PHP 5.3.2-1 with Suhosin-Patch (cli) (built: Mar 14 2010 01:11:12)
Copyright (c) 1997-2009 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies


Works fine on Windows:

PHP 5.2.13 (cli) (built: Feb 24 2010 14:32:32)
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2010 Zend Technologies

[alexfossa]

Any idea how to solve this. I've got the same issue on a fresh install of Centos with Cacti.

Thanks,

Alex

[TheWitness]

As mentioned else where install lib/database.php from the 0.8.7e version of Cacti. Also, please PM Gandalf as he has a new version of that file ready for others to test.

TheWitness

[dononeil]

As mentioned else where install lib/database.php from the 0.8.7e version of Cacti.

I doubt this is going to solve my problem as I was never able to get 87e to work either... the same problem.

You're running a newer version of PHP, I think that may be the key. There are quite a few differences between 5.1 and 5.2/5.3. I'm going to try to test upgrading PHP today.

[gandalf]

Posted lib/database.php on request.
R.

[dononeil]

Ok... I tried out the lib, now the SQL errors are gone and things seem to be working much better...

However, now I'm seeing this:

07/27/2010 11:20:01 AM - SPINE: Poller[0] NOTE: Spine did not detect multithreaded device polling.

What does that mean?

I'm also not seeing most of the graphs get updated when running with Boost (some do, some don't, most stay red X's) and the realtime plugin is still just showing a red X when it's run, even on a graph that is updating.

I only have one device defined, the local linux host, and am using the local linux template.

[gandalf]

I recommend doing this one at a time.
So for now, we first know that the SQL errors have been fixed.
As to the threading, Larry has to drop in. I'm not (yet) familiar with that option.
Then I recommend deactivating those plugins until you're satisfied. Then enable them one by one and retry. You may have to post errors to those plugin's forum threads.
R.

[TheWitness]

It's a new 'not-so-advertised' feature that allows you to take a host and poll it with multiple threads. This is a requirement for some 'real big' systems.

It is a part of 0.8.7g spine, but the UI component is not there until 0.8.8 (at least for most customers).

TheWitness