Freeradius-server-3.0.25 docking mariadb error
Hello, ezhangiso@ezhangiso-virtual-machine:/$ docker exec -it radius-test /bin/bash root@4ff809b932fe:/# chgrp -h freerad /etc/freeradius/mods-available/sql root@4ff809b932fe:/# chown -R freerad:freerad /etc/freeradius/mods-enabled/sql root@4ff809b932fe:/# vi etc/freeradius/mods-available/sql root@4ff809b932fe:/# vi /etc/freeradius/sites-available/default root@4ff809b932fe:/# vi /etc/freeradius/sites-available/inner-tunnel root@4ff809b932fe:/# vi radiusd.conf root@4ff809b932fe:/# vi /etc/freeradius/radiusd.conf root@4ff809b932fe:/# cat etc/freeradius/mods-available/sql dialect = "mysql" driver = "rlm_sql_mysql" sqlite { filename = "/tmp/freeradius.db" busy_timeout = 200 bootstrap = "${modconfdir}/${..:name}/main/sqlite/schema.sql" } mysql { tls_required = no tls_check_cert = no tls_check_cert_cn = no } warnings = auto } postgresql { send_application_name = yes } # mongo { appname = "freeradius" tls { certificate_file = /path/to/file certificate_password = "password" ca_file = /path/to/file ca_dir = /path/to/directory crl_file = /path/to/file weak_cert_validation = false allow_invalid_hostname = false server = "10.0.8.31" port = 3306 login = "radius" password = "radius" radius_db = "radius" acct_table1 = "radacct" acct_table2 = "radacct" postauth_table = "radpostauth" authcheck_table = "radcheck" groupcheck_table = "radgroupcheck" authreply_table = "radreply" groupreply_table = "radgroupreply" usergroup_table = "radusergroup" delete_stale_sessions = yes pool { start = ${thread[pool].start_servers} min = ${thread[pool].min_spare_servers} max = ${thread[pool].max_servers} uses = 0 retry_delay = 30 lifetime = 0 idle_timeout = 60 client_table = "nas" group_attribute = "SQL-Group" $INCLUDE ${modconfdir}/${.:name}/main/${dialect}/queries.conf } root@4ff809b932fe:/# cat /etc/freeradius/radiusd.conf prefix = /usr exec_prefix = /usr sysconfdir = /etc localstatedir = /var sbindir = ${exec_prefix}/sbin logdir = /var/log/freeradius raddbdir = /etc/freeradius radacctdir = ${logdir}/radacct name = freeradius confdir = ${raddbdir} modconfdir = ${confdir}/mods-config certdir = ${confdir}/certs cadir = ${confdir}/certs run_dir = ${localstatedir}/run/${name} db_dir = ${raddbdir} libdir = /usr/lib/freeradius pidfile = ${run_dir}/${name}.pid correct_escapes = true max_request_time = 30 cleanup_delay = 5 hostname_lookups = no log { destination = files colourise = yes file = ${logdir}/radius.log syslog_facility = daemon stripped_names = no auth = no auth_badpass = no auth_goodpass = no msg_denied = "You are already logged in - access denied" } checkrad = ${sbindir}/checkrad ENV { } security { user = freerad group = freerad allow_core_dumps = no max_attributes = 200 reject_delay = 1 status_server = yes } proxy_requests = yes $INCLUDE proxy.conf $INCLUDE clients.conf thread pool { start_servers = 5 max_servers = 32 min_spare_servers = 3 max_spare_servers = 10 max_requests_per_server = 0 modules { $INCLUDE mods-enabled/sql $INCLUDE mods-enabled/ } policy { $INCLUDE policy.d/ } $INCLUDE sites-enabled/ root@4ff809b932fe:/# apt install mariadb-client root@4ff809b932fe:/# mysql -h 10.0.8.31 -uradius -p radius Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 3 Server version: 10.6.5-MariaDB-1:10.6.5+maria~focal mariadb.org binary distribution Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [radius]> show tables; +------------------+ | Tables_in_radius | +------------------+ | nas | | radacct | | radcheck | | radgroupcheck | | radgroupreply | | radpostauth | | radreply | | radusergroup | +------------------+ 8 rows in set (0.00 sec) MariaDB [radius]> exit Bye root@4ff809b932fe:/# exit exit ezhangiso@ezhangiso-virtual-machine:/$ docker commit radius-test radius-mariadb sha256:1b5a68d2c3c3aaf70be72f8dcbfda27a7cf63e7ba448f412b73bd5f0d8aef63b ezhangiso@ezhangiso-virtual-machine:/$ docker stop radius-test radius-test ezhangiso@ezhangiso-virtual-machine:/$ docker run --rm --name myradius -t -p1812-1813:1812-1813/udp radius-mariadb -X FreeRADIUS Version 3.0.25 Copyright (C) 1999-2021 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 For more information about these matters, see the file named COPYRIGHT Starting - reading configuration files ... including dictionary file /usr/share/freeradius/dictionary including dictionary file /usr/share/freeradius/dictionary.dhcp including dictionary file /usr/share/freeradius/dictionary.vqp including dictionary file /etc/freeradius/dictionary including configuration file /etc/freeradius/radiusd.conf including configuration file /etc/freeradius/proxy.conf including configuration file /etc/freeradius/clients.conf including configuration file /etc/freeradius/mods-enabled/sql /etc/freeradius/mods-enabled/sql[365]: Reference "${dialect}" not found Errors reading or parsing /etc/freeradius/radiusd.conf ezhangiso@ezhangiso-virtual-machine:/$ Can anyone shed some light on this and point me in the right direction what else should I do?
On Jan 23, 2023, at 9:29 AM, 网络时代 via Freeradius-Users <freeradius-users@lists.freeradius.org> wrote:
including configuration file /etc/freeradius/mods-enabled/sql /etc/freeradius/mods-enabled/sql[365]: Reference "${dialect}" not found Errors reading or parsing /etc/freeradius/radiusd.conf ezhangiso@ezhangiso-virtual-machine:/$
In general this means you edited the configuration files and broke then. Don't do that. The default configurations work. The "dialect" reference is to the "dialect = mysql" line earlier in the mods-enabled/sql file. Alan DeKok.
participants (2)
-
Alan DeKok -
网络时代