Section 5.1. From a Radiator SQL user database

5.1. From a Radiator SQL user database

The convert program in the goodies directory does this conversion. It understands the following arguments:

convert [-h] [-v] [-update] [-password] [-dbsource dbi:drivername:option]
[-dbusername dbusername] [-dbauth auth] [-validfrom YYYYMMDD]
[-validto YYYYMMDD] [filename ...]

```
-h
```
Print help information and exit
```
-v
```
Print verbose information about inserts and updates
```
-update
```
If the user already exists in the target RAdmin database, update their information. Default is to print a warning and not update the user
```
-password
```
Interprets the filenames specified on the command line as Unix style password files, and inserts or updates the user details, including user name, encrypted password, full name and added date. Disables reading from SQL, and causes -dbsource, -dbusername and -dbauth to be ignored.
```
-dbsource dbi:drivername:option
```
Specifies the data source name of the database to read from. Must be specified unless -password is used. Use standard DBI connection strings, such as for example
```
dbi:Oracle:radiusdb
dbi:FreeTDS:database=master;host=fred;port=1433;
dbi:Pg:dbname=radiator
```
```
-dbusername username
```
Specifies the username to use to connect to the SQL database to read from. dbauth password Specifies the password for dbusername. Not required for some database types.
```
-dbsource
```
Print help information and exit
```
-validfrom
```
Specifies an optional Valid From date for all users affected by this command. Format is any date/time format supported by RAdmin. The default is to not set Valid From date.
```
-validto
```
Specifies an optional Valid To date for all users affected by this command. Format is any date/time format supported by RAdmin. If -validfrom is set, the default is 1 year from the Valid From date, else the default is to not to set Valid To date.

Examples:

perl goodies/convert -password -validfrom tod -validto '6 months' /etc/passwd

User details are read from /etc/passwd. Users that are not already in the RAdmin database are added. Username and encrypted password and full name are added, added date is set to today. The valid from date is set to midnight at the beginning of today, and the valid to date is set to 6 months from today.

perl goodies/convert -dbsource dbi:Oracle:radiusdb \
-dbusername mikem -dbauth fred -update

Connects to the Radiator database on the Oracle SID “radiusdb”, using the Oracle user name mikem, and Oracle password “fred”. All users found in the database are inserted or updated into the RAdmin database. For new users, the Added Date is set to today, but the Valid From and Valid To dates are not set for any users.