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 = "mediapr...@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-00c09f9a2...@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-00c09f9a2...@command1",User-Name =
"mediapr...@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 =
"mediapr...@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: 'mediapr...@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-00c09f9a2...@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-00c09f9a2...@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 <[email protected]>:
>>>
>>> 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
>> <[email protected]>
>>
>> _______________________________________________
>> Users mailing list
>> [email protected]
>> 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.
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
