URBIS BIOMETRIC DB SETUP: Difference between revisions
No edit summary |
|||
| (5 intermediate revisions by the same user not shown) | |||
| Line 3: | Line 3: | ||
'''URBIS BIOMETRIC DB SETUP''' | '''URBIS BIOMETRIC DB SETUP''' | ||
[[image:Urbis-attendance.png]] | |||
| Line 19: | Line 22: | ||
''' | ''' | ||
On Concert Server:-''' | On Concert/Porcupine Server:-''' | ||
There is a script that Ipmort updated data from 140 machine(Win Xp) to Concert Server. | There is a script that Ipmort updated data from 140 machine(Win Xp) to Concert Server. | ||
| Line 32: | 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.
