Author Topic: Error on new CentOS 6 installation  (Read 2368 times)

cursor

  • Newbie
  • *
  • Posts: 26
  • Karma: 0
    • View Profile
Error on new CentOS 6 installation
« on: July 20, 2011, 01:46:37 »
We are doing a new installation on CentOS 6 and after installing rpm packages and setting upthe database we get:

MySQL settings: creating temporary table    Error    Java Error: Problema DB: java.sql.SQLException: Can't create table 'temp_284365' (errno: 13) QueueMetrics requires the grants to create temporary tables to run. Please edit your MySQL configuration.

We have checked permissions and they seem fine.  The user has all privileges for the queuemetrics database.  Maybe there is a compatibility problem with mysql and the java connector?

marcos

  • Loway
  • Full Member
  • *
  • Posts: 138
  • Karma: 3
    • View Profile
Re: Error on new CentOS 6 installation
« Reply #1 on: July 25, 2011, 11:45:34 »
Hi,

It could be. What version of mysql is running on the box?
Are you able to create a temporary table with the mysql user queuemetrics through a command line?

Thank you and regards,
Marco Signorini.

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: Error on new CentOS 6 installation
« Reply #2 on: August 08, 2011, 11:44:23 »
We are tracking this as issue #1359. Anybody else has the same issue?