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

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

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

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 -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

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

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

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,

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

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. User