This is a project made by (or partially by) WSN-Team 2012 in the course CSD, which is part of the Technology Transfer Alliance.
One of the project's goal is to build a website. The website is displaying data in a friendly way and handles user authentication and management. For more information look in the documentation available in the TTA portal. Another project's goal is to reply to http requests by contacting the database and sending a JSON object. The requests may query for gateway list, sensor list and data list. For more information look in the documentation in the TTA portal.
Website contains a page for display bundlepayload data, filled with our systems WSN data. Additionally another website's aim is to manage user authentication. User authentication can be used by future groups which would like to implement a privacy policy for displaying data from different gateways. Website consists of login, registration, account settings pages for user management. There is also a contact us page in order for users to contact the system administrators. Lastly, there is a server configuration page for changing the configuration file of the server available for future implementation. WSN-Team 2012 project website is uploaded here: Website.
A server is needed in order to be able to upload and run the website on it. In our project we used apache tomcat 7 but any server version can be used. You can download Tomcat 7 and you can follow the instructions for installation guidelines. To upload the project in your server you have to do the following:
- create a war file using standard Java jar tool by typing in the command line:
cd <project path>/Website(go to the project directory)cp libs/mail.jar libs/postgresql-9.2-1000.jdbc4.jar libs/gson-2.2.2.jar WEB-INF/lib(copy all the appropriate libraries in the WEB-INF to include them in the war file creation)jar cf Website.war .(create the war file (c->create war file, f->specify the war file name, .-> represents the current directory))
- enter the servers manager/html page
- deploy the war file in the website and your website is up and running in your server
In this project we used postreSQL vesrion 9.1 to create our database schema. Any database can be used if appropriate changes are commited in the Database.java and SQLQueries.java files. To download and install postgreSQL you can go to PostgreSQL and download the appropriate source. Then follow the instalation instructions. To load the database schema you have to do the following from command line:
psql postgres(connect to database as postgres user)CREATE DATABASE "DatabaseName";(create database)psql databasename < data_base_dump(import DB from dump file outside the psql command line. The projects database dump file is stored in the database folder. Notice: database should be created before importing the dump file)
Notice You need to Insert your database specifications in the src/database/SQLQueries.java file where todo comments appear. Also in order to be able to send emails from the contact us page you need to add your gmail account or modify the code to include your mail server. Modify mail specifications in /WebContent/ContactUs.jsp.
Copyright 2012 KTH
Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.