I just tried setting up Asterisk realtime database following the wiki article https://wiki.asterisk.org/wiki/display/AST/Setting+up+PJSIP+Realtime on a Debian 9 machine (which switched from MyQSL to MariaDB).
One has to install mariadb-plugin-connect, python-mysqldb and alembic packages (alembic does not work when installed via pip). Additionally – since MariaDB by default does not have a root user password set and running mysql -u root requires sudo as well – you need to execute the following:
sudo mysql_secure_installation sudo mysql_upgrade -p –force
So far so good. I run into problems when running alembic when I get to the following change:
e96a0b8071c_increase_pjsip_column_size.py mariadb fails this operation with error “Specified key was too long; max key length is 767 bytes” when it tries to increase some fields to varchar(255).
Any idea how to solve this? Do I maybe have to switch to a different encoding for this to work?
Thanks in advance