Comments on How to Install FreeRADIUS and daloRADIUS on Ubuntu 18.04 LTS

Can't get passed here unfortunately: PERMISSION DENIED (sudo doesn't work either, probably related to the DB ownership)

Once installed, import the freeradius MySQL database schema with the following command:

mysql -u root -p radiusdb < /etc/freeradius/3.0/mods-config/sql/main/mysql/schema.sql

very nice.  Thank You.

I am also stuck at the same location as jer.bee. Is there something missing?

I got passed the importing the schema . Now I am stuck at starting the freeradius service. Error is "failed to start freeradius multi-protocol policy server

 

Hi Hitesh,

Thanks for the detailed instructions; my goals were actually to set up:

1. user's authentication via freeradius through LDAP ADC (NPS on Windos 16 is not working right);

2. NAC for machines per MAC addresses.

Is there a quick reference to howto that - in relation to this installation?

Thanks!

Thanks. It works.

Actually what kind of authentication does this provide ?

Freeradius and Apache on my server did not autostart. You might want to add:

systemctl enable apache2

systemctl enable freeradius

somewhere at the end of the tutorial.

Nice Job!

Congratulations an thanks you!

one question: how can say to program "one user, one device only"?

Thanks

I followed the steps and everything looks right. but when login from GUI by using administrator/radius, then got this error:

Database connection error Error Message: DB Error: connect failed

any idea?

thanks f

Lee

to bypass permissions for db try to copy schema.sql to other locationm change ownership to user privileges and then run mysql import command:

cp /etc/freeradius/3.0/mods-config/sql/main/mysql/schema.sql ~/

chown -R [user]:[usergrp] schema.sql

mysql -u root -p radiusdb schema.sql

 

However, i have some issues with after config. Everithing going right till i try to login in daloradis panel.

http://[serverip]/daloradius/login.php is working, but when i enter default user and pass [administrator/radius] i recieve http error 500, can't figure it out where is the problem

Seehttps://sourceforge.net/p/daloradius/support-requests/57/

I also had a problem with the step schema import mysql -u root -p radiusdb < /etc/freeradius/3.0/mods-config/sql/main/mysql/schema.sql

I was able to to get schema imported by logging in to mysql and connecting to radiusdb and then running cmd source /etc/freeradius/3.0/mods-config/sql/main/mysql/schema.sql I have no idea why that worked, or why the < didnt work, but it populated the database properly

Great guide! worked without any trouble.

Getting Error while testing the radius with NTRadping tool

"Ready to process requestsIgnoring request to auth address * port 1812 bound to server default from unknown client 192.168.1.2 port 49234 proto udp"

Please help me to fix the issue:

 

sudo systemctl status freeradius

? freeradius.service - FreeRADIUS multi-protocol policy server

   Loaded: loaded (/lib/systemd/system/freeradius.service; enabled; vendor preset: enabled)

   Active: activating (auto-restart) (Result: exit-code) since Thu 2019-12-26 10:47:14 +0545; 1s ago

     Docs: man:radiusd(8)

           man:radiusd.conf(5)

           http://wiki.freeradius.org/

           http://networkradius.com/doc/

  Process: 4412 ExecStartPre=/usr/sbin/freeradius $FREERADIUS_OPTIONS -Cxm -lstdout (code=exited, st

 

??????? 26 10:47:14 Moth3r systemd[1]: Failed to start FreeRADIUS multi-protocol policy server.

lines 1-10/10 (END)

 

I guess you have a typo here:

mysql -u root -p radiusdb < /etc/freeradius/3.0/mods-config/sql/main/mysql/schema.sql

There should be your DB user, not root.

Thank You Mr.X

I have fix the issue..

Now the ip address,subnet are not showing on Network Interface ??

 

Hi to all , i follw thi tuto and the instalation no report problem ... th page of daloradius open good but when i try to use with administrator / radius the systen respond "Database connection error

Error Message: DB Error: connect failed" 

 

I check that the database is the same in mariadb Server, freeradoius config and daloradius config what i can do ... where its the posible problems?

Pls help I got error while user test connectivity,

xecuted:echo User-Name='test',User-Password='test' | radclient -c '1' -n '3' -r '3' -t '3' -x '127.0.0.1:1812' 'auth' 'testing123' 2>&1Results:(0) -: Expected Access-Accept got Access-Reject Sent Access-Request Id 209 from 0.0.0.0:52329 to 127.0.0.1:1812 length 44 User-Name = "test" User-Password = "test" Cleartext-Password = "test" Received Access-Reject Id 209 from 127.0.0.1:1812 to 127.0.0.1:52329 length 20

On debug:

Failed binding to auth address * port 1812 bound to server default: Address already in use /etc/freeradius/3.0/sites-enabled/default[59]: Error binding to port for 0.0.0.0 port 1812

Pls help..

 

Great Guide. It all worked perfectly withour any issues.

I am working on an automated solution to implement mass authentication ,in order to do this, I must give mysql access to a remote host. Basically a remote host should connect to the DC on the FreeRadius server, in order to add users etc.

Normally, you must edit the /etc/my.cnf file and grant DB permissions however, in this case this file does not exists. Any suggestions to get this done?

 

Thanks

Hi there, after I install successfully without any error, step by step, I got this error when test user

please help me to solve this issue

Executed:echo User-Name='VPN',User-Password='*****' | radclient -c '1' -n '3' -r '3' -t '3' -x '127.0.0.1:1812' 'auth' 'testing123' 2>&1Results:(0) -: Expected Access-Accept got Access-Reject Sent Access-Request Id 178 from 0.0.0.0:60294 to 127.0.0.1:1812 length 43 User-Name = "VPN" User-Password = "*****" Cleartext-Password = "****" Received Access-Reject Id 178 from 127.0.0.1:1812 to 0.0.0.0:0 length 20

normally must work fine without any problem but now Access_Reject

thanks a lot

Dear Hitesh.

 

Thanks for this awesome and effective tutorial. Freeradius and Daloradius were successfully instaled, but after to logging on Daloradius web page, I obtain "daloradius db error connect failed".

Please, can yo help me?

Thanks for your attention and help.

Best regards.

Hi,

I am not sure if I have edited the file  /etc/freeradius/3.0/mods-enabled/sql correctly.

Please let me know what should be username and password combination I should use here. When I have followed your instruction, I was getting the following error:

root@ubuntu-04:/etc/freeradius/3.0/mods-enabled# systemctl restart freeradius

Job for freeradius.service failed because the control process exited with error code.

See "systemctl status freeradius.service" and "journalctl -xe" for details.

root@ubuntu-04:/etc/freeradius/3.0/mods-enabled# systemctl status freeradius.service

? freeradius.service - FreeRADIUS multi-protocol policy server

   Loaded: loaded (/lib/systemd/system/freeradius.service; enabled; vendor preset: enabled)

   Active: activating (auto-restart) (Result: exit-code) since Wed 2020-04-22 11:30:35 UTC; 1s ago

     Docs: man:radiusd(8)

           man:radiusd.conf(5)

           http://wiki.freeradius.org/

           http://networkradius.com/doc/

  Process: 5085 ExecStartPre=/usr/sbin/freeradius $FREERADIUS_OPTIONS -Cxm -lstdout (code=exited, status=1/FAILURE)

Appreciate if you could help with error message. Many thanks.

RajS

Dear,

Requirement is Mac Address Authenticationhow user/device authenticate without a password.client -- > AP(NAS) -- > Radius Serveri did but cannot get success.

Thanks for this tuto, i work fine, but have a problem in log send this mensage: ERROR: (7) sql: ERROR: rlm_sql_mysql: ERROR 1054 (Unknown column 'acctupdatetime' in 'field list'): 42S22need add in tables of mysql but i no have idea of this xDCan help? Thanks

 

Hi HItesh,

 

Thank you very much for this tutorial. Can you please let me know how and where to change the password of the administrator accunt for daloRADIUS? I think this is a serious security issue.

 

Thanks and best regards,

 

Jörg

Found it. Sorry. Please ignore my previous post.

I've followed the instructions as well as I can but I've run in to a hitch after making the changes to the /etc/freeradius/3.0/mods-enabled/sql file. When I try to restart the service I get this result.

Jul 02 08:34:42 slgpiradius01 freeradius[35639]: FreeRADIUS Version 3.0.20Jul 02 08:34:42 slgpiradius01 freeradius[35639]: Copyright (C) 1999-2019 The FreeRADIUS server project and contributorsJul 02 08:34:42 slgpiradius01 freeradius[35639]: There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR AJul 02 08:34:42 slgpiradius01 freeradius[35639]: PARTICULAR PURPOSEJul 02 08:34:42 slgpiradius01 freeradius[35639]: You may redistribute copies of FreeRADIUS under the terms of theJul 02 08:34:42 slgpiradius01 freeradius[35639]: GNU General Public LicenseJul 02 08:34:42 slgpiradius01 freeradius[35639]: For more information about these matters, see the file named COPYRIGHTJul 02 08:34:42 slgpiradius01 freeradius[35639]: Starting - reading configuration files ...Jul 02 08:34:42 slgpiradius01 freeradius[35639]: Debugger not attachedJul 02 08:34:42 slgpiradius01 freeradius[35639]: rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linkedJul 02 08:34:42 slgpiradius01 freeradius[35639]: Creating attribute SQL-GroupJul 02 08:34:42 slgpiradius01 freeradius[35639]: Creating attribute Unix-GroupJul 02 08:34:42 slgpiradius01 freeradius[35639]: rlm_sql_mysql: libmysql version: 8.0.20Jul 02 08:34:42 slgpiradius01 freeradius[35639]: Unable to check file "/etc/ssl/certs/my_ca.crt": No such file or directoryJul 02 08:34:42 slgpiradius01 freeradius[35639]: /etc/freeradius/3.0/mods-enabled/sql[87]: Failed parsing configuration item "ca_file"Jul 02 08:34:42 slgpiradius01 freeradius[35639]: /etc/freeradius/3.0/mods-enabled/sql[27]: Instantiation failed for module "sql"Jul 02 08:34:42 slgpiradius01 systemd[1]: freeradius.service: Control process exited, code=exited, status=1/FAILURE-- Subject: Unit process exited

The service is looking for a certificate file that it can't find. Where do I find this certificate?

In the last step after I press Login I get: 

This page isn’t working

127.0.0.1 is currently unable to handle this request.

HTTP ERROR 500

Hi Hitesh,thank you for your brilliant manual. Unfortunateley I get my Radius not running. Following problems occurred:1) "system restart freeradius" end" wirh an error message: Job for freeradius.service failed because the control process terminates with error code."systemctle status freedeadius" terminated with following error:root@ubuntu:/home/reinald# systemctl status freeradius? freeradius.service - FreeRADIUS multi-protocol policy server   Loaded: loaded (/lib/systemd/system/freeradius.service; disabled; vendor pres   Active: activating (auto-restart) (Result: exit-code) since Sat 2020-08-08 01     Docs: man:radiusd(8)           man:radiusd.conf(5)           http://wiki.freeradius.org/           http://networkradius.com/doc/  Process: 30198 ExecStartPre=/usr/sbin/freeradius $FREERADIUS_OPTIONS -Cxm -lstAug 08 01:03:21 ubuntu systemd[1]: freeradius.service: Control process exited, cAug 08 01:03:21 ubuntu systemd[1]: freeradius.service: Failed with result 'exit-Aug 08 01:03:21 ubuntu systemd[1]: Failed to start FreeRADIUS multi-protocol pol3) When starting the GUI the Home -> Server Status screen does not show a network interface:

I would be very grateful if you could help me - thanks.

 

Regards Reinald

Please ignore my last email, I got evrything running now, so far. The problem I still face is: There is no network interface in Server Status screen, it is simpl empty. Can anyone help? - thanks

Thank you very much for your contribution, everything works fine for me.

Before I used radius v2 and now with your manual I am using v3 but I have a problem that I don't know how to solve. my users are of the type user@domain (not [email protected]) in radius v2 if it works for me but in this version it does not accept special characters in the user. Does anyone know how to fix it?If the user were only user it works perfectly.

thanks, works perfect!

All things are OK. Thank you

I have the same error as other people, everything goes OK until I want to login daloradius, I use administrator/radius and get the error 

Database connection error

Error Message: DB Error: connect failed

How can I fi it? regars

hello, which version of ubuntu do you use?

I had the same error as I use ubuntu 20.04.