lmt data not reaching mysql backend

25 views
Skip to first unread message

Dave Merhar

unread,
Oct 26, 2010, 2:08:27 PM10/26/10
to lmt-d...@googlegroups.com
lmt-2.6.4
cerebro-1.10

For now 3 servers. 1 MDS, 1 OSS, and an lmt/cerebro server

Here's what I've seen:

"cerebro-stat -m lmt_ost" shows expected data from all boxes.

wireshark shows the lmt data moving from OSS to lmt/cerebro server.
(though not multicast.)

"ldd cerebro_monitor_lmt.so" shows libmysqlclient

debugging mysql shows queries during table build, restarting cerebro,
and running ltop, but nothing corresponding to arrival of lmt data.


Some kluges:
our servers have dashes in their names which confused create_lmconfig.
I manully added the names to the lc1.sql after running the script.

installing the lmt-server rpm balked on DATE::MANIP dependency. I
confirmed the latest was installed. (But we do only have perl 5.8
installed.) I "nodep'ed" the rpm on to the box.


djm

Jim Garlick

unread,
Oct 26, 2010, 2:43:28 PM10/26/10
to lmt-d...@googlegroups.com
Hi Dave,

First thing that comes to mind is can the cerebro monitor module
authenticate for write access (select,insert,delete) to the database?
I think you would be seeing a complaint in syslog if not but I am not sure.
It uses /usr/share/lmt/cron/lmtrc for this, while ltop uses
/usr/share/lmt/etc/lmtrc.

Jim

> --
> You received this message because you are subscribed to the Google Groups "lmt-discuss" group.
> To post to this group, send email to lmt-d...@googlegroups.com.
> To unsubscribe from this group, send email to lmt-discuss...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/lmt-discuss?hl=en.
>

Dave Merhar

unread,
Oct 26, 2010, 2:48:46 PM10/26/10
to lmt-d...@googlegroups.com
So I should be able to add an entry to the table using the lwatchadmin user?

djm

Jim Garlick

unread,
Oct 26, 2010, 2:50:41 PM10/26/10
to lmt-d...@googlegroups.com
On Tue, Oct 26, 2010 at 11:48:46AM -0700, Dave Merhar wrote:
> So I should be able to add an entry to the table using the lwatchadmin user?

Yes.

Jim

Dave Merhar

unread,
Oct 26, 2010, 4:02:28 PM10/26/10
to lmt-d...@googlegroups.com
No problem inserting/deleting data to TIMESTAMP_INFO and OST_DATA tables.

djm

Reply all
Reply to author
Forward
0 new messages