Source sql not found

[mohammedimrankasab]

we are trying to add MySQL as sql source on the ekuiper rule engine.
Once configured with the stream and rule we are getting an error source sql not found. Docker container environment is used.
Prepackged sql plugin is used.

/ekuiper/etc/sources/sql.yaml

default:
  interval: 10000
  url: mysql://root:root@:172.18.0.2/scadalts?parseTime=true
  internalSqlQueryCfg:
    table: events
    limit: 10
    indexField: id
    indexValue:
    indexFieldType: 
    dateTimeFormat:

stream creation

curl --location 'http://localhost:59720/streams' \
--header 'Content-Type: application/json' \
--data '{
    "sql": "create stream demo () WITH ( TYPE=\"sql\",FORMAT=\"JSON\")"
}'

rule creation

curl --location 'http://localhost:59720/rules' \
--header 'Content-Type: application/json' \
--data '{
  "id": "sql_data1",
  "sql": "SELECT * from demo",
  "actions": [
    {
      "log":{}
    }
  ]
}'

The setup used here is the combination of edgex+ekuiper with version 1.11.4-alpine

Kindly let us know if we need to fix anything from our side

logs from the ekuiper container

time="2024-02-09 17:35:41" level=info msg="Stream demo is created." file="processor/stream.go:81"
time="2024-02-09 17:37:02" level=info msg="Rule sql_data1 is created." file="processor/rule.go:73"
time="2024-02-09 17:37:02" level=info msg="Init rule with options &{Debug:false LogFilename: IsEventTime:false LateTol:1000 Concurrency:1 BufferLength:1024 SendMetaToSink:false SendError:true Qos:0 CheckpointInterval:300000 Restart:0xc000548150 Cron: Duration: CronDatetimeRange:[]}" file="planner/planner.go:44"
time="2024-02-09 17:37:02" level=info msg="Start rulestate sql_data1" file="rule/ruleState.go:151"
time="2024-02-09 17:37:02" level=error msg="runtime error: <nil>" file="infra/saferun.go:57"
time="2024-02-09 17:37:02" level=info msg="Init rule with options &{Debug:false LogFilename: IsEventTime:false LateTol:1000 Concurrency:1 BufferLength:1024 SendMetaToSink:false SendError:true Qos:0 CheckpointInterval:300000 Restart:0xc000548150 Cron: Duration: CronDatetimeRange:[]}" file="planner/planner.go:44"
time="2024-02-09 17:37:02" level=info msg="Opening stream" file="topo/topo.go:176" rule=sql_data1
time="2024-02-09 17:37:02" level=info msg="open source node demo with option &{demo  JSON  sql true   false  0   map[]}" file="node/source_node.go:75" rule=sql_data1
time="2024-02-09 17:37:02" level=info msg="open sink node 1 instances" file="node/sink_node.go:133" rule=sql_data1
time="2024-02-09 17:37:02" level=warning msg="fail to find config key  for source sql" file="conf/source.go:53"
time="2024-02-09 17:37:02" level=info msg="open source node with props map[delimiter: format:json internalsqlquerycfg:map[datetimeformat:<nil> indexfield:id indexfieldtype:<nil> indexvalue:<nil> limit:10 table:events] interval:10000 key: url:mysql://root:root@:172.18.0.2/scadalts?parseTime=true], concurrency: 1, bufferLength: 102400" file="node/source_node.go:112" rule=sql_data1
time="2024-02-09 17:37:02" level=error msg="runtime error: source sql not found" file="infra/saferun.go:55" rule=sql_data1
time="2024-02-09 17:37:02" level=error msg="closing rule sql_data1 for error: source sql not found" file="rule/ruleState.go:211"
time="2024-02-09 17:37:02" level=error msg="runtime error: <nil>" file="infra/saferun.go:55" rule=sql_data1
time="2024-02-09 17:37:02" level=info msg="Opening func collector" file="collector/func.go:52" rule=sql_data1
time="2024-02-09 17:37:02" level=info msg="sink node log_0 instance 0 done" file="node/sink_node.go:293" rule=sql_data1
time="2024-02-09 17:37:02" level=info msg="unary operator 2_project instance 0 cancelling...." file="node/operations.go:167" rule=sql_data1
time="2024-02-09 17:37:02" level=info msg="unary operator 2_project instance 0 done, cancelling future items" file="node/operations.go:108" rule=sql_data1