#!/bin/bash

PATH=/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/sbin:/usr/local/bin:.

. /etc/netflow/install.conf

echo "This script will recover administrator's password for NetFlow Analyzer."
echo "Press <ENTER> to continue..."
read
mydb_create=0
while (( !$mydb_create ))
do
    if [ ! -f /netflow/single ]; then
      read -p "Type root username for access to mysql database [root]:" username
      read -p "Type root password for access to mysql database []:" password
    fi
    MYSQLOPTION="$MYSQLOPT"
    if [ -z "$username" ]; then
	MYSQLOPTION="$MYSQLOPTION -u root"
    fi
    if [ -n "$password" ]; then
	MYSQLOPTION="$MYSQLOPTION --password=$password"
    fi
    MYSQL="$MYSQL_BIN $MYSQLOPTION"
    MYSQLDUMP="$MYSQLDUMP_BIN $MYSQLOPTION"
    echo "CREATE DATABASE IF NOT EXISTS $DATABASE;" | $MYSQL -s
    mydb_create=$(( ! $? ))
done

export MYSQL="$MYSQL"
export MYSQLDUMP="$MYSQLDUMP"
export DATABASE="$DATABASE"
export OLD_VERSION="$OLD_VERSION"

echo -n "Recovering admin account - username: admin password: nfadmin"
echo "REPLACE x_user (name,pass,enable,admin) VALUES ('admin',password('nfadmin'),1,1);" | $MYSQL -s $DATABASE
echo " DONE."
