SQL database setup - Revision history

Admin: /* myLVS Monitoring prepare */

2015-09-07T17:49:31Z

myLVS Monitoring prepare

← Older revision		Revision as of 17:49, 7 September 2015
Line 60:		Line 60:

	==myLVS Monitoring prepare==		==myLVS Monitoring prepare==
	Note that ~~thie~~ below steps are not needed if you have used the sql import script from the tarball.<br>		Note that the below steps are not needed if you have used the sql import script from the tarball.<br>

	This will show how to setup the command table for nrpe commands for		This will show how to setup the command table for nrpe commands for

2015-09-07T16:28:04Z

Create the Database and the Users

← Older revision		Revision as of 16:28, 7 September 2015
Line 30:		Line 30:

	==Create the Database and the Users==		==Create the Database and the Users==
			Note that thie below steps are not needed if you have used the sql import script from the tarball.<br>
	Create the database, login into myslq:		Create the database, login into myslq:
	# mysql -u root -p		# mysql -u root -p
Line 38:		Line 39:
	Add the demo user into myLVS if not already done, table tblUsers (Already done when importing the sql script):		Add the demo user into myLVS if not already done, table tblUsers (Already done when importing the sql script):
	mysql> insert into tblUsers (userID,name,operations,logview,showcon,searchcon,reset,reboot,search,whois,nslookup,scan,servermanager) values ('1','demo','1','1','1','1','1','1','1','1','1','1','1');		mysql> insert into tblUsers (userID,name,operations,logview,showcon,searchcon,reset,reboot,search,whois,nslookup,scan,servermanager) values ('1','demo','1','1','1','1','1','1','1','1','1','1','1');


	==Command prepare==		==Command prepare==

2015-09-07T16:27:49Z

Remote Access

← Older revision		Revision as of 16:27, 7 September 2015
Line 92:		Line 92:

	=Remote Access=		=Remote Access=
			Note that thie below steps are not needed if you have used the sql import script from the tarball.<br>
	Insert the statements:		Insert the statements:

2015-09-07T16:27:41Z

myLVS Monitoring prepare

← Older revision		Revision as of 16:27, 7 September 2015
Line 60:		Line 60:

	==myLVS Monitoring prepare==		==myLVS Monitoring prepare==
	~~Not all functions~~ are ~~implemented within~~ the ~~GUI, a few manual steps are required to setup remote access~~.		Note that thie below steps are not needed if you have used the sql import script from the tarball.<br>

	This will show how to setup the command table for nrpe commands for		This will show how to setup the command table for nrpe commands for

2015-09-07T16:27:26Z

Webservice prepare

← Older revision		Revision as of 16:27, 7 September 2015
Line 50:		Line 50:

	==Webservice prepare==		==Webservice prepare==
			Note that thie below steps are not needed if you have used the sql import script from the tarball.<br>
	This kind of data is not covered by the myLVS web gui yet but is already imported if the mylvs.sql script has already been imported.		This kind of data is not covered by the myLVS web gui yet but is already imported if the mylvs.sql script has already been imported.

Line 58:		Line 58:
	(1,1,'192.168.2.221','hh',1,0,0,30,0,30,0,200,'Host has been turned on',0,'0','20150727143609','0','0','0',0,0,'0',0,'0'),		(1,1,'192.168.2.221','hh',1,0,0,30,0,30,0,200,'Host has been turned on',0,'0','20150727143609','0','0','0',0,0,'0',0,'0'),
	(2,1,'192.168.2.222','hh',1,0,0,30,0,30,0,200,'Host has been turned on',0,'0','20150727143230','0','0','0',0,0,'0',0,'0');		(2,1,'192.168.2.222','hh',1,0,0,30,0,30,0,200,'Host has been turned on',0,'0','20150727143230','0','0','0',0,0,'0',0,'0');


	==myLVS Monitoring prepare==		==myLVS Monitoring prepare==

2015-09-07T16:27:12Z

Command prepare

← Older revision		Revision as of 16:27, 7 September 2015
Line 41:		Line 41:

	==Command prepare==		==Command prepare==
			Note that thie below steps are not needed if you have used the sql import script from the tarball.<br>
	This kind of data is not covered by the myLVS web gui yet but is already imported if the mylvs.sql script has already been imported.		This kind of data is not covered by the myLVS web gui yet but is already imported if the mylvs.sql script has already been imported.
	mysql> INSERT INTO `tblCommands` (`cmdID`,`enabled`,`name`,`command`,`type`,`type-description`) VALUES		mysql> INSERT INTO `tblCommands` (`cmdID`,`enabled`,`name`,`command`,`type`,`type-description`) VALUES

2015-09-07T16:26:17Z

myLVS Moiotring prepare

← Older revision		Revision as of 16:26, 7 September 2015
Line 59:		Line 59:


	==myLVS ~~Moiotring~~ prepare==		==myLVS Monitoring prepare==
	Not all functions are implemented within the GUI, a few manual steps are required to setup remote access.		Not all functions are implemented within the GUI, a few manual steps are required to setup remote access.
	This will show how to setup the command table for nrpe commands for		This will show how to setup the command table for nrpe commands for

2015-09-07T16:15:29Z

mySQL

← Older revision		Revision as of 16:15, 7 September 2015
Line 22:		Line 22:

	=mySQL=		=mySQL=
			Note that thie below steps are not needed if you have used the sql import script from the tarball.<br>
	*Login sample:		*Login sample:
	root@mylvs01:/# mysql -u root -p		root@mylvs01:/# mysql -u root -p

2015-09-07T16:14:45Z

mySQL

@@ Line 27: / Line 27: @@
 *Change the database:
   mysql> use mylvs;
 ==Command prepare==

2015-09-07T16:14:30Z

Create the Database and the Users

← Older revision		Revision as of 16:14, 7 September 2015
Line 1:		Line 1:


	~~=Create the Database and the Users=~~
	~~Create the database, login into myslq:~~
	~~# mysql -u root -p~~
	~~On the SQL prompt type:~~
	~~mysql> create database mylvs;~~
	~~Create the default mylvs user using the password = demo:~~
	~~mysql> GRANT ALL PRIVILEGES ON mylvs.* TO mylvsuser@localhost IDENTIFIED BY 'demo';~~
	~~Add the demo user into myLVS if not already done, table tblUsers (Already done when importing the sql script):~~
	~~mysql> insert into tblUsers (userID,name,operations,logview,showcon,searchcon,reset,reboot,search,whois,nslookup,scan,servermanager) values ('1','demo','1','1','1','1','1','1','1','1','1','1','1');~~

	=Setup Host Header=		=Setup Host Header=