<div dir="ltr"><div><div>Yes I have corrected the mistake.<br><br></div>Thanks.<br><br>Hi Federico,<br><br>Sorry to interrupt you once again, As per your input avpops worked fine for my scenario. Thanks once again.<br><br>I am having one more query, I need to know how to reduce the user balance amount .<br><br>Is there any module? Input please<br><br></div>Scenario:<br>=======<br>I am having an user name 777, 777 having the credit of 10$<br><br>I mentioned the below details as well:<br><br>$var(credit) = "10$"<br>$var(cost_per_sec) = "1"; # 1$ per sec<br> $var(i_pulse) = "1"; # 1$ to establish the call<br> $var(f_pulse) = "1"; # 1$ per second<br><br>so the user 777 should make call only for 9 seconds, the call should disconnect after the 9th second.<br><br>Also I need to reduce the credit balance as well.<br></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Aug 9, 2017 at 11:43 AM, Federico Cabiddu <span dir="ltr"><<a href="mailto:federico.cabiddu@gmail.com" target="_blank">federico.cabiddu@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Assuming that you started from default kamailio.cfg or kamailio-basic.cfg, do you also have #!define WITH_MYSQL?<div><br></div><div>Cheers,</div><div><br></div><div>Federico</div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Aug 9, 2017 at 8:05 AM, Logeshwaran G <span dir="ltr"><<a href="mailto:logeshwarangs@gmail.com" target="_blank">logeshwarangs@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Yes I have defined<br><br>#!define DBURL "mysql://root:root@localhost/k<wbr>amailio"<br></div><div class="m_287532536402475743HOEnZb"><div class="m_287532536402475743h5"><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Aug 9, 2017 at 11:32 AM, Federico Cabiddu <span dir="ltr"><<a href="mailto:federico.cabiddu@gmail.com" target="_blank">federico.cabiddu@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>Hi,</div>have you defined DBURL anywhere?<div><br></div><div>Cheers,</div><div><br></div><div>Federico<br><div><br></div></div></div><div class="gmail_extra"><br><div class="gmail_quote"><div><div class="m_287532536402475743m_-1043971473068136923h5">On Wed, Aug 9, 2017 at 8:00 AM, Logeshwaran G <span dir="ltr"><<a href="mailto:logeshwarangs@gmail.com" target="_blank">logeshwarangs@gmail.com</a>></span> wrote:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="m_287532536402475743m_-1043971473068136923h5"><div dir="ltr"><div><div>modparam("sqlops","sqlcon",DBU<wbr>RL)<br><br></div>Whether the above modparam implementation is wrong ? I am not sure <br><br></div>Its saying some error as<br> 0(2519) ERROR: sqlops [sql_api.c:669]: sql_parse_param(): invalid sqlops parameter<br><br><br></div>
<br></div></div>______________________________<wbr>_________________<br>
Kamailio (SER) - Users Mailing List<br>
<a href="mailto:sr-users@lists.kamailio.org" target="_blank">sr-users@lists.kamailio.org</a><br>
<a href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" target="_blank">https://lists.kamailio.org/cgi<wbr>-bin/mailman/listinfo/sr-users</a><br>
<br></blockquote></div><br></div>
<br>______________________________<wbr>_________________<br>
Kamailio (SER) - Users Mailing List<br>
<a href="mailto:sr-users@lists.kamailio.org" target="_blank">sr-users@lists.kamailio.org</a><br>
<a href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" target="_blank">https://lists.kamailio.org/cgi<wbr>-bin/mailman/listinfo/sr-users</a><br>
<br></blockquote></div><br></div>
</div></div><br>______________________________<wbr>_________________<br>
Kamailio (SER) - Users Mailing List<br>
<a href="mailto:sr-users@lists.kamailio.org" target="_blank">sr-users@lists.kamailio.org</a><br>
<a href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" target="_blank">https://lists.kamailio.org/cgi<wbr>-bin/mailman/listinfo/sr-users</a><br>
<br></blockquote></div><br></div>
</div></div><br>______________________________<wbr>_________________<br>
Kamailio (SER) - Users Mailing List<br>
<a href="mailto:sr-users@lists.kamailio.org">sr-users@lists.kamailio.org</a><br>
<a href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" target="_blank">https://lists.kamailio.org/<wbr>cgi-bin/mailman/listinfo/sr-<wbr>users</a><br>
<br></blockquote></div><br></div>