Without more specifics about what you are doing and what your skill/knowledge level is, I can only give you generic advice, so here goes.
Freeswitch would have defaulted to use sqlite if you didn’t have mod_mariadb loaded. You could disable mod_mariadb and see if the files in /var/lib/freeswitch/db are being updated. Just delete all of them and restart Freeswitch. They should get recreated.
I haven’t tried compiling Freeswitch from source in a long time but I seem to remember it saving files in different directories than if installing from deb packages, so I needed to make sure to tell it to save those files in the correct places, or just install Freeswitch from the DEB packages instead.
It could also be a permissions problem. This is my manual procedure to fix permissions which will also give you some idea what should be where.
I run this any time there are any changes/moves/adds/upgrades or when experiencing problems.
# Ownership www-data
chown -R www-data. /etc/freeswitch /var/lib/freeswitch \
/var/log/freeswitch /usr/share/freeswitch \
/var/log/astpp /var/log/nginx /opt/ASTPP
# Directory permissions to 755 (u=rwx,g=rx,o='rx')
find /etc/freeswitch -type d -exec chmod 755 {} \;
find /var/lib/freeswitch -type d -exec chmod 755 {} \;
find /var/log/freeswitch -type d -exec chmod 755 {} \;
find /usr/share/freeswitch -type d -exec chmod 755 {} \;
find /opt/ASTPP -type d -exec chmod 755 {} \;
find /var/log/astpp -type d -exec chmod 755 {} \;
find /var/lib/astpp -type d -exec chmod 755 {} \;
# File permissions to 777(u=rwx,g=rwx,o=rwx)
find /var/log/astpp -type f -exec chmod 777 {} \;
# File permissions to 644 (u=rw,g=r,o=r)
find /etc/freeswitch -type f -exec chmod 644 {} \;
find /var/lib/freeswitch -type f -exec chmod 644 {} \;
find /var/log/freeswitch -type f -exec chmod 644 {} \;
find /usr/share/freeswitch -type f -exec chmod 644 {} \;
find /opt/ASTPP -type f -exec chmod 644 {} \;
find /var/lib/astpp -type f -exec chmod 644 {} \;
Lastly, as stated in a previous reply, it could be your ODBC connector. I know the MariaDB ODBC 3 connector for Debian was flaky at one time. I ended up using the ODBC 2 connector instead.
Here are some basic checks to see of ODBC is working.
# Test odbc driver
odbcinst -s -q
# Test odbc connection
isql -v astpp astppuser ${MYSQL_USER_PASSWORD}
Although if that was not working then nothing would work, not just Freeswitch.
You keep saying the only thing that is not loading is sip_profiles. As far as I know that is basically everything Freeswitch loads, so still kind of sounds like a DB connection problem to me but I could be wrong.
