20
20
#include "config.h"
22
#include <boost/scoped_array.hpp>
24
21
#include <drizzled/plugin/logging.h>
25
22
#include <drizzled/gettext.h>
26
23
#include <drizzled/session.h>
27
#include <boost/date_time.hpp>
28
24
#include <boost/program_options.hpp>
29
25
#include <drizzled/module/option_map.h>
30
26
#include <libgearman/gearman.h>
31
27
#include <limits.h>
32
29
#include <sys/types.h>
33
30
#include <sys/stat.h>
40
namespace drizzle_plugin
34
using namespace drizzled;
43
35
namespace po= boost::program_options;
45
37
/* TODO make this dynamic as needed */
46
38
static const int MAX_MSG_LEN= 32*1024;
40
static bool sysvar_logging_gearman_enable;
41
static char* sysvar_logging_gearman_host= NULL;
42
static char* sysvar_logging_gearman_function= NULL;
45
/* stolen from mysys/my_getsystime
46
until the Session has a good utime "now" we can use
47
will have to use this instead */
49
static uint64_t get_microtime()
51
#if defined(HAVE_GETHRTIME)
52
return gethrtime()/1000;
57
The following loop is here because gettimeofday may fail on some systems
59
while (gettimeofday(&t, NULL) != 0) {}
60
newtime= (uint64_t)t.tv_sec * 1000000 + t.tv_usec;
62
#endif /* defined(HAVE_GETHRTIME) */
48
65
/* quote a string to be safe to include in a CSV line
49
66
that means backslash quoting all commas, doublequotes, backslashes,
50
67
and all the ASCII unprintable characters
156
class LoggingGearman :
157
public drizzled::plugin::Logging
173
class LoggingGearman : public plugin::Logging
160
const std::string _host;
161
const std::string _function;
163
int _gearman_client_ok;
164
gearman_client_st _gearman_client;
167
LoggingGearman(const LoggingGearman&);
176
int gearman_client_ok;
177
gearman_client_st gearman_client;
171
LoggingGearman(const std::string &host,
172
const std::string &function) :
173
drizzled::plugin::Logging("LoggingGearman"),
176
_gearman_client_ok(0),
182
: plugin::Logging("LoggingGearman"),
179
185
gearman_return_t ret;
182
if (gearman_client_create(&_gearman_client) == NULL)
187
if (sysvar_logging_gearman_enable == false)
190
if (sysvar_logging_gearman_host == NULL)
194
if (gearman_client_create(&gearman_client) == NULL)
184
char errmsg[STRERROR_MAX];
185
strerror_r(errno, errmsg, sizeof(errmsg));
186
drizzled::errmsg_printf(ERRMSG_LVL_ERROR, _("fail gearman_client_create(): %s"),
196
errmsg_printf(ERRMSG_LVL_ERROR, _("fail gearman_client_create(): %s"),
191
201
/* TODO, be able to override the port */
192
202
/* TODO, be able send to multiple servers */
193
ret= gearman_client_add_server(&_gearman_client,
203
ret= gearman_client_add_server(&gearman_client,
204
sysvar_logging_gearman_host, 0);
195
205
if (ret != GEARMAN_SUCCESS)
197
drizzled::errmsg_printf(ERRMSG_LVL_ERROR, _("fail gearman_client_add_server(): %s"),
198
gearman_client_error(&_gearman_client));
207
errmsg_printf(ERRMSG_LVL_ERROR, _("fail gearman_client_add_server(): %s"),
208
gearman_client_error(&gearman_client));
202
_gearman_client_ok= 1;
212
gearman_client_ok= 1;
206
216
~LoggingGearman()
208
if (_gearman_client_ok)
218
if (gearman_client_ok)
210
gearman_client_free(&_gearman_client);
220
gearman_client_free(&gearman_client);
214
virtual bool post(drizzled::Session *session)
224
virtual bool post(Session *session)
216
boost::scoped_array<char> msgbuf(new char[MAX_MSG_LEN]);
226
char msgbuf[MAX_MSG_LEN];
217
227
int msgbuf_len= 0;
219
229
assert(session != NULL);
222
232
but that crashes the server, so for now, we just lie a little bit
225
if (not _gearman_client_ok)
235
if (!gearman_client_ok)
228
238
/* TODO, the session object should have a "utime command completed"
229
239
inside itself, so be more accurate, and so this doesnt have to
230
240
keep calling current_utime, which can be slow */
232
boost::posix_time::ptime mytime(boost::posix_time::microsec_clock::local_time());
233
boost::posix_time::ptime epoch(boost::gregorian::date(1970,1,1));
234
uint64_t t_mark= (mytime-epoch).total_microseconds();
242
uint64_t t_mark= get_microtime();
237
244
// buffer to quotify the query
238
245
unsigned char qs[255];
240
247
// to avoid trying to printf %s something that is potentially NULL
241
drizzled::util::string::const_shared_ptr dbs(session->schema());
248
const char *dbs= session->db.empty() ? "" : session->db.c_str();
244
snprintf(msgbuf.get(), MAX_MSG_LEN,
251
snprintf(msgbuf, MAX_MSG_LEN,
245
252
"%"PRIu64",%"PRIu64",%"PRIu64",\"%.*s\",\"%s\",\"%.*s\","
246
253
"%"PRIu64",%"PRIu64",%"PRIu64",%"PRIu64",%"PRIu64","
247
254
"%"PRIu32",%"PRIu32",%"PRIu32",\"%s\"",
249
256
session->thread_id,
250
257
session->getQueryId(),
251
258
// dont need to quote the db name, always CSV safe
252
(int)dbs->size(), dbs->c_str(),
259
(int)session->db.length(), dbs,
253
260
// do need to quote the query
254
quotify((const unsigned char *)session->getQueryString()->c_str(), session->getQueryString()->length(), qs, sizeof(qs)),
261
quotify((const unsigned char *)session->getQueryString().c_str(),
262
session->getQueryLength(), qs, sizeof(qs)),
255
263
// command_name is defined in drizzled/sql_parse.cc
256
264
// dont need to quote the command name, always CSV safe
257
(int)drizzled::command_name[session->command].length,
258
drizzled::command_name[session->command].str,
265
(int)command_name[session->command].length,
266
command_name[session->command].str,
259
267
// counters are at end, to make it easier to add more
260
268
(t_mark - session->getConnectMicroseconds()),
261
269
(t_mark - session->start_utime),
265
273
session->tmp_table,
266
274
session->total_warn_count,
267
275
session->getServerId(),
268
drizzled::glob_hostname
271
279
char job_handle[GEARMAN_JOB_HANDLE_SIZE];
273
(void) gearman_client_do_background(&_gearman_client,
281
(void) gearman_client_do_background(&gearman_client,
282
sysvar_logging_gearman_function,
276
(void *) msgbuf.get(),
277
285
(size_t) msgbuf_len,
284
292
static LoggingGearman *handler= NULL;
286
static int logging_gearman_plugin_init(drizzled::module::Context &context)
294
static int logging_gearman_plugin_init(module::Context &context)
288
const drizzled::module::option_map &vm= context.getOptions();
290
handler= new LoggingGearman(vm["host"].as<std::string>(),
291
vm["function"].as<std::string>());
296
handler= new LoggingGearman();
292
297
context.add(handler);
293
context.registerVariable(new drizzled::sys_var_const_string_val("host", vm["host"].as<std::string>()));
294
context.registerVariable(new drizzled::sys_var_const_string_val("function", vm["function"].as<std::string>()));
299
302
static void init_options(drizzled::module::option_context &context)
302
po::value<std::string>()->default_value("localhost"),
303
N_("Hostname for logging to a Gearman server"));
305
po::value<std::string>()->default_value("drizzlelog"),
306
N_("Gearman Function to send logging to"));
305
po::value<bool>(&sysvar_logging_gearman_enable)->default_value(false)->zero_tokens(),
306
N_("Enable logging to a gearman server"));
309
} /* namespace drizzle_plugin */
309
static DRIZZLE_SYSVAR_BOOL(
311
sysvar_logging_gearman_enable,
313
N_("Enable logging to a gearman server"),
314
NULL, /* check func */
315
NULL, /* update func */
316
false /* default */);
318
static DRIZZLE_SYSVAR_STR(
320
sysvar_logging_gearman_host,
322
N_("Hostname for logging to a Gearman server"),
323
NULL, /* check func */
324
NULL, /* update func*/
325
"localhost" /* default */);
327
static DRIZZLE_SYSVAR_STR(
329
sysvar_logging_gearman_function,
331
N_("Gearman Function to send logging to"),
332
NULL, /* check func */
333
NULL, /* update func*/
334
"drizzlelog" /* default */);
336
static drizzle_sys_var* logging_gearman_system_variables[]= {
337
DRIZZLE_SYSVAR(enable),
338
DRIZZLE_SYSVAR(host),
339
DRIZZLE_SYSVAR(function),
311
343
DRIZZLE_DECLARE_PLUGIN
316
348
"Mark Atwood <mark@fallenpegasus.com>",
317
349
N_("Log queries to a Gearman server"),
318
drizzled::PLUGIN_LICENSE_GPL,
319
drizzle_plugin::logging_gearman_plugin_init,
321
drizzle_plugin::init_options
351
logging_gearman_plugin_init,
352
logging_gearman_system_variables,
323
355
DRIZZLE_DECLARE_PLUGIN_END;