Creating the server
The server on which the software is based is created with the DBMS PostgreSQL. You must know the access port to the database created, as well as the username and password to access it. To facilitate the preliminary configuration of the database by Windows users, it is advisable to download the client for PostgreSQLpgadmin, which offers a graphical interface that greatly simplifies the creation of the database.
Note: Database credentials will be required both during the database initialization and during the start of
ServerES.
PostgreSQL must be running and with the database started while the Emotional Songs server is running.
Initialization of the database
If this is your first time using Emotional Songs, you must first initialize the database previously created with PostgreSQL. This will create tables and relationships between them, as well as populating the song repository.
Database tables and relations creation tool
After downloading PostgreSQL, creating and starting your own database, you can use a specific tool provided below that, once executed, will populate the database of the necessary tables and songs (provided in the .txt file, always present in the support_tool folder).
It will be enough to start with a double click the .jar file, enter the username, password and port of the database and, if you want to load all the songs, also the data of the song repository (entering the absolute path of the file .txt).
Note: the repository file uses the string
£SEP£as separator between tuples.
Regardless of the operating system, clients and the server must be connected to the same network!
Click here to download the RepoData.txt file with the songs repository that will be loaded onto Emotional Songs database.
Windows
MacOS
To initialize the database on MacOS operating system, simply download .zip file that contains the initialization tool, clicking on the button below.
Linux and other platforms
The database initialization tool is available as a .jar file for Linux and other platforms that support those type of executable files.
ServerES
To make Emotional Songs recognize the services offered by the database, it is necessary to start the ServerES software on the server host machine.
ServerES is downloadable from the following links:
Windows (.exe file)
MacOS (.app file)
Linux and other platforms (.jar file)
To make Emotional Songs recognize the services offered by the database, it is necessary to start the database connection tool, called DataBaseInitializer.
Once started, the tool will request database data, such as DB name and password, and the port number on which it is reachable.
Once all data are entered, when the database will be connected successfully, the software shows a window with the database connection log. The last one is the same port chosen during database creation with PostgreSQL.
In this window you can take the local IP address of the server and the port to which you can connect via Emotional Songs to get the services necessary for its operations.
At least, you can export the connection log in a .txt file, if needed, just clicking the specific button.