smart reporter - Revision history

Nighthawk: /* tables */

2017-05-06T02:27:24Z

‎tables

2017-05-06T01:29:46Z

2017-05-05T13:26:48Z

‎logging and session status

2017-05-05T13:26:31Z

2017-05-02T20:36:44Z

‎postgresql

2017-05-02T20:36:36Z

2017-05-02T05:38:15Z

2017-04-30T19:28:00Z

2017-04-30T01:55:58Z

Created page with " rmdstop -server to stop category:loggin"

New page

rmdstop -server to stop

[[category:loggin]]

@@ Line 51: / Line 51: @@
 ==tables==
-...
+== fwaction ==
 [[category:loggin]]

@@ Line 43: / Line 43: @@
   Last processed file: 2017-03-01_235900.log
+         <br>The Engine has finished scanning the requested log files.
          The Engine has finished scanning the requested log files.
-−
 ==service stop and start==

@@ Line 37: / Line 37: @@
   $CPDIR/database/postgresql/bin/psql -U cp_postgres -p 18272 rt_database
-==rmdstop -server to stop
+==logging and session status==
 [[category:loggin]]

@@ Line 35: / Line 35: @@
 ==postgresql==
 connecting to postgresql database
-  CPDIR/database/postgresql/bin/psql -U cp_postgres -p 18272 rt_database
+  $CPDIR/database/postgresql/bin/psql -U cp_postgres -p 18272 rt_database
 ==rmdstop -server to stop
 [[category:loggin]]

← Older revision		Revision as of 05:38, 2 May 2017
Line 22:		Line 22:
	another result, the database is MySQL.		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

← Older revision		Revision as of 19:28, 30 April 2017
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]]