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

==rmdstop -server to stop