[RADIATOR] Connecting to Oracle DB on non default port

[Heikki Vatiainen]

On 01/07/2014 01:59 PM, Hartmaier Alexander wrote:

>>     The Oracle InstantClient configuration is in tnsnames.ora, there
>>     you specify things like hostnames, ports and other settings. In
>>     Radiator you only use the name you gave the connection in
>>     tnsnames.ora.
>>
> 
> The DBD::Oracle docs show you the possible ways to connect:
> https://metacpan.org/pod/DBD::Oracle#connect
> 
> Normally you'd specify the database name you've defined in tnsnames.ora:
> 
> DBSource dbi:Oracle:DBNAME

I agree on using tnsnames.ora for setting the parameters. For some cases
I have used syntax like this:

DBSource dbi:Oracle:service_name=xe;host=192.168.1.10;port=1521

This should work too if tnsnames.ora does not.

Thanks,
Heikki

-- 
Heikki Vatiainen <hvn at open.com.au>

Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS,
TTLS, PEAP, TNC, WiMAX, RSA, Vasco, Yubikey, MOTP, HOTP, TOTP,
DIAMETER etc. Full source on Unix, Windows, MacOSX, Solaris, VMS,
NetWare etc.