2 # setup_tables: setup MYSQL/PGSQL side of things for blootbot.
6 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");
18 my $dbname = $param{'DBName'};
22 print "error: appears that the config file was not loaded properly.\n";
26 if ($param{'DBType'} =~ /mysql/i) {
29 print "Enter root information...\n";
32 chop (my $adminuser = <STDIN>);
37 chop(my $adminpass = <STDIN>);
41 if ($adminuser eq "" or $adminpass eq "") {
42 &ERROR("error: adminuser || adminpass is NULL.");
46 &sqlOpenDB("mysql", "mysql", $adminuser, $adminpass);
48 my $database_exists = 0;
49 foreach $database (&sqlRawReturn("SHOW DATABASES")) {
50 $database_exists++ if $database eq $param{DBName};
52 if ($database_exists) {
53 &status("Database '$param{DBName}' already exists. Continuing...");
55 &status("Creating db ...");
56 &sqlRaw("create(database)", "CREATE DATABASE $param{DBName}");
59 &status("--- Adding user information for user '$param{'SQLUser'}'");
61 if (!&sqlSelect("user", "user", { 'user' => &sqlQuote($param{'SQLUser'}) })) {
62 &status("--- Adding user '$param{'SQLUser'}' $dbname/user table...");
64 $query = "INSERT INTO user VALUES ".
65 "('localhost', '$param{'SQLUser'}', ".
66 "password('$param{'SQLPass'}'), ";
68 $query .= "'Y','Y','Y','Y','Y','Y','N','N','N','N','N','N','N','N')";
70 &sqlRaw("create(user)", $query);
72 &status("... user information already present.");
75 if (!&sqlSelect("db", "db", { 'db' => &sqlQuote($param{'SQLUser'}) })) {
76 &status("--- Adding database information for database '$dbname'.");
78 $query = "INSERT INTO db VALUES ".
79 "('localhost', '$dbname', ".
80 "'$param{'SQLUser'}', ";
82 $query .= "'Y','Y','Y','Y','Y','Y','Y','N','N','N')";
84 &sqlRaw("create(db)", $query);
86 &status("... db info already present.");
90 &status("Flushing privileges...");
91 $query = "FLUSH PRIVILEGES";
92 &sqlRaw("mysql(flush)", $query);