 Now, I am going to tell you the how to troubleshoot our clicker software ok, already we have explained two session the same session was happen how to configure clicker software in your server I am correct I think we have send you the form regarding how many of them they have installed properly how many of them having a error to install our software, but according to that of the people they have still they have a facing problem to troubleshoot some errors like proper way of connecting a database connections creating a database and putting a dump into the server. So, I like to explain some way what are the errors most of the people getting and then how to solve that error ok, the first one most of the people getting the problem with HTTP status 500 actually it is a problem because of whatever request you are giving it is not able to respond that is the main problem it mean that when you are goes to that co-read a registration link. So, what will happen you are not properly configure the database. So, that is a problem it shows it is not able to response the your request. So, what you have to do first step you have to just you have to properly configure the database connection that is a very important and one more thing I like to tell you sure you have to use database username and password as clicker underscore ui everything is small it is very much it is very carefully you have to note it down and one more thing first you have to go to terminal and you have to check whether you have properly created the username clicker underscore ui as less you have given the password as clicker underscore ui. So, for checking that one just you give the command as mysql space hyphen u space clicker ui space hyphen p. So, it will ask you a password try to give the same password clicker underscore ui if it shows error it mean that you have wrongly created the username or password. So, what you have to do again you log in with root so, you have to drop the username already if exist ok. So, what you have to do drop user clicker underscore ui at local host. So, what it will do if you have wrongly created username as clicker underscore ui it will drop the username again you can go for creating the same with correct password ok. Then you have to create a new the same username password with clicker underscore ui create user clicker underscore ui the same command you have to use it will it will help you to create a username clicker underscore ui it is a main thing you have to create the username as clicker underscore ui and another one after that then please try to check you have properly dump the database for command my sql the from root only you have to dump the our sql dump. So, it is a very important you have you have the database remote aka clicker it is carrying all your coordinated details and your institute details. So, you supposed to have this database then after that give a privileges it is very important. So, many people what they are doing they have dump your my sql after they are forgot to give the privileges without privileges you cannot able to access any data inside the database. So, what it will do after when you going to registration page in a drop down it will never come your remote center name and ID. So, it will not proper registration will not happen. So, give a privileges to access the database that is your wish you can give the database that is the only thing it is enough you have to give a privileges for our database remote aka clicker that one will do ok. Then after database dump and then privileges given you have to yeah fine sorry ok. These are the steps when the username and password is incorrect in my sql ok if it is login successfully. So, it mean that you have already created a username and password correctly, but you may miss something what is that that is a giving a dump as well as privileges the same step 2 a3 that this one ok. This two step you have to follow if you have login successfully with clicker underscore ui username as well as password ok if it is not you have to create drop the user then create a user then you have to dump then give a privileges if login successful with the same username password then you have to create a dump then you go for giving a privileges. Is the first error you are facing when you get the error HTTP status 500 no second way what is happening some people is properly able to go to this page it will give a error when you are it will not pop up the remote center from the remote center name whatever you are typing it will automatically come it will be popped down from that only you have to select. So, if it is not coming it mean that you are not giving a privileges for your database. So, if you are not given a privileges so it you never get the data from your database. So, it will never get pop up here then so for that what you have to do the simple thing you have to give a privileges so it if it goes that page it mean that you properly created a database and properly you have dumped everything only the missing thing is you are not given a privileges then you have to restart the MySQL server then next is a when only very few people will get this kind of error ok. So, actually what what happened first of all I I want to ask you sorry for this one it is because of our side. So, what happened you have downloaded the our war file at 11 o'clock I am correct at the time of presentation at Friday I think so that time what happened at 10 o'clock 10 30 we have uploaded on war that was some error who are all downloaded that war file that people only will face this kind of error. So, if you are facing this this error it mean that you have downloaded the world war try to replace with new war before session itself we have we have tell them to replace the war who are all downloaded previously. So, if you are if you are not if you are not forgot to change the dump just please try to use the new war still it is available in moodling. So, what you have to do simple all the steps you have to follow first you have to remove the x already available in available war ok. So, for that simply you have to go to the command term and then you have to remove the war file as well as folder which was created when you are starting the Tomcat. After removing the war file you have to copy the new war file first we have to go to the folder where you are where the current the new war is available ok after that from that just go to the just you have to copy war into the web apps folder which is available in Tomcat. Then simply you have to restart the Tomcat after that it will work fine after when you are replacing only war it will work fine ok ok. Some people will get everything will work fine so, here you can see the message waiting for main center instructor so, if you are getting it mean that you are properly connected with our main IIT server ok. Some people will get the error like you are not connection refused you are not problem with your internet or IIT server is down. If you are getting that error it is a problem with your side of connecting with IIT server you have to check your internet connection that is the only problem. Some people will not get the institute name it is very much mandatory you supposed to get your institute name here if you are not getting the institute name it mean that what you will get that quiz when you are launching here you can able to answer the response will send to IIT we can collect the response, but in response we does not know it is responses from which remote center it is will be unknown remote center so, please avoid that one for that you have it will problem will come when there will be when you are selecting a remote center pop down will come, but some people what they are doing instead of selecting from that one they are type they are manually so, what will happen it will not match with the data it is a present in database so, what you have to do you have to the two cases are there one is manually you are typing the remote center another one some people already using existing one the world war which one we have uploaded 10 30 year around so, that people also some people will login successfully, but they will not get the remote center name so, same you have to replace the war the same steps you have to delete the existing war then you have to copy the new wars then one more thing you have to do that is you have to remove the coordinator already we have strictly followed that only one person can login for your our application currently we are not giving a more people to login so, for that already you was login so, we you suppose to delete that entry in your database so, for that you have to go to MySQL with the same database same username click underscore UI then you have to choose our database remote aka slicker after that you have to delete the coordinator table simple steps if you are follow this full line of code it will drop the entries which is available already you have registered so, again so, I tell you what will happen in our coordinator table we will have a one feel like matching with your institute ID so, it will be 0 so, that is why it shows nothing in the institute ID so, you if you are dropping that data only you will get go for press registration so, what you have to do you have to delete the coordinator table then you have just restart the server after that that one will do that is it then you can go for registration again these are the three problem the people almost facing another one problem people what is that that is that connection is not happened with IIT that is the it will not get the message like waiting for main center instructor if you are not get you are not getting this message it mean that you are not connect your internet connection is problem with your side in our side all in 24 into 7 our server will be in run mode only so, only few time when we are restarting and when we are changing our application that time only it will be it will be in a just block mode so, every time we will be in running mode only so, we our side we will not get any problem so, check your net connection and one more thing some people you are using proxy getting lot of problem still I am actually I have send you the form out of that form I getting 150 responses in this 150 off of the people they are using proxy, but it is working properly, but when I am getting call from the people technical people they are telling we are using proxy it is not working when you are removed when you are bypassing the proxy it is working fine with connected with IIT so, that one we are resolving that problem in next version sure we will get back with get back with you with proxy also that is the only thing it was happen then at almost people they are using proxy it work fine also it was connected with our IIT server.