[asterisk-users] Asterisk realtime - Error with index length in alembic script

Floimair Florian f.floimair at commend.com
Wed Jul 12 06:49:51 CDT 2017


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:
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

With best regards

Florian Floimair

A-5020 Salzburg, Saalachstraße 51

Security and Communication by Commend

FN 178618z | LG Salzburg

-----Ursprüngliche Nachricht-----
Von: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-bounces at lists.digium.com] Im Auftrag von Thomas
Gesendet: Montag, 10. Juli 2017 14:07
An: asterisk-users at lists.digium.com
Betreff: [asterisk-users] ConfBridge increase talking volume as standard


is it possible to increase talking volume for caller in ConfBridge as standard without need to press buttons after joining an conference room.

best regards

-- Bandwidth and Colocation Provided by https://linkprotect.cudasvc.com/url?a=http://www.api-digital.com&c=E,1,3cxgVpYz6rj8HJh87TiGg9vmNONVb8R9gj8CUtsKQo4J7XZd3A8P5Q2lgkuqRb7I2h0ILWV9fb2VVtM_fLD5Wkjc1g637rszrIIFlYV5gEq-t1OY5td0MjI,&typo=1 --

Check out the new Asterisk community forum at: https://community.asterisk.org/

New to Asterisk? Start here:

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:

More information about the asterisk-users mailing list