Apricot- Installation instructions

Linux Server

1. Login into mysql server as root and create a database
eg:-
[..]# mysql -u root -p
Enter password:
mysql> create database mydatabase;

2. Create a user for the database with all privileges, and access from localhost and foreign hosts
eq:-
mysq> grant all privileges on mydatabase.* to 'admin'@'localhost' identified by 'mypassword' with grant option;
mysq> grant all privileges on mydatabase.* to 'admin'@'%' identified by 'mypassword' with grant option;

3. Copy Apricot_server.jar to any directory.

4. Run command

i) java -jar Apricot_server.jar -n "database name" "databaseusername" "database user password"
This command creates tables in the provided database. A fresh database and a user with all
privileges on the database must be provided. The database details(database name,user nameand password) are permanently stored in the server.
ii) java -jar Apricot_server.jar -r "database name" "databaseusername" "database user password"
This command resets the database details(database name, username and password) which were stored in the server. The provided database must contain all needed tables in it, the server WILL NOT create any tables on it.
iii) java -jar Apricot_server.jar
This command starts the server with previously stored details(database name, user name and password).

Alternatively, you can use the "&" command to make this program run in the background. ie..
bash# java -jar Apricot_server.jar &

Linux Client

1. Copy Apricot_client.jar to any directory.

2. Apricot_server running

3. Run command
java -jar Apricot_client.jar

4. Enter username and password

5. Enter server IP address
eg:- localhost or 127.0.0.1 if Apricot_server is running on same machine
Note:- By default software username is "administrator" with password "mypassword"

Windows Server

1. Login into mysql server as root and create a database
eg:-
[..]# mysql -u root -p
Enter password:
mysql> create database mydatabase;

2. Create a user for the database with all privileges, and access from localhost and foreign hosts
eq:-
mysq> grant all privileges on mydatabase.* to 'admin'@'localhost' identified by 'mypassword' with grant option;
mysq> grant all privileges on mydatabase.* to 'admin'@'%' identified by 'mypassword' with grant option;

3. Run setup.exe(Apricot_server) and install to any directory

4. Take a command prompt, change to Apricot_server installed directory and run command

i) Apricot_server.exe -n "database name" "databaseusername" "database user password"
This command creates tables in the provided database. A fresh database and a user with all
privileges on the database must be provided. The database details(database name,user name and password) are permanently stored in the server.
ii) Apricot_server.exe -r "database name" "databaseusername" "database user password"
This command resets the database details(database name, username and password) which were stored in the server.
The provided database must contain all needed tables in it, the server WILL NOT create any tables on it.
iii) Apricot_server.exe
This command starts the server with previously stored details(database name, user name and password).

Alternatively, you can use the desktop icon to start the application(starts with previously stored details).

Windows Client

1.Install using setup.exe to any folder.

2. Apricot_server running

3. Run command
java -jar Apricot_client.jar

4. Enter username and password

5. Enter server IP address
eg:- localhost or 127.0.0.1 if Apricot_server is running on same machine
Note:- By default software username is "administrator" with password "mypassword"