(RADIATOR) Re: Executing SQL statement according to another SQL statement from diffrent database

[Hugh Irvine]

Hello Bulent -

You will probably need to use a hook to do this.

See the example hooks in "goodies/hooks.txt".

regards

Hugh


On 30 Apr 2004, at 22:24, Bulent Gulcan wrote:

> Hello All,
>
> We are using radiator and MSSQL database for authentication and 
> accounting.
>
> We are trying to update one column in CUSTOMER table of SUBBCRIBER 
> database,
> if an entry exist in ACCT table of ACCOUNTING database.
> In other words :
> IF exist (or not exist) ..... in ACCT table in ACCOUNTING database THEN
> update column A in CUSTOMER table in SUBSCRIBER database.
>
> As I read from radiator documentation, we can connect only one 
> database and
> make sql queries in one <AuthBy SQL>....</AuthBy> clause.
>
> Can we use the result of a SQL query from a database for other sql 
> queries
> from another database ?
>
> Thanks for your help.
> Regards
>
> Bulent Gulcan
> Is Net A.S.
>
>

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.