Re: There are no DB handles to use!

I went in and deleted anything relating to the older freeradius I've been
using and downloaded the latest cvs release (20030629) and started
everythign from scratch... I configed everything the same as before and now
it has no problems!!! YAY!!!

> I've been trying to set up freeradius for a few days now. It works fine
> when I use the text files but after configuring it for postgresql I end
> up getting an error "There are no DB handles to use!". As you can see
> from the debug I raised the default from 5 handles to 30 but that
> didn't help. If anyone has had a similar problem with postgresql or any
> other db for that matter please help! I've been searching the mailing
> list and google with no luck.
>
>
> rlm_sql (sql): Driver rlm_sql_postgresql (module rlm_sql_postgresql)
> loaded and linked
> rlm_sql (sql): Attempting to connect to radius@localhost:5432/radius
> rlm_sql (sql): starting 0
> rlm_sql (sql): Attempting to connect rlm_sql_postgresql #0
> rlm_sql (sql): Connected new DB handle, #0
> rlm_sql (sql): starting 1
> rlm_sql (sql): Attempting to connect rlm_sql_postgresql #1
> rlm_sql (sql): Connected new DB handle, #1
> rlm_sql (sql): starting 2
> rlm_sql (sql): Attempting to connect rlm_sql_postgresql #2
> rlm_sql (sql): Connected new DB handle, #2
> rlm_sql (sql): starting 3
> rlm_sql (sql): Attempting to connect rlm_sql_postgresql #3
> rlm_sql (sql): Connected new DB handle, #3
> rlm_sql (sql): starting 4
> rlm_sql (sql): Attempting to connect rlm_sql_postgresql #4
> rlm_sql (sql): Connected new DB handle, #4
> rlm_sql (sql): starting 5
> rlm_sql (sql): Attempting to connect rlm_sql_postgresql #5
> rlm_sql (sql): Connected new DB handle, #5
> rlm_sql (sql): starting 6
> rlm_sql (sql): Attempting to connect rlm_sql_postgresql #6
> rlm_sql (sql): Connected new DB handle, #6
> rlm_sql (sql): starting 7
> rlm_sql (sql): Attempting to connect rlm_sql_postgresql #7
> rlm_sql (sql): Connected new DB handle, #7
> rlm_sql (sql): starting 8
> rlm_sql (sql): Attempting to connect rlm_sql_postgresql #8
> rlm_sql (sql): Connected new DB handle, #8
> rlm_sql (sql): starting 9
> rlm_sql (sql): Attempting to connect rlm_sql_postgresql #9
> rlm_sql (sql): Connected new DB handle, #9
> rlm_sql (sql): starting 10
> rlm_sql (sql): Attempting to connect rlm_sql_postgresql #10
> rlm_sql (sql): Connected new DB handle, #10
> rlm_sql (sql): starting 11
> rlm_sql (sql): Attempting to connect rlm_sql_postgresql #11
> rlm_sql (sql): Connected new DB handle, #11
> rlm_sql (sql): starting 12
> rlm_sql (sql): Attempting to connect rlm_sql_postgresql #12
> rlm_sql (sql): Connected new DB handle, #12
> rlm_sql (sql): starting 13
> rlm_sql (sql): Attempting to connect rlm_sql_postgresql #13
> rlm_sql (sql): Connected new DB handle, #13
> rlm_sql (sql): starting 14
> rlm_sql (sql): Attempting to connect rlm_sql_postgresql #14
> rlm_sql (sql): Connected new DB handle, #14
> rlm_sql (sql): starting 15
> rlm_sql (sql): Attempting to connect rlm_sql_postgresql #15
> rlm_sql (sql): Connected new DB handle, #15
> rlm_sql (sql): starting 16
> rlm_sql (sql): Attempting to connect rlm_sql_postgresql #16
> rlm_sql (sql): Connected new DB handle, #16
> rlm_sql (sql): starting 17
> rlm_sql (sql): Attempting to connect rlm_sql_postgresql #17
> rlm_sql (sql): Connected new DB handle, #17
> rlm_sql (sql): starting 18
> rlm_sql (sql): Attempting to connect rlm_sql_postgresql #18
> rlm_sql (sql): Connected new DB handle, #18
> rlm_sql (sql): starting 19
> rlm_sql (sql): Attempting to connect rlm_sql_postgresql #19
> rlm_sql (sql): Connected new DB handle, #19
> rlm_sql (sql): starting 20
> rlm_sql (sql): Attempting to connect rlm_sql_postgresql #20
> rlm_sql (sql): Connected new DB handle, #20
> rlm_sql (sql): starting 21
> rlm_sql (sql): Attempting to connect rlm_sql_postgresql #21
> rlm_sql (sql): Connected new DB handle, #21
> rlm_sql (sql): starting 22
> rlm_sql (sql): Attempting to connect rlm_sql_postgresql #22
> rlm_sql (sql): Connected new DB handle, #22
> rlm_sql (sql): starting 23
> rlm_sql (sql): Attempting to connect rlm_sql_postgresql #23
> rlm_sql (sql): Connected new DB handle, #23
> rlm_sql (sql): starting 24
> rlm_sql (sql): Attempting to connect rlm_sql_postgresql #24
> rlm_sql (sql): Connected new DB handle, #24
> rlm_sql (sql): starting 25
> rlm_sql (sql): Attempting to connect rlm_sql_postgresql #25
> rlm_sql (sql): Connected new DB handle, #25
> rlm_sql (sql): starting 26
> rlm_sql (sql): Attempting to connect rlm_sql_postgresql #26
> rlm_sql (sql): Connected new DB handle, #26
> rlm_sql (sql): starting 27
> rlm_sql (sql): Attempting to connect rlm_sql_postgresql #27
> rlm_sql (sql): Connected new DB handle, #27
> rlm_sql (sql): starting 28
> rlm_sql (sql): Attempting to connect rlm_sql_postgresql #28
> rlm_sql (sql): Connected new DB handle, #28
> rlm_sql (sql): starting 29
> rlm_sql (sql): Attempting to connect rlm_sql_postgresql #29
> rlm_sql (sql): Connected new DB handle, #29
> Module: Instantiated sql (sql)
> Module: Loaded Acct-Unique-Session-Id
> acct_unique: key = "User-Name, Acct-Session-Id, NAS-IP-Address,
> Client-IP-
> Address, NAS-Port-Id"
> Module: Instantiated acct_unique (acct_unique)
> Module: Loaded detail
> detail: detailfile = "/usr/local/var/log/radius/radacct/%{Client-IP-
> Address}/detail-%Y%m%d"
> detail: detailperm = 384
> detail: dirperm = 493
> detail: locking = no
> Module: Instantiated detail (detail)
> Module: Loaded System
> unix: cache = no
> unix: passwd = "(null)"
> unix: shadow = "(null)"
> unix: group = "(null)"
> unix: radwtmp = "/usr/local/var/log/radius/radwtmp"
> unix: usegroup = no
> unix: cache_reload = 600
> Module: Instantiated unix (unix)
> Module: Loaded radutmp
> radutmp: filename = "/usr/local/var/log/radius/radutmp"
> radutmp: username = "%{User-Name}"
> radutmp: case_sensitive = yes
> radutmp: check_with_nas = yes
> radutmp: perm = 384
> radutmp: callerid = yes
> Module: Instantiated radutmp (radutmp)
> Listening on IP address *, ports 1812/udp and 1813/udp.
> Ready to process requests.
> rad_recv: Access-Request packet from host 127.0.0.1:45819, id=191,
> length=59
>        User-Name = "justind"
>        User-Password = "testy"
>        NAS-IP-Address = 255.255.255.255
>        NAS-Port = 1812
> modcall: entering group authorize
>  modcall[authorize]: module "preprocess" returns ok
>  modcall[authorize]: module "chap" returns noop
>  modcall[authorize]: module "mschap" returns noop
>    rlm_realm: No '@' in User-Name = "justind", looking up realm NULL
>    rlm_realm: No such realm "NULL"
>  modcall[authorize]: module "suffix" returns noop
> radius_xlat:  'justind'
> rlm_sql (sql): sql_set_user escaped user --> 'justind'
> radius_xlat:  'SELECT id,UserName,Attribute,Value,Op FROM radcheck
> WHERE UserName = 'justind' ORDER BY id'
> rlm_sql (sql): There are no DB handles to use! skipped 0, tried to
> connect 0
>  modcall[authorize]: module "sql" returns fail
> modcall: group authorize returns fail
> There was no response configured: rejecting request 0
> Server rejecting request 0.
> Finished request 0
> Going to the next request
> --- Walking the entire request list ---
> Waking up in 1 seconds...
> --- Walking the entire request list ---
> Waking up in 1 seconds...
> --- Walking the entire request list ---
> Sending Access-Reject of id 191 to 127.0.0.1:45819
> Waking up in 4 seconds...
> --- Walking the entire request list ---
> Cleaning up request 0 ID 191 with timestamp 3efcd2b6
> Nothing to do.  Sleeping until we see a request.
>
>
>
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html




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