Re: Freeradius + PostgreSQL not working

Guy Fraser Wed, 21 Apr 2004 12:58:16 -0700

This is what I am using {I am not using 0.9.3, but 1.0-pre0 from CVS} for radiusd.conf :

...snip...
modules {
...snip...
       $INCLUDE  ${confdir}/postgresql.conf
...snip...
}
...snip...
authorize {
       preprocess
       chap
       mschap
       suffix
       eap
# 'files' can be uncommented if you do NOT have a
# default 'Auth-Type' in the 'users' file.
#        files
       sql
       daily
}
...snip...
accounting {
       acct_unique
       detail
       unix
       radutmp
       sql
}
session {
       radutmp
       sql
}
post-auth {
       sql
}
...snip...

The test data I use is listed below, the password for troll is skunk, but is 'MD5' encrypted, so linux must be configured to athenticate with MD5.

Here is the test data I use :
... %< cut here ...
COPY radcheck (id, username, attribute, op, value) FROM stdin;
1       fredf   User-Password   ==      wilma
2       barneyr User-Password   ==      betty
3       troll   Crypt-Password  ==      $1$ODa8qvTP$DWfshR5SI4uSIp68a3DfD1
4       frog    User-Password   ==      kermit
\.

COPY radgroupcheck (id, groupname, attribute, op, value) FROM stdin; \.

COPY radgroupreply (id, groupname, attribute, op, value) FROM stdin;
1       ppp-unlimited   Framed-Compression      :=      Van-Jacobsen-TCP-IP
2       ppp-unlimited   Framed-Protocol :=      PPP
3       ppp-unlimited   Service-Type    :=      Framed-User
4       ppp-unlimited   Framed-MTU      :=      1500
5       ppp-static      Framed-Compression      :=      Van-Jacobsen-TCP-IP
6       ppp-static      Framed-Protocol :=      PPP
7       ppp-static      Service-Type    :=      Framed-User
8       ppp-static      Framed-MTU      :=      1500
9       nas-prompt      Framed-MTU      :=      1500
10      nas-prompt      Framed-Compression      :=      Van-Jacobson-TCP-IP
11      nas-prompt      Service-Type    :=      NAS-Prompt
\.

COPY radreply (id, username, attribute, op, value) FROM stdin;
1       barneyr Framed-IP-Address       :=      10.19.65.38
2       barneyr Framed-IP-Netmask       :=      255.255.255.252
\.

COPY usergroup (id, username, groupname) FROM stdin;
1       fredf   ppp-unlimited
2       barneyr ppp-static
3       troll   ppp-unlimited
4       frog    nas-prompt
\.
... %< cut here ...
Note : Spaces are supposed to be TAB's

VoipOne NOC wrote:

Hi
I have freeradius 0.9.3, compiled on a Debian Unstable system for PostgreSQL
support.
Once I installe everything, it seems to work right. Following is the final
output from "freeradius -xxyz -l stdout" :
Listening on IP address *, ports 1812/udp and 1813/udp, with proxy on
1814/udp.
Ready to process requests.
And when I try to send the radius packets for accounting from my Cisco
router, it just doesn't work
I have the following lines changed in my radiusd.conf: with_cisco_vsa_hack = yes $INCLUDE ${confdir}/postgresql.conf #unix (wtmp file) * commented out #radutmp * commented out Added sql instead of the unix accounting method.

If anyone has experience with this, please let me know what I can do.

Regards.

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

Re: Freeradius + PostgreSQL not working

Reply via email to