NEW Package: freeRADIUS 2.x

Nachtfalke

XMLRPC Sync with x.x.x.x has incomplete credentials

Perhaps you are using some special characters in your password which are not allowed.
Can you try a simple password like "password123" and then try again ?

It MUST be the password for the "admin" account of pfsense. no other account will work.

stupots

Hi,

Thanks for your very speedy reply. I'll try the attached files later today.

I attached you two files. Replace them with the existing ones in /usr/local/pkg

I used example one on this page. Try if it is ok or if there is something to be changed:
http://php.net/manual/en/function.md5.php

If you want to check the code edit freeradius.inc and watch lines 394-402

–- edit ---
it seems that we do not just need a md5 encoding but after that a base64 encoding of the md5 hash. Could you please try your cript with a password and post your password here and the according hash for that ? So we could do some more tests.
or someone could explain what is done in this perl script ;o)

For info, I implemented strong passwords on my Linux FreeRADIUS server based on info I found here:

http://www.packtpub.com/article/freeradius-authentication-storing-passwords

To be honest, it doesn't need to be an MD5 password but that's just the first thing I tried that worked. I was in a hurry yesterday when I posted - what I meant by "check box" was in the user creation tab, have a check box marked "encrypt password" and if selected, hash using MD5 or some other workable way.

If MD5 is the preferred option, then here are some sample hashes for you:

radius:~ # ./md5pass.pl hello
XUFAKrxLKna5cZ2REBfFkg==
radius:~ # ./md5pass.pl pfsense
OktMTd5JTSzsPg6mjkN+Fw==
radius:~ # ./md5pass.pl qwertyuiop
buqbfvGReaBpVO3Q9sBc6w==

Thanks,
Stuart

basterik

@Nachtfalke:

XMLRPC Sync with x.x.x.x has incomplete credentials
Perhaps you are using some special characters in your password which are not allowed.
Can you try a simple password like "password123" and then try again ?

It MUST be the password for the "admin" account of pfsense. no other account will work.

i using this config and i set admin password "123456", but server don't sync, I can't mistake, I set firewall that he logging packets between server, but I do not see any packet

Nachtfalke

@basterik:

@Nachtfalke:
XMLRPC Sync with x.x.x.x has incomplete credentials
Perhaps you are using some special characters in your password which are not allowed.
Can you try a simple password like "password123" and then try again ?

It MUST be the password for the "admin" account of pfsense. no other account will work.
i using this config and i set admin password "123456", but server don't sync, I can't mistake, I set firewall that he logging packets between server, but I do not see any packet

Strange. Are both systems using the same protocol and the same port ?
Can you try to set both to http and port 80.

But in general it works for me with different ports and protocols and some other users are using this, too.

Nachtfalke

@stupots:

Hi,

Thanks for your very speedy reply. I'll try the attached files later today.

I attached you two files. Replace them with the existing ones in /usr/local/pkg

I used example one on this page. Try if it is ok or if there is something to be changed:
http://php.net/manual/en/function.md5.php

If you want to check the code edit freeradius.inc and watch lines 394-402

–- edit ---
it seems that we do not just need a md5 encoding but after that a base64 encoding of the md5 hash. Could you please try your cript with a password and post your password here and the according hash for that ? So we could do some more tests.
or someone could explain what is done in this perl script ;o)

For info, I implemented strong passwords on my Linux FreeRADIUS server based on info I found here:

http://www.packtpub.com/article/freeradius-authentication-storing-passwords

To be honest, it doesn't need to be an MD5 password but that's just the first thing I tried that worked. I was in a hurry yesterday when I posted - what I meant by "check box" was in the user creation tab, have a check box marked "encrypt password" and if selected, hash using MD5 or some other workable way.

If MD5 is the preferred option, then here are some sample hashes for you:
radius:~ # ./md5pass.pl hello
XUFAKrxLKna5cZ2REBfFkg==
radius:~ # ./md5pass.pl pfsense
OktMTd5JTSzsPg6mjkN+Fw==
radius:~ # ./md5pass.pl qwertyuiop
buqbfvGReaBpVO3Q9sBc6w==
Thanks,
Stuart

Hi Stuart,

I think I got it. Then enconding in php is different than in perl but this hint gave me the reason:

If the optional raw_output is set to TRUE, then the md5 digest is instead returned in raw binary format with a length of 16\.

I attached the new freeradius.inc file. Try it again with that file, check if the passwords/hashes are correct and please try if it is really working/authentication.

freeradius.inc.txt

red2006

hello everyone…

im new to pfsense and im interested in implementing this to our school.

ive been reading the whole thread of this topic.

one thing caught my eyes and mind is the topic of @zlyzwy and @Nachtfalke about the SQL feature of freeradius

ive tried the ones posted by @zlyzwy on how to have a database table schema for the user authentication of captive portal

i used an external database server with XAMPP server running...
i created the database on the xampp server with the table schema's posted by @zlyzwy

i reconfigured the freeradius SQL, NAS/Clients, Interface and Captive Portal to redirect to the external database server...

but unfortunately, when i tried testing to connect to the external DB server radtest always gives me the no response from server message.
what could be the problem and why?

the normal CP + freeradius2 configuration with the user entry on freeradius works fine for me but i want to add 2,500 user accts and have a separate webGUI to process,add,delete users on the users table.

if @zlyzwy can only post again on how to populate the table and what tables on the table schema's that he posted should be populated for the user accts and how to connect it to an external db server.

i hope i hear soon from @zlyzwy and @Nachtfalke or anyone who could help me on this inquiry, thank you very much for this topic.

Nachtfalke

Can you run freeradius in debug mode and try again.
Configure everything on GUI, save and the stop the radiusd service on the GUI.

after that go to the pfsense console and type:

radiusd -X

Then try to authenticate a user and check the output of freeradius. It probably tells you what you have to do or what is not correct.

Or perhaps you are using a password which is using special characters which are not allowed. Try a simple password first.
Or the firewall rules on the xampp server do not allow traffic from pfsense - check this and disable all firewall rules.

red2006

Thank you very much for a fast reply on my inquiry.

i tried stopping the radius service on GUI and on console,
but i get the FAILED to connect to any sql server message of radiusd -X syntax.

attached are my configurations for

SQL in freeradius

Captive Portal

security setting on my xampp server

and the error message on the radiusd -X

maybe i miss something on the configuration but i just followed the instructions on this thread

Thank you very very much…

Nachtfalke

Hi,

your CP configuration looks wired. The authentication port for radius is 3306 - which is your sql port !? This looks strange.

To make clear the way how freeradius is working:

Freeradius has a listening port for authentication and if you need an accounting port
You must configure the ports on the "interfaces" tab of freeradius
The CP must connect to the listening ports of freeradius.

CP does not connect directly to the mysql database - it connects to freeradius and freeradius decides if to send the request to mysql or somewhere else.

In general the authentication port for freeradius is 1812 and the accounting port is 1813
and these two ports are important for the CP.

red2006

hello Nachtfalke,

and thank you very much for your patience…

i change my port on my captive portal config to 1812

but still same error appears on radiusd -X on console

rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
rlm_sql (sql): Attempting to connect to radius@192.168.1.7:3306/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_mysql: Couldn't connect socket to MySQL server radius@192.168.1.7:radius
rlm_sql_mysql: Mysql error 'Can't connect to MySQL server on '192.168.1.7' (60)'
rlm_sql (sql): Failed to connect DB handle #0
rlm_sql (sql): starting 1
rlm_sql (sql): starting 2
rlm_sql (sql): starting 3
rlm_sql (sql): starting 4
rlm_sql (sql): Failed to connect to any SQL server.
rlm_sql (sql): Processing generate_sql_clients
rlm_sql (sql) in generate_sql_clients: query is SELECT id, nasname, shortname, type, secret, server FROM nas
rlm_sql (sql): Ignoring unconnected handle 4..
rlm_sql (sql): Ignoring unconnected handle 3..
rlm_sql (sql): Ignoring unconnected handle 2..
rlm_sql (sql): Ignoring unconnected handle 1..
rlm_sql (sql): Ignoring unconnected handle 0..
rlm_sql (sql): There are no DB handles to use! skipped 5, tried to connect 0
Failed to load clients from SQL.
rlm_sql (sql): Closing sqlsocket 4
rlm_sql (sql): Closing sqlsocket 3
rlm_sql (sql): Closing sqlsocket 2
rlm_sql (sql): Closing sqlsocket 1
rlm_sql (sql): Closing sqlsocket 0
/usr/local/etc/raddb/sql.conf[2]: Instantiation failed for module "sql"
/usr/local/etc/raddb/sites-enabled/default[185]: Failed to load module "sql".
/usr/local/etc/raddb/sites-enabled/default[185]: Failed to parse "sql" entry.
/usr/local/etc/raddb/sites-enabled/default[69]: Errors parsing authorize section.

i attached my

nas/clients configuration here

and my interfaces configuration.

thank you very much for your patience Nachtfalke.

-red

nas.jpg_thumb

interfaces.jpg_thumb

DestekTeknik

Dear Fellas,

I've terribly noticed that, on my system, when accounting update mode from CP is selected as Start/Stop "Accounting", FreeRadius is counting triple times the actual value from time to time.

I mean I tested it with a 20 mi Forever account, and it killed the user at exactly 20 min later. But after that, the clients I've created, ended up so quickly, so I do a radtest check simultaniously with a client, and saw that, every 60 seconds, around 180 seconds are counted.

The only difference is the deadline date that I've given to the other accounts. They are also selected as Forever.

Any ideas?

DestekTeknik

One more question,

Which WebGUI are you using to manage freeRadius on a MySQL backend?

Nachtfalke

@red2006

Interfaces looks ok.

NAS/Clients:
You do not need to add the mysql server as a client. A client is only a sqitch, or an access point or the CP.
So it is not "mistake" to add the mysql server but it has no benefit :-)

I am no mysql expert but you should check the password of the mysql database and the user which has access to the database. the username and password must be entered on the freeradius -> SQL GUI.
Make sure that you chose the correct username and password.

There is nothing more I could tell you - I didn't connect freeradius to any sql database. Perhaps double check that the database name and tables are correct or perhaps contact user zlyzwy by PM.

@DestekTeknik
pfsense 2.0.1 has some problems with accounting. can you try with 2.0.2 and/or 2.1 ? There were some bugfixes on CP and accounting.
But if I remember correct there are some other threads on the forum which are telling a similar problem that yours.

You tested time quota, right ?
This should be implemented well in freeradius because it comes directly from the freeradius developers. So the problem probably lies in the CP code.
the traffic quota is just using some shell scripts which do the accounting. So it could be possible that there is something wrong.

Did you check the pfsense doc ?
http://doc.pfsense.org/index.php/FreeRADIUS_2.x_package

DestekTeknik

Yes I've tested the time quota, and I don't need the traffic quota.

I haven't tested on 2.1 cause I need a stable platform for this at the moment, and don't know how to get to 2.0.2 either…

I've read the documentation, and selected start/stop accounting setting based on the documentation, but at the moment, it is selected as interim update-not working as it should-but at least, updates the correct time when the user logouts. So no automated system to kick the user when the time is finished, just the hard logout time setting from the CP.

Do you prefer any WebGui's for the mysql management of freeradius? I'm looking into dialup-admin, but I believe they are both pointing to different table schema's so I have no idea if they work together.

Nachtfalke

I do not use any mysql database so do not use any GUI for that ;)
Other people are talking about "daloradius" but this seems to be more a complete product than just only a GUI.

DestekTeknik

daloradius-I am standing away from it at the moment, cause it is giving me headaches for the last year :)

anyway I'm dealing with dialup admin at the moment, if any of us is using it, a how-to guide will be appreciated :)

DestekTeknik

Hello folks,

I desperately need of a permanent file change in the default site file. I'm currently adding the only line I need via the edit file option of pfSense WebGUI, but the file reverts back to original after reboot. The line I add is "noresetcounter" under sql part.

Strange thing is, I also ad an attribute about Max-All-Session to the dictionary file, but that file stays the same after every reboot.

Does anyone have any ideas about this situation?

Nachtfalke

@DestekTeknik:

Hello folks,

I desperately need of a permanent file change in the default site file. I'm currently adding the only line I need via the edit file option of pfSense WebGUI, but the file reverts back to original after reboot. The line I add is "noresetcounter" under sql part.

Strange thing is, I also ad an attribute about Max-All-Session to the dictionary file, but that file stays the same after every reboot.

Does anyone have any ideas about this situation?

You need to modify the /usr/local/pkg/freeradius.inc file.

The dictionary file will be modified in this function:
freeradius_dictionary_resync()

Not sure where you did the sql changes.

DestekTeknik

@Nachtfalke:

@DestekTeknik:

Hello folks,

I desperately need of a permanent file change in the default site file. I'm currently adding the only line I need via the edit file option of pfSense WebGUI, but the file reverts back to original after reboot. The line I add is "noresetcounter" under sql part.

Strange thing is, I also ad an attribute about Max-All-Session to the dictionary file, but that file stays the same after every reboot.

Does anyone have any ideas about this situation?

You need to modify the /usr/local/pkg/freeradius.inc file.

The dictionary file will be modified in this function:
freeradius_dictionary_resync()

Not sure where you did the sql changes.

I've no problem with the changes that I've made to the dictionary file. They stay the same after the reboot.

I'm just adding a line saying "noresetcounter" to the /raddb/sites-available/default file, and this line is gone after the reboot.
I don't know how to make a change via the freeradius.inc file.
I've tried using Filer package, but because it starts after freeradius starts, It changes the file while freeradius is running, and this makes no difference for the first run. I have to restart the service manually to make it happen.

Can you suggest a solution to this?

the lines of default file look like after changing:

#  See "Authorization Queries" in sql.conf

         redundant {
			sql
			### sql2 DISABLED ###
	}
        noresetcounter ## I just add this line ##
#

Nachtfalke

Open the file /usr/local/pkg/freeradius.inc with an editor like vi.
Best way to connect to your pfsense using SSH and use the console. Type:


vi /usr/local/pkg/freeradius.inc

scroll down to the line 1232
There starts the function "freeradius_serverdefault_resync ()"
This function creates the ../sites-enabled/default file.
Starting from line 1396 to 2066 this is what is the part you need to change.