Previous page Section 3.1.2.5. DBD::SQLite Section 3.1.2.6. Other Databases (15 / 86)   Table of Contents Section 3.1.3. Install the RAdmin CGI scripts on your RAdmin host Next page

3.1.2.6. Other Databases Previous topic Parent topic Child topic Next topic

We have not provided installation scripts for other databases. You will need to follow these steps:
  1. Following your SQL vendor's instructions, create an empty database
  2. Create a database user that has permission to create tables in the new database
  3. Set the new database users password
  4. Edit Radmin/Sql.pm, and configure it so that RAdmin can connect to the SQL database, using the connection name rules for your selected DBD module, plus the user name and password you created above.
  5. Create the tables by running 
    perl createdb.pl -create
    This will attempt to log in to the database using the details you entered into Radmin/Sql.pm, then create the tables described in Radmin/Schema.pm
  6. If the previous step fails, it may be due to unusual table creation syntax for your SQL server. If so, you may need to hand edit a file to create the tables for your database. You can see what createdb.pl is trying to do by running it like this: 
    perl createdb.pl -create -n -d
  7. Install the basic data into the database with: 
    perl createdb.pl basicdb.dat radattrs.dat
  8. Try to automate the entire process and send us an installXXX.sh so others can benefit from your experience.
Previous page Section 3.1.2.5. DBD::SQLite Section 3.1.2.6. Other Databases (15 / 86)   Table of Contents Section 3.1.3. Install the RAdmin CGI scripts on your RAdmin host Next page