Ignoring unconnected handle 4..

[Chris Carver]

Abul Monsur Mannan wrote:

> Hello FR users
>
> Can anyone here to light on me.My problem is --
>
> [root at localhost ~]# radtest rumen rumen1 localhost 1812 testing123
> Sending Access-Request of id 66 to 127.0.0.1 port 1812
>       User-Name = "rumen"
>       User-Password = "rumen1"
>       NAS-IP-Address = 255.255.255.255
>       NAS-Port = 1812
> Re-sending Access-Request of id 66 to 127.0.0.1 port 1812
>       User-Name = "rumen"
>       User-Password = "rumen1"
>       NAS-IP-Address = 255.255.255.255
>       NAS-Port = 1812
>
> ------------------------------------------------------
>
> In radiusd -x command promp--
>
> rad_recv: Access-Request packet from host 127.0.0.1:32769, id=66, 
> length=57
>       User-Name = "rumen"
>       User-Password = "rumen1"
>       NAS-IP-Address = 255.255.255.255
>       NAS-Port = 1812
> Processing the authorize section of radiusd.conf
> modcall: entering group authorize for request 23
> modcall[authorize]: module "preprocess" returns ok for request 23
> modcall[authorize]: module "chap" returns noop for request 23
> modcall[authorize]: module "mschap" returns noop for request 23
>   rlm_realm: No '@' in User-Name = "rumen", looking up realm NULL
>   rlm_realm: No such realm "NULL"
> modcall[authorize]: module "suffix" returns noop for request 23
> rlm_eap: No EAP-Message, not doing EAP
> modcall[authorize]: module "eap" returns noop for request 23
> radius_xlat:  'rumen'
> rlm_sql (sql): sql_set_user escaped user --> 'rumen'
> radius_xlat:  'SELECT id, UserName, Attribute, Value, op
> FROM radcheck           WHERE Username = 'rumen'           ORDER BY
> id'
> rlm_sql (sql): Ignoring unconnected handle 4..
> rlm_sql (sql): Ignoring unconnected handle 3..
> rlm_sql (sql): Ignoring unconnected handle 2..
> rlm_sql (sql): Ignoring unconnected handle 1..
> rlm_sql (sql): Ignoring unconnected handle 0..
> rlm_sql (sql): There are no DB handles to use! skipped 5, tried to 
> connect 0
> modcall[authorize]: module "sql" returns fail for request 23
> modcall: leaving group authorize (returns fail) for request 23
> Finished request 23
> Going to the next request
> --- Walking the entire request list ---
> Waking up in 6 seconds...
> --- Walking the entire request list ---
> Cleaning up request 23 ID 66 with timestamp 44b33d38
> Nothing to do.  Sleeping until we see a request.
>
>
> By the way ,I have username - rumen with password rumen1 in "radcheck"
> table in my mysql DB.
>
> Thank You in advance.
> - List info/subscribe/unsubscribe? See 
> http://www.freeradius.org/list/users.html


For some reason your radius server is completely unable to connect to 
your mysql database.  Look at the information you have configured in 
your sql configuration file (myssql.conf, sql.conf, etc depending on 
which you use) and verify it is correct.  Try using the command line 
mysql client to connect to the mysql database you specify to ensure it 
should work properly.

mysql -u<username> -p<password> -h<remoteserver> radius

Chris Carver
Network Engineer