cacti 0.8.7e to 0.8.7g upgrade - 'new database' error

[TheWitness]

Need the cacti.log to figure this one out.

[wzzrd]

Same problem with upgrading from 0.8.7e to 0.8.7g on a RHEL4 box.

I'm a bit new to cacti, but this code below in auth.php seems to trigger the install page showing up. The install page only mentions running an sql file to *create a database*, and didn't seem to provide a way to update it. That said, I already downgraded to 0.8.7e again, so I can't really test this anymore.

Code: Select all

/* check to see if this is a new installation */
if (db_fetch_cell("select cacti from version") != $config["cacti_version"]) {
    header ("Location: install/");
    exit;   
}

[cluckduck]

[I'm the OP]

Yeah, I'm running Red Hat AS4 update 8, so (I forget the exact versions) but I'm on PHP 4.x.

I've since gone back to 087e as well. I'm about to go on holidays but if this still isn't sorted in a few weeks I'll try to post some useful info about package versions etc.

I don't recall seeing anything obvious come up in cacti.log when 087g was active.

cheers.

[TheWitness]

I'm running 087g fine on CentOS4.8 BTW. It was a new install however. So, it has something to do with process. I wish you the best of luck. Enjoy your time off first though.

TheWitness

[remsad]

I upgraded Centos 4 with Php5 and 0.8.7g works for now.

[TheWitness]

Yea, I forgot to mention that I'm using CentOS plus which includes PHP5.1.6 and MySQL5.0.x

TheWitness

[Deviloper]

I guess from the information provided here, that cacti 0.8.7g might have an compatibility issue using old releases of MySQL. I would recommend 5.1.43 or better, especially if you are working with boost and memory-tables.

my experience are that early 5.0 MySQL Community-Server has big issues (with memory tables and a lot of other things).

[gandalf]

Need the cacti.log to figure this one out.

I second that request. Without it (and perhaps an httpd's error_log) we won't get any further.
R.

[TheWitness]

I'm confused. If you can not connect, this is not a Cacti issue. More than likely it's a MySQL or a PHP issue. I guess I'm confused. Need more information to help you with your problem.

TheWitness

[jmoseley]

I'm running into the same issue on a RHEL/CentOS 3.x box. Unfortunately, the logs don't contain any errors to help debug.

PHP version: 4.3.2
mysql version: 3.23.58
Net-SMMP: 5.0.9

These are latest versions available via the standard yum repos and worked fine with 0.8.7e.

Not expecting a fix, but just wanted to let folks know that upgrading Cacti on RHEL 3.x will break if using yum packages from the standard RHEL/CentOS repos.

[TheWitness]

Try the latest lib/database.php in our SVN. This might bring joy. I'm working with Tony to get another batch of patches out this weekend that should fix the remaining version issues related to PHP.

TheWitness

[jmoseley]

Thanks.

[jmoseley]

Try the latest lib/database.php in our SVN. This might bring joy. I'm working with Tony to get another batch of patches out this weekend that should fix the remaining version issues related to PHP.

TheWitness

Were the PHP patches released? I see two more patches listed on the patches page than were available a month ago, but nothing that stands out as PHP fixes.

Thanks.

[each]

Looks like it was wrapped up in the polling interval patch. I was experiencing the same issue and installing all the available patches worked for me.

[TheWitness]

Looks like Tony did not get the latest patches out. You need, from SVN branches/0.8.7/lib/database.php and branches/0.8.7/poller.php from the root path.

TheWitness