User:Mumair

1. Verify that the correct version of MySQL server is running. Verify that the MySQL server is running. you can do so by connecting to the MySQL command line client and running the following command type in the password that you have for root, afterwards run the following command. my-sql>status The result for this command will tell you which version of MySQL is installed. it should be 5.0.16 2. verify the script version that is used.  3. at this point if you dont have a Sentral database already created, apply the schema script to create the tables. 4. check that the tables are created, you can check of some of them by running the following commands my-sql>connect CMS; my-sql>select * from Alerts; my-sql>select * from functionalview; if you do not see any problems till this point, youre database is ready 5. restart the apache tomcat service 6. load the sentral console. 7. as the console loads, if it hangs at about the middle of the progress bar, you have database connection errors. if not, you're good to log into sentral 8. Ping the MySQL machine with the hostname. if it does not reply back, fix your network connectivity. 9. make sure that the port is open on the MySQL server 10. check the hibernate.cfg.xml file and make sure the correct information for the MySQL server is present. com.mysql.jdbc.Driver jdbc:mysql:///cms 11. after making any changes to files manually, it is best practice to restart the apache tomcat service. 12. trying logging in again.