Re: Problem with accounting insert into Oracle

2012-08-14 Thread Aurélien Lafranchise
/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 hav

Re: Problem with accounting insert into Oracle

2012-08-13 Thread John Dennis
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 ma

Re: Problem with accounting insert into Oracle

2012-08-13 Thread Aurélien Lafranchise
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

Re: Problem with accounting insert into Oracle

2012-08-13 Thread John Dennis
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 Looking to carve

Re: Problem with accounting insert into Oracle

2012-08-13 Thread Aurélien Lafranchise
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

Re: Problem with accounting insert into Oracle

2012-08-13 Thread Alan DeKok
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

Problem with accounting insert into Oracle

2012-08-13 Thread Aurélien Lafranchise
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 dialup.

Re: Problem with accounting insert into Oracle

2012-08-13 Thread Aurélien Lafranchise
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

Re: Problem with accounting insert into Oracle

2012-08-13 Thread Alan DeKok
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 ca

Problem with accounting insert into Oracle

2012-08-13 Thread Aurélien Lafranchise
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 req

Re: Problem with accounting and sql

2011-12-09 Thread Paul Thornton
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 acco

Re: Problem with accounting and sql

2011-12-08 Thread Alan DeKok
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 l

Problem with accounting and sql

2011-12-08 Thread Paul Thornton
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 o

Re: FreeRADIUS and Asterisk. Problem with accounting

2010-06-08 Thread Alan DeKok
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

FreeRADIUS and Asterisk. Problem with accounting

2010-06-08 Thread Pawel Plato
Hi all. The problems start when I configure FreeRadius to insert RADIUS accounting data into SQL, in my case - postgreSQL database. I followed the steps on http://wiki.freeradius.org/SQL_HOWTO. FreeRadius creates SQL insert indeed, as you can see down below, but the thing is that the data fro

Re: Blank spaces after username - problem with accounting -MySqldatabase.

2008-01-24 Thread Marinko Tarlac
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 1.1.

Re: Blank spaces after username - problem with accounting -MySqldatabase.

2008-01-23 Thread A . L . M . Buxey
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 http://www.freeradius.org/li

Re: Blank spaces after username - problem with accounting -MySqldatabase.

2008-01-23 Thread Marinko Tarlac
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 H

Re: Blank spaces after username - problem with accounting -MySqldatabase.

2008-01-22 Thread Alan DeKok
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.

Re: Blank spaces after username - problem with accounting -MySqldatabase.

2008-01-22 Thread Kevin Bonner
On Tuesday 22 January 2008 13:20:27 Marinko Tarlac wrote: > 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? FreeRADIUS doesn't mangle usernames by default. > I repeat, user names and all other

Re: Blank spaces after username - problem with accounting -MySqldatabase.

2008-01-22 Thread Marinko Tarlac
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 account

Re: Blank spaces after username - problem with accounting -MySqldatabase.

2008-01-22 Thread Alan DeKok
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, t

Re: Blank spaces after username - problem with accounting -MySqldatabase.

2008-01-22 Thread Marinko Tarlac
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 thi

Re: Blank spaces after username - problem with accounting -MySqldatabase.

2008-01-22 Thread tnt
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 Informati

Re: Blank spaces after username - problem with accounting - MySqldatabase.

2008-01-22 Thread Marinko Tarlac
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 own

Re: Blank spaces after username - problem with accounting - MySqldatabase.

2008-01-22 Thread tnt
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

Re: Blank spaces after username - problem with accounting - MySql database.

2008-01-22 Thread Alan DeKok
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. > > sql_use

Re: Blank spaces after username - problem with accounting - MySql database.

2008-01-22 Thread Marinko Tarlac
> Neither. The user is adding the spaces. It looks to me like someone > figured out that you have test accounts. They are using the test > accounts to log in without paying. > > Well it is more than one account and they are random usernames (example, mirije, drogbba, etc. ) > You need to to

Re: Blank spaces after username - problem with accounting - MySql database.

2008-01-22 Thread Alan DeKok
Marinko Tarlac wrote: > 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

Blank spaces after username - problem with accounting - MySql database.

2008-01-21 Thread Marinko Tarlac
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.

Re: Problem with accounting

2008-01-14 Thread tnt
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

Re: Problem with accounting

2008-01-14 Thread liran tal
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 u

Re: Problem with accounting

2008-01-14 Thread inverse
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

Problem with accounting

2008-01-14 Thread Marinko Tarlac
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 mod

Re: Problem with Accounting.

2006-04-18 Thread Alejandro Sanchez
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

Re: Problem with Accounting.

2006-04-18 Thread Peter Nixon
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 me

Problem with Accounting.

2006-04-17 Thread Alejandro Sanchez
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 BYE of SIP dosen't trigger the stop of the accounting or th

Re: problem with accounting

2004-06-07 Thread Szabó György
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,

Re: problem with accounting

2004-06-07 Thread Szabó György
> 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: > >> &

Re[2]: problem with accounting

2004-06-04 Thread Alexander Lunyov
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 ac

Re: problem with accounting

2004-06-04 Thread Szabó György
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

Re: problem with accounting

2004-06-04 Thread Szabó György
2004. jÃnius 4. 11.59 dÃtummal Alexander Lunyov ezt Ãrta: > 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

Re: problem with accounting

2004-06-04 Thread Alexander Lunyov
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

problem with accounting

2004-06-04 Thread Szabó György
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