2 This file is part of GNUnet.
3 (C) 2006 - 2009 Christian Grothoff (and other contributing authors)
5 GNUnet is free software; you can redistribute it and/or modify
6 it under the terms of the GNU General Public License as published
7 by the Free Software Foundation; either version 2, or (at your
8 option) any later version.
10 GNUnet is distributed in the hope that it will be useful, but
11 WITHOUT ANY WARRANTY; without even the implied warranty of
12 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
13 General Public License for more details.
15 You should have received a copy of the GNU General Public License
16 along with GNUnet; see the file COPYING. If not, write to the
17 Free Software Foundation, Inc., 59 Temple Place - Suite 330,
18 Boston, MA 02111-1307, USA.
22 * @file src/dht/plugin_dhtlog_mysql_dump.c
23 * @brief MySQL logging plugin to record DHT operations to MySQL server,
24 * but write all queries to file instead of the actual server
25 * so that they can be imported later. The idea is that connecting
26 * to the MySQL server X times can be really problematic, but hopefully
27 * writing to a single file is more reliable.
28 * @author Nathan Evans
34 #include "gnunet_util_lib.h"
38 #define DEBUG_DHTLOG GNUNET_NO
41 * Maximum number of supported parameters for a prepared
42 * statement. Increase if needed.
47 static unsigned long max_varchar_len;
50 * The configuration the DHT service is running with
52 static const struct GNUNET_CONFIGURATION_Handle *cfg;
54 #define INSERT_QUERIES_STMT "prepare insert_query from 'INSERT INTO queries (trialuid, querytype, hops, dhtkeyuid, dhtqueryid, succeeded, nodeuid) "\
55 "VALUES (@temp_trial, ?, ?, ?, ?, ?, ?)'"
57 #define INSERT_ROUTES_STMT "prepare insert_route from 'INSERT INTO routes (trialuid, querytype, hops, dhtkeyuid, dhtqueryid, succeeded, nodeuid, from_node, to_node) "\
58 "VALUES (@temp_trial, ?, ?, ?, ?, ?, ?, ?, ?)'"
60 #define INSERT_NODES_STMT "prepare insert_node from 'INSERT ignore INTO nodes (trialuid, nodeid) "\
61 "VALUES (@temp_trial, ?)'"
63 #define INSERT_TOPOLOGY_STMT "prepare insert_topology from 'INSERT INTO topology (trialuid, date, connections) "\
64 "VALUES (@temp_trial, ?, ?)'"
66 #define EXTEND_TOPOLOGY_STMT "prepare extend_topology from 'INSERT INTO extended_topology (topology_uid, uid_first, uid_second) "\
67 "VALUES (@temp_topology, ?, ?)'"
69 #define UPDATE_TOPOLOGY_STMT "prepare update_topology from 'update topology set connections = ? where topology_uid = @temp_topology'"
71 #define SET_MALICIOUS_STMT "prepare set_malicious from 'update nodes set malicious_dropper = 1 where trialuid = @temp_trial and nodeid = @temp_node'"
73 #define INSERT_TRIALS_STMT "prepare insert_trial from 'INSERT INTO trials"\
74 "(starttime, other_trial_identifier, numnodes, topology,"\
75 "topology_percentage, topology_probability,"\
76 "blacklist_topology, connect_topology, connect_topology_option,"\
77 "connect_topology_option_modifier, puts, gets, "\
78 "concurrent, settle_time, num_rounds, malicious_getters,"\
79 "malicious_putters, malicious_droppers, malicious_get_frequency,"\
80 "malicious_put_frequency, stop_closest, stop_found, strict_kademlia, "\
81 "gets_succeeded, message) "\
82 "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'"
84 #define INSERT_GENERIC_STAT_STMT "prepare insert_generic_stat from 'INSERT INTO generic_stats" \
85 "(trialuid, nodeuid, section, name, value)"\
86 "VALUES (@temp_trial, @temp_node, @temp_section, @temp_stat, @temp_value)'"
88 #define INSERT_STAT_STMT "prepare insert_stat from 'INSERT INTO node_statistics"\
89 "(trialuid, nodeuid, route_requests,"\
90 "route_forwards, result_requests,"\
91 "client_results, result_forwards, gets,"\
92 "puts, data_inserts, find_peer_requests, "\
93 "find_peers_started, gets_started, puts_started, find_peer_responses_received,"\
94 "get_responses_received, find_peer_responses_sent, get_responses_sent) "\
95 "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'"
97 #define INSERT_DHTKEY_STMT "prepare insert_dhtkey from 'INSERT ignore INTO dhtkeys (dhtkey, trialuid) "\
98 "VALUES (?, @temp_trial)'"
100 #define UPDATE_TRIALS_STMT "prepare update_trial from 'UPDATE trials set endtime= ?, gets_succeeded = ? where trialuid = @temp_trial'"
102 #define UPDATE_CONNECTIONS_STMT "prepare update_conn from 'UPDATE trials set totalConnections = ? where trialuid = @temp_trial'"
104 #define GET_TRIAL_STMT "prepare select_trial from 'SELECT MAX( trialuid ) FROM trials into @temp_trial'"
106 #define GET_TOPOLOGY_STMT "prepare select_topology from 'SELECT MAX( topology_uid ) FROM topology into @temp_topology'"
108 #define GET_DHTKEYUID_STMT "prepare get_dhtkeyuid from 'SELECT dhtkeyuid FROM dhtkeys where dhtkey = ? and trialuid = @temp_trial'"
110 #define GET_NODEUID_STMT "prepare get_nodeuid from 'SELECT nodeuid FROM nodes where trialuid = @temp_trial and nodeid = ?'"
112 #define DATE_STR_SIZE 50
115 * File to dump all sql statements to.
123 static char date[DATE_STR_SIZE];
128 memset (date, 0, DATE_STR_SIZE);
129 tmptr = localtime (&timetmp);
131 strftime (date, DATE_STR_SIZE, "%Y-%m-%d %H:%M:%S", tmptr);
139 * Create a prepared statement.
141 * @return GNUNET_OK on success, GNUNET_SYSERR on failure
144 prepared_statement_create (const char *statement)
146 if (fprintf(outfile, "%s;\n", statement) > 0)
149 return GNUNET_SYSERR;
153 * Initialize the prepared statements for use with dht test logging
158 #define PINIT(a) (GNUNET_OK != (prepared_statement_create(a)))
159 if (PINIT (INSERT_QUERIES_STMT) ||
160 PINIT (INSERT_ROUTES_STMT) ||
161 PINIT (INSERT_TRIALS_STMT) ||
162 PINIT (SET_MALICIOUS_STMT) ||
163 PINIT (INSERT_GENERIC_STAT_STMT) ||
164 PINIT (INSERT_STAT_STMT) ||
165 PINIT (INSERT_NODES_STMT) ||
166 PINIT (INSERT_DHTKEY_STMT) ||
167 PINIT (UPDATE_TRIALS_STMT) ||
168 PINIT (GET_DHTKEYUID_STMT) ||
169 PINIT (GET_NODEUID_STMT) ||
170 PINIT (UPDATE_CONNECTIONS_STMT) ||
171 PINIT (INSERT_TOPOLOGY_STMT) ||
172 PINIT (EXTEND_TOPOLOGY_STMT) ||
173 PINIT (UPDATE_TOPOLOGY_STMT) ||
174 PINIT (GET_TRIAL_STMT) ||
175 PINIT (GET_TOPOLOGY_STMT))
177 return GNUNET_SYSERR;
187 * Records the current topology (number of connections, time, trial)
189 * @param num_connections how many connections are in the topology
191 * @return GNUNET_OK on success, GNUNET_SYSERR on failure
194 add_topology (int num_connections)
198 return GNUNET_SYSERR;
200 ret = fprintf(outfile, "set @date = \"%s\", @num = %d;\n", get_sql_time(), num_connections);
203 return GNUNET_SYSERR;
204 ret = fprintf(outfile, "execute insert_topology using "
207 return GNUNET_SYSERR;
209 ret = fprintf(outfile, "execute select_topology;\n");
213 return GNUNET_SYSERR;
217 * Records a connection between two peers in the current topology
219 * @param first one side of the connection
220 * @param second other side of the connection
222 * @return GNUNET_OK on success, GNUNET_SYSERR on failure
225 add_extended_topology (const struct GNUNET_PeerIdentity *first, const struct GNUNET_PeerIdentity *second)
229 return GNUNET_SYSERR;
232 ret = fprintf(outfile, "select nodeuid from nodes where trialuid = @temp_trial and nodeid = \"%s\" into @temp_first_node;\n", GNUNET_h2s_full(&first->hashPubKey));
234 ret = fprintf(outfile, "set @temp_first_node = 0;\n");
237 return GNUNET_SYSERR;
240 ret = fprintf(outfile, "select nodeuid from nodes where trialuid = @temp_trial and nodeid = \"%s\" into @temp_second_node;\n", GNUNET_h2s_full(&second->hashPubKey));
242 ret = fprintf(outfile, "set @temp_second_node = 0;\n");
245 return GNUNET_SYSERR;
247 ret = fprintf(outfile, "execute extend_topology using "
248 "@temp_first_node, @temp_second_node;\n");
252 return GNUNET_SYSERR;
257 * Inserts the specified trial into the dhttests.trials table
259 * @param trialuid return the trialuid of the newly inserted trial
260 * @param other_identifier identifier for the trial from another source
261 * (for joining later)
262 * @param num_nodes how many nodes are in the trial
263 * @param topology integer representing topology for this trial
264 * @param blacklist_topology integer representing blacklist topology for this trial
265 * @param connect_topology integer representing connect topology for this trial
266 * @param connect_topology_option integer representing connect topology option
267 * @param connect_topology_option_modifier float to modify connect option
268 * @param topology_percentage percentage modifier for certain topologies
269 * @param topology_probability probability modifier for certain topologies
270 * @param puts number of puts to perform
271 * @param gets number of gets to perform
272 * @param concurrent number of concurrent requests
273 * @param settle_time time to wait between creating topology and starting testing
274 * @param num_rounds number of times to repeat the trial
275 * @param malicious_getters number of malicious GET peers in the trial
276 * @param malicious_putters number of malicious PUT peers in the trial
277 * @param malicious_droppers number of malicious DROP peers in the trial
278 * @param malicious_get_frequency how often malicious gets are sent
279 * @param malicious_put_frequency how often malicious puts are sent
280 * @param stop_closest stop forwarding PUTs if closest node found
281 * @param stop_found stop forwarding GETs if data found
282 * @param strict_kademlia test used kademlia routing algorithm
283 * @param gets_succeeded how many gets did the test driver report success on
284 * @param message string to put into DB for this trial
286 * @return GNUNET_OK on success, GNUNET_SYSERR on failure
288 int add_trial (unsigned long long *trialuid, unsigned int other_identifier, unsigned int num_nodes, unsigned int topology,
289 unsigned int blacklist_topology, unsigned int connect_topology,
290 unsigned int connect_topology_option, float connect_topology_option_modifier,
291 float topology_percentage, float topology_probability,
292 unsigned int puts, unsigned int gets, unsigned int concurrent, unsigned int settle_time,
293 unsigned int num_rounds, unsigned int malicious_getters, unsigned int malicious_putters,
294 unsigned int malicious_droppers, unsigned int malicious_get_frequency,
295 unsigned int malicious_put_frequency, unsigned int stop_closest, unsigned int stop_found,
296 unsigned int strict_kademlia, unsigned int gets_succeeded,
300 if (trialuid != NULL)
303 return GNUNET_SYSERR;
305 ret = fprintf(outfile, "set @date = \"%s\", @oid = %u, @num = %u, @topology = %u, @bl = %u, "
306 "@connect = %u, @c_t_o = %u, @c_t_o_m = %f, @t_p = %f, "
307 "@t_pr = %f, @puts = %u, @gets = %u, "
308 "@concurrent = %u, @settle = %u, @rounds = %u, "
309 "@m_gets = %u, @m_puts = %u, @m_drops = %u, "
310 "@m_g_f = %u, @m_p_f = %u, @s_c = %u, @s_f = %u,"
311 "@s_k = %u, @g_s = %u, @message = \"%s\";\n",
312 get_sql_time(), other_identifier, num_nodes, topology,
313 blacklist_topology, connect_topology,
314 connect_topology_option, connect_topology_option_modifier,
315 topology_percentage, topology_probability,
316 puts, gets, concurrent, settle_time,
317 num_rounds, malicious_getters, malicious_putters,
318 malicious_droppers, malicious_get_frequency, malicious_put_frequency,
319 stop_closest, stop_found, strict_kademlia, gets_succeeded, message);
322 return GNUNET_SYSERR;
323 ret = fprintf(outfile, "execute insert_trial using "
324 "@date, @oid, @num, @topology, @t_p, @t_pr,"
325 " @bl, @connect, @c_t_o,"
326 "@c_t_o_m, @puts, @gets,"
327 "@concurrent, @settle, @rounds,"
328 "@m_gets, @m_puts, @m_drops,"
329 "@m_g_f, @m_p_f, @s_c, @s_f,"
330 "@s_k, @g_s, @message;\n");
332 return GNUNET_SYSERR;
333 ret = fprintf(outfile, "execute select_trial;\n");
337 return GNUNET_SYSERR;
342 * Inserts the specified stats into the dhttests.generic_stats table
344 * @param peer the peer inserting the statistic
345 * @param name the name of the statistic
346 * @param section the section of the statistic
347 * @param value the value of the statistic
349 * @return GNUNET_OK on success, GNUNET_SYSERR on failure
352 add_generic_stat (const struct GNUNET_PeerIdentity *peer,
354 const char *section, uint64_t value)
358 return GNUNET_SYSERR;
361 ret = fprintf(outfile, "select nodeuid from nodes where trialuid = @temp_trial and nodeid = \"%s\" into @temp_node;\n", GNUNET_h2s_full(&peer->hashPubKey));
363 ret = fprintf(outfile, "set @temp_node = 0;\n");
366 return GNUNET_SYSERR;
368 ret = fprintf(outfile, "set @temp_section = \"%s\", @temp_stat = \"%s\", @temp_value = %llu;\n",
369 section, name, (unsigned long long)value);
372 return GNUNET_SYSERR;
374 ret = fprintf(outfile, "execute insert_generic_stat;\n");
377 return GNUNET_SYSERR;
383 * Inserts the specified stats into the dhttests.node_statistics table
385 * @param peer the peer inserting the statistic
386 * @param route_requests route requests seen
387 * @param route_forwards route requests forwarded
388 * @param result_requests route result requests seen
389 * @param client_requests client requests initiated
390 * @param result_forwards route results forwarded
391 * @param gets get requests handled
392 * @param puts put requests handle
393 * @param data_inserts data inserted at this node
394 * @param find_peer_requests find peer requests seen
395 * @param find_peers_started find peer requests initiated at this node
396 * @param gets_started get requests initiated at this node
397 * @param puts_started put requests initiated at this node
398 * @param find_peer_responses_received find peer responses received locally
399 * @param get_responses_received get responses received locally
400 * @param find_peer_responses_sent find peer responses sent from this node
401 * @param get_responses_sent get responses sent from this node
403 * @return GNUNET_OK on success, GNUNET_SYSERR on failure
406 add_stat (const struct GNUNET_PeerIdentity *peer, unsigned int route_requests,
407 unsigned int route_forwards, unsigned int result_requests,
408 unsigned int client_requests, unsigned int result_forwards,
409 unsigned int gets, unsigned int puts,
410 unsigned int data_inserts, unsigned int find_peer_requests,
411 unsigned int find_peers_started, unsigned int gets_started,
412 unsigned int puts_started, unsigned int find_peer_responses_received,
413 unsigned int get_responses_received, unsigned int find_peer_responses_sent,
414 unsigned int get_responses_sent)
418 return GNUNET_SYSERR;
421 ret = fprintf(outfile, "select nodeuid from nodes where trialuid = @temp_trial and nodeid = \"%s\" into @temp_node;\n", GNUNET_h2s_full(&peer->hashPubKey));
423 ret = fprintf(outfile, "set @temp_node = 0;\n");
425 return GNUNET_SYSERR;
427 ret = fprintf(outfile, "set @r_r = %u, @r_f = %u, @res_r = %u, @c_r = %u, "
428 "@res_f = %u, @gets = %u, @puts = %u, @d_i = %u, "
429 "@f_p_r = %u, @f_p_s = %u, @g_s = %u, @p_s = %u, "
430 "@f_p_r_r = %u, @g_r_r = %u, @f_p_r_s = %u, @g_r_s = %u;\n",
431 route_requests, route_forwards, result_requests,
432 client_requests, result_forwards, gets, puts,
433 data_inserts, find_peer_requests, find_peers_started,
434 gets_started, puts_started, find_peer_responses_received,
435 get_responses_received, find_peer_responses_sent,
439 return GNUNET_SYSERR;
441 ret = fprintf(outfile, "execute insert_stat using "
442 "@temp_trial, @temp_node, @r_r, @r_f, @res_r, @c_r, "
443 "@res_f, @gets, @puts, @d_i, "
444 "@f_p_r, @f_p_s, @g_s, @p_s, "
445 "@f_p_r_r, @g_r_r, @f_p_r_s, @g_r_s;\n");
447 return GNUNET_SYSERR;
451 * Inserts the specified dhtkey into the dhttests.dhtkeys table,
452 * stores return value of dhttests.dhtkeys.dhtkeyuid into dhtkeyuid
454 * @param dhtkeyuid return value
455 * @param dhtkey hashcode of key to insert
457 * @return GNUNET_OK on success, GNUNET_SYSERR on failure
460 add_dhtkey (unsigned long long *dhtkeyuid, const GNUNET_HashCode * dhtkey)
463 if (dhtkeyuid != NULL)
467 return GNUNET_SYSERR;
470 ret = fprintf(outfile, "set @dhtkey = \"%s\";\n", GNUNET_h2s_full(dhtkey));
472 ret = fprintf(outfile, "set @dhtkey = XXXXX;\n");
475 return GNUNET_SYSERR;
476 ret = fprintf(outfile, "execute insert_dhtkey using @dhtkey;\n");
480 return GNUNET_SYSERR;
484 * Inserts the specified node into the dhttests.nodes table
486 * @param nodeuid the inserted node uid
487 * @param node the node to insert
489 * @return GNUNET_OK on success, GNUNET_SYSERR on failure
492 add_node (unsigned long long *nodeuid, struct GNUNET_PeerIdentity * node)
497 return GNUNET_SYSERR;
500 return GNUNET_SYSERR;
503 ret = fprintf(outfile, "set @node = \"%s\";\n", GNUNET_h2s_full(&node->hashPubKey));
505 return GNUNET_SYSERR;
508 return GNUNET_SYSERR;
510 ret = fprintf(outfile, "execute insert_node using @node;\n");
514 return GNUNET_SYSERR;
518 * Update dhttests.trials table with current server time as end time
520 * @param trialuid trial to update
521 * @param gets_succeeded how many gets did the testcase report as successful
523 * @return GNUNET_OK on success, GNUNET_SYSERR on failure.
526 update_trials (unsigned long long trialuid,
527 unsigned int gets_succeeded)
531 if (trialuid != current_trial)
534 _("Trialuid to update is not equal to current_trial\n"));
539 return GNUNET_SYSERR;
541 ret = fprintf(outfile, "set @date = \"%s\", @g_s = %u;\n", get_sql_time(), gets_succeeded);
544 return GNUNET_SYSERR;
546 ret = fprintf(outfile, "execute update_trial using @date, @g_s;\n");
551 return GNUNET_SYSERR;
556 * Update dhttests.nodes table setting the identified
557 * node as a malicious dropper.
559 * @param peer the peer that was set to be malicious
561 * @return GNUNET_OK on success, GNUNET_SYSERR on failure.
564 set_malicious (struct GNUNET_PeerIdentity *peer)
569 return GNUNET_SYSERR;
571 ret = fprintf(outfile, "set @temp_node = \"%s\";\n", GNUNET_h2s_full(&peer->hashPubKey));
574 return GNUNET_SYSERR;
576 ret = fprintf(outfile, "execute set_malicious;\n");
581 return GNUNET_SYSERR;
586 * Update dhttests.trials table with total connections information
588 * @param trialuid the trialuid to update
589 * @param totalConnections the number of connections
591 * @return GNUNET_OK on success, GNUNET_SYSERR on failure.
594 add_connections (unsigned long long trialuid, unsigned int totalConnections)
598 if (trialuid != current_trial)
601 _("Trialuid to update is not equal to current_trial(!)(?)\n"));
605 return GNUNET_SYSERR;
607 ret = fprintf(outfile, "set @conns = %u;\n", totalConnections);
610 return GNUNET_SYSERR;
612 ret = fprintf(outfile, "execute update_conn using @conns;\n");
617 return GNUNET_SYSERR;
622 * Update dhttests.topology table with total connections information
624 * @param totalConnections the number of connections
626 * @return GNUNET_OK on success, GNUNET_SYSERR on failure.
629 update_topology (unsigned int connections)
633 return GNUNET_SYSERR;
635 ret = fprintf(outfile, "set @temp_conns = %u;\n", connections);
638 return GNUNET_SYSERR;
640 ret = fprintf(outfile, "execute update_topology using @temp_conns;\n");
645 return GNUNET_SYSERR;
649 * Inserts the specified query into the dhttests.queries table
651 * @param sqlqueruid inserted query uid
652 * @param queryid dht query id
653 * @param type type of the query
654 * @param hops number of hops query traveled
655 * @param succeeded whether or not query was successful
656 * @param node the node the query hit
657 * @param key the key of the query
659 * @return GNUNET_OK on success, GNUNET_SYSERR on failure.
662 add_query (unsigned long long *sqlqueryuid, unsigned long long queryid,
663 unsigned int type, unsigned int hops, int succeeded,
664 const struct GNUNET_PeerIdentity * node, const GNUNET_HashCode * key)
669 return GNUNET_SYSERR;
671 if (sqlqueryuid != NULL)
675 ret = fprintf(outfile, "select dhtkeyuid from dhtkeys where trialuid = @temp_trial and dhtkey = \"%s\" into @temp_dhtkey;\n", GNUNET_h2s_full(key));
677 ret = fprintf(outfile, "set @temp_dhtkey = 0;\n");
680 return GNUNET_SYSERR;
683 ret = fprintf(outfile, "select nodeuid from nodes where trialuid = @temp_trial and nodeid = \"%s\" into @temp_node;\n", GNUNET_h2s_full(&node->hashPubKey));
685 ret = fprintf(outfile, "set @temp_node = 0;\n");
688 return GNUNET_SYSERR;
690 ret = fprintf(outfile, "set @qid = %llu, @type = %u, @hops = %u, @succ = %d;\n", queryid, type, hops, succeeded);
693 return GNUNET_SYSERR;
695 ret = fprintf(outfile, "execute insert_query using @type, @hops, @temp_dhtkey, @qid, @succ, @temp_node;\n");
700 return GNUNET_SYSERR;
704 * Inserts the specified route information into the dhttests.routes table
706 * @param sqlqueruid inserted query uid
707 * @param queryid dht query id
708 * @param type type of the query
709 * @param hops number of hops query traveled
710 * @param succeeded whether or not query was successful
711 * @param node the node the query hit
712 * @param key the key of the query
713 * @param from_node the node that sent the message to node
714 * @param to_node next node to forward message to
716 * @return GNUNET_OK on success, GNUNET_SYSERR on failure.
719 add_route (unsigned long long *sqlqueryuid, unsigned long long queryid,
720 unsigned int type, unsigned int hops,
721 int succeeded, const struct GNUNET_PeerIdentity * node,
722 const GNUNET_HashCode * key, const struct GNUNET_PeerIdentity * from_node,
723 const struct GNUNET_PeerIdentity * to_node)
728 return GNUNET_SYSERR;
730 if (sqlqueryuid != NULL)
734 ret = fprintf(outfile, "select dhtkeyuid from dhtkeys where trialuid = @temp_trial and dhtkey = \"%s\" into @temp_dhtkey;\n", GNUNET_h2s_full(key));
736 ret = fprintf(outfile, "set @temp_dhtkey = 0;\n");
739 return GNUNET_SYSERR;
742 ret = fprintf(outfile, "select nodeuid from nodes where trialuid = @temp_trial and nodeid = \"%s\" into @temp_node;\n", GNUNET_h2s_full(&node->hashPubKey));
744 ret = fprintf(outfile, "set @temp_node = 0;\n");
747 return GNUNET_SYSERR;
749 if (from_node != NULL)
750 ret = fprintf(outfile, "select nodeuid from nodes where trialuid = @temp_trial and nodeid = \"%s\" into @temp_from_node;\n", GNUNET_h2s_full(&from_node->hashPubKey));
752 ret = fprintf(outfile, "set @temp_from_node = 0;\n");
755 return GNUNET_SYSERR;
758 ret = fprintf(outfile, "select nodeuid from nodes where trialuid = @temp_trial and nodeid = \"%s\" into @temp_to_node;\n", GNUNET_h2s_full(&to_node->hashPubKey));
760 ret = fprintf(outfile, "set @temp_to_node = 0;\n");
763 return GNUNET_SYSERR;
765 ret = fprintf(outfile, "set @qid = %llu, @type = %u, @hops = %u, @succ = %d;\n", queryid, type, hops, succeeded);
768 return GNUNET_SYSERR;
770 ret = fprintf(outfile, "execute insert_route using @type, @hops, @temp_dhtkey, @qid, @succ, @temp_node, @temp_from_node, @temp_to_node;\n");
775 return GNUNET_SYSERR;
779 * Provides the dhtlog api
781 * @param c the configuration to use to connect to a server
783 * @return the handle to the server, or NULL on error
786 libgnunet_plugin_dhtlog_mysql_dump_init (void * cls)
788 struct GNUNET_DHTLOG_Plugin *plugin = cls;
795 max_varchar_len = 255;
797 GNUNET_log (GNUNET_ERROR_TYPE_DEBUG, "MySQL (DUMP) DHT Logger: initializing\n");
799 if (GNUNET_OK != GNUNET_CONFIGURATION_get_value_string (plugin->cfg,
803 outfile_path = GNUNET_strdup("");
806 GNUNET_asprintf (&outfile_name,
812 fn = GNUNET_STRINGS_filename_expand (outfile_name);
816 GNUNET_log (GNUNET_ERROR_TYPE_WARNING, _("Failed to get full path for `%s'\n"), outfile_name);
817 GNUNET_free(outfile_path);
818 GNUNET_free(outfile_name);
822 dirwarn = (GNUNET_OK != GNUNET_DISK_directory_create_for_file (fn));
823 outfile = FOPEN (fn, "w");
827 GNUNET_log_strerror_file (GNUNET_ERROR_TYPE_ERROR, "fopen", fn);
829 GNUNET_log (GNUNET_ERROR_TYPE_WARNING,
830 _("Failed to create or access directory for log file `%s'\n"),
832 GNUNET_free(outfile_path);
833 GNUNET_free(outfile_name);
838 GNUNET_free (outfile_path);
839 GNUNET_free (outfile_name);
842 if (iopen () != GNUNET_OK)
844 GNUNET_log (GNUNET_ERROR_TYPE_WARNING,
845 _("Failed to create file for dhtlog.\n"));
848 GNUNET_assert(plugin->dhtlog_api == NULL);
849 plugin->dhtlog_api = GNUNET_malloc(sizeof(struct GNUNET_DHTLOG_Handle));
850 plugin->dhtlog_api->insert_trial = &add_trial;
851 plugin->dhtlog_api->insert_stat = &add_stat;
852 plugin->dhtlog_api->insert_query = &add_query;
853 plugin->dhtlog_api->update_trial = &update_trials;
854 plugin->dhtlog_api->insert_route = &add_route;
855 plugin->dhtlog_api->insert_node = &add_node;
856 plugin->dhtlog_api->insert_dhtkey = &add_dhtkey;
857 plugin->dhtlog_api->update_connections = &add_connections;
858 plugin->dhtlog_api->insert_topology = &add_topology;
859 plugin->dhtlog_api->insert_extended_topology = &add_extended_topology;
860 plugin->dhtlog_api->update_topology = &update_topology;
861 plugin->dhtlog_api->set_malicious = &set_malicious;
862 plugin->dhtlog_api->add_generic_stat = &add_generic_stat;
868 * Shutdown the plugin.
871 libgnunet_plugin_dhtlog_mysql_dump_done (void * cls)
873 struct GNUNET_DHTLOG_Handle *dhtlog_api = cls;
874 GNUNET_log (GNUNET_ERROR_TYPE_DEBUG,
875 "MySQL DHT Logger: database shutdown\n");
876 GNUNET_assert(dhtlog_api != NULL);
878 GNUNET_free(dhtlog_api);
882 /* end of plugin_dhtlog_mysql.c */