Difference between revisions of "smart reporter"
Line 33: | Line 33: | ||
$RTDIR/Database/bin/mysql -u RMSERVER -h localhost -p --socket=/opt/CPrt-R75.40/Database/mysql.sock | $RTDIR/Database/bin/mysql -u RMSERVER -h localhost -p --socket=/opt/CPrt-R75.40/Database/mysql.sock | ||
− | + | ==postgresql== | |
connecting to postgresql database | connecting to postgresql database | ||
− | + | CPDIR/database/postgresql/bin/psql -U cp_postgres -p 18272 rt_database | |
==rmdstop -server to stop | ==rmdstop -server to stop | ||
[[category:loggin]] | [[category:loggin]] |
Revision as of 20:36, 2 May 2017
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