-
MySQL Plugin error
I just want to monitor my external MySQL database.
I finally managed to add it as an agent. Now i’ve downloaded a MySQL plugin, there’s no information about it whatsoeverhttp://pandorafms.org/index.php?sec=community&sec2=repository&lng=es&action=view_PUI&id_PUI=94
When i try to upload it to the server (i don’t know where but i tried 2 different places) i get this error “CANNOT LOAD INI FILE”
I tried to upload it here:
Manage Servers -> Register Plug-in
Extentions -> Extension UploaBoth doesn’t work.
Then i went to the “documentation”
http://www.openideas.info/wiki/index.php?title=Pandora_3.0:Documentation_en:Operations#Example_.231:_Plugin_Module_for_MySQLNo shit. I managed to create the plugin module (Administration -> Manage servers -> Manage plugin )
but then suddenly i need to “Create a module in the system agent where Pandora FMS is installed and assign it;” Where the hack can i do that?? The screenshot looks like “Administration -> manage agents -> select agent -> modules -> create new” But i can’t select “Generic module to aquire n…” and i can’t fill in any target IP or plugin ….
How the hell can i create a [****]ing graph showing me the usage of the MySQL database? (queries, rows etc.)
Damn this is way to complicated
-
3 Replies
-
Greetings,
I’ve got a couple of wild guesses about what is happening… let’s get these facts straight:
– The module type you’re looking for is “Generic numeric”
– You need to create a plug-in server module
– Make sure you don’t have a syntax error in the path when you uploaded the plug-in.
– Also make sure you wrote the right host, username and password.
– NOTE: If in the external MySQL database machine the Pandora Server IP isn’t allowed to check the database, this plugin won’t work! Make sure to check all your conf files carefully.
Otherwise, the module will not initialise.
If your problem persists, please be kind enough to provide us additional data and screenshots of your problem, so we can help you better.
-
this is what i mean…
When i try to upload it to the server (i don’t know where but i tried 2 different places) i get this error “CANNOT LOAD INI FILE”
I tried to upload it here:
Manage Servers -> Register Plug-in
Extentions -> Extension UploaBoth doesn’t work.
How can i solve that? When i can install that MySQL plugin i can assign them to my MySQL agent and read out the values, right?
-
Of course, but you need to understand that server plugins are executed from the server, no matter if you assigned the module to the MySQL agent… so the host option needs to include the external MySQL IP, not localhost if that is what you were writing.
Plugin agents are the ones located and executed from the agent software.
Plugin servers are executed from the Pandora server, despite modules using this plugin can be assigned to all kind of agents. The script file must be located in the Pandora Server machine in this case.
About the .pspz, it is true there’s a problem with the .ini file… we’re working on it right now.
However, the other configuration you tried should work… at least it is working for me right now (I’m testing the plugin)
