Freeradius with sql
Hello! I'm using freeradius server 3.0.11 compiled from source on a zyxel nsa320s. It is an arm5 based nas which has 2.6.31.8 kernel. It works perfectly, but I decided to use it with a mysql database. I Can't found the sql in mods-available folder, so i looked for what is wrong. I found the error. The redis package missing... So i compiled the redis and i recompiled freeradius. After it the sql module appeared and now useable. I edited the module and I tried to start it. It seems like started, but when I make a radtest in a parallel ssh window it rejects the attempt... Here is the output: http://pastebin.com/raw/pkEDuSrC And here is my module edit: http://pastebin.com/raw/nHTv8uQ2 Some technical info: - the nas ssh has chroot to /ffp - it has uClibc If you know the answer, please tell me about it! Best regards, Dan Ps: sorry for my bad English...
On Mar 5, 2016, at 1:28 PM, Mr Dini <diniboy74@gmail.com> wrote:
It works perfectly, but I decided to use it with a mysql database. I Can't found the sql in mods-available folder, so i looked for what is wrong. I found the error. The redis package missing... So i compiled the redis and i recompiled freeradius. After it the sql module appeared and now useable.
Redis has nothing to do with MySQL.
I edited the module and I tried to start it. It seems like started, but when I make a radtest in a parallel ssh window it rejects the attempt... Here is the output:
(0) sql: ERROR: Failed to create the pair: Invalid vendor name in attribute name "Password" See the docs. We've said to put passwords into the "Cleartext-Password" attribute for over a decade. "Password" doesn't exist. Alan DeKok.
Thanks for your quick reply, but it still not works... http://pastebin.com/raw/fNichSWW Alan DeKok <aland@deployingradius.com> ezt írta (2016. március 5., szombat):
On Mar 5, 2016, at 1:28 PM, Mr Dini <diniboy74@gmail.com> wrote:
It works perfectly, but I decided to use it with a mysql database. I Can't found the sql in mods-available folder, so i looked for what is wrong. I found the error. The redis package missing... So i compiled the redis and i recompiled freeradius. After it the sql module appeared and now useable.
Redis has nothing to do with MySQL.
I edited the module and I tried to start it. It seems like started, but when I make a radtest in a parallel ssh window it rejects the attempt... Here is the output:
(0) sql: ERROR: Failed to create the pair: Invalid vendor name in attribute name "Password"
See the docs. We've said to put passwords into the "Cleartext-Password" attribute for over a decade. "Password" doesn't exist.
Alan DeKok.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
On Mar 5, 2016, at 2:40 PM, Mr Dini <diniboy74@gmail.com> wrote:
Thanks for your quick reply, but it still not works...
It will work. Use: Cleartext-Password := "thepassword" Or whatever the password is. Read the getting started guide: http://freeradius.org/doc/getting_started.html Alan DeKok.
Ok, I reinstalled the mysql database, but now I have an other problem: http://pastebin.com/raw/D6bziYUX Alan DeKok <aland@deployingradius.com> ezt írta (2016. március 5., szombat):
On Mar 5, 2016, at 2:40 PM, Mr Dini <diniboy74@gmail.com> wrote:
Thanks for your quick reply, but it still not works...
It will work. Use:
Cleartext-Password := "thepassword"
Or whatever the password is. Read the getting started guide:
http://freeradius.org/doc/getting_started.html
Alan DeKok.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Oh. It was a big user error... Sorry! I didn't installed mysql perfectly at second time... Now I recompiled it and it works. It shows up acces-accept! :) Many-many thanks! Mr Dini <diniboy74@gmail.com> ezt írta (2016. március 6., vasárnap):
Ok, I reinstalled the mysql database, but now I have an other problem:
http://pastebin.com/raw/D6bziYUX
Alan DeKok <aland@deployingradius.com> ezt írta (2016. március 5., szombat):
On Mar 5, 2016, at 2:40 PM, Mr Dini <diniboy74@gmail.com> wrote:
Thanks for your quick reply, but it still not works...
It will work. Use:
Cleartext-Password := "thepassword"
Or whatever the password is. Read the getting started guide:
http://freeradius.org/doc/getting_started.html
Alan DeKok.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
No! It was early joy... It seems like nice, but when I try to connect it is aborts and kills the process... http://pastebin.com/raw/xUhG1WtR What's wrong? 2016-03-06 15:34 GMT+01:00 Mr Dini <diniboy74@gmail.com>:
Oh. It was a big user error... Sorry!
I didn't installed mysql perfectly at second time...
Now I recompiled it and it works. It shows up acces-accept! :)
Many-many thanks!
Mr Dini <diniboy74@gmail.com> ezt írta (2016. március 6., vasárnap):
Ok, I reinstalled the mysql database, but now I have an other problem:
http://pastebin.com/raw/D6bziYUX
Alan DeKok <aland@deployingradius.com> ezt írta (2016. március 5., szombat):
On Mar 5, 2016, at 2:40 PM, Mr Dini <diniboy74@gmail.com> wrote:
Thanks for your quick reply, but it still not works...
It will work. Use:
Cleartext-Password := "thepassword"
Or whatever the password is. Read the getting started guide:
http://freeradius.org/doc/getting_started.html
Alan DeKok.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
participants (2)
-
Alan DeKok -
Mr Dini