URBIS BIOMETRIC DB SETUP: Difference between revisions
No edit summary |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 42: | Line 42: | ||
Biometric Detail:- | Biometric Detail:- | ||
Machine IP:- 192.168.0.140 | Machine IP:- 192.168.0.140 | ||
Operating System:- Win 7 | Operating System:- Win 7 | ||
User:- administrator | User:- administrator | ||
Pass:- password@123 | Pass:- password@123 | ||
Mysql User:- root | Mysql User:- root | ||
Pass:- password@345 | Pass:- password@345 | ||
1- Biometric device store data in Ms Access. | 1- Biometric device store data in Ms Access. | ||
Access DB location :- C:\timedesk\Unis.mdb | Access DB location :- '''C:\timedesk\Unis.mdb''' | ||
2- We used a Php script to read data from MsAccess and Insert into MySql DB. | 2- We used a Php script to read data from MsAccess and Insert into MySql DB. | ||
3- We have scheduled it to execute per hour. check task scheduler. | 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.
