bad day with an upgrade

[pippoppo]

Hi,
I don't know yet which software piece broke my fitb installation: I migrated from a 32bit lenny to a 64 bit squeeze.
I didn't want to migrate all my RRDS, so I cleaned both the filesystem and the db.
When I launched again the poller, all the RRDS where created again, but no db record.

So I tcpdumped and found the problem: a double quotation mark, like this
INSERT INTO ports (host, name, safename, filename, alias, graphtype, lastpoll) VALUES ("mycore", ""GigabitEthernet3/0/26"", "GigabitEthernet3-0-26", "mycore-GigabitEthernet3-0-26_bits.rrd", "uplink 9-3", "bits", "1358200980");

the double quotation mark is due to this snmp record:
SNMPv2-SMI::mib-2.47.1.1.1.1.2.3032 = STRING: "GigabitEthernet3/0/26"

So I had to modify the code in poller_child.php line 116, here:
new: VALUES ("'.$pollprettyhost.'", "'.$intname.'", .....

old: VALUES ("'.$pollprettyhost.'", "'.$thisint[2].'", .....

using your previously prettyfied $intname.

Submitting an issue here in order to help somebody else having my same problem.

Thanks.

[lozzd]

Hm, that's not good. I should be sanitising that. Will take a look and fix.