In this video we will see third party database integration [MySQL] feature in iVMS4200. Version of iVMS4200: v3.4.0.5 build20201102 MySQL Version: v5.7.24
Hello Hamid, i have a slight problem, the configuration file path input box for libmysql.dll has disapeared after i switched to SQLServer and back? Is there any way for me to get the input box back. I can't connect to my local mysql database even tho I can when checking with ODBC?
Hello, I have 2 questions, the data is sent to MySql only when I enter the attendance record menu and click on get event from device. Is there a way to automatically send it every n seconds? The second question: I have enabled the status of the records in the time clock, how can I send or identify them to send them to MySQL? Thank you
1. Usually, it’s real time, when anyone marks attendance on device, it’ll show up on MySQL automatically, provided the ivms4200 and MySQL are online. 2. once you enable that, there is an option called enabled function keys on ivms4200, once enabled you can see the function keys which you have selected when marking attendance on MySQL database. (This may not work for very old devices)
Theoretically latest MySQL server should work, doesn’t matter if it’s MAMP or WAMP etc. The device will communicate with iVMS4200 and iVMS4200 will communicate with MySQL. Hope it helps.
Thank you for this very helpful video. I tried this using iVMS-4200 v.3.11.1.7 with MySQL 8.0.31 - Community Server (Wampserver) but failed to connect. Any suggestion?
hello and thank you for these clear explanations. But I have a problem, every time I try to connect ivms 4200 AC with my MYSQL database, I get the following error: third-party database connection failed. please check the database connection and click save. i'm using wampserver with mysql version 8.0 What could be the cause
Could be various reasons, 1. Make sure the iVMS4200 and WAMP server are using one of these: x86 or x64 2. Are iVMS4200 and MySQL on the same server? 3. Ensure that there is no firewall or any other blocking the access. Thanks!
Hi! Thank you so much for the explanation, it was very useful! I don't know if you could give me directions on how to fix a little issue i have. All my registers show as IN, even with the timetables configured. The attendance and the extra hours are calculated just fine in the app but when passing my data to the db it doesn't show when people leave their shift, it registers it like another entrance.
On ivms4200, there is an option to download the records again by selecting a time period, once manually downloaded, records will sync onto database. Hope it helps!
Hello Hamid, ive been trying to connect for now, its saying cant connect to database. Please can you please export your database (.sql) and also please link to the particular ivms 4200 you are currently using. Thanks so much
Hello Hamid, one question please. Is it possible to connect several devices and then the markings are captured by the third party database integration [MySQL]?
Yup, you can connect multiple devices (access control / attendance) to one iVMS4200 and all data can be pushed to MySQL. Make sure to add devices with different names, these device names will show for every record on MySQL table.
Hello, thank you for your tutorial. But I can connect my database. I have the message: Third-party database connection failed. I use WAMP. MySQL is in version 8.0.27. Did you find the fix of this error?
I haven’t faced this error before. However, you can check for couple of things 1. Make sure you’ve uploaded the correct dll file 2. Use latest version of iVMS4200 3. Update WAMP if available. Thanks!
@@AfhamnaExplains no, I can't integrate, I have Windows 11 and I have two computers in different locations, I've tried to use the API, which has allowed me to read the information of some workers but I haven't gotten the endpoint to bring the events, really what I require is to be able to get the inputs and outputs of the workers currently I use this model Hikvision DS-K1T320EFX which has a facial detector and fingerprint reader, however the IVMS does not meet my needs so I need to make an integration that allows me to do that, what do you suggest?
hi! my iVMS4200 does not show the field for entering the config file. I have entered the rest of the fields as the MAMP mysql server address and port, however the connection still fails.
Hamid! Can you add more tables to the database? Only this table is insufficient to know who did not register when entering. Can Person data be exported to a table?
Hi Jose, Using third party database integration, we can export only the mentioned data as per this video. We can export person data on excel table using iVMS / HikCentral.
Hi Hamid! Nice video! I'm trying to automate the third party database integration, making the FaceRecognition device to apply changes automatically to the DB. The problem we encounter is that it isn't able to update the database automatically. Only forcing the update manually. Any suggestions to that issue? By other hand, Do you know how the Hikvision People counter work with ivms 4200? Any thoughts about where the local database of ivms 4200 is located?
Hello Miguel, iVMS may not have sufficient privileges. Try running it as admin and check. Secondly, the database of ivms4200 is fully encrypted. When we try to open in notepad, it will be gibberish. One of the the recommended way is to use api or sdk of the hardware and program accordingly. Hope it helps, thanks!
Hi Nikolay, The architecture works in the way as it's mentioned in the thumbnail of this video. If the device or iVMS4200 is not turned ON, then it will not transmit data onto SQL database. Usually, when the software is ON (provided device is ON and connected to network), data will be downloaded onto MySQL. Alternatively, you can manually download the logs onto iVMS, which inturn can push the data onto MySQL. Thanks!
Hi sir, Unfortunately, the latest iVMS4200 version won't work. The connection failed error message popup even though everything is alright. I tried SQL Server option too but failed. If you still have your iVMS4200 installation, please share it with us. I want to make sure it just broke on the latest version. Thanks.
I Cant connect to MySQL, followed everything but it failed. I am Using Mysql server 5.7 and Mysqlworkbench 8.0 for database . Any tips on how to fix it?
Hi Hamid, Nice tutorial. Hamid, can you give example how to Push or Send user data from 3'rd apps to Hikvision devices using API? Need guide for that things. Thankyou
Hi, I'm having trouble linking the DB. I did all the steps as in the video, however, when saving in IVMS, I get a connection error with the thirdparty database. Can you help me?
Couple of things to check from your side: 1. Make sure both MySQL and iVMS4200 are on same PC / same network (firewall should be disabled). 2. If both are on same pc try with localhost . 3. Check if you have uploaded proper dll file. 4. Use latest version of iVMS 5. Ensure that all the fields are correctly mapped.
@@AfhamnaExplains i have this problem too. i checked all this things but problem still here. localhost is working but when saving in IVMS, I get a connection error with the thirdparty database
Yes, it’s almost similar Additionally, there is option to include or exclude devices (in case if you don’t need any data to be sent to sql from any particular device(s)) Hope it helps!
@@AfhamnaExplains it says saving failed Third-party database connection failed. Please check the database connection and click save That's all I'm getting
Hi Hamid, I tried to connect a third party database online with the server ip adress , user name and password , i didn’t find the right version of the lib , is the 5.6.43 I don’t know if I can try something else.
Hello Bro. can you give me advice. i have also error like that: Third-party database connection failed please check connection. what i did already: 1. changed dll file of from 5,1 to 8 version of mysql 2. mysql and ivms on same computer 3. mysql using from openserver 4. checked port 3306. connection from other db client
The crucial moment here: as iVMS is built for the x86 architecture, you have to provide the libmysql.dll file for x86. I also stuck with it and my solution was to install MySQL server x86 (32-bit) locally and to provide the installed libmysql.dll file to iVMS. If you install MySQL Server for x64 architecture and provide libmysql.dll from it, it will cause the "Third-party database connection failed..." error
@@nighter20i will give that a try, but can u please tell me how to get the config file path input box back? I only have Database Type: MySQL then server IP. How do i get the config file path inlut box back?
@@christiaanvanjaarsveldt242 I was also confused that it disappeared after I restarted iVMS. I gave up and reinstalled it from scratch (all it's settings were lost, obviously). You can try putting the correct libmysql.dll file to that location that was in the path fields before it disappeared.
hello, I follow all your process and it works locally, but connecting to a remote server causes a disconnection, it indicates that the data is wrong, save the access data and try again, you will know the reason for the failure
1. Do you mean that the connection to remote server is disconnected always? Or is it unstable? (Connects and then disconnects after sometime) 2. What is the exact error message you are getting? (Also mention if you got the error when saving the sql settings on iVMS or when a user marks attendance on the device)?
@@AfhamnaExplains 2. the error occurs after certain attempts by a user to mark attendance on the device, it says problems with the connection to the database (this on a remote server of my database on a local server like XAMPP is well maintained on Registration.)
1. Ensure that the connection is fully wired. Between devices, server with DB and iVMS 2. Are there any other databases / instances apart from the DB for iVMS? 3. Ensure you are using latest version of XAMPP & iVMS 4. Double check firewall on both.
@@AfhamnaExplains -yes, the connection of both computers is by cable to the network -Inside the local computer, only ivms and a local server for XAMPP databases are installed and the connection tests are made with both the server in the cloud and the local one for the databases. -the connection between iVMS and the reader is good and is well maintained. -All permissions were given.
Hey Hamid, may I ask for this software, how am I able to save the data of other fields into database. For example, right now I am trying to do something where it will detect if this person has passed by this area so I can save the data into database for further action. Or do you have any other ideas on how to work on this kind of project? Thank you in advance :D
You can place one device (or multiple) in each area and set the device name based on area. Whenever a person appears infront of the device. The device name, date-time, employee Id will appear (along with other fields) Later you can run sql command to filter out for a particular area (particular device(s)). This is limitation on iVMS However, if you use Hik-Central, you’ll have option to select particular devices and sql data will populate only for the selected devices. Unselected device(s) data will NOT populate on sql database. Hope it’s clear!
@@AfhamnaExplains Okay, so for example let say now I am able to filter out the data for the particular area, am I able to take the data from the database and do some integration with my codes? For example I use the data in the database to send email to that person.
Also I would like to add on another scenario is that, is it possible to check if this user has been registered for certain area? Example, I have 2 area, but that person only registered for area 1's device, then when that person goes to area 2, will the device get detected where that person is not registered for area 2?
Hamid, I have database connection error with mysql and sql databasese both. I did as u showed in this and other videos. But I get 'Thisr party database connection failed' error anyway. How can I fix this??
@@AfhamnaExplains Hi Hamid! I am using microsoft mysql installer - community. I uploaded the proper dll. I don't know the reason why the connection failing ((
Hi @@zy.r.4323 Could you send screenshot of the error and also, the fields on MySQL table? What port is your MySQL running? Please double check if firewall is blocking the ports. What version of iVMS4200 are you using? Are iVMS4200 and MySQL instance on the same PC?
@@AfhamnaExplains UA-cam doesn't allow sending screenshots. port:3306. iVMS4200 V 3.5.0.4 build 20210203. iVMS4200 and MySQL are now on the same pc. but I have to integrate on remote server. I'm testing on localhost
@@zy.r.4323 You are using the latest version of iVMS4200. What version of MySQL are you using? If telnet is enabled, then try telnet localhost 3306 to see if it enters. Btw, you can use any image hosting service ( pasteboard.co/ / imgur.com/upload )to upload the screenshot and share the uploaded image link in the comments.
Hi can double check if you had uploaded the correct dll file. Secondly, make sure the credentials are correct and the MySQL has access to connect to iVMS.
There is an option in iVMS where you’ll have to enter your email server details and you have option to select what types of reports you’ll require via email.
@@andharuwicaksono6980 what version of iVMS are you using? Are you using MySQL only or are you using any stack similar to xampp or MAMP or any other? If yes, let me know.
@@AfhamnaExplains i tried with different programms but i never can establish a connection to a database. I'm using a different machine from other company, it's from safire, the SF-AC3002KEMD-IP, but I think the it works is the same that safire
@@AfhamnaExplains im using windows ivms4200 xampp for mysql i cant find the mysql dll file at xampp folder ? i want to know dll file name for xampp , thanks
@@AfhamnaExplains Hello sir, Thank you for the reply. Could you please give me your email address? Then I can send every screenshot and more details. The problem is if I try with HikCentral Access Control Web Client using my DB credentials it works. But the same credentials not working for ivms software. I am using, ivms V1.8.1.4 AC MySQL community 8.0.31.0 Both software run the same pc Error msg: third-party database connection failed. please check the database connection and click save Screenshots: drive.google.com/drive/folders/1uQfykHkDsFF75cw296SWyqYmX-isk62Z?usp=sharing Table Col: `id` varchar(255) `cardno` varchar(255) `personname` `devicesn` varchar(255) `devicename` varchar(255) `direction` varchar(255) `time` time `date` date `datetime` datetime I don't have a license key for HikCentral Access Control Web Client therefor ivms software is very important to me sir
That’s bit strange. Could you create a new database with a table in it and try? Secondly, follow the same order when creating columns in table (it should be same as mentioned in iVMS interface)
@@AfhamnaExplains Hi Bro. I have one trouble might need your help. I see in my SQL have around 10 log event while in Hikcentral shown up to 100 log event . Thank so much !
Here are couple of things which you can check 1. Let’s say if you have 3 devices, there is an option in HikCentral to choose which devices needs to sync with database. 2. Check only today’s logs and see if the count matches with number of records on sql server. 3. Usually, when sql is down, HikCentral will not sync with sql. If sql is down for less than 16 days (if I am not wrong), the data will be synced with sql server automatically, will require couple of hours to sync.
@@AfhamnaExplains i want to push to the server but what if there is no internet connection. is there any option to push previous unsync datas to the server database
The whole setup can work even if there’s no internet connection. SQL Database and iVMS should be on the same computer or same network. If there’s temporary network connectivity issue, the logs usually will get downloaded automatically once the network is stable. Secondly, if you still need API access, you can use HikCentral. You’ll have to sign NDA with Hik team. To know more details, you need to get in touch with Hikvision Distributor in your local region.
Hi please please how can i access thr ivms online. For example if am using another computer elsewhere without not in the same network
iVMS works only one computer . Recommended to go fr HikCentral.
Hello Hamid, i have a slight problem, the configuration file path input box for libmysql.dll has disapeared after i switched to SQLServer and back? Is there any way for me to get the input box back. I can't connect to my local mysql database even tho I can when checking with ODBC?
I find that weird too, once we add the path, it disappears
Usually, I uninstall and reinstall it.
fantastic explains..👌
Thanks a lot 😊
Hello, I have 2 questions, the data is sent to MySql only when I enter the attendance record menu and click on get event from device. Is there a way to automatically send it every n seconds? The second question: I have enabled the status of the records in the time clock, how can I send or identify them to send them to MySQL?
Thank you
1. Usually, it’s real time, when anyone marks attendance on device, it’ll show up on MySQL automatically, provided the ivms4200 and MySQL are online.
2. once you enable that, there is an option called enabled function keys on ivms4200, once enabled you can see the function keys which you have selected when marking attendance on MySQL database. (This may not work for very old devices)
Hello, How true is it that the HIKVISION DS-K1T342MFWX camera needs MySQL 5.7.44?
Is there any version of MAMP that has this version of MySQL?
Theoretically latest MySQL server should work, doesn’t matter if it’s MAMP or WAMP etc.
The device will communicate with iVMS4200 and iVMS4200 will communicate with MySQL.
Hope it helps.
Thank you for this very helpful video. I tried this using iVMS-4200 v.3.11.1.7 with MySQL 8.0.31 - Community Server (Wampserver) but failed to connect. Any suggestion?
You can double check if the DLL file which you uploaded is correct.
Or try 32-bit version of the dll file.
Thanks!
hello and thank you for these clear explanations.
But I have a problem, every time I try to connect ivms 4200 AC with my MYSQL database, I get the following error: third-party database connection failed. please check the database connection and click save.
i'm using wampserver with mysql version 8.0
What could be the cause
Could be various reasons,
1. Make sure the iVMS4200 and WAMP server are using one of these: x86 or x64
2. Are iVMS4200 and MySQL on the same server?
3. Ensure that there is no firewall or any other blocking the access.
Thanks!
Hi! Thank you so much for the explanation, it was very useful! I don't know if you could give me directions on how to fix a little issue i have. All my registers show as IN, even with the timetables configured. The attendance and the extra hours are calculated just fine in the app but when passing my data to the db it doesn't show when people leave their shift, it registers it like another entrance.
Hello Paz,
You’ll need to enable attendance status on the device.
Thanks!
@@AfhamnaExplains Thank you a loooot, I'll try it!
there are more data on my ivms4200 but some are not automatically added to the third party database
how is it possible to export this data manually?
On ivms4200, there is an option to download the records again by selecting a time period, once manually downloaded, records will sync onto database. Hope it helps!
Good job and it is what I looking for
Glad it helped! :)
if someties the internet is down ? is there any other way to ready data from device and dump it to MySql instead of real time transations ?
There in an option to manually download data from device onto iVMS, when you do that, the data will be synced to MySQL.
Hello Hamid, ive been trying to connect for now, its saying cant connect to database. Please can you please export your database (.sql) and also please link to the particular ivms 4200 you are currently using. Thanks so much
Hello Isaac
May I know what is the issue which you are facing currently, please provide more details!
Hello Hamid, one question please. Is it possible to connect several devices and then the markings are captured by the third party database integration [MySQL]?
Yup, you can connect multiple devices (access control / attendance) to one iVMS4200 and all data can be pushed to MySQL.
Make sure to add devices with different names, these device names will show for every record on MySQL table.
@@AfhamnaExplains many thanks !!
Welcome.
@@AfhamnaExplains Hello, can i have your email ?
You can share yours.
Hello, thank you for your tutorial. But I can connect my database. I have the message: Third-party database connection failed. I use WAMP. MySQL is in version 8.0.27. Did you find the fix of this error?
I haven’t faced this error before.
However, you can check for couple of things
1. Make sure you’ve uploaded the correct dll file
2. Use latest version of iVMS4200
3. Update WAMP if available.
Thanks!
i think remember your firewall on windows.and desable it.thanks
@@zhar_eng8765 thanks for the tip
Hello this video is interesting, I have tried to do it using Laragon but I have not been able to try wampserver
Hello there
Were you able to integrate successfully?
@@AfhamnaExplains no, I can't integrate, I have Windows 11 and I have two computers in different locations, I've tried to use the API, which has allowed me to read the information of some workers but I haven't gotten the endpoint to bring the events, really what I require is to be able to get the inputs and outputs of the workers currently I use this model Hikvision
DS-K1T320EFX which has a facial detector and fingerprint reader, however the IVMS does not meet my needs so I need to make an integration that allows me to do that, what do you suggest?
Hi!,
Thanks for the video. One question, how can I connect it to a mysql database on a web server? (I have a problem with the .dll
Hello there
1. What problem are you facing with DLL’s?
2. Is attendance software and MySQL on the same computer / server?
Thanks!
Hai bro I need to connect HikCentral Access control (Web client) in to mysql database. How to do that?
The process should be similar
Did you try?
Can we connect this iVMS4200 with Remote MySQL Database.. not the localhost?
Haven’t tried it.
However, if the required ports are forwarded on router, it should work.
hi! my iVMS4200 does not show the field for entering the config file. I have entered the rest of the fields as the MAMP mysql server address and port, however the connection still fails.
You’ll need to reinstall IVMS again
@@AfhamnaExplains if i do, will the current data be wiped out?
@user-zr7lo5oi7h it’ll overwrite the existing data.
Hamid! Can you add more tables to the database? Only this table is insufficient to know who did not register when entering. Can Person data be exported to a table?
Hi Jose,
Using third party database integration, we can export only the mentioned data as per this video.
We can export person data on excel table using iVMS / HikCentral.
Hi Hamid! Nice video!
I'm trying to automate the third party database integration, making the FaceRecognition device to apply changes automatically to the DB. The problem we encounter is that it isn't able to update the database automatically. Only forcing the update manually. Any suggestions to that issue?
By other hand, Do you know how the Hikvision People counter work with ivms 4200? Any thoughts about where the local database of ivms 4200 is located?
Hello Miguel,
iVMS may not have sufficient privileges. Try running it as admin and check.
Secondly, the database of ivms4200 is fully encrypted. When we try to open in notepad, it will be gibberish.
One of the the recommended way is to use api or sdk of the hardware and program accordingly.
Hope it helps, thanks!
Hi. I want to connect iVMS4200 with my oracle database. How can I connect?
Apologies, I can’t help on this. I’ve NOT tried it.
Hamid! Thank you for this video. But it only worked than ivms window is opened. How i can send all old data from ivms to mysql database?
Hi Nikolay,
The architecture works in the way as it's mentioned in the thumbnail of this video. If the device or iVMS4200 is not turned ON, then it will not transmit data onto SQL database. Usually, when the software is ON (provided device is ON and connected to network), data will be downloaded onto MySQL. Alternatively, you can manually download the logs onto iVMS, which inturn can push the data onto MySQL. Thanks!
@@AfhamnaExplains Thanks. But how to manually export-import the logs onto iVMS?
@@nikolayt4609 we don’t have an option to import logs onto iVMS.
Hi sir,
Unfortunately, the latest iVMS4200 version won't work. The connection failed error message popup even though everything is alright. I tried SQL Server option too but failed. If you still have your iVMS4200 installation, please share it with us. I want to make sure it just broke on the latest version. Thanks.
Hello Rizal,
Could you provide the version number which you tested with
Thanks!
hello thanks for rhe video
Welcome!
hey! i’m using mysql 5.7.26 on v3.11 of ivms and it shows the connection error when i try to save it - can i check what versions of ivms work w mysql?
i’ve also tried mysql version 5.7.44 and the latest 8.2, all of which don’t seem to work with the latest version of ivms
Did you try using latest version of iVMS?
Have you uploaded the right dll file?
What is the error message?
@@AfhamnaExplains i figured it out, apparently IVMS only works with x86 versions of mysql and not x64
Great. Thanks for the feedback
@@chloeho9655 Hi. Where you find the mysql installer for x86?
I Cant connect to MySQL, followed everything but it failed. I am Using Mysql server 5.7 and Mysqlworkbench 8.0 for database
. Any tips on how to fix it?
What error message are you getting?
Hi Hamid,
Nice tutorial.
Hamid, can you give example how to Push or Send user data from 3'rd apps to Hikvision devices using API?
Need guide for that things.
Thankyou
hi Ryan, You’ll have to approach your local distributor and sign an NDA with them, then they can provide the API documentation.
Thank you!
Can I send data to my remote MySQL without using the localhost? I mean to my server.
Yes, you can, if your server (with MySQL) and another computer (with iVMS) are on the same network.
@@AfhamnaExplains how it can be on the same network, lets suppose my server in USA and Ivms in our local machine? 2. is it possible to use VPS? plz
Hi, I'm having trouble linking the DB. I did all the steps as in the video, however, when saving in IVMS, I get a connection error with the thirdparty database.
Can you help me?
Couple of things to check from your side:
1. Make sure both MySQL and iVMS4200 are on same PC / same network (firewall should be disabled).
2. If both are on same pc try with localhost .
3. Check if you have uploaded proper dll file.
4. Use latest version of iVMS
5. Ensure that all the fields are correctly mapped.
@@AfhamnaExplains i have this problem too. i checked all this things but problem still here. localhost is working but when saving in IVMS, I get a connection error with the thirdparty database
Did you upload the correct dll file?
@@AfhamnaExplains sure.
@@AfhamnaExplains sure
Is it possible using this Integration to create a webpage to add a reg plate to the anpr camera.
Not possible.
Is this the same exact process for doing 3rd party integration in HikCentral Professional?
Yes, it’s almost similar
Additionally, there is option to include or exclude devices (in case if you don’t need any data to be sent to sql from any particular device(s))
Hope it helps!
Is it possible to chat with you somewhere privately bro, i’m actually facing an issue if you don’t mind , would appreciate your help thanks
You can reach out to me on this temporary address: 2ca8aebv@duck.com
@@AfhamnaExplains sent bro
@@AfhamnaExplainshave you received my email bro?
Hi nice video.... Can you tell your mysql db is 32bit or 64bit ... thank you
Welcome!
It’s 64 bit.
Is there an option to download that version? As I'm having problems connecting the new one to mysql
It’s recommended to use latest version of iVMS & MySQL
@@AfhamnaExplains I understand but I'm unable to make it work, it just wont save when apply to database is on. What should I do?
@@jeck263 what error message did you get?
@@AfhamnaExplains it says saving failed Third-party database connection failed. Please check the database connection and click save
That's all I'm getting
Hi, is that resolved?
Hi Hamid, I tried to connect a third party database online with the server ip adress , user name and password , i didn’t find the right version of the lib , is the 5.6.43 I don’t know if I can try something else.
Hi Ivan
Do you have access to the server?
Good day i have two device on the same ivms and one of them not sending the attendance log to database what shall i do
Double check if you are able to get attendance logs on the software.
Followed the same steps but not connected. Any idea
There could be a problem with the dll file, please double check!
@@AfhamnaExplains tried several times but not working. I installed MAMP server and .dell file given parth same as video.
Hi hamid sir,
Is there any other software in that we can upload user information from third party database and get information when the user is IN ?
Hi Zakariya,
APIs could be a solution for this.
@@AfhamnaExplains thanks for the reply.
Could you suggest any free api ?
You’ll have to get in touch with your local distributor and sign NDA
Hello Bro. can you give me advice. i have also error like that: Third-party database connection failed please check connection.
what i did already:
1. changed dll file of from 5,1 to 8 version of mysql
2. mysql and ivms on same computer
3. mysql using from openserver
4. checked port 3306. connection from other db client
Firewall or antivirus could be blocking the ports. Please double check.
The crucial moment here: as iVMS is built for the x86 architecture, you have to provide the libmysql.dll file for x86. I also stuck with it and my solution was to install MySQL server x86 (32-bit) locally and to provide the installed libmysql.dll file to iVMS. If you install MySQL Server for x64 architecture and provide libmysql.dll from it, it will cause the "Third-party database connection failed..." error
@@nighter20i will give that a try, but can u please tell me how to get the config file path input box back? I only have Database Type: MySQL then server IP. How do i get the config file path inlut box back?
@@christiaanvanjaarsveldt242 I was also confused that it disappeared after I restarted iVMS. I gave up and reinstalled it from scratch (all it's settings were lost, obviously). You can try putting the correct libmysql.dll file to that location that was in the path fields before it disappeared.
@@nighter20 Thank you for the tip
If i update data on mysql manually, is it automatic sync to ivms db ?
Please your kindly answer.. very thanks
Not possible.
Hi sir, I wanted to ask you if it is possible to manipulate a database through queries on a local host?
Hello Bralze,
Yes, you can run update query on MySQL database provided sql user has sufficient privileges.
@@AfhamnaExplains
Do you have a video or documented guide on how I could rig it?
@@p0ue I don't have any currently. You can do a google search and check!
Thank you sir
Welcome!
Cant connect to MySQL, followed everything but it failed. Any tips on how to avoid this error.?
May I know what type of MySQL are you using?
Like XAMPP or MAMP or anything similar to that.
Es posible hacerlo con laragon? no me funciona la conexion
Haven’t tested with it. MySQL is included in it, so theoretically it should work.
¿third party database option records include temperature field?
Only HikCentral supports temperature field. (Provided you use temperature screening access control system).
hello, I follow all your process and it works locally, but connecting to a remote server causes a disconnection, it indicates that the data is wrong, save the access data and try again, you will know the reason for the failure
1. Do you mean that the connection to remote server is disconnected always? Or is it unstable? (Connects and then disconnects after sometime)
2. What is the exact error message you are getting? (Also mention if you got the error when saving the sql settings on iVMS or when a user marks attendance on the device)?
@@AfhamnaExplains 1. the remote connection with the device is stable and is maintained.
@@AfhamnaExplains 2. the error occurs after certain attempts by a user to mark attendance on the device, it says problems with the connection to the database (this on a remote server of my database on a local server like XAMPP is well maintained on Registration.)
1. Ensure that the connection is fully wired. Between devices, server with DB and iVMS
2. Are there any other databases / instances apart from the DB for iVMS?
3. Ensure you are using latest version of XAMPP & iVMS
4. Double check firewall on both.
@@AfhamnaExplains -yes, the connection of both computers is by cable to the network
-Inside the local computer, only ivms and a local server for XAMPP databases are installed and the connection tests are made with both the server in the cloud and the local one for the databases.
-the connection between iVMS and the reader is good and is well maintained.
-All permissions were given.
Hey Hamid, may I ask for this software, how am I able to save the data of other fields into database. For example, right now I am trying to do something where it will detect if this person has passed by this area so I can save the data into database for further action. Or do you have any other ideas on how to work on this kind of project? Thank you in advance :D
You can place one device (or multiple) in each area and set the device name based on area. Whenever a person appears infront of the device. The device name, date-time, employee Id will appear (along with other fields)
Later you can run sql command to filter out for a particular area (particular device(s)).
This is limitation on iVMS
However, if you use Hik-Central, you’ll have option to select particular devices and sql data will populate only for the selected devices. Unselected device(s) data will NOT populate on sql database.
Hope it’s clear!
It’s bit outdated, but this link would help a bit.
bit.ly/hik-integration
@@AfhamnaExplains Okay, so for example let say now I am able to filter out the data for the particular area, am I able to take the data from the database and do some integration with my codes? For example I use the data in the database to send email to that person.
@@AfhamnaExplains Thanks for the quick reply! It's been awhile since I get an active user that replies my comment.
Also I would like to add on another scenario is that, is it possible to check if this user has been registered for certain area? Example, I have 2 area, but that person only registered for area 1's device, then when that person goes to area 2, will the device get detected where that person is not registered for area 2?
Hamid, I have database connection error with mysql and sql databasese both. I did as u showed in this and other videos. But I get 'Thisr party database connection failed' error anyway. How can I fix this??
Hi ZYR,
May I know what MySQL client are you using?
Did you upload the proper dll file?
@@AfhamnaExplains Hi Hamid! I am using microsoft mysql installer - community. I uploaded the proper dll. I don't know the reason why the connection failing ((
Hi @@zy.r.4323
Could you send screenshot of the error and also, the fields on MySQL table?
What port is your MySQL running?
Please double check if firewall is blocking the ports.
What version of iVMS4200 are you using?
Are iVMS4200 and MySQL instance on the same PC?
@@AfhamnaExplains UA-cam doesn't allow sending screenshots. port:3306. iVMS4200 V 3.5.0.4 build 20210203. iVMS4200 and MySQL are now on the same pc. but I have to integrate on remote server. I'm testing on localhost
@@zy.r.4323 You are using the latest version of iVMS4200.
What version of MySQL are you using?
If telnet is enabled, then try telnet localhost 3306 to see if it enters.
Btw, you can use any image hosting service ( pasteboard.co/ / imgur.com/upload )to upload the screenshot and share the uploaded image link in the comments.
How can i get image of pass record?
kindly provide more details
@@AfhamnaExplains, I need to get for pass record snapshot which camera make before facial recognition process
hi thanks for the video. i have a question if i want to add online mysql database how do i get the dll file.? please help
When you install MySQL, by default will save a copy the dll file onto the installed directory!!
@@AfhamnaExplains thank you
Sir ...i want show same data in hikision camera display.....can you help me
This works only for DS-K series access control / attendance terminals only,
@@AfhamnaExplains ok sir.
Sir tell me about this..if you have any idea.
API / SDK can help if you need to integrate camera with third party system!
You’ll have to contact local distributor to get more details.
@@AfhamnaExplains ok sir thanks 🙏
Welcome!
Hello, where can I find the complete database structure?
Software Backed is completely encrypted.
Third party database connection failed. I did the same steps as in the video. What is wrong? can you help me please?
Hi can double check if you had uploaded the correct dll file.
Secondly, make sure the credentials are correct and the MySQL has access to connect to iVMS.
@@AfhamnaExplains can i connect ivms to database in my web hosting? can you help me?
@@bayubp5084 usually on the same network it works fine (MySQL and iVMS). Haven’t tried with two different networks.
@@AfhamnaExplains oke thank you, your information is very helpful
Niceeeee
Glad you liked it.!
Wow amazing...so how can I join it to visual basic studio 6000
Not possible
hello, how to send automatically times attendances report by mail
There is an option in iVMS where you’ll have to enter your email server details and you have option to select what types of reports you’ll require via email.
Can we connect it with online server?
It should work provided the required ports are open
Where to find the libmysql.dll file in xampp?
Depends on the type of MySQL app which you are using
Hello! Can I have your email in order to talk about an integration of this feature that I need in Mexico?
Share your email address, I’ll drop an email. Thanks!
@@AfhamnaExplains luisenrique.lopez01@gmail.com
Thank you!!
Why i can't connect to MySql DB. MySQL Version: v5.7.24, MySQL Version: v5.7.24. "Third-party database connection failed."
1. Did you upload correct dll file?
2. Does the sql user has admin privileges?
3. Is MySQL port open?
@@AfhamnaExplains 1. Yes is correct "C:\Program Files\MySQL\MySQL Server 5.7\lib\libmysql.dll"
@@AfhamnaExplains 2. I Login as root | 3. yes is open 3306 set as 127.0.0.1
@@AfhamnaExplains Hello i still cannot connect to MySQL thirdparty database. Any solution?
@@andharuwicaksono6980
what version of iVMS are you using?
Are you using MySQL only or are you using any stack similar to xampp or MAMP or any other? If yes, let me know.
can i use mysql instead of mamp?
Yes
@@AfhamnaExplains i tried with different programms but i never can establish a connection to a database. I'm using a different machine from other company, it's from safire, the SF-AC3002KEMD-IP, but I think the it works is the same that safire
i need to install some kind of connector before I try to do this?
Make sure you upload the correct DLL file.
im using xampp how to find configuration dll file ?
You can install this windows app “everything” and search for the particular dll file.
@@AfhamnaExplains im using windows ivms4200 xampp for mysql i cant find the mysql dll file at xampp folder ? i want to know dll file name for
xampp , thanks
It’s the same as mentioned in the video.
Anyone could connect? still same error third-party database connection failed.
What’s the error message?
Where exactly are you struck?
@@AfhamnaExplains Hello sir, Thank you for the reply.
Could you please give me your email address? Then I can send every screenshot and more details.
The problem is if I try with HikCentral Access Control Web Client using my DB credentials it works. But the same credentials not working for ivms software.
I am using,
ivms V1.8.1.4 AC
MySQL community 8.0.31.0
Both software run the same pc
Error msg: third-party database connection failed. please check the database connection and click save
Screenshots: drive.google.com/drive/folders/1uQfykHkDsFF75cw296SWyqYmX-isk62Z?usp=sharing
Table Col:
`id` varchar(255)
`cardno` varchar(255)
`personname`
`devicesn` varchar(255)
`devicename` varchar(255)
`direction` varchar(255)
`time` time
`date` date
`datetime` datetime
I don't have a license key for HikCentral Access Control Web Client therefor ivms software is very important to me sir
That’s bit strange.
Could you create a new database with a table in it and try?
Secondly, follow the same order when creating columns in table (it should be same as mentioned in iVMS interface)
@@AfhamnaExplains Face recognition terminal iVMS-4200 shows an error when connecting to the mysql database
What error message did you get?
When did you get error message?
Hi Bro, Could you share the source code are running ? Very appreciated it!
There is no source code
You can just follow the Procedure as mentioned in the video.
Thanks!
@@AfhamnaExplains Hi Bro. I have one trouble might need your help. I see in my SQL have around 10 log event while in Hikcentral shown up to 100 log event . Thank so much !
Here are couple of things which you can check
1. Let’s say if you have 3 devices, there is an option in HikCentral to choose which devices needs to sync with database.
2. Check only today’s logs and see if the count matches with number of records on sql server.
3. Usually, when sql is down, HikCentral will not sync with sql. If sql is down for less than 16 days (if I am not wrong), the data will be synced with sql server automatically, will require couple of hours to sync.
@@AfhamnaExplains Thank very much Bro. Let me observe all the things you recommented 🙏
Welcome!
How to use it with PHP and mysql
MySQL Integration mentioned in this video.
We can’t integrate with PHP
@@AfhamnaExplains Is it possible to integrate it with PHP
@@aizazaziz5636 no
do ivms4200 provide api?
No.
@@AfhamnaExplains i want to push to the server but what if there is no internet connection. is there any option to push previous unsync datas to the server database
The whole setup can work even if there’s no internet connection. SQL Database and iVMS should be on the same computer or same network. If there’s temporary network connectivity issue, the logs usually will get downloaded automatically once the network is stable.
Secondly, if you still need API access, you can use HikCentral. You’ll have to sign NDA with Hik team. To know more details, you need to get in touch with Hikvision Distributor in your local region.
@@AfhamnaExplains ok thanks man