· 8 years ago · Dec 20, 2017, 12:04 PM
1rednager@batmanvpn-ru1:/lib/systemd/system$ sudo freeradius -f -lstdout -xx
2freeradius: FreeRADIUS Version 2.2.8, for host x86_64-pc-linux-gnu, built on Jul 26 2017 at 15:27:21
3Copyright (C) 1999-2015 The FreeRADIUS server project and contributors.
4There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A
5PARTICULAR PURPOSE.
6You may redistribute copies of FreeRADIUS under the terms of the
7GNU General Public License.
8For more information about these matters, see the file named COPYRIGHT.
9Starting - reading configuration files ...
10including configuration file /etc/freeradius/radiusd.conf
11including configuration file /etc/freeradius/proxy.conf
12including configuration file /etc/freeradius/clients.conf
13including files in directory /etc/freeradius/modules/
14including configuration file /etc/freeradius/modules/preprocess
15including configuration file /etc/freeradius/modules/sradutmp
16including configuration file /etc/freeradius/modules/echo
17including configuration file /etc/freeradius/modules/smbpasswd
18including configuration file /etc/freeradius/modules/chap
19including configuration file /etc/freeradius/modules/digest
20including configuration file /etc/freeradius/modules/detail
21including configuration file /etc/freeradius/modules/policy
22including configuration file /etc/freeradius/modules/detail.log
23including configuration file /etc/freeradius/modules/logintime
24including configuration file /etc/freeradius/modules/perl
25including configuration file /etc/freeradius/modules/checkval
26including configuration file /etc/freeradius/modules/radrelay
27including configuration file /etc/freeradius/modules/always
28including configuration file /etc/freeradius/modules/mac2ip
29including configuration file /etc/freeradius/modules/smsotp
30including configuration file /etc/freeradius/modules/attr_filter
31including configuration file /etc/freeradius/modules/krb5
32including configuration file /etc/freeradius/modules/etc_group
33including configuration file /etc/freeradius/modules/rediswho
34including configuration file /etc/freeradius/modules/expr
35including configuration file /etc/freeradius/modules/unix
36including configuration file /etc/freeradius/modules/realm
37including configuration file /etc/freeradius/modules/ippool
38including configuration file /etc/freeradius/modules/opendirectory
39including configuration file /etc/freeradius/modules/wimax
40including configuration file /etc/freeradius/modules/mac2vlan
41including configuration file /etc/freeradius/modules/cache
42including configuration file /etc/freeradius/modules/exec
43including configuration file /etc/freeradius/modules/cui
44including configuration file /etc/freeradius/modules/radutmp
45including configuration file /etc/freeradius/modules/pam
46including configuration file /etc/freeradius/modules/files
47including configuration file /etc/freeradius/modules/sql_log
48including configuration file /etc/freeradius/modules/passwd
49including configuration file /etc/freeradius/modules/soh
50including configuration file /etc/freeradius/modules/dynamic_clients
51including configuration file /etc/freeradius/modules/counter
52including configuration file /etc/freeradius/modules/inner-eap
53including configuration file /etc/freeradius/modules/redis
54including configuration file /etc/freeradius/modules/mschap
55including configuration file /etc/freeradius/modules/sqlcounter_expire_on_login
56including configuration file /etc/freeradius/modules/ntlm_auth
57including configuration file /etc/freeradius/modules/pap
58including configuration file /etc/freeradius/modules/ldap
59including configuration file /etc/freeradius/modules/replicate
60including configuration file /etc/freeradius/modules/acct_unique
61including configuration file /etc/freeradius/modules/dhcp_sqlippool
62including configuration file /etc/freeradius/modules/linelog
63including configuration file /etc/freeradius/modules/otp
64including configuration file /etc/freeradius/modules/attr_rewrite
65including configuration file /etc/freeradius/modules/expiration
66including configuration file /etc/freeradius/modules/detail.example.com
67including configuration file /etc/freeradius/eap.conf
68including configuration file /etc/freeradius/sql.conf
69including configuration file /etc/freeradius/sql/mysql/dialup.conf
70including configuration file /etc/freeradius/policy.conf
71including files in directory /etc/freeradius/sites-enabled/
72including configuration file /etc/freeradius/sites-enabled/inner-tunnel
73including configuration file /etc/freeradius/sites-enabled/default
74main {
75 user = "freerad"
76 group = "freerad"
77 allow_core_dumps = no
78}
79including dictionary file /etc/freeradius/dictionary
80main {
81 name = "freeradius"
82 prefix = "/usr"
83 localstatedir = "/var"
84 sbindir = "/usr/sbin"
85 logdir = "/var/log/freeradius"
86 run_dir = "/var/run/freeradius"
87 libdir = "/usr/lib/freeradius"
88 radacctdir = "/var/log/freeradius/radacct"
89 hostname_lookups = no
90 max_request_time = 30
91 cleanup_delay = 5
92 max_requests = 1024
93 pidfile = "/var/run/freeradius/freeradius.pid"
94 checkrad = "/usr/sbin/checkrad"
95 debug_level = 0
96 proxy_requests = yes
97 log {
98 stripped_names = no
99 auth = no
100 auth_badpass = no
101 auth_goodpass = no
102 }
103 security {
104 max_attributes = 200
105 reject_delay = 1
106 status_server = yes
107 allow_vulnerable_openssl = no
108 }
109}
110radiusd: #### Loading Realms and Home Servers ####
111 proxy server {
112 retry_delay = 5
113 retry_count = 3
114 default_fallback = no
115 dead_time = 120
116 wake_all_if_all_dead = no
117 }
118 home_server localhost {
119 ipaddr = 127.0.0.1
120 port = 1812
121 type = "auth"
122 secret = "testing123"
123 response_window = 20
124 max_outstanding = 65536
125 require_message_authenticator = yes
126 zombie_period = 40
127 status_check = "status-server"
128 ping_interval = 30
129 check_interval = 30
130 num_answers_to_alive = 3
131 num_pings_to_alive = 3
132 revive_interval = 120
133 status_check_timeout = 4
134 coa {
135 irt = 2
136 mrt = 16
137 mrc = 5
138 mrd = 30
139 }
140 }
141 home_server_pool my_auth_failover {
142 type = fail-over
143 home_server = localhost
144 }
145 realm example.com {
146 auth_pool = my_auth_failover
147 }
148 realm LOCAL {
149 }
150radiusd: #### Loading Clients ####
151 client localhost {
152 ipaddr = 127.0.0.1
153 require_message_authenticator = no
154 secret = "secretkey!!!"
155 nastype = "other"
156 }
157radiusd: #### Instantiating modules ####
158 instantiate {
159 Module: Linked to module rlm_exec
160 Module: Instantiating module "exec" from file /etc/freeradius/modules/exec
161 exec {
162 wait = no
163 input_pairs = "request"
164 shell_escape = yes
165 timeout = 10
166 }
167 Module: Linked to module rlm_expr
168 Module: Instantiating module "expr" from file /etc/freeradius/modules/expr
169 Module: Linked to module rlm_expiration
170 Module: Instantiating module "expiration" from file /etc/freeradius/modules/expiration
171 expiration {
172 reply-message = "Password Has Expired "
173 }
174 Module: Linked to module rlm_logintime
175 Module: Instantiating module "logintime" from file /etc/freeradius/modules/logintime
176 logintime {
177 reply-message = "You are calling outside your allowed timespan "
178 minimum-timeout = 60
179 }
180 }
181radiusd: #### Loading Virtual Servers ####
182server { # from file /etc/freeradius/radiusd.conf
183 modules {
184 Module: Creating Auth-Type = digest
185 Module: Checking authenticate {...} for more modules to load
186 Module: Linked to module rlm_pap
187 Module: Instantiating module "pap" from file /etc/freeradius/modules/pap
188 pap {
189 encryption_scheme = "auto"
190 auto_header = no
191 }
192 Module: Linked to module rlm_chap
193 Module: Instantiating module "chap" from file /etc/freeradius/modules/chap
194 Module: Linked to module rlm_mschap
195 Module: Instantiating module "mschap" from file /etc/freeradius/modules/mschap
196 mschap {
197 use_mppe = yes
198 require_encryption = no
199 require_strong = no
200 with_ntdomain_hack = no
201 allow_retry = yes
202 }
203 Module: Linked to module rlm_digest
204 Module: Instantiating module "digest" from file /etc/freeradius/modules/digest
205 Module: Linked to module rlm_unix
206 Module: Instantiating module "unix" from file /etc/freeradius/modules/unix
207 unix {
208 radwtmp = "/var/log/freeradius/radwtmp"
209 }
210 Module: Linked to module rlm_eap
211 Module: Instantiating module "eap" from file /etc/freeradius/eap.conf
212 eap {
213 default_eap_type = "md5"
214 timer_expire = 60
215 ignore_unknown_eap_types = no
216 cisco_accounting_username_bug = no
217 max_sessions = 1024
218 }
219 Module: Linked to sub-module rlm_eap_md5
220 Module: Instantiating eap-md5
221 Module: Linked to sub-module rlm_eap_leap
222 Module: Instantiating eap-leap
223 Module: Linked to sub-module rlm_eap_gtc
224 Module: Instantiating eap-gtc
225 gtc {
226 challenge = "Password: "
227 auth_type = "PAP"
228 }
229 Module: Linked to sub-module rlm_eap_tls
230 Module: Instantiating eap-tls
231 tls {
232 rsa_key_exchange = no
233 dh_key_exchange = yes
234 rsa_key_length = 512
235 dh_key_length = 512
236 verify_depth = 0
237 CA_path = "/etc/freeradius/certs"
238 pem_file_type = yes
239 private_key_file = "/etc/freeradius/certs/server.key"
240 certificate_file = "/etc/freeradius/certs/server.pem"
241 CA_file = "/etc/freeradius/certs/ca.pem"
242 private_key_password = "whatever"
243 dh_file = "/etc/freeradius/certs/dh"
244 random_file = "/dev/urandom"
245 fragment_size = 1024
246 include_length = yes
247 check_crl = no
248 check_all_crl = no
249 cipher_list = "DEFAULT"
250 make_cert_command = "/etc/freeradius/certs/bootstrap"
251 ecdh_curve = "prime256v1"
252 cache {
253 enable = no
254 lifetime = 24
255 max_entries = 255
256 }
257 verify {
258 }
259 ocsp {
260 enable = no
261 override_cert_url = yes
262 url = "http://127.0.0.1/ocsp/"
263 use_nonce = yes
264 timeout = 0
265 softfail = no
266 }
267 }
268 Module: Linked to sub-module rlm_eap_ttls
269 Module: Instantiating eap-ttls
270 ttls {
271 default_eap_type = "md5"
272 copy_request_to_tunnel = no
273 use_tunneled_reply = no
274 virtual_server = "inner-tunnel"
275 include_length = yes
276 }
277 Module: Linked to sub-module rlm_eap_peap
278 Module: Instantiating eap-peap
279 peap {
280 default_eap_type = "mschapv2"
281 copy_request_to_tunnel = no
282 use_tunneled_reply = no
283 proxy_tunneled_request_as_eap = yes
284 virtual_server = "inner-tunnel"
285 soh = no
286 }
287 Module: Linked to sub-module rlm_eap_mschapv2
288 Module: Instantiating eap-mschapv2
289 mschapv2 {
290 with_ntdomain_hack = no
291 send_error = no
292 }
293 Module: Checking authorize {...} for more modules to load
294 Module: Linked to module rlm_preprocess
295 Module: Instantiating module "preprocess" from file /etc/freeradius/modules/preprocess
296 preprocess {
297 huntgroups = "/etc/freeradius/huntgroups"
298 hints = "/etc/freeradius/hints"
299 with_ascend_hack = no
300 ascend_channels_per_line = 23
301 with_ntdomain_hack = no
302 with_specialix_jetstream_hack = no
303 with_cisco_vsa_hack = no
304 with_alvarion_vsa_hack = no
305 }
306reading pairlist file /etc/freeradius/huntgroups
307reading pairlist file /etc/freeradius/hints
308 Module: Linked to module rlm_realm
309 Module: Instantiating module "suffix" from file /etc/freeradius/modules/realm
310 realm suffix {
311 format = "suffix"
312 delimiter = "@"
313 ignore_default = no
314 ignore_null = no
315 }
316 Module: Linked to module rlm_files
317 Module: Instantiating module "files" from file /etc/freeradius/modules/files
318 files {
319 usersfile = "/etc/freeradius/users"
320 acctusersfile = "/etc/freeradius/acct_users"
321 preproxy_usersfile = "/etc/freeradius/preproxy_users"
322 compat = "no"
323 }
324reading pairlist file /etc/freeradius/users
325reading pairlist file /etc/freeradius/acct_users
326reading pairlist file /etc/freeradius/preproxy_users
327 Module: Linked to module rlm_sql
328 Module: Instantiating module "sql" from file /etc/freeradius/sql.conf
329 sql {
330 driver = "rlm_sql_mysql"
331 server = "localhost"
332 port = ""
333 login = "user!!!"
334 password = "password!!!!"
335 radius_db = "radius"
336 read_groups = yes
337 sqltrace = no
338 sqltracefile = "/var/log/freeradius/sqltrace.sql"
339 readclients = yes
340 deletestalesessions = yes
341 num_sql_socks = 32
342 lifetime = 0
343 max_queries = 0
344 sql_user_name = "%{User-Name}"
345 default_user_profile = ""
346 nas_query = "SELECT id, nasname, shortname, type, secret, server FROM nas"
347 authorize_check_query = "SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id"
348 authorize_reply_query = "SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id"
349 authorize_group_check_query = "SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = '%{Sql-Group}' ORDER BY id"
350 authorize_group_reply_query = "SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = '%{Sql-Group}' ORDER BY id"
351 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'"
352 accounting_update_query = " UPDATE radacct SET framedipaddress = '%{Framed-IP-Address}', acctsessiontime = '%{%{Acct-Session-Time}:-0}', 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}'"
353 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}:-0}', '%{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}')"
354 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}')"
355 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}'"
356 accounting_stop_query = " UPDATE radacct SET acctstoptime = '%S', acctsessiontime = '%{%{Acct-Session-Time}:-0}', 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}'"
357 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}:-0}', '%{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}')"
358 group_membership_query = "SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority"
359 connect_failure_retry_delay = 60
360 simul_count_query = ""
361 simul_verify_query = "SELECT radacctid, acctsessionid, username, nasipaddress, nasportid, framedipaddress, callingstationid, framedprotocol FROM radacct WHERE username = '%{SQL-User-Name}' AND acctstoptime IS NULL"
362 postauth_query = "INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( '%{User-Name}', '%{%{User-Password}:-%{Chap-Password}}', '%{reply:Packet-Type}', '%S')"
363 safe-characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"
364 }
365rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
366rlm_sql (sql): Attempting to connect to rednager@localhost:/radius
367rlm_sql (sql): starting 0
368rlm_sql (sql): Attempting to connect rlm_sql_mysql #0
369rlm_sql_mysql: Starting connect to MySQL server for #0
370rlm_sql (sql): Connected new DB handle, #0
371rlm_sql (sql): starting 1
372rlm_sql (sql): Attempting to connect rlm_sql_mysql #1
373rlm_sql_mysql: Starting connect to MySQL server for #1
374rlm_sql (sql): Connected new DB handle, #1
375rlm_sql (sql): starting 2
376rlm_sql (sql): Attempting to connect rlm_sql_mysql #2
377rlm_sql_mysql: Starting connect to MySQL server for #2
378rlm_sql (sql): Connected new DB handle, #2
379rlm_sql (sql): starting 3
380rlm_sql (sql): Attempting to connect rlm_sql_mysql #3
381rlm_sql_mysql: Starting connect to MySQL server for #3
382rlm_sql (sql): Connected new DB handle, #3
383rlm_sql (sql): starting 4
384rlm_sql (sql): Attempting to connect rlm_sql_mysql #4
385rlm_sql_mysql: Starting connect to MySQL server for #4
386rlm_sql (sql): Connected new DB handle, #4
387rlm_sql (sql): starting 5
388rlm_sql (sql): Attempting to connect rlm_sql_mysql #5
389rlm_sql_mysql: Starting connect to MySQL server for #5
390rlm_sql (sql): Connected new DB handle, #5
391rlm_sql (sql): starting 6
392rlm_sql (sql): Attempting to connect rlm_sql_mysql #6
393rlm_sql_mysql: Starting connect to MySQL server for #6
394rlm_sql (sql): Connected new DB handle, #6
395rlm_sql (sql): starting 7
396rlm_sql (sql): Attempting to connect rlm_sql_mysql #7
397rlm_sql_mysql: Starting connect to MySQL server for #7
398rlm_sql (sql): Connected new DB handle, #7
399rlm_sql (sql): starting 8
400rlm_sql (sql): Attempting to connect rlm_sql_mysql #8
401rlm_sql_mysql: Starting connect to MySQL server for #8
402rlm_sql (sql): Connected new DB handle, #8
403rlm_sql (sql): starting 9
404rlm_sql (sql): Attempting to connect rlm_sql_mysql #9
405rlm_sql_mysql: Starting connect to MySQL server for #9
406rlm_sql (sql): Connected new DB handle, #9
407rlm_sql (sql): starting 10
408rlm_sql (sql): Attempting to connect rlm_sql_mysql #10
409rlm_sql_mysql: Starting connect to MySQL server for #10
410rlm_sql (sql): Connected new DB handle, #10
411rlm_sql (sql): starting 11
412rlm_sql (sql): Attempting to connect rlm_sql_mysql #11
413rlm_sql_mysql: Starting connect to MySQL server for #11
414rlm_sql (sql): Connected new DB handle, #11
415rlm_sql (sql): starting 12
416rlm_sql (sql): Attempting to connect rlm_sql_mysql #12
417rlm_sql_mysql: Starting connect to MySQL server for #12
418rlm_sql (sql): Connected new DB handle, #12
419rlm_sql (sql): starting 13
420rlm_sql (sql): Attempting to connect rlm_sql_mysql #13
421rlm_sql_mysql: Starting connect to MySQL server for #13
422rlm_sql (sql): Connected new DB handle, #13
423rlm_sql (sql): starting 14
424rlm_sql (sql): Attempting to connect rlm_sql_mysql #14
425rlm_sql_mysql: Starting connect to MySQL server for #14
426rlm_sql (sql): Connected new DB handle, #14
427rlm_sql (sql): starting 15
428rlm_sql (sql): Attempting to connect rlm_sql_mysql #15
429rlm_sql_mysql: Starting connect to MySQL server for #15
430rlm_sql (sql): Connected new DB handle, #15
431rlm_sql (sql): starting 16
432rlm_sql (sql): Attempting to connect rlm_sql_mysql #16
433rlm_sql_mysql: Starting connect to MySQL server for #16
434rlm_sql (sql): Connected new DB handle, #16
435rlm_sql (sql): starting 17
436rlm_sql (sql): Attempting to connect rlm_sql_mysql #17
437rlm_sql_mysql: Starting connect to MySQL server for #17
438rlm_sql (sql): Connected new DB handle, #17
439rlm_sql (sql): starting 18
440rlm_sql (sql): Attempting to connect rlm_sql_mysql #18
441rlm_sql_mysql: Starting connect to MySQL server for #18
442rlm_sql (sql): Connected new DB handle, #18
443rlm_sql (sql): starting 19
444rlm_sql (sql): Attempting to connect rlm_sql_mysql #19
445rlm_sql_mysql: Starting connect to MySQL server for #19
446rlm_sql (sql): Connected new DB handle, #19
447rlm_sql (sql): starting 20
448rlm_sql (sql): Attempting to connect rlm_sql_mysql #20
449rlm_sql_mysql: Starting connect to MySQL server for #20
450rlm_sql (sql): Connected new DB handle, #20
451rlm_sql (sql): starting 21
452rlm_sql (sql): Attempting to connect rlm_sql_mysql #21
453rlm_sql_mysql: Starting connect to MySQL server for #21
454rlm_sql (sql): Connected new DB handle, #21
455rlm_sql (sql): starting 22
456rlm_sql (sql): Attempting to connect rlm_sql_mysql #22
457rlm_sql_mysql: Starting connect to MySQL server for #22
458rlm_sql (sql): Connected new DB handle, #22
459rlm_sql (sql): starting 23
460rlm_sql (sql): Attempting to connect rlm_sql_mysql #23
461rlm_sql_mysql: Starting connect to MySQL server for #23
462rlm_sql (sql): Connected new DB handle, #23
463rlm_sql (sql): starting 24
464rlm_sql (sql): Attempting to connect rlm_sql_mysql #24
465rlm_sql_mysql: Starting connect to MySQL server for #24
466rlm_sql (sql): Connected new DB handle, #24
467rlm_sql (sql): starting 25
468rlm_sql (sql): Attempting to connect rlm_sql_mysql #25
469rlm_sql_mysql: Starting connect to MySQL server for #25
470rlm_sql (sql): Connected new DB handle, #25
471rlm_sql (sql): starting 26
472rlm_sql (sql): Attempting to connect rlm_sql_mysql #26
473rlm_sql_mysql: Starting connect to MySQL server for #26
474rlm_sql (sql): Connected new DB handle, #26
475rlm_sql (sql): starting 27
476rlm_sql (sql): Attempting to connect rlm_sql_mysql #27
477rlm_sql_mysql: Starting connect to MySQL server for #27
478rlm_sql (sql): Connected new DB handle, #27
479rlm_sql (sql): starting 28
480rlm_sql (sql): Attempting to connect rlm_sql_mysql #28
481rlm_sql_mysql: Starting connect to MySQL server for #28
482rlm_sql (sql): Connected new DB handle, #28
483rlm_sql (sql): starting 29
484rlm_sql (sql): Attempting to connect rlm_sql_mysql #29
485rlm_sql_mysql: Starting connect to MySQL server for #29
486rlm_sql (sql): Connected new DB handle, #29
487rlm_sql (sql): starting 30
488rlm_sql (sql): Attempting to connect rlm_sql_mysql #30
489rlm_sql_mysql: Starting connect to MySQL server for #30
490rlm_sql (sql): Connected new DB handle, #30
491rlm_sql (sql): starting 31
492rlm_sql (sql): Attempting to connect rlm_sql_mysql #31
493rlm_sql_mysql: Starting connect to MySQL server for #31
494rlm_sql (sql): Connected new DB handle, #31
495rlm_sql (sql): Processing generate_sql_clients
496rlm_sql (sql) in generate_sql_clients: query is SELECT id, nasname, shortname, type, secret, server FROM nas
497rlm_sql (sql): Reserving sql socket id: 31
498rlm_sql_mysql: MYSQL check_error: 1146 received
499rlm_sql (sql): database query error, SELECT id, nasname, shortname, type, secret, server FROM nas: Table 'radius.nas' doesn't exist
500rlm_sql (sql): Released sql socket id: 31
501Failed to load clients from SQL.
502rlm_sql (sql): Closing sqlsocket 31
503rlm_sql (sql): Closing sqlsocket 30
504rlm_sql (sql): Closing sqlsocket 29
505rlm_sql (sql): Closing sqlsocket 28
506rlm_sql (sql): Closing sqlsocket 27
507rlm_sql (sql): Closing sqlsocket 26
508rlm_sql (sql): Closing sqlsocket 25
509rlm_sql (sql): Closing sqlsocket 24
510rlm_sql (sql): Closing sqlsocket 23
511rlm_sql (sql): Closing sqlsocket 22
512rlm_sql (sql): Closing sqlsocket 21
513rlm_sql (sql): Closing sqlsocket 20
514rlm_sql (sql): Closing sqlsocket 19
515rlm_sql (sql): Closing sqlsocket 18
516rlm_sql (sql): Closing sqlsocket 17
517rlm_sql (sql): Closing sqlsocket 16
518rlm_sql (sql): Closing sqlsocket 15
519rlm_sql (sql): Closing sqlsocket 14
520rlm_sql (sql): Closing sqlsocket 13
521rlm_sql (sql): Closing sqlsocket 12
522rlm_sql (sql): Closing sqlsocket 11
523rlm_sql (sql): Closing sqlsocket 10
524rlm_sql (sql): Closing sqlsocket 9
525rlm_sql (sql): Closing sqlsocket 8
526rlm_sql (sql): Closing sqlsocket 7
527rlm_sql (sql): Closing sqlsocket 6
528rlm_sql (sql): Closing sqlsocket 5
529rlm_sql (sql): Closing sqlsocket 4
530rlm_sql (sql): Closing sqlsocket 3
531rlm_sql (sql): Closing sqlsocket 2
532rlm_sql (sql): Closing sqlsocket 1
533rlm_sql (sql): Closing sqlsocket 0
534/etc/freeradius/sql.conf[22]: Instantiation failed for module "sql"
535/etc/freeradius/sites-enabled/default[177]: Failed to find "sql" in the "modules" section.
536/etc/freeradius/sites-enabled/default[69]: Errors parsing authorize section.
537rednager@batmanvpn-ru1:/lib/systemd/system$