Here's how you store the resultant value from the avp_db_query() function;<div><br></div><div><span style> avp_db_query("select count from load_count where dest='1'"<b>,"$avp(i:1)"</b>);</span> <br>
<br>if you do not put the bold ","$avp(i:1)" in parameter then your avp_db_query returns 1 on successful query i.e if there are any results in the query. If there were no query results then it returns 0;</div>
<div><br></div><div>But the thing is If you are getting errors on startup like u said i.e OpenSIPS is not starting then its probably something really wrong in your configurations file, on the other hand if opensips starts and you are getting errors while executing those queries then I can assume some error with your query or error around it.</div>
<div><br></div><div>Regards,</div><div>Sammy</div><div><br><div class="gmail_quote">On Tue, Jun 19, 2012 at 10:55 AM, Rudy <span dir="ltr"><<a href="mailto:rudy@dynamicpacket.com" target="_blank">rudy@dynamicpacket.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Prasad,<br>
<br>
You really need to do some more debugging (and documentation reading)<br>
on your own before asking for help on any list. Firstly, your queries<br>
are not valid, paste them into the mysql<br>
console so you can see the error yourself ( eg: " select count from<br>
load_count where dest='2' " ). Its probably a good idea for you to<br>
read up on SQL and how to use it.<br>
Second, if you need help with the avpops module, please refer to the<br>
documentation @<br>
<a href="http://www.opensips.org/html/docs/modules/1.8.x/avpops.html" target="_blank">http://www.opensips.org/html/docs/modules/1.8.x/avpops.html</a> .<br>
<br>
Thanks in advance,<br>
--Rudy<br>
Dynamic Packet<br>
Toll-Free: 888.929.VOIP ( 8647 )<br>
<div class="HOEnZb"><div class="h5"><br>
<br>
On Tue, Jun 19, 2012 at 1:35 AM, prasad kelkar <<a href="mailto:durga144@gmail.com">durga144@gmail.com</a>> wrote:<br>
> hello,<br>
> I created table as folows.<br>
> mysql> use opensips;<br>
> Reading table information for completion of table and column names<br>
> You can turn off this feature to get a quicker startup with -A<br>
><br>
> Database changed<br>
> mysql> select * from load_count;<br>
> +------+-------+<br>
> | dest | count |<br>
> +------+-------+<br>
> | 1 | 1 |<br>
> +------+-------+<br>
> 1 row in set (0.10 sec)<br>
> my cfg is as follows<br>
> I am getting error while starting opensips<br>
> please help<br>
> debug=3<br>
> log_stderror=no<br>
> log_facility=LOG_LOCAL0<br>
><br>
> fork=yes<br>
> children=4<br>
><br>
> /* uncomment the following lines to enable debugging */<br>
> #debug=6<br>
> #fork=no<br>
> #log_stderror=yes<br>
><br>
> /* uncomment the next line to disable TCP (default on) */<br>
> #disable_tcp=yes<br>
><br>
> /* uncomment the next line to enable the auto temporary blacklisting of<br>
> not available destinations (default disabled) */<br>
> #disable_dns_blacklist=no<br>
><br>
> /* uncomment the next line to enable IPv6 lookup after IPv4 dns<br>
> lookup failures (default disabled) */<br>
> #dns_try_ipv6=yes<br>
><br>
> /* uncomment the next line to disable the auto discovery of local aliases<br>
> based on revers DNS on IPs (default on) */<br>
> #auto_aliases=no<br>
><br>
> /* uncomment the following lines to enable TLS support (default off) */<br>
> #disable_tls = no<br>
> #listen = tls:your_IP:5061<br>
> #tls_verify_server = 1<br>
> #tls_verify_client = 1<br>
> #tls_require_client_certificate = 0<br>
> #tls_method = TLSv1<br>
> #tls_certificate = "/usr/local/etc/opensips/tls/user/user-cert.pem"<br>
> #tls_private_key = "/usr/local/etc/opensips/tls/user/user-privkey.pem"<br>
> #tls_ca_list = "/usr/local/etc/opensips/tls/user/user-calist.pem"<br>
><br>
><br>
> port=5060<br>
><br>
> /* uncomment and configure the following line if you want opensips to<br>
> bind on a specific interface/port/proto (default bind on all available) */<br>
> #listen=udp:<a href="http://192.168.1.2:5060" target="_blank">192.168.1.2:5060</a><br>
><br>
><br>
> ####### Modules Section ########<br>
><br>
> #set module path<br>
> mpath="/usr/local/lib/opensips/modules/"<br>
><br>
> /* uncomment next line for MySQL DB support */<br>
> loadmodule "db_mysql.so"<br>
> loadmodule "statistics.so"<br>
> loadmodule "sl.so"<br>
> loadmodule "tm.so"<br>
> loadmodule "rr.so"<br>
> loadmodule "maxfwd.so"<br>
> loadmodule "usrloc.so"<br>
> loadmodule "registrar.so"<br>
> loadmodule "textops.so"<br>
> loadmodule "mi_fifo.so"<br>
> loadmodule "uri_db.so"<br>
> loadmodule "uri.so"<br>
> loadmodule "xlog.so"<br>
> loadmodule "acc.so"<br>
> loadmodule "avpops.so"<br>
> /* uncomment next lines for MySQL based authentication support<br>
> NOTE: a DB (like db_mysql) module must be also loaded */<br>
> loadmodule "auth.so"<br>
> loadmodule "auth_db.so"<br>
> /* uncomment next line for aliases support<br>
> NOTE: a DB (like db_mysql) module must be also loaded */<br>
> #loadmodule "alias_db.so"<br>
> /* uncomment next line for multi-domain support<br>
> NOTE: a DB (like db_mysql) module must be also loaded<br>
> NOTE: be sure and enable multi-domain support in all used modules<br>
> (see "multi-module params" section ) */<br>
> #loadmodule "domain.so"<br>
> /* uncomment the next two lines for presence server support<br>
> NOTE: a DB (like db_mysql) module must be also loaded */<br>
> #loadmodule "presence.so"<br>
> #loadmodule "presence_xml.so"<br>
><br>
><br>
><br>
> # ----------------- setting module-specific parameters ---------------<br>
><br>
><br>
> # ----- mi_fifo params -----<br>
> modparam("mi_fifo", "fifo_name", "/tmp/opensips_fifo")<br>
> modparam("statistics", "variable", "count")<br>
><br>
><br>
> # ----- rr params -----<br>
> # add value to ;lr param to cope with most of the UAs<br>
> modparam("rr", "enable_full_lr", 1)<br>
> # do not append from tag to the RR (no need for this script)<br>
> modparam("rr", "append_fromtag", 0)<br>
><br>
><br>
> # ----- rr params -----<br>
> modparam("registrar", "method_filtering", 1)<br>
> /* uncomment the next line to disable parallel forking via location */<br>
> # modparam("registrar", "append_branches", 0)<br>
> /* uncomment the next line not to allow more than 10 contacts per AOR */<br>
> #modparam("registrar", "max_contacts", 10)<br>
><br>
><br>
> # ----- uri_db params -----<br>
> /* by default we disable the DB support in the module as we do not need it<br>
> in this configuration */<br>
> #modparam("uri_db", "use_uri_table", 0)<br>
> #modparam("uri_db", "db_url", "")<br>
><br>
><br>
> # ----- acc params -----<br>
> /* what sepcial events should be accounted ? */<br>
> modparam("acc", "early_media", 1)<br>
> modparam("acc", "report_ack", 1)<br>
> modparam("acc", "report_cancels", 1)<br>
> /* by default ww do not adjust the direct of the sequential requests.<br>
> if you enable this parameter, be sure the enable "append_fromtag"<br>
> in "rr" module */<br>
> modparam("acc", "detect_direction", 0)<br>
> /* account triggers (flags) */<br>
> modparam("acc", "failed_transaction_flag", 3)<br>
> modparam("acc", "log_flag", 1)<br>
> modparam("acc", "log_missed_flag", 2)<br>
> /* uncomment the following lines to enable DB accounting also */<br>
> modparam("acc", "db_flag", 1)<br>
> modparam("acc", "db_missed_flag", 2)<br>
><br>
><br>
> # ----- usrloc params -----<br>
> modparam("usrloc", "db_mode", 0)<br>
> /* uncomment the following lines if you want to enable DB persistency<br>
> for location entries */<br>
> modparam("usrloc", "db_mode", 2)<br>
> modparam("usrloc", "db_url",<br>
> "mysql://opensips:opensipsrw@localhost/opensips")<br>
><br>
><br>
> # ----- auth_db params -----<br>
> /* uncomment the following lines if you want to enable the DB based<br>
> authentication */<br>
> modparam("auth_db", "calculate_ha1", yes)<br>
> modparam("auth_db", "password_column", "password")<br>
> modparam("auth_db", "db_url",<br>
> "mysql://opensips:opensipsrw@localhost/opensips")<br>
> #modparam("auth_db", "load_credentials", "")<br>
><br>
><br>
> # ----- alias_db params -----<br>
> /* uncomment the following lines if you want to enable the DB based<br>
> aliases */<br>
> #modparam("alias_db", "db_url",<br>
> # "mysql://opensips:opensipsrw@localhost/opensips")<br>
><br>
><br>
> # ----- domain params -----<br>
> /* uncomment the following lines to enable multi-domain detection<br>
> support */<br>
> #modparam("domain", "db_url",<br>
> # "mysql://opensips:opensipsrw@localhost/opensips")<br>
> #modparam("domain", "db_mode", 1) # Use caching<br>
><br>
><br>
> # ----- multi-module params -----<br>
> /* uncomment the following line if you want to enable multi-domain support<br>
> in the modules (dafault off) */<br>
> #modparam("alias_db|auth_db|usrloc|uri_db", "use_domain", 1)<br>
><br>
> # ----- presence params -----<br>
> /* uncomment the following lines if you want to enable presence */<br>
> #modparam("presence|presence_xml", "db_url",<br>
> # "mysql://opensips:opensipsrw@localhost/opensips")<br>
> #modparam("presence_xml", "force_active", 1)<br>
> #modparam("presence", "server_address", "sip:<a href="http://192.168.1.2:5060" target="_blank">192.168.1.2:5060</a>")<br>
> #modparam("dispatcher", "count", 0)<br>
> modparam("avpops","db_url","mysql://opensips:opensipsrw@localhost/opensips")<br>
> modparam("avpops","avp_table","load_count")<br>
> route{<br>
> if (is_method("INVITET"))<br>
> {<br>
> avp_db_query("select count from load_count where dest='1'");<br>
> avp_db_query("select count from load_count where dest='2'");<br>
> if(avp_check("$avp(1)", "lt/$avp(2)"))<br>
> {<br>
> forward("<a href="http://172.29.9.131:5060" target="_blank">172.29.9.131:5060</a>");<br>
> exit();<br>
> }<br>
> else<br>
> {<br>
> forward("<a href="http://172.29.9.136:5060" target="_blank">172.29.9.136:5060</a>");<br>
> exit;<br>
> }<br>
> }<br>
><br>
> _______________________________________________<br>
> Users mailing list<br>
> <a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
> <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</div></div></blockquote></div><br></div>