<div dir="ltr">Please open a Ticket (<a href="https://issues.asterisk.org">https://issues.asterisk.org</a>), to let them know that they need to update the documentation in Wiki and also handle this situation when using Alembic in Debian 9 (could happens in other Distros too).</div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature" data-smartmail="gmail_signature">Marcelo H. Terres <<a href="mailto:mhterres@gmail.com" target="_blank">mhterres@gmail.com</a>><br>IM: <a href="mailto:mhterres@jabber.mundoopensource.com.br" target="_blank">mhterres@jabber.mundoopensource.com.br</a><br><a href="https://www.mundoopensource.com.br" target="_blank">https://www.mundoopensource.com.br</a><br><a href="https://twitter.com/mhterres" target="_blank">https://twitter.com/mhterres</a><br><a href="https://linkedin.com/in/marceloterres" target="_blank">https://linkedin.com/in/marceloterres</a></div></div>
<br><div class="gmail_quote">On 12 July 2017 at 13:11, Floimair Florian <span dir="ltr"><<a href="mailto:f.floimair@commend.com" target="_blank">f.floimair@commend.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Nevermind guys!<br>
<br>
I just found out the solution myself:<br>
<br>
MariaDB in Debian uses utf8mb4 as default character set (see here: <a href="https://mariadb.com/kb/en/mariadb/differences-in-mariadb-in-debian-and-ubuntu/" rel="noreferrer" target="_blank">https://mariadb.com/kb/en/<wbr>mariadb/differences-in-<wbr>mariadb-in-debian-and-ubuntu/</a>)<wbr>.<br>
<br>
I needed to uncomment the lines with utf8mb4 in /etc/mysql/maria.db.conf in the following files:<br>
<br>
50-client.cnf (1 line)<br>
50-mysql-clients.cnf (1 line)<br>
50-server.cnf (2 lines)<br>
<span class=""><br>
<br>
<br>
With best regards<br>
<br>
Florian Floimair <br>
<br>
<br>
</span>-----Ursprüngliche Nachricht-----<br>
Von: <a href="mailto:asterisk-users-bounces@lists.digium.com">asterisk-users-bounces@lists.<wbr>digium.com</a> [mailto:<a href="mailto:asterisk-users-bounces@lists.digium.com">asterisk-users-<wbr>bounces@lists.digium.com</a>] Im Auftrag von Floimair Florian<br>
Gesendet: Mittwoch, 12. Juli 2017 13:50<br>
An: Asterisk Users Mailing List - Non-Commercial Discussion <<a href="mailto:asterisk-users@lists.digium.com">asterisk-users@lists.digium.<wbr>com</a>><br>
Betreff: [asterisk-users] Asterisk realtime - Error with index length in alembic script<br>
<span class=""><br>
Hi!<br>
<br>
I just tried setting up Asterisk realtime database following the wiki article <a href="https://wiki.asterisk.org/wiki/display/AST/Setting+up+PJSIP+Realtime" rel="noreferrer" target="_blank">https://wiki.asterisk.org/<wbr>wiki/display/AST/Setting+up+<wbr>PJSIP+Realtime</a> on a Debian 9 machine (which switched from MyQSL to MariaDB).<br>
<br>
One has to install mariadb-plugin-connect, python-mysqldb and alembic packages (alembic does not work when installed via pip).<br>
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:<br>
sudo mysql_secure_installation<br>
sudo mysql_upgrade -p --force<br>
<br>
So far so good. I run into problems when running alembic when I get to the following change:<br>
</span><a href="https://linkprotect.cudasvc.com/url?a=https://e96a0b8071c_increase_pjsip_column_size.py&c=E,1,dGJHzJtuX7eYDELI39tEC4ecYafZjsCUjWDL5p09DOWe28cNAbd_GFmJLD2jBZfffS-vYPvUH1CUUjR7gX1rtdvm5NFCTV_tDVCtQerGg6RZ&typo=1" rel="noreferrer" target="_blank">https://linkprotect.cudasvc.<wbr>com/url?a=https://e96a0b8071c_<wbr>increase_pjsip_column_size.py&<wbr>c=E,1,<wbr>dGJHzJtuX7eYDELI39tEC4ecYafZjs<wbr>CUjWDL5p09DOWe28cNAbd_<wbr>GFmJLD2jBZfffS-<wbr>vYPvUH1CUUjR7gX1rtdvm5NFCTV_<wbr>tDVCtQerGg6RZ&typo=1</a><br>
<span class="">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).<br>
<br>
Any idea how to solve this? Do I maybe have to switch to a different encoding for this to work?<br>
<br>
Thanks in advance<br>
<br>
<br>
<br>
With best regards<br>
<br>
Florian Floimair<br>
<br>
COMMEND INTERNATIONAL GMBH<br>
A-5020 Salzburg, Saalachstraße 51<br>
</span><a href="https://linkprotect.cudasvc.com/url?a=http://www.commend.com&c=E,1,AMmXtJHsI4hmbBwyuM3M1xbRoGx-jiTaCiP7NxokUuMnadAIjb8xkI9P1ki_t2xzN78KaSN07DIpAamHT5VUTD5fbWuRqBVMk8ZAvCXz4t9wk89RgGU28EY,&typo=1" rel="noreferrer" target="_blank">https://linkprotect.cudasvc.<wbr>com/url?a=http://www.commend.<wbr>com&c=E,1,<wbr>AMmXtJHsI4hmbBwyuM3M1xbRoGx-<wbr>jiTaCiP7NxokUuMnadAIjb8xkI9P1k<wbr>i_<wbr>t2xzN78KaSN07DIpAamHT5VUTD5fbW<wbr>uRqBVMk8ZAvCXz4t9wk89RgGU28EY,<wbr>&typo=1</a><br>
<span class=""><br>
Security and Communication by Commend<br>
<br>
FN 178618z | LG Salzburg<br>
<br>
-----Ursprüngliche Nachricht-----<br>
</span>Von: <a href="https://linkprotect.cudasvc.com/url?a=https://asterisk-users-bounces@lists.digium.com&c=E,1,7s7_D_Myc9BrXsqexg-b_jeGW99IlnqrhZCMhGKzBBE0m7-4lzl4Pqf0FBhPDU7YvysBh3XyuK7jqolYZryc5Pv214OOwiAf7rFVSlR6XZKzTS_0oyqQLA,,&typo=1" rel="noreferrer" target="_blank">https://linkprotect.cudasvc.<wbr>com/url?a=https://asterisk-<wbr>users-bounces@lists.digium.<wbr>com&c=E,1,7s7_D_Myc9BrXsqexg-<wbr>b_jeGW99IlnqrhZCMhGKzBBE0m7-<wbr>4lzl4Pqf0FBhPDU7YvysBh3XyuK7jq<wbr>olYZryc5Pv214OOwiAf7rFVSlR6XZK<wbr>zTS_0oyqQLA,,&typo=1</a> <a href="https://linkprotect.cudasvc.com/url?a=https://[mailto:asterisk-users-bounces@lists.digium.com&c=E,1,b02t9WMuMstwiWAHz0XrrZjHTVSQwnEy5yxXJi5pqNE6eqJ_ZzijQ4_PsoLa3tnaco3BYXQ5Ck2OHfmk_Dm4EHbE77z220o2c-VzuvBbEcq7PCY,&typo=1]" rel="noreferrer" target="_blank">https://linkprotect.cudasvc.<wbr>com/url?a=https://[mailto:<wbr>asterisk-users-bounces@lists.<wbr>digium.com&c=E,1,<wbr>b02t9WMuMstwiWAHz0XrrZjHTVSQwn<wbr>Ey5yxXJi5pqNE6eqJ_ZzijQ4_<wbr>PsoLa3tnaco3BYXQ5Ck2OHfmk_<wbr>Dm4EHbE77z220o2c-<wbr>VzuvBbEcq7PCY,&typo=1]</a> Im Auftrag von Thomas<br>
<span class="">Gesendet: Montag, 10. Juli 2017 14:07<br>
</span>An: <a href="https://linkprotect.cudasvc.com/url?a=https://asterisk-users@lists.digium.com&c=E,1,LICqKTGOt1JJCqd7cLtDeAYTRlaeW-0IaAjeofhcEGlqHiUa9FX1v_0Z61fjn6Cglc1LwJESdZ5CsnB1ZeUMPn7gV2z5agkz3kh8onHV0Oxnmn9c4DjH6CBU&typo=1" rel="noreferrer" target="_blank">https://linkprotect.cudasvc.<wbr>com/url?a=https://asterisk-<wbr>users@lists.digium.com&c=E,1,<wbr>LICqKTGOt1JJCqd7cLtDeAYTRlaeW-<wbr>0IaAjeofhcEGlqHiUa9FX1v_<wbr>0Z61fjn6Cglc1LwJESdZ5CsnB1ZeUM<wbr>Pn7gV2z5agkz3kh8onHV0Oxnmn9c4D<wbr>jH6CBU&typo=1</a><br>
<span class="">Betreff: [asterisk-users] ConfBridge increase talking volume as standard<br>
<br>
Hello,<br>
<br>
is it possible to increase talking volume for caller in ConfBridge as standard without need to press buttons after joining an conference room.<br>
<br>
best regards<br>
Thomas<br>
<br>
--<br>
______________________________<wbr>______________________________<wbr>_________<br>
-- Bandwidth and Colocation Provided by <a href="https://linkprotect.cudasvc.com/url?a=http://www.api-digital.com&c=E,1,3cxgVpYz6rj8HJh87TiGg9vmNONVb8R9gj8CUtsKQo4J7XZd3A8P5Q2lgkuqRb7I2h0ILWV9fb2VVtM_fLD5Wkjc1g637rszrIIFlYV5gEq-t1OY5td0MjI,&typo=1" rel="noreferrer" target="_blank">https://linkprotect.cudasvc.<wbr>com/url?a=http://www.api-<wbr>digital.com&c=E,1,<wbr>3cxgVpYz6rj8HJh87TiGg9vmNONVb8<wbr>R9gj8CUtsKQo4J7XZd3A8P5Q2lgkuq<wbr>Rb7I2h0ILWV9fb2VVtM_<wbr>fLD5Wkjc1g637rszrIIFlYV5gEq-<wbr>t1OY5td0MjI,&typo=1</a> --<br>
<br>
Check out the new Asterisk community forum at: <a href="https://community.asterisk.org/" rel="noreferrer" target="_blank">https://community.asterisk.<wbr>org/</a><br>
<br>
New to Asterisk? Start here:<br>
<a href="https://wiki.asterisk.org/wiki/display/AST/Getting+Started" rel="noreferrer" target="_blank">https://wiki.asterisk.org/<wbr>wiki/display/AST/Getting+<wbr>Started</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="https://linkprotect.cudasvc.com/url?a=http://lists.digium.com/mailman/listinfo/asterisk-users&c=E,1,8wdFEBPawJhe3Q7z9CDJspktcWZmak6_F7Qwy-KlgT8Y3RKfi8rz6GZboEEYt3CZnt4-JjH7gKYVY79x72M6dUv0yXmSnCduYVFcBMK4FJNKC_QOHqI9aSjt&typo=1" rel="noreferrer" target="_blank">https://linkprotect.cudasvc.<wbr>com/url?a=http://lists.digium.<wbr>com/mailman/listinfo/asterisk-<wbr>users&c=E,1,<wbr>8wdFEBPawJhe3Q7z9CDJspktcWZmak<wbr>6_F7Qwy-<wbr>KlgT8Y3RKfi8rz6GZboEEYt3CZnt4-<wbr>JjH7gKYVY79x72M6dUv0yXmSnCduYV<wbr>FcBMK4FJNKC_QOHqI9aSjt&typo=1</a><br>
<br>
--<br>
______________________________<wbr>______________________________<wbr>_________<br>
</span>-- Bandwidth and Colocation Provided by <a href="https://linkprotect.cudasvc.com/url?a=http://www.api-digital.com&c=E,1,VVFR1vt-VTtY8TkmHZUWfvj_qWyvKuVj3j3kEWWRkDTqIoK5793fkmzz9AnT3OcPsNe5K5B3f4dXsXnP4GaT1rCJ3ejq9IG69CQTwZrDqsi13OegC5RQ8hdx&typo=1" rel="noreferrer" target="_blank">https://linkprotect.cudasvc.<wbr>com/url?a=http://www.api-<wbr>digital.com&c=E,1,VVFR1vt-<wbr>VTtY8TkmHZUWfvj_<wbr>qWyvKuVj3j3kEWWRkDTqIoK5793fkm<wbr>zz9AnT3OcPsNe5K5B3f4dXsXnP4GaT<wbr>1rCJ3ejq9IG69CQTwZrDqsi13OegC5<wbr>RQ8hdx&typo=1</a> --<br>
<span class=""><br>
Check out the new Asterisk community forum at: <a href="https://community.asterisk.org/" rel="noreferrer" target="_blank">https://community.asterisk.<wbr>org/</a><br>
<br>
New to Asterisk? Start here:<br>
<a href="https://wiki.asterisk.org/wiki/display/AST/Getting+Started" rel="noreferrer" target="_blank">https://wiki.asterisk.org/<wbr>wiki/display/AST/Getting+<wbr>Started</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
</span> <a href="https://linkprotect.cudasvc.com/url?a=http://lists.digium.com/mailman/listinfo/asterisk-users&c=E,1,8XODZp3VpPc6qb0tcihfIZdGrdIrkd-VCre0cSW0BegTWE_FQwvkwDTHGm8U3zoh7SeoujNXlQu50jrPRfD-eWh-imQTu3o3wFA6ag-rUcunf1TZRY11&typo=1" rel="noreferrer" target="_blank">https://linkprotect.cudasvc.<wbr>com/url?a=http://lists.digium.<wbr>com/mailman/listinfo/asterisk-<wbr>users&c=E,1,<wbr>8XODZp3VpPc6qb0tcihfIZdGrdIrkd<wbr>-VCre0cSW0BegTWE_<wbr>FQwvkwDTHGm8U3zoh7SeoujNXlQu50<wbr>jrPRfD-eWh-imQTu3o3wFA6ag-<wbr>rUcunf1TZRY11&typo=1</a><br>
<div class="HOEnZb"><div class="h5"><br>
--<br>
______________________________<wbr>______________________________<wbr>_________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" rel="noreferrer" target="_blank">http://www.api-digital.com</a> --<br>
<br>
Check out the new Asterisk community forum at: <a href="https://community.asterisk.org/" rel="noreferrer" target="_blank">https://community.asterisk.<wbr>org/</a><br>
<br>
New to Asterisk? Start here:<br>
<a href="https://wiki.asterisk.org/wiki/display/AST/Getting+Started" rel="noreferrer" target="_blank">https://wiki.asterisk.org/<wbr>wiki/display/AST/Getting+<wbr>Started</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" rel="noreferrer" target="_blank">http://lists.digium.com/<wbr>mailman/listinfo/asterisk-<wbr>users</a><br>
</div></div></blockquote></div><br></div>