database migration failure

cellvoz

Hi,

We have a remote mysql server and get a error in the migration, "bitbucket does not have adequate permissions to create a temporary table in the target database when connected as the specified user. Please check that the user has permission to CREATE TEMPORARY TABLES"

But we already create a database user with full granted permissions, we probe the user and permission from CLI of server and works fine.

 

[root@Tharbad /]# mysql -h 192.168.7.5 -u btbckuser -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3468184
Server version: 5.7.19-log MySQL Community Server (GPL)

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| bitbucket |
+--------------------+
2 rows in set (0.00 sec)

mysql> use bitbucket;
Database changed
mysql> CREATE TEMPORARY TABLE IF NOT EXISTS table2 AS (SELECT 1,2);
Query OK, 1 row affected (0.00 sec)
Records: 1 Duplicates: 0 Warnings: 0

Andy Heinzer

Hi Oscar,

What version of Bitbucket is this?   I would recommend walking back through the steps in Connecting Bitbucket Server to MySQL to be sure we have the database and user setup correctly.

I would want to check would be, after granting this user privileges, did you use a

FLUSH PRIVILEGES;

command in mysql to make sure that this rights this user has are getting applied as such.

If that doesn't help, try to restart the bitbucket application once more to see if you can still recreate this error.  If you can gather the log files from Bitbucket during the times these errors get generated.  You can find these in then <Bitbucket home directory>/log

I would be interested to take a closer look at these logs, perhaps there are other clues there that can help us better understand this error.

Andy