502 bad gateway error after hitting bookstack url

[sachinvishwakarma26]

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.

[sachinvishwakarma26]

Hi @ssddanbrown ,

Kindly provide the resolution for the same

[ssddanbrown]

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?

[sachinvishwakarma26]

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

[ssddanbrown]

@sachinvishwakarma26 What nginx configuration did you use?

[sachinvishwakarma26]

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;
}
}

[ssddanbrown]

@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?

[sachinvishwakarma26]

Hi @ssddanbrown

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

[sachinvishwakarma26]

[ssddanbrown]

@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?

[sachinvishwakarma26]

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]

Hi @ssddanbrown ,

Kindly provide the update for the same?

Thanks,
Prakash

[watschi]

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

[sachinvishwakarma26]

Hi @watschi @ssddanbrown ,

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

[sachinvishwakarma26]

Team,

Kindly provide the update for the same.

[ssddanbrown]

@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

[sachinvishwakarma26]

we have tried but isn't working

[ssddanbrown]

So have you tried this?

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

(and enter bookstack@ when promoted for the password)

[sachinvishwakarma26]

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.

[sachinvishwakarma26]

Hi @ssddanbrown ,

Kindly provide the update for the same.

[watschi]

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.

[sachinvishwakarma26]

@watschi,

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

We went to through debugging steps everything is correcet.

[sachinvishwakarma26]

Hi @ssddanbrown.

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

[sachinvishwakarma26]

Hi @ssddanbrown ,

we are getting below Database error. Kindly advise here.

[ssddanbrown]

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.

[sachinvishwakarma26]

@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]

@ssddanbrown ,

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

[sachinvishwakarma26]

@ssddanbrown ,

Kindly update the status

[watschi]

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.