Move to new OS -> No Datasources but running [SOLVED]

[web_rene]

Hi there,

I have a Problem after having moved a running Version of Cacti from a Centos to a Gentoo machine.
Since the Pathes changed, I have also changed them in the Mysqldump and everything is working fine.

The funny thing is, that if I select any created Graph (tried old and new ones) I don't see any single Datasource in the Dropdown menue. It only says "none".

Can someone tell me, where Cacti retrieves the values for this Dropdown Menu? I checked Pathes / Accessrights to the Database etc. Everything looks fine to me. Right now I have both it Running on the Old Centos and the new Gentoo machine. This is the only difference.

Cacti Version - 0.8.6j
Plugin Architecture - 1.1
Poller Type - CMD.php
Server Info - Linux 2.6.19-gentoo-r5-BackEnd-Build
Web Server - Apache
PHP - 5.2.4_p20070914-pl2-gentoo
PHP Extensions - libxml, xml, session, pcre, SimpleXML, sockets, snmp, SPL, standard, Reflection, mysql, mcrypt, mbstring, iconv, gettext, dom, date, zlib, openssl, apache2handler
MySQL - 5.0.44-log
RRDTool - 1.2.23
SNMP - 5.4
Plugins

• Host Info (hostinfo - v0.1)
  Device Monitoring (monitor - v0.7)
  SQL Queries (sqlqueries - v0.1)
  rrdclean (RRD Cleaner - v1.2 (Hack Gilles Boulon))
  Network Tools (tools - v0.2)
  Update Checker (update - v0.3)
  Uptime (uptime - v0.3)

[web_rene]

No one??

Please just tell me someone where Cacti gets its Datasource-Pulldowns from, it shows when I open the properties of an existing Graph!

[rony]

I'm concerned that something in you database move didn't get copied correctly.

There are a few tables the data is pulled from. Did you install all the same plugins on the new system that you had on the old system? Did you install any extra plugins?

[web_rene]

Hi and thanks for your reply.
Actually I made a 1-to-1 Copy of the whole Cactipath but to another locacation.
(Used to be /var/www/html/... , Is now /var/www/localhost/...)

I changed all the Configuration values to the new location and also changed all paths in the Database.

Nevertheless it still doesn't work. The Funny thing is, that everything else works somehow.

[gandalf]

Please read the second link of my signature to find more details
Reinhard

[web_rene]

Hi and thanks for your reply.
I checked everything mentioned in your second link but didn't find any problems.

I guess I will have to go into source....

[web_rene]

Ok, one step further:

It seems to be a Problem with the new Database. I Debugged the php-files and finally reached the Querys that are executed for getting the values.

The query is:

Code: Select all

select CONCAT_WS('', case when host.description is null then 'No Host - ' when host.description is not null then '' end,data_template_data.name_cache,' (',data_template_rrd.data_source_name,')') as name, data_template_rrd.id from (data_template_data,data_template_rrd,data_local) left join host on (data_local.host_id=host.id) where data_template_rrd.local_data_id=data_local.id and data_template_data.local_data_id=data_local.id and data_local.host_id=38 order by name

On the Old cacti Database it runs without Problems and shows me all the Datasources.
On the new Database it shows me an errormessage:

Code: Select all

ERROR 1271 (HY000): Illegal mix of collations for operation 'concat_ws'

If I change the statement, leaving the case-statement (just concat_ws('','',...) ), it also works on the new Database.

Any ideas?

DB Version New is 5.0.44
DB Version Old is 5.0.18
[/code]

[web_rene]

...one step further:

I can execute the query now manually. The characterset of the database was different than the characterset of the tables.

Anyways, it doesn't work using the Webgui.

I proceed with my search.

[web_rene]

Ok,

sorry for bothering you.
Now, since I found the source of the Problem, I also found the solution here in the Forum:

http://forums.cacti.net/viewtopic.php?t=13474