[asterisk-users] Asterisk realtime - Error with index length in alembic script
Floimair Florian
f.floimair at commend.com
Tue Aug 1 08:01:36 CDT 2017
For anyone interested I documented my findings as a comment to the original wiki article here:
https://wiki.asterisk.org/wiki/display/AST/Setting+up+PJSIP+Realtime?refresh=1501592246325&refresh=1501592309852&refresh=1501592385401&focusedCommentId=37455051#comment-37455051
With best regards
Florian Floimair
Von: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-bounces at lists.digium.com] Im Auftrag von Floimair Florian
Gesendet: Donnerstag, 13. Juli 2017 11:52
An: Asterisk Users Mailing List - Non-Commercial Discussion <asterisk-users at lists.digium.com>
Betreff: Re: [asterisk-users] Asterisk realtime - Error with index length in alembic script
Yeah, I will do that.
I have some more things I need to clarify, so I will just gather all the information and sum it up beforehand.
With best regards
Florian Floimair
Von: asterisk-users-bounces at lists.digium.com<https://linkprotect.cudasvc.com/url?a=https://asterisk-users-bounces@lists.digium.com&c=E,1,0XqWlrx_jzejrGNUHtTyaJK4qUM_42T294RO02AeZx1yC7S4VAhPghx0V3eABtc6iCyi2Hw94tXfogxQe7-_d4nHtaVKyDRhuV9ENoTvLdcyt5Oj&typo=1> [mailto:asterisk-users-bounces at lists.digium.com<https://linkprotect.cudasvc.com/url?a=https://%5bmailto:asterisk-users-bounces@lists.digium.com&c=E,1,c178FD0VgmrFePlnP2rVqBbNajHEfk_KMZsBP5ySVdU8rGasTlFhG89zoM3W1egVUCBtu8PcUeBsekqYzsXH9pDuQBZo1kfs4ZeMdbh9&typo=1>] Im Auftrag von Marcelo Terres
Gesendet: Mittwoch, 12. Juli 2017 22:55
An: Asterisk Users Mailing List - Non-Commercial Discussion <asterisk-users at lists.digium.com<https://linkprotect.cudasvc.com/url?a=https://%26lt;asterisk-users@lists.digium.com&c=E,1,Dm7JnZlS9SB0f1GpjBHWKwoW8bbEMCNe9IfvHNMjrm3moyvQ-k1T4SHRcAh35JxByJanXoMJU-ydogOJWdWr9lWzPV6UzSVJqyTbgkkfRkQs0CZdzykzYw,,&typo=1>>
Betreff: Re: [asterisk-users] Asterisk realtime - Error with index length in alembic script
Please open a Ticket (https://issues.asterisk.org), 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).
Marcelo H. Terres <mhterres at gmail.com<mailto:mhterres at gmail.com>>
IM: mhterres at jabber.mundoopensource.com.br<mailto:mhterres at jabber.mundoopensource.com.br>
https://www.mundoopensource.com.br<https://linkprotect.cudasvc.com/url?a=https://www.mundoopensource.com.br&c=E,1,cC98P-aUo0sGW0nm4x61IEJa3J0afB1zbPdps3H6n3PIgLTX7AqK3Tu23_zNx520Yyc8Yzs47UV9i25C0XsWCC24S8fQAXstahwvJHpIxRcmrMu0_FU,&typo=1>
https://twitter.com/mhterres
https://linkedin.com/in/marceloterres
On 12 July 2017 at 13:11, Floimair Florian <f.floimair at commend.com<mailto:f.floimair at commend.com>> wrote:
Nevermind guys!
I just found out the solution myself:
MariaDB in Debian uses utf8mb4 as default character set (see here: https://mariadb.com/kb/en/mariadb/differences-in-mariadb-in-debian-and-ubuntu/<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>).
I needed to uncomment the lines with utf8mb4 in /etc/mysql/maria.db.conf in the following files:
50-client.cnf (1 line)
50-mysql-clients.cnf (1 line)
50-server.cnf (2 lines)
With best regards
Florian Floimair
-----Ursprüngliche Nachricht-----
Von: asterisk-users-bounces at lists.digium.com<mailto:asterisk-users-bounces at lists.digium.com> [mailto:asterisk-users-bounces at lists.digium.com<mailto:asterisk-users-bounces at lists.digium.com>] Im Auftrag von Floimair Florian
Gesendet: Mittwoch, 12. Juli 2017 13:50
An: Asterisk Users Mailing List - Non-Commercial Discussion <asterisk-users at lists.digium.com<mailto:asterisk-users at lists.digium.com>>
Betreff: [asterisk-users] Asterisk realtime - Error with index length in alembic script
Hi!
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:
https://linkprotect.cudasvc.com/url?a=https://e96a0b8071c_increase_pjsip_column_size.py&c=E,1,dGJHzJtuX7eYDELI39tEC4ecYafZjsCUjWDL5p09DOWe28cNAbd_GFmJLD2jBZfffS-vYPvUH1CUUjR7gX1rtdvm5NFCTV_tDVCtQerGg6RZ&typo=1
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
COMMEND INTERNATIONAL GMBH
A-5020 Salzburg, Saalachstraße 51
https://linkprotect.cudasvc.com/url?a=http://www.commend.com&c=E,1,AMmXtJHsI4hmbBwyuM3M1xbRoGx-jiTaCiP7NxokUuMnadAIjb8xkI9P1ki_t2xzN78KaSN07DIpAamHT5VUTD5fbWuRqBVMk8ZAvCXz4t9wk89RgGU28EY,&typo=1
Security and Communication by Commend
FN 178618z | LG Salzburg
-----Ursprüngliche Nachricht-----
Von: 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 https://linkprotect.cudasvc.com/url?a=https://[mailto:asterisk-users-bounces@lists.digium.com&c=E,1,b02t9WMuMstwiWAHz0XrrZjHTVSQwnEy5yxXJi5pqNE6eqJ_ZzijQ4_PsoLa3tnaco3BYXQ5Ck2OHfmk_Dm4EHbE77z220o2c-VzuvBbEcq7PCY,&typo=1]<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> Im Auftrag von Thomas
Gesendet: Montag, 10. Juli 2017 14:07
An: https://linkprotect.cudasvc.com/url?a=https://asterisk-users@lists.digium.com&c=E,1,LICqKTGOt1JJCqd7cLtDeAYTRlaeW-0IaAjeofhcEGlqHiUa9FX1v_0Z61fjn6Cglc1LwJESdZ5CsnB1ZeUMPn7gV2z5agkz3kh8onHV0Oxnmn9c4DjH6CBU&typo=1
Betreff: [asterisk-users] ConfBridge increase talking volume as standard
Hello,
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
Thomas
--
_____________________________________________________________________
-- 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:
https://wiki.asterisk.org/wiki/display/AST/Getting+Started
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
https://linkprotect.cudasvc.com/url?a=http://lists.digium.com/mailman/listinfo/asterisk-users&c=E,1,8wdFEBPawJhe3Q7z9CDJspktcWZmak6_F7Qwy-KlgT8Y3RKfi8rz6GZboEEYt3CZnt4-JjH7gKYVY79x72M6dUv0yXmSnCduYVFcBMK4FJNKC_QOHqI9aSjt&typo=1
--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by https://linkprotect.cudasvc.com/url?a=http://www.api-digital.com&c=E,1,VVFR1vt-VTtY8TkmHZUWfvj_qWyvKuVj3j3kEWWRkDTqIoK5793fkmzz9AnT3OcPsNe5K5B3f4dXsXnP4GaT1rCJ3ejq9IG69CQTwZrDqsi13OegC5RQ8hdx&typo=1 --
Check out the new Asterisk community forum at: https://community.asterisk.org/
New to Asterisk? Start here:
https://wiki.asterisk.org/wiki/display/AST/Getting+Started
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
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
--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com<https://linkprotect.cudasvc.com/url?a=http://www.api-digital.com&c=E,1,Q3zTG4eXKlcDPKnNU1X648pnZGLkk8ZY_2h5LSwNyZpLsHDqvUyWg6BFAZ45ClinhC7P9ieYzg73Ingp1aKjL8-fR79ZucR1vftWnVK-uj-4L-IuU_Kfxa3h&typo=1> --
Check out the new Asterisk community forum at: https://community.asterisk.org/
New to Asterisk? Start here:
https://wiki.asterisk.org/wiki/display/AST/Getting+Started
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users<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>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20170801/87742897/attachment.html>
More information about the asterisk-users
mailing list