Can't send messages to database

[rhadz1]

I am running windows 11. Mirth 4.5.2.

I have a Maria database container:

1. get MariaDB container:

docker pull mariadb:latest

2. start container:

docker run -d --name mariadb -e MYSQL_ROOT_PASSWORD=xxx -p 3306:3306 mariadb:latest

"docker ps" -> verifies container is running

3. I have Mirth container setup and connected to the db:

docker run -d --name mirthconnect -p 8080:8080 -p 8443:8443 -p 6661:6661 --link mariadb:mariadb -e DB_TYPE=MySQL -e DB_HOST=mariadb -e DB_PORT=3306 -e DB_NAME=mirthdb -e DB_USER=root -e DB_PASS=xxx nextgenhealthcare/connect

4. localhost:8080 -> open up mirth admin. Create a new channel. Source is TCP reader, destination is database writer with the following configuration:

Now when I send a test message:

New-Object System.Net.Sockets.TcpClient("localhost", 6651)
>> $stream = $tcpClient.GetStream()
>> $writer = New-Object System.IO.StreamWriter($stream)
>>
>> # Create a PowerShell object with the necessary fields for the channel table
>> $messageObject = @{
>>     "name"     = "Test Channel"
>>     "revision" = 1
>>     "channel"  = "This is a test channel message"
>> }
>>
>> # Convert the PowerShell object to a JSON string
>> $jsonMessage = $messageObject | ConvertTo-Json
>>
>> # Send the JSON string over the TCP connection
>> $writer.WriteLine($jsonMessage)
>> $writer.Flush()
>>
>> # Close the TCP connection
>> $tcpClient.Close()

It arrives to the source fine, but the destination connector has an issue sending the message to the DB:

Not sure what to do. Chatgpt was of 0 help. The issue seems to be related to the query not parsing the information(JSON) from the source connector.

[rhadz1]

Found answer through youtube video.

Necessary to create a transformer for the source connector as well that will map the variables to allow them to be used by the destination connector.