Software License Management Portal Project
Purpose: To accept HTTPS request from various software packages we have developed. To determine whether the registration is valid, and respond to the software package accordingly. Portal to include a management interface to manager software packages, clients, and registrations as defined below.
Information received from the software package includes software id (4 digits), registration email address, and GUID. Website should respond to software application with encrypted value of status.
Portal will run on a paid GoDaddy website server configured for windows and SQL server.
Portal programmer will be responsible for uploading website and creating the tables in SQL through GoDaddy’s management tools which we will provide access to.
I anticipate needing tables for the following:
USERS – Website administration security table. Initially one master user should be used with full access to the entire back end of the portal
CLIENT – Client contact table. Unique based on email address. Standard contact information, address, city, state, zip, phone, fax, client-since-date, etc.
SOFTWARE REGISTRATION – Software registration database. Includes all software that is currently registered. Include SoftwareID, Registration Date, GUID (Globally Unique ID), ClientID, Expiration Date
SOFTWARE LIBRARY – Each Software package will have a single ID in the database. Eventually, this will probably interface with a sales website, but at this point just and ID, and Software Name.
CONNECTION HISTORY – Every time a software package verifies to the portal, it should be logged. Date/Time, Client ID, SoftwareID, IP Address, License Result
Administrative backend should allow for adding, editing, deleting and search/viewing users, clients, software registrations, software library, connection history.
Phase one is a simple get it up and running quick project. Whoever is chosen will be given priority for future development on this project.
10/15/2008 -- After seeing some of the bids come through, I was not willing to pay these prices for this project. So, last night for 5 hours, I stumbled through setting up the webserver, and sql server connections from my hosting provider, and learned what I needed to do to connect to the database. I created the databases easily and added some sample data.
Start to finish, it took me about 5 hours... and saved myself quite a bit of money. Thank you for everyone who bid on the project... but my needs have been met.