Checklist for solving ~~MEDIA_ACCESS_FAILURE~~

Checklist for solving MEDIA_ACCESS_FAILURE

This guide assumes that you have installed openCRX 2.0 Server. For more information see here.

Database is not running

The MySQL database may not be able to start. You can check this as follows:

On Linux platforms

• Open a shell
• Go to the directory .\opencrxServer-2.0.0\bin
• cat control.sh and lookup the line which says /usr/sbin/mysqld --defaults-file=...
• Copy/Paste this line to the console and try to execute it manually. The MySQL daemon should start correctly
• If it does not start mysqld should output an error message which should help you to solve the problem. Typical problems are security related. In this case try to start MySQL with mysqld_safe instead of mysqld. If that helps modify control.sh correspondingly

On Windows platforms

• Launch the MySQL System Tray Monitor
• Right-click on the MySQL System Tray Monitor and select the menu entry Configure Instance
• You get a dialog showing a list of installed MySQL services
• Try to start/stop the service with the name opencrx-2.0.0-mysql. If the service can not be started you should get an error message which should help you to solve the problem

Database resource configuration is not valid

• Go to the directory .\opencrxServer-2.0.0\apache-tomcat-6\deployment-units\jdbc-mysql-5.rar\META-INF and open the file ra.xml
• Also check the content of the context configuration files located in .\conf\Catalina\localhost
• Check whether the connection properties for UserName, Password and ConnectionURL match your MySQL database settings

Database driver is missing

• Go to the directory .\opencrxServer-2.0.0\apache-tomcat-6\lib and check whether it contains the JAR file mysql-connector-java-bin.jar