Need help on installing FR with postgresql.
Hello! I installed FR in my CentOS 6.2 from source. Doing a radtest on it, works good with files authentication. I try to change the authentication to sql mode, and I get the following error when I start FR: Thu Feb 2 11:30:36 2012 : Error: Could not link driver rlm_sql_postgresql: rlm_sql_postgresql.so: cannot open shared object file: No such file or directory Thu Feb 2 11:30:36 2012 : Error: Make sure it (and all its dependent libraries!) are in the search path of your system's ld. Thu Feb 2 11:30:36 2012 : Error: /netnfork/radius-server//etc/raddb/sql.conf[22]: Instantiation failed for module "sql" Thu Feb 2 11:30:36 2012 : Error: /netnfork/radius-server//etc/raddb/sites-enabled/default[177]: Failed to load module "sql". Thu Feb 2 11:30:36 2012 : Error: /netnfork/radius-server//etc/raddb/sites-enabled/default[69]: Errors parsing authorize section. When I installed the FR, I put a --prefix=/my/path to the ./configure command. The resulted warnings, that are related to my problem, are: ... configure: WARNING: silently not building rlm_sql_postgresql. configure: WARNING: FAILURE: rlm_sql_postgresql requires: libpq-fe.h libpq. ... I want to use FR with postgresql, and I have postgresql installed on my system, and also the FR database is already well done. (I know that because I have a FR installation under the default location. I installed it via yum, and it works good). So, can anybody explain me how to resolve my issue? I tried to install libpq-fe.h, but I didn't find it. I also tried to run the following: # ./configure --prefix=/my/path/ --with-postgresql-include-dir=/usr/pgsql-9.1/lib/ | grep -i WARNING but with the same WARNING. Can anybody help me on this? Thanks! -- View this message in context: http://freeradius.1045715.n5.nabble.com/Need-help-on-installing-FR-with-post... Sent from the FreeRadius - Dev mailing list archive at Nabble.com.
On Thu, Feb 2, 2012 at 4:41 PM, artaxerxe <mapandrei@gmail.com> wrote:
Hello!
I installed FR in my CentOS 6.2 from source.
Why? The package works just fine. You CAN rebuild it to 2.1.12 (or wait until 2.2.0), but really, the bundled version should work fine for most purposes.
configure: WARNING: FAILURE: rlm_sql_postgresql requires: libpq-fe.h libpq.
Do you have those two files?
I also tried to run the following: # ./configure --prefix=/my/path/ --with-postgresql-include-dir=/usr/pgsql-9.1/lib/ | grep -i WARNING but with the same WARNING.
Can anybody help me on this?
I don't have access to RH's spec file right now, but here's what's used on debian/rules: --with-rlm_sql_postgresql_lib_dir=`pg_config --libdir` \ --with-rlm_sql_postgresql_include_dir=`pg_config --includedir` \ -- Fajar
I want to install it from source because I want to have it installed under a specific directory. That's why I try to install it from source. -- View this message in context: http://freeradius.1045715.n5.nabble.com/Need-help-on-installing-FR-with-post... Sent from the FreeRadius - Dev mailing list archive at Nabble.com.
Thanks Alan for reply. I installed postgresql91-devel, restart the system, but get the same errors. -- View this message in context: http://freeradius.1045715.n5.nabble.com/Need-help-on-installing-FR-with-post... Sent from the FreeRadius - Dev mailing list archive at Nabble.com.
On Thu, Feb 2, 2012 at 5:45 PM, artaxerxe <mapandrei@gmail.com> wrote:
Thanks Alan for reply.
I installed postgresql91-devel, restart the system, but get the same errors.
Did you read the rest of the replies, or did you deliberately pick only some parts of it? For example, Alan said "... then re-run configure and rebuild" while I said "...here's what's used on debian/rules: --with-rlm_sql_postgresql_lib_dir=`pg_config --libdir` \ --with-rlm_sql_postgresql_include_dir=`pg_config --includedir` \ " Note how neither of us said "restart the system"? -- Fajar
Yes, I have read it. Just that in your response, I thought that you are specifying a "fix value", not the "meaning" of what you called. Anyway, I beg your pardon, but I think it would be beter to say: --with-rlm_sql_postgresql_lib_dir=`/path/to/postgres/libraries/dir` Thanks anyway! -- View this message in context: http://freeradius.1045715.n5.nabble.com/Need-help-on-installing-FR-with-post... Sent from the FreeRadius - Dev mailing list archive at Nabble.com.
After some researches, I solved the problem. The command is: ./configure --prefix=/my/path --with-rlm-sql_postgresql-include-dir=/usr/pgsql-9.1/include --with-rlm-sql-postgresql-lib-dir=/usr/pgsql-9.1/lib This is due to the fact that by default, FR specifies the postgres includes directory as /usr/include/psql and libraries directory as /usr/lib. And this is what makes installation to fail. -- View this message in context: http://freeradius.1045715.n5.nabble.com/Need-help-on-installing-FR-with-post... Sent from the FreeRadius - Dev mailing list archive at Nabble.com.
participants (3)
-
Alan Buxey -
artaxerxe -
Fajar A. Nugraha