Re: [asterisk-users] Asterisk realtime - Error with index length in alembic script
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=1501592309852=1501592385401=37455051#comment-37455051 With best regards Florian Floimair Von: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@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@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-boun...@lists.digium.com<https://linkprotect.cudasvc.com/url?a=https://asterisk-users-boun...@lists.digium.com=E,1,0XqWlrx_jzejrGNUHtTyaJK4qUM_42T294RO02AeZx1yC7S4VAhPghx0V3eABtc6iCyi2Hw94tXfogxQe7-_d4nHtaVKyDRhuV9ENoTvLdcyt5Oj=1> [mailto:asterisk-users-boun...@lists.digium.com<https://linkprotect.cudasvc.com/url?a=https://%5bmailto:asterisk-users-boun...@lists.digium.com=E,1,c178FD0VgmrFePlnP2rVqBbNajHEfk_KMZsBP5ySVdU8rGasTlFhG89zoM3W1egVUCBtu8PcUeBsekqYzsXH9pDuQBZo1kfs4ZeMdbh9=1>] Im Auftrag von Marcelo Terres Gesendet: Mittwoch, 12. Juli 2017 22:55 An: Asterisk Users Mailing List - Non-Commercial Discussion <asterisk-users@lists.digium.com<https://linkprotect.cudasvc.com/url?a=https://%26lt;asterisk-users@lists.digium.com=E,1,Dm7JnZlS9SB0f1GpjBHWKwoW8bbEMCNe9IfvHNMjrm3moyvQ-k1T4SHRcAh35JxByJanXoMJU-ydogOJWdWr9lWzPV6UzSVJqyTbgkkfRkQs0CZdzykzYw,,=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 <mhter...@gmail.com<mailto:mhter...@gmail.com>> IM: mhter...@jabber.mundoopensource.com.br<mailto:mhter...@jabber.mundoopensource.com.br> https://www.mundoopensource.com.br<https://linkprotect.cudasvc.com/url?a=https://www.mundoopensource.com.br=E,1,cC98P-aUo0sGW0nm4x61IEJa3J0afB1zbPdps3H6n3PIgLTX7AqK3Tu23_zNx520Yyc8Yzs47UV9i25C0XsWCC24S8fQAXstahwvJHpIxRcmrMu0_FU,=1> https://twitter.com/mhterres https://linkedin.com/in/marceloterres On 12 July 2017 at 13:11, Floimair Florian <f.floim...@commend.com<mailto:f.floim...@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/=E,1,vcstDda1EXiLuEfYH_bWSEQiKUNSlxsJREZBgYMwpFTlFa1RWIuFe-eoxVvQIGuxWq4LaHyhrIGhulqolz16NPWIGtPYLbSURFxq9b0Tl5B4r3vd56NqBNAzGA,,=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-boun...@lists.digium.com<mailto:asterisk-users-boun...@lists.digium.com> [mailto:asterisk-users-boun...@lists.digium.com<mailto:asterisk-users-boun...@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@lists.digium.com<mailto:asterisk-users@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=E,1,dGJHzJtuX7eYDELI39tEC4ecYafZjsCUjWDL5p09DOWe28cNAbd_GFmJLD2jBZfffS-vYPvUH1CUUjR7gX1rtdvm5NFCTV_tDVCtQerGg6RZ=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
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-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] Im Auftrag von Marcelo Terres Gesendet: Mittwoch, 12. Juli 2017 22:55 An: Asterisk Users Mailing List - Non-Commercial Discussion <asterisk-users@lists.digium.com> 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 <mhter...@gmail.com<mailto:mhter...@gmail.com>> IM: mhter...@jabber.mundoopensource.com.br<mailto:mhter...@jabber.mundoopensource.com.br> https://www.mundoopensource.com.br<https://linkprotect.cudasvc.com/url?a=https://www.mundoopensource.com.br=E,1,cC98P-aUo0sGW0nm4x61IEJa3J0afB1zbPdps3H6n3PIgLTX7AqK3Tu23_zNx520Yyc8Yzs47UV9i25C0XsWCC24S8fQAXstahwvJHpIxRcmrMu0_FU,=1> https://twitter.com/mhterres https://linkedin.com/in/marceloterres On 12 July 2017 at 13:11, Floimair Florian <f.floim...@commend.com<mailto:f.floim...@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/=E,1,vcstDda1EXiLuEfYH_bWSEQiKUNSlxsJREZBgYMwpFTlFa1RWIuFe-eoxVvQIGuxWq4LaHyhrIGhulqolz16NPWIGtPYLbSURFxq9b0Tl5B4r3vd56NqBNAzGA,,=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-boun...@lists.digium.com<mailto:asterisk-users-boun...@lists.digium.com> [mailto:asterisk-users-boun...@lists.digium.com<mailto:asterisk-users-boun...@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@lists.digium.com<mailto:asterisk-users@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=E,1,dGJHzJtuX7eYDELI39tEC4ecYafZjsCUjWDL5p09DOWe28cNAbd_GFmJLD2jBZfffS-vYPvUH1CUUjR7gX1rtdvm5NFCTV_tDVCtQerGg6RZ=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=E,1,AMmXtJHsI4hmbBwyuM3M1xbRoGx-jiTaCiP7NxokUuMnadAIjb8xkI9P1ki_t2xzN78KaSN07DIpAamHT5VUTD5fbWuRqBVMk8ZAvCXz4t9wk89RgGU28EY,=1 Security and Communication by Commend FN 178618z | LG Salzburg -Ursprüngliche Nachricht- Von: https://linkprotect.cudasvc.com/url?a=https://asterisk-users-boun...@lists.digium.com=E,1,7s7_D_Myc9BrXsqexg-b_jeGW99IlnqrhZCMhGKzBBE0m7-4lzl4Pqf0FBhPDU7YvysBh3XyuK7jqolYZryc5Pv214OOwiAf7rFVSlR6XZKzTS_0oyqQLA,,=1 https://linkprotect.cudasvc.com/url?a=https://[mailto:asterisk-users-boun...@lists.digium.com=E,1,b02t9WMuMstwiWAHz0XrrZjHTVSQwnEy5yxXJi5pqNE6eqJ_ZzijQ4_PsoLa3tnaco3BYXQ5Ck2OHfmk_Dm4EHbE77z220o2c-VzuvBbEcq7PCY,=1]<https://linkprotect.cudasvc.com/url?a=https://%5bmailto:asterisk-users-boun...@lists.digium.com=E,1,b02t9WMuMstwiWAHz0XrrZjHTVSQwnEy5yxXJi5pqNE6eqJ_ZzijQ4_PsoLa3tnaco3BYXQ5Ck2OHfmk_Dm4EHbE77z220o2c-VzuvBbEcq7PCY,=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=E,1,LICqKTGOt1JJCqd7cLtDeAYTRlaeW-0IaAjeofhcEGlqHiUa9FX1v_0Z61f
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 <mhter...@gmail.com> IM: mhter...@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.floim...@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-boun...@lists.digium.com [mailto:asterisk-users- > boun...@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@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=E,1,dGJHzJtuX7eYDELI39tEC4ecYafZjs > CUjWDL5p09DOWe28cNAbd_GFmJLD2jBZfffS-vYPvUH1CUUjR7gX1rtdvm5NFCTV_ > tDVCtQerGg6RZ=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=E,1, > AMmXtJHsI4hmbBwyuM3M1xbRoGx-jiTaCiP7NxokUuMnadAIjb8xkI9P1ki_ > t2xzN78KaSN07DIpAamHT5VUTD5fbWuRqBVMk8ZAvCXz4t9wk89RgGU28EY,=1 > > Security and Communication by Commend > > FN 178618z | LG Salzburg > > -Ursprüngliche Nachricht- > Von: https://linkprotect.cudasvc.com/url?a=https://asterisk- > users-boun...@lists.digium.com=E,1,7s7_D_Myc9BrXsqexg- > b_jeGW99IlnqrhZCMhGKzBBE0m7-4lzl4Pqf0FBhPDU7YvysBh3XyuK7jq > olYZryc5Pv214OOwiAf7rFVSlR6XZKzTS_0oyqQLA,,=1 > https://linkprotect.cudasvc.com/url?a=https://[mailto: > asterisk-users-boun...@lists.digium.com=E,1, > b02t9WMuMstwiWAHz0XrrZjHTVSQwnEy5yxXJi5pqNE6eqJ_ZzijQ4_ > PsoLa3tnaco3BYXQ5Ck2OHfmk_Dm4EHbE77z220o2c-VzuvBbEcq7PCY,=1] Im > Auftrag von Thomas > Gesendet: Montag, 10. Juli 2017 14:07 > An: https://linkprotect.cudasvc.com/url?a=https://asterisk- > us...@lists.digium.com=E,1,LICqKTGOt1JJCqd7cLtDeAYTRlaeW- > 0IaAjeofhcEGlqHiUa9FX1v_0Z61fjn6Cglc1LwJESdZ5CsnB1ZeUM > Pn7gV2z5agkz3kh8onHV0Oxnmn9c4DjH6CBU=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=E,1,3cxgVpYz6rj8HJh87TiGg9vmNONVb8 > R9gj8CUtsKQo4J7XZd3A8P5Q2lgkuqRb7I2h0ILWV9fb2VVtM_ > fLD5Wkjc1g637rszrIIFlYV5gEq-t1OY5td0MjI,=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. > c
Re: [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-boun...@lists.digium.com [mailto:asterisk-users-boun...@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@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=E,1,dGJHzJtuX7eYDELI39tEC4ecYafZjsCUjWDL5p09DOWe28cNAbd_GFmJLD2jBZfffS-vYPvUH1CUUjR7gX1rtdvm5NFCTV_tDVCtQerGg6RZ=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=E,1,AMmXtJHsI4hmbBwyuM3M1xbRoGx-jiTaCiP7NxokUuMnadAIjb8xkI9P1ki_t2xzN78KaSN07DIpAamHT5VUTD5fbWuRqBVMk8ZAvCXz4t9wk89RgGU28EY,=1 Security and Communication by Commend FN 178618z | LG Salzburg -Ursprüngliche Nachricht- Von: https://linkprotect.cudasvc.com/url?a=https://asterisk-users-boun...@lists.digium.com=E,1,7s7_D_Myc9BrXsqexg-b_jeGW99IlnqrhZCMhGKzBBE0m7-4lzl4Pqf0FBhPDU7YvysBh3XyuK7jqolYZryc5Pv214OOwiAf7rFVSlR6XZKzTS_0oyqQLA,,=1 https://linkprotect.cudasvc.com/url?a=https://[mailto:asterisk-users-boun...@lists.digium.com=E,1,b02t9WMuMstwiWAHz0XrrZjHTVSQwnEy5yxXJi5pqNE6eqJ_ZzijQ4_PsoLa3tnaco3BYXQ5Ck2OHfmk_Dm4EHbE77z220o2c-VzuvBbEcq7PCY,=1] Im Auftrag von Thomas Gesendet: Montag, 10. Juli 2017 14:07 An: https://linkprotect.cudasvc.com/url?a=https://asterisk-users@lists.digium.com=E,1,LICqKTGOt1JJCqd7cLtDeAYTRlaeW-0IaAjeofhcEGlqHiUa9FX1v_0Z61fjn6Cglc1LwJESdZ5CsnB1ZeUMPn7gV2z5agkz3kh8onHV0Oxnmn9c4DjH6CBU=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=E,1,3cxgVpYz6rj8HJh87TiGg9vmNONVb8R9gj8CUtsKQo4J7XZd3A8P5Q2lgkuqRb7I2h0ILWV9fb2VVtM_fLD5Wkjc1g637rszrIIFlYV5gEq-t1OY5td0MjI,=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=E,1,8wdFEBPawJhe3Q7z9CDJspktcWZmak6_F7Qwy-KlgT8Y3RKfi8rz6GZboEEYt3CZnt4-JjH7gKYVY79x72M6dUv0yXmSnCduYVFcBMK4FJNKC_QOHqI9aSjt=1 -- _ -- Bandwidth and Colocation Provided by https://linkprotect.cudasvc.com/url?a=http://www.api-digital.com=E,1,VVFR1vt-VTtY8TkmHZUWfvj_qWyvKuVj3j3kEWWRkDTqIoK5793fkmzz9AnT3OcPsNe5K5B3f4dXsXnP4GaT1rCJ3ejq9IG69CQTwZrDqsi13OegC5RQ8hdx=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=E,1,8XODZp3VpPc6qb0tcihfIZdGrdIrkd-VCre0cSW0BegTWE_FQwvkwDTHGm8U3zoh7SeoujNXlQu50jrPRfD-eWh-imQTu3o3wFA6ag-rUcunf1TZRY11=1 -- _ -- Bandwidth and Colocation Provided by http://www
[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-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] Im Auftrag von Thomas Gesendet: Montag, 10. Juli 2017 14:07 An: asterisk-users@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=E,1,3cxgVpYz6rj8HJh87TiGg9vmNONVb8R9gj8CUtsKQo4J7XZd3A8P5Q2lgkuqRb7I2h0ILWV9fb2VVtM_fLD5Wkjc1g637rszrIIFlYV5gEq-t1OY5td0MjI,=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=E,1,8wdFEBPawJhe3Q7z9CDJspktcWZmak6_F7Qwy-KlgT8Y3RKfi8rz6GZboEEYt3CZnt4-JjH7gKYVY79x72M6dUv0yXmSnCduYVFcBMK4FJNKC_QOHqI9aSjt=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
Re: [asterisk-users] Asterisk realtime error
Hi Renzzo, Which linux distribution you are using? maybe problem is due to mysql.sock try with direct tcp connection. 1. remove dbsock = /var/lib/mysql/mysql.sock line 2. change mysql user host permission from localhost % 3. dump mysql permissions or restart mysql; 4. reload / restart asterisk. Regards Nasir Iqbal http://www.ictinnovations.com On Wed, 2007-09-26 at 23:25 -0500, RENZZO SOTOMAYOR wrote: Peder, I have all the permissions in mysql user. I can query my database from the local box. Mik Cheez, yes, it is. mysql.sock is in /var/lib/mysql/ Asterisk and Mysql are in the same PC I still have the same error and don't know what to do. help plz! thanks in advance, Renzzo Mik Cheez wrote: Is your mysql.sock actually in /var/lib/mysql/ ? Peder wrote: Could be a mysql permission issue. Try this from the local box: mysql -u root -p enter asterisk as the password use asterisk; select * from sip_buddies; select * from iax_buddies; If you get that far and can see the entries in iax_buddies and sip_buddies, you know it isn't a permissions issue. If you can't, then you know where to look. RENZZO SOTOMAYOR wrote: Hi! I am proving Asterisk 1.2.24 in realtime with MySQL 5.0.27 using Idefisk softphones. I followed the steps of how to of voip-org but always have this error: Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL RealTime: Failed to query database. Check debug for more info. Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL RealTime: Failed to query database. Check debug for more info. Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL RealTime: Failed to query database. Check debug for more info. Sep 25 20:29:07 NOTICE[12000]: chan_iax2.c:5252 register_verify: Host 127.0.0.1 http://127.0.0.1/ failed MD5 authentication for '101' (9a43a82001dfa49d84e8facb765f7 d e2 != 31610d29241e861816b83998501ee223) I configure extconfig.conf as: [settings] iaxusers = mysql,asterisk,iax_buddies iaxpeers = mysql,asterisk,iax_buddies sipusers = mysql,asterisk,sip_buddies sippeers = mysql,asterisk,sip_buddies res_mysql.conf as: [general] dbhost = localhost dbname = asterisk dbuser = root dbpass = asterisk dbport = 3306 dbsock = /var/lib/mysql/mysql.sock My table as: CREATE TABLE iax_buddies ( name varchar(30) primary key NOT NULL, username varchar(30), type varchar(6) NOT NULL, secret varchar(50), callerid varchar(100), context varchar(100), host varchar(31) NOT NULL default 'dynamic', disallow varchar(100), allow varchar(100) ); I'm running asterisk on Fedora 6. Plz help thanks in advance Renzzo ___ Sign up now for AstriCon 2007! September 25-28th. http://www.astricon.net/ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Sign up now for AstriCon 2007! September 25-28th. http://www.astricon.net/ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Sign up now for AstriCon 2007! September 25-28th. http://www.astricon.net/ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
[asterisk-users] Asterisk realtime error
Peder, I have all the permissions in mysql user. I can query my database from the local box. Mik Cheez, yes, it is. mysql.sock is in /var/lib/mysql/ Asterisk and Mysql are in the same PC I still have the same error and don't know what to do. help plz! thanks in advance, Renzzo Mik Cheez wrote: Is your mysql.sock actually in /var/lib/mysql/ ? Peder wrote: Could be a mysql permission issue. Try this from the local box: mysql -u root -p enter asterisk as the password use asterisk; select * from sip_buddies; select * from iax_buddies; If you get that far and can see the entries in iax_buddies and sip_buddies, you know it isn't a permissions issue. If you can't, then you know where to look. RENZZO SOTOMAYOR wrote: Hi! I am proving Asterisk 1.2.24 in realtime with MySQL 5.0.27 using Idefisk softphones. I followed the steps of how to of voip-org but always have this error: Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL RealTime: Failed to query database. Check debug for more info. Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL RealTime: Failed to query database. Check debug for more info. Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL RealTime: Failed to query database. Check debug for more info. Sep 25 20:29:07 NOTICE[12000]: chan_iax2.c:5252 register_verify: Host 127.0.0.1 http://127.0.0.1/ failed MD5 authentication for '101' (9a43a82001dfa49d84e8facb765f7 d e2 != 31610d29241e861816b83998501ee223) I configure extconfig.conf as: [settings] iaxusers = mysql,asterisk,iax_buddies iaxpeers = mysql,asterisk,iax_buddies sipusers = mysql,asterisk,sip_buddies sippeers = mysql,asterisk,sip_buddies res_mysql.conf as: [general] dbhost = localhost dbname = asterisk dbuser = root dbpass = asterisk dbport = 3306 dbsock = /var/lib/mysql/mysql.sock My table as: CREATE TABLE iax_buddies ( name varchar(30) primary key NOT NULL, username varchar(30), type varchar(6) NOT NULL, secret varchar(50), callerid varchar(100), context varchar(100), host varchar(31) NOT NULL default 'dynamic', disallow varchar(100), allow varchar(100) ); I'm running asterisk on Fedora 6. Plz help thanks in advance Renzzo ___ Sign up now for AstriCon 2007! September 25-28th. http://www.astricon.net/ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Sign up now for AstriCon 2007! September 25-28th. http://www.astricon.net/ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
[asterisk-users] Asterisk realtime error
Hi! I am proving Asterisk 1.2.24 in realtime with MySQL 5.0.27 using Idefisk softphones. I followed the steps of how to of voip-org but always have this error: Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL RealTime: Failed to query database. Check debug for more info. Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL RealTime: Failed to query database. Check debug for more info. Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL RealTime: Failed to query database. Check debug for more info. Sep 25 20:29:07 NOTICE[12000]: chan_iax2.c:5252 register_verify: Host 127.0.0.1 failed MD5 authentication for '101' (9a43a82001dfa49d84e8facb765f7de2 != 31610d29241e861816b83998501ee223) I configure extconfig.conf as: [settings] iaxusers = mysql,asterisk,iax_buddies iaxpeers = mysql,asterisk,iax_buddies sipusers = mysql,asterisk,sip_buddies sippeers = mysql,asterisk,sip_buddies res_mysql.conf as: [general] dbhost = localhost dbname = asterisk dbuser = root dbpass = asterisk dbport = 3306 dbsock = /var/lib/mysql/mysql.sock My table as: CREATE TABLE iax_buddies ( name varchar(30) primary key NOT NULL, username varchar(30), type varchar(6) NOT NULL, secret varchar(50), callerid varchar(100), context varchar(100), host varchar(31) NOT NULL default 'dynamic', disallow varchar(100), allow varchar(100) ); I'm running asterisk on Fedora 6. Plz help thanks in advance Renzzo ___ Sign up now for AstriCon 2007! September 25-28th. http://www.astricon.net/ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Asterisk realtime error
Could be a mysql permission issue. Try this from the local box: mysql -u root -p enter asterisk as the password use asterisk; select * from sip_buddies; select * from iax_buddies; If you get that far and can see the entries in iax_buddies and sip_buddies, you know it isn't a permissions issue. If you can't, then you know where to look. RENZZO SOTOMAYOR wrote: Hi! I am proving Asterisk 1.2.24 in realtime with MySQL 5.0.27 using Idefisk softphones. I followed the steps of how to of voip-org but always have this error: Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL RealTime: Failed to query database. Check debug for more info. Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL RealTime: Failed to query database. Check debug for more info. Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL RealTime: Failed to query database. Check debug for more info. Sep 25 20:29:07 NOTICE[12000]: chan_iax2.c:5252 register_verify: Host 127.0.0.1 http://127.0.0.1/ failed MD5 authentication for '101' (9a43a82001dfa49d84e8facb765f7d e2 != 31610d29241e861816b83998501ee223) I configure extconfig.conf as: [settings] iaxusers = mysql,asterisk,iax_buddies iaxpeers = mysql,asterisk,iax_buddies sipusers = mysql,asterisk,sip_buddies sippeers = mysql,asterisk,sip_buddies res_mysql.conf as: [general] dbhost = localhost dbname = asterisk dbuser = root dbpass = asterisk dbport = 3306 dbsock = /var/lib/mysql/mysql.sock My table as: CREATE TABLE iax_buddies ( name varchar(30) primary key NOT NULL, username varchar(30), type varchar(6) NOT NULL, secret varchar(50), callerid varchar(100), context varchar(100), host varchar(31) NOT NULL default 'dynamic', disallow varchar(100), allow varchar(100) ); I'm running asterisk on Fedora 6. Plz help thanks in advance Renzzo ___ Sign up now for AstriCon 2007! September 25-28th. http://www.astricon.net/ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Sign up now for AstriCon 2007! September 25-28th. http://www.astricon.net/ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Asterisk realtime error
Is your mysql.sock actually in /var/lib/mysql/ ? RENZZO SOTOMAYOR wrote: Hi! I am proving Asterisk 1.2.24 in realtime with MySQL 5.0.27 using Idefisk softphones. I followed the steps of how to of voip-org but always have this error: Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL RealTime: Failed to query database. Check debug for more info. Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL RealTime: Failed to query database. Check debug for more info. Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL RealTime: Failed to query database. Check debug for more info. Sep 25 20:29:07 NOTICE[12000]: chan_iax2.c:5252 register_verify: Host 127.0.0.1 http://127.0.0.1/ failed MD5 authentication for '101' (9a43a82001dfa49d84e8facb765f7d e2 != 31610d29241e861816b83998501ee223) I configure extconfig.conf as: [settings] iaxusers = mysql,asterisk,iax_buddies iaxpeers = mysql,asterisk,iax_buddies sipusers = mysql,asterisk,sip_buddies sippeers = mysql,asterisk,sip_buddies res_mysql.conf as: [general] dbhost = localhost dbname = asterisk dbuser = root dbpass = asterisk dbport = 3306 dbsock = /var/lib/mysql/mysql.sock My table as: CREATE TABLE iax_buddies ( name varchar(30) primary key NOT NULL, username varchar(30), type varchar(6) NOT NULL, secret varchar(50), callerid varchar(100), context varchar(100), host varchar(31) NOT NULL default 'dynamic', disallow varchar(100), allow varchar(100) ); I'm running asterisk on Fedora 6. Plz help thanks in advance Renzzo ___ Sign up now for AstriCon 2007! September 25-28th. http://www.astricon.net/ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Sign up now for AstriCon 2007! September 25-28th. http://www.astricon.net/ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Asterisk realtime error
Peder, I have all the permissions in mysql user. I can query my database from the local box. Mik Cheez, yes, it is. mysql.sock is in /var/lib/mysql/ Asterisk and Mysql are in the same PC I still have the same error and don't know what to do. help plz! thanks in advance, Renzzo Mik Cheez wrote: Is your mysql.sock actually in /var/lib/mysql/ ? Peder wrote: Could be a mysql permission issue. Try this from the local box: mysql -u root -p enter asterisk as the password use asterisk; select * from sip_buddies; select * from iax_buddies; If you get that far and can see the entries in iax_buddies and sip_buddies, you know it isn't a permissions issue. If you can't, then you know where to look. RENZZO SOTOMAYOR wrote: Hi! I am proving Asterisk 1.2.24 in realtime with MySQL 5.0.27 using Idefisk softphones. I followed the steps of how to of voip-org but always have this error: Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL RealTime: Failed to query database. Check debug for more info. Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL RealTime: Failed to query database. Check debug for more info. Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL RealTime: Failed to query database. Check debug for more info. Sep 25 20:29:07 NOTICE[12000]: chan_iax2.c:5252 register_verify: Host 127.0.0.1 http://127.0.0.1/ failed MD5 authentication for '101' (9a43a82001dfa49d84e8facb765f7d e2 != 31610d29241e861816b83998501ee223) I configure extconfig.conf as: [settings] iaxusers = mysql,asterisk,iax_buddies iaxpeers = mysql,asterisk,iax_buddies sipusers = mysql,asterisk,sip_buddies sippeers = mysql,asterisk,sip_buddies res_mysql.conf as: [general] dbhost = localhost dbname = asterisk dbuser = root dbpass = asterisk dbport = 3306 dbsock = /var/lib/mysql/mysql.sock My table as: CREATE TABLE iax_buddies ( name varchar(30) primary key NOT NULL, username varchar(30), type varchar(6) NOT NULL, secret varchar(50), callerid varchar(100), context varchar(100), host varchar(31) NOT NULL default 'dynamic', disallow varchar(100), allow varchar(100) ); I'm running asterisk on Fedora 6. Plz help thanks in advance Renzzo ___ Sign up now for AstriCon 2007! September 25-28th. http://www.astricon.net/ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Sign up now for AstriCon 2007! September 25-28th. http://www.astricon.net/ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users