<font color="#333333"><font size="2"><font face="tahoma,sans-serif">Ok,</font></font></font><div><font color="#333333"><font size="2"><font face="tahoma,sans-serif">So Installed freeradius2 from ports on another system, and which is working, then I did pkg_create -Rjb freeradius-2.1.10_2 and got all needed files, transported all to the pfsense machine, did a pkg_add and all installed ok, however when enabling sql I still see error:</font></font></font></div>
<div><font color="#333333"><font size="2"><font face="tahoma,sans-serif"><br></font></font></font></div><div><font color="#333333"><font size="2"><font face="tahoma,sans-serif"><div>Could not link driver rlm_sql_mysql: file not found</div>
<div>Make sure it (and all its dependent libraries!) are in the search path of your system's ld.</div><div>/usr/local/etc/raddb/sql.conf[22]: Instantiation failed for module "sql"</div><div>/usr/local/etc/raddb/sites-enabled/inner-tunnel[131]: Failed to load module "sql".</div>
<div>/usr/local/etc/raddb/sites-enabled/inner-tunnel[47]: Errors parsing authorize section.</div><div><br></div><div>and when I check all fles are in here:</div><div>/usr/local/lib/freeradius-2.1.10</div><div> <a href="http://rlm_sql_mysql-2.1.10.la">rlm_sql_mysql-2.1.10.la</a></div>
<div> rlm_sql_mysql.so</div><div> <a href="http://rlm_sql_mysql.la">rlm_sql_mysql.la</a></div><div> rlm_sql_mysql.a</div><div> <a href="http://rlm_sql_mysql-2.1.10.so">rlm_sql_mysql-2.1.10.so</a></div><div>
<br></div><div>under radiusd.conf the shared lib points to:</div><div><br></div><div>libdir = /usr/local/lib/freeradius-2.1.10</div><div><br></div><div>Any clue as to why it does not see the files?</div><div><br></div><div>
Thanks</div><div><br></div><div><br></div></font></font></font><br><div class="gmail_quote">On Wed, Mar 30, 2011 at 9:12 AM, Franz <span dir="ltr"><<a href="mailto:flamana@gmail.com">flamana@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><font color="#333333"><font size="2"><font face="tahoma,sans-serif">Hi,</font></font></font><div><font color="#333333"><font size="2"><font face="tahoma,sans-serif">Thanks David and Alan for this great advise, I will try it and post back.</font></font></font></div>
<div><font color="#333333"><font size="2"><font face="tahoma,sans-serif"><br></font></font></font></div><div><font color="#333333"><font size="2"><font face="tahoma,sans-serif">Thanks!<br></font></font></font><div><div></div>
<div class="h5"><br><div class="gmail_quote">
On Wed, Mar 30, 2011 at 8:56 AM, David Wood <span dir="ltr"><<a href="mailto:david@wood2.org.uk" target="_blank">david@wood2.org.uk</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi Franz,<br>
<br>
In message <<a href="mailto:AANLkTikH%2Ba1YJDGU5N-TyF-8Xo8_tdE23EqO2V7k%2BYJX@mail.gmail.com" target="_blank">AANLkTikH+a1YJDGU5N-TyF-8Xo8_tdE23EqO2V7k+YJX@mail.gmail.com</a>>, Franz <<a href="mailto:flamana@gmail.com" target="_blank">flamana@gmail.com</a>> writes<div>
<div></div><div><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I have currently installed freeradius 2.1.10 and Mysql 5..5.10 on a pfsense<br>
box which is freebsd. I want this to work with mysql however I was wondering<br>
how to install freeradius with mysql support as I am unable to do it via<br>
ports or try any commands or flags with ./configure via tarball. Only<br>
pkg_add is available, can I recompile or install from scratch to get<br>
freeradius to bind to mysql?<br>
</blockquote>
<br></div></div>
Alan has already given you the answer - you need a development environment. pfSense does not contain compilers and other development tools to keep the image size down.<br>
<br>
Another reason why pfSense does not contain development tools is because it is arguably inappropriate to build software on a firewall. Maybe you are using pfSense for some other task, though if you are using it as a firewall, I would argue strongly that your RADIUS server should be running on another machine inside your firewall.<br>
<br>
<br>
You can't reconfigure a binary package - the configuration is burned in when it is created, usually by the default options. It is nonsense to try to pass configuration flags to pkg_add.<br>
<br>
The default options are always set for minimum external dependencies - if you want features like SQL or LDAP support, you have to set the relevant options yourself and rebuild the package. FreeBSD does not adopt the approach of some Linux distributions, where the additional modules are distributed in separate binary packages.<br>
<br>
<br>
You will need to set the appropriate options for the net/freeradius2 port and build a package using that port on a FreeBSD box of the appropriate release and major version - ideally the minor version should also match, though that doesn't usually matter. You can then pkg_add that package on the pfSense machine.<br>
<br>
<br>
pfSense 2.0 RC is based on FreeBSD 8.1 - amd64 for the 64 bit version and i386 for the 32 bit version.<br>
<br>
pfSense 1.2.3 is based on FreeBSD 7.2 i386.<br>
<br>
<br>
A virtual machine can be useful for building packages if you don't have access to a FreeBSD machine.<br>
<br>
<br>
When I maintained the FreeBSD FreeRADIUS ports, I was asked to create a net/freeradius-mysql slave port for someone working on pfSense. This is FreeRADIUS 1.x and should probably die. It isn't realistic to create slave ports for all the dependencies that people might require - port bloat is frowned on.<br>
<br>
<br>
<br>
With best wishes,<br>
<br>
<br>
<br>
<br>
David<br><font color="#888888">
-- <br>
David Wood<br>
<a href="mailto:david@wood2.org.uk" target="_blank">david@wood2.org.uk</a></font><div><div></div><div><br>
-<br>
List info/subscribe/unsubscribe? See <a href="http://www.freeradius.org/list/users.html" target="_blank">http://www.freeradius.org/list/users.html</a><br>
</div></div></blockquote></div><br></div></div></div>
</blockquote></div><br></div>