[Solved] Syslog missing dependency for settings plugin.

[axcx]

Hey everyone

I just started setting up this plugin, and I think I am really close to get it working except I get this error when I go to the "Syslogs" tab.

"You are missing a dependency for Syslog, please install the 'Settings' plugin."

I do have the 'settings' plugin installed, version 0.7, it was one of the first plugins I installed together with PIA to get Thold to work.

I can see that the syslog database is working correct and messages are being stored in the syslog_incoming table.

mysql> select * from syslog_incoming;

syslog | notice | 2011-10-19 | 09:02:18 | cacti server | syslog-ng[21419]: syslog-ng starting up; version='2.1.4'

This is a test from one of my UPS's.
kern | alert | 2011-10-19 | 15:04:24 | UPS IP | APC: Test Syslog.

Can anyone help pointing me in the right direction to get this resolved?

Thanks in advance,
Jakob

[TheWitness]

Upgrade to settings 0.71 and then uninstall/reinstall settings 0.71, and the problem be fixed.

TheWitness

[axcx]

Sorry, this was my own fault. I was using a way old version of syslog....

It is working now except there is something terrible wrong with my database setup.

The data is logged, but somehow syslog is not reading it correct. Any ideas welcome.

Critical:
Cacti[15722]: CMDPHP: ERROR: SQL Cell Failed!, Error:'1064', SQL:"SELECT hex FROM colors WHERE id="

Info:
syslog-ng[21419]: Log statistics; dropped='pipe(/tmp/mysql.pipe)=0', processed='center(queued)=40', processed='center(received)=21', processed='destination(d_boot)=0', processed='destination(d_auth)=0', processed='destination(d_cron)=15', processed='destination(d_mysql)=21', processed='destination(d_mlal)=0', processed='destination(d_kernel)=0', processed='destination(d_mesg)=4', processed='destination(d_cons)=0', processed='destination(d_spol)=0', processed='destination(d_mail)=0', processed='source(s_sys)=20', processed='source(net)=1', suppressed='pipe(/tmp/mysql.pipe)=0' | 23 |

[TheWitness]

I forgot about this old bug. Goto Console->Settings->Syslog and press the save button. Problems in the Cacti Log will disappear.

TheWitness

[axcx]

Thanks for the help, it seems to be working okay now.

I have one last questions, I hope you can help me with.

In the "Select Host" section of the syslog page the hosts show up as IP addresses. Is it possible to change that to show the hostname instead?

It works for localhost, but the UPS I have setup to send off syslog messages to my linux box shows up as the IP.

Changing Subject to solved. Original problem is solved.


Thanks in advance,
Jakob

[TheWitness]

Configure your rsyslog, or syslog-ng to do this.

[axcx]

Thank you so much for taking time to reply to all this. I will look at the documentation how to do this for syslog-ng.

Cheers,
Jakob