Netgate Discussion Forum
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Search
    • Register
    • Login

    NEW Package: freeRADIUS 2.x

    Scheduled Pinned Locked Moved pfSense Packages
    628 Posts 80 Posters 757.0k Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • marcellocM
      marcelloc
      last edited by

      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

      Treinamentos de Elite: http://sys-squad.com

      Help a community developer! ;D

      1 Reply Last reply Reply Quote 0
      • N
        Nachtfalke
        last edited by

        @marcelloc:

        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)
        1 Reply Last reply Reply Quote 0
        • marcellocM
          marcelloc
          last edited by

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

          Maybe it's better removing freeradius packages first

          Treinamentos de Elite: http://sys-squad.com

          Help a community developer! ;D

          1 Reply Last reply Reply Quote 0
          • N
            Nachtfalke
            last edited by

            @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):
            1 Reply Last reply Reply Quote 0
            • marcellocM
              marcelloc
              last edited by

              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?

              Treinamentos de Elite: http://sys-squad.com

              Help a community developer! ;D

              1 Reply Last reply Reply Quote 0
              • N
                Nachtfalke
                last edited by

                @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!

                1 Reply Last reply Reply Quote 0
                • marcellocM
                  marcelloc
                  last edited by

                  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

                  Treinamentos de Elite: http://sys-squad.com

                  Help a community developer! ;D

                  1 Reply Last reply Reply Quote 0
                  • N
                    Nachtfalke
                    last edited by

                    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)
                    1 Reply Last reply Reply Quote 0
                    • marcellocM
                      marcelloc
                      last edited by

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

                      The dest folder maybe /usr/local/lib

                      Treinamentos de Elite: http://sys-squad.com

                      Help a community developer! ;D

                      1 Reply Last reply Reply Quote 0
                      • N
                        Nachtfalke
                        last edited by

                        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
                        1 Reply Last reply Reply Quote 0
                        • N
                          Nachtfalke
                          last edited by

                          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):
                          1 Reply Last reply Reply Quote 0
                          • marcellocM
                            marcelloc
                            last edited by

                            @Nachtfalke:

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

                            I'll change it to 5.5

                            Treinamentos de Elite: http://sys-squad.com

                            Help a community developer! ;D

                            1 Reply Last reply Reply Quote 0
                            • N
                              Nachtfalke
                              last edited by

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

                              1 Reply Last reply Reply Quote 0
                              • marcellocM
                                marcelloc
                                last edited by

                                @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

                                Treinamentos de Elite: http://sys-squad.com

                                Help a community developer! ;D

                                1 Reply Last reply Reply Quote 0
                                • T
                                  tritron
                                  last edited by

                                  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 ?

                                  1 Reply Last reply Reply Quote 0
                                  • marcellocM
                                    marcelloc
                                    last edited by

                                    @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.

                                    Treinamentos de Elite: http://sys-squad.com

                                    Help a community developer! ;D

                                    1 Reply Last reply Reply Quote 0
                                    • marcellocM
                                      marcelloc
                                      last edited by

                                      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/

                                      Treinamentos de Elite: http://sys-squad.com

                                      Help a community developer! ;D

                                      1 Reply Last reply Reply Quote 0
                                      • N
                                        Nachtfalke
                                        last edited by

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

                                        1 Reply Last reply Reply Quote 0
                                        • N
                                          Nachtfalke
                                          last edited by

                                          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.

                                          1 Reply Last reply Reply Quote 0
                                          • marcellocM
                                            marcelloc
                                            last edited by

                                            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.

                                            Treinamentos de Elite: http://sys-squad.com

                                            Help a community developer! ;D

                                            1 Reply Last reply Reply Quote 0
                                            • First post
                                              Last post
                                            Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.