Difference between revisions of "smart reporter"
(Created page with " rmdstop -server to stop category:loggin") |
|||
| Line 1: | Line 1: | ||
| + | ==databases and versions== | ||
| − | rmdstop -server to stop | + | 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. | ||
| + | |||
| + | |||
| + | |||
| + | connecting to postgresql database | ||
| + | $CPDIR/database/postgresql/bin/psql -U cp_postgres -p 18272 rt_database | ||
| + | |||
| + | ==rmdstop -server to stop | ||
[[category:loggin]] | [[category:loggin]] | ||
Revision as of 19:28, 30 April 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.
connecting to postgresql database $CPDIR/database/postgresql/bin/psql -U cp_postgres -p 18272 rt_database
==rmdstop -server to stop
