I have local mysql non docker already running, I want to reuse it and not allowed #857

edrimon · 2023-07-07T10:39:54Z

edrimon
Jul 7, 2023

Hi,

There is already a non docker local Mysql I want to reuse, just to add a new DB called koillection etc.

However if I remove that db part from docker-compose, as I do not want a mysql DB docker to start, I get the message:
ERROR: Service 'koillection' depends on service 'db' which is undefined.

I do not find also any config parameters related. So the question is, how can I run koillektion with an already existing DB? Or even to connect to an external mysql/postgress DB etc. not requiring to start a local docker instance just for koillection?

benjaminjonard · 2023-07-07T11:25:59Z

benjaminjonard
Jul 7, 2023
Maintainer

Hello,

I don't have an easy way to test this, but you should be able to achieve this by removing the depends_on property and adding a network_mode property :

version: '3'

services:
    # Koillection
    koillection:
        image: koillection/koillection
        container_name: koillection
        restart: unless-stopped
        network_mode: host
        ports:
            - 80:80
        env_file:
            - .env
        volumes:
            - ./volumes/koillection/uploads:/uploads

Then in your .env file you should update DB_HOST with your database IP

Make sure your database is started before starting the Koillection container

2 replies

edrimon Jul 7, 2023
Author

Tried that , after downloading the containers, it crashes with error:
ERROR: for koillection "host" network_mode is incompatible with port_bindings

I guess I need some tuning in the docker compose level but I need to dig and I am not so familiar..

benjaminjonard Jul 7, 2023
Maintainer

Yes, I guess you have to remove the ports property too

edrimon · 2023-07-07T13:44:02Z

edrimon
Jul 7, 2023
Author

I do not think the ports should be removed, as I want the docker to listen to a port and this to be mapped to the O/S port in order to be called and reachable by other services, from what I understand. Anyway, I think I got it, I will reply hopefully soon that it was solved. thanks

…

On Fri, Jul 7, 2023 at 4:33 PM Benjamin Jonard ***@***.***> wrote: Yes, I guess you have to remove the ports property too — Reply to this email directly, view it on GitHub <#857 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAJAG4EL7FLWMRHIJIALTADXPAF4JANCNFSM6AAAAAA2BUOKUE> . You are receiving this because you authored the thread.Message ID: ***@***.*** com>

0 replies

edrimon · 2023-07-07T14:26:30Z

edrimon
Jul 7, 2023
Author

I tried now to follow the alternative for installation, 1. php bin/console bazinga:js-translation:dump assets/js --format=js says: There are no commands defined in the "bazinga:js-translation" namespace. Did you mean this? app:translations 2. Configure a vhost (you can find an example for nginx in docs folder) -> (There is nowhere a "docs" folder) 3. Generate assets : cd assets/ && yarn install && yarn build && cd .. -> 00h00m00s 0/0: : ERROR: [Errno 2] No such file or directory: 'install' It seems there is no file or directory "install" inside assets folder but other files. Can you please advice?

…

On Fri, Jul 7, 2023 at 4:43 PM Efthymios Drymonas ***@***.***> wrote: I do not think the ports should be removed, as I want the docker to listen to a port and this to be mapped to the O/S port in order to be called and reachable by other services, from what I understand. Anyway, I think I got it, I will reply hopefully soon that it was solved. thanks On Fri, Jul 7, 2023 at 4:33 PM Benjamin Jonard ***@***.***> wrote: > Yes, I guess you have to remove the ports property too > > — > Reply to this email directly, view it on GitHub > <#857 (reply in thread)>, > or unsubscribe > <https://github.com/notifications/unsubscribe-auth/AAJAG4EL7FLWMRHIJIALTADXPAF4JANCNFSM6AAAAAA2BUOKUE> > . > You are receiving this because you authored the thread.Message ID: > ***@***.*** > com> >

2 replies

benjaminjonard Jul 7, 2023
Maintainer

I updated the wiki, it was a bit outdated. Very few people uses this installation method, I think it's really going the hard way

I updated the command, it is php bin/console app:translations:dump now
There is a nginx vhost in the docker folder you can use as an exemple (it's the vhost used by the docker container)
I could execute that command without trouble, try to go into the assets folder and that execute : yarn install then yarn build

benjaminjonard Jul 7, 2023
Maintainer

If it can help you, I managed to connect to a Mysql database like this :

version: '3'

services:
    # Koillection
    koillection:
        image: koillection/koillection
        container_name: koillection
        restart: unless-stopped
        extra_hosts:
            - "host.docker.internal:host-gateway"
        ports:
            - 81:80
        env_file:
            - .env
        volumes:
            - ./volumes/koillection/uploads:/

And in my .env.local

DB_DRIVER=pdo_mysql
DB_NAME=koillection
DB_HOST=127.0.0.1
DB_PORT=3306
DB_USER=root
DB_PASSWORD=password
DB_VERSION=8

edrimon · 2023-07-07T14:50:32Z

edrimon
Jul 7, 2023
Author

Thanks, I am in the assets folder, I try "yarn install", I get the following: 00h00m00s 0/0: : ERROR: [Errno 2] No such file or directory: 'install'

…

On Fri, Jul 7, 2023 at 5:39 PM Benjamin Jonard ***@***.***> wrote: I updated the wiki, it was a bit outdated. I updated the command, it is php bin/console app:translations:dump now There is a nginx vhost in the docker folder you can use as an exemple (it's the vhost used by the docker container) I could execute that command without trouble, try to go into the assets folder and that execute : yarn install then yarn build — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you authored the thread.Message ID: ***@***.***>

1 reply

benjaminjonard Jul 7, 2023
Maintainer

I can only point you to a stack overflow thread :/ yarn install should trigger the javascript dependencies installation, not search for a directory

https://stackoverflow.com/questions/46013544/yarn-install-command-error-no-such-file-or-directory-install

edrimon · 2023-07-07T14:56:03Z

edrimon
Jul 7, 2023
Author

Thanks, according to your docker suggestion, the docker container now keeps restarting, I get this in the logs. In your case it starts normally? 14:55:00 CRITICAL [console] Error thrown while running command "'doctrine:migration:migrate' --no-interaction --allow-no-migration --env=prod". Message: "An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory" ["exception" => Doctrine\DBAL\Exception\ConnectionException { …},"command" => "'doctrine:migration:migrate' --no-interaction --allow-no-migration --env=prod","message" => "An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory"]

…

On Fri, Jul 7, 2023 at 5:53 PM Benjamin Jonard ***@***.***> wrote: I can only point you to a stack overflow thread :/ yarn install should trigger the javascript dependencies installation, not search for a directory https://stackoverflow.com/questions/46013544/yarn-install-command-error-no-such-file-or-directory-install — Reply to this email directly, view it on GitHub <#857 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAJAG4G5C4R6OAIFOYUW25LXPAPF3ANCNFSM6AAAAAA2BUOKUE> . You are receiving this because you authored the thread.Message ID: ***@***.*** com>

0 replies

edrimon · 2023-07-08T11:23:40Z

edrimon
Jul 8, 2023
Author

The thing is that I am trying DB_HOST=host.docker.internal , which should work, as I am listening to 172.17.0.1:3306 and this is the IP that host.docker.internal resolves to according to the extra_hosts: host.docker.internal:host-gateway definition. Now I keep getting "An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection timed out"] It seems that I cannot connect from docker. I managed to connect using host networking and pointing directly to 127.0.0.1 IP but then it couldn't start, as port 80 was already taken by another docker container and I cannot use the port mapping in host networking. Another useful thing I thought could work was to forward the unix socket, but then I am not sure how can I connect to the forwarded socket according to this nice article (check the first answer): mysql - Docker-Compose: connect to host when host.docker.internal doesn't work - Stack Overflow <https://stackoverflow.com/questions/74527573/docker-compose-connect-to-host-when-host-docker-internal-doesnt-work> I understand that this is not supported or not implemented yet, but I have struggled lots of hours to make it work, Please kindly could you help ? We are having a very big collection of 78rpm records digitized and we would really want to test this using some metadata. Thanks and Regards

…

On Fri, Jul 7, 2023 at 5:55 PM Efthymios Drymonas ***@***.***> wrote: Thanks, according to your docker suggestion, the docker container now keeps restarting, I get this in the logs. In your case it starts normally? 14:55:00 CRITICAL [console] Error thrown while running command "'doctrine:migration:migrate' --no-interaction --allow-no-migration --env=prod". Message: "An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory" ["exception" => Doctrine\DBAL\Exception\ConnectionException { …},"command" => "'doctrine:migration:migrate' --no-interaction --allow-no-migration --env=prod","message" => "An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory"] On Fri, Jul 7, 2023 at 5:53 PM Benjamin Jonard ***@***.***> wrote: > I can only point you to a stack overflow thread :/ yarn install should > trigger the javascript dependencies installation, not search for a directory > > > https://stackoverflow.com/questions/46013544/yarn-install-command-error-no-such-file-or-directory-install > > — > Reply to this email directly, view it on GitHub > <#857 (reply in thread)>, > or unsubscribe > <https://github.com/notifications/unsubscribe-auth/AAJAG4G5C4R6OAIFOYUW25LXPAPF3ANCNFSM6AAAAAA2BUOKUE> > . > You are receiving this because you authored the thread.Message ID: > ***@***.*** > com> >

0 replies

benjaminjonard · 2023-07-08T12:17:43Z

benjaminjonard
Jul 8, 2023
Maintainer

Maybe you could have a look to the last answer on this thread :

https://stackoverflow.com/questions/35586778/docker-container-doesnt-expose-ports-when-net-host-is-mentioned-in-the-docker

I'll try to find another solution when I'm home

1 reply

edrimon Jul 8, 2023
Author

Thanks, but this thing is that this does not work, as port 80 is already used as written earlier. How can I change the port to be other than 80 ?

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

I have local mysql non docker already running, I want to reuse it and not allowed #857

{{title}}

Replies: 7 comments 6 replies

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

Select a reply

I have local mysql non docker already running, I want to reuse it and not allowed #857

edrimon Jul 7, 2023

Replies: 7 comments · 6 replies

benjaminjonard Jul 7, 2023 Maintainer

edrimon Jul 7, 2023 Author

benjaminjonard Jul 7, 2023 Maintainer

edrimon Jul 7, 2023 Author

edrimon Jul 7, 2023 Author

benjaminjonard Jul 7, 2023 Maintainer

benjaminjonard Jul 7, 2023 Maintainer

edrimon Jul 7, 2023 Author

benjaminjonard Jul 7, 2023 Maintainer

edrimon Jul 7, 2023 Author

edrimon Jul 8, 2023 Author

benjaminjonard Jul 8, 2023 Maintainer

edrimon Jul 8, 2023 Author

edrimon
Jul 7, 2023

Replies: 7 comments 6 replies

benjaminjonard
Jul 7, 2023
Maintainer

edrimon Jul 7, 2023
Author

benjaminjonard Jul 7, 2023
Maintainer

edrimon
Jul 7, 2023
Author

edrimon
Jul 7, 2023
Author

benjaminjonard Jul 7, 2023
Maintainer

benjaminjonard Jul 7, 2023
Maintainer

edrimon
Jul 7, 2023
Author

benjaminjonard Jul 7, 2023
Maintainer

edrimon
Jul 7, 2023
Author

edrimon
Jul 8, 2023
Author

benjaminjonard
Jul 8, 2023
Maintainer

edrimon Jul 8, 2023
Author