/etc/raddb/certs was copied too! How to regenerate the certificates ?
In general, how to install a copy of a radius server to another box ?
For my SQL problem, any idea ?
Thanks all
AL
Le 13 août 2012 à 18:35, John Dennis a écrit :
On 08/13/2012 11:41 AM, Aurélien Lafranchise wrote:
I have
Hi,
I have the same error for every request in dialup.conf (STOP, START, UPDATE).
The database connection is working well but I have:
[sql] Couldn't insert SQL accounting STOP record - ORA-01756: quoted string not
properly terminated
with sqltrace on you can see the mistake at the end. The
Aurélien Lafranchise wrote:
I have the same error for every request in dialup.conf (STOP, START, UPDATE).
The database connection is working well but I have:
[sql] Couldn't insert SQL accounting STOP record - ORA-01756: quoted string
not properly terminated
with sqltrace on you can see
It seems that Freeradius is getting stuck when inserting hex chain. Does that
remind something to someone ?
AL
Le 13 août 2012 à 13:42, Aurélien Lafranchise a écrit :
Hi,
I have the same error for every request in dialup.conf (STOP, START, UPDATE).
The database connection is working
Hi Alan,
Thanks for the answer.
I need all these data so it is not a clean problem. But I will disable sqltrace
when everything will be ok.
Could you be more precise on where to increase the 2K limit ?
Cheers,
AL
Aurélien Lafranchise wrote:
I have the same error for every request in
Aurélien Lafranchise wrote:
Could you be more precise on where to increase the 2K limit ?
All over the place in rlm_sql.c and sql.c.
Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Ok, it is what I thought.
It is strange: it was working well on Freeradius 2.1.10-1 and not on my fresh
install 2.1.12-3. Any idea ?
AL
Aurélien Lafranchise wrote:
Could you be more precise on where to increase the 2K limit ?
All over the place in rlm_sql.c and sql.c.
Alan DeKok.
Le 13
On 08/13/2012 11:10 AM, Aurélien Lafranchise wrote:
It is strange: it was working well on Freeradius 2.1.10-1 and not on my
fresh install 2.1.12-3. Any idea ?
Do you have any .rpmnew or .rpmsave files under /etc/raddb? If so the
server will try to load them.
--
John Dennis
I have installed a new linux and it is a fresh install. I copied /etc/raddb
from one box to another that's all !
The other difference is that I switch from Fedora 14 to CentOS 6.3.
AL
Le 13 août 2012 à 17:28, John Dennis a écrit :
On 08/13/2012 11:10 AM, Aurélien Lafranchise wrote:
It is
On 08/13/2012 11:41 AM, Aurélien Lafranchise wrote:
I have installed a new linux and it is a fresh install. I copied
/etc/raddb from one box to another that's all !
What about your /etc/raddb/certs? Did you copy that too? If so you may
have problems if the server cert does not match the new
Hi Alan,
On 09/12/2011 01:57, Alan DeKok wrote:
OK... the debug log shows you have a little more upgrading to do for
it work best in 2.x, but that's OK.
Indeed - as I have my head in FreeRADIUS today, it may well be time to
clear out all those old User-Passwords!
Except that the
Hi
I've been trying to debug why accounting information isn't making it
into the SQL database on our main FR server (2.1.11) - it seems that
this has been the case since upgrading from version 1.something ancient
a few months back.
I have a fairly simple MySQL backed setup - and minimal changes
Paul Thornton wrote:
I've been trying to debug why accounting information isn't making it
into the SQL database on our main FR server (2.1.11) - it seems that
this has been the case since upgrading from version 1.something ancient
a few months back.
OK... the debug log shows you have a
Pawel Plato wrote:
... I thought that FreeRadius will somehow map these
values from Asterisk to values which can be put to radacct table,
Not everyone has an Asterisk server. There are standard RADIUS
attributes which everyone else uses.
See raddb/sql/mysql/dialup.conf. It contains the
It is solved now. I deleted FR .4 and migrated to .7 with fresh clean
install. I didn't use the old files.
Thanks
[EMAIL PROTECTED] wrote:
Hi,
Please don't be angry. I'm trying to fix this issue because it works
perfectly on FR1.1.7
if you've copied the config files direct from
Please don't be angry. I'm trying to fix this issue because it works
perfectly on FR1.1.7
Now I'm completely sure that problem is on my side but radius is on default
setup. Only thing we changed is uncommenting sql statements (for simul
check, author, and account.) in radiusd.conf.
Case closed
Hi,
Please don't be angry. I'm trying to fix this issue because it works
perfectly on FR1.1.7
if you've copied the config files direct from 1.1.7 to a 2.0.0
system then there will be quirks.
wheres the full debug log?
alan
-
List info/subscribe/unsubscribe? See
There is a configuration line in radiusd.conf:
nospace_user = yes (default is no)
that will remove trailing space even when entered. By the user. It
doesn't help if the trailing space is in the database.
Ivan Kalik
Kalik Informatika ISP
Dana 22/1/2008, Marinko Tarlac [EMAIL PROTECTED] piše:
Marinko Tarlac wrote:
Well it is more than one account and they are random usernames (example,
mirije, drogbba, etc. )
FreeRADIUS does not add spaces to user names. Again, run it in
debugging mode to see *exactly* what it is seeing.
Inside sql.conf everything seems fine.
It's more likely to be a MySQL bug. Try the same with a user entry in
users file - if user can authenticate with and without trailing space
then it is freeradius bug. If SELECT . 'test' and SELECT .
'test ' produce the same output, then the problem is with MySQL.
Ivan Kalik
Kalik
Thanks but this option didn't help.
I tried with random username and when I add blank space after username user
still can connect... Seems like a radius bug so I will try to install newer
version.
In any case I will inform you about this... Until I fix this issue I will
update radacct with my
MySQL is 5.0.x
Query SELECT * FROM `radcheck` WHERE `UserName` LIKE 'test.user '; (added
space) returns 0 records (not found)
Query SELECT * FROM `radcheck` WHERE `UserName` LIKE 'test.user'; (without
blank space) returns valid records. (password, simultaneus-use and other
check entries.
So
Marinko Tarlac wrote:
So this can be called as FreeRadius bug ?
No. As I have said, FreeRADIUS does not add spaces to user names.
This is the *first* time I can recall seeing this problem in almost 9
years of working with FreeRADIUS. It is *not* a FreeRADIUS issue.
If you see spaces,
Alan DeKok wrote:
a) the user has typed the user name with spaces
Yes. User has typed user name with space but why radius didn't ignore them?
I repeat, user names and all other records in database are without
space. User has entered space and he can connect but he can't see his
Marinko Tarlac wrote:
a) the user has typed the user name with spaces
Yes. User has typed user name with space but why radius didn't ignore them?
Why would it? Spaces are perfectly valid in a user name.
I repeat, user names and all other records in database are without
space. User
Hi there... It is me again... Few days ago, I wrote about my problem
with accounting. Problem is that accounting doesn't work for some users.
In this case it is test.user... After some investigation with log
files (holly radiusd -X), I can see that problem is in username. As you
can see (line
Hey Marinko,
On Jan 14, 2008 9:15 AM, Marinko Tarlac [EMAIL PROTECTED] wrote:
Hi
We have FreeRadius 1.1.4 and Mikrotik (as a NAS) with MySql as a database.
Accounting works fine for all users except for one user. Authentication
works fine and NAS sends updates as I specify for all users
Hi
We have FreeRadius 1.1.4 and Mikrotik (as a NAS) with MySql as a database.
Accounting works fine for all users except for one user. Authentication
works fine and NAS sends updates as I specify for all users and I can't find
any reason why it doesn't work for specific username.
In debugging
On Jan 14, 2008 9:15 AM, Marinko Tarlac [EMAIL PROTECTED] wrote:
Hi
We have FreeRadius 1.1.4 and Mikrotik (as a NAS) with MySql as a database.
Accounting works fine for all users except for one user. Authentication
works fine and NAS sends updates as I specify for all users and I can't find
Can you post the debug for Accounting Start packets for that user and one
that is being recorded.
Ivan Kalik
Kalik Informatika ISP
Dana 14/1/2008, Marinko Tarlac [EMAIL PROTECTED] piše:
Hi
We have FreeRadius 1.1.4 and Mikrotik (as a NAS) with MySql as a database.
Accounting works fine for all
Let's try again: you haven't posted the debug output. From this I can
see that access request are proxied but accounting one aren't. Post the
debug so we can see why.
On first glance there is a lot missing (Acct-Session-Time, number of
octets ...) from this accounting stop packet:
rad_recv:
The logs are given below for access request and accounting request.
*Proxy Radius Server Logs:*
*Access Request Logs *
Sending Access-Request of id 0 to 100.100.0.2 port 1812
Framed-IP-Address = 10.0.0.178
Calling-Station-Id = 00:0F:66:EE:BE:3A
User-Name = steve
User-Password = testing
Hi
I have configured the Free Radius Server to work as proxy radius server with
the following in the proxy.conf
realm NULL {
type = radius
authhost = 100.100.0.2:1812
accthost = 100.100.0.2:1813
secret = testing123
}
All the other conf files are configured properly. AM getting the
You haven't posted the debug output. Post one that has both access and
accounting requests for the same user.
Ivan Kalik
Kalik Informatika ISP
Dana 10/1/2008, Jayaraman Balasubramanian
[EMAIL PROTECTED] piše:
Hi
I have configured the Free Radius Server to work as proxy radius server with
the
Hi,
I have setup freeradius 1.1.2 in FreeBSD 6.0 with mysql support. I
have setup user in radcheck table as follows;
1403 | test01 | | || Max-All-Session | :=
| 1500|
The user test001 is allowed to login total for 25hrs. After finishing
25hrs if the user
On Tue 18 Apr 2006 00:55, Alejandro Sanchez wrote:
Hi. evrybody.
I am using freeradius with Sip Express Router (SER)
and i am enable accounting on freeradius 1.1.1 but in
the log files and the tables of freeradius only save
the start request, in other words when i finish a call
the method
Hi Peter.
I don't have de stop record in the detail file, when i
finish the call looks like radius dosen't recive the
BYE transaction..
--- Peter Nixon [EMAIL PROTECTED] escribió:
On Tue 18 Apr 2006 00:55, Alejandro Sanchez wrote:
Hi. evrybody.
I am using freeradius with Sip Express
thanks for the responses. i already do that, i set my client on port 1646, but
am just wondering why sometime the error message is still appearing in my
raduis.log?
Thanks,
Emman
Quoting Michael Mitchell [EMAIL PROTECTED]:
Your client is sending accounting packets to the port on which
Your client is sending accounting packets to the port on which
freeRADIUS is listening for proxy responses. Configure the client to
send accounting packets to the correct port (probably 1646), and you
should be good...
Emman S. Loloy wrote:
Hi guys,
anyone knows how to solve this problem?
Sat
Hello Szabo,
Friday, June 4, 2004, 2:24:08 PM, you wrote:
SG Excuse me for the last mail.
SG Here is the log file from radacct directory.
Hello Szab,
Friday, June 4, 2004, 1:56:02 PM, you wrote:
SG I have a problem with accounting. If accounting is turn off on AP,
then the SG
I'm sorry for the last mail.
Hello Szabo,
Friday, June 4, 2004, 2:24:08 PM, you wrote:
SG Excuse me for the last mail.
SG Here is the log file from radacct directory.
Hello Szab,
Friday, June 4, 2004, 1:56:02 PM, you wrote:
SG I have a problem with accounting. If accounting
Hi, my name is George.
I have a problem with accounting. If accounting is turn off on AP, then the
radius is working. If I turn on the accounting on AP, after authentication
few seconds the AP brakes the connection. I don't know why do this. Maybe I
should set some attributes for the users
Hello Szab,
Friday, June 4, 2004, 1:56:02 PM, you wrote:
SG I have a problem with accounting. If accounting is turn off on AP, then the
SG radius is working. If I turn on the accounting on AP, after authentication
SG few seconds the AP brakes the connection. I don't know why do this. Maybe I
SG
Excuse me for the last mail.
Here is the log file from radacct directory.
Hello Szab,
Friday, June 4, 2004, 1:56:02 PM, you wrote:
SG I have a problem with accounting. If accounting is turn off on AP, then
the SG radius is working. If I turn on the accounting on AP, after
authentication SG
44 matches
Mail list logo
