FreeRadius with Postgresql

Sunday Olutayo olutayo at sadeeb.com.ng
Thu Mar 19 11:56:21 CET 2009


I install the freeradius from the Ubuntu repo.

Sunday Olutayo


----- Original Message -----
From: freeradius-users-request at lists.freeradius.org
To: freeradius-users at lists.freeradius.org
Sent: Thursday, 19 March, 2009 11:41:36 GMT +01:00 West Central Africa
Subject: Freeradius-Users Digest, Vol 47, Issue 92

Send Freeradius-Users mailing list submissions to
	freeradius-users at lists.freeradius.org

To subscribe or unsubscribe via the World Wide Web, visit
	http://lists.freeradius.org/mailman/listinfo/freeradius-users
or, via email, send a message with subject or body 'help' to
	freeradius-users-request at lists.freeradius.org

You can reach the person managing the list at
	freeradius-users-owner at lists.freeradius.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Freeradius-Users digest..."


Today's Topics:

   1. Re: FreeRadius with Postgresql (A.L.M.Buxey at lboro.ac.uk)
   2. Re: MacOS X Leopard version of FR crashing with segmentation
      fault (Alan DeKok)
   3. Re: freeradius and mikrotik auth problem pppoe error 691
      (tnt at kalik.net)
   4. Re: Adding users in the database from a client computer
      (tnt at kalik.net)
   5. Re: radclient: problem with exit code 0 and 1 (oz)
   6. Re: FreeRadius with Postgresql (tnt at kalik.net)
   7. Re: radclient: problem with exit code 0 and 1 (tnt at kalik.net)
   8. Re: dear everyone.. (Nizar Zulmi)


----------------------------------------------------------------------

Message: 1
Date: Thu, 19 Mar 2009 09:40:55 +0000
From: A.L.M.Buxey at lboro.ac.uk
Subject: Re: FreeRadius with Postgresql
To: FreeRadius users mailing list
	<freeradius-users at lists.freeradius.org>
Message-ID: <20090319094055.GC4883 at lboro.ac.uk>
Content-Type: text/plain; charset=us-ascii

Hi,

> On following the messages; this is what I get from running freeradius -X
> but before point it to PostgreSQL it runs fine.

<snip>
 
> rlm_sql (sql): Could not link driver rlm_sql_postgresql: rlm_sql_postgresql.so: cannot open shared object file: No such file or directory
> rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the search path of your system's ld.

fairly straight forward - did you build this server yourself? If so, 
did you check the output of the ./configure stage? looks like it
hasnt built the postgres modules - probably because the required
postgres devel package wasnt installed at the time.

if this is from a package, check that there isnt some additional
part package that provides the postgres functionality - I note
that several distros split FR into multiple parts.

alan


------------------------------

Message: 2
Date: Thu, 19 Mar 2009 11:08:11 +0100
From: Alan DeKok <aland at deployingradius.com>
Subject: Re: MacOS X Leopard version of FR crashing with segmentation
	fault
To: FreeRadius users mailing list
	<freeradius-users at lists.freeradius.org>
Message-ID: <49C2198B.3050706 at deployingradius.com>
Content-Type: text/plain; charset=ISO-8859-1

Randall Newman wrote:
> I looked at the permissions but everything looks ok, so still not sure
> why the -x  and -xx options are not working, but that's not my main
> problem. I did notice one strange thing in the log shortly before one of
> the segmentation faults. Not sure if its related but perhaps someone
> here can shed some light:
> 
> radiusd(32122,0xa0479720) malloc: *** error for object 0x1d3610:
> incorrect checksum for freed object - object was probably modified after
> being freed.
> *** set a breakpoint in malloc_error_break to debug

  Yes, that would be related.  It's a bug.

  The simple suggestion is to upgrade to a recent version, which won't
have this bug.

  Alan DeKok.


------------------------------

Message: 3
Date: Thu, 19 Mar 2009 11:08:33 +0100
From: <tnt at kalik.net>
Subject: Re: freeradius and mikrotik auth problem pppoe error 691
To: "FreeRadius users mailing list"
	<freeradius-users at lists.freeradius.org>
Message-ID: <ABOLfBNb.1237457313.6016940.tnt at kalik.net>
Content-Type: text/plain; charset=ISO-8859-2

>I don`t have firewall
>How i solve the problem ?

Yes, you do. Things like iptables are also firewalls. Use wireshark to
find where are packets stopped. And then fix it.

Ivan Kalik
Kalik Informatika ISP



------------------------------

Message: 4
Date: Thu, 19 Mar 2009 11:20:26 +0100
From: <tnt at kalik.net>
Subject: Re: Adding users in the database from a client computer
To: "FreeRadius users mailing list"
	<freeradius-users at lists.freeradius.org>
Message-ID: <Xy7curVV.1237458026.1324940.tnt at kalik.net>
Content-Type: text/plain; charset=ISO-8859-2

>Again, I'm a relatively new freeradius user so I am not really an expert
>with it.
>
>In our project, we need to "add" and "delete" users from the server database
>from an authorized client computer.

See:

- dialup admin (included with the server)

- daloRadius (same thing but under active development)

- phpMy Admin (works directly with the database; requires for you to know
what you are doing- if you don't use the admin tools above)

Ivan Kalik
Kalik Informatika ISP



------------------------------

Message: 5
Date: Thu, 19 Mar 2009 11:23:53 +0100
From: oz <oz at bluemonk.de>
Subject: Re: radclient: problem with exit code 0 and 1
To: FreeRadius users mailing list
	<freeradius-users at lists.freeradius.org>
Message-ID: <49C21D39.9080304 at bluemonk.de>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed


Alan DeKok wrote:
> oz wrote:
>> the normal behavior of radclient seems to get lost somewhere in the
>> versions later than freeradius-0.7, where it worked:
> 
>   That's nice... but 1.1.x will NOT be fixed.
> 
>   I've committed a fix that will be in the next release of the server.
> If you need this functionality, upgrade.

Thanks, but for some reasons I cannot do updates to the upcoming release on 
that server. So I compiled 0.7 this morning, just to get the radclient tool 
from that release. It was succesfully built, yeay, but has another bug with 
masking the password when it is used in the radtest-script :-/

  Sending Access-Request of id 110 to 192.168.X.X:1812
         User-Name = "testuser"
         User-Password = "\360\213[p\224\212I\314\217\343\361\214\370\326\351$"

Do you have an idea, which freeradius version after 0.7 has a working exit code 
1, but is free from that other problem with the password-masking? Then I'd like 
to try that.

Else I would have to test-compile the 19 releases between 0.7 and 1.1.7 for a 
possible workaround.

oz








------------------------------

Message: 6
Date: Thu, 19 Mar 2009 11:31:43 +0100
From: <tnt at kalik.net>
Subject: Re: FreeRadius with Postgresql
To: "FreeRadius users mailing list"
	<freeradius-users at lists.freeradius.org>
Message-ID: <2MX3ZcOA.1237458703.3584630.tnt at kalik.net>
Content-Type: text/plain; charset=ISO-8859-2

>rlm_sql (sql): Could not link driver rlm_sql_postgresql: rlm_sql_postgresql.so: cannot open shared object file: No such file or directory
>rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the search path of your system's ld.
>radiusd.conf[11]: sql: Module instantiation failed.
>radiusd.conf[1860] Unknown module "sql".
>radiusd.conf[1789] Failed to parse authorize section.

http://wiki.freeradius.org/index.php/FreeRADIUS_Wiki:FAQ#It_says_.22Could_not_link_..._file_not_found.22.2C_what_do_I_do.3F

Ivan Kalik
Kalik Informatika ISP



------------------------------

Message: 7
Date: Thu, 19 Mar 2009 11:37:47 +0100
From: <tnt at kalik.net>
Subject: Re: radclient: problem with exit code 0 and 1
To: "FreeRadius users mailing list"
	<freeradius-users at lists.freeradius.org>
Message-ID: <grm8YwoX.1237459067.9781960.tnt at kalik.net>
Content-Type: text/plain; charset=ISO-8859-2

>from that release. It was succesfully built, yeay, but has another bug with
>masking the password when it is used in the radtest-script :-/
>
>  Sending Access-Request of id 110 to 192.168.X.X:1812
>         User-Name = "testuser"
>         User-Password = "\360\213[p\224\212I\314\217\343\361\214\370\326\351$"
>

Not a bug. Shared secret is wrong.

Ivan Kalik
Kalik Informatika ISP



------------------------------

Message: 8
Date: Thu, 19 Mar 2009 03:41:30 -0700 (PDT)
From: Nizar Zulmi <siapa_bilang_emailku_panjang at yahoo.com>
Subject: Re: dear everyone..
To: FreeRadius users mailing list
	<freeradius-users at lists.freeradius.org>
Message-ID: <820558.16835.qm at web30401.mail.mud.yahoo.com>
Content-Type: text/plain; charset="iso-8859-1"

still can't get it. can u show me please which script to do benchmarking the RADIUS server, and how to running the script,.


--- On Thu, 3/19/09, A.L.M.Buxey at lboro.ac.uk <A.L.M.Buxey at lboro.ac.uk> wrote:

From: A.L.M.Buxey at lboro.ac.uk <A.L.M.Buxey at lboro.ac.uk>
Subject: Re: dear everyone..
To: "FreeRadius users mailing list" <freeradius-users at lists.freeradius.org>
Date: Thursday, March 19, 2009, 4:20 PM


-----Inline Attachment Follows-----

Hi,
> iam a new bie freeradius user, i have a duty from my lecture to build a hotspot captive portal using chillispot and freeradius. now i make it, chilispot and freeradius working well on ubuntu machine, but the problem is my lecture want me to do stress test on the radius server to make sure that the system is still working well in any condition..
> 
> i still confused how to perform the stress test...anyone help me please..thank you for your attentionsorry for bad english :D

there are a couple of scripts supplied with the server to allow
benchmarking which hit the server fast and hard. run a couple
of those whilst eg flood pinging the system.? but 'any condition'
is hardly any kind of scientific or useful phrase. for example,
is the system working well if half the packets get lost? does
the system work well if packets are routed in different directions?
does the system work well when an idiot logs into the box and runs
other random processes that take up CPU time (nice bit of SETI or
D2OL etc)?? quantify the scenarios before you can demonstrate behaviour.
useful exercise as you might uncover some wierd corner case to
help improve the server (I've found several Linux kernel issues
over the years on very stressed servers)

alan
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freeradius.org/pipermail/freeradius-users/attachments/20090319/b11516fa/attachment.html>

------------------------------

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


End of Freeradius-Users Digest, Vol 47, Issue 92
************************************************



More information about the Freeradius-Users mailing list