What is the error line you are reading in logs ?<br><br><div class="gmail_quote">On Tue, Jun 19, 2012 at 10:35 AM, prasad kelkar <span dir="ltr"><<a href="mailto:durga144@gmail.com" target="_blank">durga144@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">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>
</blockquote></div><br>