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

[cellvoz]

Hi, thanks for the answer, we already try flushing privileges and get the same result, finally we have another server of BD and works in this one, after installation we manually change the bitbucket.properties to point the first db server, we create and copy the complete schema created by installation in second server and right now is working... same user, same permissions...

We suspect about version of db mysql server.

Server with installation problem (mysqld 5.7.19-community-edition)