# How to connect to ksqldb cluster using bash command line

**URL:** <https://forum.confluent.io/t/how-to-connect-to-ksqldb-cluster-using-bash-command-line/10517>\
**Category:** ksqlDB\
**Created:** [16 April 2024 11:40 UTC](https://forum.confluent.io/t/how-to-connect-to-ksqldb-cluster-using-bash-command-line/10517 "2024-04-16T11:40:11Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![PavanKalyan97](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.confluent.io/pavankalyan97/32/3716_2.png) [@PavanKalyan97](https://forum.confluent.io/u/PavanKalyan97)\
**Post date:** [16 April 2024 11:40 UTC](https://forum.confluent.io/t/how-to-connect-to-ksqldb-cluster-using-bash-command-line/10517/1 "2024-04-16T11:40:11Z")

</div>

Hi Team,

As per my testing i have created a free confluent cloud ui and have connectors and ksqldb.

i want to access that ksqldb cluster in azure build pipelines (with basic command line task)

i have used curl command to install confluent platform.  
but still unable to login to confluent cloud or connect to ksqldb.

Please help me in setting up this and connect to my ksqldb cluster.

Command line script:  
curl -O [http://packages.confluent.io/archive/7.0/confluent-7.0.1.tar.gz](http://packages.confluent.io/archive/7.0/confluent-7.0.1.tar.gz)

tar -xzf confluent-7.0.1.tar.gz  
rm confluent-7.0.1.tar.gz  
echo “extracted package”

export CONFLUENT\_HOME=./confluent-7.0.1  
export PATH=$PATH:$CONFLUENT\_HOME/bin

export [CONFLUENT\_CLOUD\_EMAIL="cloudusername@gmail.com](mailto:CONFLUENT_CLOUD_EMAIL=%22cloudusername@gmail.com)"  
export CONFLUENT\_CLOUD\_PASSWORD=“cloudpassword”

sudo apt-get install -y expect

# Write expect script

cat \< login.exp  
spawn confluent login --prompt  
expect “Email:”  
send “$CONFLUENT\_CLOUD\_EMAIL\n”  
expect “Password:”  
send “$CONFLUENT\_CLOUD\_PASSWORD\n”  
interact  
EOF

# Execute the expect script

expect login.exp

sed -i 's/^bootstrap.servers=._/bootstrap.servers=pkc-4j8dq.southeastasia.azure.confluent.cloud:9092:$(kafkabroker\_port)/’ ./confluent_/etc/ksqldb/ksql-#server.properties

sed -i ‘s/^listeners=0.0.0.0:8088/listeners=pkc-4j8dq.southeastasia.azure.confluent.cloud/lkc-zj3p53:8088/’ ./confluent\*/etc/ksqldb/ksql-server.properties

$CONFLUENT\_HOME/bin/ksql -u -p Restendpoint \<\< EOF  
show streams;  
EOF

Please help me asap,  
Thanks.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex019/uploads/confluentcommunity/original/1X/c49438c90c9df282e9996fdf6971be890c71b65a.svg) [@system](https://forum.confluent.io/u/system)\
**Post date:** [16 May 2024 11:40 UTC](https://forum.confluent.io/t/how-to-connect-to-ksqldb-cluster-using-bash-command-line/10517/2 "2024-05-16T11:40:44Z")

</div>

This topic was automatically closed after 30 days. New replies are no longer allowed.