[OpenSIPS-Users] Rating Engine Problem

[john99]

Hi,

Im having a similar issue, and could use some help. 
MySQL error: 1146 (Table 'radius.radacct200903' doesn't exist) 63Session
halted. 
i dont have a 200903 table

On INSERT the monthly table is created automatically when necessary.  

when i complete a call, radiius_xlat is calling "CALL
update_raddact_record_mediaproxy"
it is not calling the INSERT first.  So no tables are being created.   I
think this has something to do with the data opensips
is sending to radius but thats why im asking for help.

any and all help is greatly needed and appreciated.  thanks.

hers is my radius -X readout

Listening on authentication *:1812
Listening on accounting *:1813
Ready to process requests.
rad_recv: Accounting-Request packet from host 192.168.0.105:37715, id=178,
length=230
	User-Name = "mediaproxy at default"
	Acct-Output-Octets = 0
	NAS-IP-Address = 192.168.0.106
	Sip-To-Tag = "as3676c243"
	Media-Codecs = "Unknown, GSM"
	Media-Info = ""
	Sip-User-Agents = "Ekiga/2.0.12+Asterisk PBX"
	Sip-Applications = "audio, video"
	Acct-Session-Time = 50
	Acct-Session-Id = "dc83c947-2511-de11-9903-00c09f9a2b32 at command1"
	Acct-Status-Type = Update
	Sip-From-Tag = "5489c947-2511-de11-9903-00c09f9a2b32"
	Acct-Delay-Time = 3
	Acct-Input-Octets = 0
  Processing the preacct section of radiusd.conf
modcall: entering group preacct for request 0
  modcall[preacct]: module "preprocess" returns noop for request 0
rlm_acct_unique: WARNING: Attribute NAS-Port was not found in request,
unique ID MAY be inconsistent
rlm_acct_unique: Hashing ',Client-IP-Address = 192.168.0.105,NAS-IP-Address
= 192.168.0.106,Acct-Session-Id =
"dc83c947-2511-de11-9903-00c09f9a2b32 at command1",User-Name =
"mediaproxy at default"'
rlm_acct_unique: Acct-Unique-Session-ID = "f105ba032e958c94".
  modcall[preacct]: module "acct_unique" returns ok for request 0
    rlm_realm: Looking up realm "default" for User-Name =
"mediaproxy at default"
    rlm_realm: No such realm "default"
  modcall[preacct]: module "suffix" returns noop for request 0
  modcall[preacct]: module "files" returns noop for request 0
modcall: leaving group preacct (returns ok) for request 0
  Processing the accounting section of radiusd.conf
modcall: entering group accounting for request 0
radius_xlat: 
'/usr/local/var/log/radius/radacct/192.168.0.105/detail-20090316'
rlm_detail:
/usr/local/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d expands
to /usr/local/var/log/radius/radacct/192.168.0.105/detail-20090316
  modcall[accounting]: module "detail" returns ok for request 0
  modcall[accounting]: module "unix" returns noop for request 0
radius_xlat:  '/usr/local/var/log/radius/radutmp'
radius_xlat:  'mediaproxy at default'
  rlm_radutmp: No NAS-Port seen.  Cannot do anything.
  rlm_radumtp: WARNING: checkrad will probably not work!
  modcall[accounting]: module "radutmp" returns noop for request 0
radius_xlat:  '          CALL update_raddact_record_mediaproxy(                
'radius',                 '50',                 '0',                 '0',                
'Ekiga/2.0.12=2BAsterisk PBX',                 'Unknown=2C GSM',                
'audio=2C video',                 '',                 '0',                
'dc83c947-2511-de11-9903-00c09f9a2b32 at command1',                
'as3676c243',                 '5489c947-2511-de11-9903-00c09f9a2b32'                
)'
radius_xlat:  '/usr/local/var/log/radius/sqltrace-20090316.log'
rlm_sql (sql): Reserving sql socket id: 24
rlm_sql_mysql: query:            CALL update_raddact_record_mediaproxy(                
'radius',                 '50',                 '0',                 '0',                
'Ekiga/2.0.12=2BAsterisk PBX',                 'Unknown=2C GSM',                
'audio=2C video',                 '',                 '0',                
'dc83c947-2511-de11-9903-00c09f9a2b32 at command1',                
'as3676c243',                 '5489c947-2511-de11-9903-00c09f9a2b32'                
)
radius_xlat:  ''
radius_xlat:  '/usr/local/var/log/radius/sqltrace-20090316.log'
rlm_sql (sql): Released sql socket id: 24
  modcall[accounting]: module "sql" returns ok for request 0
modcall: leaving group accounting (returns ok) for request 0
Sending Accounting-Response of id 178 to 192.168.0.105 port 37715
Finished request 0
Going to the next request
--- Walking the entire request list ---
Waking up in 6 seconds...
--- Walking the entire request list ---
Cleaning up request 0 ID 178 with timestamp 49be730a
Nothing to do.  Sleeping until we see a request.




bay2x1 wrote:
> 
> Thanx for your help. I really appreciate it.  I will do what you told
> me... re-read the rating.txt many many times. In regards to my rating,
> destination, profiles, customers settings any suggestion on what seems to
> be misconfigured or any other documentation that discusses this subject. 
> I know that this matter is  discussed on the rating.txt.
> 
> Iñaki Baz Castillo wrote:
>> 
>> 2009/2/26 bay2x1 <rod at racequeen.ph>:
>>>
>>> I apologize for reposting my topic. Well, I have check it and its now
>>> working
>>> fine, the username in the radacct table is no longer empty.  However,
>>> the
>>> rating engine is still not computing for the cost of call.
>> 
>> Read and re-read the rating.txt file. It's hard to understand in a
>> single reading :)
>> Your profile, rating...  tables are not well configured (the most
>> probable reason).
>> 
>> -- 
>> Iñaki Baz Castillo
>> <ibc at aliax.net>
>> 
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>> 
>> 
> 
> 

-- 
View this message in context: http://n2.nabble.com/Rating-Engine-Problem-tp2375313p2489850.html
Sent from the OpenSIPS - Users mailing list archive at Nabble.com.