Dear Igor Chen,
level=6 ��� ���������� ������� ������� ������������, ���� ������ ������
�� ������ ������ ������ ("�����������" ������� ��� 5). �.�. ���� �����
��� ������� �� ��� ���, �� level ���� ������ ������. ���� �� �����
������������ ����� 3� ���� - � ������ ���� ������ ���� � �� 2 ��� ������
���� ��������...
--Monday, April 15, 2002, 12:32:34 PM, you wrote to [EMAIL PROTECTED]:
IC> On Fri, 12 Apr 2002, Roman wrote:
>> Hi!
>> I use freeradius 0.5 with postgresql 7.2 on FreeBSD 4.5
>> When i run freeradius in dedug mode (radiusd -x), I found that:
>> 1) freeradius query for Accounting stop packets with
>> "accounting_stop_query_alt" in any way, regardless of accounting_stop_query
>> fail or not
>>
>> rad_recv: Accounting-Request packet from host x.x.x.x, id=206, length=127
>>
>> query: UPDATE radacct SET AcctStopTime =.....
>> rlm_postgresql Status: PGRES_COMMAND_OK
>> sql_postgresql: affected rows = 1
>>
>> query: INSERT into radacct ( AcctSessionId,....
>> rlm_postgresql Status: PGRES_FATAL_ERROR
>> sql_postgresql: affected rows =
>>
>> I have not many C experience, but it seems like
>> sql_affected_rows always 0 for update query
>>
>>
>> rlm_sql.c:
>>
>> numaffected = (inst->module->sql_affected_rows)(sqlsocket, inst->config);
>> if (numaffected < 1) {
>> /*
>> * If our update above didn't match anything
>> * we assume it's because we haven't seen a
>> * matching Start record. So we have to
>> * insert this stop rather than do an update
>> */
>> ...
>>
>> 2) accounting_stop_query_alt is syntacticaly incorrect (both sql.conf and
>> postgresql.conf).
IC> I've already wrote about that :-) and even posted my sql.conf for postgres
--
~/ZARAZA
������ ����� ���� ��������� ���� ��������� (����)
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html