-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Alan DeKok
Sent: Thursday, May 29, 2003 3:21 PM
To: [EMAIL PROTECTED]
Subject: Re: Rlm_sql error
"Jeff Sullivan" <[EMAIL PROTECTED]> wrote:
> This set of errors is showing up exactly every minute.
>
> Thu May 29 15:02:05 2003 : Error: rlm_sql (sql): failed after
> re-connect Thu May 29 15:02:05 2003 : Error: rlm_sql (sql): Couldn't
> update SQL accounting STOP record - ERROR: pg_atoi: zero-length
> string
>
> Any Help?
The same question was asked and answered yesterday, I believe.
Alan DeKok.
-
Nope, not answered.
Here is the request
rad_recv: Accounting-Request packet from host 10.0.9.8:1646, id=211,
length=212
User-Name = "admin"
NAS-IP-Address = x.x.x.x
NAS-Identifier = "x.x.x.x"
Acct-Status-Type = Stop
Acct-Session-Id = "3672440832"
Acct-Delay-Time = 182338
Acct-Authentic = Local
Service-Type = Administrative-User
NAS-Port-Type = Virtual
Login-Service = Telnet
Login-TCP-Port = 49809
Login-IP-Host = 10.0.9.9
USR-VTS-Session-Key = "il\354\3219\240?0\236\223\223k\221SW7"
USR-Call-Arrival-Time = 0
USR-Call-End-Time = 0
Attr-28154031 = 0x00
Acct-Session-Time = 7756
Acct-Terminate-Cause = User-Request
USR-HARC-Disconnect-Code = No-Error
USR-Speed-Of-Connection = Auto
rlm_sql (sql): Reserving sql socket id: 20
rlm_sql_postgresql: Status: PGRES_FATAL_ERROR
rlm_sql_postgresql: affected rows =
rlm_sql_postgresql: Postgresql check_error: PGRES_FATAL_ERROR, returning
SQL_DOWN
rlm_sql (sql): Attempting to connect rlm_sql_postgresql #20
rlm_sql (sql): Connected new DB handle, #20
rlm_sql_postgresql: Status: PGRES_FATAL_ERROR
rlm_sql_postgresql: affected rows =
rlm_sql_postgresql: Postgresql check_error: PGRES_FATAL_ERROR, returning
SQL_DOWN
rlm_sql (sql): failed after re-connect
rlm_sql (sql): Couldn't update SQL accounting STOP record - ERROR:
pg_atoi: zero-length string
10.0.9.9 is the IP of my radius server. I am not using checkrad and
cannot find admin in any of my configuration files.
Jeff
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
