acc problem

classic Classic list List threaded Threaded
8 messages Options
Reply | Threaded
Open this post in threaded view
|

acc problem

ASHWINI NAIDU

hi All,

    Installed opensips-1.4.4 . my acc module is supoorted with mysql. but when i try to insert values into acc table using the below command the acc table is not getting populated.


--
Thanking You,
Ashwini BR Naidu

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: acc problem

Bogdan-Andrei Iancu
Hi ASHWINI,

ASHWINI NAIDU wrote:
>
> hi All,
>
>     Installed opensips-1.4.4 . my acc module is supoorted with mysql.
> but when i try to insert values into acc table using the below command
> the acc table is not getting populated.
What is the below command for insert into acc ?

Regards,
Bogdan

>
>
> --
> Thanking You,
> Ashwini BR Naidu
> ------------------------------------------------------------------------
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>  


_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: acc problem

ASHWINI NAIDU
oops sorry

modparam("acc", "db_url", "mysql://opensips:opensipsrw@localhost/opensips")
modparam("acc", "db_extra", "src_user=$fU;src_domain=$fd;dst_user=$rU;dst_domain=$rd;src_ip=$si")

this doesn't insert values into acc table.



On Tue, Feb 10, 2009 at 6:03 PM, Bogdan-Andrei Iancu <[hidden email]> wrote:
Hi ASHWINI,


ASHWINI NAIDU wrote:

hi All,

   Installed opensips-1.4.4 . my acc module is supoorted with mysql. but when i try to insert values into acc table using the below command the acc table is not getting populated.
What is the below command for insert into acc ?

Regards,
Bogdan


--
Thanking You,
Ashwini BR Naidu
------------------------------------------------------------------------

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
 




--
Thanking You,
Ashwini BR Naidu

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: acc problem

Bogdan-Andrei Iancu
You mean you do not get any record in DB or only the db_extra values are
missing?

Do you set the acc flag in your script?

Regards,
Bogdan

ASHWINI NAIDU wrote:

> oops sorry
>
> modparam("acc", "db_url",
> "mysql://opensips:opensipsrw@localhost/opensips")
> modparam("acc", "db_extra",
> "src_user=$fU;src_domain=$fd;dst_user=$rU;dst_domain=$rd;src_ip=$si")
>
> this doesn't insert values into acc table.
>
>
>
> On Tue, Feb 10, 2009 at 6:03 PM, Bogdan-Andrei Iancu
> <[hidden email] <mailto:[hidden email]>> wrote:
>
>     Hi ASHWINI,
>
>
>     ASHWINI NAIDU wrote:
>
>
>         hi All,
>
>            Installed opensips-1.4.4 . my acc module is supoorted with
>         mysql. but when i try to insert values into acc table using
>         the below command the acc table is not getting populated.
>
>     What is the below command for insert into acc ?
>
>     Regards,
>     Bogdan
>
>
>
>         --
>         Thanking You,
>         Ashwini BR Naidu
>         ------------------------------------------------------------------------
>
>         _______________________________________________
>         Users mailing list
>         [hidden email] <mailto:[hidden email]>
>         http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>          
>
>
>
>
>
> --
> Thanking You,
> Ashwini BR Naidu


_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: acc problem

ASHWINI NAIDU
hi bogdan,

I donot get any record in DB. I have written below the setting for acc made.

# ----- acc params -----
/* what sepcial events should be accounted ? */
modparam("acc", "db_url", "mysql://opensips:opensipsrw@localhost/opensips")
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)



On Tue, Feb 10, 2009 at 6:27 PM, Bogdan-Andrei Iancu <[hidden email]> wrote:
You mean you do not get any record in DB or only the db_extra values are missing?

Do you set the acc flag in your script?

Regards,
Bogdan

ASHWINI NAIDU wrote:
oops sorry

modparam("acc", "db_url", "mysql://opensips:opensipsrw@localhost/opensips")
modparam("acc", "db_extra", "src_user=$fU;src_domain=$fd;dst_user=$rU;dst_domain=$rd;src_ip=$si")

this doesn't insert values into acc table.



On Tue, Feb 10, 2009 at 6:03 PM, Bogdan-Andrei Iancu <[hidden email] <mailto:[hidden email]>> wrote:

   Hi ASHWINI,


   ASHWINI NAIDU wrote:


       hi All,

          Installed opensips-1.4.4 . my acc module is supoorted with
       mysql. but when i try to insert values into acc table using
       the below command the acc table is not getting populated.

   What is the below command for insert into acc ?

   Regards,
   Bogdan



       --        Thanking You,
       Ashwini BR Naidu
       ------------------------------------------------------------------------

       _______________________________________________
       Users mailing list
       [hidden email] <mailto:[hidden email]>

       http://lists.opensips.org/cgi-bin/mailman/listinfo/users
       




--
Thanking You,
Ashwini BR Naidu




--
Thanking You,
Ashwini BR Naidu

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: acc problem

Bogdan-Andrei Iancu
Hi ASHWINI,

do you do "setflag(1)" in you script, for the requests?

Regards,
Bogdan

ASHWINI NAIDU wrote:

> hi bogdan,
>
> I donot get any record in DB. I have written below the setting for acc
> made.
>
> # ----- acc params -----
> /* what sepcial events should be accounted ? */
> modparam("acc", "db_url",
> "mysql://opensips:opensipsrw@localhost/opensips")
> 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)
>
>
>
> On Tue, Feb 10, 2009 at 6:27 PM, Bogdan-Andrei Iancu
> <[hidden email] <mailto:[hidden email]>> wrote:
>
>     You mean you do not get any record in DB or only the db_extra
>     values are missing?
>
>     Do you set the acc flag in your script?
>
>     Regards,
>     Bogdan
>
>     ASHWINI NAIDU wrote:
>
>         oops sorry
>
>         modparam("acc", "db_url",
>         "mysql://opensips:opensipsrw@localhost/opensips")
>         modparam("acc", "db_extra",
>         "src_user=$fU;src_domain=$fd;dst_user=$rU;dst_domain=$rd;src_ip=$si")
>
>         this doesn't insert values into acc table.
>
>
>
>         On Tue, Feb 10, 2009 at 6:03 PM, Bogdan-Andrei Iancu
>         <[hidden email] <mailto:[hidden email]>
>         <mailto:[hidden email]
>         <mailto:[hidden email]>>> wrote:
>
>            Hi ASHWINI,
>
>
>            ASHWINI NAIDU wrote:
>
>
>                hi All,
>
>                   Installed opensips-1.4.4 . my acc module is
>         supoorted with
>                mysql. but when i try to insert values into acc table using
>                the below command the acc table is not getting populated.
>
>            What is the below command for insert into acc ?
>
>            Regards,
>            Bogdan
>
>
>
>                --        Thanking You,
>                Ashwini BR Naidu
>              
>          ------------------------------------------------------------------------
>
>                _______________________________________________
>                Users mailing list
>                [hidden email]
>         <mailto:[hidden email]>
>         <mailto:[hidden email]
>         <mailto:[hidden email]>>
>
>                http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>                
>
>
>
>
>         --
>         Thanking You,
>         Ashwini BR Naidu
>
>
>
>
>
> --
> Thanking You,
> Ashwini BR Naidu


_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: acc problem

Bogdan-Andrei Iancu
Then do it, as this will trigger the accounting.

Regards,
Bogdan

ASHWINI NAIDU wrote:

> no i don't setflag(1) for requests or anywhere in the script
>
> On Tue, Feb 10, 2009 at 6:58 PM, Bogdan-Andrei Iancu
> <[hidden email] <mailto:[hidden email]>> wrote:
>
>     Hi ASHWINI,
>
>     do you do "setflag(1)" in you script, for the requests?
>
>
>     Regards,
>     Bogdan
>
>     ASHWINI NAIDU wrote:
>
>         hi bogdan,
>
>         I donot get any record in DB. I have written below the setting
>         for acc made.
>
>         # ----- acc params -----
>         /* what sepcial events should be accounted ? */
>         modparam("acc", "db_url",
>         "mysql://opensips:opensipsrw@localhost/opensips")
>         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)
>
>
>
>         On Tue, Feb 10, 2009 at 6:27 PM, Bogdan-Andrei Iancu
>         <[hidden email] <mailto:[hidden email]>
>         <mailto:[hidden email]
>         <mailto:[hidden email]>>> wrote:
>
>            You mean you do not get any record in DB or only the db_extra
>            values are missing?
>
>            Do you set the acc flag in your script?
>
>            Regards,
>            Bogdan
>
>            ASHWINI NAIDU wrote:
>
>                oops sorry
>
>                modparam("acc", "db_url",
>                "mysql://opensips:opensipsrw@localhost/opensips")
>                modparam("acc", "db_extra",
>              
>          "src_user=$fU;src_domain=$fd;dst_user=$rU;dst_domain=$rd;src_ip=$si")
>
>                this doesn't insert values into acc table.
>
>
>
>                On Tue, Feb 10, 2009 at 6:03 PM, Bogdan-Andrei Iancu
>                <[hidden email] <mailto:[hidden email]>
>         <mailto:[hidden email] <mailto:[hidden email]>>
>                <mailto:[hidden email]
>         <mailto:[hidden email]>
>                <mailto:[hidden email]
>         <mailto:[hidden email]>>>> wrote:
>
>                   Hi ASHWINI,
>
>
>                   ASHWINI NAIDU wrote:
>
>
>                       hi All,
>
>                          Installed opensips-1.4.4 . my acc module is
>                supoorted with
>                       mysql. but when i try to insert values into acc
>         table using
>                       the below command the acc table is not getting
>         populated.
>
>                   What is the below command for insert into acc ?
>
>                   Regards,
>                   Bogdan
>
>
>
>                       --        Thanking You,
>                       Ashwini BR Naidu
>                            
>         ------------------------------------------------------------------------
>
>                       _______________________________________________
>                       Users mailing list
>                       [hidden email]
>         <mailto:[hidden email]>
>                <mailto:[hidden email]
>         <mailto:[hidden email]>>
>                <mailto:[hidden email]
>         <mailto:[hidden email]>
>                <mailto:[hidden email]
>         <mailto:[hidden email]>>>
>
>                      
>         http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>                      
>
>
>
>                --        Thanking You,
>                Ashwini BR Naidu
>
>
>
>
>
>         --
>         Thanking You,
>         Ashwini BR Naidu
>
>
>
>
>
> --
> Thanking You,
> Ashwini BR Naidu


_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: acc problem

ASHWINI NAIDU
Hi Bogdan,

Thank you for the help [:)]

On Tue, Feb 10, 2009 at 7:07 PM, Bogdan-Andrei Iancu <[hidden email]> wrote:
Then do it, as this will trigger the accounting.


Regards,
Bogdan

ASHWINI NAIDU wrote:
no i don't setflag(1) for requests or anywhere in the script

On Tue, Feb 10, 2009 at 6:58 PM, Bogdan-Andrei Iancu <[hidden email] <mailto:[hidden email]>> wrote:

   Hi ASHWINI,

   do you do "setflag(1)" in you script, for the requests?


   Regards,
   Bogdan

   ASHWINI NAIDU wrote:

       hi bogdan,

       I donot get any record in DB. I have written below the setting
       for acc made.

       # ----- acc params -----
       /* what sepcial events should be accounted ? */
       modparam("acc", "db_url",
       "mysql://opensips:opensipsrw@localhost/opensips")
       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)



       On Tue, Feb 10, 2009 at 6:27 PM, Bogdan-Andrei Iancu
       <[hidden email] <mailto:[hidden email]>
       <mailto:[hidden email]
       <mailto:[hidden email]>>> wrote:

          You mean you do not get any record in DB or only the db_extra
          values are missing?

          Do you set the acc flag in your script?

          Regards,
          Bogdan

          ASHWINI NAIDU wrote:

              oops sorry

              modparam("acc", "db_url",
              "mysql://opensips:opensipsrw@localhost/opensips")
              modparam("acc", "db_extra",
                    "src_user=$fU;src_domain=$fd;dst_user=$rU;dst_domain=$rd;src_ip=$si")

              this doesn't insert values into acc table.



              On Tue, Feb 10, 2009 at 6:03 PM, Bogdan-Andrei Iancu
              <[hidden email] <mailto:[hidden email]>
       <mailto:[hidden email] <mailto:[hidden email]>>
              <mailto:[hidden email]
       <mailto:[hidden email]>
              <mailto:[hidden email]
       <mailto:[hidden email]>>>> wrote:

                 Hi ASHWINI,


                 ASHWINI NAIDU wrote:


                     hi All,

                        Installed opensips-1.4.4 . my acc module is
              supoorted with
                     mysql. but when i try to insert values into acc
       table using
                     the below command the acc table is not getting
       populated.

                 What is the below command for insert into acc ?

                 Regards,
                 Bogdan



                     --        Thanking You,
                     Ashwini BR Naidu
                                 ------------------------------------------------------------------------

                     _______________________________________________
                     Users mailing list
                     [hidden email]
       <mailto:[hidden email]>
              <mailto:[hidden email]
       <mailto:[hidden email]>>
              <mailto:[hidden email]
       <mailto:[hidden email]>
              <mailto:[hidden email]
       <mailto:[hidden email]>>>

                           http://lists.opensips.org/cgi-bin/mailman/listinfo/users
                   


              --        Thanking You,
              Ashwini BR Naidu





       --        Thanking You,
       Ashwini BR Naidu





--
Thanking You,
Ashwini BR Naidu




--
Thanking You,
Ashwini BR Naidu

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users