Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Bitbucket Bitbucket Server Backup Client database connection problem

E-Global Trade & Finance Group, Inc
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 8, 2019

Hi

I found solution for bitbucket backup https://marketplace.atlassian.com/apps/1211500/bitbucket-server-backup-client?hosting=server&tab=support

I downloaded this solution and created necessary config in backup-config.properties

I used login pass for user with admin privelegies 

When running script it's fails

In bitbucket log file I see 

Caused by: com.atlassian.stash.internal.backup.BackupException: An error occurred while backing up the database
at com.atlassian.stash.internal.maintenance.backup.DatabaseBackupStep.run(DatabaseBackupStep.java:84)
at com.atlassian.stash.internal.maintenance.CompositeMaintenanceTask$Step.run(CompositeMaintenanceTask.java:133)
at com.atlassian.stash.internal.maintenance.CompositeMaintenanceTask.run(CompositeMaintenanceTask.java:69)
at com.atlassian.stash.internal.maintenance.backup.BackupPhase.run(BackupPhase.java:71)
... 15 common frames omitted
Caused by: com.atlassian.stash.internal.backup.liquibase.LiquibaseDataAccessException: Failed to obtain snapshot. Database type: mysql; nested exception is liquibase.exception.DatabaseException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied; you need (at least one of) the SHOW DATABASES privilege(s) for this operation
at com.atlassian.stash.internal.backup.liquibase.DefaultLiquibaseSession.getSnapshot(DefaultLiquibaseSession.java:76)
at com.atlassian.stash.internal.backup.liquibase.LiquibaseSessionThreadLocal.getSnapshot(LiquibaseSessionThreadLocal.java:49)
at com.atlassian.stash.internal.backup.liquibase.DefaultLiquibaseDao.countRows(DefaultLiquibaseDao.java:139)
at com.atlassian.stash.internal.backup.liquibase.DefaultLiquibaseMigrationDao.countTotalRows(DefaultLiquibaseMigrationDao.java:111)
at com.atlassian.stash.internal.backup.liquibase.DefaultLiquibaseMigrationDao.backup(DefaultLiquibaseMigrationDao.java:74)
at com.atlassian.stash.internal.maintenance.backup.DatabaseBackupStep.run(DatabaseBackupStep.java:82)
... 18 common frames omitted
Caused by: liquibase.exception.DatabaseException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied; you need (at least one of) the SHOW DATABASES privilege(s) for this operation

 

How I can fix it?

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events