As WipeDrive, Detalys, and Hardware Inventory can save the results of their operation directly to a SQL database, we decided to provide a basic manual with instructions on how to set up a MYSQL Server Express in your Windows machine. Your SQL server must be accessible from any machine you want to save the log. In this manual, we will not mention any IP settings because that will depend on your environment and network layout.
Installing Postgre SQL
Start by installing the latest version of the Postgre installer for you machine. The installer can be found here: Download PostgreSQL (enterprisedb.com)
After the download is complete, open, and run the installer. Press “Next” on the set-up screen. You will then be prompted to choose the location for the install. We recommend leaving this option the same. After you have chosen a location press “Next”
On the next screen it will ask what components you would like to install. Leave all of them selected and press “Next” It will again ask for a download location, leave this the same and press “Next”
It will prompt you to enter a password for the database superuser. Make sure it will be something you will remember. After entering a password, press “Next”
On the next page it will ask for the port number the sever will listen to, leave this the same and press “Next” The next page will ask for a Locale for the new database cluster, leave this the same and press “Next” Press “Next“ again Until you start installing the Postgre server
After the installation process is complete Press “Finish”
Verifying the Installation
There are multiple ways to verify that the server has been installed correctly. You can connect to a database using some client applications like pgAdmin or psql shell.
Search for the psql shell in the windows search bar and open it.
Enter all the necessary information like server, database, port, username, and password and press “Enter”
Use the command “SELECT version();“you will see the following result:
Page Break
Creating a Server
Open pgAdmin, you can do this by typing “pgAdmin” in the windows search bar. Here we will want to create a server to host our database. We can do this by pressing “Add new server”
Enter in the name you’d like and Navigate to the connection tab and enter a name for the Server name. After entering a name go to the “Connections” tab next to the “General” tab. Here we will enter some network fields. In the host name/ address field, enter “localhost” leave the port, maintenance, and username fields the same. In the password field enter in the password you entered during the installation process and Press “Save”
You should now have a server on your local machine and now we can move to making a database.
Page Break
Creating a Database
After successfully creating the server, we now need to make a database for the WipeDrive initializer tool and Query tool to populate and view the database entries.
With the server open press, the drop-down arrow on the database name. In the drop down we should see “Databases” Right click on “Databases” and press “Create”
At the pop-up, enter a name for the database and press “save”
After creating the database, we can now initialize it with the WipeDrive initializer tool. More on how to initialize the database can be found here: Setting Up an Existing SQL Database for use with WipeDrive : WipeDrive