Duplicate SQL queries

2009-12-14 Thread Santiago Balaguer García
Hi, It is a long time since I work with FR and hotspots. I am using a Postgres database, but I want to move to a ORACLE database. To keep the consistency and the service I want to run simultaneously both databases, so the INSERTs and UPDATEs have to be done in Postgres and ORACLE

Re: Duplicate SQL queries

2009-12-14 Thread Josip Rodin
On Mon, Dec 14, 2009 at 09:04:11AM +, Santiago Balaguer García wrote: It is a long time since I work with FR and hotspots. I am using a Postgres database, but I want to move to a ORACLE database. To keep the consistency and the service I want to run simultaneously both databases,

Freeradius db.ippool is FULL Error : rlm_ippool: No available ip addresses in pool.

2009-12-14 Thread Gökhan ORHON
Hello, I have a big problem please HELP. I newbee for Radius, I am use freeradius 2.x on the Suse 11.1. (Vmware ESXi 3.5) I use ippool. (254 IP) I have a gprs POS machine. POS is work no problem but, When connect POS machine to radius server, and disconnect, ippool not free ip on the db. I

incorrect shared secret

2009-12-14 Thread James Devine
If a packet is received that contains an incorrect shared secret, should something be logged? Looking through the logs, it looks like freeradius still tries to process the request, the password is mangled, but no mention of incorrect shared secret as far as I get tell. - List

Re: Freeradius db.ippool is FULL Error : rlm_ippool: No available ip addresses in pool.

2009-12-14 Thread EasyHorpak.com
G?khan ORHON wrote: Hello, ? I have a big problem please HELP. ? I newbee for Radius, ? I am use freeradius 2.x on the Suse 11.1. (Vmware ESXi 3.5) I use ippool. (254 IP) I have a gprs POS machine. POS is work no problem but, ? When connect POS machine

Re: incorrect shared secret

2009-12-14 Thread Alan DeKok
James Devine wrote: If a packet is received that contains an incorrect shared secret, should something be logged? No. Looking through the logs, it looks like freeradius still tries to process the request, the password is mangled, but no mention of incorrect shared secret as far as I get

RE: Freeradius db.ippool is FULL Error : rlm_ippool: No available ip addresses in pool.

2009-12-14 Thread Gökhan ORHON
I am not use MySQL db. Only users file and db.ippool and db.ipindex file. From: freeradius-users-bounces+gokhan.orhon=provus.com...@lists.freeradius.org [mailto:freeradius-users-bounces+gokhan.orhon=provus.com...@lists.freeradius.org] On Behalf Of EasyHorpak.com Sent: Monday, December 14, 2009

RADIUS 2.x - modules not loaded correctly

2009-12-14 Thread Axel Vogel
Hi all I want to inform the community about a mistake I run into and wish that nobody run into this after me. It's my style to copy an original file to a backup version before modifying it. Therefore I copied the ${confdir}/modules/mschap to ${confdir}/modules/mschap.ori and edited the

Group and SQL issue

2009-12-14 Thread David Peterson
I am using the latest freeradius code with WiMax, Daloradius and MySQL. I am getting group rejects with the server complaining that it can't use MSCHAPv2. The confounding thing is that I had this working last week and it's now acting differently. Here is the debug: Mon Dec 14 12:32:14 2009 :

Re: sqlipool

2009-12-14 Thread tnt
Hello All, I did not fixed this problem. same configuration works on server (ubuntu). but on another server (freebsd) not works :( Please look to the 3 th line. its normally? (expand) +- entering group post-auth {...} [sqlippool] No Pool-Name defined. [sqlippool] expand -

Re: Freeradius db.ippool is FULL Error : rlm_ippool: No available ip addresses in pool.

2009-12-14 Thread tnt
Hello, I have a big problem please HELP. I newbee for Radius, I am use freeradius 2.x on the Suse 11.1. (Vmware ESXi 3.5) I use ippool. (254 IP) I have a gprs POS machine. POS is work no problem but, When connect POS machine to radius server, and disconnect, ippool not free ip on the

Re: Group and SQL issue

2009-12-14 Thread tnt
I am using the latest freeradius code with WiMax, Daloradius and MySQL. I am getting group rejects with the server complaining that it can't use MSCHAPv2. The confounding thing is that I had this working last week and it's now acting differently. Here is the debug: Password is wrong. Ivan

RE: Group and SQL issue

2009-12-14 Thread David Peterson
Yeah, I'm an id10t LOL Thanks for the help. David -Original Message- From: t...@kalik.net [mailto:t...@kalik.net] Sent: Monday, December 14, 2009 2:13 PM To: David Peterson-WirelessConnections; FreeRadius users mailing list Subject: Re: Group and SQL issue I am using the latest

RE: RADIUS 2.x - modules not loaded correctly

2009-12-14 Thread Gary Gatten
Interesting... I often do similar renaming so now I wonder if a similar issue is causing me problems on my test system Thanks for the FYI. G -Original Message- From: freeradius-users-bounces+ggatten=waddell@lists.freeradius.org

Yanıt: Re: Freeradius db.ippool is FULL Erro r : rlm_ippool: No available ip addresses in pool.

2009-12-14 Thread Gökhan ORHON
I know. But cant control many pos or devices power down directly. How db pool release active ip. I use rlm tool In the crontab every 30 minutes. But I think wrong way. Can you give for active session on the db ippool time out value or any way? Or different configuration. Note: this devices is

Re: RADIUS 2.x - modules not loaded correctly

2009-12-14 Thread Alan Buxey
hi, dont leave the unwanted/old modules in the modules directory. make a new directory called modules-available and put them into there. better still, emulate the method used for virtual servers and move modules to modules-available and then make a directory called modules and synlink the

Re: Yanıt: Re: Freeradius db.ippool is FULL Error : rlm _ippool: No available ip addresses in pool.

2009-12-14 Thread tnt
I know. But cant control many pos or devices power down directly. How db pool release active ip. I use rlm tool In the crontab every 30 minutes. But I think wrong way. Can you give for active session on the db ippool time out value or any way? Or different configuration. Note: this devices

Re: RADIUS 2.x - modules not loaded correctly

2009-12-14 Thread Axel Vogel
Hi Alan, your proposals are very good. I will not make my mistake a second time. But think of me as an administrator who takes a LINUX distribution with precompiled freeradiusd and who reads all the manuals and FAQs and then modifies the configuration files in an old-fashioned way and - nothing

Rejecting User By their Calling-Station-Id (Mac Address)

2009-12-14 Thread Alex M
Hey all, i'm coming back here w/ my old question of how to reject users based on their MAC address... but now im running FR 2.x.x So, we have trial access for free, and some people figured that they can re-register new accounts for trial all over again and have fun this way. Well thats not fun

RE: Freeradius-Users Digest, Vol 56, Issue 88

2009-12-14 Thread Nadir M. Aliyev
Hello All, I did not fixed this problem. same configuration works on server (ubuntu). but on another server (freebsd) not works :( Please look to the 3 th line. its normally? (expand) +- entering group post-auth {...} [sqlippool] No Pool-Name defined. [sqlippool] expand -

radiusd -X

2009-12-14 Thread kachin Agarwal
Hi, Whenever i use radiusd -X i get the following  : This is a part of radiusd -X Sending Access-Challenge of id 8 to 127.0.0.1 port 10004     Tunnel-Type:0 = VLAN     Tunnel-Medium-Type:0 = IEEE-802     Tunnel-Private-Group-Id:0 = 2     Symbol-User-Group = moto     Symbol-Downlink-Limit-Kbps =

Re: RADIUS 2.x - modules not loaded correctly

2009-12-14 Thread Alan DeKok
Axel Vogel wrote: My warning: Beware of having private files in ${confdir}/modules. All of the files in the modules directory are loaded. This is just like Apache, and other systems using a module system. Alan DeKok. - List info/subscribe/unsubscribe? See

Re: radiusd -X

2009-12-14 Thread Alan DeKok
kachin Agarwal wrote: Whenever i use radiusd -X i get the following : ... i did not understand the waking up in 4.9 sec ?? Why does it wait for.? It's waiting for something to do, like the NAS sending it a packet. can we remove this? No. Alan DeKok. - List

Re: Rejecting User By their Calling-Station-Id (Mac Address)

2009-12-14 Thread Alan DeKok
Alex M wrote: Hey all, i'm coming back here w/ my old question of how to reject users based on their MAC address... but now im running FR 2.x.x So, we have trial access for free, and some people figured that they can re-register new accounts for trial all over again and have fun this way.