How to ensure the database security of Lenvica HRMS time attendance software!

[EBRAHIM ABDALLA]

#22284

We have been using the time attendance software for the past 7 years. Our attendance is recorded in software and payroll is processed through the software only. The server system crashed last week due to some system files missing. We were luckily able to fix the same saving ourselves from loosing the data critical to our company. Is there any provision in the time attendance software to ensure its DB security?

[Vineeth Jose]

#22287

Database is very critical. Hence, we must adopt measures to ensure its safety from cases of system crash, data theft, corruption etc. Here are a few points that you must note.

1. Establish strong passwords
Implementing strong passwords is the easiest thing you can do to strengthen your security. Do not share the passwords with other users. Lenvica HRMS keeps history of changes that have been made the software, if anyone attempting to tamper the DB works using your credentials then it may mislead.

2. Put up a strong firewall
In order to have a properly protected network, firewalls are must. So it reduces attempts to risk the safety of DB from outside or even internal networks.

3. Install antivirus protection
Antivirus and anti-malware software are essentials in your arsenal of online security weapons, as well.

4. Update AtttendHRM software and other related OS or system security programs regularly
Making sure Lenvica HRMS time attendance software and other crucial programs in the server are updated is a necessary step towards being fully protected. With each patch, Lenvica HRMS team make changes to cop with the current set of security threats.

5. Secure your Computers, Laptops
Your computers and laptops from where you access the software must be well protected. You mustn’t provide unattended access to others either physically or through remote desktop sharing tools.

6. Backup Lenvica HRMS Database regularly
Servers should have a complete backup weekly, and incremental backups every night.
Scheduling regular backups to an external hard drive, or in the cloud, is an easy and the most effective way to ensure that all your data is stored safely. You must schedule for the automatic backup at least twice a day in the Lenvica HRMS time attendance software. It will automatically run and store the database in the location you have specified.

7. Monitor diligently
Physical security must be ensured. You can setup access control to server rooms, cctv cameras etc to ensure this.

8. Educate your employees
Teaching your employees about safe online habits and proactive defense is crucial.
Make sure your employees understand how important your company’s data is, and all the measures they can take to protect it.

[Keity]

#22288

Hi,

I am getting a frequent message from my firewall that the Firebird SQL on the Lenvica HRMS server was flagged by our security tool to be using the default sysdba password.
Please guide me how to change the password of firebird.

[Steve Alex]

#22290

Hello Keity,

Following are the steps to change Firebird password in Lenvica HRMS server:

1. Run ‘Command prompt’ as admin and change to the firebird directory folder (C:\Program Files (x86)\Firebird\Firebird_2_5\bin)

2. Run following commands in the order:

1. gsec -user sysdba -password masterkey
2. modify sysdba -pw
For eg: modify sysdba -pw thaiunion@fb
3. quit

Remember to change firebird password of Lenvica HRMS server and all clients connection manager.
We recommend to change Firebird password once in a month.

Change Firebird Password

[Abaeze]

#22291

Can I automatically backup the Lenvica HRMS database at midnight?

[Nisa]

#22299

Yes, you can schedule a task to a backup database. You can schedule regular backups to an external hard drive, network drive or in the cloud. You can schedule for a month, week or day of midnight. We recommend to automatic backup at least twice a day in the Lenvica HRMS time attendance software. It will automatically run and store the database in the location you have specified.
Following is the document to schedule automated backups of the Lenvica HRMS Database.

[Paul Gosar]

#22295

I am going to install Lenvica HRMS time attendance software for my client. They want to know which version of MSSQL server they need to install for the time attendance software. They require the software only for Attendance as they are already using a payroll software. Please advise.

[Sujit Manoharan]

#22297

Hi Paul, MSSQL is not required for Lenvica HRMS Time Attendance software. Our time attendance software uses Firebird database server which is an open source software which is available for free. Please send the software requirements to sales@lenvica.com, so that we can provide you the best configuration and quote.

[Author]

Posts