Configuration
Database preparation
You will need to give create the database by hand using the MySQL command line client; This is relatively simple and will require that you have the appropriate permissions:
bash$ mysql -uroot -pd3vt3st mysql> use mysql; Database changed mysql> CREATE DATABASE IF NOT EXISTS cvebrowser; Query OK, 1 row affected (0.05 sec) |
Also is required than you create a user with the appropriate permissions so the JDBC client can connect; For that you will need the IP address of the machine that will run the importer and the search engine:
 | There is more than one way to assign the permissions on MySQL, please check their on-line manual for more details. Be advised to use a different user and password combination than the one provided on this manual, otherwise you will be exposing yourself to remote attackers. |
mysql> GRANT ALL ON cvebrowser.* TO 'cvebrowser'@'127.0.0.1' IDENTIFIED BY 'cv3br0ws3r'; Query OK, 0 rows affected (0.02 sec) mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) |
Once the database and user are created then you need to create the application tables and to load the initial metadata:
mysql> use cvebrowser Database changed mysql> source /opt/cvebrowser/etc/create_tables.sql Query OK, 0 rows affected (0.01 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.03 sec) mysql> source /opt/cvebrowser/etc/load_metadata.sql Query OK, 0 rows affected (0.00 sec) Query OK, 1 row affected (0.02 sec) Query OK, 1 row affected (0.00 sec) Query OK, 1 row affected (0.00 sec) Query OK, 1 row affected (0.00 sec) Query OK, 1 row affected (0.00 sec) Query OK, 1 row affected (0.01 sec) Query OK, 1 row affected (0.00 sec) ... (OK, you get the point ;)) |
Now the database is ready to be used.