Installing database server, preparing databases

Skip to end of metadata
Go to start of metadata

LOGalyze installer package does not include installation of the database server. From the software listed in chapter 2.1.4 choose the one suiting your needs best. The procedure of the database server installation is included in the product document.
Running the following SQL commands the database schemes used by LOGalyze and their users can be created. In order to run these, appropriate authorization is necessary. SQL commands suppose that the administration interface and the log-analyzing motor are on the same server as the database.
MySQL 5.1
CREATE DATABASE `logalyzeconf` CHARACTER SET UTF8 COLLATE UTF8_UNICODE_CI;
CREATE DATABASE `logalyzedata` CHARACTER SET UTF8 COLLATE UTF8_UNICODE_CI;
GRANT ALL PRIVILEGES ON logalyzeconf.* TO 'logalyzeconf'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON logalyzeconf.* TO 'logalyzeconf'@'127.0.0.1' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON logalyzedata.* TO 'logalyzedata'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON logalyzedata.* TO 'logalyzedata'@'127.0.0.1' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
SET GLOBAL event_scheduler=on;
Oracle 10g

Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.