Hi all, I wanna ask related to docker. I'd like to...
# orm-helpa
ardit
12/28/2018, 5:21 PMHi all, I wanna ask related to docker. I'd like to setup on my local computer which already has mysql that runs on vagrant. Is it possible for prisma that runs on docker to connect to the mysql?
h
Harshit
12/28/2018, 5:37 PMyou can use
host.docker.internalHarshit
12/28/2018, 5:37 PMI havent used vagrant so I don't know it maps your mysql to localhost or some other ip
Harshit
12/28/2018, 5:43 PMok did some digging you can map the port of your Vagrant box to your host port using
config.vm.network "forwarded_port", guest: 3306, host: 3306Harshit
12/28/2018, 5:43 PMthen you can use
host.docker.internal3366a
ardit
12/28/2018, 5:45 PMfor the vagrant, it's already done, my computer connect with the IP and port to the vm.
I guess I need to learn that
host.docker.internalh
Harshit
12/28/2018, 5:47 PMhere are docs for it: https://docs.docker.com/docker-for-mac/networking/
Harshit
12/28/2018, 5:47 PMRemember though this will only work in windows and mac
Harshit
12/28/2018, 5:47 PMNOT linux
a
ardit
12/29/2018, 7:57 AMediting the compose, run the docker and seeing no error on the docker logs. Try to run the
<http://localhost:4466>h
Harshit
12/29/2018, 7:58 AMCan you share a screenshot?
Harshit
12/29/2018, 7:58 AMAlso try http://localhost:4466/management
a
ardit
12/29/2018, 8:00 AMardit
12/29/2018, 8:00 AMfor the /management it's working
ardit
12/29/2018, 8:01 AM Copy code
version: '3'
services:
prisma:
image: prismagraphql/prisma:1.23
restart: always
ports:
- "4466:4466"
environment:
PRISMA_CONFIG: |
port: 4466
databases:
mydbname:
connector: mysql
host: host.docker.internal
port: 3306
user: myuser
password: mypassword
migrations: true
# mysql:
# image: mysql:5.7
# restart: always
# ports:
# - "3306:3306"
# environment:
# MYSQL_ROOT_PASSWORD: prisma
# volumes:
# - mysql:/var/lib/mysql
# volumes:
# mysql:ardit
12/29/2018, 8:01 AMand this is my docker-compose
h
Harshit
12/29/2018, 8:21 AMhave you deployed a prisma service yet? otherwise it will not work. Try to
prisma deploya
ardit
12/29/2018, 8:58 AMalready done, and it's working. But I guess it didn't connect to the
mydbnamedefault@default🙌 1
h
Harshit
12/29/2018, 8:58 AMyes 🙂 , we use that naming scheme as to track various services
a
ardit
12/29/2018, 8:59 AMis it not possible to connect to my existing mysql db?
h
Harshit
12/29/2018, 8:59 AMYou can use introspection for that but, you will lose out migrations and other awesome feature. Do this only if you have existing data in your database
a
ardit
12/29/2018, 9:01 AMI have existing data. Find out that introspection still not supported for mysql, isn't it?
h
Harshit
12/29/2018, 9:01 AM🤦♀️ yes indeed. https://github.com/prisma/prisma/issues/2506
a
ardit
12/29/2018, 9:18 AMhaha, oke then. Hope the issue can be solved soon 🙂
3 Views