NEW Package: freeRADIUS 2.x

Nachtfalke

well, with krb5 compiled without thousand of deps ???

can you try this package features on lab with x64 pfsense?

x64
pkg_add -r http://e-sac.siteseguro.ws/packages/amd64/8/All/freeradius-2.1.12.tbz

I did this on a fresh 2.0.1 x64 vm:

[2.0.1-RELEASE][admin@pfsense.localdomain]/root(3): pkg_info
bsdinstaller-2.0.2011.0913 BSD Installer mega-package
gettext-0.18.1.1    GNU gettext package
libiconv-1.13.1_1   A character set conversion library
[2.0.1-RELEASE][admin@pfsense.localdomain]/root(4): pkg_add -r http://e-sac.siteseguro.ws/packages/amd64/8/All/freeradius-2.1.12.tbz
Fetching http://e-sac.siteseguro.ws/packages/amd64/8/All/freeradius-2.1.12.tbz... Done.
Fetching http://e-sac.siteseguro.ws/packages/amd64/8/All/krb5-1.9.2_1.tbz... Done.
Fetching http://e-sac.siteseguro.ws/packages/amd64/8/All/python27-2.7.2_3.tbz... Done.

====
Note that some of the standard modules are provided as separate
ports since they require extra dependencies:

bsddb           databases/py-bsddb
gdbm            databases/py-gdbm
sqlite3         databases/py-sqlite3
tkinter         x11-toolkits/py-tkinter

Install them as needed.
====

Error: Unable to get http://e-sac.siteseguro.ws/packages/amd64/8/All/perl-5.12.4_3.tbz: Not Found
Fetching http://e-sac.siteseguro.ws/packages/amd64/8/All/libltdl-2.4_1.tbz... Done.
Error: Unable to get http://e-sac.siteseguro.ws/packages/amd64/8/All/gdbm-1.9.1.tbz: Not Found
===> Setting user and group in radiusd.conf
===> Creating users and/or groups.
Creating group 'freeradius' with gid '133'.
Creating user 'freeradius' with uid '133'.
===> Bootstrapping default certificates, please wait...
===> Adjusting ownership of directory /usr/local/etc/raddb
===> Adjusting ownership of directory /var/log/radacct
===> Adjusting ownership of directory /var/run/radiusd
===> Adjusting ownership of /var/log/radius.log
===> Adjusting ownership of /var/log/radutmp
===> Adjusting ownership of /var/log/radwtmp
===> Updating libdir in /usr/local/etc/raddb/radiusd.conf
pkg_add: can't open dependency file '/var/db/pkg/perl-5.12.4_3/+REQUIRED_BY'!
dependency registration is incomplete
pkg_add: can't open dependency file '/var/db/pkg/gdbm-1.9.1/+REQUIRED_BY'!
dependency registration is incomplete

===============================================================================

To enable FreeRADIUS, put the following line in /etc/rc.conf

radiusd_enable="YES"

The sample configuration can be found at
/usr/local/share/examples/freeradius/raddb

If you are upgrading FreeRADIUS, you are advised to use this as a reference
for updating your configuration.

FreeRADIUS will look for its configuration directory at
/usr/local/etc/raddb by default.

If you did not already have a configuration at this location, the sample
configuration has been copied to this location and has been bootstrapped.

If you wish to point FreeRADIUS to a configuration at a different
location, put the following line in /etc/rc.conf

radiusd_flags="-d /path/to/raddb"

To start the server in normal (daemon) mode, run:

/usr/local/etc/rc.d/radiusd start

and to stop the server, run:

/usr/local/etc/rc.d/radiusd stop

To start the server in debugging mode, run:

/usr/local/etc/rc.d/radiusd debug

You are advised to make cautious changes to the configuration, and to test
frequently, using debugging mode where necessary. Try to resist the
temptation to disable or delete things that you don't understand - you may
well break things!

The documentation has been installed at /usr/local/share/doc/freeradius

Useful configuration advice can be found in the FreeRADIUS Wiki at
http://wiki.freeradius.org

===============================================================================

The only two errors I could see are:

Error: Unable to get http://e-sac.siteseguro.ws/packages/amd64/8/All/perl-5.12.4_3.tbz: Not Found
Error: Unable to get http://e-sac.siteseguro.ws/packages/amd64/8/All/gdbm-1.9.1.tbz: Not Found

Just tried to start it an is runs:

[2.0.1-RELEASE][admin@pfsense.localdomain]/root(6): /usr/local/etc/rc.d/radiusd onestart
Starting radiusd.
[2.0.1-RELEASE][admin@pfsense.localdomain]/root(7): /usr/local/etc/rc.d/radiusd onestatus
radiusd is running as pid 28705.
[2.0.1-RELEASE][admin@pfsense.localdomain]/root(8): ps -ax | grep radiusd
28705  ??  Ss     0:00.00 /usr/local/sbin/radiusd
[2.0.1-RELEASE][admin@pfsense.localdomain]/root(9): ps -auwx | grep radiusd
freeradius 28705  0.0  0.6 43020  6180  ??  Is    1:48AM   0:00.00 /usr/local/sbin/radiusd

I did a "ldd rlm_krb5.so":

[2.0.1-RELEASE][admin@pfsense.localdomain]/usr/local/lib/freeradius-2.1.12(8): ldd rlm_krb5.so
rlm_krb5.so:
        libfreeradius-radius-2.1.12.so => /usr/local/lib/freeradius-2.1.12/libfreeradius-radius-2.1.12.so (0x800c00000)
        libkrb5.so => /usr/local/lib/libkrb5.so (0x800d21000)
        libcom_err.so => /usr/lib/libcom_err.so (0x800eef000)
        libk5crypto.so => /usr/local/lib/libk5crypto.so (0x800ff1000)
        libthr.so.3 => /lib/libthr.so.3 (0x80111b000)
        libc.so.7 => /lib/libc.so.7 (0x800646000)
        libkrb5support.so => /usr/local/lib/libkrb5support.so (0x801233000)

And this for ldap, mysql and pgsql:

[2.0.1-RELEASE][admin@pfsense.localdomain]/usr/local/lib/freeradius-2.1.12(10): ldd rlm_sql_postgresql-2.1.12.so
rlm_sql_postgresql-2.1.12.so:
        libpq.so.5 => not found (0x0)
        libthr.so.3 => /lib/libthr.so.3 (0x800c00000)
        libc.so.7 => /lib/libc.so.7 (0x800646000)
[2.0.1-RELEASE][admin@pfsense.localdomain]/usr/local/lib/freeradius-2.1.12(11): ldd rlm_sql_mysql.so
rlm_sql_mysql.so:
        libmysqlclient.so.18 => not found (0x0)
        libz.so.5 => /lib/libz.so.5 (0x800c00000)
        libm.so.5 => /lib/libm.so.5 (0x800d15000)
        libthr.so.3 => /lib/libthr.so.3 (0x800e34000)
        libc.so.7 => /lib/libc.so.7 (0x800646000)
[2.0.1-RELEASE][admin@pfsense.localdomain]/usr/local/lib/freeradius-2.1.12(12): ldd rlm_ldap.so
rlm_ldap.so:
        libfreeradius-radius-2.1.12.so => /usr/local/lib/freeradius-2.1.12/libfreeradius-radius-2.1.12.so (0x800c00000)
        libldap_r-2.4.so.8 => not found (0x0)
        liblber-2.4.so.8 => /usr/local/lib/liblber-2.4.so.8 (0x800d21000)
        libsasl2.so.2 => not found (0x0)
        libssl.so.6 => /usr/lib/libssl.so.6 (0x800e2e000)
        libcrypto.so.6 => /lib/libcrypto.so.6 (0x800f80000)
        libthr.so.3 => /lib/libthr.so.3 (0x80121a000)
        libc.so.7 => /lib/libc.so.7 (0x800646000)

marcelloc

I've just uploaded missing packages, can you try again?

Maybe it's better removing freeradius packages first

Nachtfalke

@marcelloc:

I've just uploaded missing packages, can you try again?

Maybe it's better removing freeradius packages first

Of course I can.
I reverted the vm to basic pfsense install:

[2.0.1-RELEASE][admin@pfsense.localdomain]/root(3): pkg_info
bsdinstaller-2.0.2011.0913 BSD Installer mega-package
gettext-0.18.1.1    GNU gettext package
libiconv-1.13.1_1   A character set conversion library
[2.0.1-RELEASE][admin@pfsense.localdomain]/root(4): pkg_add -r http://e-sac.siteseguro.ws/packages/amd64/8/All/freeradius-2.1.12.tbz
Fetching http://e-sac.siteseguro.ws/packages/amd64/8/All/freeradius-2.1.12.tbz... Done.
Fetching http://e-sac.siteseguro.ws/packages/amd64/8/All/krb5-1.9.2_1.tbz... Done.
Fetching http://e-sac.siteseguro.ws/packages/amd64/8/All/python27-2.7.2_3.tbz... Done.

====
Note that some of the standard modules are provided as separate
ports since they require extra dependencies:

bsddb           databases/py-bsddb
gdbm            databases/py-gdbm
sqlite3         databases/py-sqlite3
tkinter         x11-toolkits/py-tkinter

Install them as needed.
====

Fetching http://e-sac.siteseguro.ws/packages/amd64/8/All/perl-5.12.4_3.tbz... Done.
Removing stale symlinks from /usr/bin...
    Skipping /usr/bin/perl
    Skipping /usr/bin/perl5
Done.
Creating various symlinks in /usr/bin...
    Symlinking /usr/local/bin/perl5.12.4 to /usr/bin/perl
    Symlinking /usr/local/bin/perl5.12.4 to /usr/bin/perl5
Done.
cd: can't cd to /usr/include
Cleaning up /etc/make.conf... Done.
Spamming /etc/make.conf... Done.
Fetching http://e-sac.siteseguro.ws/packages/amd64/8/All/libltdl-2.4_1.tbz... Done.
Fetching http://e-sac.siteseguro.ws/packages/amd64/8/All/gdbm-1.9.1.tbz... Done.
===> Setting user and group in radiusd.conf
===> Creating users and/or groups.
Creating group 'freeradius' with gid '133'.
Creating user 'freeradius' with uid '133'.
===> Bootstrapping default certificates, please wait...
===> Adjusting ownership of directory /usr/local/etc/raddb
===> Adjusting ownership of directory /var/log/radacct
===> Adjusting ownership of directory /var/run/radiusd
===> Adjusting ownership of /var/log/radius.log
===> Adjusting ownership of /var/log/radutmp
===> Adjusting ownership of /var/log/radwtmp
===> Updating libdir in /usr/local/etc/raddb/radiusd.conf

===============================================================================

To enable FreeRADIUS, put the following line in /etc/rc.conf

radiusd_enable="YES"

The sample configuration can be found at
/usr/local/share/examples/freeradius/raddb

If you are upgrading FreeRADIUS, you are advised to use this as a reference
for updating your configuration.

FreeRADIUS will look for its configuration directory at
/usr/local/etc/raddb by default.

If you did not already have a configuration at this location, the sample
configuration has been copied to this location and has been bootstrapped.

If you wish to point FreeRADIUS to a configuration at a different
location, put the following line in /etc/rc.conf

radiusd_flags="-d /path/to/raddb"

To start the server in normal (daemon) mode, run:

/usr/local/etc/rc.d/radiusd start

and to stop the server, run:

/usr/local/etc/rc.d/radiusd stop

To start the server in debugging mode, run:

/usr/local/etc/rc.d/radiusd debug

You are advised to make cautious changes to the configuration, and to test
frequently, using debugging mode where necessary. Try to resist the
temptation to disable or delete things that you don't understand - you may
well break things!

The documentation has been installed at /usr/local/share/doc/freeradius

Useful configuration advice can be found in the FreeRADIUS Wiki at
http://wiki.freeradius.org

===============================================================================

[2.0.1-RELEASE][admin@pfsense.localdomain]/root(5):

Radiusd is running:

[2.0.1-RELEASE][admin@pfsense.localdomain]/root(5): ps -ax | grep radiusd
[2.0.1-RELEASE][admin@pfsense.localdomain]/root(6): /usr/local/etc/rc.d/radiusd onestart
Starting radiusd.
[2.0.1-RELEASE][admin@pfsense.localdomain]/root(7): /usr/local/etc/rc.d/radiusd onestatus
radiusd is running as pid 7247.
[2.0.1-RELEASE][admin@pfsense.localdomain]/root(8): ps -auwx | grep radiusd
freeradius  7247  0.0  0.6 43020  6184  ??  Ss   12:49PM   0:00.00 /usr/local/sbin/radiusd
[2.0.1-RELEASE][admin@pfsense.localdomain]/root(9):

ldd on the new added modules:

[2.0.1-RELEASE][admin@pfsense.localdomain]/usr/local/lib/freeradius-2.1.12(11): ldd rlm_krb5.so
rlm_krb5.so:
        libfreeradius-radius-2.1.12.so => /usr/local/lib/freeradius-2.1.12/libfreeradius-radius-2.1.12.so (0x800c00000)
        libkrb5.so => /usr/local/lib/libkrb5.so (0x800d21000)
        libcom_err.so => /usr/lib/libcom_err.so (0x800eef000)
        libk5crypto.so => /usr/local/lib/libk5crypto.so (0x800ff1000)
        libthr.so.3 => /lib/libthr.so.3 (0x80111b000)
        libc.so.7 => /lib/libc.so.7 (0x800646000)
        libkrb5support.so => /usr/local/lib/libkrb5support.so (0x801233000)
[2.0.1-RELEASE][admin@pfsense.localdomain]/usr/local/lib/freeradius-2.1.12(12): ldd rlm_sql.so
rlm_sql.so:
        libfreeradius-radius-2.1.12.so => /usr/local/lib/freeradius-2.1.12/libfreeradius-radius-2.1.12.so (0x800c00000)
        libltdl.so.7 => /usr/local/lib/libltdl.so.7 (0x800d21000)
        libthr.so.3 => /lib/libthr.so.3 (0x800e2a000)
        libc.so.7 => /lib/libc.so.7 (0x800646000)
[2.0.1-RELEASE][admin@pfsense.localdomain]/usr/local/lib/freeradius-2.1.12(13): ldd rlm_sql_log.so
rlm_sql_log.so:
        libfreeradius-radius-2.1.12.so => /usr/local/lib/freeradius-2.1.12/libfreeradius-radius-2.1.12.so (0x800c00000)
        libthr.so.3 => /lib/libthr.so.3 (0x800d21000)
        libc.so.7 => /lib/libc.so.7 (0x800646000)
[2.0.1-RELEASE][admin@pfsense.localdomain]/usr/local/lib/freeradius-2.1.12(14): ldd rlm_sql_mysql.so
rlm_sql_mysql.so:
        libmysqlclient.so.18 => not found (0x0)
        libz.so.5 => /lib/libz.so.5 (0x800c00000)
        libm.so.5 => /lib/libm.so.5 (0x800d15000)
        libthr.so.3 => /lib/libthr.so.3 (0x800e34000)
        libc.so.7 => /lib/libc.so.7 (0x800646000)
[2.0.1-RELEASE][admin@pfsense.localdomain]/usr/local/lib/freeradius-2.1.12(15): ldd rlm_sql_postgresql.so
rlm_sql_postgresql.so:
        libpq.so.5 => not found (0x0)
        libthr.so.3 => /lib/libthr.so.3 (0x800c00000)
        libc.so.7 => /lib/libc.so.7 (0x800646000)
[2.0.1-RELEASE][admin@pfsense.localdomain]/usr/local/lib/freeradius-2.1.12(16): ldd rlm_ldap.so
rlm_ldap.so:
        libfreeradius-radius-2.1.12.so => /usr/local/lib/freeradius-2.1.12/libfreeradius-radius-2.1.12.so (0x800c00000)
        libldap_r-2.4.so.8 => not found (0x0)
        liblber-2.4.so.8 => /usr/local/lib/liblber-2.4.so.8 (0x800d21000)
        libsasl2.so.2 => not found (0x0)
        libssl.so.6 => /usr/lib/libssl.so.6 (0x800e2e000)
        libcrypto.so.6 => /lib/libcrypto.so.6 (0x800f80000)
        libthr.so.3 => /lib/libthr.so.3 (0x80121a000)
        libc.so.7 => /lib/libc.so.7 (0x800646000)
[2.0.1-RELEASE][admin@pfsense.localdomain]/usr/local/lib/freeradius-2.1.12(17):

marcelloc

Missing dependencies are:

libmysqlclient.so.18 => not found (0x0)
libpq.so.5 => not found (0x0)
libldap_r-2.4.so.8 => not found (0x0)
libpq.so.5 => not found (0x0)

Did you find any other?

Nachtfalke

@marcelloc:

Missing dependencies are:

libmysqlclient.so.18 => not found (0x0)
libpq.so.5 => not found (0x0)
libldap_r-2.4.so.8 => not found (0x0)
libpq.so.5 => not found (0x0)

Did you find any other?

I only checked these few modules. I will check the others and post back in some minutes!

marcelloc

see if these packages reduces missing dependencies

pkg_add -r http://e-sac.siteseguro.ws/packages/amd64/8/All/mysql-client-5.1.60.tbz
pkg_add -r http://e-sac.siteseguro.ws/packages/amd64/8/All/cyrus-sasl-2.1.25_1.tbz
pkg_add -r http://e-sac.siteseguro.ws/packages/amd64/8/All/openldap-sasl-client-2.4.26.tbz

Nachtfalke

I found this is missing in ldap.so, too:


libsasl2.so.2 => not found (0x0)

Ok, I tested many other modules I know that they are used and there seems to be all ok.

PS: Can you make "WITHOUT_USERS" ? Or will we do this later in pkg_config.8.xml ?

–-- saw your edit ----

This fixed the missing dependency I posted above but with errors:

[2.0.1-RELEASE][admin@pfsense.localdomain]/usr/local/lib/freeradius-2.1.12(86): pkg_add -r http://e-sac.siteseguro.ws/packages/amd64/8/All/cyrus-sasl-2.1.25_1.tbz
Fetching http://e-sac.siteseguro.ws/packages/amd64/8/All/cyrus-sasl-2.1.25_1.tbz... Done.
*** Added group `cyrus' (id 60)
*** Added user `cyrus' (id 60)
/libexec/ld-elf.so.1: Shared object "libgssapi.so.10" not found, required by "saslpasswd2"
/libexec/ld-elf.so.1: Shared object "libgssapi.so.10" not found, required by "sasldblistusers2"
WARNING: Failed to create /usr/local/etc/sasldb2.db

You can use sasldb2 for authentication, to add users use:

        saslpasswd2 -c username

If you want to enable SMTP AUTH with the system Sendmail, read
Sendmail.README

NOTE: This port has been compiled with a default pwcheck_method of
      auxprop.  If you want to authenticate your user by /etc/passwd,
      PAM or LDAP, install ports/security/cyrus-sasl2-saslauthd and
      set sasl_pwcheck_method to saslauthd after installing the
      Cyrus-IMAPd 2.X port.  You should also check the
      /usr/local/lib/sasl2/*.conf files for the correct
      pwcheck_method.

[2.0.1-RELEASE][admin@pfsense.localdomain]/usr/local/lib/freeradius-2.1.12(87): ldd rlm_ldap.so
rlm_ldap.so:
        libfreeradius-radius-2.1.12.so => /usr/local/lib/freeradius-2.1.12/libfreeradius-radius-2.1.12.so (0x800c00000)
        libldap_r-2.4.so.8 => not found (0x0)
        liblber-2.4.so.8 => /usr/local/lib/liblber-2.4.so.8 (0x800d21000)
        libsasl2.so.2 => /usr/local/lib/libsasl2.so.2 (0x800e2e000)
        libssl.so.6 => /usr/lib/libssl.so.6 (0x800f48000)
        libcrypto.so.6 => /lib/libcrypto.so.6 (0x80109a000)
        libthr.so.3 => /lib/libthr.so.3 (0x801334000)
        libc.so.7 => /lib/libc.so.7 (0x800646000)
[2.0.1-RELEASE][admin@pfsense.localdomain]/usr/local/lib/freeradius-2.1.12(88):

mysql-client didn't fix anything. Still missing:

libmysqlclient.so.18 => not found (0x0)

openldap-sasl-client fixed the missing rlm_ldap.so dependency.

So just these two are still missing: (PGSQL, SQL and MySQL)

libmysqlclient.so.18 => not found (0x0)
libpq.so.5 => not found (0x0)

[2.0.1-RELEASE][admin@pfsense.localdomain]/usr/local/lib/freeradius-2.1.12(98): ldd rlm_sql_mysql.so
rlm_sql_mysql.so:
        libmysqlclient.so.18 => not found (0x0)
        libz.so.5 => /lib/libz.so.5 (0x800c00000)
        libm.so.5 => /lib/libm.so.5 (0x800d15000)
        libthr.so.3 => /lib/libthr.so.3 (0x800e34000)
        libc.so.7 => /lib/libc.so.7 (0x800646000)
[2.0.1-RELEASE][admin@pfsense.localdomain]/usr/local/lib/freeradius-2.1.12(99): ldd rlm_sql_postgresql.so
rlm_sql_postgresql.so:
        libpq.so.5 => not found (0x0)
        libthr.so.3 => /lib/libthr.so.3 (0x800c00000)
        libc.so.7 => /lib/libc.so.7 (0x800646000)

marcelloc

Copy sasl missing deps from this folder
http://e-sac.siteseguro.ws/pfsense/8/amd64/All/ldd/

The dest folder maybe /usr/local/lib

Nachtfalke

Which version of mysql-client did you choose ? pkg_info says 5.1.60

If did:


pkg_add -f ftp://ftp.freebsd.org/pub/FreeBSD/ports/amd64/packages-8-stable/All/mysql-client-5.5.19.tbz

This seems to fix the missing libmysqlclient.so.18:

[2.0.1-RELEASE][admin@pfsense.localdomain]/usr/local/lib/freeradius-2.1.12(43): ldd rlm_sql_mysql.so
rlm_sql_mysql.so:
        libmysqlclient.so.18 => /usr/local/lib/mysql/libmysqlclient.so.18 (0x800c00000)
        libz.so.5 => /lib/libz.so.5 (0x801035000)
        libm.so.5 => /lib/libm.so.5 (0x80114a000)
        libthr.so.3 => /lib/libthr.so.3 (0x801269000)
        libc.so.7 => /lib/libc.so.7 (0x800646000)
        libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0x801381000)
        libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x80158c000)

This command gave me before just .15.so and .16.so but not the recommended .18.so

[2.0.1-RELEASE][admin@pfsense.localdomain]/usr/local/lib/freeradius-2.1.12(45): ldconfig -r | grep 'mysql'
        search directories: /usr/lib:/usr/local/lib:/lib:/usr/local/lib/freeradius-2.1.12:/usr/local/lib/mysql
        127:-lmysqlclient.15 => /usr/local/lib/mysql/libmysqlclient.so.15
        128:-lmysqlclient.16 => /usr/local/lib/mysql/libmysqlclient.so.16
        129:-lmysqlclient_r.16 => /usr/local/lib/mysql/libmysqlclient_r.so.16
        130:-lmysqlclient.18 => /usr/local/lib/mysql/libmysqlclient.so.18
        131:-lmysqlclient_r.18 => /usr/local/lib/mysql/libmysqlclient_r.so.18

Nachtfalke

And this fixed the PGSQL:


[2.0.1-RELEASE][admin@pfsense.localdomain]/usr/local/lib/freeradius-2.1.12(57): pkg_add -r ftp://ftp.freebsd.org/pub/FreeBSD/ports/amd64/packages-8-stable/All/postgresql-client-9.1.2.tbz
Fetching ftp://ftp.freebsd.org/pub/FreeBSD/ports/amd64/packages-8-stable/All/postgresql-client-9.1.2.tbz... Done.
Fetching ftp://ftp.freebsd.org/pub/FreeBSD/ports/amd64/packages-8-stable/All/pkg-config-0.25_1.tbz... Done.
Fetching ftp://ftp.freebsd.org/pub/FreeBSD/ports/amd64/packages-8-stable/All/libxml2-2.7.8_1.tbz... Done.

The PostgreSQL port has a collection of "side orders":

postgresql-docs
  For all of the html documentation

p5-Pg
  A perl5 API for client access to PostgreSQL databases.

postgresql-tcltk
  If you want tcl/tk client support.

postgresql-jdbc
  For Java JDBC support.

postgresql-odbc
  For client access from unix applications using ODBC as access
  method. Not needed to access unix PostgreSQL servers from Win32
  using ODBC. See below.

ruby-postgres, py-PyGreSQL
  For client access to PostgreSQL databases using the ruby & python
  languages.

p5-postgresql-plperl, postgresql-pltcl & postgresql-plruby
  For using perl5, tcl & ruby as procedural languages.

postgresql-contrib
  Lots of contributed utilities, postgresql functions and
  datatypes. There you find pg_standby, pgcrypto and many other cool
  things.

etc...

[2.0.1-RELEASE][admin@pfsense.localdomain]/usr/local/lib/freeradius-2.1.12(58): ldd rlm_sql_postgresql.so                                                    rlm_sql_postgresql.so:
        libpq.so.5 => /usr/local/lib/libpq.so.5 (0x800c00000)
        libthr.so.3 => /lib/libthr.so.3 (0x800d29000)
        libc.so.7 => /lib/libc.so.7 (0x800646000)
        libintl.so.9 => /usr/local/lib/libintl.so.9 (0x800e41000)
        libssl.so.6 => /usr/lib/libssl.so.6 (0x800f4a000)
        libcrypto.so.6 => /lib/libcrypto.so.6 (0x80109c000)
        libiconv.so.3 => /usr/local/lib/libiconv.so.3 (0x801336000)
[2.0.1-RELEASE][admin@pfsense.localdomain]/usr/local/lib/freeradius-2.1.12(59):

marcelloc

@Nachtfalke:

Which version of mysql-client did you choose ? pkg_info says 5.1.60

I'll change it to 5.5

Nachtfalke

As long as you are doing all my work - please let me know if I could help you at least a bit :P

marcelloc

@Nachtfalke:

As long as you are doing all my work -

That's fun :D

Instead of pcbsd, try a pure freebsd.

please let me know if I could help you at least a bit :P

we are helping each other. I compile and you check dependencies

tritron

Is it posible to use existing users of activedirectory in this package ? Pfsense comes with certeficate managment and user list and works with active directory and also freeradius supports active directory.
So would be nice to remove certiificate option and user option and just use pfsense user list or other servers that are listed in user settings in pfsense. Does the current package supports active directory if i edit config by hand or the module is not compiled in ?

marcelloc

@tritron:

Does the current package supports active directory if i edit config by hand or the module is not compiled in ?

That's what we is trying to do. ;)

For now it's not supported as we are compiling freeradius with kerberos and etc.

After binaries are ok, Nachtfalke will continue package update.

marcelloc

Nachtfalke,

mysql5.5 and postgres9.1.2 are uploaded.

I'm also doind this job to i386 the link is

http://e-sac.siteseguro.ws/packages/8/All/

Nachtfalke

Okay, then I will reset my VMs and test. :)

Nachtfalke

Feedback for tested machine pfsense 2.0.1 amd64:
This installs without errors or missing dependencies:
http://e-sac.siteseguro.ws/packages/amd64/8/All/freeradius-2.1.12.tbz

I need to manually install these packages because ldap and *sql have missing files.

pkg_add -r http://e-sac.siteseguro.ws/packages/amd64/8/All/mysql-client-5.1.60.tbz
pkg_add -r http://e-sac.siteseguro.ws/packages/amd64/8/All/cyrus-sasl-2.1.25_1.tbz
pkg_add -r http://e-sac.siteseguro.ws/packages/amd64/8/All/openldap-sasl-client-2.4.26.tbz

Still the (minor) error with this package:
http://e-sac.siteseguro.ws/packages/amd64/8/All/cyrus-sasl-2.1.25_1.tbz

[2.0.1-RELEASE][admin@pfsense.localdomain]/root(13): pkg_add -r http://e-sac.siteseguro.ws/packages/8/All/cyrus-sasl-2.1.25_1.tbz
Fetching http://e-sac.siteseguro.ws/packages/8/All/cyrus-sasl-2.1.25_1.tbz... Done.
Fetching http://e-sac.siteseguro.ws/packages/8/All/db41-4.1.25_4.tbz... Done.
*** Added group `cyrus' (id 60)
*** Added user `cyrus' (id 60)
/libexec/ld-elf.so.1: Shared object "libgssapi.so.10" not found, required by "saslpasswd2"
/libexec/ld-elf.so.1: Shared object "libgssapi.so.10" not found, required by "sasldblistusers2"
WARNING: Failed to create /usr/local/etc/sasldb2

You can use sasldb2 for authentication, to add users use:

        saslpasswd2 -c username

If you want to enable SMTP AUTH with the system Sendmail, read
Sendmail.README

NOTE: This port has been compiled with a default pwcheck_method of
      auxprop.  If you want to authenticate your user by /etc/passwd,
      PAM or LDAP, install ports/security/cyrus-sasl2-saslauthd and
      set sasl_pwcheck_method to saslauthd after installing the
      Cyrus-IMAPd 2.X port.  You should also check the
      /usr/local/lib/sasl2/*.conf files for the correct
      pwcheck_method.

After installing all above I can start radiusd. This is what I tested:
plain users file authentication using "radtest" tool.
Authentication works.

I enabled ldap and configured users file to only use ldap to authenticate users:
freeradius is starting, loading the ldap modules and default configuration. I have tested with "radtest" tool and the radius tries to connect to ldap. I do not have any LDAP/AD configured so I could not finally test that. But it looks like it should work.

I disabled ldap and enabled sql.
using "MYSQL" as datasbase and "POSTGRESSQL" is working. I still have no database to test but I did the tests from ldap and freeradius tries to connect to sql database.

We didn't compile ORACLE because this is still experimental.
Something what is a bit strange is that I could choose "MSSQL" in sql.conf but the there is the rlm_sql_mssql.sq module missing. But there is no build option in Makefile for this database support. Perhaps we could think about that in future versions but not at the moment.

Kerberos module has all dependencies but could not test it. Kerberos together with samba to use MS AD to authenticate.
That is something what isn't really clear for me at the moment and the freeradius documentation isn't, too. Is the ldap module enough to connect to an MS AD or do we really need to go the way using kerberos and samba. perhaps the second way is the way which fully sopports MS AD. As far as I know Windows Server 2003 and high have the ability to communicate with the LDAP protocol.
But there is nothing we can do now - I think.

I will go on testing i386 as I did it with amd64.

marcelloc

The missing Shared object are not related to cyrus packages but on files not included in pfSense. That why I created a folder with missing libs

It's easy to work around in xml instalation.

cyrus is also used in postfix for authentication in smtp.

Nachtfalke

@marcelloc:

The missing Shared object are not related to cyrus packages but on files not included in pfSense. That why I created a folder with missing libs

It's easy to work around in xml instalation.

cyrus is also used in postfix for authentication in smtp.

Yes, we can use "additionalfilesneeded" right ?

i386:
It is not build with PostgreSQL.
And "openldap-sasl-client-2.4.26.tbz" is missing on your server.
"Cyrus-sasl" installs fine when I add the "ldd" files before.
krb5 is ok with dependencies, mysql is too.

Puhhh, that was really hard work on this package…for you :P
But great job till now. SQL and LDAP support will make this package interesting for some people :)