Public | Automated Build

Last pushed: 2 years ago
Short Description
Short description is empty for this repo.
Full Description

MultiDBs-KeywordSearchR-Server


DISCRIPTION

Keyword Search Relational project is a Google like keyword search through all registered stores based on relational index approach. We directly collaborates with MetaStore and PrestoDB Query projects. Datasource information is passed to us as parameter from Metastore team once a new database connection is added. Then our programs take actions to generate corresponding SQL queries and send them to PrestoDB team by requesting their REST service. After getting the query results from PresoDB, indexes are built for each entry in the databases for more efficient keyword search.


HOW TO START?

1.Steps to set up the project

(1) Please download the setup.sh first on your local machine. (Click the download button in the right corner)
Suppose you download the setup.sh on /opt. Then run "cd /opt"

(2) In the terminal, input "sudo chmod +x setup.sh"(without double quotation mark) to modify the permission.

(3) run "./setup.sh"(without double quotation mark).

(4) When the MySQL is installing, the username you set should be root, and the password should be root too.

2.Then you need to open mysql port 3306 to the public. Open mysql port 3306 to public (enabling remote access)
To check if your mysql port 3306 is open to public, follow these two steps:
(1) Login to the server by using "mysql -u root -proot"
(2) run this command:

sudo lsof -i -P | grep :3306

You will probably see this at the end of the line:

0t0 TCP localhost:3306 (LISTEN)

This means that your mysql is only available to localhost (the server machine), not open to public.
Otherwise, it should be "0t0 TCP *:3306 (LISTEN)".

(3)
To make the mysql 3306 port public accessible, follow these commands in the terminal:

sudo nano /etc/mysql/my.cnf

We need to edit the mysql config file using nano. Use down arrow to scroll down and find "[mysqld]"

Then try to find a line "bind-address =127.0.0.1"

Add a '#' in front of that line to disable it

start a new line, with content "bind-address =0.0.0.0"

Save the file by using ctrl + O.

Exit by ctrl + X.

(4)
sudo /etc/init.d/mysql restart

If fails, check if the content of my.cnf file has been edited. And simply run the command again.

If succeeds, run the following to check port:

(5)
sudo lsof -i -P | grep :3306

And now you should be able to see something very similar to the following if everything is correct:

mysqld 5970 mysql 10u IPv4 3452154 0t0 TCP *:3306 (LISTEN)

3.If you run successfully, you can run "lsof -i:7654", then you can see information of the process.

Now you can see our main webpage on your local machine. Hit : localhost

If you update, run "ssh stop-server.sh" to stop the server and rebuild the javacode first, then run "ssh start-servers.sh" to restart the server.

Docker Pull Command
Owner
evgenykarataev

Comments (0)