unable to create new host at cacti

[cenil]

Hai,

Please help,

I'm running 0.8.6j on SunOS 5.10
Apache 2.2.4
MySql 5.0.41
PHP 5.2.3
OpenSSL/0.9.8e DAV/2

All of the existing devices in my cacti work fine but I'm unable to create new devices and graphs for new devices. I can save the device successfull but itsn't show up in the list of devices. This problem appears after the server rebooting by unknown person. The rrd file of the interface was created on rra.

Any suggestions or ideas?
Thanks

[gandalf]

Please have a look at the header line of the host list display. Does the number displayed match the number of hosts entered?
Reinhard

[foo]

Are you running boost? If so, disable it (remove from global.php), then let Cacti make one run, then you can re-enable boost.

There's a bug with boost right now using 8.7.0. Boost won't create new graphs, but it will update already existing ones.

[cenil]

Please have a look at the header line of the host list display. Does the number displayed match the number of hosts entered?
Reinhard

Dear Reinhard,

Showing Rows 1 to 30 of 162 [1,2,3,4,5,6] , the last host list displayed 162 devices, and i tried to create the new one, it must be 163 devices. But when i save succesfull the new device i've added, the host list displayed still 162 devices. Any idea ?

Thanks,

Dewi

[TheWitness]

Are you running boost? If so, disable it (remove from global.php), then let Cacti make one run, then you can re-enable boost.

There's a bug with boost right now using 8.7.0. Boost won't create new graphs, but it will update already existing ones.

Foo,

What error messages are you getting related to boost?

TheWitness

[cenil]

Please have a look at the header line of the host list display. Does the number displayed match the number of hosts entered?
Reinhard

Below the error message in mysql log ( more /var/mysql/servername.err ) :


071112 10:29:30 mysqld started
071112 10:29:33 InnoDB: Started
/usr/sfw/sbin/mysqld: ready for connections.
Version: '4.0.15-log' socket: '/tmp/mysql.sock' port: 3306
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.

key_buffer_size=16777216
read_buffer_size=131072
max_used_connections=0
max_connections=100
threads_connected=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 80383 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

-e
Number of processes running now: 0
071112 10:32:04 mysqld restarted
071112 10:32:04 InnoDB: Started
/usr/sfw/sbin/mysqld: ready for connections.
Version: '4.0.15-log' socket: '/tmp/mysql.sock' port: 3306
A mysqld process already exists at Mon Nov 12 10:32:49 WIT 2007
A mysqld process already exists at Mon Nov 12 10:32:58 WIT 2007

----

What does it mean ?

[cenil]

Are you running boost? If so, disable it (remove from global.php), then let Cacti make one run, then you can re-enable boost.

There's a bug with boost right now using 8.7.0. Boost won't create new graphs, but it will update already existing ones.

what do you mean 'boost' ?

[TheWitness]

Sorry, cross post from foo. I was asking him.

TheWitness

[cenil]

Sorry, cross post from foo. I was asking him.

TheWitness

Any idea ?

[TheWitness]

Please 1) Repair your database 2) Make sure that the sql_mode is unset.

TheWitness

mysql cacti
> show global variables;
> quit;

[foo]

Are you running boost? If so, disable it (remove from global.php), then let Cacti make one run, then you can re-enable boost.

There's a bug with boost right now using 8.7.0. Boost won't create new graphs, but it will update already existing ones.

Foo,

What error messages are you getting related to boost?

TheWitness

I'm running 1.5 right now, since it's the only stable one. (that I've come across). I never had any boost related issues pre-0.8.7, by the way.

* Boost 1.7: rcaston database error. You're already aware of this from other users. Won't waste your time with details.
* Boost 1.6: boost_server.php stops responding roughly every 2-3 hours. It would still graph, but the caching side of it would stop working. Restart boost, and all the graphs would display again, completely up to date. Errors in boost log complaining about 'client disconnected early' (I forget the actual quote).
* Boost 1.5: Boost still dies like above, but everything else works flawlessly, minus creation of graphs. No errors in logs. If you add a new host, boost won't do the initial graph creation. Disable boost in global.php, let Cacti create the graph, then enable boost and it's fine.

Again, note none of the above issues were present pre Cacti 0.8.7.

I've tried upgrading rrdtool, no change.

Details:
FreeBSD 6.1
PHP 4.4.4
rrdtool: 1.2.23

[TheWitness]

Using boost server?

TheWitness

[cenil]

Please 1) Repair your database 2) Make sure that the sql_mode is unset.

TheWitness

mysql cacti
> show global variables;
> quit;

It's work !!! Thank you so much.
My cacti can add new host again after repair database.

Dewi

[foo]

Using boost server?

TheWitness

Yes, using the boost server. I've tried disabling the server, caching, and all combinations in between. No luck.

[TheWitness]

Using boost server?

TheWitness

Yes, using the boost server. I've tried disabling the server, caching, and all combinations in between. No luck.

I might release 1.8 this weekend. Found a major bug in 1.6/1.7 but I need more testing.

TheWitness