FreeRADIUS 1.1.2 -> 2.1.12 migration steps
All, At my new working place I have inherited a FR 1.1.3 running on CentOS 5.6. Beyond being outdated and unsupported, this FR setup is causing a lot of problems so I plan a migration to RHEL5 and FR 2.1.12. I've been searching but I cannot find a procedure describing which steps to follow in order to migrate from one server/version to another. Can someone please shed some light or point me in the right direction? TIA, Martin
Hi,
At my new working place I have inherited a FR 1.1.3 running on CentOS 5.6. Beyond being outdated and unsupported, this FR setup is causing a lot of problems so I plan a migration to RHEL5 and FR 2.1.12. I've been searching but I cannot find a procedure describing which steps to follow in order to migrate from one server/version to another.
Can someone please shed some light or point me in the right direction?
save your configuration and read through to see the bits you have used. (maybe compare it to the 1.1.3 default configuration to see which bits got modified) take the provided default 2.1.12 configuration and then edit it for your needs...ADDING the things you need. once you have a working authenticating server then start to remove the modules/functions you dont need. dont try going from 0 lines of config TO a working server, it will never work. alan
Alan Buxey <A.L.M.Buxey@lboro.ac.uk> writes:
At my new working place I have inherited a FR 1.1.3 running on CentOS 5.6. Beyond being outdated and unsupported, this FR setup is causing a lot of problems so I plan a migration to RHEL5 and FR 2.1.12. I've been searching but I cannot find a procedure describing which steps to follow in order to migrate from one server/version to another.
Can someone please shed some light or point me in the right direction?
save your configuration and read through to see the bits you have used. (maybe compare it to the 1.1.3 default configuration to see which bits got modified)
take the provided default 2.1.12 configuration and then edit it for your needs...ADDING the things you need. once you have a working authenticating server then start to remove the modules/functions you dont need. dont try going from 0 lines of config TO a working server, it will never work.
All good advice. Just wanted to add a couple of hints which I found useful when doing the same job: Take advantage of the more modular configuration design in 2.1.12, adding your non-global site specific changes as new files instead of editing existing files. This simplifies integration of new defaults on upgrades, and makes it really easy to roll back to a clean default if you mess up. And, as you are going to start from scratch here anyway, I'd also recommend putting all changed files under revision control. Don't you just wish you had that for the 1.1.3 config you've inherited? Doesn't need to be anything fancy. RCS will do. Bjørn
Migrating from CentOS5 to RHEL5 ? Whats the point ? Especially when CentOS6.x/RHEL6.x is already here... On 3/5/2012 5:38 PM, Martin Mielke wrote:
All,
At my new working place I have inherited a FR 1.1.3 running on CentOS 5.6. Beyond being outdated and unsupported, this FR setup is causing a lot of problems so I plan a migration to RHEL5 and FR 2.1.12. I've been searching but I cannot find a procedure describing which steps to follow in order to migrate from one server/version to another.
Can someone please shed some light or point me in the right direction?
TIA,
Martin
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
This is part of an OS consolidation project which started some time ago. There were too many Linux-flavours like Debian, Slackware, Fedora, CentOS, RedHat 4, Mandriva... thus making maintenance, support and administration more complicated... Anyway, this was not the point ;-) Regards, Martin
-----Original Message----- From: freeradius-users-bounces+mmielke=sapphire.gi@lists.freeradius.org [mailto:freeradius-users- bounces+mmielke=sapphire.gi@lists.freeradius.org] On Behalf Of Marinko Tarlac Sent: 05 March 2012 23:46 To: freeradius-users@lists.freeradius.org Subject: Re: FreeRADIUS 1.1.2 -> 2.1.12 migration steps
Migrating from CentOS5 to RHEL5 ? Whats the point ?
Especially when CentOS6.x/RHEL6.x is already here...
On 3/5/2012 5:38 PM, Martin Mielke wrote:
All,
At my new working place I have inherited a FR 1.1.3 running on CentOS 5.6. Beyond being outdated and unsupported, this FR setup is causing a lot of problems so I plan a migration to RHEL5 and FR 2.1.12. I've been searching but I cannot find a procedure describing which steps to follow in order to migrate from one server/version to another.
Can someone please shed some light or point me in the right direction?
TIA,
Martin
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
On Tue, Mar 6, 2012 at 6:13 PM, Martin Mielke <mmielke@sapphire.gi> wrote:
This is part of an OS consolidation project which started some time ago. There were too many Linux-flavours like Debian, Slackware, Fedora, CentOS, RedHat 4, Mandriva... thus making maintenance, support and administration more complicated...
Anyway, this was not the point ;-)
IMHO it's relevant. If you're consolidating stuff, you'd want to put in on something with a long support lifetime. RHEL5 will end its production phase 1 this year. So if this is a new setup, and you're migrating to FR2 anyway, RHEL6 would be a better choice. As to how to migrate, Alan and Bjorn already provide good suggestions. If you still have problems during migration, feel free to ask. -- Fajar
Hello, After installing Daloradius I get the following error, could somebody give me a clue of how to solve it? Befoe everything was working... Thanks!! including configuration file /etc/freeradius/modules/dynamic_clients including configuration file /etc/freeradius/modules/pap including configuration file /etc/freeradius/modules/acct_unique including configuration file /etc/freeradius/modules/detail including configuration file /etc/freeradius/modules/radutmp including configuration file /etc/freeradius/modules/mac2vlan including configuration file /etc/freeradius/modules/expiration including configuration file /etc/freeradius/modules/attr_rewrite including configuration file /etc/freeradius/modules/sql_log including configuration file /etc/freeradius/modules/linelog including configuration file /etc/freeradius/modules/preprocess including configuration file /etc/freeradius/modules/counter including configuration file /etc/freeradius/modules/policy including configuration file /etc/freeradius/modules/mac2ip including configuration file /etc/freeradius/modules/echo including configuration file /etc/freeradius/modules/wimax including configuration file /etc/freeradius/modules/sradutmp including configuration file /etc/freeradius/modules/exec including configuration file /etc/freeradius/modules/realm including configuration file /etc/freeradius/modules/detail.example.com including configuration file /etc/freeradius/modules/perl including configuration file /etc/freeradius/modules/passwd including configuration file /etc/freeradius/modules/krb5 including configuration file /etc/freeradius/modules/files including configuration file /etc/freeradius/modules/pam including configuration file /etc/freeradius/modules/cui including configuration file /etc/freeradius/eap.conf including configuration file /etc/freeradius/sql.conf including configuration file /etc/freeradius/sql/mysql/dialup.conf including files in directory /etc/freeradius/sites-enabled/ including configuration file /etc/freeradius/sites-enabled/inner-tunnel including configuration file /etc/freeradius/sites-enabled/default main { user = "freerad" group = "freerad" allow_core_dumps = no } including dictionary file /etc/freeradius/dictionary main { prefix = "/usr" localstatedir = "/var" logdir = "/var/log/freeradius" libdir = "/usr/lib/freeradius" radacctdir = "/var/log/freeradius/radacct" hostname_lookups = no max_request_time = 30 cleanup_delay = 5 max_requests = 1024 pidfile = "/var/run/freeradius/freeradius.pid" checkrad = "/usr/sbin/checkrad" debug_level = 0 proxy_requests = yes log { stripped_names = no auth = no auth_badpass = no auth_goodpass = no } 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 = yes 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 { ipaddr = 127.0.0.1 require_message_authenticator = no secret = "1107" nastype = "other" } client 192.168.0.0/24 { require_message_authenticator = no secret = "1107" shortname = "private-network-1" nastype = "other" } radiusd: #### Instantiating modules #### instantiate { Module: Linked to module rlm_exec Module: Instantiating module "exec" from file /etc/freeradius/modules/exec exec { wait = no input_pairs = "request" shell_escape = yes } Module: Linked to module rlm_expr Module: Instantiating module "expr" from file /etc/freeradius/modules/expr Module: Linked to module rlm_expiration Module: Instantiating module "expiration" from file /etc/freeradius/modules/expiration expiration { reply-message = "Password Has Expired " } Module: Linked to module rlm_logintime Module: Instantiating module "logintime" from file /etc/freeradius/modules/logintime logintime { reply-message = "You are calling outside your allowed timespan " minimum-timeout = 60 } } radiusd: #### Loading Virtual Servers #### server inner-tunnel { # from file /etc/freeradius/sites-enabled/inner-tunnel modules { Module: Checking authenticate {...} for more modules to load Module: Linked to module rlm_pap Module: Instantiating module "pap" from file /etc/freeradius/modules/pap pap { encryption_scheme = "auto" auto_header = no } Module: Linked to module rlm_chap Module: Instantiating module "chap" from file /etc/freeradius/modules/chap Module: Linked to module rlm_mschap Module: Instantiating module "mschap" from file /etc/freeradius/modules/mschap mschap {rlm_sql_mysql: MYSQL check_error: 1146 received use_mppe = yes require_encryption = no require_strong = no with_ntdomain_hack = no } Module: Linked to module rlm_unix Module: Instantiating module "unix" from file /etc/freeradius/modules/unix unix { radwtmp = "/var/log/freeradius/radwtmp" } Module: Linked to module rlm_eap Module: Instantiating module "eap" from file /etc/freeradius/eap.conf eap { default_eap_type = "md5" timer_expire = 60 ignore_unknown_eap_types = no cisco_accounting_username_bug = no max_sessions = 4096 } 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" } Module: Linked to sub-module rlm_eap_tls Module: Instantiating eap-tls tls { rsa_key_exchange rlm_sql_mysql: MYSQL check_error: 1146 received = no dh_key_exchange = yes rsa_key_length = 512 dh_key_length = 512 verify_depth = 0 CA_path = "/etc/freeradius/certs" pem_file_type = yes private_key_file = "/etc/freeradius/certs/server.key" certificate_file = "/etc/freeradius/certs/server.pem" CA_file = "/etc/freeradius/certs/ca.pem" private_key_password = "whatever" dh_file = "/etc/freeradius/certs/dh" random_file = "/dev/urandom" fragment_size = 1024 include_length = yes check_crl = no cipher_list = "DEFAULT" make_cert_command = "/etc/freeradius/certs/bootstrap" cache { enable = no lifetime = 24 max_entries = 255 } verify { } } Module: Linked to sub-module rlm_eap_ttls Module: Instantiatinrlm_sql_mysql: MYSQL check_error: 1146 received g eap-ttls ttls { default_eap_type = "md5" copy_request_to_tunnel = no use_tunneled_reply = no virtual_server = "inner-tunnel" include_length = yes } Module: Linked to sub-module rlm_eap_peap Module: Instantiating eap-peap peap { default_eap_type = "mschapv2" copy_request_to_tunnel = no use_tunneled_reply = no proxy_tunneled_request_as_eap = yes virtual_server = "inner-tunnel" } Module: Linked to sub-module rlm_eap_mschapv2 Module: Instantiating eap-mschapv2 mschapv2 { with_ntdomain_harlm_sql_mysql: MYSQL check_error: 1146 received ck = no } Module: Checking authorize {...} for more modules to load Module: Linked to module rlm_realm Module: Instantiating module "suffix" from file /etc/freeradius/modules/realm realm suffix { format = "suffix" delimiter = "@" ignore_default = no ignore_null = no } Module: Linked to module rlm_files Module: Instantiating module "files" from file /etc/freeradius/modules/files files { usersfile = "/etc/freeradius/users" acctusersfile = "/etc/freeradius/acct_users" preproxy_usersfile = "/etc/freeradius/preproxy_users" compat = "no" } Module: Checking session {...} for more modules to load Module: Linked to module rlm_radutmp Module: Instantiating module "radutmp" from file /etc/freeradius/modules/radutmp radutmp { filename = "/var/log/freeradius/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 module "attr_filter.access_reject" from file /etc/freeradius/modules/attr_filter attr_filter attr_filter.access_reject { attrsfile = "/etc/freeradius/attrs.access_reject" key = "%{User-Name}" } } # modules } # server server { # from file /etc/freeradius/radiusd.conf 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 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 } Module: Linked to module rlm_sql Module: Instantiating module "sql" from file /etc/freeradius/sql.conf sql { driver = "rlm_sql_mysql" server = "localhost" port = "" login = "root" password = "1107" radius_db = "radius" read_groups = yes sqltrace = no sqltracefile = "/var/log/freeradius/sqltrace.sql" readclients = no 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, server 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.-_: /" } rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting to connect to root@localhost:/radius rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 rlm_sql_mysql: Starting connect to MySQL server for #0 rlm_sql (sql): Connected new DB handle, #0 rlm_sql (sql): starting 1 rlm_sql (sql): Attempting to connect rlm_sql_mysql #1 rlm_sql_mysql: Starting connect to MySQL server for #1 rlm_sql (sql): Connected new DB handle, #1 rlm_sql (sql): starting 2 rlm_sql (sql): Attempting to connect rlm_sql_mysql #2 rlm_sql_mysql: Starting connect to MySQL server for #2 rlm_sql (sql): Connected new DB handle, #2 rlm_sql (sql): starting 3 rlm_sql (sql): Attempting to connect rlm_sql_mysql #3 rlm_sql_mysql: Starting connect to MySQL server for #3 rlm_sql (sql): Connected new DB handle, #3 rlm_sql (sql): starting 4 rlm_sql (sql): Attempting to connect rlm_sql_mysql #4 rlm_sql_mysql: Starting connect to MySQL server for #4 rlm_sql (sql): Connected new DB handle, #4 Module: Checking preacct {...} for more modules to load Module: Linked to module rlm_acct_unique Module: Instantiating module "acct_unique" from file /etc/freeradius/modules/acct_unique acct_unique { key = "User-Name, Acct-Session-Id, NAS-IP-Address, Client-IP-Address, NAS-Port" } Module: Checking accounting {...} for more modules to load Module: Linked to module rlm_detail Module: Instantiating module "detail" from file /etc/freeradius/modules/detail detail { detailfile = "/var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d" header = "%t" detailperm = 384 dirperm = 493 locking = no log_packet_header = no } Module: Checking session {...} for more modules to load Module: Checking post-proxy {...} for more modules to load Module: Checking post-auth {...} for more modules to load } # modules } # server radiusd: #### Opening IP addresses and Ports #### listen { type = "auth" ipaddr = * port = 0 } listen { type = "acct" ipaddr = * port = 0 } listen { type = "auth" ipaddr = 127.0.0.1 port = 18120 } Listening on authentication address * port 1812 Listening on accounting address * port 1813 Listening on authentication address 127.0.0.1 port 18120 as server inner-tunnel Listening on proxy address * port 1814 Ready to process requests. rad_recv: Access-Request packet from host 127.0.0.1 port 34348, id=144, length=61 User-Name = "mysqltest" User-Password = "testsecret" NAS-IP-Address = 192.168.182.1 NAS-Port = 0rlm_sql_mysql: MYSQL check_error: 1146 received # Executing section authorize from file /etc/freeradius/radiusd.conf +- entering group authorize {...} ++[preprocess] returns ok ++[chap] returns noop ++[mschap] returns noop [suffix] No '@' in User-Name = "mysqltest", looking up realm NULL [suffix] No such realm "NULL" ++[suffix] returns noop [eap] No EAP-Message, not doing EAP ++[eap] returns noop [sql] expand: %{User-Name} -> mysqltest [sql] sql_set_user escaped user --> 'mysqltest' rlm_sql (sql): Reserving sql socket id: 4 [sql] expand: SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'mysqltest' ORDER BY id [sql] User found in radcheck table [sql] expand: SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, username, attribute, value, op FROM radreply WHERE username = 'mysqltest' ORDER BY id rlm_sql_mysql: MYSQL check_error: 1146 received rlm_sql_getvpdata: database query error [sql] SQL query error; rejecting user rlm_sql (sql): Released sql socket id: 4 ++[sql] returns fail Using Post-Auth-Type Reject # Executing group from file /etc/freeradius/sites-enabled/default +- entering group REJECT {...} [attr_filter.access_reject] expand: %{User-Name} -> mysqltest attr_filter: Matched entry DEFAULT at line 11 ++[attr_filter.access_reject] returns updated Delaying reject of request 0 for 1 seconds Going to the next request Waking up in 0.9 seconds. Sending delayed reject for request 0 Sending Access-Reject of id 144 to 127.0.0.1 port 34348 Waking up in 4.9 seconds. Cleaning up request 0 ID 144 with timestamp +14 Ready to process requests.
On Tue, Mar 6, 2012 at 7:27 PM, Javier Ruiz Escalante <fruiz002@hotmail.com> wrote:
Hello,
After installing Daloradius I get the following error, could somebody give me a clue of how to solve it? Befoe everything was working...
Did you read daloradius documentation, just in case it had some warnings? Did you ask in daloradius list/forum?
-> SELECT id, username, attribute, value, op FROM radreply WHERE username = 'mysqltest' ORDER BY id rlm_sql_mysql: MYSQL check_error: 1146 received
Run that query manually ono your sql server. It should tell you what's wrong. -- Fajar
Just a little remark : CentOS 5.8 has up-to-date freeradius 2.1.12 (binary and sources) CentOS 6.2 only has freeradius 2.1.10 from upstream (redhat 6.2). Best regards, Fred MAISON Le 6 mars 2012 13:06, Fajar A. Nugraha <list@fajar.net> a écrit :
On Tue, Mar 6, 2012 at 6:13 PM, Martin Mielke <mmielke@sapphire.gi> wrote:
This is part of an OS consolidation project which started some time ago. There were too many Linux-flavours like Debian, Slackware, Fedora, CentOS, RedHat 4, Mandriva... thus making maintenance, support and administration more complicated...
Anyway, this was not the point ;-)
IMHO it's relevant.
If you're consolidating stuff, you'd want to put in on something with a long support lifetime. RHEL5 will end its production phase 1 this year. So if this is a new setup, and you're migrating to FR2 anyway, RHEL6 would be a better choice.
As to how to migrate, Alan and Bjorn already provide good suggestions. If you still have problems during migration, feel free to ask.
-- Fajar - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
On 03/12/2012 11:33 AM, Fred wrote:
Just a little remark : CentOS 5.8 has up-to-date freeradius 2.1.12 (binary and sources) CentOS 6.2 only has freeradius 2.1.10 from upstream (redhat 6.2).
And we are expecting to ship freeradius 2.1.12 in the RHEL 6.3 update. -- John Dennis <jdennis@redhat.com> Looking to carve out IT costs? www.redhat.com/carveoutcosts/
On 03/12/2012 03:34 PM, Norman Elton wrote:
And we are expecting to ship freeradius 2.1.12 in the RHEL 6.3 update.
Any chance you can post the 2.1.12 packages to test? I can compile FR by hand, but testing the RPM would be good.
No, I'm sorry I cannot pre-release packages. However if you are a RHEL customer I believe you can participate in beta testing. -- John Dennis <jdennis@redhat.com> Looking to carve out IT costs? www.redhat.com/carveoutcosts/
I don't see any differences... Just save your config files and replace them later when rpm "goes live" On 3/12/2012 8:34 PM, Norman Elton wrote:
And we are expecting to ship freeradius 2.1.12 in the RHEL 6.3 update. Any chance you can post the 2.1.12 packages to test? I can compile FR by hand, but testing the RPM would be good.
Thanks,
Norman Elton - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
I don't see any differences... Just save your config files and replace them later when rpm "goes live"
If anyone's interested, 2.1.12 builds fine with the specfile included in the source release. I had to rebuild the certificate patch file and include a few extra man files in the manifest. Simple build. Norman
participants (9)
-
Alan Buxey -
Bjørn Mork -
Fajar A. Nugraha -
Fred -
Javier Ruiz Escalante -
John Dennis -
Marinko Tarlac -
Martin Mielke -
Norman Elton