Hilmi Hilmiev wrote:
Hi all,--
I have FreeBSD + OpenLDAP + FreeRADIUS + MySQL. My target: RADIUS with LDAP authentication and logs in MySQL. But I have problem, with testing that work or not. When I start RADIUS server in debug mod option -X, everything is OK:
rlm_sql: Driver rlm_sql_mysql loaded and linked
rlm_sql: Attempting to connect to root@localhost:/radius
rlm_sql: starting 0
rlm_sql: Attempting to connect #0
rlm_sql: Starting connect to MySQL server for #0
rlm_sql: Connected new DB handle, #0
rlm_sql: starting 1
rlm_sql: Attempting to connect #1
rlm_sql: Starting connect to MySQL server for #1
rlm_sql: Connected new DB handle, #1
rlm_sql: starting 2
rlm_sql: Attempting to connect #2
rlm_sql: Starting connect to MySQL server for #2
rlm_sql: Connected new DB handle, #2
rlm_sql: starting 3
rlm_sql: Attempting to connect #3
rlm_sql: Starting connect to MySQL server for #3
rlm_sql: Connected new DB handle, #3
rlm_sql: starting 4
rlm_sql: Attempting to connect #4
rlm_sql: Starting connect to MySQL server for #4
rlm_sql: Connected new DB handle, #4
Module: Instantiated sql (sql)
Listening on IP address *, ports 1812/udp and 1813/udp, with proxy on 1814/udp.
Ready to process requests.
Server was started success, but I can't see the logs in MySQL table! When I change sql accounting with radutmp situation is the same. radutmp file not exist. All of this accounting system, I try to test with sshd -> authentication via radius. My /etc/pam.conf for sshd is configured like this:
sshd auth sufficient pam_skey.so
sshd auth sufficient pam_opie.so no_fake_prompts
sshd auth required pam_radius.so try_first_pass
sshd account required pam_unix.so
sshd password required pam_permit.so
sshd session required pam_permit.so
This system work, I can authenticate via RADIUS, but I can't see the logs files, or sql records. Have somebody any ideas for what is wrong in my situation? Any ideas for how to check this system? I see that work, but I need to see the logs in MySQL tables.
My radiusd.conf is:
# Accounting. Log to detail file, and to the radwtmp file, and maintain
# radutmp.
accounting {
# acct_unique
# detail
# counter
# unix
# radutmp
# sradutmp
sql
}
# Session database, used for checking Simultaneous-Use. Either the radutmp
# or rlm_sql module can handle this
session {
# radutmp
sql
}
10x in advanced!
=-=-=-=-=-=-=-=-=-=-=-=-=
Hilmi Hilmiev
www.wizzbit.com
=-=-=-=-=-=-=-=-=-=-=-=-=
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
