Hi guys! It looks like I have not compiled the acc module with database support. Can somebody confirm this? How can I do this? If I insert these rows :
modparam("acc", "db_flag", 1) modparam("acc", "db_missed_flag", 1)
this is the error:
0(29943) set_mod_param_regex: parameter <db_flag> not found in module <acc> 0(29943) parse error (87,29-30): Can't set module parameter 0(29943) set_mod_param_regex: parameter <db_missed_flag> not found in module <acc> 0(29943) parse error (88,36-37): Can't set module parameter ERROR: bad config file (2 errors)
Normaly it is ok. And it doesn't work?
Szabolcs Szasz a écrit :
OK. Then, how can I define the acc module's parameter to register calls into the database? Now I have:
modparam("acc", "log_level", 1) modparam("acc", "log_flag", 1 )
at the module parameters
and
setflag(1);
What have I to do?
but you can have more as one accounting. You're flag numbre must be the same as the number defined at the beggining (module's paramters)
Szabolcs Szasz a écrit :
Yes, I do. I consider that this line of log is caused by the "setflag()" command : (ACC: transaction answered: method=INVITE,), or not???
Do you use the command "setflag()" ?
Szabolcs Szasz a écrit :
Hello
I have installed SER on my redhat box. I have a problem with ser-mysql accounting. In the log is apearing the acc information, but it doesn't write into the mysql database? It looks like this when I make a call from 506029 to 506030 :
0(24195) ------------------------------------------- 0(24195) entering route[1] - relaying SIP message 0(24195) relaying message ... 0(24195) ACC: transaction answered: method=INVITE, i-uri=sip:506030@10.1.10.10:5060;user=phone, o-uri=sip:506030@10.1.10.105:5060, call_id=58dcd4-a010a68-13c4-119d-44d0f9-247@10.1.10.10, from=sip:506029@10.1.10.10 ;tag=a010a68-13c4-119d-44d0f9-3b9d, code=200 0(24195) ------------------------------------------- 0(24195) entering main loop 0(24195) ACK message received 0(24195) ------------------------------------------- 0(24195) entering route[1] - relaying SIP message 0(24195) relaying message ... 0(24195) ACC: request acknowledged: method=ACK, i-uri=sip:506030@10.1.10.105:5060, o-uri=sip:506030@10.1.10.105:5060, call_id=58dcd4-a010a68-13c4-119d-44d0f9-247@10.1.10.10, from=sip:506029@10.1.10.10 ;tag=a010a68-13c4-119d-44d0f9-3b9d, code=200 0(24195) ------------------------------------------- 0(24195) entering main loop 0(24195) BYE message received 0(24195) ------------------------------------------- 0(24195) entering route[1] - relaying SIP message 0(24195) relaying message ... 0(24195) ACC: transaction answered: method=BYE, i-uri=sip:506029@10.1.10.104:5060, o-uri=sip:506029@10.1.10.104:5060, call_id=58dcd4-a010a68-13c4-119d-44d0f9-247@10.1.10.10, from=sip:506030@10.1.10.10:5060;user=phone ;tag=a010a69-13c4-11a0-44dbd5-740c, code=200
Can anyone help me ?
Thanks Szabolcs
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
Szabolcs Szasz CCNA Network Engineer
Digi Communication SRL H2/3 Petofi Sandor St. Sovata, Mures, Romania Tel/ Fax: +40 265 577888 +40 265 577785 +40 365 506000 sszasz@digicomm.ro www.digicomm.ro _____________________________
Szabolcs Szasz CCNA Network Engineer
Digi Communication SRL H2/3 Petofi Sandor St. Sovata, Mures, Romania Tel/ Fax: +40 265 577888 +40 265 577785 +40 365 506000 sszasz@digicomm.ro www.digicomm.ro _____________________________
_____________________________ Szabolcs Szasz CCNA Network Engineer
Digi Communication SRL H2/3 Petofi Sandor St. Sovata, Mures, Romania Tel/ Fax: +40 265 577888 +40 265 577785 +40 365 506000 sszasz@digicomm.ro www.digicomm.ro _____________________________
vi modules/acc/Makefile
see if u have commented out the Mysql lines, and commented the radius line
Iqbal
Szabolcs Szasz wrote:
Hi guys! It looks like I have not compiled the acc module with database support. Can somebody confirm this? How can I do this? If I insert these rows :
modparam("acc", "db_flag", 1) modparam("acc", "db_missed_flag", 1)
this is the error:
0(29943) set_mod_param_regex: parameter <db_flag> not found in module <acc> 0(29943) parse error (87,29-30): Can't set module parameter 0(29943) set_mod_param_regex: parameter <db_missed_flag> not found in module <acc> 0(29943) parse error (88,36-37): Can't set module parameter ERROR: bad config file (2 errors)
Normaly it is ok. And it doesn't work?
Szabolcs Szasz a écrit :
OK. Then, how can I define the acc module's parameter to register calls into the database? Now I have:
modparam("acc", "log_level", 1) modparam("acc", "log_flag", 1 )
at the module parameters
and
setflag(1);
What have I to do?
but you can have more as one accounting. You're flag numbre must be the same as the number defined at the beggining (module's paramters)
Szabolcs Szasz a écrit :
Yes, I do. I consider that this line of log is caused by the "setflag()" command : (ACC: transaction answered: method=INVITE,), or not???
Do you use the command "setflag()" ?
Szabolcs Szasz a écrit :
>Hello > >I have installed SER on my redhat box. I have a problem with >ser-mysql >accounting. In the log is apearing the acc information, but it >doesn't >write into the mysql database? It looks like this when I make a call >from >506029 to 506030 : > >0(24195) ------------------------------------------- >0(24195) entering route[1] - relaying SIP message >0(24195) relaying message ... >0(24195) ACC: transaction answered: method=INVITE, >i-uri=sip:506030@10.1.10.10:5060;user=phone, >o-uri=sip:506030@10.1.10.105:5060, >call_id=58dcd4-a010a68-13c4-119d-44d0f9-247@10.1.10.10, >from=sip:506029@10.1.10.10 ;tag=a010a68-13c4-119d-44d0f9-3b9d, >code=200 >0(24195) ------------------------------------------- >0(24195) entering main loop >0(24195) ACK message received >0(24195) ------------------------------------------- >0(24195) entering route[1] - relaying SIP message >0(24195) relaying message ... >0(24195) ACC: request acknowledged: method=ACK, >i-uri=sip:506030@10.1.10.105:5060, o-uri=sip:506030@10.1.10.105:5060, >call_id=58dcd4-a010a68-13c4-119d-44d0f9-247@10.1.10.10, >from=sip:506029@10.1.10.10 ;tag=a010a68-13c4-119d-44d0f9-3b9d, >code=200 >0(24195) ------------------------------------------- >0(24195) entering main loop >0(24195) BYE message received >0(24195) ------------------------------------------- >0(24195) entering route[1] - relaying SIP message >0(24195) relaying message ... >0(24195) ACC: transaction answered: method=BYE, >i-uri=sip:506029@10.1.10.104:5060, o-uri=sip:506029@10.1.10.104:5060, >call_id=58dcd4-a010a68-13c4-119d-44d0f9-247@10.1.10.10, >from=sip:506030@10.1.10.10:5060;user=phone >;tag=a010a69-13c4-11a0-44dbd5-740c, code=200 > >Can anyone help me ? > >Thanks >Szabolcs > > > > > >_______________________________________________ >Serusers mailing list >serusers@lists.iptel.org >http://lists.iptel.org/mailman/listinfo/serusers > > >
Szabolcs Szasz CCNA Network Engineer
Digi Communication SRL H2/3 Petofi Sandor St. Sovata, Mures, Romania Tel/ Fax: +40 265 577888 +40 265 577785 +40 365 506000 sszasz@digicomm.ro www.digicomm.ro _____________________________
Szabolcs Szasz CCNA Network Engineer
Digi Communication SRL H2/3 Petofi Sandor St. Sovata, Mures, Romania Tel/ Fax: +40 265 577888 +40 265 577785 +40 365 506000 sszasz@digicomm.ro www.digicomm.ro _____________________________
Szabolcs Szasz CCNA Network Engineer
Digi Communication SRL H2/3 Petofi Sandor St. Sovata, Mures, Romania Tel/ Fax: +40 265 577888 +40 265 577785 +40 365 506000 sszasz@digicomm.ro www.digicomm.ro _____________________________
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
.
Szabolcs,
You're correct in at MySQL support is not compiled by default. You need to edit <ser-sources>/modules/acc/Makefile and uncomment the MYSQL line. Then just do another "make" and it should work.
With the modparam() settings you have all you need to do is setflag(1) before calling t_relay() and the message will be written to the acc table in MySQL.
I'd recommend getting a copy of the Getting Started document on http://onsip.org/ because it fully documents MySQL support.
Regards, Paul
On 6/28/05, Szabolcs Szasz sszasz@digicomm.ro wrote:
Hi guys! It looks like I have not compiled the acc module with database support. Can somebody confirm this? How can I do this? If I insert these rows :
modparam("acc", "db_flag", 1) modparam("acc", "db_missed_flag", 1)
this is the error:
0(29943) set_mod_param_regex: parameter <db_flag> not found in module
<acc> 0(29943) parse error (87,29-30): Can't set module parameter 0(29943) set_mod_param_regex: parameter <db_missed_flag> not found in module <acc> 0(29943) parse error (88,36-37): Can't set module parameter ERROR: bad config file (2 errors)
Normaly it is ok. And it doesn't work?
Szabolcs Szasz a écrit :
OK. Then, how can I define the acc module's parameter to register calls into the database? Now I have:
modparam("acc", "log_level", 1) modparam("acc", "log_flag", 1 )
at the module parameters
and
setflag(1);
What have I to do?
but you can have more as one accounting. You're flag numbre must be the same as the number defined at the beggining (module's paramters)
Szabolcs Szasz a écrit :
Yes, I do. I consider that this line of log is caused by the "setflag()" command : (ACC: transaction answered: method=INVITE,), or not???
Do you use the command "setflag()" ?
Szabolcs Szasz a écrit :
>Hello > >I have installed SER on my redhat box. I have a problem with > ser-mysql >accounting. In the log is apearing the acc information, but it > doesn't >write into the mysql database? It looks like this when I make a call >from >506029 to 506030 : > >0(24195) ------------------------------------------- >0(24195) entering route[1] - relaying SIP message >0(24195) relaying message ... >0(24195) ACC: transaction answered: method=INVITE, >i-uri=sip:506030@10.1.10.10:5060;user=phone, >o-uri=sip:506030@10.1.10.105:5060, >call_id=58dcd4-a010a68-13c4-119d-44d0f9-247@10.1.10.10, >from=sip:506029@10.1.10.10 ;tag=a010a68-13c4-119d-44d0f9-3b9d, >code=200 >0(24195) ------------------------------------------- >0(24195) entering main loop >0(24195) ACK message received >0(24195) ------------------------------------------- >0(24195) entering route[1] - relaying SIP message >0(24195) relaying message ... >0(24195) ACC: request acknowledged: method=ACK, >i-uri=sip:506030@10.1.10.105:5060, o-uri=sip:506030@10.1.10.105
:5060,
>call_id=58dcd4-a010a68-13c4-119d-44d0f9-247@10.1.10.10, >from=sip:506029@10.1.10.10 ;tag=a010a68-13c4-119d-44d0f9-3b9d, >code=200 >0(24195) ------------------------------------------- >0(24195) entering main loop >0(24195) BYE message received >0(24195) ------------------------------------------- >0(24195) entering route[1] - relaying SIP message >0(24195) relaying message ... >0(24195) ACC: transaction answered: method=BYE, >i-uri=sip:506029@10.1.10.104:5060, o-uri=sip:506029@10.1.10.104
:5060,
>call_id=58dcd4-a010a68-13c4-119d-44d0f9-247@10.1.10.10, >from=sip:506030@10.1.10.10:5060;user=phone >;tag=a010a69-13c4-11a0-44dbd5-740c, code=200 > >Can anyone help me ? > >Thanks >Szabolcs > > > > > >_______________________________________________ >Serusers mailing list >serusers@lists.iptel.org >http://lists.iptel.org/mailman/listinfo/serusers >
Szabolcs Szasz CCNA Network Engineer
Digi Communication SRL H2/3 Petofi Sandor St. Sovata, Mures, Romania Tel/ Fax: +40 265 577888 +40 265 577785 +40 365 506000 sszasz@digicomm.ro www.digicomm.ro http://www.digicomm.ro _____________________________
Szabolcs Szasz CCNA Network Engineer
Digi Communication SRL H2/3 Petofi Sandor St. Sovata, Mures, Romania Tel/ Fax: +40 265 577888 +40 265 577785 +40 365 506000 sszasz@digicomm.ro www.digicomm.ro http://www.digicomm.ro _____________________________
Szabolcs Szasz CCNA Network Engineer
Digi Communication SRL H2/3 Petofi Sandor St. Sovata, Mures, Romania Tel/ Fax: +40 265 577888 +40 265 577785 +40 365 506000 sszasz@digicomm.ro www.digicomm.ro http://www.digicomm.ro _____________________________
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
take a look at the MAkefile of the acc module
regards, klaus
Szabolcs Szasz wrote:
Hi guys! It looks like I have not compiled the acc module with database support. Can somebody confirm this? How can I do this? If I insert these rows :
modparam("acc", "db_flag", 1) modparam("acc", "db_missed_flag", 1)
this is the error:
0(29943) set_mod_param_regex: parameter <db_flag> not found in module <acc> 0(29943) parse error (87,29-30): Can't set module parameter 0(29943) set_mod_param_regex: parameter <db_missed_flag> not found in module <acc> 0(29943) parse error (88,36-37): Can't set module parameter ERROR: bad config file (2 errors)
Normaly it is ok. And it doesn't work?
Szabolcs Szasz a écrit :
OK. Then, how can I define the acc module's parameter to register calls into the database? Now I have:
modparam("acc", "log_level", 1) modparam("acc", "log_flag", 1 )
at the module parameters
and
setflag(1);
What have I to do?
but you can have more as one accounting. You're flag numbre must be the same as the number defined at the beggining (module's paramters)
Szabolcs Szasz a écrit :
Yes, I do. I consider that this line of log is caused by the "setflag()" command : (ACC: transaction answered: method=INVITE,), or not???
Do you use the command "setflag()" ?
Szabolcs Szasz a écrit :
>Hello > >I have installed SER on my redhat box. I have a problem with >ser-mysql >accounting. In the log is apearing the acc information, but it >doesn't >write into the mysql database? It looks like this when I make a call >from >506029 to 506030 : > >0(24195) ------------------------------------------- >0(24195) entering route[1] - relaying SIP message >0(24195) relaying message ... >0(24195) ACC: transaction answered: method=INVITE, >i-uri=sip:506030@10.1.10.10:5060;user=phone, >o-uri=sip:506030@10.1.10.105:5060, >call_id=58dcd4-a010a68-13c4-119d-44d0f9-247@10.1.10.10, >from=sip:506029@10.1.10.10 ;tag=a010a68-13c4-119d-44d0f9-3b9d, >code=200 >0(24195) ------------------------------------------- >0(24195) entering main loop >0(24195) ACK message received >0(24195) ------------------------------------------- >0(24195) entering route[1] - relaying SIP message >0(24195) relaying message ... >0(24195) ACC: request acknowledged: method=ACK, >i-uri=sip:506030@10.1.10.105:5060, o-uri=sip:506030@10.1.10.105:5060, >call_id=58dcd4-a010a68-13c4-119d-44d0f9-247@10.1.10.10, >from=sip:506029@10.1.10.10 ;tag=a010a68-13c4-119d-44d0f9-3b9d, >code=200 >0(24195) ------------------------------------------- >0(24195) entering main loop >0(24195) BYE message received >0(24195) ------------------------------------------- >0(24195) entering route[1] - relaying SIP message >0(24195) relaying message ... >0(24195) ACC: transaction answered: method=BYE, >i-uri=sip:506029@10.1.10.104:5060, o-uri=sip:506029@10.1.10.104:5060, >call_id=58dcd4-a010a68-13c4-119d-44d0f9-247@10.1.10.10, >from=sip:506030@10.1.10.10:5060;user=phone >;tag=a010a69-13c4-11a0-44dbd5-740c, code=200 > >Can anyone help me ? > >Thanks >Szabolcs > > > > > >_______________________________________________ >Serusers mailing list >serusers@lists.iptel.org >http://lists.iptel.org/mailman/listinfo/serusers >
Szabolcs Szasz CCNA Network Engineer
Digi Communication SRL H2/3 Petofi Sandor St. Sovata, Mures, Romania Tel/ Fax: +40 265 577888 +40 265 577785 +40 365 506000 sszasz@digicomm.ro www.digicomm.ro _____________________________
Szabolcs Szasz CCNA Network Engineer
Digi Communication SRL H2/3 Petofi Sandor St. Sovata, Mures, Romania Tel/ Fax: +40 265 577888 +40 265 577785 +40 365 506000 sszasz@digicomm.ro www.digicomm.ro _____________________________
Szabolcs Szasz CCNA Network Engineer
Digi Communication SRL H2/3 Petofi Sandor St. Sovata, Mures, Romania Tel/ Fax: +40 265 577888 +40 265 577785 +40 365 506000 sszasz@digicomm.ro www.digicomm.ro _____________________________
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
Klaus,
You may find that even after you have uncommented the mysql lines in makefile, it still does not compile...
you need to use:
make modules include_modules="mysql"
make install include_modules="mysql"
mysql module is not compiled/installed by default because it depends on an external library (libmysqlclient)
- Daryl
On 6/28/05, Klaus Darilion klaus.mailinglists@pernau.at wrote:
take a look at the MAkefile of the acc module
regards, klaus
Szabolcs Szasz wrote:
Hi guys! It looks like I have not compiled the acc module with database support. Can somebody confirm this? How can I do this? If I insert these rows :
modparam("acc", "db_flag", 1) modparam("acc", "db_missed_flag", 1)
this is the error:
0(29943) set_mod_param_regex: parameter <db_flag> not found in module <acc> 0(29943) parse error (87,29-30): Can't set module parameter 0(29943) set_mod_param_regex: parameter <db_missed_flag> not found in module <acc> 0(29943) parse error (88,36-37): Can't set module parameter ERROR: bad config file (2 errors)
Normaly it is ok. And it doesn't work?
Szabolcs Szasz a écrit :
OK. Then, how can I define the acc module's parameter to register calls into the database? Now I have:
modparam("acc", "log_level", 1) modparam("acc", "log_flag", 1 )
at the module parameters
and
setflag(1);
What have I to do?
but you can have more as one accounting. You're flag numbre must be the same as the number defined at the beggining (module's paramters)
Szabolcs Szasz a écrit :
Yes, I do. I consider that this line of log is caused by the "setflag()" command : (ACC: transaction answered: method=INVITE,), or not???
>Do you use the command "setflag()" ? > >Szabolcs Szasz a écrit : > > > >>Hello >> >>I have installed SER on my redhat box. I have a problem with >>ser-mysql >>accounting. In the log is apearing the acc information, but it >>doesn't >>write into the mysql database? It looks like this when I make a call >>from >>506029 to 506030 : >> >>0(24195) ------------------------------------------- >>0(24195) entering route[1] - relaying SIP message >>0(24195) relaying message ... >>0(24195) ACC: transaction answered: method=INVITE, >>i-uri=sip:506030@10.1.10.10:5060;user=phone, >>o-uri=sip:506030@10.1.10.105:5060, >>call_id=58dcd4-a010a68-13c4-119d-44d0f9-247@10.1.10.10, >>from=sip:506029@10.1.10.10 ;tag=a010a68-13c4-119d-44d0f9-3b9d, >>code=200 >>0(24195) ------------------------------------------- >>0(24195) entering main loop >>0(24195) ACK message received >>0(24195) ------------------------------------------- >>0(24195) entering route[1] - relaying SIP message >>0(24195) relaying message ... >>0(24195) ACC: request acknowledged: method=ACK, >>i-uri=sip:506030@10.1.10.105:5060, o-uri=sip:506030@10.1.10.105:5060, >>call_id=58dcd4-a010a68-13c4-119d-44d0f9-247@10.1.10.10, >>from=sip:506029@10.1.10.10 ;tag=a010a68-13c4-119d-44d0f9-3b9d, >>code=200 >>0(24195) ------------------------------------------- >>0(24195) entering main loop >>0(24195) BYE message received >>0(24195) ------------------------------------------- >>0(24195) entering route[1] - relaying SIP message >>0(24195) relaying message ... >>0(24195) ACC: transaction answered: method=BYE, >>i-uri=sip:506029@10.1.10.104:5060, o-uri=sip:506029@10.1.10.104:5060, >>call_id=58dcd4-a010a68-13c4-119d-44d0f9-247@10.1.10.10, >>from=sip:506030@10.1.10.10:5060;user=phone >>;tag=a010a69-13c4-11a0-44dbd5-740c, code=200 >> >>Can anyone help me ? >> >>Thanks >>Szabolcs >> >> >> >> >> >>_______________________________________________ >>Serusers mailing list >>serusers@lists.iptel.org >>http://lists.iptel.org/mailman/listinfo/serusers >> > _____________________________ Szabolcs Szasz CCNA Network Engineer
Digi Communication SRL H2/3 Petofi Sandor St. Sovata, Mures, Romania Tel/ Fax: +40 265 577888 +40 265 577785 +40 365 506000 sszasz@digicomm.ro www.digicomm.ro _____________________________
Szabolcs Szasz CCNA Network Engineer
Digi Communication SRL H2/3 Petofi Sandor St. Sovata, Mures, Romania Tel/ Fax: +40 265 577888 +40 265 577785 +40 365 506000 sszasz@digicomm.ro www.digicomm.ro _____________________________
Szabolcs Szasz CCNA Network Engineer
Digi Communication SRL H2/3 Petofi Sandor St. Sovata, Mures, Romania Tel/ Fax: +40 265 577888 +40 265 577785 +40 365 506000 sszasz@digicomm.ro www.digicomm.ro _____________________________
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers
-
Daryl Sanders -
Iqbal -
Java Rockx -
Klaus Darilion -
Szabolcs Szasz