502 bad gateway error after hitting bookstack url #5144

Closed
opened 2026-02-05 09:43:20 +03:00 by OVERLORD · 29 comments
Owner

Originally created by @sachinvishwakarma26 on GitHub (Jan 22, 2025).

Attempted Debugging

  • I have read the debugging page

Searched GitHub Issues

  • I have searched GitHub for the issue.

Describe the Scenario

Hi @ssddanbrown we are tried to configure bookstack on RHEL 9 and we have completed all configuration setup with following you're document.
we are running application on Nginx web serrvice and we are able to access application through localhost but in not in port no 80 in the browser, its throwing error like bad gateway.
Could you please help us here.

2024-07-RHEL9-install (1).pdf

Exact BookStack Version

8.2

Log Content

No response

Hosting Environment

Hi @ssddanbrown we are tried to configure bookstack on RHEL 9 and we have completed all configuration setup with following you're document.
we are running application on Nginx web serrvice and we are able to access application through localhost but in not in port no 80 in the browser, its throwing error like bad gateway.
Could you please help us here.

Originally created by @sachinvishwakarma26 on GitHub (Jan 22, 2025). ### Attempted Debugging - [x] I have read the debugging page ### Searched GitHub Issues - [x] I have searched GitHub for the issue. ### Describe the Scenario Hi @ssddanbrown we are tried to configure bookstack on RHEL 9 and we have completed all configuration setup with following you're document. we are running application on Nginx web serrvice and we are able to access application through localhost but in not in port no 80 in the browser, its throwing error like bad gateway. Could you please help us here. [2024-07-RHEL9-install (1).pdf](https://github.com/user-attachments/files/18510140/2024-07-RHEL9-install.1.pdf) ### Exact BookStack Version 8.2 ### Log Content _No response_ ### Hosting Environment Hi @ssddanbrown we are tried to configure bookstack on RHEL 9 and we have completed all configuration setup with following you're document. we are running application on Nginx web serrvice and we are able to access application through localhost but in not in port no 80 in the browser, its throwing error like bad gateway. Could you please help us here.
OVERLORD added the 🐕 Support label 2026-02-05 09:43:20 +03:00
Author
Owner

@sachinvishwakarma26 commented on GitHub (Jan 23, 2025):

Hi @ssddanbrown ,

Kindly provide the resolution for the same

@sachinvishwakarma26 commented on GitHub (Jan 23, 2025): Hi @ssddanbrown , Kindly provide the resolution for the same
Author
Owner

@ssddanbrown commented on GitHub (Jan 23, 2025):

Hi @sachinvishwakarma26,
You mentioned following my guide but you also mentioned nginx, whereas my guide is using Apache.

  • What web server are you actually using on the server to run with PHP/BookStack?
  • Have you introduced any additional proxy layers or other web-servers?
@ssddanbrown commented on GitHub (Jan 23, 2025): Hi @sachinvishwakarma26, You mentioned following my guide but you also mentioned nginx, whereas my guide is using Apache. - What web server are you actually using on the server to run with PHP/BookStack? - Have you introduced any additional proxy layers or other web-servers?
Author
Owner

@sachinvishwakarma26 commented on GitHub (Jan 23, 2025):

Hi @ssddanbrown ,

1.> What web server are you actually using on the server to run with PHP/BookStack?
Answer: we are using Nginx web server
2.> Have you introduced any additional proxy layers or other web-servers?
Answer: No

@sachinvishwakarma26 commented on GitHub (Jan 23, 2025): Hi @ssddanbrown , 1.> What web server are you actually using on the server to run with PHP/BookStack? Answer: we are using Nginx web server 2.> Have you introduced any additional proxy layers or other web-servers? Answer: No
Author
Owner

@ssddanbrown commented on GitHub (Jan 23, 2025):

@sachinvishwakarma26 What nginx configuration did you use?

@ssddanbrown commented on GitHub (Jan 23, 2025): @sachinvishwakarma26 What nginx configuration did you use?
Author
Owner

@sachinvishwakarma26 commented on GitHub (Jan 23, 2025):

Hi @ssddanbrown.

This is the below nginx configuration

server {
listen 80;
server_name scsbookstack.adaptikcloud.com;
root /var/www/BookStack/public;

access_log /var/log/nginx/bookstack_access.log;
error_log /var/log/nginx/bookstack_error.log;

client_max_body_size 1G;
fastcgi_buffers 64 4K;

index index.php;

location / {
try_files $uri $uri/ /index.php?$query_string;
}

location ~ ^/(?:.htaccess|data|config|db_structure.xml|README) {
deny all;
}

location ~ .php(?:$|/) {
fastcgi_split_path_info ^(.+.php)(/.+)$;
include fastcgi_params;
fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
fastcgi_param PATH_INFO $fastcgi_path_info;
fastcgi_pass unix:/run/php-fpm.sock;
}

location ~* .(?:jpg|jpeg|gif|bmp|ico|png|css|js|swf)$ {
expires 30d;
access_log off;
}
}

@sachinvishwakarma26 commented on GitHub (Jan 23, 2025): Hi @ssddanbrown. This is the below nginx configuration server { listen 80; server_name scsbookstack.adaptikcloud.com; root /var/www/BookStack/public; access_log /var/log/nginx/bookstack_access.log; error_log /var/log/nginx/bookstack_error.log; client_max_body_size 1G; fastcgi_buffers 64 4K; index index.php; location / { try_files $uri $uri/ /index.php?$query_string; } location ~ ^/(?:\.htaccess|data|config|db_structure\.xml|README) { deny all; } location ~ \.php(?:$|/) { fastcgi_split_path_info ^(.+\.php)(/.+)$; include fastcgi_params; fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name; fastcgi_param PATH_INFO $fastcgi_path_info; fastcgi_pass unix:/run/php-fpm.sock; } location ~* \.(?:jpg|jpeg|gif|bmp|ico|png|css|js|swf)$ { expires 30d; access_log off; } }
Author
Owner

@ssddanbrown commented on GitHub (Jan 23, 2025):

@sachinvishwakarma26

  • Did you definitely install BookStack to the /var/www/BookStack path? In my guide I did not, but used /var/www/bookstack.
  • Have you verified PHP-FPM is installed and running, with a socket available at the /run/php-fpm.sock path?
@ssddanbrown commented on GitHub (Jan 23, 2025): @sachinvishwakarma26 - Did you definitely install BookStack to the `/var/www/BookStack` path? In my guide I did not, but used `/var/www/bookstack`. - Have you verified PHP-FPM is installed and running, with a socket available at the `/run/php-fpm.sock` path?
Author
Owner

@sachinvishwakarma26 commented on GitHub (Jan 23, 2025):

Hi @ssddanbrown

Bookstack and php-fpm are installed and as well as service running.

Image

Image

@sachinvishwakarma26 commented on GitHub (Jan 23, 2025): Hi @ssddanbrown Bookstack and php-fpm are installed and as well as service running. ![Image](https://github.com/user-attachments/assets/2c8b74f8-c687-4175-928b-fba33eff7b8b) ![Image](https://github.com/user-attachments/assets/04491f7a-9a17-4de3-aca4-91d05106859b)
Author
Owner

@sachinvishwakarma26 commented on GitHub (Jan 23, 2025):

Image

@sachinvishwakarma26 commented on GitHub (Jan 23, 2025): ![Image](https://github.com/user-attachments/assets/2cbeb114-ab4c-40a0-91c1-4f3160e22623)
Author
Owner

@ssddanbrown commented on GitHub (Jan 23, 2025):

@sachinvishwakarma26

Fix the /var/www/BookStack/public path in your nginx config to be /var/www/bookstack/public since that's what's shown on your terminal. Then restart nginx and test again.

If it's still not working, Please confirm if lines are added to the /var/log/nginx/bookstack_error.log on attempted access. If so, please share the log messages.
If not, is anything logged to /var/log/nginx/bookstack_access.log?

@ssddanbrown commented on GitHub (Jan 23, 2025): @sachinvishwakarma26 Fix the `/var/www/BookStack/public` path in your nginx config to be `/var/www/bookstack/public` since that's what's shown on your terminal. Then restart nginx and test again. If it's still not working, Please confirm if lines are added to the ` /var/log/nginx/bookstack_error.log` on attempted access. If so, please share the log messages. If not, is anything logged to ` /var/log/nginx/bookstack_access.log`?
Author
Owner

@sachinvishwakarma26 commented on GitHub (Jan 23, 2025):

Hi @ssddanbrown

Thanks now bookstack url is accessible with port no 80.

we need to one more help currently one more bookstack application already running in Amazon linux2. So we wanted to transfer the data to new Rhel9 server bookstack URL. Could you please provide some any steps to transfer the exiting data instead of copying manually.

Tanks,
Prakash

@sachinvishwakarma26 commented on GitHub (Jan 23, 2025): Hi @ssddanbrown Thanks now bookstack url is accessible with port no 80. we need to one more help currently one more bookstack application already running in Amazon linux2. So we wanted to transfer the data to new Rhel9 server bookstack URL. Could you please provide some any steps to transfer the exiting data instead of copying manually. Tanks, Prakash
Author
Owner

@sachinvishwakarma26 commented on GitHub (Jan 24, 2025):

Hi @ssddanbrown ,

Kindly provide the update for the same?

Thanks,
Prakash

@sachinvishwakarma26 commented on GitHub (Jan 24, 2025): Hi @ssddanbrown , Kindly provide the update for the same? Thanks, Prakash
Author
Owner

@watschi commented on GitHub (Jan 24, 2025):

You can find backup & restore instructions in the official documentation at https://www.bookstackapp.com/docs/admin/backup-restore/

@watschi commented on GitHub (Jan 24, 2025): You can find backup & restore instructions in the official documentation at https://www.bookstackapp.com/docs/admin/backup-restore/
Author
Owner

@sachinvishwakarma26 commented on GitHub (Jan 27, 2025):

Hi @watschi @ssddanbrown ,

We are trying to take db backup but its throwing below error. Kindly suggest here.

Image

@sachinvishwakarma26 commented on GitHub (Jan 27, 2025): Hi @watschi @ssddanbrown , We are trying to take db backup but its throwing below error. Kindly suggest here. ![Image](https://github.com/user-attachments/assets/7c98fe85-4ece-494b-aae7-a038568393b3)
Author
Owner

@sachinvishwakarma26 commented on GitHub (Jan 28, 2025):

Team,

Kindly provide the update for the same.

@sachinvishwakarma26 commented on GitHub (Jan 28, 2025): Team, Kindly provide the update for the same.
Author
Owner

@ssddanbrown commented on GitHub (Jan 28, 2025):

@sachinvishwakarma26 That bookstack user you're using for the mysql dump command probably needs a password, which you're not defining.

You might be able to use either of these:

# Run the mysqldump via the root user
sudo mysqldump -u root bookstack > bookstack.backup.sql

# Run the mysqldump via the bookstack user, and prompt for password
mysqldump -u bookstack -p bookstack > bookstack.backup.sql
@ssddanbrown commented on GitHub (Jan 28, 2025): @sachinvishwakarma26 That `bookstack` user you're using for the mysql dump command probably needs a password, which you're not defining. You might be able to use either of these: ```bash # Run the mysqldump via the root user sudo mysqldump -u root bookstack > bookstack.backup.sql # Run the mysqldump via the bookstack user, and prompt for password mysqldump -u bookstack -p bookstack > bookstack.backup.sql ```
Author
Owner

@sachinvishwakarma26 commented on GitHub (Jan 28, 2025):

we have tried but isn't working

@sachinvishwakarma26 commented on GitHub (Jan 28, 2025): we have tried but isn't working
Author
Owner

@ssddanbrown commented on GitHub (Jan 28, 2025):

So have you tried this?

mysqldump -u bookstack -p bookstackdb > bookstack.backup.sql

(and enter bookstack@ when promoted for the password)

@ssddanbrown commented on GitHub (Jan 28, 2025): So have you tried this? ```bash mysqldump -u bookstack -p bookstackdb > bookstack.backup.sql ``` (and enter `bookstack@` when promoted for the password)
Author
Owner

@sachinvishwakarma26 commented on GitHub (Jan 28, 2025):

Hi @ssddanbrown ,

Thanks for youre valauble support as you suggested you are able to take the backup and restoration also done.
but after restoration we are getting below error.

Image

@sachinvishwakarma26 commented on GitHub (Jan 28, 2025): Hi @ssddanbrown , Thanks for youre valauble support as you suggested you are able to take the backup and restoration also done. but after restoration we are getting below error. ![Image](https://github.com/user-attachments/assets/3ce362e7-f8bf-4361-b221-9c9e4637b819)
Author
Owner

@sachinvishwakarma26 commented on GitHub (Jan 29, 2025):

Hi @ssddanbrown ,

Kindly provide the update for the same.

@sachinvishwakarma26 commented on GitHub (Jan 29, 2025): Hi @ssddanbrown , Kindly provide the update for the same.
Author
Owner

@watschi commented on GitHub (Jan 30, 2025):

Did you follow all steps in the backup and restore documentation (https://www.bookstackapp.com/docs/admin/backup-restore/)?
You will probably need to update your URLs as described there.

If you followed all steps and are still facing errors, please see the debugging guide at https://www.bookstackapp.com/docs/admin/debugging/ and provide any errors from your log files.

@watschi commented on GitHub (Jan 30, 2025): Did you follow all steps in the backup and restore documentation (https://www.bookstackapp.com/docs/admin/backup-restore/)? You will probably need to update your URLs as described there. If you followed all steps and are still facing errors, please see the debugging guide at https://www.bookstackapp.com/docs/admin/debugging/ and provide any errors from your log files.
Author
Owner

@sachinvishwakarma26 commented on GitHub (Jan 30, 2025):

@watschi,

Yes we have followed the backup and restore documentation and successfully restoration completed.

We went to through debugging steps everything is correcet.

@sachinvishwakarma26 commented on GitHub (Jan 30, 2025): @watschi, Yes we have followed the backup and restore documentation and successfully restoration completed. We went to through debugging steps everything is correcet.
Author
Owner

@sachinvishwakarma26 commented on GitHub (Jan 30, 2025):

Hi @ssddanbrown.

We are using mariadb database for bookstack.
Could you please help me out how to take backup and restore commands

@sachinvishwakarma26 commented on GitHub (Jan 30, 2025): Hi @ssddanbrown. We are using mariadb database for bookstack. Could you please help me out how to take backup and restore commands
Author
Owner

@sachinvishwakarma26 commented on GitHub (Jan 30, 2025):

Hi @ssddanbrown ,

we are getting below Database error. Kindly advise here.

Image

@sachinvishwakarma26 commented on GitHub (Jan 30, 2025): Hi @ssddanbrown , we are getting below Database error. Kindly advise here. ![Image](https://github.com/user-attachments/assets/6c9ed9f8-b33c-4d5f-a291-702cd544459e)
Author
Owner

@ssddanbrown commented on GitHub (Jan 30, 2025):

We went to through debugging steps everything is correcet.

With all due respect, I can no longer believe what you say since you very clearly provided incorrect information in the original post, which wastes extra time of people trying to help you.

That looks like a bad restoration.
It's essential that you restore the mysqldump file into a completely empty database.
It cannot have existing tables.

Assuming nothing is important in that new target database, Empty the new target database (drop all tables) then try again.
After restoring, run the php artisan migrate on your BookStack instance and save the output you get on the command line. Report back if there are any errors. It's important you do this on first run after restore. Subsequent runs of this command may not result in the same information.

@ssddanbrown commented on GitHub (Jan 30, 2025): > We went to through debugging steps everything is correcet. With all due respect, I can no longer believe what you say since you very clearly provided incorrect information in the original post, which wastes extra time of people trying to help you. That looks like a bad restoration. It's essential that you restore the mysqldump file into a completely empty database. It cannot have existing tables. Assuming nothing is important in that new target database, Empty the new target database (drop all tables) then try again. After restoring, run the `php artisan migrate` on your BookStack instance and save the output you get on the command line. Report back if there are any errors. It's important you do this on first run after restore. Subsequent runs of this command may not result in the same information.
Author
Owner

@sachinvishwakarma26 commented on GitHub (Jan 30, 2025):

@ssddanbrown ,

Can you help us to drop the tables with command and also provide command details for taking backup and as well as restore

@sachinvishwakarma26 commented on GitHub (Jan 30, 2025): @ssddanbrown , Can you help us to drop the tables with command and also provide command details for taking backup and as well as restore
Author
Owner

@sachinvishwakarma26 commented on GitHub (Jan 31, 2025):

@ssddanbrown ,

Kindly provide the updates for the same.
Note: We are using MariaDB

@sachinvishwakarma26 commented on GitHub (Jan 31, 2025): @ssddanbrown , Kindly provide the updates for the same. Note: We are using MariaDB
Author
Owner

@sachinvishwakarma26 commented on GitHub (Feb 3, 2025):

@ssddanbrown ,

Kindly update the status

@sachinvishwakarma26 commented on GitHub (Feb 3, 2025): @ssddanbrown , Kindly update the status
Author
Owner

@watschi commented on GitHub (Feb 3, 2025):

Hi @sachinvishwakarma26

this is free software with people (Dan) working on it for free, so please don't excessively tag people for updates. They are already notified the first time, and there are no obligations regarding support.

As to your questions:
The command for backup and restore have been provided to you multiple times now, they are documented in the backup and restore documentation as well as in Dan comments in this thread. If there are any issues with them you need to provide the errors you're receiving executing them, otherwise we can't help with those.

For dropping the tables, the easiest way is to just delete the database, command should easily be found with an internet search. Dropping/deleting a database: https://mariadb.com/kb/en/drop-database/
For recreating, follow the install guide you've linked to already.

@watschi commented on GitHub (Feb 3, 2025): Hi @sachinvishwakarma26 this is free software with people (Dan) working on it for free, so please don't excessively tag people for updates. They are already notified the first time, and there are no obligations regarding support. As to your questions: The command for backup and restore have been provided to you multiple times now, they are documented in the backup and restore documentation as well as in Dan comments in this thread. If there are any issues with them you need to provide the errors you're receiving executing them, otherwise we can't help with those. For dropping the tables, the easiest way is to just delete the database, command should easily be found with an internet search. Dropping/deleting a database: https://mariadb.com/kb/en/drop-database/ For recreating, follow the install guide you've linked to already.
Author
Owner

@ssddanbrown commented on GitHub (Feb 25, 2025):

Thanks @watschi,
Since there has been on further follow up on this since I'm going to go ahead and close it off.

@ssddanbrown commented on GitHub (Feb 25, 2025): Thanks @watschi, Since there has been on further follow up on this since I'm going to go ahead and close it off.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/BookStack#5144