As default Collect Earth is setup to use SQLite as the database that stores the collected data. In order to use a server-based solution (*PostgreSQL*) so that several PCs running Collect Earth can share the same data, the user must set up the database connection. **INSTALL POSTGRESQL** Install [PostgreSQL server][1] in a computer that can be reached by the other PCs, whether through the internet or within the intranet. After you install PostgreSQL run the pgAdmin III application that should also have been installed when the PostgreSQL was installed. You should login to the DB using the postgres user (usual passwords would be postgres or admin, but this depends on what you set when installing the database at first) You should also create a new Login Role ( in the Login Roles branch under the server ), for instance you can call it `collectearth` with password `collectearth` ( this is set in the definition tab ) Step 1 : Create "collectearth" login roles ![alt text][2] Step 1.A : Set long name "collectearth" ![alt text][3] Step 1.B : Set the privileges for the user ![alt text][4] Step 2: Create database. ![alt text][5] Step 2,A: Call it also "collectearth" and set "collectearth" as the owner ![alt text][6] Step 2.B : In the " privileges" grant "collectearth" full control of the database ![alt text][7] Step 3: Create a schema within your new database and call it **"collect"** , Very important to keep this name as other names will provoke an exception! ![alt text][8] **Configure the Database** By default PostgreSQL is setup so the database cannot be accessed from outside the localhost (the computer where the server is installed ). In Windows we need to change this ( [check for more info here][9] ) Go the folder where the PostgreSQL has been installed. By default it should be : `C:\Program Files\postgresql*VERSION_NUMBER*\data` ( or `C:\Program Files\postgresql*VERSION_NUMBER*\data\pg10` for Postgres 10) Open the file called **pg_hba.conf** and append this line to the list of accepted connections : host all all 0.0.0.0/0 trust md5 This means that the database accepts now connections from any IPs ( you can tweak this to accept connection only from you local network : [see the documentation][10] ) Now on the same folder open the file **postgresql.conf** and change the line where it say `listen_addresses`. set it to : listen__addresses='*' At this stage you need to **restart PostgreSQL**. Since it is installed as a service (usually) in Windows the fastest way is to just restart the computer. At the end the Object browser in the pgAdmin should look like this: ![alt text][11] **SET UP COLLECT EARTH** Now you should open Collect Earth and got to the main menu *Tools->Properties* and then go to the *operation mode* tab. In that tab fill the fields like in the image attached ( the XXX.XXX.XXX.XXX is your IP address. You can see the current IP address of your computer on the same dialog (see image) ![alt text][12] You should check that the connection is working by clicking on the smartly titled "Test Connection" button!! Click on Save & Apply changes and now you should see that Collect Earth has populated the collect schema in the Database with all the tables necessary for the Collect to store data. **NOW CHECK THAT OTHER USERS CAN CONNECT TO THE DATABASE** If this does not happen, review that the PostgreSQL Database is reachable from outside your PC. If the database can be accessed from outside the PC then maybe there is a firewall configuration that is preventing the computer to connect to the PostgreSQL server. FINALLY - CONFIGURE THE CEP FILE -------------------------------- If you want that the CEP file that you distribute to other users carry this information, so that you dont need to make them configure the DB connection manually, then you can modify the contents of the file "earth.properties" inside the CEP file (remember you can open a CEP file with an application like WinRAR or WinZip as it really is just a ZIP file) You will need to substitue these lines (of course with your own data for the IP, DB username and DB password) db_driver=POSTGRESQL db_host=192.168.89.2 db_name=collectearth db_password=collectearth db_port=5432 db_username=collectearth [1]: http://www.postgresql.org/ [2]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-20-34.png [3]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-24-21.png [4]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-21-19.png [5]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-21-46.png [6]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-22-52.png [7]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-23-30.png [8]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-24-02.png [9]: http://www.cyberciti.biz/tips/postgres-allow-remote-access-tcp-connection.html [10]: http://www.postgresql.org/docs/9.1/static/auth-pg-hba-conf.html [11]: http://www.openforis.org/support/upfiles/pgAdmin3_2018-05-10_14-32-31.png [12]: http://www.openforis.org/support/upfiles/javaw_2017-03-28_02-46-19.png

As default Collect Earth is setup to use SQLite as the database that stores the collected data. In order to use a server-based solution (*PostgreSQL*) so that several PCs running Collect Earth can share the same data, the user must set up the database connection. **INSTALL POSTGRESQL** Install [PostgreSQL server][1] in a computer that can be reached by the other PCs, whether through the internet or within the intranet. After you install PostgreSQL run the pgAdmin III application that should also have been installed when the PostgreSQL was installed. You should login to the DB using the postgres user (usual passwords would be postgres or admin, but this depends on what you set when installing the database at first) You should also create a new Login Role ( in the Login Roles branch under the server ), for instance you can call it `collectearth` with password `collectearth` ( this is set in the definition tab ) Step 1 : Create "collectearth" login roles ![alt text][2] Step 1.A : Set long name "collectearth" ![alt text][3] Step 1.B : Set the privileges for the user ![alt text][4] Step 2: Create database. ![alt text][5] Step 2,A: Call it also "collectearth" and set "collectearth" as the owner ![alt text][6] Step 2.B : In the " privileges" grant "collectearth" full control of the database ![alt text][7] Step 3: Create a schema within your new database and call it **"collect"** , Very important to keep this name as other names will provoke an exception! ![alt text][8] **Configure the Database** By default PostgreSQL is setup so the database cannot be accessed from outside the localhost (the computer where the server is installed ). In Windows we need to change this ( [check for more info here][9] ) Go the folder where the PostgreSQL has been installed. By default it should be : `C:\Program Files\postgresql*VERSION_NUMBER*\data` ( or `C:\Program Files\postgresql*VERSION_NUMBER*\data\pg10` for Postgres 10) Open the file called **pg_hba.conf** and append this line to the list of accepted connections : host all all 0.0.0.0/0 trust This means that the database accepts now connections from any IPs ( you can tweak this to accept connection only from you local network : [see the documentation][10] ) Now on the same folder open the file **postgresql.conf** and change the line where it say `listen_addresses`. set it to : listen__addresses='*' At this stage you need to **restart PostgreSQL**. Since it is installed as a service (usually) in Windows the fastest way is to just restart the computer. At the end the Object browser in the pgAdmin should look like this: ![alt text][11] **SET UP COLLECT EARTH** Now you should open Collect Earth and got to the main menu *Tools->Properties* and then go to the *operation mode* tab. In that tab fill the fields like in the image attached ( the XXX.XXX.XXX.XXX is your IP address. You can see the current IP address of your computer on the same dialog (see image) ![alt text][11] text][12] You should check that the connection is working by clicking on the smartly titled "Test Connection" button!! Click on Save & Apply changes and now you should see that Collect Earth has populated the collect schema in the Database with all the tables necessary for the Collect to store data. **NOW CHECK THAT OTHER USERS CAN CONNECT TO THE DATABASE** If this does not happen, review that the PostgreSQL Database is reachable from outside your PC. If the database can be accessed from outside the PC then maybe there is a firewall configuration that is preventing the computer to connect to the PostgreSQL server. FINALLY - CONFIGURE THE CEP FILE -------------------------------- If you want that the CEP file that you distribute to other users carry this information, so that you dont need to make them configure the DB connection manually, then you can modify the contents of the file "earth.properties" inside the CEP file (remember you can open a CEP file with an application like WinRAR or WinZip as it really is just a ZIP file) You will need to substitue these lines (of course with your own data for the IP, DB username and DB password) db_driver=POSTGRESQL db_host=192.168.89.2 db_name=collectearth db_password=collectearth db_port=5432 db_username=collectearth [1]: http://www.postgresql.org/ [2]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-20-34.png [3]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-24-21.png [4]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-21-19.png [5]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-21-46.png [6]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-22-52.png [7]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-23-30.png [8]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-24-02.png [9]: http://www.cyberciti.biz/tips/postgres-allow-remote-access-tcp-connection.html [10]: http://www.postgresql.org/docs/9.1/static/auth-pg-hba-conf.html [11]: http://www.openforis.org/support/upfiles/javaw_2017-03-28_02-46-19.png http://www.openforis.org/support/upfiles/pgAdmin3_2018-05-10_14-32-31.png [12]: http://www.openforis.org/support/upfiles/javaw_2017-03-28_02-46-19.png

As default Collect Earth is setup to use SQLite as the database that stores the collected data. In order to use a server-based solution (*PostgreSQL*) so that several PCs running Collect Earth can share the same data, the user must set up the database connection. **INSTALL POSTGRESQL** Install [PostgreSQL server][1] in a computer that can be reached by the other PCs, whether through the internet or within the intranet. After you install PostgreSQL run the pgAdmin III application that should also have been installed when the PostgreSQL was installed. You should login to the DB using the postgres user (usual passwords would be postgres or admin, but this depends on what you set when installing the database at first) You should also create a new Login Role ( in the Login Roles branch under the server ), for instance you can call it `collectearth` with password `collectearth` ( this is set in the definition tab ) Step 1 : Create "collectearth" login roles ![alt text][2] Step 1.A : Set long name "collectearth" ![alt text][3] Step 1.B : Set the privileges for the user ![alt text][4] Step 2: Create database. ![alt text][5] Step 2,A: Call it also "collectearth" and set "collectearth" as the owner ![alt text][6] Step 2.B : In the " privileges" grant "collectearth" full control of the database ![alt text][7] Step 3: Create a schema within your new database and call it **"collect"** , Very important to keep this name as other names will provoke an exception! ![alt text][8] **Configure the Database** By default PostgreSQL is setup so the database cannot be accessed from outside the localhost (the computer where the server is installed ). In Windows we need to change this ( [check for more info here][9] ) Go the folder where the PostgreSQL has been installed. By default it should be : `C:\Program Files\postgresql*VERSION_NUMBER*\data` ( or `C:\Program Files\postgresql*VERSION_NUMBER*\data\pg10` for Postgres 10) Open the file called **pg_hba.conf** and append this line to the list of accepted connections : host all all 0.0.0.0/0 trust This means that the database accepts now connections from any IPs ( you can tweak this to accept connection only from you local network : [see the documentation][10] ) Now on the same folder open the file **postgresql.conf** and change the line where it say `listen_addresses`. set it to : listen__addresses='*' At this stage you need to restart PostgreSQL. **restart PostgreSQL**. Since it is installed as a service (usually) in Windows the fastest way is to just restart the computer. **SET UP COLLECT EARTH** Now you should open Collect Earth and got to the main menu *Tools->Properties* and then go to the *operation mode* tab. In that tab fill the fields like in the image attached ( the XXX.XXX.XXX.XXX is your IP address. You can see the current IP address of your computer on the same dialog (see image) ![alt text][11] You should check that the connection is working by clicking on the smartly titled "Test Connection" button!! Click on Save & Apply changes and now you should see that Collect Earth has populated the collect schema in the Database with all the tables necessary for the Collect to store data. **NOW CHECK THAT OTHER USERS CAN CONNECT TO THE DATABASE** If this does not happen, review that the PostgreSQL Database is reachable from outside your PC. If the database can be accessed from outside the PC then maybe there is a firewall configuration that is preventing the computer to connect to the PostgreSQL server. FINALLY - CONFIGURE THE CEP FILE -------------------------------- If you want that the CEP file that you distribute to other users carry this information, so that you dont need to make them configure the DB connection manually, then you can modify the contents of the file "earth.properties" inside the CEP file (remember you can open a CEP file with an application like WinRAR or WinZip as it really is just a ZIP file) You will need to substitue these lines (of course with your own data for the IP, DB username and DB password) db_driver=POSTGRESQL db_host=192.168.89.2 db_name=collectearth db_password=collectearth db_port=5432 db_username=collectearth [1]: http://www.postgresql.org/ [2]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-20-34.png [3]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-24-21.png [4]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-21-19.png [5]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-21-46.png [6]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-22-52.png [7]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-23-30.png [8]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-24-02.png [9]: http://www.cyberciti.biz/tips/postgres-allow-remote-access-tcp-connection.html [10]: http://www.postgresql.org/docs/9.1/static/auth-pg-hba-conf.html [11]: http://www.openforis.org/support/upfiles/javaw_2017-03-28_02-46-19.png

As default Collect Earth is setup to use SQLite as the database that stores the collected data. In order to use a server-based solution (*PostgreSQL*) so that several PCs running Collect Earth can share the same data, the user must set up the database connection. **INSTALL POSTGRESQL** Install [PostgreSQL server][1] in a computer that can be reached by the other PCs, whether through the internet or within the intranet. After you install PostgreSQL run the pgAdmin III application that should also have been installed when the PostgreSQL was installed. You should login to the DB using the postgres user (usual passwords would be postgres or admin, but this depends on what you set when installing the database at first) You should also create a new Login Role ( in the Login Roles branch under the server ), for instance you can call it `collectearth` with password `collectearth` ( this is set in the definition tab ) Step 1 : Create "collectearth" login roles ![alt text][2] Step 1.A : Set long name "collectearth" ![alt text][3] Step 1.B : Set the privileges for the user ![alt text][4] Step 2: Create database. ![alt text][5] Step 2,A: Call it also "collectearth" and set "collectearth" as the owner ![alt text][6] Step 2.B : In the " privileges" grant "collectearth" full control of the database ![alt text][7] Step 3: Create a schema within your new database and call it **"collect"** , Very important to keep this name as other names will provoke an exception! ![alt text][8] **Configure the Database** By default PostgreSQL is setup so the database cannot be accessed from outside the localhost (the computer where the server is installed ). In Windows we need to change this ( [check for more info here][9] ) Go the folder where the PostgreSQL has been installed. By default it should be : `C:\Program Files\postgresql*VERSION_NUMBER*\data` Files\postgresql*VERSION_NUMBER*\data` ( or `C:\Program Files\postgresql*VERSION_NUMBER*\data\pg10` for Postgres 10) Open the file called **pg_hba.conf** and append this line to the list of accepted connections : host all all 0.0.0.0/0 trust This means that the database accepts now connections from any IPs ( you can tweak this to accept connection only from you local network : [see the documentation][10] ) Now on the same folder open the file **postgresql.conf** and change the line where it say `listen_addresses`. set it to : listen__addresses='*' At this stage you need to restart PostgreSQL. Since it is installed as a service (usually) in Windows the fastest way is to just restart the computer. **SET UP COLLECT EARTH** Now you should open Collect Earth and got to the main menu *Tools->Properties* and then go to the *operation mode* tab. In that tab fill the fields like in the image attached ( the XXX.XXX.XXX.XXX is your IP address. You can see the current IP address of your computer on the same dialog (see image) ![alt text][11] You should check that the connection is working by clicking on the smartly titled "Test Connection" button!! Click on Save & Apply changes and now you should see that Collect Earth has populated the collect schema in the Database with all the tables necessary for the Collect to store data. **NOW CHECK THAT OTHER USERS CAN CONNECT TO THE DATABASE** If this does not happen, review that the PostgreSQL Database is reachable from outside your PC. If the database can be accessed from outside the PC then maybe there is a firewall configuration that is preventing the computer to connect to the PostgreSQL server. FINALLY - CONFIGURE THE CEP FILE -------------------------------- If you want that the CEP file that you distribute to other users carry this information, so that you dont need to make them configure the DB connection manually, then you can modify the contents of the file "earth.properties" inside the CEP file (remember you can open a CEP file with an application like WinRAR or WinZip as it really is just a ZIP file) You will need to substitue these lines (of course with your own data for the IP, DB username and DB password) db_driver=POSTGRESQL db_host=192.168.89.2 db_name=collectearth db_password=collectearth db_port=5432 db_username=collectearth [1]: http://www.postgresql.org/ [2]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-20-34.png [3]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-24-21.png [4]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-21-19.png [5]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-21-46.png [6]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-22-52.png [7]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-23-30.png [8]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-24-02.png [9]: http://www.cyberciti.biz/tips/postgres-allow-remote-access-tcp-connection.html [10]: http://www.postgresql.org/docs/9.1/static/auth-pg-hba-conf.html [11]: http://www.openforis.org/support/upfiles/javaw_2017-03-28_02-46-19.png

As default Collect Earth is setup to use SQLite as the database that stores the collected data. In order to use a server-based solution (*PostgreSQL*) so that several PCs running Collect Earth can share the same data, the user must set up the database connection. **INSTALL POSTGRESQL** Install [PostgreSQL server][1] in a computer that can be reached by the other PCs, whether through the internet or within the intranet. After you install PostgreSQL run the pgAdmin III application that should also have been installed when the PostgreSQL was installed. You should login to the DB using the postgres user (usual passwords would be postgres or admin, but this depends on what you set when installing the database at first) You should also create a new Login Role ( in the Login Roles branch under the server ), for instance you can call it `collectearth` with password `collectearth` ( this is set in the definition tab ) Step 1 : Create "collectearth" login roles ![alt text][2] Step 1.A : Set long name "collectearth" ![alt text][3] Step 1.B : Set the privileges for the user ![alt text][4] Step 2: Create database. ![alt text][5] Step 2,A: Call it also "collectearth" and set "collectearth" as the owner ![alt text][6] Step 2.B : In the " privileges" grant "collectearth" full control of the database ![alt text][7] Step 3: Create a schema within your new database and call it **"collect"** , Very important to keep this name as other names will provoke an exception! ![alt text][8] **Configure the Database** By default PostgreSQL is setup so the database cannot be accessed from outside the localhost (the computer where the server is installed ). In Windows we need to change this ( [check for more info here][9] ) Go the folder where the PostgreSQL has been installed. By default it should be : `C:\Program Files\postgresql*VERSION_NUMBER*\data` Open the file called **pg_hba.conf** and append this line to the list of accepted connections : host all all 0.0.0.0/0 trust This means that the database accepts now connections from any IPs ( you can tweak this to accept connection only from you local network : [see the documentation][10] ) Now on the same folder open the file **postgresql.conf** and change the line where it say `listen_addresses`. set it to : `listen__addresses='*'` listen__addresses='*' At this stage you need to restart PostgreSQL. Since it is installed as a service (usually) in Windows the fastest way is to just restart the computer. **SET UP COLLECT EARTH** Now you should open Collect Earth and got to the main menu *Tools->Properties* and then go to the *operation mode* tab. In that tab fill the fields like in the image attached ( the XXX.XXX.XXX.XXX is your IP address. You can see the current IP address of your computer on the same dialog (see image) ![alt text][11] You should check that the connection is working by clicking on the smartly titled "Test Connection" button!! Click on Save & Apply changes and now you should see that Collect Earth has populated the collect schema in the Database with all the tables necessary for the Collect to store data. **NOW CHECK THAT OTHER USERS CAN CONNECT TO THE DATABASE** If this does not happen, review that the PostgreSQL Database is reachable from outside your PC. If the database can be accessed from outside the PC then maybe there is a firewall configuration that is preventing the computer to connect to the PostgreSQL server. FINALLY - CONFIGURE THE CEP FILE -------------------------------- If you want that the CEP file that you distribute to other users carry this information, so that you dont need to make them configure the DB connection manually, then you can modify the contents of the file "earth.properties" inside the CEP file (remember you can open a CEP file with an application like WinRAR or WinZip as it really is just a ZIP file) You will need to substitue these lines (of course with your own data for the IP, DB username and DB password) db_driver=POSTGRESQL db_host=192.168.89.2 db_name=collectearth db_password=collectearth db_port=5432 db_username=collectearth [1]: http://www.postgresql.org/ [2]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-20-34.png [3]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-24-21.png [4]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-21-19.png [5]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-21-46.png [6]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-22-52.png [7]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-23-30.png [8]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-24-02.png [9]: http://www.cyberciti.biz/tips/postgres-allow-remote-access-tcp-connection.html [10]: http://www.postgresql.org/docs/9.1/static/auth-pg-hba-conf.html [11]: http://www.openforis.org/support/upfiles/javaw_2017-03-28_02-46-19.pnghttp://www.openforis.org/support/upfiles/javaw_2017-03-28_02-46-19.png

As default Collect Earth is setup to use SQLite as the database that stores the collected data. In order to use a server-based solution (*PostgreSQL*) so that several PCs running Collect Earth can share the same data, the user must set up the database connection. **INSTALL POSTGRESQL** Install [PostgreSQL server][1] in a computer that can be reached by the other PCs, whether through the internet or within the intranet. After you install PostgreSQL run the pgAdmin III application that should also have been installed. Create a new installed when the PostgreSQL was installed. You should login to the DB using the postgres user (usual passwords would be postgres or admin, but this depends on what you set when installing the database ( call it whatever you want, e.g. `CollectEarthDb` ), inside this database you need to create a Schema and name it "**collect**" ( it is important that the name is that one ). at first) You should also create a new Login Role ( in the Login Roles branch under the server ), for instance you can call it `collect_client` `collectearth` with password `collect_pass` `collectearth` ( this is set in the definition tab ) Step 1 : Create "collectearth" login roles ![alt text][2] Step 1.A : Set long name "collectearth" ![alt text][3] Step 1.B : Set the privileges for the user ![alt text][4] Step 2: Create database. ![alt text][5] Step 2,A: Call it also "collectearth" and set "collectearth" as the owner ![alt text][6] Step 2.B : In the " privileges" grant "collectearth" full control of the database ![alt text][7] Step 3: Create a schema within your new database and call it **"collect"** , Very important to keep this name as other names will provoke an exception! ![alt text][8] **Configure the Database** By default PostgreSQL is setup so the database cannot be accessed from outside the localhost (the computer where the server is installed ). In Windows we need to change this ( [check for more info here][2] here][9] ) Go the folder where the PostgreSQL has been installed. By default it should be : `C:\Program Files\postgresql*VERSION_NUMBER*\data` Open the file called **pg_hba.conf** and append this line to the list of accepted connections : host all all 0.0.0.0/0 trust This means that the database accepts now connections from any IPs ( you can tweak this to accept connection only from you local network : [see the documentation][3] documentation][10] ) Now on the same folder open the file **postgresql.conf** and change the line where it say `listen_addresses`. set it to : `listen__addresses='*'` At this stage you need to restart PostgreSQL. Since it is installed as a service (usually) in Windows the fastest way is to just restart the computer. **SET UP COLLECT EARTH** Now you should open Collect Earth and got to the main menu *Tools->Properties* and then go to the *operation mode* tab. In that tab fill the fields like in the image attached ( the XXX.XXX.XXX.XXX is your IP address, you address. You can find it out see the current IP address of your computer on the same dialog (see image) ![alt text][11] You should check that the connection is working by executing [cmd and then typing IPCONFIG][4] ) . ![alt text][5] clicking on the smartly titled "Test Connection" button!! Click on Save & Apply changes and now you should see that Collect Earth has populated the collect schema in the Database with all the tables necessary for the Collect to store data. **NOW CHECK THAT OTHER USERS CAN CONNECT TO THE DATABASE** If this does not happen, review that the PostgreSQL Database is reachable from outside your PC. If the database can be accessed from outside the PC then maybe there is a firewall configuration that is preventing the computer to connect to the PostgreSQL server. FINALLY - CONFIGURE THE CEP FILE -------------------------------- If you want that the CEP file that you distribute to other users carry this information, so that you dont need to make them configure the DB connection manually, then you can modify the contents of the file "earth.properties" inside the CEP file (remember you can open a CEP file with an application like WinRAR or WinZip as it really is just a ZIP file) You will need to substitue these lines (of course with your own data for the IP, DB username and DB password) db_host=192.168.89.2 db_name=collectearth db_password=collectearth db_port=5432 db_username=collectearth [1]: http://www.postgresql.org/ [2]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-20-34.png [3]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-24-21.png [4]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-21-19.png [5]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-21-46.png [6]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-22-52.png [7]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-23-30.png [8]: http://www.openforis.org/support/upfiles/pgAdmin4_2017-03-28_02-24-02.png [9]: http://www.cyberciti.biz/tips/postgres-allow-remote-access-tcp-connection.html [3]: [10]: http://www.postgresql.org/docs/9.1/static/auth-pg-hba-conf.html [4]: http://kb.linksys.com/Linksys/GetArticle.aspx?docid=d02ed3aa3e704caea42f5c007b8c6472_3996.xml [5]: http://www.openforis.org/support/upfiles/operation_mode.png[11]: http://www.openforis.org/support/upfiles/javaw_2017-03-28_02-46-19.png

As default Collect Earth is setup to use SQLite as the database that stores the collected data. In order to use a server-based solution (*PostgreSQL*) so that several PCs running Collect Earth can share the same data, the user must set up the database connection. **INSTALL POSTGRESQL** Install [PostgreSQL server][1] in a computer that can be reached by the other PCs, whether through the internet or within the intranet. After you install PostgreSQL run the pgAdmin III application that should also have been installed. Create a new database ( call it whatever you want, e.g. `CollectEarthDb` ), inside this database you need to create a Schema and name it "**collect**" ( it is important that the name is that one ). You should also create a new Login Role ( in the Login Roles branch under the server ), for instance you can call it `collect_client` with password `collect_pass` ( this is set in the definition tab ) **Configure the Database** By default PostgreSQL is setup so the database cannot be accessed from outside the localhost (the computer where the server is installed ). In Windows we need to change this ( [check for more info here][2] ) Go the folder where the PostgreSQL has been installed. By default it should be : `C:\Program Files\postgresql*VERSION_NUMBER*\data` Open the file called **pg_hba.conf** and append this line to the list of accepted connections : host all all 0.0.0.0/0 trust This means that the database accepts now connections from any IPs ( you can tweak this to accept connection only from you local network : [see the documentation][3] ) Now on the same folder open the file **postgresql.conf** and change the line where it say `listen_addresses`. set it to : `listen__addresses='*'` At this stage you need to restart PostgreSQL. Since it is installed as a service (usually) in Windows the fastest way is to just restart the computer. **SET UP COLLECT EARTH** Now you should open Collect Earth and got to the main menu *Tools->Properties* and then go to the *operation mode* tab. In that tab fill the fields like in the image attached ( the XXX.XXX.XXX.XXX is your IP address, you can find it out by executing [cmd and then typing IPCONFIG][4] ) . ![alt text][5] Click on Save & Apply changes and now you should see that Collect Earth has populated the collect schema in the Database with all the tables necessary for the Collect to store data. **NOW CHECK THAT OTHER USERS CAN CONNECT TO THE DATABASE** If this does not happen, review that the PostgreSQL Database is reachable from outside your PC. If the database can be accessed from outside the PC then maybe there is a firewall configuration that is preventing the computer to connect to the PostgreSQL server. [1]: http://www.postgresql.org/ [2]: http://www.cyberciti.biz/tips/postgres-allow-remote-access-tcp-connection.html [3]: http://www.postgresql.org/docs/9.1/static/auth-pg-hba-conf.html [4]: http://kb.linksys.com/Linksys/GetArticle.aspx?docid=d02ed3aa3e704caea42f5c007b8c6472_3996.xml [5]: http://www.openforis.org/support/upfiles/operation_mode.png