|
|
| Author |
Message |
nhi
Beginner
Joined: 30 Mar 2005
Posts: 2
|
 Posted: Wed Mar 30, 2005 11:23 pm Post subject: SQL:How to query different databases than netmrgs ? |
 |
|
Hi,
I just installed netmrg today, and I want to fire up some queries on our mysql database and make graphs from it. but it seems I cannot set the database name when creating an sql script ? Then I tried it with creating a script, with mysql cmd which the result is a number, but the graph shows nothing. Can someone hint me to the right direction ?
I use a linux box.
Also the traffic graph is empty , I used the template for that and set the interface to our eth device...any maybe comon newbie problem I have encountered ?
ill be glad to provide more info if needed.
thx lot !
Chris |
|
| Back to top |
|
 |
nhi
Beginner
Joined: 30 Mar 2005
Posts: 2
|
| Posted: Wed Mar 30, 2005 11:30 pm Post subject: |
|
|
| oh ok, I ran the gatherscript with -am (just found that info hehe) and I had to addp athes to my script. but still is there not a more elegant way ?[/quote] |
|
| Back to top |
|
|
keb
Contributor
Joined: 09 Jul 2003
Posts: 44
Location: Camp Hill, PA, USA
|
| Posted: Thu Mar 31, 2005 5:50 am Post subject: |
|
|
You should be able to setup a MySQL test under Tests -> SQL. There you can specify the host, user, passwd, etc. to obtain the information you want to graph. You can set it up to use parameters instead of hard-coded values, and then specify those params in the sub-device.
-Kevin |
|
| Back to top |
|
|
|
