Selfhosted

40165 readers

592 users here now

A place to share alternatives to popular online services that can be self-hosted without giving up privacy or locking you into a service you don't control.

Rules:

Be civil: we're here to support and learn from one another. Insults won't be tolerated. Flame wars are frowned upon.
No spam posting.
Posts have to be centered around self-hosting. There are other communities for discussing hardware or home computing. If it's not obvious why your post topic revolves around selfhosting, please include details to make it clear.
Don't duplicate the full text of your blog or github here. Just post the link for folks to click.
Submission headline should match the article title (don’t cherry-pick information from the title to fit your agenda).
No trolling.

Resources:

selfh.st Newsletter and index of selfhosted software and apps
awesome-selfhosted software
awesome-sysadmin resources
Self-Hosted Podcast from Jupiter Broadcasting

Any issues on the community? Report it using the report flag.

Questions? DM the mods!

founded 1 year ago

MODERATORS

LinguaCafe - Confused why the provided docker-compose doesn't work. (self.selfhosted)

submitted 9 months ago* (last edited 9 months ago) by Natal to c/selfhosted

13 comments fedilink hide all child comments

Hello everyone,

Recently found LinguaCafe and decided to spin it up. There's a provided docker-compose with just volumes to specify to your own taste. Pretty easy right?

I can't make it work. Spent nearly two hours already trying to figure out what I'm missing.

Can someone take a look at my compose file and tell me where I'm stupid?

_____________ EDITS

Progress has been made, I used chmod 777 on the whole app directory and now get the following error : Illuminate\Database\QueryException SQLSTATE[HY000] [1045] Access denied for user 'linguacafe'@'ip adress censored' (using password: YES) (SQL: select count(*) as aggregate from users)

Here's a somewhat anonymized pastebin, I just removed the password and my name from the file. The rest is basically the file provided by the github + my paths. https://pastebin.com/u2cbWm2n

https://github.com/simjanos-dev/LinguaCafe

What happens is, my containers spin up apparently properly. But when I go to :9191, I have this:

https://imgur.com/a/PiazCcP

I did sudo chmod 777 /home/user/Documents/Docker/LinguaCafe/temp -R as instructed by the documentation.

Never had that happen before. Does anyone know? Thanks

you are viewing a single comment's thread
view the rest of the comments

[–] [email protected] 3 points 9 months ago* (last edited 9 months ago)

Did you change the mysql container database name, username and password to something other than the default linguacafe ?

That would break it, as it's using those specific credentials to login to the database. Which would cause Access denied for user ‘linguacafe’@‘ip adress censored’ (using password: YES) (SQL: select count(*) as aggregate from users)

Try with the default, you'll need to wipe the mysql data under /home/user/Documents/Docker/LinguaCafe/database/ after stopping the container first.

    environment:
        MYSQL_DATABASE: linguacafe
        MYSQL_USER: linguacafe
        MYSQL_PASSWORD: linguacafe
        MYSQL_ROOT_PASSWORD: linguacafe
        SERVICE_NAME: linguacafe