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