Docker BookStack - a platform to create documentation/wiki content built with PHP & Laravel

[finnegan]

Strange indeed. I see some progress after making those changes, but still no dice. Here is the current error.

For reference, this is with the MariaDB tcp connection open w/ port 3306 and associated firewall rule made making it wide open right now for initial testing.

And lastly, just to do some complete testing here, when I append the port to the db_connection env variable, it does not resolve.

Frustrating - this all makes me want to build my own lightweight NAS / docker machine! The one thing I will really miss is photostation...

 

[AdrianEarnshaw]

I am no DB expert but the log suggests that you may not have set up the database correctly using phpMyAdmin as it seems to find your database but the password is incorrect. I've attached my settings, to see if that helps.

 

[finnegan]

I'm no expert either.

When I created these empty DB's in phpMyAdmin, I simple clicked the create new database and took the default option. I then created unique usernames for each of those db's and assigned them passwords (b/c it looks like Synology forces you to do so w/ some addon).

Here is a snapshot from phpMyAdmin

Is there an approved method or steps that I should go through to create those DB's? When I searched online, I followed what I found, but I'm clearly not doing something right.

Also - thank you all for the support!

It might be worth noting that I have been unable to get any docker program to use this DB (in spite of what you may see above in entries). I ultimately got freshrss to work, but only by having it use its own embedded sqlite db.

 

[AdrianEarnshaw]

When I set up my database I just typed in the Database name and selected Create. It then automatically set the user, I did nothing special for that. Also, I just checked my databases and I have bookstack setup in MariaDB5. I set it up a long time ago and cannot remember why I did it under 5 instead of 10.

 

[Telos]

This looks like a possible replacement for Microsoft's OneNote for me. As I played with the demo, I couldn't figure out how I might migrate my OneNote content. Even basic copy/paste turned the formatted text into images. Maybe there's something basic I'm missing.

Any thoughts about transitioning existing works to BookStack?

 

[finnegan]

Welp - i'm not getting much farther w/ various testing options. Let's see if anyone else on this thread has some useful suggestions!

@AdrianEarnshaw I even loaded MariaDB5 and switched the port and got the same error (after again creating the database / user combo).

@Telos for your question, a quick google search turned up this link to a feature request in bookstack. It isn't something that has has been implemented yet, but if you have your Onenote notebooks in the MS Cloud, theoretically, their newer APIs should enable this to be done. Not sure if you're up to that work or not, but perhaps you could lend your voice to the request.

 

[AdrianEarnshaw]

Okay, a little bit of trial and error time. Temporarily disable your firewall on the NAS and see if it connects. If it does then you have a rule blocking access somewhere.

 

[Rusty]

@finnegan one more thing that you could try is to setup another mysql/maria instance inside docker as well. Try using Books with that version. I see you have freshrss and firefly DBs running in this instance. Can you use those DBs with their apps or not?

 

[JosephSmith99]

@finnegan : any luck? I'm literally in the exact same situation as you (MariaDB 10, Synology NAS, Docker, Bookstack,...) and have done all the same things with no luck.

I will say this though: keep the Bookstacker instance running in Docker even though the log seemingly shows nothing is happening. I've had mine open for 20 minutes now and a few new lines pop-up in the log that seem to indicate something is happening --albeit really slowly. In another forum, someone had the same problem as us but after waiting 30min it finally kicked in.

Currently when I try to access the address in Chrome, it went from "This site cannot be reached" to now "504 Gateway Time-out". Fingers crossed, and I'll update in 30-40 minutes if anything changes.

 

[finnegan]

Sorry, @JosephSmith99 , no joy. Tonight I went ahead and let it run for a good 45 mins while I worked out and it never made progress. (amazing how we are all in this together! )

@AdrianEarnshaw - thought of disabling the firewall a few days ago. Did it again tonight for good measure, and no dice. Good idea though!

@Rusty, Over the next few days, when I get some time, I'll try to install mysql in a docker container again and see if I can make more progress. Also, I never got FreshRSS to connect to this DB. In the end, I took the local sqlite option, which seems to work pretty well, actually.

Thanks all!

 

[AdrianEarnshaw]

Sorry to hear that you are still having problems. Have you checked your permissions to access the database inside phpMyAdmin?

I will say this, it is really odd how some people have no problem running things out of Docker yet others have problems. There's a few apps I have given up on as I just couldn't get them to work no matter what I did.

 

[JosephSmith99]

Sorry to hear that you are still having problems. Have you checked your permissions to access the database inside phpMyAdmin?

I will say this, it is really odd how some people have no problem running things out of Docker yet others have problems. There's a few apps I have given up on as I just couldn't get them to work no matter what I did.

Hi AdrianEarnshaw - What do you mean in terms of "permissions to access the database inside phpMyAdmin"? Like, the privileges in MariaDB 10 from phpMyAdmin for the specific user to access the DB? If so, for me, Privileges are "all privileges" and grant is "no" (which I think is what's expected).

 

[AdrianEarnshaw]

Sorry for the poor explanation. In phpMyAdmin go to the User Accounts tab and under there you will see a list of user names. The one that you are using as the login ha it got All Privileges next to it. If not that may be your answer. I've attached a shot from my system, user name blanked out for obvious reasons.

 

[wwwampy]

wwwampy updated BookStack - a platform to create documentation/wiki content built with PHP & Laravel with a new update entry:

v0.31

From version v0.31 new environmental variable is added: APP_URL.

Check the overview site for environmental variables for more details.

Read the rest of this update entry...

 

[AdrianEarnshaw]

wwwampy updated BookStack - a platform to create documentation/wiki content built with PHP & Laravel with a new update entry:

v0.31



Read the rest of this update entry...

Thanks for posting this. I wondered why my container had stopped working. I just added this new variable and its back working again. Many thanks.