2 * nbtscanner -- a tool for scanning large networks for SMB servers.
4 * mysql_interface.c: Interface routines for the MySQL table.
5 * Copyright (C) 2000 Steinar H. Gunderson
7 * Large amounts of code adapted from Samba (http://www.samba.org/)
8 * Copyright (C) Andrew Tridgell 1994-1998, and others.
10 * This program is free software; you can redistribute it and/or modify
11 * it under the terms of the GNU General Public License as published by
12 * the Free Software Foundation; either version 2 of the License, or
13 * (at your option) any later version.
15 * This program is distributed in the hope that it will be useful,
16 * but WITHOUT ANY WARRANTY; without even the implied warranty of
17 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
18 * GNU General Public License for more details.
20 * You should have received a copy of the GNU General Public License
21 * along with this program; if not, write to the Free Software
22 * Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
30 #include "mysql_interface.h"
31 #include "configfile.h"
35 /* veeeery detailed error reporting here ;-) */
36 void init_mysql(char *host, char *username, char *password)
38 if (mysql != NULL) return; /* hack */
40 mysql = mysql_init(NULL);
43 fprintf(stderr, "mysql_init() failed\n");
48 if (mysql_real_connect(mysql, mysql_host, username, password, "nbtscanner",
51 fprintf(stderr, "mysql_real_connect() failed\n");
57 void add_record_mysql(char *ip, char *hostname, char *fileservername, char *groupname)
60 char hname[256], fsname[256], gname[256];
62 mysql_real_escape_string(mysql, hname, hostname, strlen(hostname));
63 mysql_real_escape_string(mysql, fsname, fileservername, strlen(fileservername));
64 mysql_real_escape_string(mysql, gname, groupname, strlen(groupname));
67 "REPLACE INTO nbtscanner.nbtscanner SET ip='%s', hostname='%s', fileservername='%s', groupname='%s';",
68 ip, hname, fsname, gname);
70 if (mysql_query(mysql, query) != 0) {
72 fprintf(stderr, "mysql_query(`%s') failed\n", query);
78 void delete_record_mysql(char *ip)
82 "DELETE FROM nbtscanner.nbtscanner WHERE ip='%s';",
85 if (mysql_query(mysql, query) != 0) {
87 fprintf(stderr, "mysql_query(`%s') failed\n", query);
93 void print_all_records_mysql()
96 unsigned long *lengths;
97 unsigned int num_fields;
100 if (mysql_query(mysql, "SELECT ip,(CASE WHEN fileservername='-unknown-nbtscanner-' THEN hostname ELSE fileservername END),groupname,(fileservername <> '-unknown-nbtscanner-') FROM nbtscanner.nbtscanner;") != 0) {
101 if (verbosity >= 1) {
102 fprintf(stderr, "mysql_query('SELECT ip'...) failed\n");
107 result = mysql_store_result(mysql);
108 if (result == NULL) {
109 if (verbosity >= 1) {
110 fprintf(stderr, "mysql_store_result() failed\n");
115 num_fields = mysql_num_fields(result);
117 MYSQL_ROW row = mysql_fetch_row(result);
118 if (row == NULL) return;
120 lengths = mysql_fetch_lengths(result);
122 for (i = 0; i < num_fields; i++) {
125 /* strip away CR/LFs */
126 for (j = 0; j < lengths[i]; j++) {
127 if (row[i][j] == 0 || row[i][j] == 10 || row[i][j] == 13 || row[i][j] == ',') {
131 printf("%.*s", (int) lengths[i], row[i] ? row[i] : "NULL");
132 if (i != num_fields - 1) printf(",");
140 /* don't care if this fails */
141 mysql_query(mysql, "OPTIMIZE TABLE nbtscanner.nbtscanner;");