Setup MyLVS: Difference between revisions

From MyLVS
Jump to navigation Jump to search
No edit summary
Line 10: Line 10:
  mysql> create database mylvs;
  mysql> create database mylvs;
Create the default mylvs user:
Create the default mylvs user:
  GRANT ALL PRIVILEGES ON mylvs.* TO mylvsuser@localhost IDENTIFIED BY 'demo';
  mysql> GRANT ALL PRIVILEGES ON mylvs.* TO mylvsuser@localhost IDENTIFIED BY 'demo';
Add myLVS User:
mysql> insert into tblUsers (userID,name,operations,showcon,searchcon,reset,reboot,search,whois,nslookup,scan,servermanager) values ('1','demo','1','1','1','1','1','1','1','1','1','1');
Then exit mysql on run:
Then exit mysql on run:
  mysql -u root -p < lvs.sql
  mysql -u root -p < lvs.sql

Revision as of 17:48, 14 June 2015

Setup mySQL

At the very step we need to setup the database with all the required tables, please use the import script mylvs.sql to do so. You'll find the script within the download archive in /scripts or on the reference vm in /var/www/mylvs/scripts

mysql -u root -p < lvs.sql

Create Database and 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:

mysql> GRANT ALL PRIVILEGES ON mylvs.* TO mylvsuser@localhost IDENTIFIED BY 'demo';

Add myLVS User:

mysql> insert into tblUsers (userID,name,operations,showcon,searchcon,reset,reboot,search,whois,nslookup,scan,servermanager) values ('1','demo','1','1','1','1','1','1','1','1','1','1');

Then exit mysql on run:

mysql -u root -p < lvs.sql

Setup Apache

Get and copy the Apache template to:

/etc/apache2/sites-enabled/mylvs.conf

Run:

a2ensite mylvs.conf