<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
        {font-family:"Cambria Math";
        panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0cm;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:purple;
        text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
        {mso-style-name:msonormal;
        mso-margin-top-alt:auto;
        margin-right:0cm;
        mso-margin-bottom-alt:auto;
        margin-left:0cm;
        font-size:12.0pt;
        font-family:"Times New Roman",serif;}
span.E-MailFormatvorlage18
        {mso-style-type:personal-reply;
        font-family:"Calibri",sans-serif;
        color:#1F497D;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-family:"Calibri",sans-serif;
        mso-fareast-language:EN-US;}
@page WordSection1
        {size:612.0pt 792.0pt;
        margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
        {page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="DE" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Yeah, I will do that.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">I have some more things I need to clarify, so I will just gather all the information and sum it up beforehand.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="DE-AT" style="color:#1F497D"> <o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="DE-AT" style="color:#1F497D"> <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE-AT" style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black">With best regards<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE-AT" style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black"><br>
</span><b><span lang="DE-AT" style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black">Florian Floimair<br>
<br>
</span></b><span lang="DE-AT" style="color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Von:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> asterisk-users-bounces@lists.digium.com [mailto:asterisk-users-bounces@lists.digium.com]
<b>Im Auftrag von </b>Marcelo Terres<br>
<b>Gesendet:</b> Mittwoch, 12. Juli 2017 22:55<br>
<b>An:</b> Asterisk Users Mailing List - Non-Commercial Discussion <asterisk-users@lists.digium.com><br>
<b>Betreff:</b> Re: [asterisk-users] Asterisk realtime - Error with index length in alembic script<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">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).<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><br clear="all">
<o:p></o:p></p>
<div>
<div>
<p class="MsoNormal">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://linkprotect.cudasvc.com/url?a=https://www.mundoopensource.com.br&c=E,1,cC98P-aUo0sGW0nm4x61IEJa3J0afB1zbPdps3H6n3PIgLTX7AqK3Tu23_zNx520Yyc8Yzs47UV9i25C0XsWCC24S8fQAXstahwvJHpIxRcmrMu0_FU,&typo=1" 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><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">On 12 July 2017 at 13:11, Floimair Florian <<a href="mailto:f.floimair@commend.com" target="_blank">f.floimair@commend.com</a>> wrote:<o:p></o:p></p>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<p class="MsoNormal">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://linkprotect.cudasvc.com/url?a=https://mariadb.com/kb/en/mariadb/differences-in-mariadb-in-debian-and-ubuntu/&c=E,1,vcstDda1EXiLuEfYH_bWSEQiKUNSlxsJREZBgYMwpFTlFa1RWIuFe-eoxVvQIGuxWq4LaHyhrIGhulqolz16NPWIGtPYLbSURFxq9b0Tl5B4r3vd56NqBNAzGA,,&typo=1" target="_blank">
https://mariadb.com/kb/en/mariadb/differences-in-mariadb-in-debian-and-ubuntu/</a>).<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>
<br>
 <br>
 <br>
With best regards<br>
<br>
Florian Floimair <br>
<br>
<br>
-----Ursprüngliche Nachricht-----<br>
Von: <a href="mailto:asterisk-users-bounces@lists.digium.com">asterisk-users-bounces@lists.digium.com</a> [mailto:<a href="mailto:asterisk-users-bounces@lists.digium.com">asterisk-users-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.com</a>><br>
Betreff: [asterisk-users] Asterisk realtime - Error with index length in alembic script<br>
<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" target="_blank">
https://wiki.asterisk.org/wiki/display/AST/Setting+up+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>
<a href="https://linkprotect.cudasvc.com/url?a=https://e96a0b8071c_increase_pjsip_column_size.py&c=E,1,dGJHzJtuX7eYDELI39tEC4ecYafZjsCUjWDL5p09DOWe28cNAbd_GFmJLD2jBZfffS-vYPvUH1CUUjR7gX1rtdvm5NFCTV_tDVCtQerGg6RZ&typo=1" target="_blank">https://linkprotect.cudasvc.com/url?a=https://e96a0b8071c_increase_pjsip_column_size.py&c=E,1,dGJHzJtuX7eYDELI39tEC4ecYafZjsCUjWDL5p09DOWe28cNAbd_GFmJLD2jBZfffS-vYPvUH1CUUjR7gX1rtdvm5NFCTV_tDVCtQerGg6RZ&typo=1</a><br>
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>
<a href="https://linkprotect.cudasvc.com/url?a=http://www.commend.com&c=E,1,AMmXtJHsI4hmbBwyuM3M1xbRoGx-jiTaCiP7NxokUuMnadAIjb8xkI9P1ki_t2xzN78KaSN07DIpAamHT5VUTD5fbWuRqBVMk8ZAvCXz4t9wk89RgGU28EY,&typo=1" target="_blank">https://linkprotect.cudasvc.com/url?a=http://www.commend.com&c=E,1,AMmXtJHsI4hmbBwyuM3M1xbRoGx-jiTaCiP7NxokUuMnadAIjb8xkI9P1ki_t2xzN78KaSN07DIpAamHT5VUTD5fbWuRqBVMk8ZAvCXz4t9wk89RgGU28EY,&typo=1</a><br>
<br>
Security and Communication by Commend<br>
<br>
FN 178618z | LG Salzburg<br>
<br>
-----Ursprüngliche Nachricht-----<br>
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" target="_blank">
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</a>
<a href="https://linkprotect.cudasvc.com/url?a=https://%5bmailto:asterisk-users-bounces@lists.digium.com&c=E,1,b02t9WMuMstwiWAHz0XrrZjHTVSQwnEy5yxXJi5pqNE6eqJ_ZzijQ4_PsoLa3tnaco3BYXQ5Ck2OHfmk_Dm4EHbE77z220o2c-VzuvBbEcq7PCY,&typo=1%5d" target="_blank">
https://linkprotect.cudasvc.com/url?a=https://[mailto:asterisk-users-bounces@lists.digium.com&c=E,1,b02t9WMuMstwiWAHz0XrrZjHTVSQwnEy5yxXJi5pqNE6eqJ_ZzijQ4_PsoLa3tnaco3BYXQ5Ck2OHfmk_Dm4EHbE77z220o2c-VzuvBbEcq7PCY,&typo=1]</a> Im Auftrag von Thomas<br>
Gesendet: Montag, 10. Juli 2017 14:07<br>
An: <a href="https://linkprotect.cudasvc.com/url?a=https://asterisk-users@lists.digium.com&c=E,1,LICqKTGOt1JJCqd7cLtDeAYTRlaeW-0IaAjeofhcEGlqHiUa9FX1v_0Z61fjn6Cglc1LwJESdZ5CsnB1ZeUMPn7gV2z5agkz3kh8onHV0Oxnmn9c4DjH6CBU&typo=1" target="_blank">
https://linkprotect.cudasvc.com/url?a=https://asterisk-users@lists.digium.com&c=E,1,LICqKTGOt1JJCqd7cLtDeAYTRlaeW-0IaAjeofhcEGlqHiUa9FX1v_0Z61fjn6Cglc1LwJESdZ5CsnB1ZeUMPn7gV2z5agkz3kh8onHV0Oxnmn9c4DjH6CBU&typo=1</a><br>
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>
_____________________________________________________________________<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" target="_blank">
https://linkprotect.cudasvc.com/url?a=http://www.api-digital.com&c=E,1,3cxgVpYz6rj8HJh87TiGg9vmNONVb8R9gj8CUtsKQo4J7XZd3A8P5Q2lgkuqRb7I2h0ILWV9fb2VVtM_fLD5Wkjc1g637rszrIIFlYV5gEq-t1OY5td0MjI,&typo=1</a> --<br>
<br>
Check out the new Asterisk community forum at: <a href="https://community.asterisk.org/" target="_blank">
https://community.asterisk.org/</a><br>
<br>
New to Asterisk? Start here:<br>
      <a href="https://wiki.asterisk.org/wiki/display/AST/Getting+Started" target="_blank">
https://wiki.asterisk.org/wiki/display/AST/Getting+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" target="_blank">https://linkprotect.cudasvc.com/url?a=http://lists.digium.com/mailman/listinfo/asterisk-users&c=E,1,8wdFEBPawJhe3Q7z9CDJspktcWZmak6_F7Qwy-KlgT8Y3RKfi8rz6GZboEEYt3CZnt4-JjH7gKYVY79x72M6dUv0yXmSnCduYVFcBMK4FJNKC_QOHqI9aSjt&typo=1</a><br>
<br>
--<br>
_____________________________________________________________________<br>
-- 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" target="_blank">
https://linkprotect.cudasvc.com/url?a=http://www.api-digital.com&c=E,1,VVFR1vt-VTtY8TkmHZUWfvj_qWyvKuVj3j3kEWWRkDTqIoK5793fkmzz9AnT3OcPsNe5K5B3f4dXsXnP4GaT1rCJ3ejq9IG69CQTwZrDqsi13OegC5RQ8hdx&typo=1</a> --<br>
<br>
Check out the new Asterisk community forum at: <a href="https://community.asterisk.org/" target="_blank">
https://community.asterisk.org/</a><br>
<br>
New to Asterisk? Start here:<br>
      <a href="https://wiki.asterisk.org/wiki/display/AST/Getting+Started" target="_blank">
https://wiki.asterisk.org/wiki/display/AST/Getting+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,8XODZp3VpPc6qb0tcihfIZdGrdIrkd-VCre0cSW0BegTWE_FQwvkwDTHGm8U3zoh7SeoujNXlQu50jrPRfD-eWh-imQTu3o3wFA6ag-rUcunf1TZRY11&typo=1" target="_blank">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</a><o:p></o:p></p>
<div>
<div>
<p class="MsoNormal"><br>
--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="https://linkprotect.cudasvc.com/url?a=http://www.api-digital.com&c=E,1,Q3zTG4eXKlcDPKnNU1X648pnZGLkk8ZY_2h5LSwNyZpLsHDqvUyWg6BFAZ45ClinhC7P9ieYzg73Ingp1aKjL8-fR79ZucR1vftWnVK-uj-4L-IuU_Kfxa3h&typo=1" target="_blank">
http://www.api-digital.com</a> --<br>
<br>
Check out the new Asterisk community forum at: <a href="https://community.asterisk.org/" target="_blank">
https://community.asterisk.org/</a><br>
<br>
New to Asterisk? Start here:<br>
      <a href="https://wiki.asterisk.org/wiki/display/AST/Getting+Started" target="_blank">
https://wiki.asterisk.org/wiki/display/AST/Getting+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,kMGBeJCBoMnz-kX-JecFQt79-MhJ6aUG3c1_1KG6vV9RyKZ52xW_2qs1eiFY0AMPHx8EpiDO3hej7WLh2wFn9NPCpKx8GRYrUlkuxxJMfqW8&typo=1" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><o:p></o:p></p>
</div>
</div>
</blockquote>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</body>
</html>