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)