Database error after changing server instances #15

New issue

Open

opened 2023-12-30 04:31:03 +00:00 by carlyman · 0 comments

carlyman commented

2023-12-30 04:31:03 +00:00

Incomplete set of error messages:

pixelfed-db  | 2023-12-30  4:00:40 22 [Warning] Access denied for user 'pixelfed'@'172.18.0.15' (using password: YES)
pixelfed-db  | 2023-12-30  4:01:39 23 [Warning] Access denied for user 'pixelfed'@'172.18.0.17' (using password: YES)
pixelfed-db  | 2023-12-30  4:02:40 25 [Warning] Access denied for user 'pixelfed'@'172.18.0.20' (using password: YES)
pixelfed-db  | 2023-12-30  4:03:41 28 [Warning] Access denied for user 'pixelfed'@'172.18.0.21' (using password: YES)
pixelfed-db  | 2023-12-30  4:04:41 29 [Warning] Access denied for user 'pixelfed'@'172.18.0.22' (using password: YES)
pixelfed-db  | 2023-12-30  4:13:44 48 [Warning] Access denied for user 'pixelfed'@'172.18.0.23' (using password: YES)
---
pixelfed-db  | 2023-12-30  4:13:18 47 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
---
pixelfed-app     | PHP Fatal error:  Uncaught mysqli_sql_exception: Access denied for user 'pixelfed'@'172.18.0.23' (using password: YES) in /wait-for-db.php:12
pixelfed-app     | Stack trace:
pixelfed-app     | #0 /wait-for-db.php(12): mysqli_connect()
pixelfed-app     | #1 /wait-for-db.php(20): connect()
pixelfed-app     | #2 {main}
pixelfed-app     |   thrown in /wait-for-db.php on line 12
pixelfed-app     | + '[' '!' -z ']'
pixelfed-app     | + cp -r storage.skel/app storage.skel/debugbar storage.skel/framework storage.skel/logs storage.skel/purify storage/
pixelfed-app     | + chown -R www-data:www-data storage/ bootstrap/
pixelfed-app     | + php /wait-for-db.php
pixelfed-app     | PHP Fatal error:  Uncaught mysqli_sql_exception: Access denied for user 'pixelfed'@'172.18.0.23' (using password: YES) in /wait-for-db.php:12
pixelfed-app     | Stack trace:
pixelfed-app     | #0 /wait-for-db.php(12): mysqli_connect()
pixelfed-app     | #1 /wait-for-db.php(20): connect()
pixelfed-app     | #2 {main}
pixelfed-app     |   thrown in /wait-for-db.php on line 12

I moved from one EC2 instance to a new one (used same volume, reattached). All my other services I host using docker were successful in starting up; however, my Pixelfed stack has database connection issues. Nothing changed in my docker-compose or env file that I used to create the Pixelfed stack to begin with. Incomplete set of error messages: ``` pixelfed-db | 2023-12-30 4:00:40 22 [Warning] Access denied for user 'pixelfed'@'172.18.0.15' (using password: YES) pixelfed-db | 2023-12-30 4:01:39 23 [Warning] Access denied for user 'pixelfed'@'172.18.0.17' (using password: YES) pixelfed-db | 2023-12-30 4:02:40 25 [Warning] Access denied for user 'pixelfed'@'172.18.0.20' (using password: YES) pixelfed-db | 2023-12-30 4:03:41 28 [Warning] Access denied for user 'pixelfed'@'172.18.0.21' (using password: YES) pixelfed-db | 2023-12-30 4:04:41 29 [Warning] Access denied for user 'pixelfed'@'172.18.0.22' (using password: YES) pixelfed-db | 2023-12-30 4:13:44 48 [Warning] Access denied for user 'pixelfed'@'172.18.0.23' (using password: YES) --- pixelfed-db | 2023-12-30 4:13:18 47 [Warning] Access denied for user 'root'@'localhost' (using password: NO) --- pixelfed-app | PHP Fatal error: Uncaught mysqli_sql_exception: Access denied for user 'pixelfed'@'172.18.0.23' (using password: YES) in /wait-for-db.php:12 pixelfed-app | Stack trace: pixelfed-app | #0 /wait-for-db.php(12): mysqli_connect() pixelfed-app | #1 /wait-for-db.php(20): connect() pixelfed-app | #2 {main} pixelfed-app | thrown in /wait-for-db.php on line 12 pixelfed-app | + '[' '!' -z ']' pixelfed-app | + cp -r storage.skel/app storage.skel/debugbar storage.skel/framework storage.skel/logs storage.skel/purify storage/ pixelfed-app | + chown -R www-data:www-data storage/ bootstrap/ pixelfed-app | + php /wait-for-db.php pixelfed-app | PHP Fatal error: Uncaught mysqli_sql_exception: Access denied for user 'pixelfed'@'172.18.0.23' (using password: YES) in /wait-for-db.php:12 pixelfed-app | Stack trace: pixelfed-app | #0 /wait-for-db.php(12): mysqli_connect() pixelfed-app | #1 /wait-for-db.php(20): connect() pixelfed-app | #2 {main} pixelfed-app | thrown in /wait-for-db.php on line 12 ```

No labels

No milestone

No project

No assignees

1 participant

Notifications

Due date

The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: dockers/pixelfed#15

No description provided.