URBIS BIOMETRIC DB SETUP: Difference between revisions
No edit summary |
|||
| (3 intermediate revisions by the same user not shown) | |||
| 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'''. | |||
Latest revision as of 08:21, 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
- su – rajarshi
$ crontab -l
- Sync TimeDESK data
45 * * * * getTimeDeskIOdata.php > /dev/null 2>&1
Setup Details of Win7 Machine[edit]
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.
