thr3ads.net - asterisk users - [asterisk-users] Asterisk realtime - Error with index length in alembic script [Jul 2017]

If this information is useful, please help other people find it:
Share via:

Floimair Florian

2017-Jul-12 11:49 UTC

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

?
?
With best regards

Florian Floimair

COMMEND INTERNATIONAL GMBH
A-5020 Salzburg, Saalachstra?e 51
http://www.commend.com

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

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

Floimair Florian

2017-Jul-12 12:11 UTC

head link

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

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/).

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] 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>
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 at
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 at
lists.digium.com&c=E,1,b02t9WMuMstwiWAHz0XrrZjHTVSQwnEy5yxXJi5pqNE6eqJ_ZzijQ4_PsoLa3tnaco3BYXQ5Ck2OHfmk_Dm4EHbE77z220o2c-VzuvBbEcq7PCY,&typo=1]
Im Auftrag von Thomas
Gesendet: Montag, 10. Juli 2017 14:07
An: https://linkprotect.cudasvc.com/url?a=https://asterisk-users at
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

Marcelo Terres

2017-Jul-12 20:54 UTC

head link

[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>
IM: mhterres at jabber.mundoopensource.com.br
https://www.mundoopensource.com.br
https://twitter.com/mhterres
https://linkedin.com/in/marceloterres

On 12 July 2017 at 13:11, Floimair Florian <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/).
>
> 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] 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>
> 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,dGJHzJtuX7eYDELI39tEC4ecYafZjs
> CUjWDL5p09DOWe28cNAbd_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 at lists.digium.com&c=E,1,7s7_D_Myc9BrXsqexg-
> b_jeGW99IlnqrhZCMhGKzBBE0m7-4lzl4Pqf0FBhPDU7YvysBh3XyuK7jq
> olYZryc5Pv214OOwiAf7rFVSlR6XZKzTS_0oyqQLA,,&typo=1
> https://linkprotect.cudasvc.com/url?a=https://[mailto:
> asterisk-users-bounces at lists.digium.com&c=E,1,
> b02t9WMuMstwiWAHz0XrrZjHTVSQwnEy5yxXJi5pqNE6eqJ_ZzijQ4_
> PsoLa3tnaco3BYXQ5Ck2OHfmk_Dm4EHbE77z220o2c-VzuvBbEcq7PCY,&typo=1] Im
> Auftrag von Thomas
> Gesendet: Montag, 10. Juli 2017 14:07
> An: https://linkprotect.cudasvc.com/url?a=https://asterisk-
> users at lists.digium.com&c=E,1,LICqKTGOt1JJCqd7cLtDeAYTRlaeW-
> 0IaAjeofhcEGlqHiUa9FX1v_0Z61fjn6Cglc1LwJESdZ5CsnB1ZeUM
> Pn7gV2z5agkz3kh8onHV0Oxnmn9c4DjH6CBU&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,3cxgVpYz6rj8HJh87TiGg9vmNONVb8
> R9gj8CUtsKQo4J7XZd3A8P5Q2lgkuqRb7I2h0ILWV9fb2VVtM_
> 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,8wdFEBPawJhe3Q7z9CDJspktcWZmak
> 6_F7Qwy-KlgT8Y3RKfi8rz6GZboEEYt3CZnt4-JjH7gKYVY79x72M6dUv0yXmSnCduYV
> FcBMK4FJNKC_QOHqI9aSjt&typo=1
>
> --
> _____________________________________________________________________
> -- Bandwidth and Colocation Provided by https://linkprotect.cudasvc.
> com/url?a=http://www.api-digital.com&c=E,1,VVFR1vt-VTtY8TkmHZUWfvj_
> qWyvKuVj3j3kEWWRkDTqIoK5793fkmzz9AnT3OcPsNe5K5B3f4dXsXnP4GaT
> 1rCJ3ejq9IG69CQTwZrDqsi13OegC5RQ8hdx&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 --
>
> 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
>-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20170712/84c1231e/attachment.html>

Reasonably Related Threads

Search for more reasonably related threads

asterisk users - Jul 2017 - Asterisk realtime - Error with index length in alembic script

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

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

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

Reasonably Related Threads