1
1
/* -*- mode: c++; c-basic-offset: 2; indent-tabs-mode: nil; -*-
2
2
* vim:expandtab:shiftwidth=2:tabstop=2:smarttab:
4
* Copyright (C) 2008, 2009 Sun Microsystems, Inc.
4
* Copyright (C) 2008,2009 Sun Microsystems
6
6
* This program is free software; you can redistribute it and/or modify
7
7
* it under the terms of the GNU General Public License as published by
24
24
#include <drizzled/plugin/logging.h>
25
25
#include <drizzled/gettext.h>
26
26
#include <drizzled/session.h>
27
#include <drizzled/errmsg_print.h>
28
27
#include <boost/date_time.hpp>
29
28
#include <boost/program_options.hpp>
30
29
#include <drizzled/module/option_map.h>
41
namespace drizzle_plugin
39
using namespace drizzled;
44
40
namespace po= boost::program_options;
46
42
/* TODO make this dynamic as needed */
47
43
static const int MAX_MSG_LEN= 32*1024;
45
static bool sysvar_logging_gearman_enable;
46
static char* sysvar_logging_gearman_host= NULL;
47
static char* sysvar_logging_gearman_function= NULL;
49
49
/* quote a string to be safe to include in a CSV line
50
50
that means backslash quoting all commas, doublequotes, backslashes,
51
51
and all the ASCII unprintable characters
157
class LoggingGearman :
158
public drizzled::plugin::Logging
157
class LoggingGearman : public plugin::Logging
161
const std::string _host;
162
const std::string _function;
164
int _gearman_client_ok;
165
gearman_client_st _gearman_client;
168
LoggingGearman(const LoggingGearman&);
160
int gearman_client_ok;
161
gearman_client_st gearman_client;
172
LoggingGearman(const std::string &host,
173
const std::string &function) :
174
drizzled::plugin::Logging("LoggingGearman"),
177
_gearman_client_ok(0),
166
: plugin::Logging("LoggingGearman"),
180
169
gearman_return_t ret;
183
if (gearman_client_create(&_gearman_client) == NULL)
171
if (sysvar_logging_gearman_enable == false)
174
if (sysvar_logging_gearman_host == NULL)
178
if (gearman_client_create(&gearman_client) == NULL)
185
drizzled::sql_perror(_("fail gearman_client_create()"));
180
char errmsg[STRERROR_MAX];
181
strerror_r(errno, errmsg, sizeof(errmsg));
182
errmsg_printf(ERRMSG_LVL_ERROR, _("fail gearman_client_create(): %s"),
189
187
/* TODO, be able to override the port */
190
188
/* TODO, be able send to multiple servers */
191
ret= gearman_client_add_server(&_gearman_client,
189
ret= gearman_client_add_server(&gearman_client,
190
sysvar_logging_gearman_host, 0);
193
191
if (ret != GEARMAN_SUCCESS)
195
drizzled::errmsg_printf(drizzled::error::ERROR, _("fail gearman_client_add_server(): %s"),
196
gearman_client_error(&_gearman_client));
193
errmsg_printf(ERRMSG_LVL_ERROR, _("fail gearman_client_add_server(): %s"),
194
gearman_client_error(&gearman_client));
200
_gearman_client_ok= 1;
198
gearman_client_ok= 1;
204
202
~LoggingGearman()
206
if (_gearman_client_ok)
204
if (gearman_client_ok)
208
gearman_client_free(&_gearman_client);
206
gearman_client_free(&gearman_client);
212
virtual bool post(drizzled::Session *session)
210
virtual bool post(Session *session)
214
212
boost::scoped_array<char> msgbuf(new char[MAX_MSG_LEN]);
215
213
int msgbuf_len= 0;
220
218
but that crashes the server, so for now, we just lie a little bit
223
if (not _gearman_client_ok)
221
if (!gearman_client_ok)
227
TODO, the session object should have a "utime command completed"
228
inside itself, so be more accurate, and so this doesnt have to
229
keep calling current_utime, which can be slow.
231
uint64_t t_mark= session->getCurrentTimestamp(false);
224
/* TODO, the session object should have a "utime command completed"
225
inside itself, so be more accurate, and so this doesnt have to
226
keep calling current_utime, which can be slow */
228
boost::posix_time::ptime mytime(boost::posix_time::microsec_clock::local_time());
229
boost::posix_time::ptime epoch(boost::gregorian::date(1970,1,1));
230
uint64_t t_mark= (mytime-epoch).total_microseconds();
234
233
// buffer to quotify the query
235
234
unsigned char qs[255];
237
236
// to avoid trying to printf %s something that is potentially NULL
238
drizzled::util::string::const_shared_ptr dbs(session->schema());
237
const char *dbs= session->db.empty() ? "" : session->db.c_str();
241
240
snprintf(msgbuf.get(), MAX_MSG_LEN,
246
245
session->thread_id,
247
246
session->getQueryId(),
248
247
// dont need to quote the db name, always CSV safe
249
(int)dbs->size(), dbs->c_str(),
248
(int)session->getSchema().length(), dbs,
250
249
// do need to quote the query
251
250
quotify((const unsigned char *)session->getQueryString()->c_str(), session->getQueryString()->length(), qs, sizeof(qs)),
252
// getCommandName is defined in drizzled/sql_parse.h dont
253
// need to quote the command name, always CSV safe
254
(int)drizzled::getCommandName(session->command).size(),
255
drizzled::getCommandName(session->command).c_str(),
251
// command_name is defined in drizzled/sql_parse.cc
252
// dont need to quote the command name, always CSV safe
253
(int)command_name[session->command].length,
254
command_name[session->command].str,
256
255
// counters are at end, to make it easier to add more
257
256
(t_mark - session->getConnectMicroseconds()),
258
(session->getElapsedTime()),
257
(t_mark - session->start_utime),
259
258
(t_mark - session->utime_after_lock),
260
259
session->sent_row_count,
261
260
session->examined_row_count,
262
261
session->tmp_table,
263
262
session->total_warn_count,
264
263
session->getServerId(),
265
drizzled::glob_hostname
268
267
char job_handle[GEARMAN_JOB_HANDLE_SIZE];
270
(void) gearman_client_do_background(&_gearman_client,
269
(void) gearman_client_do_background(&gearman_client,
270
sysvar_logging_gearman_function,
273
272
(void *) msgbuf.get(),
274
273
(size_t) msgbuf_len,
281
280
static LoggingGearman *handler= NULL;
283
static int logging_gearman_plugin_init(drizzled::module::Context &context)
282
static int logging_gearman_plugin_init(module::Context &context)
285
const drizzled::module::option_map &vm= context.getOptions();
287
handler= new LoggingGearman(vm["host"].as<std::string>(),
288
vm["function"].as<std::string>());
284
handler= new LoggingGearman();
289
285
context.add(handler);
290
context.registerVariable(new drizzled::sys_var_const_string_val("host", vm["host"].as<std::string>()));
291
context.registerVariable(new drizzled::sys_var_const_string_val("function", vm["function"].as<std::string>()));
296
290
static void init_options(drizzled::module::option_context &context)
299
po::value<std::string>()->default_value("localhost"),
300
_("Hostname for logging to a Gearman server"));
302
po::value<std::string>()->default_value("drizzlelog"),
303
_("Gearman Function to send logging to"));
293
po::value<bool>(&sysvar_logging_gearman_enable)->default_value(false)->zero_tokens(),
294
N_("Enable logging to a gearman server"));
306
} /* namespace drizzle_plugin */
297
static DRIZZLE_SYSVAR_BOOL(
299
sysvar_logging_gearman_enable,
301
N_("Enable logging to a gearman server"),
302
NULL, /* check func */
303
NULL, /* update func */
304
false /* default */);
306
static DRIZZLE_SYSVAR_STR(
308
sysvar_logging_gearman_host,
310
N_("Hostname for logging to a Gearman server"),
311
NULL, /* check func */
312
NULL, /* update func*/
313
"localhost" /* default */);
315
static DRIZZLE_SYSVAR_STR(
317
sysvar_logging_gearman_function,
319
N_("Gearman Function to send logging to"),
320
NULL, /* check func */
321
NULL, /* update func*/
322
"drizzlelog" /* default */);
324
static drizzle_sys_var* logging_gearman_system_variables[]= {
325
DRIZZLE_SYSVAR(enable),
326
DRIZZLE_SYSVAR(host),
327
DRIZZLE_SYSVAR(function),
308
331
DRIZZLE_DECLARE_PLUGIN
313
336
"Mark Atwood <mark@fallenpegasus.com>",
314
337
N_("Log queries to a Gearman server"),
315
drizzled::PLUGIN_LICENSE_GPL,
316
drizzle_plugin::logging_gearman_plugin_init,
318
drizzle_plugin::init_options
339
logging_gearman_plugin_init,
340
logging_gearman_system_variables,
320
343
DRIZZLE_DECLARE_PLUGIN_END;