Quick question: I am looking into adding an ACT! Plugin to populate the Radius MySQL database through unix ODBC. Found rlm_sql_unixodbc and wondered if this is already provided for this purpose, or something else? Looks like it needs to be run through "make"... (not installed by default). Otherwise, I can go through the steps for installing mysql-connector-odbc and friends. Thanks, Jim
Jim Rice wrote:
Quick question: I am looking into adding an ACT! Plugin to populate the Radius MySQL database through unix ODBC. Found rlm_sql_unixodbc and wondered if this is already provided for this purpose, or something else?
It's for that purpose.
Looks like it needs to be run through "make"... (not installed by default).
Yes. Alan DeKok.
Found this in the rlm_sql_unixodbc config.log: ... /usr/bin/ld: cannot find -lodbc ... configure:3080: WARNING: silently not building rlm_sql_unixodbc. configure:3082: WARNING: FAILURE: rlm_sql_unixodbc requires: libodbc sql.h. Did I miss some dependencies earlier when installing FR 2.1.10? Can I run "make" within this directory stand-alone, or should I rebuild from the top? I wouldn't want to lose where I am now and start over. ;-) ----- Original Message ----- From: "Alan DeKok" <aland@deployingradius.com> To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org> Sent: Thursday, April 07, 2011 12:43 AM Subject: Re: rlm_sql_unixodbc ?
Jim Rice wrote:
Quick question: I am looking into adding an ACT! Plugin to populate the Radius MySQL database through unix ODBC. Found rlm_sql_unixodbc and wondered if this is already provided for this purpose, or something else?
It's for that purpose.
Looks like it needs to be run through "make"... (not installed by default).
Yes.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Hi,
Found this in the rlm_sql_unixodbc config.log: ... /usr/bin/ld: cannot find -lodbc ... configure:3080: WARNING: silently not building rlm_sql_unixodbc. configure:3082: WARNING: FAILURE: rlm_sql_unixodbc requires: libodbc sql.h.
Did I miss some dependencies earlier when installing FR 2.1.10?
yes.
Can I run "make" within this directory stand-alone, or should I rebuild from the top?
just install the required dependencies , then recompile...then run 'make install' the required rlm_sql_unixodbc will be built and installed and none of your config will be touched (though you might want to just back up your current RADDB config directory just in case! ;-) ) alan
I thought I had followed the FR installation instructions and was surprised that something might have been missing. How can I know which dependencies are missing? (Which packages to install?) I had already installed mysql-connector-odbc before finding rlm_sql_unixodbc. There were several new library files added, including /usr/lib/libodbc.so.1.0.0 But -lodbc not so much.
On Fri, Apr 8, 2011 at 4:30 AM, Jim Rice <jmrice6640@yahoo.com> wrote:
I thought I had followed the FR installation instructions and was surprised that something might have been missing. How can I know which dependencies are missing? (Which packages to install?)
I had already installed mysql-connector-odbc before finding rlm_sql_unixodbc. There were several new library files added, including /usr/lib/libodbc.so.1.0.0 But -lodbc not so much.
Usually you'd need a "*.so" for linking, so I'm guessing you need a package which contains /usr/lib/libodbc.so (although in reality it could be just a symlink to libodbc.so.1.0.0). It's probably called mysql-connector-odbc-devel or mysql-connector-odbc-dev -- Fajar
After installing mysql-connector-odbc, running ./configure within rlm_sql_unixodbc it was then able to find: checking for SQLConnect in -lodbc... yes But not: checking for sql.h... no configure: WARNING: silently not building rlm_sql_unixodbc. configure: WARNING: FAILURE: rlm_sql_unixodbc requires: sql.h. I ran a find for sql.h and it is not in /usr. And neither pkg exists for mysql-connector-odbc-devel nor mysql-connector-odbc-dev. There is this: /usr/local/src/freeradius-server-2.1.10/src/modules/rlm_sql/rlm_sql.h Still not sure how to resolve this.
On Fri, Apr 8, 2011 at 8:13 AM, Jim Rice <jmrice6640@yahoo.com> wrote:
After installing mysql-connector-odbc, running ./configure within rlm_sql_unixodbc it was then able to find: checking for SQLConnect in -lodbc... yes
But not: checking for sql.h... no configure: WARNING: silently not building rlm_sql_unixodbc. configure: WARNING: FAILURE: rlm_sql_unixodbc requires: sql.h.
I ran a find for sql.h and it is not in /usr.
And neither pkg exists for mysql-connector-odbc-devel nor mysql-connector-odbc-dev.
There is this: /usr/local/src/freeradius-server-2.1.10/src/modules/rlm_sql/rlm_sql.h
Still not sure how to resolve this.
Ask your distro list/forum/support, the package name can be distro-specific. Or build unixodbc from source. For example, on Ubuntu, it should be unixodbc-dev http://packages.ubuntu.com/search?searchon=contents&keywords=sql.h&mode=exac... -- Fajar
config.log:configure:3082: WARNING: FAILURE: rlm_sql_unixodbc requires: sql.h. ----- Original Message ----- From: "Fajar A. Nugraha" <list@fajar.net> To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org> Sent: Thursday, April 07, 2011 07:30 PM Subject: Re: rlm_sql_unixodbc ?
On Fri, Apr 8, 2011 at 8:13 AM, Jim Rice <jmrice6640@yahoo.com> wrote:
After installing mysql-connector-odbc, running ./configure within rlm_sql_unixodbc it was then able to find: checking for SQLConnect in -lodbc... yes
But not: checking for sql.h... no configure: WARNING: silently not building rlm_sql_unixodbc. configure: WARNING: FAILURE: rlm_sql_unixodbc requires: sql.h.
I ran a find for sql.h and it is not in /usr.
And neither pkg exists for mysql-connector-odbc-devel nor mysql-connector-odbc-dev.
There is this: /usr/local/src/freeradius-server-2.1.10/src/modules/rlm_sql/rlm_sql.h
Still not sure how to resolve this.
Ask your distro list/forum/support, the package name can be distro-specific. Or build unixodbc from source.
For example, on Ubuntu, it should be unixodbc-dev http://packages.ubuntu.com/search?searchon=contents&keywords=sql.h&mode=exac...
-- Fajar - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Found it. I was missing unixODBC-devel Thanks! ----- Original Message ----- From: "Alan DeKok" <aland@deployingradius.com> To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org> Sent: Friday, April 08, 2011 04:02 AM Subject: Re: rlm_sql_unixodbc ?
Jim Rice wrote:
config.log:configure:3082: WARNING: FAILURE: rlm_sql_unixodbc requires: sql.h.
Install the unixodbc software, library, and header files.
Ask the unixodbc people how to do this.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Jim Rice wrote:
I thought I had followed the FR installation instructions and was surprised that something might have been missing.
I think you're misunderstanding *optional* modules. The server comes with plugins for LDAP, SQL (MySQL, PostGreSQL, DB2, Oracle, ...), and many, many, more. However, the build process checks for preconditions. If you don't have MySQL installed, it won't build the MySQL plugin. This shouldn't be a suprise.
How can I know which dependencies are missing? (Which packages to install?)
The Unixodbc headers and libraries. *Read* the "configure" output from the rlm_sql_unixodbc module. It says what it's looking for.
I had already installed mysql-connector-odbc before finding rlm_sql_unixodbc. There were several new library files added, including /usr/lib/libodbc.so.1.0.0 But -lodbc not so much.
"-lodbc" tells the linker to find a file "libodbc*". Please do some reading on how Unix build systems work. Alan DeKok.
participants (4)
-
Alan Buxey -
Alan DeKok -
Fajar A. Nugraha -
Jim Rice