missing column in mysql

Hello all, this mail is just to let you know about something i found, sadly i was in a maintenance window so i forgot to copy which column it was. Theres a column missing or misname in the acc mysql module in 6.0.4. 

steps i did

1. configured kamctlrc with the mysql host+credentials (mysql was completely empty, only a new user created to be used with kamailio)
2. created the tables with kamdbctl create
3. enabled mysql and acc mysql in kamailio.cfg
4. used only setflag with 1 in some points of the call
5. placed a call

When kamailio tries to insert in the acc table there’s an error for a missing or misnamed column in the mysql and the insert fails.

all of described steps were made using ghcr.io/kamailio/kamailio:6.0.4-bookworm <http://ghcr.io/kamailio/kamailio:6.0.4-bookworm> container image with the following detail

╰─# docker image inspect ghcr.io/kamailio/kamailio:6.0.4-bookworm
[
    {
        "Id": "sha256:119a8949971f70bb69c7286650fdee8ce9ef33ae81bad798bf20a81f1daad249",
        "RepoTags": [
            "ghcr.io/kamailio/kamailio:6.0.4-bookworm"
        ],
        "RepoDigests": [
            "ghcr.io/kamailio/kamailio@sha256:119a8949971f70bb69c7286650fdee8ce9ef33ae81bad798bf20a81f1daad249"
        ],
        "Comment": "buildkit.dockerfile.v0",
        "Created": "2025-11-06T12:04:58.852349663Z",
        "Config": {
            "Env": [
                "PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin",
                "REFRESHED_AT=2025-11-06",
                "SHM_MEMORY=64",
                "PKG_MEMORY=8"
            ],
            "Entrypoint": [
                "/bin/sh",
                "-c",
                "kamailio -DD -E -m ${SHM_MEMORY} -M ${PKG_MEMORY}"
            ],
            "Volumes": {
                "/etc/kamailio": {}
            },
            "Labels": {
                "org.opencontainers.image.authors": "Victor Seva <[email protected]>",
                "org.opencontainers.image.created": "2025-11-06T12:03:50.575Z",
                "org.opencontainers.image.description": "official Debian base image",
                "org.opencontainers.image.licenses": "GPL-3.0",
                "org.opencontainers.image.revision": "e17c5b6ae7094f9e4842b54d260b2596f91baad4",
                "org.opencontainers.image.source": "https://github.com/kamailio/kamailio-docker",
                "org.opencontainers.image.title": "kamailio",
                "org.opencontainers.image.url": "https://github.com/kamailio/kamailio-docker",
                "org.opencontainers.image.version": "6.0.4-bookworm"
            }
        },
        "Architecture": "amd64",
        "Os": "linux",
        "Size": 394440142,
        "RootFS": {
            "Type": "layers",
            "Layers": [
                "sha256:e7278a7fd0ae725fc048bfd0a36c69c162b1d8530a39f49c977cfb8454857c3b",
                "sha256:14e4fdaa2b777103ab080a7eee7dfeff316580c46f5152e4cf3fdb781884920c",
                "sha256:74581eabb88cf4a1cc38a6b303ea2d804ce943f92e1d7f5de77d3bafe38fb32d",
                "sha256:696484fe1e2c0a1cd56beb483c7f4ac29811dd3f45c42b514796ab9559459816",
                "sha256:023fef7ed12af21069a6e56c933dfbc1aad6ad422eb75e34f08e084c1433ea8f"
            ]
        },
        "Metadata": {
            "LastTagTime": "2025-11-29T22:32:21.299030421Z"
        },
        "Descriptor": {
            "mediaType": "application/vnd.oci.image.index.v1+json",
            "digest": "sha256:119a8949971f70bb69c7286650fdee8ce9ef33ae81bad798bf20a81f1daad249",
            "size": 1458
        }
    }
]
╭─root@teco-01 ~
╰─#

__________________________________________________________
Kamailio - Users Mailing List - Non Commercial Discussions -- [email protected]
To unsubscribe send an email to [email protected]
Important: keep the mailing list in the recipients, do not reply only to the sender!