similar to: cmd mysql

What I'm retrying to do is update mysql field with the new message ID that was just recorded. Ideally, I'd like to specify the field to update using a variable ${BINID} and use ${NEWPHRASENAME} for the value - I'm not sure asterisk will allow using a variable for the field name and if not, I'll attempt to create an exten for each bin to update. Here the method I'd like to

Hi, I am trying to connect the outbound dialing with mysql with the following code, exten => 88,1,MYSQL(Connect connid hostname username password dbname) exten => 88,2,GotoIf($["${connid}" = ""]?error,1) exten => 88,3,MYSQL(Query resultid ${connid} SELECT\ phone\ FROM\ <tablename>\ WHERE\ phone =${a}) exten => 88,4,MYSQL(Fetch fetchid ${resultid} ph\ sa)

I just connected an Asterisk server to an Avaya Pbx using the instructions at: http://www.voip-info.org/wiki/index.php?page=Asterisk +Avaya Everything seems to be working as I can send and receive calls. The only detail I am having a problem with is that when an extension on the Avaya calls an Asterisk extension, I only get the name part of the CID, not the number. From Asterisk to the Avaya

Greetings all- I have a handful of Asterisk 1.4.x installations where users dial 'outbound calls' to the PSTN even though the destination is on the same Asterisk box or on another Asterisk box on the same network. Instead of paying twice for the call to go out to the PSTN on one channel and back in on another channel, I'd like the ability to lookup the destination number in a MySQL

Hi List Is someone out there using one or more GSMgateway(s) from CyberTelecom ? Me and some friends are interested in buying some of them, but before we would like to ask, how the experiences are others have made. e.g. How easy to setup ? How reliable ? How's the voice quality ? etc. Any input/feedback is welcome. Greets Adibar --

Hello, I'm trying to set up a mailbox for a bunch of domains. To do so I'm running some docker containers (I know I can use multidomain set up and I'm doing so, but I need to have some domains on different containers for specific reasons). In order to keep it all clean, I want to use different PostgreSQL databases for each container, and I'm running the container with an

Hi, I think, there is missing constructor function supporting remote writing for XapianWritableDatabase class in the php bindings (0.9.7). This code: $db = new XapianWritableDatabase(remote_open($db_host, $db_port), $action); returns: Fatal error: No matching function for overloaded 'new_XapianWritableDatabase' (...) $db = new XapianWritableDatabase($path, $action); works fine.

Signed-off-by: Simon Courtois <scourtois at linagora.com> --- src/task-omatic/taskomatic.rb | 5 ++--- 1 files changed, 2 insertions(+), 3 deletions(-) diff --git a/src/task-omatic/taskomatic.rb b/src/task-omatic/taskomatic.rb index 471ec88..1dfd74f 100755 --- a/src/task-omatic/taskomatic.rb +++ b/src/task-omatic/taskomatic.rb @@ -355,11 +355,10 @@ class TaskOmatic end end

Dear all, Considering this simple example of hexbinplot: mixdata <- data.frame(x = c(rnorm(5000), rnorm(5000,4,1.5)), y = c(rnorm(5000), rnorm(5000,2,3)), a = gl(2, 5000)) fig <- hexbinplot(y ~ x | a, mixdata) print(fig) update(fig, colramp = BTC) produces a bad (non-updated) legend. Compare it with: hexbinplot(y ~ x | a, mixdata, colramp = BTC) What

The error is caused by the save! method updating an object that another thread (most likely in taskomatic) already updated. In the case of this race condition, we retry saving. However, a proper fix would involve fixing the locking. --- src/db-omatic/db_omatic.rb | 23 ++++++++++++++++++++--- 1 files changed, 20 insertions(+), 3 deletions(-) diff --git a/src/db-omatic/db_omatic.rb

I have a module as shown below and when I extend an active record to use it, I can not access the primary_key method. In a simple test program using a similar approach where active record is not involved, access to the class methods seems to work ok. What can I do to make this work or so that I can access the class methods ? ################################## require

Hi All Does anyone know how to use the MySQL cmd in Asterisk with LIKE and % in the query? I have: exten => s,5,Set(query=SELECT name from contacts where tel like %${number}) exten => s,6,MySQL(Connect connid hostname username password dbname) exten => s,7,MySQL(Query resultid ${connid} ${query}) But there seems to be a problem with the % sign and I don't know how to

Signed-off-by: Simon COURTOIS <scourtois at linagora.com> --- src/app/controllers/vm_controller.rb | 5 ++ src/app/models/vm_task.rb | 4 +- src/app/views/vm/start.rhtml | 77 ++++++++++++++++++++++++++++++++++ src/task-omatic/taskomatic.rb | 7 +++- 4 files changed, 91 insertions(+), 2 deletions(-) create mode 100644 src/app/views/vm/start.rhtml diff

What wrong with this: [get-dnisinfo] ; sub-routine to get owner's password exten => s,1,Verbose( == ) exten => s,n,MYSQL(Connect connid localhost root password dax) exten => s,n,MYSQL(Query resultid ${connid} SELECT\ password\ FROM\ dnislookup\ WHERE\ dnis=\'${IVR-Exten}\') exten => s,n,MYSQL(Fetch fetchid ${password} password) exten => s,n,Verbose( == Password found

> The compare of interest is clear, I think. It compares a Vector Induction Variable with a broadcasted loop invariant value, aka the BTC. Obtaining the latter operand is the goal, clearly, but to do so, the former operand needs to be recognized as a VIV. Yep, exactly that. > What if this compare is not generated by LV’s fold-tail-by-masking transformation? Not sure I completely follow

rails railscoders --database=mysql created the directory with folders except for a ''components/'' folder which Practical Rails by Alan Bradburne lists as one of the folders created. Continuing with: mysqladmin -u root create railscoders_development returns this: mysqladmin: connect to server at ''localhost'' failed error: ''Access denied for user

An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20090909/4ba848c0/attachment.htm -------------- next part -------------- A non-text attachment was scrubbed... Name: bhfisher.vcf Type: text/x-vcard Size: 253 bytes Desc: not available Url : http://lists.digium.com/pipermail/asterisk-users/attachments/20090909/4ba848c0/attachment.vcf

That doesn?t seem to work either. Where do I find logs for log rotation to see the reason it failed? Ethon > On Nov 16, 2017, at 7:53 PM, Bill Shirley <bill at KnoxvilleChristian.org <mailto:bill at KnoxvilleChristian.org>> wrote: > > I believe you need a 'create' statement to set the permissions. Here > is an example for mariadb: >

Hi people, I'm trying to retrieve data from the database (server MySQL). I have the following dial plan: exten => s,1,Noop(Start) exten => s,n,MYSQL(Connect connid localhost user pass asteriskcdrdb) exten => s,n,Noop(Connid: ${connid}) ... The problem is that the 3? line is not showing the connid. How can I know the error? Thanks,

I have recently noticed that my dovecot-deliver.log is huge and wanted to start rotating it. So a couple of questions: 1. Can the dovecot-deliver.log be combined with the maillog, that gets rotated weekly? If it can be done, is it advisable? Since the inception of this particular server, the log file has been located in the /home/vmail directory. Is there a reason it shouldn?t be located in