After the installation of asterisk-mysql asterisk does not start any more

Hi there,
i have the asterisk-mysql package via the command:

apt-get install asterisk-mysql

installed.
The following packages were then installed:

root@dsme01:~# cat /var/log/dpkg.log
2021-11-02 13:50:00 startup archives unpack
2021-11-02 13:50:08 install asterisk-config:all 1:16.2.1~dfsg-1+deb10u1 1:16.2.1~dfsg-1+deb10u2
2021-11-02 13:50:08 status half-installed asterisk-config:all 1:16.2.1~dfsg-1+deb10u1
2021-11-02 13:50:09 status unpacked asterisk-config:all 1:16.2.1~dfsg-1+deb10u2
2021-11-02 13:50:09 install asterisk-core-sounds-en-gsm:all <keine> 1.6.1-1
2021-11-02 13:50:09 status half-installed asterisk-core-sounds-en-gsm:all 1.6.1-1
2021-11-02 13:50:10 status unpacked asterisk-core-sounds-en-gsm:all 1.6.1-1
2021-11-02 13:50:10 install asterisk-core-sounds-en:all <keine> 1.6.1-1
2021-11-02 13:50:10 status half-installed asterisk-core-sounds-en:all 1.6.1-1
2021-11-02 13:50:10 status unpacked asterisk-core-sounds-en:all 1.6.1-1
2021-11-02 13:50:11 install libgmime-3.0-0:amd64 <keine> 3.2.1-1
2021-11-02 13:50:11 status triggers-pending libc-bin:amd64 2.28-10
2021-11-02 13:50:11 status half-installed libgmime-3.0-0:amd64 3.2.1-1
2021-11-02 13:50:11 status unpacked libgmime-3.0-0:amd64 3.2.1-1
2021-11-02 13:50:11 install libneon27-gnutls:amd64 <keine> 0.30.2-3
2021-11-02 13:50:11 status half-installed libneon27-gnutls:amd64 0.30.2-3
2021-11-02 13:50:12 status unpacked libneon27-gnutls:amd64 0.30.2-3
2021-11-02 13:50:12 install asterisk-modules:amd64 <keine> 1:16.2.1~dfsg-1+deb10u2
2021-11-02 13:50:12 status half-installed asterisk-modules:amd64 1:16.2.1~dfsg-1+deb10u2
2021-11-02 13:50:12 status unpacked asterisk-modules:amd64 1:16.2.1~dfsg-1+deb10u2
2021-11-02 13:50:13 install asterisk:amd64 <keine> 1:16.2.1~dfsg-1+deb10u2
2021-11-02 13:50:13 status half-installed asterisk:amd64 1:16.2.1~dfsg-1+deb10u2
2021-11-02 13:50:13 status triggers-pending systemd:amd64 241-7~deb10u8
2021-11-02 13:50:13 status triggers-pending man-db:amd64 2.8.5-2
2021-11-02 13:50:14 status unpacked asterisk:amd64 1:16.2.1~dfsg-1+deb10u2
2021-11-02 13:50:14 install asterisk-moh-opsound-gsm:all <keine> 2.03-1
2021-11-02 13:50:14 status half-installed asterisk-moh-opsound-gsm:all 2.03-1
2021-11-02 13:50:14 status unpacked asterisk-moh-opsound-gsm:all 2.03-1
2021-11-02 13:50:15 install asterisk-mysql:amd64 <keine> 1:16.2.1~dfsg-1+deb10u2
2021-11-02 13:50:15 status half-installed asterisk-mysql:amd64 1:16.2.1~dfsg-1+deb10u2
2021-11-02 13:50:15 status unpacked asterisk-mysql:amd64 1:16.2.1~dfsg-1+deb10u2
2021-11-02 13:50:15 install asterisk-voicemail:amd64 <keine> 1:16.2.1~dfsg-1+deb10u2
2021-11-02 13:50:15 status half-installed asterisk-voicemail:amd64 1:16.2.1~dfsg-1+deb10u2
2021-11-02 13:50:15 status unpacked asterisk-voicemail:amd64 1:16.2.1~dfsg-1+deb10u2
2021-11-02 13:50:16 startup packages configure
2021-11-02 13:50:16 configure libgmime-3.0-0:amd64 3.2.1-1 <keine>
2021-11-02 13:50:16 status unpacked libgmime-3.0-0:amd64 3.2.1-1
2021-11-02 13:50:16 status half-configured libgmime-3.0-0:amd64 3.2.1-1
2021-11-02 13:50:16 status installed libgmime-3.0-0:amd64 3.2.1-1
2021-11-02 13:50:16 configure asterisk-core-sounds-en-gsm:all 1.6.1-1 <keine>
2021-11-02 13:50:16 status unpacked asterisk-core-sounds-en-gsm:all 1.6.1-1
2021-11-02 13:50:16 status half-configured asterisk-core-sounds-en-gsm:all 1.6.1-1
2021-11-02 13:50:16 status installed asterisk-core-sounds-en-gsm:all 1.6.1-1
2021-11-02 13:50:16 configure asterisk-config:all 1:16.2.1~dfsg-1+deb10u2 <keine>
2021-11-02 13:50:16 status unpacked asterisk-config:all 1:16.2.1~dfsg-1+deb10u2
2021-11-02 13:50:22 status half-configured asterisk-config:all 1:16.2.1~dfsg-1+deb10u2
2021-11-02 13:50:22 status installed asterisk-config:all 1:16.2.1~dfsg-1+deb10u2
2021-11-02 13:50:22 configure libneon27-gnutls:amd64 0.30.2-3 <keine>
2021-11-02 13:50:22 status unpacked libneon27-gnutls:amd64 0.30.2-3
2021-11-02 13:50:22 status half-configured libneon27-gnutls:amd64 0.30.2-3
2021-11-02 13:50:23 status installed libneon27-gnutls:amd64 0.30.2-3
2021-11-02 13:50:23 configure asterisk-core-sounds-en:all 1.6.1-1 <keine>
2021-11-02 13:50:23 status unpacked asterisk-core-sounds-en:all 1.6.1-1
2021-11-02 13:50:23 status half-configured asterisk-core-sounds-en:all 1.6.1-1
2021-11-02 13:50:23 status installed asterisk-core-sounds-en:all 1.6.1-1
2021-11-02 13:50:23 configure asterisk-moh-opsound-gsm:all 2.03-1 <keine>
2021-11-02 13:50:23 status unpacked asterisk-moh-opsound-gsm:all 2.03-1
2021-11-02 13:50:23 status half-configured asterisk-moh-opsound-gsm:all 2.03-1
2021-11-02 13:50:23 status installed asterisk-moh-opsound-gsm:all 2.03-1
2021-11-02 13:50:23 configure asterisk-modules:amd64 1:16.2.1~dfsg-1+deb10u2 <keine>
2021-11-02 13:50:23 status unpacked asterisk-modules:amd64 1:16.2.1~dfsg-1+deb10u2
2021-11-02 13:50:23 status half-configured asterisk-modules:amd64 1:16.2.1~dfsg-1+deb10u2
2021-11-02 13:50:24 status installed asterisk-modules:amd64 1:16.2.1~dfsg-1+deb10u2
2021-11-02 13:50:24 configure asterisk:amd64 1:16.2.1~dfsg-1+deb10u2 <keine>
2021-11-02 13:50:24 status unpacked asterisk:amd64 1:16.2.1~dfsg-1+deb10u2
2021-11-02 13:50:37 conffile /etc/default/asterisk keep
2021-11-02 13:50:44 conffile /etc/init.d/asterisk keep
2021-11-02 13:50:47 conffile /etc/logrotate.d/asterisk keep
2021-11-02 13:50:47 status half-configured asterisk:amd64 1:16.2.1~dfsg-1+deb10u2
2021-11-02 13:50:51 status installed asterisk:amd64 1:16.2.1~dfsg-1+deb10u2
2021-11-02 13:50:51 configure asterisk-mysql:amd64 1:16.2.1~dfsg-1+deb10u2 <keine>
2021-11-02 13:50:51 status unpacked asterisk-mysql:amd64 1:16.2.1~dfsg-1+deb10u2
2021-11-02 13:50:51 status half-configured asterisk-mysql:amd64 1:16.2.1~dfsg-1+deb10u2
2021-11-02 13:50:51 status installed asterisk-mysql:amd64 1:16.2.1~dfsg-1+deb10u2
2021-11-02 13:50:52 configure asterisk-voicemail:amd64 1:16.2.1~dfsg-1+deb10u2 <keine>
2021-11-02 13:50:52 status unpacked asterisk-voicemail:amd64 1:16.2.1~dfsg-1+deb10u2
2021-11-02 13:50:52 status half-configured asterisk-voicemail:amd64 1:16.2.1~dfsg-1+deb10u2
2021-11-02 13:50:52 status installed asterisk-voicemail:amd64 1:16.2.1~dfsg-1+deb10u2
2021-11-02 13:50:52 trigproc systemd:amd64 241-7~deb10u8 <keine>
2021-11-02 13:50:52 status half-configured systemd:amd64 241-7~deb10u8
2021-11-02 13:50:52 status installed systemd:amd64 241-7~deb10u8
2021-11-02 13:50:52 trigproc man-db:amd64 2.8.5-2 <keine>
2021-11-02 13:50:52 status half-configured man-db:amd64 2.8.5-2
2021-11-02 13:50:55 status installed man-db:amd64 2.8.5-2
2021-11-02 13:50:55 trigproc libc-bin:amd64 2.28-10 <keine>
2021-11-02 13:50:55 status half-configured libc-bin:amd64 2.28-10
2021-11-02 13:50:56 status installed libc-bin:amd64 2.28-10
2021-11-02 14:02:59 startup archives unpack
2021-11-02 14:02:59 upgrade asterisk-mysql:amd64 1:16.2.1~dfsg-1+deb10u2 1:16.2.1~dfsg-1+deb10u2
2021-11-02 14:02:59 status half-configured asterisk-mysql:amd64 1:16.2.1~dfsg-1+deb10u2
2021-11-02 14:02:59 status unpacked asterisk-mysql:amd64 1:16.2.1~dfsg-1+deb10u2
2021-11-02 14:02:59 status half-installed asterisk-mysql:amd64 1:16.2.1~dfsg-1+deb10u2
2021-11-02 14:03:00 status unpacked asterisk-mysql:amd64 1:16.2.1~dfsg-1+deb10u2
2021-11-02 14:03:00 startup packages configure
2021-11-02 14:03:00 configure asterisk-mysql:amd64 1:16.2.1~dfsg-1+deb10u2 <keine>
2021-11-02 14:03:00 status unpacked asterisk-mysql:amd64 1:16.2.1~dfsg-1+deb10u2
2021-11-02 14:03:00 status half-configured asterisk-mysql:amd64 1:16.2.1~dfsg-1+deb10u2
2021-11-02 14:03:00 status installed asterisk-mysql:amd64 1:16.2.1~dfsg-1+deb10u2

During the installation, configuration adjustments should be made, which I had already changed. So I confirmed the query that the existing files are to be kept.
Asterisk doesn’t start anymore. The following error message appears:

root@dsme01:~# asterisk -vvvvvvc
asterisk: symbol lookup error: asterisk: undefined symbol: json_vsprintf

I have the following “libjansson” version:

root@dsme01:~# dpkg -l | grep libjansson
ii  libjansson-dev:amd64                          2.12-1                                          amd64        C library for encoding, decoding and manipulating JSON data (dev)
ii  libjansson4:amd64                             2.12-1                                          amd64        C library for encoding, decoding and manipulating JSON data

Unfortunately I don’t know what to do next. Can you help me?
A heartfelt thank you.
Greetings from Stefan

It looks as if you are using an older packages version of Asterisk (16.2.1) on a Debian based system. What are you using exactly?

If might be that the Asterisk packages are not well maintained nowadays and I would like to suggest to clean everything up with apt purge and then install from the sources.

Okay I then compiled asterisk with the version:

root@dsme01:~# asterisk -V
Asterisk 16.6.1

I now want to switch to the stable version of Debian Buster 10:

root@dsme01:~# aptitude versions 'asterisk'
p   1:16.2.1~dfsg-1+deb10u2                                                          oldstable                                                    100 
p   1:16.16.1~dfsg-1~bpo10+1                                                         buster-backports                                             100 

Whats the best way to do this?

Strictly speaking, this is not an Asterisk question. If you are currently running “Stretch” you need to update only the repos with the proper new name, which would be either “Buster” or “Bullseye”. If you have modified a couple of config files in the past, who will have to make a lot of decisions and most of the time you probably don’t know what to do, :).

It’s easier to install a brand new machine.

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