[RADIATOR] TOTP authentication with Oracle

[Hugh Irvine]

Hello Denis -

The first thing to do is upgrade to the latest Radiator 4.21 and test again to verify that there is still a problem.

After that, we need to see a copy of your configuration file together with a complete trace 4 debug showing what is happening.

It would also be useful to know what versions of PERL modules you are using for DBI, DBD-Oracle, etc.

regards

Hugh


> On 31 Jul 2018, at 00:43, Denis PAVANI <d.pavani at cineca.it> wrote:
> 
> Hello,
> 
> I am trying to setup totp authentication using google authenticator.
> 
> We use Oracle as a backend DB, which is perfectly working for accounting. When using totp, I got errors, an accounting failure and then radiator crashes (test instance, Radiator 4.16)
> 
> Last line in the log is
> 
> Mon Jul 30 15:33:26 2018: DEBUG: Query to 'DBI:Oracle:db105.dbc': 'select secret, active, pin, digits, bad_logins, accessed, last_timestep, timestep, algorithm, timestep_origin from totpkeys where username='user'':
> 
> The same query done on commandline using sqlplus works.
> 
> Could you share any suggestion?
> 
> Best regards.
> 
> -- 
> 
> *******************************************************************
> Ing. Denis Pavani
> 
> DSET - Gruppo Tecnologie
> CINECA
> via Raffaello Sanzio 4 20090 SEGRATE MI
> Tel: +39 02 26995.348
> skype: d.pavani.at.cineca
> 
> “In my experience there is no such thing as luck.” – Obi-Wan Kenobi
> 
> *******************************************************************
> 
> _______________________________________________
> radiator mailing list
> radiator at lists.open.com.au
> http://lists.open.com.au/mailman/listinfo/radiator


--

Hugh Irvine
hugh 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, SIM, etc. 
Full source on Unix, Linux, Windows, macOS, Solaris, VMS, NetWare etc.