Hello, I've installed FreeRADIUS (3.0.4-6.el7) on CentOS 7 from the repositories with the plan to use unixODBC and FreeTDS to authenticate against a MSSQL database; however, running radiusd -X results in this (similar error when using freeradius-3.0.8-3.fc23): rlm_sql (sql): Driver rlm_sql_unixodbc (module rlm_sql_unixodbc) loaded and linked rlm_sql (sql): Attempting to connect to database "FreeRADIUS" rlm_sql (sql): Initialising connection pool pool { start = 5 min = 4 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: 01000 [unixODBC][Driver Manager]Can't open lib '/usr/lib64/libtdsodbc.so.0.0.0' : ?w????: undefined symbol: get_vtable rlm_sql_unixodbc: SQL down 08003 [unixODBC][Driver Manager]Connnection does not exist rlm_sql_unixodbc: Can't allocate the statement 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" Other users faced this 'get_vtable' issue but it doesn't seem that anyone found a solution, any help is appreciated. Thanks
rlm_sql (sql): Opening additional connection (0) rlm_sql_unixodbc: 01000 [unixODBC][Driver Manager]Can't open lib '/usr/lib64/libtdsodbc.so.0.0.0' : ?w????: undefined symbol: get_vtable rlm_sql_unixodbc: SQL down 08003 [unixODBC][Driver Manager]Connnection does
Hi, Can you tell us what version (package) of unixODBC you are running? It's quite possible that the version that CentOS/RHEL ship with CentOS 7 is somewhat older than the version that has the vtable entry. Once we know, Arran and Alan can fix it and Nikolay at RedHat can do a patch :-) Stefan Paetow Moonshot Industry & Research Liaison Coordinator t: +44 (0)1235 822 125 gpg: 0x3FCE5142 xmpp: stefanp@jabber.dev.ja.net skype: stefan.paetow.janet jisc.ac.uk Jisc is a registered charity (number 1149740) and a company limited by guarantee which is registered in England under Company No. 5747339, VAT No. GB 197 0632 86. Jisc¹s registered office is: One Castlepark, Tower Hill, Bristol, BS2 0JA. T 0203 697 5800. Jisc Collections and Janet Ltd. is a wholly owned Jisc subsidiary and a company limited by guarantee which is registered in England under Company No. number 2881024, VAT No. GB 197 0632 86. The registered office is: Lumen House, Library Avenue, Harwell, Didcot, Oxfordshire, OX11 0SG. T 01235 822200.
Hi,
Can you tell us what version (package) of unixODBC you are running?
It's quite possible that the version that CentOS/RHEL ship with CentOS 7 is somewhat older than the version that has the vtable entry.
...in which case the centos build would fail.....as it would be built against such libraries with the same version includes etc ? - was this a self-built FreeRADIUS server or from RPM? alan
Can you tell us what version (package) of unixODBC you are running?
It's quite possible that the version that CentOS/RHEL ship with CentOS 7 is somewhat older than the version that has the vtable entry.
...in which case the centos build would fail.....as it would be built against such libraries with the same version includes etc ? - was this a self-built FreeRADIUS server or from RPM?
Fair enough. I'd also check that freetds is installed. The .so refers to that, so if it's not part of the SPEC file pre-requisites, then yes, freetds needs to be installed. Stefan Paetow Moonshot Industry & Research Liaison Coordinator t: +44 (0)1235 822 125 gpg: 0x3FCE5142 xmpp: stefanp@jabber.dev.ja.net skype: stefan.paetow.janet jisc.ac.uk Jisc is a registered charity (number 1149740) and a company limited by guarantee which is registered in England under Company No. 5747339, VAT No. GB 197 0632 86. Jisc¹s registered office is: One Castlepark, Tower Hill, Bristol, BS2 0JA. T 0203 697 5800. Jisc Collections and Janet Ltd. is a wholly owned Jisc subsidiary and a company limited by guarantee which is registered in England under Company No. number 2881024, VAT No. GB 197 0632 86. The registered office is: Lumen House, Library Avenue, Harwell, Didcot, Oxfordshire, OX11 0SG. T 01235 822200.
Hi Harvii, Install mysql-devel package and try it. On Thu, Jul 30, 2015 at 2:02 PM, Harvii Dent <harvii.dent@gmail.com> wrote:
Hello,
I've installed FreeRADIUS (3.0.4-6.el7) on CentOS 7 from the repositories with the plan to use unixODBC and FreeTDS to authenticate against a MSSQL database; however, running radiusd -X results in this (similar error when using freeradius-3.0.8-3.fc23):
rlm_sql (sql): Driver rlm_sql_unixodbc (module rlm_sql_unixodbc) loaded and linked rlm_sql (sql): Attempting to connect to database "FreeRADIUS" rlm_sql (sql): Initialising connection pool pool { start = 5 min = 4 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: 01000 [unixODBC][Driver Manager]Can't open lib '/usr/lib64/libtdsodbc.so.0.0.0' : ?w????: undefined symbol: get_vtable rlm_sql_unixodbc: SQL down 08003 [unixODBC][Driver Manager]Connnection does not exist rlm_sql_unixodbc: Can't allocate the statement 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"
Other users faced this 'get_vtable' issue but it doesn't seem that anyone found a solution, any help is appreciated.
Thanks - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
participants (4)
-
A.L.M.Buxey＠lboro.ac.uk -
Harvii Dent -
J＠g＠dee5h -
Stefan Paetow