Setup MyLVS: Difference between revisions

From MyLVS
Jump to navigation Jump to search
Line 13: Line 13:
Add myLVS User:
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');
  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=
=Setup Apache=

Revision as of 17:50, 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');

Setup Apache

Get and copy the Apache template to:

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

Run:

a2ensite mylvs.conf