2 # setup_tables: setup MYSQL/PGSQL side of things for blootbot.
7 require "src/logger.pl";
8 require "src/modules.pl";
10 require "src/interface.pl";
12 $bot_src_dir = "./src/";
14 # read param stuff from blootbot.config.
15 &loadConfig("files/blootbot.config");
17 my $dbname = $param{'DBName'};
21 print "error: appears that teh config file was not loaded properly.\n";
25 if ($param{'DBType'} =~ /mysql/i) {
28 print "Enter root information...\n";
31 chop (my $adminuser = <STDIN>);
36 chop(my $adminpass = <STDIN>);
40 if ($adminuser eq "" or $adminpass eq "") {
41 &ERROR("error: adminuser || adminpass is NULL.");
45 &openDB("mysql", $adminuser, $adminpass);
47 my $database_exists = 0;
48 foreach $database (&dbRawReturn("SHOW DATABASES")) {
49 $database_exists++ if $database eq $param{DBName};
51 if ($database_exists) {
52 &status("Database '$param{DBName}' already exists. Continuing...");
54 &status("Creating db ...");
55 &dbRaw("create(database)", "CREATE DATABASE $param{DBName}");
58 &status("--- Adding user information for user '$param{'SQLUser'}'");
60 if (!&dbGet("user","user", "user=".&dbQuote($param{'SQLUser'}) ) ) {
61 &status("--- Adding user '$param{'SQLUser'}' $dbname/user table...");
63 $query = "INSERT INTO user VALUES ".
64 "('localhost', '$param{'SQLUser'}', ".
65 "password('$param{'SQLPass'}'), ";
67 $query .= "'Y','Y','Y','Y','Y','Y','N','N','N','N','N','N','N','N')";
69 &dbRaw("create(user)", $query);
71 &status("... user information already present.");
74 if (!&dbGet("db","db","db=".&dbQuote($param{'SQLUser'}) ) ) {
75 &status("--- Adding database information for database '$dbname'.");
77 $query = "INSERT INTO db VALUES ".
78 "('localhost', '$dbname', ".
79 "'$param{'SQLUser'}', ";
81 $query .= "'Y','Y','Y','Y','Y','Y','Y','N','N','N')";
83 &dbRaw("create(db)", $query);
85 &status("... db info already present.");
89 &status("Flushing privileges...");
90 $query = "FLUSH PRIVILEGES";
91 &dbRaw("mysql(flush)", $query);