Re: If SQL not available during startup, then it not available all the time
Hello !
Sun Apr 23 10:08:22 2006 : Error: rlm_sql (pgsql-voip): Failed to connect DB handle #0 Sun Apr 23 10:08:22 2006 : Debug: rlm_sql (pgsql-voip): starting 1 Sun Apr 23 10:08:22 2006 : Debug: rlm_sql (pgsql-voip): starting 2 Sun Apr 23 10:08:22 2006 : Debug: rlm_sql (pgsql-voip): starting 3 Sun Apr 23 10:08:22 2006 : Debug: rlm_sql (pgsql-voip): starting 4 Sun Apr 23 10:08:22 2006 : Debug: rlm_sql (pgsql-voip): Failed to
connect to any SQL server.
Sun Apr 23 10:08:22 2006 : Debug: Module: Instantiated sql (pgsql-voip)
then it will not available all the time until we reload FreeRADIUS daemon -
it not ever try to reconnect:
Sun Apr 23 10:17:51 2006 : Debug: radius_xlat: 'INSERT into
radoriginate (RadiusServerName, UserName, NASIPAddress, AcctStartTime, AcctStopTime, Cal
Sun Apr 23 10:17:51 2006 : Debug: rlm_sql (pgsql-voip): Ignoring unconnected handle 4.. Sun Apr 23 10:17:51 2006 : Debug: rlm_sql (pgsql-voip): Ignoring unconnected handle 3.. Sun Apr 23 10:17:51 2006 : Debug: rlm_sql (pgsql-voip): Ignoring unconnected handle 2.. Sun Apr 23 10:17:51 2006 : Debug: rlm_sql (pgsql-voip): Ignoring unconnected handle 1.. Sun Apr 23 10:17:51 2006 : Debug: rlm_sql (pgsql-voip): Ignoring unconnected handle 0.. Sun Apr 23 10:17:51 2006 : Info: rlm_sql (pgsql-voip): There are no DB handles to use! skipped 5, tried to connect 0
Why FreeRADIUS do not try to reconnect during sql command must be proceeded ? Is it possible to fix via configuration parameter or its hard-coded bug ?
P.S. I had maid perl-script to recover radius cdrs into DB from standard FreeRADIUS detail-* files. If any interesting in it, I'll public it on the web.
Please help to resolve this bug...
I would be interested, however there is already a perl script that does exactly that called h323detail2db.pl in src/billing/ It is specific to Cisco h323 VSA records and my pqsl-voip schema but it can be trivially changed to work with "standard" records. If you give me a look at your script, maybe we can combine our work.
http://www.onlinebilling.ru/freeradius/rad-details/radvoiplogs2db.pl I think this is much pretty script - it's easy to configure to different scheme. It's only have no any preparations for open Cisco-AVPair since my FR parse all needed attributes self, but it can be easily done... -- Ruslan A Dautkhanov
I would be interested, however there is already a perl script that does exactly that called h323detail2db.pl in src/billing/ It is specific to Cisco h323 VSA records and my pqsl-voip schema but it can be trivially changed to work with "standard" records. If you give me a look at your script, maybe we can combine our work.
http://www.onlinebilling.ru/freeradius/rad-details/radvoiplogs2db.pl
I think this is much pretty script - it's easy to configure to different scheme.
It's only have no any preparations for open Cisco-AVPair since my FR parse all needed attributes self, but it can be easily done...
What is the copyright on this code? I like the way you have done it, and would like to use some of it in h323detail2db.pl Regards -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc
Hello ! Peter Nixon wrote:
I would be interested, however there is already a perl script that does exactly that called h323detail2db.pl in src/billing/ It is specific to Cisco h323 VSA records and my pqsl-voip schema but it can be trivially changed to work with "standard" records. If you give me a look at your script, maybe we can combine our work.
http://www.onlinebilling.ru/freeradius/rad-details/radvoiplogs2db.pl
I think this is much pretty script - it's easy to configure to different scheme.
It's only have no any preparations for open Cisco-AVPair since my FR parse all needed attributes self, but it can be easily done...
What is the copyright on this code?
Just string "Ruslan A Dautkhanov <ruslan@onlinebilling.ru>" with your remarks possible... I love open source... ;)
I like the way you have done it, and would like to use some of it in h323detail2db.pl
I like that it helps. -- Ruslan A Dautkhanov
On Thu 08 Jun 2006 13:03, Ruslan A Dautkhanov wrote:
Hello !
Peter Nixon wrote:
I would be interested, however there is already a perl script that does exactly that called h323detail2db.pl in src/billing/ It is specific to Cisco h323 VSA records and my pqsl-voip schema but it can be trivially changed to work with "standard" records. If you give me a look at your script, maybe we can combine our work.
http://www.onlinebilling.ru/freeradius/rad-details/radvoiplogs2db.pl
I think this is much pretty script - it's easy to configure to different scheme.
It's only have no any preparations for open Cisco-AVPair since my FR parse all needed attributes self, but it can be easily done...
What is the copyright on this code?
Just string "Ruslan A Dautkhanov <ruslan@onlinebilling.ru>" with your remarks possible... I love open source... ;)
I like the way you have done it, and would like to use some of it in h323detail2db.pl
I like that it helps.
Thanks. I like the look of your code, as you say it is pretty, however it is lacking many of the features of h323detail2db.pl I am working on a new script now which is for generic radius detail records (not cisco h323 records). It is in a working state now, but I need to clean it up a bit before I add it into cvs. Cheers -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc
participants (2)
-
Peter Nixon -
Ruslan A Dautkhanov