Openbravo POS customization (Serial key and Autobackup)


Serial Key feature

--The default duration of the certificate of the installer is 30 days

--One serial key per user(stored in tbl_serialkeys)

--Once they run the software, it will ask for a serial, email and name

--After inputting the serial, the software will connect to my server via internet and do the following authentication process:

---Verify if serial is valid(the status of the serial key should be ‘Unused’ otherwise an “Invalid serial key” notification message will appear)

---Log the IP address, Serial key, Email and name of the user

---The status of serial key in ‘tbl_serialkeys’ should be changed to ‘Used’

---Sends a notification email(w/ complete details) to admin

---Server sends a certificate to client

---Certificate is valid for 365 days

--Client computers automatically request new certificate to server after half of the duration of the validity of certificate

--If connection cannot be made a notification message must pop out upon opening of application:

"Renewal of your license cannot be made, please contact the supplier as soon as possible to avoid any inconvenience. You still have X days left before your license expires."

--If the license expires, the software must deny access to user anymore unless renewal process has been executed properly.

--The software must also silently connect to server once a day whenever there is an internet connection to verify the status of serial key if its set to ‘Deactivated’ the system will automatically set the license to expired, denying further access to the user and a popup window should appear for the renewal of license.

--If the user/client reformatted its computer, they will notify us via(email/phone) and we will issue them another serial key, then their current serial key will be set to ‘Deactivated’ so that no one will be able to use it anymore.

--The certificate must not depend on the system clock of the user since it can be easily bypassed. Maybe it should have its own counter?

--The system must also have its own counter(Table name: tbl_syslogs, Column Name: Counter). The purpose of the system’s counter is to verify that the certificate is not being altered. The certificate will be automatically revoked whenever the counter of certificate didn’t much the system’s counter. And ask the user to renew its license. When the system connects to the internet, it should send a command to change the status of the serial to ‘Deactivated’ and add the reason ‘Invalid Certificate’ to column ‘remarks’

--Server’s username and password must not be stored in the system. The system will only send command to the server in able to process its request.

Database Table Structure




-status [Used/Unused/Deactivated]








Other security feature:

How to protect the certificate that will be generated in the computer from being copied?

-What I have in my mind is that, the system will create a random filename stored in Windows\System32. The file attribute must also be set to hidden, read only and system.

Please suggest if you have something better in your mind.

Automatic Backup feature

-The user can backup the database base on the configured settings:

->Base on the preset time

->or everytime you run the POS(can be toggled on/off)

->or everytime you exit the POS(can be toggled on/off)

-The user must also be able to backup the database manually

-The system should assign the filename automatically for each backup entry.

-The user can configure how many backup entry can be stored before it overwrites the first entry

-The user can restore the database via backup/restore panel

-The backup entries should be encrypted

Skills: J2EE, Java, MySQL

See more: openbravo system key, my email address is invalid, java notification, invalid email address message, my j, j software, security for computers, serial, serial java, pos java, pos application, license key, access database and java, java connect database, connect time server, pos system database, java send email server, create installer access, java system log, java backup contact name, protect key license, email read notification, serial read file, server set windows server 2013, email notification windows backup

About the Employer:
( 5 reviews ) Quezon City, Philippines

Project ID: #4726684

11 freelancers are bidding on average ₱27066 for this job


Experienced java developer. Worked on openbravo customization before.

₱30000 PHP in 5 days
(45 Reviews)

Please Check PMB.

₱15000 PHP in 10 days
(90 Reviews)

I can do it

₱36000 PHP in 30 days
(47 Reviews)

Let me help you!

₱15789 PHP in 15 days
(30 Reviews)

I can start immediatly. Thanks

₱32222 PHP in 3 days
(5 Reviews)

Kia ora! are a NZ based web and software design company who have seen you here on the freelance market and are really excited about working with you and treating you to the full service, professional experi More

₱30927 PHP in 30 days
(2 Reviews)

Expert in POS.

₱22222 PHP in 20 days
(2 Reviews)

let me do this!

₱33333 PHP in 20 days
(1 Review)

Dear Sir, I have a project for such technologies experience. I can provide you total ETL, E-Commerce, CRM, openbravo ERP, Java POS and Web POS System which allow you to manage your all the needs. I am an openb More

₱22222 PHP in 3 days
(0 Reviews)

Hi.Accept the bid to start immediately.

₱24444 PHP in 10 days
(0 Reviews)

It’s an easy task for us. We have gone through your requirements and we are ready to start the work immediately on your project. We will send you the list of company’s projects and Portfolio once you reply us. Also ple More

₱28344 PHP in 67 days
(0 Reviews)

i have good hand with frees witch stuffs. check pm

₱20618 PHP in 7 days
(0 Reviews)

We are A Certified Company, We provide you: - 1. Dedicated team with Fast & Accurate. 2. Always Skype or phone availability as per your Timing. 3. Able to work during your working hours. 4. 100% QUALITY work. More

₱20618 PHP in 30 days
(0 Reviews)

consider it done, i'm ready to do it!

₱22222 PHP in 3 days
(0 Reviews)