configuration error?

[ivomans]

I tried to get this module running.

Executing commands in scope Thingsdb went without any error message:

new_module('mysql', 'github.com/thingsdb/module-go-mysql');
set_module_conf('mysql', {
            dsn: "root:......@mysql/dev",
            conn_max_lifetime: 3,
            max_idle_conn: 10,
            max_open_conn: 1
});

But afterwards trying any query_rows or get_db_stats command result all in error message:
modulemysqlis not running (status: configuration error; useset_module_conf(..)to update the module configuration)

Same problem when trying with format dsn: "root:.......@tcp(127.0.0.1:3306)/dev",

Don´t see what could be wrong with the configuration. Mysql database is up and running, database 'dev' exists.
Some errormessage at the set_module_conf command would be useful, if there really is an error.

[joente]

The following works:

Using Docker to spin an mysql image

docker run -p 13306:3306 --name mysql-docker-local -e MYSQL_ROOT_PASSWORD=Password -d mysql:latest

Create a database

docker exec -it mysql-docker-local /bin/bash

mysql -u root -p
Enter password: 

mysql> create database data;
Query OK, 1 row affected (0.02 sec)

mysql> use data;
mysql> CREATE TABLE IF NOT EXISTS fruit (id int(10) NOT NULL AUTO_INCREMENT, name varchar(50) NOT NULL DEFAULT '', PRIMARY KEY(id));
Query OK, 0 rows affected, 1 warning (0.02 sec)

mysql> INSERT INTO fruit (name) VALUES ('apple');
Query OK, 1 row affected (0.03 sec)

mysql> INSERT INTO fruit (name) VALUES ('banana');
Query OK, 1 row affected (0.01 sec)

Install the module (thingsdb)

new_module('mysql', 'github.com/thingsdb/module-go-mysql');

Configure the module

set_module_conf('mysql', {
    dsn: "root:Password@tcp(localhost:13306)/data",
    conn_max_lifetime: 3,
    max_idle_conn: 10,
    max_open_conn: 1
});

Test query

mysql.query_rows({
    query: 'SELECT * FROM fruit WHERE name = ?;',
    params: ['apple'],
}).then(|res| {
    res;
});

Response

[
    [
        {
            "id": "1",
            "name": "apple"
        }
    ]
]

[ivomans]

@joente : Unfortunately your example did not help to solve my configuration.

I noticed dsn: "root:......@tcp(mysql:3306)/dev", is stll causing a configuration error.
When the line is changed into dsn: "root:......@tcp(mysql:3306)/", combined with queries that specify the databasename ( select * from dev.fruit ) I can retrieve data from the dev database.