search for: alembic

Displaying 20 results from an estimated 89 matches for "alembic".

2016 Apr 01
3
Asterisk 13.8.0 alembic database update fails.
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. INFO [alembic.migration] Context impl MySQLImpl. INFO [alembic.migration] Will assume non-transactional DDL. INFO [alembic.migration] Running upgrade 2d078ec071b7 -&g...
2015 Sep 24
2
problems with PJSIP install on UBUNTU 14.04
...? 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 https://wiki.asterisk.org/wiki/display/AST/Setting+up+PJSIP+Realtime#SettingupPJSIPRealtime-InstallingandUsingAlembic will cause alembic to upgrade the tables. -- Joshua Colp Digium, Inc. | Senior Software Developer 445 Jan Davis Drive NW - Huntsville, AL 35806 - US Check us out at: www.digium.com & www.asterisk.org
2016 Apr 01
2
Asterisk 13.8.0 alembic database update fails.
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 you install it - from a > package or pip? A change may have gone in which somehow...
2016 Feb 08
2
sql schema without alembic
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 use > to write it to a new file, >> to > join onot an existing file or | to pass...
2016 Apr 01
5
Asterisk 13.8.0 alembic database update fails.
...arley 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 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 you install it - from a >...
2015 Jul 09
2
Asterisk 13 / realtime voicemail creation
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. |config|- the set of schemas for Asterisk Realtime databases > 2. |voicemail|- the schema...
2014 Apr 14
1
Alembic - Asterisk 11
...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 there any plans to implement that with Asterisk 11, since that is the current LTS release? Or are we pretty sure the table structure won't be changing within that version through the rest of its lifespan, making such an effort a waste? Thanks, Josh -------------- n...
2016 Feb 04
2
sql schema without alembic
hi, is there way to get SQL schema for Asterisk 13.7.0 without alembic? thanks -- --------------------------------------- Marek Cervenka =======================================
2017 Jul 12
2
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....
2017 Jul 12
2
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.fl...
2017 Sep 15
3
Realtime pjsip issues
...the endpoints tables. It keeps putting the value from the endpoints > id > field as the entries it can't find. > > One point of note the tables we used and created for pjsip back when we > setup the 13.12.2 version are not what is currently being created when we > run alembic now.. Also the contact table from alembic creation process > does > not work we get insert errors inside of asterisk when contact entry > attempts are being crated. It shows a number of fields that are not there > in the created tables. > > This is the foundation of my iss...
2018 Dec 07
2
cdr_odbc.c:174 odbc_log: Unable to retrieve database handle. CDR failed.
...n't make any sense to call it data source name (dsn) at places where the name of a section is expected. It also doesn't make sense that the section name in res_odbc.conf should be relevant here. Resources (res) would be configuration information --- the tables for this are created with alembic --- while logging information is something else --- and the tables for it are not created with alembic. This could use a lot of cleanup and (or at least) much better documentation.
2016 Sep 12
3
Mysql PJSIP realtime > 13.10?
...:2001 at 192.168.2.165:5060;transport=udp has been >> deleted >> >> Up until 13.10 everything was working despite the warnings about >> field types. Now my phones will not register. I can make calls but not >> receive. All database modifications are done through alembic so they are >> supposed to be up to date. The only way I can find to solve this issue >> right now is to restore a 13.10 backup for both the database and Asterisk. >> > > res_config_mysql has been in "extended" support for some time now and it's > possible...
2018 Dec 07
4
how to use a database
...[...] >> >> 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 odbc? Alembic made the primary key so that each queue can only have one entry (What is an interface here?), and there's probably a reason for that. How do you enter several members for a queue? Asterisk seems to either rather crash than to create a queue, or to do nothing.
2016 Sep 12
2
Mysql PJSIP realtime > 13.10?
...65:5060;transport=udp has been >>> deleted >>> >>> Up until 13.10 everything was working despite the warnings about >>> field types. Now my phones will not register. I can make calls but not >>> receive. All database modifications are done through alembic so they are >>> supposed to be up to date. The only way I can find to solve this issue >>> right now is to restore a 13.10 backup for both the database and Asterisk. >>> >> >> res_config_mysql has been in "extended" support for some time now and &gt...
2023 Apr 06
1
Intro and question
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 ... > Thanks in advance for any assistance. Well, my first question would be "are you intending to use Asterisk Realtime features (ie: configurations in database tables instead of text files)...
2023 Apr 06
1
Intro and question
...t 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 ... >> Thanks in advance for any assistance. > Well, my first question would be "are you intending to use Asterisk Realtime > features (ie: configurations in database tables instea...
2016 Sep 12
4
Mysql PJSIP realtime > 13.10?
...OR '2001' == Contact 2001/sip:2001 at 192.168.2.165:5060;transport=udp has been deleted Up until 13.10 everything was working despite the warnings about field types. Now my phones will not register. I can make calls but not receive. All database modifications are done through alembic so they are supposed to be up to date. The only way I can find to solve this issue right now is to restore a 13.10 backup for both the database and Asterisk. -- Telecomunicaciones Abiertas de M?xico S.A. de C.V. Carlos Ch?vez +52 (55)9116-91161
2017 Sep 14
3
Realtime pjsip issues
On Thu, Sep 14, 2017, at 05:27 PM, Bryant Zimmerman wrote: > This appears to be some kind of cache issue. > We have been doing caching with earlier versions of asterisk 13 on the > pjsip realtime, but now for some reason > The items only show up the first time we use pjsip list/show and then > they > are wiped. I see a new full cache option and that appears to make a >
2023 Apr 06
2
Intro and question
...l Configuration" section detailing some changes to modules.conf and logger.conf, and a few ownership change commands to certain files and directories. All went exactly according to the documentation. Then the weeds started to appear, and I was off into them. The first was the mention of Alembic. This was not installed as part of the apt-get installation mentioned above, but I expected whatever Alembic could do, I could do manually, it'd just take longer and be more tedious. NO problem. I'd get through it. Reading on, I found this, regarding an SQL database: Log into the dat...