Cannot register administrator for the first time due to hibernate.dialect error

SMRT Portal has difficulty connecting to the smrtportal MySQL database after installation if you have a unique setting in your MySQL 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.

To resolve this issue, first verify that you have changed the MySQL bind address to something other than the default 127.0.0.1:

grep bind /etc/mysql/my.cnf

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