Problem mit Freeradius und SQL Modul

[Serow]

Hi,

ich versucht mich gerade an FreeRadius und der Anbindung an MySQL. Beim starten von FreeRadius sagt er mir folgendes:

Sun Oct  2 15:19:56 2011 : Error: /etc/freeradius/sites-enabled/default[159]: Failed to load module "sql".
Sun Oct  2 15:19:56 2011 : Error: /etc/freeradius/sites-enabled/default[62]: Errors parsing authorize section.

Hier erstmal die sites-enabled/default:

authorize {
        preprocess
        chap
        mschap
        digest
        suffix
        eap {
                ok = return
        }
        sql
        expiration
        logintime
        pap
}
authenticate {
        Auth-Type PAP {
                pap
        }
        Auth-Type CHAP {
                chap
        }
        Auth-Type MS-CHAP {
                mschap
        }
        digest
        unix
        eap
}
preacct {
        preprocess
        acct_unique
        suffix
        files
}
accounting {
        detail
        unix
        radutmp
        sql
        exec
        attr_filter.accounting_response
}
session {
        radutmp
        sql
}
post-auth {
        sql
        exec
        Post-Auth-Type REJECT {
                attr_filter.access_reject
        }
}
pre-proxy {
}
post-proxy {
        eap
}

Auffällig für mich ist ermal dass, in /etc/freeradius/modules kein sql Modul liegt:

root@hotspot:~# ls -l /etc/freeradius/modules/
total 192
-rw-r--r-- 1 root root  457 Nov 14  2010 acct_unique
-rw-r--r-- 1 root root  420 Nov 14  2010 always
-rw-r--r-- 1 root root 1255 Nov 14  2010 attr_filter
-rw-r--r-- 1 root root 1336 Nov 14  2010 attr_rewrite
-rw-r--r-- 1 root root  139 Nov 14  2010 chap
-rw-r--r-- 1 root root 1376 Nov 14  2010 checkval
-rw-r--r-- 1 root root 2903 Nov 14  2010 counter
-rw-r--r-- 1 root root  509 Nov 14  2010 cui
-rw-r--r-- 1 root root 2134 Nov 14  2010 detail
-rw-r--r-- 1 root root  924 Nov 14  2010 detail.example.com
-rw-r--r-- 1 root root 1724 Nov 14  2010 detail.log
-rw-r--r-- 1 root root  273 Nov 14  2010 digest
-rw-r--r-- 1 root root  269 Nov 14  2010 dynamic_clients
-rw-r--r-- 1 root root 3289 Nov 14  2010 echo
-rw-r--r-- 1 root root  816 Nov 14  2010 etc_group
-rw-r--r-- 1 root root  766 Nov 14  2010 exec
-rw-r--r-- 1 root root  548 Nov 14  2010 expiration
-rw-r--r-- 1 root root  558 Nov 14  2010 expr
-rw-r--r-- 1 root root 1522 Nov 14  2010 files
-rw-r--r-- 1 root root 4465 Nov 14  2010 inner-eap
-rw-r--r-- 1 root root 2200 Nov 14  2010 ippool
-rw-r--r-- 1 root root  153 Nov 14  2010 krb5
-rw-r--r-- 1 root root 5267 Nov 14  2010 ldap
-rw-r--r-- 1 root root 2502 Nov 14  2010 linelog
-rw-r--r-- 1 root root 1088 Nov 14  2010 logintime
-rw-r--r-- 1 root root  680 Nov 14  2010 mac2ip
-rw-r--r-- 1 root root  347 Nov 14  2010 mac2vlan
-rw-r--r-- 1 root root 2104 Nov 14  2010 mschap
-rw-r--r-- 1 root root  379 Nov 14  2010 ntlm_auth
-rw-r--r-- 1 root root  287 Nov 14  2010 opendirectory
-rw-r--r-- 1 root root 3357 Nov 14  2010 otp
-rw-r--r-- 1 root root  642 Nov 14  2010 pam
-rw-r--r-- 1 root root  571 Nov 14  2010 pap
-rw-r--r-- 1 root root 1968 Nov 14  2010 passwd
-rw-r--r-- 1 root root 1587 Nov 14  2010 perl
-rw-r--r-- 1 root root  559 Nov 14  2010 policy
-rw-r--r-- 1 root root 1661 Nov 14  2010 preprocess
-rw-r--r-- 1 root root 1510 Nov 14  2010 radutmp
-rw-r--r-- 1 root root  847 Nov 14  2010 realm
-rw-r--r-- 1 root root  354 Nov 14  2010 smbpasswd
-rw-r--r-- 1 root root 1232 Nov 14  2010 smsotp
-rw-r--r-- 1 root root  601 Nov 14  2010 sqlcounter_expire_on_login
-rw-r--r-- 1 root root 2162 Nov 14  2010 sql_log
-rw-r--r-- 1 root root  442 Nov 14  2010 sradutmp
-rw-r--r-- 1 root root  543 Nov 14  2010 unix
-rw-r--r-- 1 root root 3526 Nov 14  2010 wimax
root@hotspot:~#

Ansich ist das mysql Packet aber installiert:

root@hotspot:~# dpkg -l | grep freeradius
ii  freeradius                          2.1.10+dfsg-2                a high-performance and highly configurable RADIUS server
ii  freeradius-common                   2.1.10+dfsg-2                FreeRADIUS common files
ii  freeradius-mysql                    2.1.10+dfsg-2                MySQL module for FreeRADIUS server
ii  freeradius-utils                    2.1.10+dfsg-2                FreeRADIUS client utilities
ii  libfreeradius2                      2.1.10+dfsg-2                FreeRADIUS shared library
root@hotspot:~#

Hat jemand ne Idee was da schief läuft?

ciao
serow

 

[mime]

root@hotspot:~# ls -l /etc/freeradius/modules/

"/usr/lib/freeradius/"? (Debian -- Liste der Dateien in Paket freeradius-mysql/lenny/i386)

Hat jemand ne Idee was da schief läuft?

In der radiusd.conf nach "$INCLUDE sql.conf" suchen...

Ansonsten den radiusd mal mit "-X" starten. Vielleicht siehst du dann mehr.

HTH

Micha

 

[Serow]

Hi,

sry, dass ich mich erst so spät wieder melde. War die letzte Woche unterwegs. Hier ist dein Listing das du haben wolltest:

root@hotspot:~# ls -l /usr/lib/freeradius/ | grep sql
-rw-r--r-- 1 root root  37728 Nov 14  2010 rlm_sql-2.1.10.so
-rw-r--r-- 1 root root  15720 Nov 14  2010 rlm_sqlcounter-2.1.10.so
lrwxrwxrwx 1 root root     24 Oct  2 09:35 rlm_sqlcounter.so -> rlm_sqlcounter-2.1.10.so
-rw-r--r-- 1 root root  16680 Nov 14  2010 rlm_sqlippool-2.1.10.so
lrwxrwxrwx 1 root root     23 Oct  2 09:35 rlm_sqlippool.so -> rlm_sqlippool-2.1.10.so
-rw-r--r-- 1 root root  11584 Nov 14  2010 rlm_sql_log-2.1.10.so
lrwxrwxrwx 1 root root     21 Oct  2 09:35 rlm_sql_log.so -> rlm_sql_log-2.1.10.so
-rw-r--r-- 1 root root   9656 Nov 14  2010 rlm_sql_mysql-2.1.10.so
lrwxrwxrwx 1 root root     23 Oct  2 15:18 rlm_sql_mysql.so -> rlm_sql_mysql-2.1.10.so
lrwxrwxrwx 1 root root     17 Oct  2 09:35 rlm_sql.so -> rlm_sql-2.1.10.so
root@hotspot:~#

Und hier die letzten Zeilen von freeradius -X:

root@hotspot:~# freeradius -X | tail -n 15
 Module: Checking authorize {...} for more modules to load
 Module: Linked to module rlm_preprocess
 Module: Instantiating module "preprocess" from file /etc/freeradius/modules/preprocess
  preprocess {
        huntgroups = "/etc/freeradius/huntgroups"
        hints = "/etc/freeradius/hints"
        with_ascend_hack = no
        ascend_channels_per_line = 23
        with_ntdomain_hack = no
        with_specialix_jetstream_hack = no
        with_cisco_vsa_hack = no
        with_alvarion_vsa_hack = no
  }
/etc/freeradius/sites-enabled/default[159]: Failed to load module "sql".
/etc/freeradius/sites-enabled/default[62]: Errors parsing authorize section. 
root@hotspot:~#

ciao
serow