similar to: 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

Hi, I have following 2 tables: Table 1: POSTAL | VALUE 1000|49 1010|100 1020|50 Table 2: INSEE | POSTAL A|1000 B|1000 C|1010 D|1020 I would like to convert this to the following: INSEE | VALUE_SPREAD A|24.5 B|24.5 C|100 D|50 I can achieve this with a nested SQL query (through counting the number of POSTAL that belong to any given INSEE, and diving the value of the postal in that INSEE by

Hi, I am learning Radrails and want to tie the web project all together by displaying 3 tables linked together. I want to select one item from the main table, and then link to the other two tables. they will be linked by the key of the first table. It seems that I should create a rhtml in a main table or should I just copy the list.rhtml created by the generator scaffold? I might not make any

Dear R helpers I have a table and i need to make new table table1: sire snp1 snp2 snp3 snp4 snp5 snp6 snp7 snp8 snp9 snp10 snp11 snp12 snp13 snp14 snp15 8877 -1 -1 -1 -1 0 0 -1 -1 -1 0 1 1 1 -1 -1 7765 1 1 1 0 0 0 -1 1 1 1 0 0 0 1 0 8766 1 1 -1 0 -1 -1 0 -1 0 -1 -1 -1 0 1 0 6756 0 1 0 -1 1 -1 -1 0 0 0 0 -1 0 1 1 5644 -1 0 1 -1 0 0 0 0 -1 -1 0 0 0 0 1 I have table2 sire

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

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

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

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

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

Hi ihave one table that look like SNP1 SNP2 SNP3 SNP4 SNP5 SIRE1 1 -1 -1 1 -1 SIRE2 1 -1 1 1 1 SIRE3 -1 -1 1 1 0 SIRE4 -1 1 1 0 1 SIRE5 -1 1 -1 -1 1 SIRE6 0 0 0 1 -1 SIRE7 -1 0 -1 1 1 SIRE8 1 -1 NA 0 NA SIRE9 -1 1 1 -1 -1 SIRE10 1 1 1 1 1 table 2 only one line SNP1 SNP2 SNP3 SNP4 SNP5 SIRE100 -1 -1 1

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 every one I?m new to R and I cant figure our how to use the loop to do the following task, any help would be very kind of every one. I have a file called (table3.txt) that contains over 1000 row and over 40 columns. So for example first row would look like that Deafness, EYA4, DIAPH1, MYO7A, TECTA, COL11A2, POU4F3, MYH9, ACTG1, MYO6 I want the loop stamens to loop thro each row

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

after downgrade to 13.8.2 May 27 18:21:06 ast kernel: asterisk[16286]: segfault at 1010024 ip b49162cd sp bfac0940 error 4 in libmysqlclient.so.16.0.0[b48f1000+12e000] after downgrade to 13.7.2 asterisk is ok Dne 27.5.2016 v 18:09 Marek ?ervenka napsal(a): > btw info from my segfault > > Core was generated by `/usr/sbin/asterisk -f -vvvg -c'. > Program terminated with signal 11,

doesnt work for me Dne 29.5.2016 v 17:48 Niklas Larsson napsal(a): > Hi, > > > On 2016-05-27 18:28, Marek ?ervenka wrote: >> after downgrade to 13.8.2 >> May 27 18:21:06 ast kernel: asterisk[16286]: segfault at 1010024 ip >> b49162cd sp bfac0940 error 4 in >> libmysqlclient.so.16.0.0[b48f1000+12e000] >> >> after downgrade to 13.7.2 >>

Hi R user,I am struggling to figure out on how I can calculate the average from the two tables in R. Any one can help me? really your help would be grateful- I am spending so much time to figure it out. It should not be so hard, I think. I have very big data but I have created a hypothetical data for simplification. for example I have : table 1 table 1: species occurance data

hi, i have the same problems as in https://issues.asterisk.org/jira/browse/ASTERISK-25833 my current combination is centos 6 32-bit, unixODBC 2.3.2 (recompiled from fedora20), mysql 5.1.73, mysql-connector-odbc 5.1.5, asterisk 13.9.1 i tried update to mysql-connector-odbc 5.3.6 from oracle but it segfaults every time can you share your working mysql+odbc combination? thanks odbcinst.ini

Hi everyone, Using ARRAY_SIZE improves the code readability. I used coccinelle (I made a change to the array_size.cocci file [1]) to find several places where ARRAY_SIZE could be used instead of other macros or sizeof division. I tried to divide the changes into a patch per subsystem (excepted for staging). If one of the patch should be split into several patches, let me know. In order to reduce

Dne 28.1.2016 v 13:37 Brian :: napsal(a): > when you say load - how many concurrent calls? Is there transcoding > happening? sip / PRIs ? what load? > 12 concurrent calls no transcoding SIP under 1.5 with 4x 1Ghz vcpus (its vmware VPS) > On Thu, Jan 28, 2016 at 9:57 AM, Marek ?ervenka <cervajs at fpf.slu.cz > <mailto:cervajs at fpf.slu.cz>> wrote: > >

Dne 27.1.2016 v 17:50 A J Stiles napsal(a): > On Wednesday 27 Jan 2016, Marek ?ervenka wrote: >> Dne 27.1.2016 v 13:14 A J Stiles napsal(a): >>> On Wednesday 27 Jan 2016, Marek ?ervenka wrote: >>>> hi, >>>> >>>> i have strange problem with asterisk 13 mixmonitor, recording to wav >>>> (centos6) >>>> when the system is