/* ** Copyright (C) 2001-2025 Zabbix SIA ** ** This program is free software: you can redistribute it and/or modify it under the terms of ** the GNU Affero General Public License as published by the Free Software Foundation, version 3. ** ** This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; ** without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. ** See the GNU Affero General Public License for more details. ** ** You should have received a copy of the GNU Affero General Public License along with this program. ** If not, see <https://www.gnu.org/licenses/>. **/ package mysql import ( "context" "net/http" "time" "github.com/omeid/go-yarn" "golang.zabbix.com/sdk/metric" "golang.zabbix.com/sdk/plugin" "golang.zabbix.com/sdk/uri" "golang.zabbix.com/sdk/zbxerr" ) const ( sqlExt = ".sql" pluginName = "Mysql" hkInterval = 10 ) // Plugin inherits plugin.Base and store plugin-specific data. type Plugin struct { plugin.Base connMgr *ConnManager options PluginOptions } // impl is the pointer to the plugin implementation. var impl Plugin // Export implements the Exporter interface. func (p *Plugin) Export(key string, rawParams []string, _ plugin.ContextProvider) (any, error) { params, extraParams, hc, err := metrics[key].EvalParams(rawParams, p.options.Sessions) if err != nil { return nil, zbxerr.ErrorInvalidParams.Wrap(err) } err = metric.SetDefaults(params, hc, p.options.Default) if err != nil { return nil, zbxerr.ErrorInvalidParams.Wrap(err) } uri, err := uri.NewWithCreds(params["URI"], params["User"], params["Password"], uriDefaults) if err != nil { return nil, zbxerr.ErrorInvalidParams.Wrap(err) } handleMetric := getHandlerFunc(key) if handleMetric == nil { return nil, zbxerr.ErrorUnsupportedMetric } conn, err := p.connMgr.GetConnection(*uri, params) if err != nil { // Special logic of processing connection errors should be used if mysql.ping is requested // because it must return pingFailed if any error occurred. if key == keyPing { return pingFailed, nil } p.Errf(err.Error()) return nil, zbxerr.ErrorConnectionFailed.Wrap(err) } result, err := handleMetric(context.Background(), conn, params, extraParams...) if err != nil { p.Errf(err.Error()) return nil, zbxerr.ErrorCannotFetchData.Wrap(err) } return result, nil } // Start implements the Runner interface and performs initialization when plugin is activated. func (p *Plugin) Start() { p.connMgr = NewConnManager( time.Duration(p.options.KeepAlive)*time.Second, time.Duration(p.options.Timeout)*time.Second, time.Duration(p.options.CallTimeout)*time.Second, hkInterval*time.Second, p.setCustomQuery(), p.Logger, ) } func (p *Plugin) setCustomQuery() yarn.Yarn { if p.options.CustomQueriesPath == "" { return yarn.NewFromMap(map[string]string{}) } queryStorage, err := yarn.New(http.Dir(p.options.CustomQueriesPath), "*"+sqlExt) if err != nil { p.Errf(err.Error()) // create empty storage if error occurred return yarn.NewFromMap(map[string]string{}) } return queryStorage } // Stop implements the Runner interface and frees resources when plugin is deactivated. func (p *Plugin) Stop() { p.connMgr.Destroy() p.connMgr = nil }