[prev in list] [next in list] [prev in thread] [next in thread]
List: openser-users
Subject: Re: [SR-Users] Dispatcher Questions
From: Grant Bagdasarian <gb () cm ! nl>
Date: 2018-09-26 5:43:38
Message-ID: 1f0026194863486bb89ce8677f2e67d8 () cm ! nl
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
[Attachment #4 (text/plain)]
Hi Duarte,
Using views is perfectly fine, as long as the results are in the schema the \
dispatcher module requires. We're also using views to feed the dispatcher module with \
data, but this is a one way data flow. I'm unaware of the dispatcher module also \
being able to push data (state) back to the database, so if you do require this, it \
would be wise to check out the module features.
Basically any module can work with views (if you wish to restructure your database in \
another way). I haven't encountered a module not being able to work with a view, \
unless two-way data flow is required.
Regards,
Grant Bagdasarian
Senior Developer
cm.com<https://cm.com>
[cid:image002.png@01D4556C.C1800AD0]
From: sr-users <sr-users-bounces@lists.kamailio.org> On Behalf Of Duarte Rocha
Sent: dinsdag 25 september 2018 20:01
To: sr-users@lists.kamailio.org
Subject: [SR-Users] Dispatcher Questions
Greetings,
I have some questions about Dispatcher0s modules general behaviours.
Can Dispatcher use two tables to read values from?
If I can't use two tables, is it possible to read them from a Mysql View?
I want to be able to have a Gateway belonging to more than one Gateway Set. By doing \
so, in the table, the gateway will be repeated but with different groups. How will \
the probing work in this scenario? Will the Gateway be probed multiple times?
Thanks for your help.
Cheers
[Attachment #5 (text/html)]
<html xmlns:v="urn:schemas-microsoft-com:vml" \
xmlns:o="urn:schemas-microsoft-com:office:office" \
xmlns:w="urn:schemas-microsoft-com:office:word" \
xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" \
xmlns="http://www.w3.org/TR/REC-html40"> <head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span lang="NL">Hi Duarte, <o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Using views is perfectly fine, as long as the results are in the \
schema the dispatcher module requires. <o:p></o:p></p>
<p class="MsoNormal">We're also using views to feed the dispatcher module with data, \
but this is a one way data flow. <o:p></o:p></p>
<p class="MsoNormal">I'm unaware of the dispatcher module also being able to push \
data (state) back to the database, so if you do require this, it would be wise to \
check out the module features. <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Basically any module can work with views (if you wish to \
restructure your database in another way). I haven't encountered a module not being \
able to work with a view, unless two-way data flow is required. <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Regards,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td style="padding:0cm 0cm 1.5pt 0cm">
<p class="MsoNormal"><span style="font-size:16.0pt;color:#1657EA">Grant \
Bagdasarian</span><span style="font-size:12.0pt;color:#1657EA"><o:p></o:p></span></p> \
</td> </tr>
<tr>
<td style="padding:0cm 0cm 15.0pt 0cm">
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">Senior \
Developer</span><span style="font-size:9.0pt;color:black"><o:p></o:p></span></p> \
</td> </tr>
<tr>
<td style="padding:0cm 0cm 1.5pt 0cm">
<p class="MsoNormal"><span \
style="font-size:9.0pt;color:#1657EA"><o:p> </o:p></span></p> </td>
</tr>
<tr>
<td style="padding:0cm 0cm 15.0pt 0cm">
<p class="MsoNormal"><span style="font-size:12.0pt;color:#1657EA"><a \
href="https://cm.com"><span style="color:blue">cm.com</span></a></span><span \
style="font-size:9.0pt;color:#1657EA"><o:p></o:p></span></p> </td>
</tr>
<tr>
<td style="padding:3.75pt 0cm 16.5pt 0cm">
<p class="MsoNormal"><img border="0" width="150" height="61" \
style="width:1.5625in;height:.6354in" id="_x0000_i1025" \
src="cid:image002.png@01D4556C.C1800AD0"><o:p></o:p></p> </td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span lang="NL"><o:p> </o:p></span></p>
<p class="MsoNormal"><b>From:</b> sr-users \
<sr-users-bounces@lists.kamailio.org> <b> On Behalf Of </b>Duarte Rocha<br>
<b>Sent:</b> dinsdag 25 september 2018 20:01<br>
<b>To:</b> sr-users@lists.kamailio.org<br>
<b>Subject:</b> [SR-Users] Dispatcher Questions<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">Greetings, <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I have some questions about Dispatcher0s modules general \
behaviours.<o:p></o:p></p> </div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Can Dispatcher use two tables to read values \
from?<o:p></o:p></p> </div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">If I can't use two tables, is it possible to read them from a \
Mysql View? <o:p></o:p></p> </div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I want to be able to have a Gateway belonging to more than one \
Gateway Set. By doing so, in the table, the gateway will be repeated but with \
different groups. How will the probing work in this scenario? Will the Gateway be \
probed multiple times?<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Thanks for your help.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Cheers<o:p></o:p></p>
</div>
</div>
</div>
</body>
</html>
["image002.png" (image/png)]
[Attachment #7 (unknown)]
_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users@lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic