Aller au contenu

erreur de lancement radius -X


Messages recommandés

bonsoir,

apres l'installation de freeradius et de mysql, quand je lance raduisd -X sans le sql ca se lance normale , mais une fois le sql est mentionnee dans authorize{} et accounting{} j'ai l'erreur suivante

svp aidez moi!!

[root@localhost raddb]# /usr/local/freeradius-fsdm/sbin/radiusd -X
FreeRADIUS Version 2.1.5, for host i686-pc-linux-gnu, built on May 14 2009 at 22:11:05
Copyright (C) 1999-2008 The FreeRADIUS server project and contributors.			   
There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A				   
PARTICULAR PURPOSE.																   
You may redistribute copies of FreeRADIUS under the terms of the					  
GNU General Public License v2.														
Starting - reading configuration files ...											
including configuration file /usr/local/freeradius-fsdm/etc/raddb/radiusd.conf		
including configuration file /usr/local/freeradius-fsdm/etc/raddb/proxy.conf		  
including configuration file /usr/local/freeradius-fsdm/etc/raddb/clients.conf		
including files in directory /usr/local/freeradius-fsdm/etc/raddb/modules/			
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/smsotp	  
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/wimax	   
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/acct_unique 
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/ldap		
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/detail.example.com
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/sqlcounter_expire_on_login
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/detail.log				
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/sql_log				   
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/expiration				
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/detail					
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/passwd					
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/pap					   
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/checkval				  
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/chap					  
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/otp					   
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/attr_filter			   
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/perl					  
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/digest					
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/sradutmp				  
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/mac2ip					
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/policy					
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/realm					 
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/linelog				   
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/radutmp				   
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/smbpasswd				 
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/etc_group				 
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/mschap					
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/echo					  
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/preprocess				
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/krb5					  
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/pam					   
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/logintime				 
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/exec					  
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/unix					  
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/counter				   
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/inner-eap				 
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/attr_rewrite			  
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/always					
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/mac2vlan				  
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/ippool					
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/expr					  
including configuration file /usr/local/freeradius-fsdm/etc/raddb/modules/files					 
including configuration file /usr/local/freeradius-fsdm/etc/raddb/eap.conf						  
including configuration file /usr/local/freeradius-fsdm/etc/raddb/sql.conf						  
including configuration file /usr/local/freeradius-fsdm/etc/raddb/sql/mysql/dialup.conf			 
including configuration file /usr/local/freeradius-fsdm/etc/raddb/sql/mysql/counter.conf			
including configuration file /usr/local/freeradius-fsdm/etc/raddb/policy.conf					   
including files in directory /usr/local/freeradius-fsdm/etc/raddb/sites-enabled/					
including configuration file /usr/local/freeradius-fsdm/etc/raddb/sites-enabled/default			 
including configuration file /usr/local/freeradius-fsdm/etc/raddb/sites-enabled/control-socket	  
including configuration file /usr/local/freeradius-fsdm/etc/raddb/sites-enabled/inner-tunnel		
including dictionary file /usr/local/freeradius-fsdm/etc/raddb/dictionary						   
main {																							  
	prefix = "/usr/local/freeradius-fsdm"													   
	localstatedir = "/usr/local/freeradius-fsdm/var"											
	logdir = "/usr/local/freeradius-fsdm/var/log/radius"										
	libdir = "/usr/local/freeradius-fsdm/lib"												   
	radacctdir = "/usr/local/freeradius-fsdm/var/log/radius/radacct"							
	hostname_lookups = no																	   
	max_request_time = 30																	   
	cleanup_delay = 5																		   
	max_requests = 1024																		 
	allow_core_dumps = no																	   
	pidfile = "/usr/local/freeradius-fsdm/var/run/radiusd/radiusd.pid"						  
	checkrad = "/usr/local/freeradius-fsdm/sbin/checkrad"									   
	debug_level = 0																			 
	proxy_requests = yes																		
log {																							  
	stripped_names = yes																		
	auth = yes																				  
	auth_badpass = yes																		  
	auth_goodpass = yes																		 
}																								  
security {																						 
	max_attributes = 200																		
	reject_delay = 1																			
	status_server = yes																		 
}																								  
}																								   
radiusd: #### Loading Realms and Home Servers ####												  
proxy server {																					 
	retry_delay = 5																			 
	retry_count = 3																			 
	default_fallback = no																	   
	dead_time = 120																			 
	wake_all_if_all_dead = no																   
}																								  
home_server localhost {																			
	ipaddr = 127.0.0.1																		  
	port = 1812																				 
	type = "auth"																			   
	secret = "testing123"																	   
	response_window = 20																		
	max_outstanding = 65536																	 
	require_message_authenticator = no														  
	zombie_period = 40																		  
	status_check = "status-server"															  
	ping_interval = 30																		  
	check_interval = 30																		 
	num_answers_to_alive = 3																	
	num_pings_to_alive = 3																	  
	revive_interval = 120																	   
	status_check_timeout = 4																	
	irt = 2																					 
	mrt = 16																					
	mrc = 5																					 
	mrd = 30																					
}																								  
home_server_pool my_auth_failover {																
	type = fail-over																			
	home_server = localhost																	 
}																								  
realm example.com {																				
	auth_pool = my_auth_failover																
}																								  
realm LOCAL {																					  
}																								  
radiusd: #### Loading Clients ####																  
client localhost {																				 
	require_message_authenticator = no														  
	secret = "testing123"																	   
	shortname = "localhost"																	 
	nastype = "other"																		   
}																								  
radiusd: #### Instantiating modules ####															
instantiate {																					  
Module: Linked to module rlm_exec																  
Module: Instantiating exec																		 
 exec {																							
	wait = no																				   
	input_pairs = "request"																	 
	shell_escape = yes																		  
 }																								 
Module: Linked to module rlm_expr																  
Module: Instantiating expr																		 
Module: Linked to module rlm_expiration															
Module: Instantiating expiration																   
 expiration {																					  
	reply-message = "Password Has Expired  "													
 }																								 
Module: Linked to module rlm_logintime															 
Module: Instantiating logintime																	
 logintime {																					   
	reply-message = "You are calling outside your allowed timespan  "						   
	minimum-timeout = 60																		
 }																								 
}																								  
radiusd: #### Loading Virtual Servers ####														  
server inner-tunnel {																			   
modules {																						  
Module: Checking authenticate {...} for more modules to load									   
Module: Linked to module rlm_pap																   
Module: Instantiating pap																		  
 pap {																							 
	encryption_scheme = "auto"																  
	auto_header = no																			
 }																								 
Module: Linked to module rlm_chap																  
Module: Instantiating chap																		 
Module: Linked to module rlm_mschap																
Module: Instantiating mschap																	   
 mschap {																						  
	use_mppe = yes																			  
	require_encryption = no																	 
	require_strong = no																		 
	with_ntdomain_hack = no																	 
 }																								 
Module: Linked to module rlm_unix																  
Module: Instantiating unix																		 
 unix {																							
	radwtmp = "/usr/local/freeradius-fsdm/var/log/radius/radwtmp"							   
 }																								 
Module: Linked to module rlm_eap																   
Module: Instantiating eap																		  
 eap {																							 
	default_eap_type = "md5"																	
	timer_expire = 60																		   
	ignore_unknown_eap_types = no															   
	cisco_accounting_username_bug = no														  
	max_sessions = 2048																		 
 }																								 
Module: Linked to sub-module rlm_eap_md5														   
Module: Instantiating eap-md5																	  
Module: Linked to sub-module rlm_eap_leap														  
Module: Instantiating eap-leap																	 
Module: Linked to sub-module rlm_eap_gtc														   
Module: Instantiating eap-gtc																	  
  gtc {																							
	challenge = "Password: "																	
	auth_type = "PAP"																		   
  }																								
Ignoring EAP-Type/tls because we do not have OpenSSL support.									   
Ignoring EAP-Type/ttls because we do not have OpenSSL support.									  
Ignoring EAP-Type/peap because we do not have OpenSSL support.									  
Module: Linked to sub-module rlm_eap_mschapv2													  
Module: Instantiating eap-mschapv2																 
  mschapv2 {																					   
	with_ntdomain_hack = no																	 
  }																								
Module: Checking authorize {...} for more modules to load										  
Module: Linked to module rlm_realm																 
Module: Instantiating suffix																	   
 realm suffix {																					
	format = "suffix"																		   
	delimiter = "@"																			 
	ignore_default = no																		 
	ignore_null = no																			
 }																								 
Module: Linked to module rlm_files																 
Module: Instantiating files																		
 files {																						   
	usersfile = "/usr/local/freeradius-fsdm/etc/raddb/users"									
	acctusersfile = "/usr/local/freeradius-fsdm/etc/raddb/acct_users"						   
	preproxy_usersfile = "/usr/local/freeradius-fsdm/etc/raddb/preproxy_users"				  
	compat = "no"																			   
 }																								 
Module: Checking session {...} for more modules to load											
Module: Linked to module rlm_radutmp															   
Module: Instantiating radutmp																	  
 radutmp {																						 
	filename = "/usr/local/freeradius-fsdm/var/log/radius/radutmp"							  
	username = "%{User-Name}"																   
	case_sensitive = yes																		
	check_with_nas = yes																		
	perm = 384																				  
	callerid = yes																			  
 }																								 
Module: Checking post-proxy {...} for more modules to load										 
Module: Checking post-auth {...} for more modules to load										  
Module: Linked to module rlm_attr_filter														   
Module: Instantiating attr_filter.access_reject													
 attr_filter attr_filter.access_reject {														   
	attrsfile = "/usr/local/freeradius-fsdm/etc/raddb/attrs.access_reject"					  
	key = "%{User-Name}"																		
 }																								 
}																								  
}																								   
modules {																						  
Module: Checking authenticate {...} for more modules to load									   
Module: Checking authorize {...} for more modules to load										  
Module: Linked to module rlm_preprocess															
Module: Instantiating preprocess																   
 preprocess {																					  
	huntgroups = "/usr/local/freeradius-fsdm/etc/raddb/huntgroups"							  
	hints = "/usr/local/freeradius-fsdm/etc/raddb/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																 
 }																								 
Module: Linked to module rlm_sql																   
Module: Instantiating sql																		  
 sql {																							 
	driver = "rlm_sql_mysql"																	
	server = "localhost"																		
	port = ""																				   
	login = "fsdm"																			  
	password = "fsdmmysql"																	  
	radius_db = "radius"																		
	read_groups = yes																		   
	sqltrace = no																			   
	sqltracefile = "/usr/local/freeradius-fsdm/var/log/radius/sqltrace.sql"					 
	readclients = yes																		   
	deletestalesessions = yes																   
	num_sql_socks = 5																		   
	lifetime = 0																				
	max_queries = 0																			 
	sql_user_name = "%{User-Name}"															  
	default_user_profile = ""																   
	nas_query = "SELECT id, nasname, shortname, type, secret FROM nas"						  
	authorize_check_query = "SELECT id, username, attribute, value, op		   FROM radcheck		   WHERE username = '%{SQL-User-Name}'		   ORDER BY id"																				   
	authorize_reply_query = "SELECT id, username, attribute, value, op		   FROM radreply		   WHERE username = '%{SQL-User-Name}'		   ORDER BY id"																				   
	authorize_group_check_query = "SELECT id, groupname, attribute,		   Value, op		   FROM radgroupcheck		   WHERE groupname = '%{Sql-Group}'		   ORDER BY id"																
	authorize_group_reply_query = "SELECT id, groupname, attribute,		   value, op		   FROM radgroupreply		   WHERE groupname = '%{Sql-Group}'		   ORDER BY id"																
	accounting_onoff_query = "		  UPDATE radacct		   SET			  acctstoptime	   =  '%S',			  acctsessiontime	=  unix_timestamp('%S') -									unix_timestamp(acctstarttime),			  acctterminatecause =  '%{Acct-Terminate-Cause}',			  acctstopdelay	  =  %{%{Acct-Delay-Time}:-0}		   WHERE acctstoptime IS NULL		   AND nasipaddress	  =  '%{NAS-IP-Address}'		   AND acctstarttime	 <= '%S'"		
	accounting_update_query = "		   UPDATE radacct		   SET			  framedipaddress = '%{Framed-IP-Address}',			  acctsessiontime	 = '%{Acct-Session-Time}',			  acctinputoctets	 = '%{%{Acct-Input-Gigawords}:-0}'  << 32 |									'%{%{Acct-Input-Octets}:-0}',			  acctoutputoctets	= '%{%{Acct-Output-Gigawords}:-0}' << 32 |									'%{%{Acct-Output-Octets}:-0}'		   WHERE acctsessionid = '%{Acct-Session-Id}'		   AND username		= '%{SQL-User-Name}'		   AND nasipaddress	= '%{NAS-IP-Address}'"																														   
	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,   xascendsessionsvrkey)		   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-Gigawords}:-0}' << 32 |			  '%{%{Acct-Input-Octets}:-0}',			  '%{%{Acct-Output-Gigawords}:-0}' << 32 |			  '%{%{Acct-Output-Octets}:-0}',			  '%{Called-Station-Id}', '%{Calling-Station-Id}',			  '%{Service-Type}', '%{Framed-Protocol}',			  '%{Framed-IP-Address}',			  '0', '%{X-Ascend-Session-Svr-Key}')"				  
	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,	xascendsessionsvrkey)		   VALUES			 ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}',			  '%{SQL-User-Name}',			  '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}',			  '%{NAS-Port-Type}', '%S', NULL,			  '0', '%{Acct-Authentic}', '%{Connect-Info}',			  '', '0', '0',			  '%{Called-Station-Id}', '%{Calling-Station-Id}', '',			  '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}',			  '%{%{Acct-Delay-Time}:-0}', '0', '%{X-Ascend-Session-Svr-Key}')"		   
	accounting_start_query_alt = "		   UPDATE radacct SET			  acctstarttime	 = '%S',			  acctstartdelay	= '%{%{Acct-Delay-Time}:-0}',			  connectinfo_start = '%{Connect-Info}'		   WHERE acctsessionid  = '%{Acct-Session-Id}'		   AND username		 = '%{SQL-User-Name}'		   AND nasipaddress	 = '%{NAS-IP-Address}'"																														  
	accounting_stop_query = "		   UPDATE radacct SET			  acctstoptime	   = '%S',			  acctsessiontime	= '%{Acct-Session-Time}',			  acctinputoctets	= '%{%{Acct-Input-Gigawords}:-0}' << 32 |								   '%{%{Acct-Input-Octets}:-0}',			  acctoutputoctets   = '%{%{Acct-Output-Gigawords}:-0}' << 32 |								   '%{%{Acct-Output-Octets}:-0}',			  acctterminatecause = '%{Acct-Terminate-Cause}',			  acctstopdelay	  = '%{%{Acct-Delay-Time}:-0}',			  connectinfo_stop   = '%{Connect-Info}'		   WHERE acctsessionid   = '%{Acct-Session-Id}'		   AND username		  = '%{SQL-User-Name}'		   AND nasipaddress	  = '%{NAS-IP-Address}'"																								   
	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-Gigawords}:-0}' << 32 |			  '%{%{Acct-Input-Octets}:-0}',			  '%{%{Acct-Output-Gigawords}:-0}' << 32 |   '%{%{Acct-Output-Octets}:-0}',			  '%{Called-Station-Id}', '%{Calling-Station-Id}',			  '%{Acct-Terminate-Cause}',			  '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}',			  '0', '%{%{Acct-Delay-Time}:-0}')"
	group_membership_query = "SELECT groupname		   FROM radusergroup		   WHERE username = '%{SQL-User-Name}'		  ORDER BY priority"
	connect_failure_retry_delay = 60
	simul_count_query = ""
	simul_verify_query = "SELECT radacctid, acctsessionid, username,								nasipaddress, nasportid, framedipaddress,								callingstationid, framedprotocol								FROM radacct								WHERE username = '%{SQL-User-Name}'								AND acctstoptime IS NULL"
	postauth_query = "INSERT INTO radpostauth						   (username, pass, reply, authdate)		   VALUES (						   '%{User-Name}',						   '%{%{User-Password}:-%{Chap-Password}}',						   '%{reply:Packet-Type}', '%S')"
	safe-characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"
 }
Could not link driver rlm_sql_mysql: rlm_sql_mysql.so: cannot open shared object file: No such file or directory
Make sure it (and all its dependent libraries!) are in the search path of your system's ld.
/usr/local/freeradius-fsdm/etc/raddb/sql.conf[22]: Instantiation failed for module "sql"
/usr/local/freeradius-fsdm/etc/raddb/sites-enabled/default[152]: Failed to find module "sql".
/usr/local/freeradius-fsdm/etc/raddb/sites-enabled/default[62]: Errors parsing authorize section.
}
Errors initializing modules

Lien vers le commentaire
Partager sur d’autres sites

Archivé

Ce sujet est désormais archivé et ne peut plus recevoir de nouvelles réponses.

×
×
  • Créer...