Unable to deploy this apps on OpenShift

[coolpalani]

I am trying to deploy this micro service on OpenShift 3.7. It's throwing an error message while create catalogue-db pods

NAME READY STATUS RESTARTS AGE catalogue-db-1846494424-2j29q 0/1 CrashLoopBackOff 6 8m

Error message

Initializing database mysqld: Can't create/write to file '/var/lib/mysql/is_writable' (Errcode: 13 - Permission denied) 2018-03-14T13:11:18.115358Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-03-14T13:11:18.120035Z 0 [ERROR] --initialize specified but the data directory exists and is not writable. Aborting. 2018-03-14T13:11:18.120064Z 0 [ERROR] Aborting

[rade]

That's odd. I suspect the volume creates as a result of the VOLUME declaration ends up being read-only. Perhaps that's some strange OpenShift default permissions issue.

[coolpalani]

It seems permission issue. We need to add user: "1000:50" in docker file.

workaround solutions provided here: https://github.com/docker-library/mysql/issues/219

We are directly pulling docker image "weaveworksdemos/catalogue-db:0.3.0" but not creating any docker image as manually. could you guide me where I have to insert this permission complete-demo.yaml file

apiVersion: extensions/v1beta1 kind: Deployment metadata: name: catalogue-db labels: name: catalogue-db namespace: sock-shop spec: replicas: 1 template: metadata: labels: name: catalogue-db spec: containers: - name: catalogue-db image: weaveworksdemos/catalogue-db:0.3.0 env: - name: MYSQL_ROOT_PASSWORD value: fake_password - name: MYSQL_DATABASE value: socksdb ports: - name: mysql containerPort: 3306 nodeSelector: beta.kubernetes.io/os: linux

[rade]

Are you sure that will solve the problem? The catalogue-db k8s manifest isn't mounting any dirs from the host into the container.

Nevertheless, to experiment, I suggest creating your own catalogue-db image.

[coolpalani]

Let me try with 0.3.5 docker image https://hub.docker.com/r/weaveworksdemos/catalogue-db/tags/

[coolpalani]

@rade

I eventually deployed this application in OpenShift :)

[root@master ~]# oc get pods NAME READY STATUS RESTARTS AGE carts-515570173-69nkf 1/1 Running 0 56m carts-db-224813618-4kdcl 1/1 Running 0 1h catalogue-3634130434-nwfgg 1/1 Running 0 1h catalogue-db-4001046256-dbj5d 1/1 Running 0 46m front-end-4148163561-5xbsk 1/1 Running 0 42m orders-3874398928-2w49n 1/1 Running 0 1h orders-db-1112365690-n5lnl 1/1 Running 0 1h payment-716517544-l9zj6 1/1 Running 0 59m queue-master-2067646375-4w8kj 1/1 Running 0 1h rabbitmq-2169020979-blv2b 1/1 Running 0 59m shipping-1884913266-8v5hm 1/1 Running 0 58m user-1155543707-7cl4s 1/1 Running 0 57m user-db-1749560319-7jt9l 1/1 Running 0 58m

Fix: I removed all the security context and run catalogue-db as user 0 It may not be best practice, but we have to run this application for experimental. The way of this application design for kubernetes, they are more focused in security. In OpenShift each project will be isolated, hopefully not going to harm.

Thanks for your support

[sunilk747]

@coolpalani Can you share your yaml which you used it to deploy it to openshift

[spzorn123]

Think i am getting a similar issue. What was the fix?

Initializing database   | mysqld: Can't create/write to file '/var/lib/mysql/is_writable' (Errcode: 13 - Permission denied)   | 2019-03-16T05:43:04.624144Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).   | 2019-03-16T05:43:04.625694Z 0 [ERROR] --initialize specified but the data directory exists and is not writable. Aborting.  

[spzorn123]

It seems permission issue. We need to add user: "1000:50" in docker file.

workaround solutions provided here: docker-library/mysql#219

We are directly pulling docker image "weaveworksdemos/catalogue-db:0.3.0" but not creating any docker image as manually. could you guide me where I have to insert this permission complete-demo.yaml file

apiVersion: extensions/v1beta1 kind: Deployment metadata: name: catalogue-db labels: name: catalogue-db namespace: sock-shop spec: replicas: 1 template: metadata: labels: name: catalogue-db spec: containers:

• name: catalogue-db image: weaveworksdemos/catalogue-db:0.3.0 env:
• name: MYSQL_ROOT_PASSWORD value: fake_password
• name: MYSQL_DATABASE value: socksdb ports:
• name: mysql containerPort: 3306 nodeSelector: beta.kubernetes.io/os: linux

@coolpalani did you ever get this running on OpenShift?