similar to: Asterisk 13.8.0 alembic database update fails.

On 15-09-24 04:42 PM, Ryan, Travis wrote: > Did something change DB-wise with PJSIP and realtime between 13.3.2 > and 13.5.0? I'm getting an unknown column error and unsure where I > need that column and the type it needs to be. Yes, the schema can change between versions. Following the instructions on

On 04/01/2016 04:06 PM, Joshua Colp wrote: > Harley Peters wrote: >> I get the following error when trying to update date the database via >> contrib/ast-db-manage/alembic -c config.ini upgrade head. >> Every previous update has always worked any idea what is wrong. >> >> OS=Debian Jessie, fully up to date. > > What version of Alembic is installed and how did

On Fri, Apr 1, 2016 at 3:22 PM, George Joseph <george.joseph at fairview5.com> wrote: > > > On Fri, Apr 1, 2016 at 3:15 PM, Harley Peters <harley at thepetersclan.com> > wrote: > >> On 04/01/2016 04:06 PM, Joshua Colp wrote: >> >>> Harley Peters wrote: >>> >>>> I get the following error when trying to update date the database

Dne 4.2.2016 v 12:17 A J Stiles napsal(a): > On Thursday 04 Feb 2016, Marek ?ervenka wrote: >> hi, >> >> is there way to get SQL schema for Asterisk 13.7.0 without alembic? >> thanks > Assuming you already have Asterisk up and running, you can just use > > $ mysqldump -d -uroot DATABASE TABLE1 TABLE2 TABLE3 ... > > will print (on STDOUT, so you can just

I've had years of experience using ODBC for CDR, SIP, and extensions with Asterisk. One thing that has been problematic in the past is with documentation as far as database tables changing between versions (even within minor releases, though that was back in the 1.4 days). I was excited to see there is a plan for better managing that on Asterisk 12 via Alembic. All that being said, are

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

hi, is there way to get SQL schema for Asterisk 13.7.0 without alembic? thanks -- --------------------------------------- Marek Cervenka =======================================

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

Hello, I'm having a problem when trying to create realtime stuff for asterisk 13 in mysql DB. Following https://wiki.asterisk.org/wiki/display/AST/Managing+Realtime+Databases+with+Alembic, I've successfully created the main tables using "config" schema. > Update |script_location|to the schema to update. Asterisk currently > supports two sets of schemas: > > 1.

The Asterisk Development Team has announced the release of Asterisk 13.8.0. This release is available for immediate download at http://downloads.asterisk.org/pub/telephony/asterisk The release of Asterisk 13.8.0 resolves several issues reported by the community and would have not been possible without your participation. Thank you! The following are the issues resolved in this release: New

On Fri, Sep 15, 2017, at 10:37 AM, Bryant Zimmerman wrote: > Joshua > > That is the interesting part of it. We took our configs and database > tables from our working 13.12.2 deployments and tried to use them with > our > new 13.17.1 deployments and we are having issues where the tables are not > working. On the new server asterisk keeps saying it can't find the

On 12/07/2018 02:25 PM, Joshua C. Colp wrote: > On Fri, Dec 7, 2018, at 9:19 AM, hw wrote: >> >> Hi, >> >> is cdr logging using odbc buggy? I'im only getting an error >> "cdr_odbc.c:174 odbc_log: Unable to retrieve database handle. CDR failed.". >> >> Connecting with isql to the datasource given in cdr_odbc.conf works just >> fine,

Anthony, No, I had no intention of doing any of those things, for I know not what they are or why I would need or want to be doing them. Maybe I should have just stuck with the original idea of installing from Debian distro. I'm exploring the phreaknet option now. If I come up with a running system, I'm just going to leave it that way and work with it as it is. On 4/6/2023 10:35

On Thursday 06 April 2023 at 15:48:24, Steve Matzura wrote: > this is the first time I have attempted a > from-scratch installation and setup on my own. ...<so far, so good>... > Then the weeds started to appear, and I was off into them. > > The first was the mention of Alembic. > Reading on, I found this, regarding an SQL database: > SQL? Database? Where ... what

On Mon, Sep 12, 2016 at 3:01 PM, Carlos Chavez <cursor at telecomabmex.com> wrote: > On 9/12/16 3:39 PM, George Joseph wrote: > > > > On Mon, Sep 12, 2016 at 2:31 PM, George Joseph <gjoseph at digium.com> wrote: > >> >> >> On Mon, Sep 12, 2016 at 2:14 PM, Carlos Chavez <cursor at telecomabmex.com> >> wrote: >> >>> Has

On Mon, Sep 12, 2016 at 2:31 PM, George Joseph <gjoseph at digium.com> wrote: > > > On Mon, Sep 12, 2016 at 2:14 PM, Carlos Chavez <cursor at telecomabmex.com> > wrote: > >> Has anyone successfully used Mysql realtime PJSIP with Asterisk >> 13.11? I have tried 13.11, 13.11.1 and 13.11.2 but I always get the >> following error now: >>

I've been using Asterisk, including administering and maintaining it, in some aspect since 2003, but this is the first time I have attempted a from-scratch installation and setup on my own. I'm following the instructions in the ePub edition of the book "Asterisk, the Definitive Guide, Fifth Edition," published by O’Reilly Media, Inc. in 2019, for Asterisk version 16 on a

The Asterisk Development Team has announced the release of Asterisk 13.8.0. This release is available for immediate download at http://downloads.asterisk.org/pub/telephony/asterisk The release of Asterisk 13.8.0 resolves several issues reported by the community and would have not been possible without your participation. Thank you! The following are the issues resolved in this release: New

On 12/07/2018 03:36 PM, Administrator TOOTAI wrote: > Le 07/12/2018 à 14:32, hw a écrit : > > [...] >> >> Queues seem to be the only way to have several phones ring at once, or >> are there other ways? > > Dial(SIP/Phone1&SIP/Phone2&...&SIP/Phonex,,) > Good to know, thanks! What are the entries needed in the queue_members table when using

Has anyone successfully used Mysql realtime PJSIP with Asterisk 13.11? I have tried 13.11, 13.11.1 and 13.11.2 but I always get the following error now: Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162 require_mysql: Realtime table general at ps_contacts: column 'qualify_timeout' cannot be type 'int(10)' (need char) [Sep 12 14:42:35] WARNING[24498]: