jira <> mysql (manual debugging)
 

Trying to spawn up Atlassian JIRA on http://10.213.9.157:8080/ using Puppet's mySQL and JIRA modules. But right now, I'm trying to manually configure mySQL to debug this situation.
I'm getting "HTTP Status 500 - Could not determine database type. (Unknown database 'jiraDB')" plus
{
2015-05-27 11:43:13,618 http-bio-8080-exec-8 ERROR anonymous 703x6x1 - 10.213.9.217 /favicon.ico [NoModule] Could not determine database type.
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'jiraDB'
2015-05-27 11:43:13,670 http-bio-8080-exec-8 ERROR anonymous 703x6x1 - 10.213.9.217 /favicon.ico [NoModule] Error getting datasource via DBCP
}
from /opt/jira/atlassian-jira-6.4.1-standalone/logs/catalina.out

So when I try these on mysql console, I get these errors even after taking out "skip-grant-tables"
(These are what I should be trying, right?)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| jiraDB |
| mysql |
+--------------------+
3 rows in set (0.01 sec)
mysql> create user jira;
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
mysql> grant all on jiraDB.* to 'jira'@'10.213.9.157' identified by 'secret';
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
mysql>

(Also asked this on ask-puppetlabs. But in case anyone here has a clue)

Why are you skipping grant tables?
If you are meaning to script/automate this process, (sorry, I don't know puppet)
Why not use There is no need to actually enter the mysql > environment for this.

Then test those same creds:
The only time in 10+ years in Linux, I only had to use skip-grant-tables is to recover a mysql root_user password.
Bad habit.

right now dealing java issue.

Would you know the full path of Oracle JDK on CentOS?
(For java_home)

Thanks.

I do not, sorry.