Jump to content

URBIS BIOMETRIC DB SETUP: Difference between revisions

From TetraWiki
No edit summary
No edit summary
Line 35: Line 35:


45 * * * * getTimeDeskIOdata.php > /dev/null 2>&1
45 * * * * getTimeDeskIOdata.php > /dev/null 2>&1
== Setup Details of Win7 Machine ==
Biometric Detail:-
Machine IP:- 192.168.0.140
Operating System:- Win 7
User:- administrator
Pass:- password@123
Mysql User:- root
Pass:- password@345
1- Biometric device store data in Ms Access.
Access DB location :- C:\timedesk\Unis.mdb
2- We used a Php script to read data from MsAccess and Insert into MySql DB.
Script Location:- C:\timedesk\virdi\getaccessdata2mysql.php
3- We have scheduled it to execute per hour. check task scheduler.

Revision as of 08:18, 9 December 2015


                                URBIS BIOMETRIC DB SETUP



1- Biometric store data into MS-Access DB.


There is a script to import Data from MS-Access to Mysql.

Task Schedule of administrator. This script execute every hour.

IP= 192.168.0.140

Script Name:- getaccessdata2mysqldb.php

Location:- c://Timedesk/virdi

On Concert/Porcupine Server:-

There is a script that Ipmort updated data from 140 machine(Win Xp) to Concert Server.

Location is= /var/w3/da/w3etc/cronjobs/run/studioR/getTimeDeskIOdata.php

  1. su – rajarshi

$ crontab -l

  1. Sync TimeDESK data

45 * * * * getTimeDeskIOdata.php > /dev/null 2>&1


Setup Details of Win7 Machine

Biometric Detail:-

Machine IP:- 192.168.0.140 Operating System:- Win 7 User:- administrator Pass:- password@123 Mysql User:- root Pass:- password@345


1- Biometric device store data in Ms Access. Access DB location :- C:\timedesk\Unis.mdb

2- We used a Php script to read data from MsAccess and Insert into MySql DB. Script Location:- C:\timedesk\virdi\getaccessdata2mysql.php

3- We have scheduled it to execute per hour. check task scheduler.