(RADIATOR) <SessionDatabase SQL>

[Hugh Irvine]

Hello Mariano -

Why don't you use this:

	%d%H%M%S

regards

Hugh


On Tuesday 15 May 2001 07:56, Mariano Absatz wrote:
> Hi,
>
> I'm having problems with a <SessionDatabase SQL>... I want to use the
> timestamp in the AddQuery (with Oracle), but '%p' is yelding a 1 digit
> second if the seconds in the timestamp is <10.
>
> Following is the corresponding part in the config file and afterwards, a
> trace 4.
>
> Note, in the trace, that it says
> TO_DATE('2001-05-14 18:38:2', 'YYYY-MM-DD HH24:MI:SS')
> instead of
> TO_DATE('2001-05-14 18:38:02', 'YYYY-MM-DD HH24:MI:SS')
>
> <SessionDatabase SQL>
>         Identifier SessDBUsers
>
>         include %{GlobalVar:ConfigDir}/DBUseData.cfg
>
>
>         AddQuery INSERT INTO USUARIOS_EN_LINEA \
>                 (USU_CODIGO, VISP_CODIGO, USUA_SESION_ID, \
>                 USUA_IP_NAS, POOL_NAME, USUA_PORT, USUA_BYTES,
> USUA_TIEMPO, \
>                 USUA_HORA_CONEXION, USUA_CALL_ID, USUA_DNIS,
> USUA_IP_ASIGNADA) \
>                 VALUES \
>                 ('%U', '%R', '%{Acct-Session-Id}', \
>                 '%N', 'nombre del pool', %{NAS-Port}, 0, 0, \
>                 TO_DATE('%f-%g-%i %j:%k:%p', 'YYYY-MM-DD HH24:MI:SS'), \
>                 '%{Calling-Station-Id}', '%{Called-Station-Id}',
> '%{Framed-IP-Address}')
>
>         DeleteQuery DELETE FROM USUARIOS_EN_LINEA \
>                 WHERE USU_CODIGO='%U' AND VISP_CODIGO='%R' AND \
>                         USUA_IP_NAS='%N' AND USUA_PORT='%{NAS-Port}'
>
>         ClearNasQuery DELETE FROM USUARIOS_EN_LINEA \
>                 WHERE USUA_IP_NAS='%N'
>
>         CountQuery SELECT USUA_IP_NAS, USUA_PORT, USUA_SESION_ID \
>                 FROM USUARIOS_EN_LINEA \
>                 WHERE USU_CODIGO='%U' AND VISP_CODIGO='%R'
>
>
> </SessionDatabase>
>
>
>
>
>
>
> Mon May 14 18:38:02 2001: INFO: Server started: Radiator 2.18.1 on mr-visp
> Mon May 14 18:38:02 2001: DEBUG: Packet dump:
> *** Received from 127.0.0.1 port 41858 ....
> Code:       Accounting-Request
> Identifier: 198
> Authentic:  Gr<16><25>3<197>+<215><2><219><223>`eSUK
> Attributes:
>         User-Name = "yaNi at pert"
>         Service-Type = Framed-User
>         NAS-IP-Address = 200.59.130.83
>         NAS-Port = 1234
>         NAS-Port-Type = Async
>         Acct-Session-Id = "hola001"
>         Acct-Status-Type = Start
>         Called-Station-Id = "123456789"
>         Calling-Station-Id = "987654321"
>
> Mon May 14 18:38:02 2001: DEBUG: Rewrote user name to yaNi at pert
> Mon May 14 18:38:02 2001: DEBUG: Rewrote user name to yani at pert
> Mon May 14 18:38:02 2001: DEBUG: Check if Handler  should be used to
> handle this request
> Mon May 14 18:38:02 2001: DEBUG: Handling request with Handler ''
> Mon May 14 18:38:02 2001: DEBUG: SessDBUsers Adding session for
> yaNi at pert, 200.59.130.83, 1234
> Mon May 14 18:38:02 2001: DEBUG: do query is: DELETE FROM
> USUARIOS_EN_LINEA WHERE USU_CODIGO='yani' AND VISP_CODIGO='pert' AND
> USUA_IP_NAS='200.59.130.83' AND USUA_PORT='1234'
>
> Mon May 14 18:38:02 2001: DEBUG: do query is: INSERT INTO
> USUARIOS_EN_LINEA (USU_CODIGO, VISP_CODIGO, USUA_SESION_ID, USUA_IP_NAS,
> POOL_NAME, USUA_PORT, USUA_BYTES, USUA_TIEMPO, USUA_HORA_CONEXION,
> USUA_CALL_ID, USUA_DNIS, USUA_IP_ASIGNADA) VALUES ('yani', 'pert',
> 'hola001', '200.59.130.83', 'nombre del pool', 1234, 0, 0, TO_DATE('2001-
> 05-14 18:38:2', 'YYYY-MM-DD HH24:MI:SS'), '987654321', '123456789', '0')
>
> Mon May 14 18:38:03 2001: ERR: do failed for 'INSERT INTO
> USUARIOS_EN_LINEA (USU_CODIGO, VISP_CODIGO, USUA_SESION_ID, USUA_IP_NAS,
> POOL_NAME, USUA_PORT, USUA_BYTES, USUA_TIEMPO, USUA_HORA_CONEXION,
> USUA_CALL_ID, USUA_DNIS, USUA_IP_ASIGNADA) VALUES ('yani', 'pert',
> 'hola001', '200.59.130.83', 'nombre del pool', 1234, 0, 0, TO_DATE('2001-
> 05-14 18:38:2', 'YYYY-MM-DD HH24:MI:SS'), '987654321', '123456789',
> '0')': ORA-01722: invalid number (DBD ERROR: OCIStmtExecute)
> Mon May 14 18:38:03 2001: ERR: do failed for 'INSERT INTO
> USUARIOS_EN_LINEA (USU_CODIGO, VISP_CODIGO, USUA_SESION_ID, USUA_IP_NAS,
> POOL_NAME, USUA_PORT, USUA_BYTES, USUA_TIEMPO, USUA_HORA_CONEXION,
> USUA_CALL_ID, USUA_DNIS, USUA_IP_ASIGNADA) VALUES ('yani', 'pert',
> 'hola001', '200.59.130.83', 'nombre del pool', 1234, 0, 0, TO_DATE('2001-
> 05-14 18:38:2', 'YYYY-MM-DD HH24:MI:SS'), '987654321', '123456789',
> '0')': ORA-01722: invalid number (DBD ERROR: OCIStmtExecute)
> Mon May 14 18:38:03 2001: DEBUG: Handling with Radius::AuthSQL
> Mon May 14 18:38:03 2001: DEBUG: Handling accounting with Radius::AuthSQL
> Mon May 14 18:38:03 2001: DEBUG: Accounting accepted
> Mon May 14 18:38:03 2001: DEBUG: Packet dump:
> *** Sending to 127.0.0.1 port 41858 ....
> Code:       Accounting-Response
> Identifier: 198
> Authentic:  Gr<16><25>3<197>+<215><2><219><223>`eSUK
> Attributes:
>
>
>
> TIA.
>
> ===
> 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.

-- 
Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
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.