smart reporter

databases and versions

SmartReporter Database Management This release can use one of these SQL databases:

• MySQL - When you upgrade from R75.40 or earlier to R77, SmartReporter continues to use the legacy • MySQL database. In some cases, upgrading from R75.20 or R75.40 can also use MySQL.

PostgreSQL - All new installations of SmartReporter, from R75.40VS and higher, use the PostgreSQL database. You do database management operations in these ways:

• With the SmartReporter Database Maintenance view • With CLI commands. MySQL and PostgreSQL have different commands and procedures • Changing SmartReporter configuration files

To see which SQL database is installed, run:

grep DefaultDatabase $CPDIR/registry/HKLM_registry.data

If the command returns the string PostgreSQL, the database is PostgreSQL. If the command returns another result, the database is MySQL.

mysql database

username for mysql connections: RMSERVER password can me set in smartreporter gui under management > database maintenance > change database password

mysql binary location: $RTDIR/Database/bin/mysql socket file: use as defined in $RTDIR/Database/conf/my.cnf

example command to connect to local database

$RTDIR/Database/bin/mysql -u RMSERVER -h localhost -p --socket=/opt/CPrt-R75.40/Database/mysql.sock

postgresql

connecting to postgresql database

$CPDIR/database/postgresql/bin/psql -U cp_postgres -p 18272 rt_database

logging and session status

log consolidation session log: $RTDIR/log_consolidator_engine/log/<Session_ID>/lc_rt.log

example of successful log consolidation entry...

Last processed file: 2017-03-01_235900.log
       
The Engine has finished scanning the requested log files.

service stop and start

rmdstop -server to stop

fwaction

fw_action_code |  fw_action_name  

            -1 | 
             0 | consolidated
             1 | encrypt
             2 | approved
             3 | accept
             4 | blocked
             5 | drop
             6 | reject

... and more...