3.2.3.5. Create the RAdmin tables and complete the installation Previous topic Parent topic Child topic Next topic

By now, you should have installed Perl, plus the DBI and DBD-ODBC perl modules. If so, you can now use the createdb.pl program supplied with RAdmin to create the database tables that RAdmin needs.
  1. Start a Command Prompt window.
  2. Change directories to the RAdmin distribution
  3. Edit the file Radmin\Sql.pm in your RAdmin distribution directory. This is the file that tells all the RAdmin programs how to connect to the SQL database. Ensure that it is set up like this:
    $Radmin::config{DBSource} = ’dbi:ODBC:Radmin’;
    $Radmin::config{DBUsername} = ’radmin’;
    $Radmin::config{DBAuth} = ra+9+9dminpw’;
    Where “Radmin” is the name of the ODBC System DSN you created above, “radmin” is the SQL database login name you created above, and “ra+9+9dminpw” is the password for that user.
  4. Run the command:
    perl createdb.pl -create -- basicdb.dat radattrs.dat
    This will create all the tables and data that RAdmin needs