(RADIATOR) Stumpted on SQL accounting logs.

Hugh Irvine hugh at open.com.au
Sat Mar 6 01:08:10 CST 2004


Hello Jason -

I don't quite understand what you are trying to do in your script, but 
why don't you have Radiator just write into the SQL database directly?

Its a very simple AuthBy SQL setup, and there is an example in 
"goodies/sql.cfg".

regards

Hugh


On 6 Mar 2004, at 04:56, Jason Godsey wrote:

> Starting with the default,
> AcctColumnDef	 USERNAME,User-Name
>
> We currently dump accounting into daily text detail files, and 
> post-process them  into an SQL server to run billing scripts.
>
> The one thing that my perl scripts do, and that I'm having dificulting 
> figuring out is storing the account#, not User-Name in the SQL table.
>
> My perl script simply makes a hash $un2uid{"jason"}=100492; (populated 
> by a single query off the users table in SQL).
>
> After this, I simply ($user)=(/User-Name = "([^"]+)/);
> $user=$un2uid{$user};
>
> So, what I'm stumped on is how to obtain the field i_account_id from 
> my user table, and then use it in the accounting fields.
>
> Thank you in advance.
>
> --
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.
>
>

NB: have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.

--
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.


More information about the radiator mailing list