At 07.28 03/12/02, you wrote:
in general you don't know why the query fails. It can fails also if the connection is down.Hello,I have been having problems with freeradius 0.8 crashing for us regularly. First: we are using freeradius 0.8 with ldap authentication and sql accounting to an oracle database. I can supply config files if required. At the moment the server crashes multiple times a day. I *think* I have tracked down the problem. If a user logs in with a username > 32 characters we have problems. The column is VARCHAR2 32, and so the insert/update fails (fair enough). First bug: rlm_sql_oracle.c returns SQL_DOWN. I believe it should return -1. SQL_DOWN should be for when the connection fails.
the check at the top of the sql_query funcion:
if (oracle_sock->conn == NULL) {
radlog(L_ERR, "Socket not connected");
return SQL_DOWN;
doesn't match if the connection is down.
I had the same problem with the connection_info field, and I solved it altering the data type definition.
---------------------------------------
Psychiatrists say that 1 of 4 people is mentally ill. Check 3 friends. If they're ok, you're it.
---------------------------------------
Ing. Andrea Gabellini
Email: [EMAIL PROTECTED]
Tel: 0549 886111 (Italy)
Tel. +378 0549 886111 (International)
Intelcom San Marino S.p.A.
Strada degli Angariari, 3
47891 Rovereta
Repubblic of San Marino
http://www.omniway.sm http://www.intelcom.sm
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
