[Freeswitch-users] mod db - hostname

[Anders Sonderkjaer]

I found the answer myself: The hostname has to be 'any', since something is
evaluated on it. What exactly hostname it refers to I don't know, but 'any'
makes it take...any.

--Anders

On Sun, Oct 21, 2012 at 2:16 PM, Anders Sonderkjaer <betterzystems at gmail.com
> wrote:

> Hi,
>
> I cannot get fetch the data in db_data from the dialplan. The ODBC is
> running and has been tested.
>
> I have not found any documentation on what the 'hostname' column in the
> db_data table should be - so I just put what the server has right now
> ('freeswitch01') - is that ok?
>
> This is what I am doing in the dialplan:
>
>    <extension name="incoming_did">
>       <condition field="${sip_received_ip}" expression="^1.2.3.\d+$"/>
>       <condition field="destination_number" expression="^(\d+)$">
>          <action application="info"/>
>          <action application="set"
> data="sip_to_user=${db(select/forward/${sip_to_user})}"/>
>          <action application="bridge"
> data="sofia/gateway/main_trunk/9999$1"/>
>       </condition>
>    </extension>
>
> 1.2.3 are the first four digits of the IP address I get the call from -
> this works, have tested it with a hardcoded forward.
>
> The call sent to FS has the To User set to 2000000. I use this to identify
> the user sending the call, and then want to look in db_data to find out
> which number the call should be forwarded to. So 2000000 would be the
> data_key and the value/data is the number to forward to.
> What I want to get out of it, is that a bridge is made to
> sofia/gateway/main_trunk/9999forward_number, where the forward_number is
> the value/data retrieved from db_data, and 9999 is the prefix for the
> termination partner (this works, has been tested).
>
> Input would really be appreciated!
>
> Thanks,
> A.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20121022/8a9fb8f9/attachment-0001.html