COMMAND_RCMDMGNT_SQLCREDS

Return HOME or USAGE

Name

rcmdmgnt - Parallel Remote Command Configuration Manager

Sqlcreds_Command

The credentials to access the database must be encoded to reduce the
risk of unauthorized access. The following command will provide the
encoded keys to configure in the Config File.

 # rcmdmgnt -sqlcreds [sql-options]
         -read [login:password:confirm]
        -update [login:passwod:confirm]

The 'colon' is required between the values.

If the 'read' and/or 'update' option are omitted, they will be prompted.

Sqlcreds_Options

drive=[sqlite|mysql|postgres]
    default: sqlite

db=[value]
    default: RCMD

dbfile=[fullname]
    default: /var/lib/rcmd/db/rcmd.db, required for db=sqlite

read=[login:password:confirm]
    no defaults, not required for db=sqlite

server=[value]
    no defaults, not required for db=sqlite

schema=[value]
    no defaults, not required for db=sqlite, required only if defined on
    database service

table=[value]
    defaults: node

update=[login:password:confirm]
    no defaults, not required for db=sqlite

NOTE: The password must be at least 8 characters long and contain at least the following characters: [a-z], [A-Z], [0-9] and [!@#$%&*-+]

NOTE: The 'update_creds' will is required for the 'rcmdmgnt' command only.

Generic_Options

 config, debug, non-interactive, noheards, notitle

Sqlcreds_Examples

1) based sqlite database

     # rcmdmgnt -sqlcreds

     Login to Read/Only : myread
     Password to Read/Only [myread]  : [ ******** ]
     Confirm Password [myread]  : [ ******** ]

     Login to Updates : myupdate
     Password to Updates [myupdate]  : [ ******** ]
     Confirm Password [myupdate]  : [ ******** ]

     The following line must be add in the [config-file]:

     catalog read_creds [my-encoded-key]
     catalog update_creds [my-encoded-key]

     Command completed

NOTE: The 'read_creds' will be used by the 'rcmd' and 'rcmdmgnt' command. You must copy/paste the values into /etc/rcmd.d/rcmd.conf file.

2) based mysql/mariadb

     # rcmdmgnt -sqlcreds -driver mysql -db [mydb] -server [myhost] -schema [myschema] -table [mytable]
     ...
     catalog driver mysql
     catalog db mydb
     catalog server myserver
     catalog read_creds [my-encoded-key]
     catalog update_creds [my-encoded-key]
     ...

     Command completed

NOTE: the 'mydb' and 'myhost' values are required. The 'myschema' and 'mytable' are required if no defaults in use. You must copy/paste the values into /etc/rcmd.d/rcmd.conf file.

3) based postgresql

     # rcmdmgnt -sqlcreds -driver postgres
     ...
     catalog driver postgres
     catalog db mydb
     catalog server myserver
     catalog read_creds [my-encoded-key]
     catalog update_creds [my-encoded-key]
     ...

     Command completed

NOTE: the 'mydb' and 'myhost' values are required. The 'myschema' and 'mytable' are required if no defaults in use. You must copy/paste the values into /etc/rcmd.d/rcmd.conf file.

4) To update the /etc/rcmd.d/rcmd.conf use 'refresh' option

     # rcmdmgnt -sqlcreds -refresh
     ...
     Loading current config file
     No credentials is required for SQLite
     Creating new config file
     Updating new config file
     Command completed

     # rcmdmgnt -sqlcreds -refresh -driver mysql
     ...
     Loading current config file
     The read and update credentials will be replaced!
     Creating new config file
     Updating new config file
     Command completed

     # rcmdmgnt -sqlcreds -refresh -driver postgres
     ...
     Loading current config file
     The read and update credentials will be replaced!
     Creating new config file
     Updating new config file
     Command completed

ENDED