Puppet - JIRA module not connecting to mySQL

asked 2015-05-13 13:39:49 -0500

pup-master gravatar image

I'm in the process of deploying Atlassian's Confluence and JIRA on separate RHELs.

Confluence was simple. But on JIRA, I'm having trouble connecting JIRA to mySQL.

Can anyone see how my Puppet code is wrong here? Here I'm using modules to deploy mySQL first, then JIRA. Oracle JDK is running.

node 'jira.oracle' {

class { '::mysql::server':
 root_password           => 'secret',
 remove_default_accounts => true,
 override_options        => $override_options
 }


 ::mysql::db { 'mydb':
 user     => 'jira',
 password => 'secret',
 dbname   => 'jiraDB',
 host     => 'localhost',

}

mysql_grant { 'jira@localhost/*.*':
  ensure     => 'present',
  options    => ['GRANT'],
  privileges => ['ALL'],
  table      => '*.*',
  user       => 'jira@localhost' ,
}


mysql_grant { 'root@10.0.0.9/*.*':
  ensure     => 'present',
  options    => ['GRANT'],
  privileges => ['ALL'],
  table      => '*.*',
  user       => 'root@10.0.0.9' ,
}

class { 'jira':
javahome       => '/usr/java/jdk1.8.0_45',
mysql_connector_install => '/opt/MySQL-connector' ,
mysql_connector_manage => true ,
user        => 'jira',
dbpassword  => 'secret',
dbserver    => 'localhost',
dbname => 'jiraDB',
db => 'mysql',
dbtype => 'mysql',
   }   }

(http://jira-IP-Address:8080) leads to "HTTP Status 500 - Could not determine database type. (Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.)"

(http://localhost:3306) mySQL page says "4���5.1.73����r^`G$|da�ÿ÷��������������;AsA+S?#-[aU���ÿ„Got packets out of order" Thanks.

UPDATE: with the updated code, mySQL Workbench can access the database. Now need to connect JIRA to it. Also it's stuck at black page on http://10.0.0.9:8080/secure/SetupAppl...

edit retag flag offensive close merge delete