Not able to dumb bitnami_reportserver internal database

ReportServer (EN)
1

Hi,

We were trying to find our bitnami_reportserver internal database root credentials , but we were not able to find that ,

When we are going to reset mysql root password using the user “bn_reportserver” following this

https://www.cyberciti.biz/tips/recover-mysql-root-password.html

step 2 is saying:

2017-01-19T15:02:39.346591Z mysqld_safe Directory ‘/var/run/mysqld’ for UNIX socket file don’t exists.

this is whole message:

grep: write error: Broken pipe
2017-01-19T15:02:39.325001Z mysqld_safe Logging to syslog.
2017-01-19T15:02:39.332987Z mysqld_safe Logging to ‘/var/log/mysql/error.log’.
2017-01-19T15:02:39.339042Z mysqld_safe Logging to ‘/var/log/mysql/error.log’.
2017-01-19T15:02:39.346591Z mysqld_safe Directory ‘/var/run/mysqld’ for UNIX socket file don’t exists.

Also cursor is blinking like busy.
It doesn’t return terminal string. It is on blank line blinking on first position after error line.

So I have tried to dumb the database , but while dumbing the same , I am getting the following error :-

This is error on dump:

mysqldump: Got error: 1045: Access denied for user ‘bn_reportserver’@‘localhost’ (using password: YES) when trying to connect.

Could you please help us to sort out this issue.

Regards,
Sreejith

2

We did finally succeed in dumping the internal database. We are learning a bit from trying database queries, including a 6 table query to relate users to reports and teamspaces.