What exactly does it mean Socket Destructor failed
I have the proper access to log into the SQL server and I can remotely log into it through tsql and with the MS SQL linux instructions, and perform queries, but I cannot get freeradius for the life of me able to connect....it keeps erroring out with socket destructor called. rlm_sql (sql): Driver rlm_sql_unixodbc (module rlm_sql_unixodbc) loaded and linked rlm_sql (sql): Attempting to connect to database "gensql" rlm_sql (sql): Initialising connection pool pool { start = 15 min = 10 max = 32 spare = 3 uses = 0 lifetime = 0 cleanup_interval = 30 idle_timeout = 60 retry_delay = 1 spread = no } rlm_sql (sql): Opening additional connection (0) rlm_sql_unixodbc: Connection failed rlm_sql_unixodbc: Socket destructor called, closing socket rlm_sql (sql): Opening connection failed (0) rlm_sql (sql): Removing connection pool /etc/raddb/mods-enabled/sql[20]: Instantiation failed for module "sql" [root@localhost raddb]# Robert Graham Network Engineer U-Haul International 2727 N. Central Ave Phoenix, AZ 85004
On Jan 2, 2015, at 10:01 AM, Robert Graham <robert_graham@uhaul.com> wrote:
I have the proper access to log into the SQL server and I can remotely log into it through tsql and with the MS SQL linux instructions, and perform queries, but I cannot get freeradius for the life of me able to connect....it keeps erroring out with socket destructor called
The real error is a bit earlier:
rlm_sql (sql): Opening additional connection (0) rlm_sql_unixodbc: Connection failed
It would be nice to say *why* the connection failed. Unfortunately, the documentation for MS SQL isn’t really clear. I’ve pushed a fix which will print out the actual error number. Please grab the latest code from github: https://github.com/FreeRADIUS/freeradius-server/archive/v3.0.x.zip For a list of MS-SQL error codes, see: http://technet.microsoft.com/en-us/library/aa176407%28v=sql.80%29.aspx Alan DeKok.
Alan, I downloaded the updated code and ran the install, with the developer option, but now I get a alot of magic number mismatches between the modules...Ill just start with a fresh installtion of linux on the vmbox and try again. Robert Graham Network Engineer U-Haul International 2727 N. Central Ave Phoenix, AZ 85004 FreeRadius users mailing list <freeradius-users@lists.freeradius.org> writes:
On Jan 2, 2015, at 10:01 AM, Robert Graham <robert_graham@uhaul.com> wrote:
I have the proper access to log into the SQL server and I can remotely log into it through tsql and with the MS SQL linux instructions, and perform queries, but I cannot get freeradius for the life of me able to connect....it keeps erroring out with socket destructor called
The real error is a bit earlier:
rlm_sql (sql): Opening additional connection (0) rlm_sql_unixodbc: Connection failed
It would be nice to say *why* the connection failed. Unfortunately, the documentation for MS SQL isn’t really clear.
I’ve pushed a fix which will print out the actual error number. Please grab the latest code from github:
https://github.com/FreeRADIUS/freeradius-server/archive/v3.0.x.zip
For a list of MS-SQL error codes, see:
http://technet.microsoft.com/en-us/library/aa176407%28v=sql.80%29.aspx
Alan DeKok.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
On 2 Jan 2015, at 10:01, Robert Graham <robert_graham@uhaul.com> wrote:
I have the proper access to log into the SQL server and I can remotely log into it through tsql and with the MS SQL linux instructions, and perform queries, but I cannot get freeradius for the life of me able to connect....it keeps erroring out with socket destructor called.
'Socket destructor called, closing socket' isn't an error, so it's not 'erroring' out on that. If you're using MS SQL use the freetds driver instead, it speaks the native MS SQL protocol. -Arran Arran Cudbard-Bell <a.cudbardb@freeradius.org> FreeRADIUS development team FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2
participants (3)
-
Alan DeKok -
Arran Cudbard-Bell -
Robert Graham