Yes freeradius works with quintums. I think you need to add sql in the authorize section of your radiusd.conf and you also need to send return code back to the quintum from the sql.
You can read the rlm sql in the doc directory or src/billing for some pointers. All the best. Kafui Amedzekor. --- Dmitriy Milashenko <[EMAIL PROTECTED]> wrote: > Здравствуйте, 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 > _______________________________ Do you Yahoo!? Declare Yourself - Register online to vote today! http://vote.yahoo.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
