Здравствуйте, freeradius-users.

I'd like to make pre-paid voip using quintum.

so, I've created database

voip=# SELECT * FROM radcheck;
 id |  username  |   attribute   | op |   value
----+------------+---------------+----+------------
  1 | 1233211233 | User-Password | == | 1233211233
(1 запись)

voip=# SELECT * FROM radgroupcheck;
 id | groupname | attribute | op | value
----+-----------+-----------+----+-------
  1 | test      | Auth-Type | := | Local
(1 запись)

then
radiusd -X
...

rad_recv: Access-Request packet from host 195.68.222.205:24579, id=15, length=155
        NAS-IP-Address = 195.68.222.205
        User-Name = "1233211233"
        User-Password = "1233211233"
        NAS-Port-Type = Async
        Quintum-h323-conf-id = "h323-conf-id=34313462 31346662 31320061 643200CA"
        Quintum-AVPair = "h323-ivr-out=ACCESSCODE:12345"
  Processing the authorize section of radiusd.conf
modcall: entering group authorize for request 0
  modcall[authorize]: module "preprocess" returns ok for request 0
  modcall[authorize]: module "chap" returns noop for request 0
  modcall[authorize]: module "mschap" returns noop for request 0
    rlm_realm: No '@' in User-Name = "1233211233", looking up realm NULL
    rlm_realm: No such realm "NULL"
  modcall[authorize]: module "suffix" returns noop for request 0
radius_xlat:  '1233211233'
rlm_sql (pgsql-voip): sql_set_user escaped user --> '1233211233'
radius_xlat:  'SELECT id, UserName, Attribute, Value, Op ??FROM radcheck ??WHERE 
Username = '1233211233' ??ORDER BY id'
rlm_sql (pgsql-voip): Reserving sql socket id: 14
rlm_sql_postgresql: query: SELECT id, UserName, Attribute, Value, Op ??FROM radcheck 
??WHERE Username = '1233211233' ??ORDER BY id
rlm_sql_postgresql: Status: PGRES_TUPLES_OK
rlm_sql_postgresql: affected rows =

but using psql tool

voip=# SELECT id, UserName, Attribute, Value, Op FROM radcheck WHERE Username = 
'1233211233' ORDER BY id;
 id |  username  |   attribute   |   value    | op
----+------------+---------------+------------+----
  1 | 1233211233 | User-Password | 1233211233 | ==
(1 запись)

please tell me why I can get this row from radcheck, and freeradius
can not do this?

I use freeradius 1.0.0.
-- 
С уважением,
 Dmitriy                          mailto:[EMAIL PROTECTED]


-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Reply via email to