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.
- Start a Command Prompt window.
- Change directories to the RAdmin distribution
- 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.
- Run the command:
perl createdb.pl -create -- basicdb.dat radattrs.dat
This
will create all the tables and data that RAdmin needs