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. <put in beta script version>
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 <3306>
10. check the hibernate.cfg.xml file and make sure the correct information for the MySQL server is present. <property name="connection.driver_class">com.mysql.jdbc.Driver</property> <property name="connection.url">jdbc:mysql://<MySQLSERVER>/cms</property>
11. after making any changes to files manually, it is best practice to restart the apache tomcat service.
12. trying logging in again.
Content Disclaimer
Informasi ini disarikan dari Wikipedia dan disajikan kembali untuk tujuan edukasi. Konten tersedia di bawah lisensi CC BY-SA 3.0. Kami tidak bertanggung jawab atas ketidakakuratan data yang bersumber dari kontribusi publik tersebut.
- The information displayed on this website is sourced in part or in whole from Wikipedia and has been adapted for the purpose of restating it. We strive to provide accurate and relevant information, however:
- There is no guarantee of absolute accuracy. Wikipedia is an open, collaborative project that can be edited by anyone, so information is subject to change.
- It is not intended to constitute professional advice. The content displayed is for informational and educational purposes only. For important decisions (e.g., medical, legal, or financial), please consult a professional.
- Content copyright. Wikipedia is licensed under the Creative Commons Attribution-ShareAlike License (CC BY-SA). This means that content may be reused with appropriate attribution and shared under a similar license.
- Responsible use. Any risk arising from the use of information from this website is entirely the responsibility of the user.