SMRT Portal has dificulty connecting to the smrtportal mysql database - pb-dyim/SMRT-Analysis GitHub Wiki

SMRT Portal has difficulty connecting to the smrtportal mysql database after installation if you have a unique setting in your myslq my.conf file.

Following is the typical error when you try to create the first administrator user:

Error listing Users. Case; 'hibernate.dialect' must be set when no Connection available.

Enter grep bind /etc/mysql/my.cnf.

If you had changed the bind address to something other than the default 127.0.0.1, then you need to replace localhost in the $SEYMOUR_HOME/redist/tomcat/webapps/smrtportal/WEB-INF/classes/META-INF/persistence.xml file with the actual IP address, or hostname of the server running mysql.