* You are viewing the archive for July 17th, 2012

Unplanned Service Outage Within Next Hour For Asterisk Community Services

We’re having some intermittent network difficulties that may affect the Asterisk community services listed below. You may experience an outage for a few minutes sometime during the next 30 minutes to an hour while we swap out some networking equipment. We apologize for any inconvenience.

The services affected may include:

bamboo.asterisk.org
code.asterisk.org
downloads.digium.com
downloads.asterisk.org
git.asterisk.org
issues.asterisk.org
packages.asterisk.org
reviewboard.asterisk.org
svn.asterisk.org
svnview.digium.com
wiki.asterisk.org

How I Could Insert A Record Into The Table With REALTIME

Hello,

I am trying to working with Asterisk RealTime.

According to http://www.voip-info.org/wiki/view/Asterisk+func+realtime

Example writing to database using realtime Add avp into extconfig.conf avp => pgsql,hostedpbx,thiak_avp

and add new extension into extension.conf exten => s,n,Set(REALTIME(avp,attribute,USED_CHANS/BOB,value)=1

This will execute the following SQL:
UPDATE avp SET value = ’1′ WHERE attribute = ‘USED_CHANS/BOB’


My Question is if I would like to execute INSERT SQL statement

like

INSERT IGNORE INTO avp (value, attribute) VALUES(value1, value2)

How I am able to make it work with REALTIME.

Thanks