-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Uwe Kastens wrote:
Hello list,
I am trying to use some internal database function to calculate the Session-Timeout.
If I set the value for Session-Timeout to a integer like 123, its correctly delivered as answer to my request.
If I try to use sql xlat I will get the answer: Error: rlm_sql: Failed to create the pair: Unknown value %{sql:SELECT disctime.time FROM `disctime` WHERE disctime.user = %{User-Name}} for attribute Session-Timeout Sun Apr 19 20:11:03 2009 : Error: rlm_sql (sql): Error getting data from database
I tried several different things: Use a select statement to query the integer directly. I ends up in the same error. I am using:
*sigh* single quotation marks around %{User-Name}, it's still a string remember....
- freeradius: FreeRADIUS Version 2.0.4, for host i486-pc-linux-gnu, built on Sep 7 2008 at 23:35:34 - Debian GNU/Linux 5.0 (lenny) - postgresql 8.3.7-0lenny1
BR
Uwe
-----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.9 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAknsLZAACgkQcaklux5oVKJICwCdGQ8po+i46xN3uXUyp0GGDwOr xWIAn22YpKHnqtJse1rCGRFow+KHc6hq =1D2m -----END PGP SIGNATURE-----