Difference between revisions of "smart reporter"

From cpwiki.net
Jump to: navigation, search
Check Point Profressional Services
(Created page with " rmdstop -server to stop category:loggin")
 
(tables)
 
(7 intermediate revisions by one user not shown)
Line 1: Line 1:
  
 +
==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
 +
        <br>The Engine has finished scanning the requested log files.
 +
 +
==service stop and start==
  
 
rmdstop -server to stop
 
rmdstop -server to stop
 +
 +
==tables==
 +
 +
== fwaction ==
 +
 +
fw_action_code |  fw_action_name 
 +
<br>            -1 |
 +
              0 | consolidated
 +
              1 | encrypt
 +
              2 | approved
 +
              3 | accept
 +
              4 | blocked
 +
              5 | drop
 +
              6 | reject
 +
... and more...
 +
 +
 +
  
 
[[category:loggin]]
 
[[category:loggin]]

Latest revision as of 02:27, 6 May 2017

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...