Segmentation fault - FreeRadius 1.1.0.tar.gz with Debian 3.1
Hello all, I have tried configure the freeradius from the debian's packages , but they haven't got sql_counter module. Then I decided to download the source freeradius-1.1.0.tar.gz , I configured it, with the next steps : ./configure --with-experimental-modules make make install For database I used the script "/freeradius-1.1.0/src/modules/rlm_sql/drivers/rlm_sql_mysql/db_mysql.sql" I edited the configuration files sql.conf, clients.conf and radiusd.conf . (/usr/local/etc/raddb). To executed the radiusd -X : solsrv:/usr/local/etc/raddb# radiusd -X Starting - reading configuration files ... reread_config: reading radiusd.conf Config: including file: /usr/local/etc/raddb/proxy.conf Config: including file: /usr/local/etc/raddb/clients.conf Config: including file: /usr/local/etc/raddb/snmp.conf Config: including file: /usr/local/etc/raddb/eap.conf Config: including file: /usr/local/etc/raddb/sql.conf main: prefix = "/usr/local" main: localstatedir = "/usr/local/var" main: logdir = "/usr/local/var/log/radius" main: libdir = "/usr/local/lib" main: radacctdir = "/usr/local/var/log/radius/radacct" main: hostname_lookups = no main: max_request_time = 30 main: cleanup_delay = 5 main: max_requests = 1024 main: delete_blocked_requests = 0 main: port = 0 main: allow_core_dumps = no main: log_stripped_names = no main: log_file = "/usr/local/var/log/radius/radius.log" main: log_auth = no main: log_auth_badpass = no main: log_auth_goodpass = no main: pidfile = "/usr/local/var/run/radiusd/radiusd.pid" main: user = "(null)" main: group = "(null)" main: usercollide = no main: lower_user = "no" main: lower_pass = "no" main: nospace_user = "no" main: nospace_pass = "no" main: checkrad = "/usr/local/sbin/checkrad" main: proxy_requests = yes proxy: retry_delay = 5 proxy: retry_count = 3 proxy: synchronous = no proxy: default_fallback = yes proxy: dead_time = 120 proxy: post_proxy_authorize = no proxy: wake_all_if_all_dead = no security: max_attributes = 200 security: reject_delay = 1 security: status_server = no main: debug_level = 0 read_config_files: reading dictionary read_config_files: reading naslist Using deprecated naslist file. Support for this will go away soon. read_config_files: reading clients read_config_files: reading realms radiusd: entering modules setup Module: Library search path is /usr/local/lib Module: Loaded exec exec: wait = yes exec: program = "(null)" exec: input_pairs = "request" exec: output_pairs = "(null)" exec: packet_type = "(null)" rlm_exec: Wait=yes but no output defined. Did you mean output=none? Module: Instantiated exec (exec) Module: Loaded expr Module: Instantiated expr (expr) Module: Loaded PAP pap: encryption_scheme = "crypt" Module: Instantiated pap (pap) Module: Loaded CHAP Module: Instantiated chap (chap) Module: Loaded MS-CHAP mschap: use_mppe = yes mschap: require_encryption = no mschap: require_strong = no mschap: with_ntdomain_hack = no mschap: passwd = "(null)" mschap: authtype = "MS-CHAP" mschap: ntlm_auth = "(null)" Module: Instantiated mschap (mschap) Module: Loaded System unix: cache = no unix: passwd = "(null)" unix: shadow = "(null)" unix: group = "(null)" unix: radwtmp = "/usr/local/var/log/radius/radwtmp" unix: usegroup = no unix: cache_reload = 600 Module: Instantiated unix (unix) Module: Loaded eap eap: default_eap_type = "md5" eap: timer_expire = 60 eap: ignore_unknown_eap_types = no eap: cisco_accounting_username_bug = no rlm_eap: Loaded and initialized type md5 rlm_eap: Loaded and initialized type leap gtc: challenge = "Password: " gtc: auth_type = "PAP" rlm_eap: Loaded and initialized type gtc mschapv2: with_ntdomain_hack = no rlm_eap: Loaded and initialized type mschapv2 Module: Instantiated eap (eap) Module: Loaded preprocess preprocess: huntgroups = "/usr/local/etc/raddb/huntgroups" preprocess: hints = "/usr/local/etc/raddb/hints" preprocess: with_ascend_hack = no preprocess: ascend_channels_per_line = 23 preprocess: with_ntdomain_hack = no preprocess: with_specialix_jetstream_hack = no preprocess: with_cisco_vsa_hack = no Module: Instantiated preprocess (preprocess) Module: Loaded realm realm: format = "suffix" realm: delimiter = "@" realm: ignore_default = no realm: ignore_null = no Module: Instantiated realm (suffix) Module: Loaded files files: usersfile = "/usr/local/etc/raddb/users" files: acctusersfile = "/usr/local/etc/raddb/acct_users" files: preproxy_usersfile = "/usr/local/etc/raddb/preproxy_users" files: compat = "no" Module: Instantiated files (files) Module: Loaded SQL sql: driver = "rlm_sql_mysql" sql: server = "localhost" sql: port = "" sql: login = "root" sql: password = "fusi0n" sql: radius_db = "radius" sql: acct_table = "radacct" sql: acct_table2 = "radacct" sql: authcheck_table = "radcheck" sql: authreply_table = "radreply" sql: groupcheck_table = "radgroupcheck" sql: groupreply_table = "radgroupreply" sql: usergroup_table = "usergroup" sql: nas_table = "nas" sql: dict_table = "dictionary" sql: sqltrace = no sql: sqltracefile = "/usr/local/var/log/radius/sqltrace.sql" sql: readclients = no sql: deletestalesessions = yes sql: num_sql_socks = 5 sql: sql_user_name = "%{User-Name}" sql: default_user_profile = "" sql: query_on_not_found = no sql: authorize_check_query = "SELECT id, UserName, Attribute, Value, op FROM radcheck WHERE Username = '%{SQL-User-Name}' ORDER BY id" sql: authorize_reply_query = "SELECT id, UserName, Attribute, Value, op FROM radreply WHERE Username = '%{SQL-User-Name}' ORDER BY id" sql: authorize_group_check_query = "SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = '%{SQL-User-Name}' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id" sql: authorize_group_reply_query = "SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = '%{SQL-User-Name}' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id" sql: accounting_onoff_query = "UPDATE radacct SET AcctStopTime='%S', AcctSessionTime=unix_timestamp('%S') - unix_timestamp(AcctStartTime), AcctTerminateCause='%{Acct-Terminate-Cause}', AcctStopDelay = '%{Acct-Delay-Time}' WHERE AcctSessionTime=0 AND AcctStopTime=0 AND NASIPAddress= '%{NAS-IP-Address}' AND AcctStartTime <= '%S'" sql: accounting_update_query = "UPDATE radacct SET FramedIPAddress = '%{Framed-IP-Address}', AcctSessionTime = '%{Acct-Session-Time}', AcctInputOctets = '%{Acct-Input-Octets}', AcctOutputOctets = '%{Acct-Output-Octets}' WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' AND NASIPAddress= '%{NAS-IP-Address}'" sql: accounting_update_query_alt = "INSERT into radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay) values('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', DATE_SUB('%S',INTERVAL (%{Acct-Session-Time:-0} + %{Acct-Delay-Time:-0}) SECOND), '%{Acct-Session-Time}', '%{Acct-Authentic}', '', '%{Acct-Input-Octets}', '%{Acct-Output-Octets}', '%{Called-Station-Id}', '%{Calling-Station-Id}', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '0')" sql: accounting_start_query = "INSERT into radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay) values('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', '%S', '0', '0', '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '%{Acct-Delay-Time}', '0')" sql: accounting_start_query_alt = "UPDATE radacct SET AcctStartTime = '%S', AcctStartDelay = '%{Acct-Delay-Time}', ConnectInfo_start = '%{Connect-Info}' WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' AND NASIPAddress = '%{NAS-IP-Address}'" sql: accounting_stop_query = "UPDATE radacct SET AcctStopTime = '%S', AcctSessionTime = '%{Acct-Session-Time}', AcctInputOctets = '%{Acct-Input-Octets}', AcctOutputOctets = '%{Acct-Output-Octets}', AcctTerminateCause = '%{Acct-Terminate-Cause}', AcctStopDelay = '%{Acct-Delay-Time}', ConnectInfo_stop = '%{Connect-Info}' WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' AND NASIPAddress = '%{NAS-IP-Address}'" sql: accounting_stop_query_alt = "INSERT into radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay) values('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', DATE_SUB('%S', INTERVAL (%{Acct-Session-Time:-0} + %{Acct-Delay-Time:-0}) SECOND), '%S', '%{Acct-Session-Time}', '%{Acct-Authentic}', '', '%{Connect-Info}', '%{Acct-Input-Octets}', '%{Acct-Output-Octets}', '%{Called-Station-Id}', '%{Calling-Station-Id}', '%{Acct-Terminate-Cause}', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '0', '%{Acct-Delay-Time}')" sql: group_membership_query = "SELECT GroupName FROM usergroup WHERE UserName='%{SQL-User-Name}'" sql: connect_failure_retry_delay = 60 sql: simul_count_query = "" sql: simul_verify_query = "SELECT RadAcctId, AcctSessionId, UserName, NASIPAddress, NASPortId, FramedIPAddress, CallingStationId, FramedProtocol FROM radacct WHERE UserName='%{SQL-User-Name}' AND AcctStopTime = 0" sql: postauth_table = "radpostauth" sql: postauth_query = "INSERT into radpostauth (id, user, pass, reply, date) values ('', '%{User-Name}', '%{User-Password:-Chap-Password}', '%{reply:Packet-Type}', NOW())" sql: safe-characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /" Segmentation fault solsrv:/usr/local/etc/raddb# someone could help me? Thanks. PS: I use Debian 3.1 r1.
Hello Ivo, I haven`t got the file "mysql.conf" in the directory "/usr/local/etc/raddb" but I have the file "sql.conf" where I have the configuration of mysql. In the file radiusd.conf has : $INCLUDE ${confdir}/sql.conf :( ----- Original Message ----- From: "Ivo" <ml.radius@ultra.hr> To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org> Sent: Friday, February 24, 2006 6:14 PM Subject: Re: Segmentation fault - FreeRadius 1.1.0.tar.gz with Debian 3.1
Maybe you are missing $INCLUDE ${confdir}/mysql.conf in your radiusd.conf
sql: safe-characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789._: /" Segmentation fault
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
I haven`t got the file "mysql.conf" in the directory "/usr/local/etc/raddb" but I have the file "sql.conf" where I have the configuration of mysql. In the file radiusd.conf has :
$INCLUDE ${confdir}/sql.conf
:(
That is OK. It is the default file name for mysql configuration. It was rather confusing for me so I renamed it a long time ago and forgot to edit it before "cut&paste-ing" it for you. Does "strace radiusd" give you more information about the reason for failure?
Hello Alan, I have searched the MySQL client libreries with "find . -name *mysql*" ... ... ./usr/lib/libmysqlclient.so.12.0.0 ./usr/lib/libmysqlclient_r.so.12.0.0 ./usr/lib/libmysqlclient_r.so.12 ./usr/lib/libmysqlclient.so.12 ./usr/lib/php4/20020429/mysql.so ... ... I have edited my radiusd.conf and I added the path /usr/lib in the libdir : ... ... prefix = /usr/local exec_prefix = ${prefix} .... .... libdir = ${exec_prefix}/lib:/usr/lib/ ... ... I have seen that directory "/usr/local/lib" has this files: solsrv:/usr/local/lib# ls firmware rlm_chap.a rlm_eap_md5-1.1.0.so rlm_files.la rlm_realm-1.1.0.so libeap-1.1.0.la rlm_chap.la rlm_eap_md5.a rlm_files.so rlm_realm.a libeap-1.1.0.so rlm_chap.so rlm_eap_md5.la rlm_mschap-1.1.0.la rlm_realm.la libeap.a rlm_checkval-1.1.0.la rlm_eap_md5.so rlm_mschap-1.1.0.so rlm_realm.so libeap.la rlm_checkval-1.1.0.so rlm_eap_mschapv2-1.1.0.la rlm_mschap.a rlm_sim_files-1.1.0.la libeap.so rlm_checkval.a rlm_eap_mschapv2-1.1.0.so rlm_mschap.la rlm_sim_files-1.1.0.so libltdl.a rlm_checkval.la rlm_eap_mschapv2.a rlm_mschap.so rlm_sim_files.a libltdl.la rlm_checkval.so rlm_eap_mschapv2.la rlm_ns_mta_md5-1.1.0.la rlm_sim_files.la libltdl.so rlm_cram-1.1.0.la rlm_eap_mschapv2.so rlm_ns_mta_md5-1.1.0.so rlm_sim_files.so libltdl.so.3 rlm_cram-1.1.0.so rlm_eap_sim-1.1.0.la rlm_ns_mta_md5.a rlm_smb-1.1.0.la libltdl.so.3.1.0 rlm_cram.a rlm_eap_sim-1.1.0.so rlm_ns_mta_md5.la rlm_smb-1.1.0.so libradius-1.1.0.la rlm_cram.la rlm_eap_sim.a rlm_ns_mta_md5.so rlm_smb.a libradius-1.1.0.so rlm_cram.so rlm_eap_sim.la rlm_pap-1.1.0.la rlm_smb.la libradius.a rlm_detail-1.1.0.la rlm_eap_sim.so rlm_pap-1.1.0.so rlm_smb.so libradius.la rlm_detail-1.1.0.so rlm_eap.so rlm_pap.a rlm_sql-1.1.0.la libradius.so rlm_detail.a rlm_example-1.1.0.la rlm_pap.la rlm_sql-1.1.0.so rlm_acct_unique-1.1.0.la rlm_detail.la rlm_example-1.1.0.so rlm_pap.so rlm_sql.a rlm_acct_unique-1.1.0.so rlm_detail.so rlm_example.a rlm_passwd-1.1.0.la rlm_sqlcounter-1.1.0.la rlm_acct_unique.a rlm_digest-1.1.0.la rlm_example.la rlm_passwd-1.1.0.so rlm_sqlcounter-1.1.0.so rlm_acct_unique.la rlm_digest-1.1.0.so rlm_example.so rlm_passwd.a rlm_sqlcounter.a rlm_acct_unique.so rlm_digest.a rlm_exec-1.1.0.la rlm_passwd.la rlm_sqlcounter.la rlm_always-1.1.0.la rlm_digest.la rlm_exec-1.1.0.so rlm_passwd.so rlm_sqlcounter.so rlm_always-1.1.0.so rlm_digest.so rlm_exec.a rlm_perl-1.1.0.la rlm_sql.la rlm_always.a rlm_eap-1.1.0.la rlm_exec.la rlm_perl-1.1.0.so rlm_sql_log-1.1.0.la rlm_always.la rlm_eap-1.1.0.so rlm_exec.so rlm_perl.a rlm_sql_log-1.1.0.so rlm_always.so rlm_eap.a rlm_expr-1.1.0.la rlm_perl.la rlm_sql_log.a rlm_attr_filter-1.1.0.la rlm_eap_gtc-1.1.0.la rlm_expr-1.1.0.so rlm_perl.so rlm_sql_log.la rlm_attr_filter-1.1.0.so rlm_eap_gtc-1.1.0.so rlm_expr.a rlm_preprocess-1.1.0.la rlm_sql_log.so rlm_attr_filter.a rlm_eap_gtc.a rlm_expr.la rlm_preprocess-1.1.0.so rlm_sql.so rlm_attr_filter.la rlm_eap_gtc.la rlm_expr.so rlm_preprocess.a rlm_unix-1.1.0.la rlm_attr_filter.so rlm_eap_gtc.so rlm_fastusers-1.1.0.la rlm_preprocess.la rlm_unix-1.1.0.so rlm_attr_rewrite-1.1.0.la rlm_eap.la rlm_fastusers-1.1.0.so rlm_preprocess.so rlm_unix.a rlm_attr_rewrite-1.1.0.so rlm_eap_leap-1.1.0.la rlm_fastusers.a rlm_radutmp-1.1.0.la rlm_unix.la rlm_attr_rewrite.a rlm_eap_leap-1.1.0.so rlm_fastusers.la rlm_radutmp-1.1.0.so rlm_unix.so rlm_attr_rewrite.la rlm_eap_leap.a rlm_fastusers.so rlm_radutmp.a rlm_attr_rewrite.so rlm_eap_leap.la rlm_files-1.1.0.la rlm_radutmp.la rlm_chap-1.1.0.la rlm_eap_leap.so rlm_files-1.1.0.so rlm_radutmp.so rlm_chap-1.1.0.so rlm_eap_md5-1.1.0.la rlm_files.a rlm_realm-1.1.0.la solsrv:/usr/local/lib# I have runned "radiusd -X" and it doesn't work :-(((( ----- Original Message ----- From: "Alan DeKok" <aland@ox.org> To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org> Sent: Friday, February 24, 2006 6:28 PM Subject: Re: Segmentation fault - FreeRadius 1.1.0.tar.gz with Debian 3.1
"oscurin" <oscurin@gmail.com> wrote:
Segmentation fault solsrv:/usr/local/etc/raddb#=20
Your MySQL client libraries cannot be found at run time. Edit the "libdir" configuration item to include the directory where the files are located, or update your dynamic linker.
Alan DeKok.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
participants (3)
-
Alan DeKok -
Ivo -
oscurin