Hi

i have read letter by letter the querys in postgresql.conf and found the error, there isnt the ${group_tables}.op field in the group querys, only in the user querys, i added it manually and all is fine now, the only problem that remains is the simultaneous login, after the op correction, i get this messages all the time a user tries to connect:

modcall: group authorize returns ok
auth: type Local
auth: user supplied User-Password matches local User-Password
modcall: entering group session
radius_xlat:  '/usr/local/var/log/radius/radutmp'
radius_xlat:  '2660124'
checkrad: No NAS type, or type "other" not checking
  modcall[session]: module "radutmp" returns ok
modcall: group session returns ok
Multiple logins (max 1) : [2660124] (from client private-network port 0 cli 2660124)
Sending Access-Reject of id 229 to 192.168.10.117:21647
        Reply-Message := "\r\nYou are already logged in - access denied\r\n\n"
Finished request 15

 

Miguel

-----Original Message-----
From: Miranda Gomez Miguel Angel [mailto:[EMAIL PROTECTED]
Sent: Friday, July 04, 2003 12:26 PM
To: [EMAIL PROTECTED]
Subject: Strange Message using Exec-Program-Wait

Hi People.
Im running freeradius 0.8.1 with accounting and userinfo in a postgres 7.3 database, i want to use the exec-program-wait function, i have configured the radgroupreply table with the following information
 
radius=# select * from radgroupreply;
 id | groupname |     attribute     | op |              value              
----+-----------+-------------------+----+----------------------------------
  2 | prepago   | Exec-Program-Wait | =  | /usr/local/bin/calcula_tiempo.pl
(1 row)
 
 
All seems to work ok, but im having this message when running in debug mode:
 
rlm_sql: The 'op' field for attribute 'Exec-Program-Wait = /usr/local/bin/calcula_tiempo.pl' is NULL, or non-existent.
rlm_sql: You MUST FIX THIS if you want the configuration to behave as you expect.
rlm_sql (sql): Released sql socket id: 1
modcall[authorize]: module "sql" returns ok
i also want to restrict the users to one simultaneous connection, but this doesnt work, if i set the following in the radgroupcheck table, none user can connect:
 
radius=# select * from radgroupcheck;
 id | groupname |    attribute     | op | value 
----+-----------+------------------+----+--------
  1 | disabled  | Auth-Type        | := | Reject
  5 | prepago   | Simultaneous-Use | := | 1
 
and this message appears in the debug:
 
rlm_sql (sql): No matching entry in the database for request from user [2660124]
rlm_sql (sql): Released sql socket id: 13
  modcall[authorize]: module "sql" returns notfound
  modcall[authorize]: module "files" returns notfound
modcall: group authorize returns ok
auth: No authenticate method (Auth-Type) configuration found for the request: Rejecting the user
auth: Failed to validate the user.
Login incorrect: [2660124/2660003#] (from client private-network port 0 cli 2660124)
Sending Access-Reject of id 158 to 192.168.10.117:21647
Finished request 1
Going to the next request
 
I did remove all the entries in the users file, i want all informaction in the DB.
 
If i remove the simultaneous check, the user can connect ok.
 
thanks in advance
 
Miguel
 
 
 
 
 
 

Reply via email to