From dulgar@hotmail.com Tue Aug 26 00:40:19 2008
From: Ahmet =?utf-8?q?D=C3=9CLGAR?= <dulgar@hotmail.com>
To: freeradius-users@lists.freeradius.org
Subject: mysql configuration
Date: Tue, 26 Aug 2008 01:40:13 +0300
Message-ID: <BAY118-W52AF7EC09B141E69FAB402C6670@phx.gbl>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============7178985434038645436=="

--===============7178985434038645436==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable


hi everyone
i use fedora 9 and freeraidus 2.0.5
i want to use mysql database for user lists and i want to limit time users lo=
gin for example 3 hour or 3 days
i looked documents for howto wpa
i create the  radius db by db_mysql.sql
configure the sql.conf by writein login mysql password
and include sql.conf in radiusd.conf
=20
but i only cant correct the statement, i think they are for 1.1.7
authorise {	preprocess	chap	mschap	suffix	eap	# We leave "files" enabled to a=
llow creation of test users in /etc/raddb/users	files	sql	pap}accounting {	# =
We leave "detail" enabled to _additionally_ log accounting to /var/log/radius=
/radacct	detail	sql}
i add this statment end of the radiusd.conf but it doesnt work
i am new at freeradius and linux,
thanks for replay
=20
_________________________________________________________________
Gelen kutunuzda hi=C3=A7 yer kalmamas=C4=B1ndan b=C4=B1kt=C4=B1n=C4=B1z m=C4=
=B1? Windows Live Hotmail =C5=9Fimdi size 5GB =C3=9CCRETS=C4=B0Z depolama ala=
n=C4=B1 sunuyor! =C3=9Ccretsiz Windows Live Hotmail hesab=C4=B1n=C4=B1z=C4=B1=
 buradan al=C4=B1n!
http://get.live.com/mail/overview



--===============7178985434038645436==
Content-Type: text/html
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="attachment.html"
MIME-Version: 1.0

PGh0bWw+CjxoZWFkPgo8c3R5bGU+Ci5obW1lc3NhZ2UgUAp7Cm1hcmdpbjowcHg7CnBhZGRpbmc6
MHB4Cn0KYm9keS5obW1lc3NhZ2UKewpGT05ULVNJWkU6IDEwcHQ7CkZPTlQtRkFNSUxZOlRhaG9t
YQp9Cjwvc3R5bGU+CjwvaGVhZD4KPGJvZHkgY2xhc3M9J2htbWVzc2FnZSc+CmhpIGV2ZXJ5b25l
PEJSPgppIHVzZSBmZWRvcmEgOSBhbmQgZnJlZXJhaWR1cyAyLjAuNTxCUj4KaSB3YW50IHRvIHVz
ZSBteXNxbCBkYXRhYmFzZSBmb3IgdXNlciBsaXN0cyBhbmQgaSB3YW50IHRvIGxpbWl0IHRpbWUg
dXNlcnMgbG9naW4gZm9yIGV4YW1wbGUgMyBob3VyIG9yIDMgZGF5czxCUj4KaSBsb29rZWQgZG9j
dW1lbnRzIGZvciBob3d0byB3cGE8QlI+CmkgY3JlYXRlIHRoZSZuYnNwOyByYWRpdXMgZGIgYnkg
ZGJfbXlzcWwuc3FsPEJSPgpjb25maWd1cmUgdGhlIHNxbC5jb25mIGJ5IHdyaXRlaW4gbG9naW4g
bXlzcWwgcGFzc3dvcmQ8QlI+CmFuZCBpbmNsdWRlIHNxbC5jb25mIGluIHJhZGl1c2QuY29uZjxC
Uj4KJm5ic3A7PEJSPgpidXQgaSBvbmx5IGNhbnQgY29ycmVjdCB0aGUgc3RhdGVtZW50LCBpIHRo
aW5rIHRoZXkgYXJlIGZvciAxLjEuNzxCUj4KYXV0aG9yaXNlIHs8QlI+CXByZXByb2Nlc3M8QlI+
CWNoYXA8QlI+CW1zY2hhcDxCUj4Jc3VmZml4PEJSPgllYXA8QlI+CSMgV2UgbGVhdmUgImZpbGVz
IiBlbmFibGVkIHRvIGFsbG93IGNyZWF0aW9uIG9mIHRlc3QgdXNlcnMgaW4gL2V0Yy9yYWRkYi91
c2VyczxCUj4JZmlsZXM8QlI+CXNxbDxCUj4JcGFwPEJSPn08QlI+PEJSPmFjY291bnRpbmcgezxC
Uj4JIyBXZSBsZWF2ZSAiZGV0YWlsIiBlbmFibGVkIHRvIF9hZGRpdGlvbmFsbHlfIGxvZyBhY2Nv
dW50aW5nIHRvIC92YXIvbG9nL3JhZGl1cy9yYWRhY2N0PEJSPglkZXRhaWw8QlI+CXNxbDxCUj59
PEJSPgppIGFkZCB0aGlzIHN0YXRtZW50IGVuZCBvZiB0aGUgcmFkaXVzZC5jb25mIGJ1dCBpdCBk
b2VzbnQgd29yazxCUj4KaSBhbSBuZXcgYXQgZnJlZXJhZGl1cyBhbmQgbGludXgsPEJSPgp0aGFu
a3MgZm9yIHJlcGxheTxCUj4KJm5ic3A7PEJSPjxiciAvPjxociAvPkFpbGVuaXogdmUgYXJrYWRh
/mxhcv1u/XpsYSBwYXlsYf5tYWsgaedpbiBiaXIgYXlkYSA1MDAnZSBrYWRhciBmb3Rv8HJhZiBn
9m5kZXJpbiEg3mltZGkg/GNyZXRzaXogV2luZG93cyBMaXZlIEFsYW79bv16YSBnaWRpbiA8YSBo
cmVmPSdodHRwOi8vZ2V0LmxpdmUuY29tL3NwYWNlcy9vdmVydmlldycgdGFyZ2V0PSdfbmV3Jz5C
dXJheWEgdP1rbGEhPC9hPjwvYm9keT4KPC9odG1sPg==

--===============7178985434038645436==--


From aland@deployingradius.com Tue Aug 26 01:13:26 2008
From: Alan DeKok <aland@deployingradius.com>
To: freeradius-users@lists.freeradius.org
Subject: Re: mysql configuration
Date: Tue, 26 Aug 2008 01:12:26 +0200
Message-ID: <48B33C5A.8050306@deployingradius.com>
In-Reply-To: <BAY118-W52AF7EC09B141E69FAB402C6670@phx.gbl>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============4226333210173971628=="

--===============4226333210173971628==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 8bit

Ahmet DÜLGAR wrote:
> hi everyone
> i use fedora 9 and freeraidus 2.0.5
> i want to use mysql database for user lists and i want to limit time
> users login for example 3 hour or 3 days
> i looked documents for howto wpa

  Or... just read the examples that come with the server?

> but i only cant correct the statement, i think they are for 1.1.7
> authorise {
...
> i add this statment end of the radiusd.conf but it doesnt work

  See raddb/sites-available/default

  The "authorise", etc. sections have been moved there.

  Alan DeKok.

--===============4226333210173971628==--


From tnt@kalik.net Tue Aug 26 01:17:57 2008
From: Ivan Kalik <tnt@kalik.net>
To: freeradius-users@lists.freeradius.org
Subject: Re: mysql configuration
Date: Tue, 26 Aug 2008 00:17:52 +0100
Message-ID: <QrqRRHKT.1219706272.6939600.tnt@kalik.co.yu>
In-Reply-To: <BAY118-W52AF7EC09B141E69FAB402C6670@phx.gbl>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============2416147229775086847=="

--===============2416147229775086847==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

Read instructions at the end of radiusd.conf. It tels you where are those
sections in 2.0.5.

Ivan Kalik
Kalik Infoprmatika ISP


Dana 25/8/2008, "Ahmet D=C3=9CLGAR" <dulgar@hotmail.com> pi=C5=A1e:

>
>hi everyone
>i use fedora 9 and freeraidus 2.0.5
>i want to use mysql database for user lists and i want to limit time users l=
ogin for example 3 hour or 3 days
>i looked documents for howto wpa
>i create the  radius db by db_mysql.sql
>configure the sql.conf by writein login mysql password
>and include sql.conf in radiusd.conf
>
>but i only cant correct the statement, i think they are for 1.1.7
>authorise {	preprocess	chap	mschap	suffix	eap	# We leave "files" enabled to =
allow creation of test users in /etc/raddb/users	files	sql	pap}accounting {	#=
 We leave "detail" enabled to _additionally_ log accounting to /var/log/radiu=
s/radacct	detail	sql}
>i add this statment end of the radiusd.conf but it doesnt work
>i am new at freeradius and linux,
>thanks for replay
>
>_________________________________________________________________
>Gelen kutunuzda hi=C3=A7 yer kalmamas=C3=BDndan b=C3=BDkt=C3=BDn=C3=BDz m=C3=
=BD? Windows Live Hotmail =C5=A3imdi size 5GB =C3=9CCRETS=C3=9DZ depolama ala=
n=C3=BD sunuyor! =C3=9Ccretsiz Windows Live Hotmail hesab=C3=BDn=C3=BDz=C3=BD=
 buradan al=C3=BDn!
>http://get.live.com/mail/overview
>


--===============2416147229775086847==--


