smart reporter

From cpwiki.net
Revision as of 02:27, 6 May 2017 by Nighthawk (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
Check Point Profressional Services

Contents

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

tables

fwaction

fw_action_code |  fw_action_name  

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

... and more...