[RADIATOR] Connecting to Oracle DB on non default port

[rohan.henry @cwjamaica.com]

Heikki,

Thanks. It works!

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

But it wouldn't work until I specified the port number even though its the
default.

Rohan

On Tue, Jan 7, 2014 at 7:13 AM, Heikki Vatiainen <hvn at open.com.au> wrote:

> 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.
> _______________________________________________
> radiator mailing list
> radiator at open.com.au
> http://www.open.com.au/mailman/listinfo/radiator
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.open.com.au/pipermail/radiator/attachments/20140107/68e6a738/attachment.html