# Openshift operator how to create public route and connect

**URL:** <https://forums.percona.com/t/openshift-operator-how-to-create-public-route-and-connect/11744>\
**Category:** Percona Operator for MySQL\
**Created:** [August 11, 2021, 7:50pm UTC](https://forums.percona.com/t/openshift-operator-how-to-create-public-route-and-connect/11744 "2021-08-11T19:50:05Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rob\_Phillips](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/rob_phillips/32/4196_2.png) [@Rob\_Phillips](https://forums.percona.com/u/Rob_Phillips)\
**Post date:** [August 11, 2021, 7:50pm UTC](https://forums.percona.com/t/openshift-operator-how-to-create-public-route-and-connect/11744/1 "2021-08-11T19:50:06Z")

</div>

I am having some issues creating a route in OpenShift to the haproxy LB. For the time being I would like to be able to use an on-prem app to utilize the percona mysql database created with the openshift operator. I tried to set up the cr.yaml file with the configuration as such…My db pods start up just fine but the haproxy pods fail in crashloopbackoff  
configuration: |  
global  
maxconn 2048  
external-check  
stats socket /var/run/haproxy.sock mode 600 expose-fd listeners level user  
defaults  
log global  
mode tcp  
retries 10  
timeout client 28800s  
timeout connect 100500  
timeout server 28800s  
frontend galera-in  
bind \*:3309 accept-proxy  
bind \*:3306 accept-proxy  
mode tcp  
option clitcpka  
default\_backend galera-nodes  
frontend galera-replica-in  
bind \*:3307  
mode tcp  
option clitcpka  
default\_backend galera-replica-nodes

---

<div class="post-metadata">

**Author:** ![Rob\_Phillips](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/rob_phillips/32/4196_2.png) [@Rob\_Phillips](https://forums.percona.com/u/Rob_Phillips)\
**Post date:** [August 11, 2021, 7:58pm UTC](https://forums.percona.com/t/openshift-operator-how-to-create-public-route-and-connect/11744/2 "2021-08-11T19:58:58Z")

</div>

My service is fine…It is defined in openshift as a Cluster IP that is accessible within the cluster only. I created a route using the haproxy service in openshift but I can’t seem to connect to it in anyway. I typically try mysql workbench or something like that.

---

<div class="post-metadata">

**Author:** ![Ivan\_Pylypenko](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ivan_pylypenko/32/2452_2.png) [@Ivan\_Pylypenko](https://forums.percona.com/u/Ivan_Pylypenko)\
**Post date:** [September 20, 2021, 8:44am UTC](https://forums.percona.com/t/openshift-operator-how-to-create-public-route-and-connect/11744/3 "2021-09-20T08:44:38Z")

</div>

Hi Rob

It looks like you’ve faced two separate issues at a time.

As for haproxy crash, please post some log output here. Maybe we would get something from it.

As for external access for on-prep openshift I would suggest to follow official recommendations. They have pretty good coverage of a topic.  
[https://docs.openshift.com/container-platform/4.8/networking/configuring\_ingress\_cluster\_traffic/overview-traffic.html](https://docs.openshift.com/container-platform/4.8/networking/configuring_ingress_cluster_traffic/overview-traffic.html)