dtv-scan-tables.git - dtv-scan-tables Debian packaging

diff options

author	Jonathan McCrohan <jmccrohan@gmail.com>	2016-06-11 15:19:36 +0100
committer	Jonathan McCrohan <jmccrohan@gmail.com>	2016-06-11 15:19:36 +0100
commit	800dccb249b663bdbd99e876996d4b5ac5ffa937 (patch)
tree	78c662dab55a8a4c7850f2e6408182b8a646fdb1 /dvb-t/se-Norraker
parent	e7855f4fed7766032a5674cf3a932856460df799 (diff)
download	dtv-scan-tables-800dccb249b663bdbd99e876996d4b5ac5ffa937.tar.gz

Imported Upstream version 0+git20160503.4f192bdupstream/0+git20160503.4f192bd

Diffstat (limited to 'dvb-t/se-Norraker')

0 files changed, 0 insertions, 0 deletions

/* $Id: plugin_sample.c 733 2007-01-15 05:47:13Z michael $ * $URL: https://ssl.bulix.org/svn/lcd4linux/branches/0.10.1/plugin_qnaplog.c $ * * plugin qnaplog * * Copyright (C) 2009 Ralf Tralow <qnaplog@ringwelt.de> * * This file is part of LCD4Linux. * * LCD4Linux is free software; you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation; either version 2, or (at your option) * any later version. * * LCD4Linux 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 General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program; if not, write to the Free Software * Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA. * */ /* DOC: * To compile the plugin remember to add -lsqlite3 option into Makefile. I.E: CC = gcc -lsqlite3 * or run: * $ gcc -I/opt/include -L/opt/lib/sqlite3 plugin_qnaplog.c -lsqlite3 -o plugin_qnaplog.o * * * exported functions: * * int plugin_init_qnaplog (void) * void plugin_exit_qnaplog(void) * static void my_status(RESULT * result, RESULT *arg1) * static void my_conn(RESULT *result, RESULT *arg1) * static void my_event(RESULT *result, RESULT *arg1) * * * adds various functions * */ /* define the include files you need */ #include "config.h" #include "cfg.h" #include <stdlib.h> #include <string.h> #include <ctype.h> #include <stdio.h> #ifdef HAVE_SQLITE3_H #include <sqlite3.h> #else #warning sqlite3.h not found: plugin deactivated #endif #include <unistd.h> #include <sys/stat.h> #include <time.h> /* these should always be included */ #include "debug.h" #include "plugin.h" #ifdef WITH_DMALLOC #include <dmalloc.h> #endif #ifdef HAVE_SQLITE3_H #define SQLSTATEMENT_CONN "select * from NASLOG_CONN ORDER BY conn_id DESC LIMIT 1" #define SQLSTATEMENT_EVENT "select * from NASLOG_EVENT ORDER BY event_id DESC LIMIT 1" time_t lastaccesstimeConn = 0; time_t lastaccesstimeEvent = 0; sqlite3 *connexConn; sqlite3 *connexEvent; char dbNameConn[256]; char dbNameEvent[256]; char conn_id[10]; char conn_type[12]; char conn_date[12]; char conn_time[12]; char conn_user[30]; char conn_ip[16]; char conn_comp[30]; char conn_res[255]; char conn_serv[10]; char conn_action[12]; char event_id[10]; char event_comp[30]; char event_date[12]; char event_ip[16]; char event_time[12]; char event_type[12]; char event_user[30]; char event_desc[255]; #define MAX_IDS_TYPE 3 char *IDS_TYPE[MAX_IDS_TYPE] = { "Information", "Warning", "Error" }; #define MAX_IDS_SERV 8 char *IDS_SERV[MAX_IDS_SERV] = { "S0", "Samba", "S2", "HTTP", "S4", "S5", "S6", "SSH" }; #define MAX_IDS_ACTION 16 char *IDS_ACTION[MAX_IDS_ACTION] = { "C0", "Delete", "Read", "Write", "C4", "C5", "C6", "C7", "C8", "Login fail", "Login ok", "Logout", "C12", "C13", "C14", "Add" }; static char Section[] = "Plugin:QnapLog"; /** test the connection to conn.log * */ static int configureConn(void) { static int configured = 0; char *s; int rc; if (configured != 0) return configured; s = cfg_get(Section, "databaseConn", ""); if (*s == '\0') { info("[QnapLog] empty '%s.database' entry in %s, assuming none", Section, cfg_source()); strcpy(dbNameConn, "/etc/logs/conn.log"); } else { snprintf(dbNameConn, sizeof(dbNameConn), "%s", s); } free(s); rc = sqlite3_open(dbNameConn, &connexConn); if (rc) { error("[QnapLog] connection error: %s", sqlite3_errmsg(connexConn)); configured = -1; sqlite3_close(connexConn); return configured; } configured = 1; return configured; } /** test the connection to event.log * */ static int configureEvent(void) { static int configured = 0; char *s; int rc; if (configured != 0) return configured; s = cfg_get(Section, "databaseEvent", ""); if (*s == '\0') { info("[QnapLog] empty '%s.database' entry in %s, assuming none", Section, cfg_source()); strcpy(dbNameEvent, "/etc/logs/event.log"); } else { snprintf(dbNameEvent, sizeof(dbNameEvent), "%s", s); } free(s); rc = sqlite3_open(dbNameEvent, &connexEvent); if (rc) { error("[QnapLog] connection error: %s", sqlite3_errmsg(connexEvent)); configured = -1; sqlite3_close(connexEvent); return configured; } configured = 1; return configured; } /** callback function for conn request * */ static int callbackConn(void *NotUsed, int argc, char **argv, char **azColName) { int i; int c; for (i = 0; i < argc; i++) { if (strcmp(azColName[i], "conn_id") == 0) { snprintf(conn_id, sizeof(conn_id), "%s", argv[i] ? argv[i] : "NULL"); } else if (strcmp(azColName[i], "conn_type") == 0) { c = atoi(argv[i]); if (c < MAX_IDS_TYPE) snprintf(conn_type, sizeof(conn_type), "%s", IDS_TYPE[c]); } else if (strcmp(azColName[i], "conn_date") == 0) { snprintf(conn_date, sizeof(conn_date), "%s", argv[i] ? argv[i] : "NULL"); } else if (strcmp(azColName[i], "conn_time") == 0) { snprintf(conn_time, sizeof(conn_time), "%s", argv[i] ? argv[i] : "NULL"); } else if (strcmp(azColName[i], "conn_user") == 0) { snprintf(conn_user, sizeof(conn_user), "%s", argv[i] ? argv[i] : "NULL"); } else if (strcmp(azColName[i], "conn_ip") == 0) { snprintf(conn_ip, sizeof(conn_ip), "%s", argv[i] ? argv[i] : "NULL"); } else if (strcmp(azColName[i], "conn_comp") == 0) { snprintf(conn_comp, sizeof(conn_comp), "%s", argv[i] ? argv[i] : "NULL"); } else if (strcmp(azColName[i], "conn_res") == 0) { snprintf(conn_res, sizeof(conn_res), "%s", argv[i] ? argv[i] : "NULL"); } else if (strcmp(azColName[i], "conn_serv") == 0) { c = atoi(argv[i]); if (c < MAX_IDS_SERV) snprintf(conn_serv, sizeof(conn_serv), "%s", IDS_SERV[c]); } else if (strcmp(azColName[i], "conn_action") == 0) { c = atoi(argv[i]); if (c < MAX_IDS_ACTION) snprintf(conn_action, sizeof(conn_action), "%s", IDS_ACTION[c]); } } return 0; } /** callback function for event request * */ static int callbackEvent(void *NotUsed, int argc, char **argv, char **azColName) { int i; int c; for (i = 0; i < argc; i++) { if (strcmp(azColName[i], "event_id") == 0) { snprintf(event_id, sizeof(event_id), "%s", argv[i] ? argv[i] : "NULL"); } else if (strcmp(azColName[i], "event_type") == 0) { c = *argv[i] & 0x0F; if (c < MAX_IDS_TYPE) snprintf(event_type, sizeof(event_type), "%s", IDS_TYPE[c]); } else if (strcmp(azColName[i], "event_date") == 0) { snprintf(event_date, sizeof(event_date), "%s", argv[i] ? argv[i] : "NULL"); } else if (strcmp(azColName[i], "event_time") == 0) { snprintf(event_time, sizeof(event_time), "%s", argv[i] ? argv[i] : "NULL"); } else if (strcmp(azColName[i], "event_user") == 0) { snprintf(event_user, sizeof(event_user), "%s", argv[i] ? argv[i] : "NULL"); } else if (strcmp(azColName[i], "event_ip") == 0) { snprintf(event_ip, sizeof(event_ip), "%s", argv[i] ? argv[i] : "NULL"); } else if (strcmp(azColName[i], "event_comp") == 0) { snprintf(event_comp, sizeof(event_comp), "%s", argv[i] ? argv[i] : "NULL"); } else if (strcmp(azColName[i], "event_desc") == 0) { snprintf(event_desc, sizeof(event_desc), "%s", argv[i] ? argv[i] : "NULL"); } } return 0; } /** request last of qnap connection * */ static void my_conn(RESULT * result, RESULT * arg1) { char *key; char *value; char *zErrMsg = 0; int rc; struct stat attrib; // create a file attribute structure time_t accesstime; value = -1; key = R2S(arg1); if (configureConn() >= 0) { stat(dbNameConn, &attrib); // get the attributes accesstime = attrib.st_mtime; // Get the last modified time and put it into the time structure if (accesstime > lastaccesstimeConn) { lastaccesstimeConn = accesstime; rc = sqlite3_exec(connexConn, SQLSTATEMENT_CONN, callbackConn, 0, &zErrMsg); if (rc != SQLITE_OK) { fprintf(stderr, "SQL error: %s\n", zErrMsg); sqlite3_free(zErrMsg); } } if (strcasecmp(key, "id") == 0) { value = conn_id; } else if (strcasecmp(key, "type") == 0) { value = conn_type; } else if (strcasecmp(key, "date") == 0) { value = conn_date; } else if (strcasecmp(key, "time") == 0) { value = conn_time; } else if (strcasecmp(key, "user") == 0) { value = conn_user; } else if (strcasecmp(key, "ip") == 0) { value = conn_ip; } else if (strncasecmp(key, "res", 3) == 0) { value = conn_res; } else if (strncasecmp(key, "serv", 4) == 0) { value = conn_serv; } else if (strncasecmp(key, "act", 3) == 0) { value = conn_action; } else if (strncasecmp(key, "comp", 4) == 0) { value = conn_comp; } } /* store result */ SetResult(&result, R_STRING, value); } /** request last qnap event * */ static void my_event(RESULT * result, RESULT * arg1) { char *key; char *value; char *zErrMsg = 0; int rc; struct stat attrib; // create a file attribute structure time_t accesstime; value = -1; key = R2S(arg1); if (configureEvent() >= 0) { stat(dbNameEvent, &attrib); // get the attributes accesstime = attrib.st_mtime; // Get the last modified time and put it into the time structure if (accesstime > lastaccesstimeEvent) { lastaccesstimeEvent = accesstime; rc = sqlite3_exec(connexEvent, SQLSTATEMENT_EVENT, callbackEvent, 0, &zErrMsg); if (rc != SQLITE_OK) { fprintf(stderr, "SQL error: %s\n", zErrMsg); sqlite3_free(zErrMsg); } } if (strcasecmp(key, "id") == 0) { value = event_id; } else if (strncasecmp(key, "comp", 4) == 0) { value = event_comp; } else if (strcasecmp(key, "date") == 0) { value = event_date; } else if (strcasecmp(key, "ip") == 0) { value = event_ip; } else if (strcasecmp(key, "time") == 0) { value = event_time; } else if (strcasecmp(key, "type") == 0) { value = event_type; } else if (strcasecmp(key, "user") == 0) { value = event_user; } else if (strncasecmp(key, "desc", 4) == 0) { value = event_desc; } } /* store result */ SetResult(&result, R_STRING, value); } /** status for conn or event connection * */ static void my_status(RESULT * result, RESULT * arg1) { const char *value = ""; const char *status = "Ok"; char *key; key = R2S(arg1); if (strcmp(key, "conn") == 0) { if (configureConn() > 0) { value = status; } } else if (strcmp(key, "event") == 0) { if (configureEvent() > 0) { value = status; } } SetResult(&result, R_STRING, value); } #endif /* plugin initialization */ int plugin_init_qnaplog(void) { #ifdef HAVE_SQLITE3_H /* register all our cool functions */ /* the second parameter is the number of arguments */ /* -1 stands for variable argument list */ AddFunction("qnaplog::status", 1, my_status); AddFunction("qnaplog::conn", 1, my_conn); AddFunction("qnaplog::event", 1, my_event); #endif return 0; } void plugin_exit_qnaplog(void) { #ifdef HAVE_SQLITE3_H /* free any allocated memory */ /* close filedescriptors */ sqlite3_close(connexConn); sqlite3_close(connexEvent); #endif }


context:
space:
mode: