Hi,
continueing:
http://lists.freeradius.org/pipermail/freeradius-users/2008-June/msg00677.html
@Alan de Kok
;) Thanks for keeping me so stupid even if I already said that I already
got it working a couple of setups on 1.1.7 - but I won't complain
because I seriously realy appreciate your help!
about my SQL configuration:
###############################################
cat sql.conf
[...]
database = "postgresql"
server = "localhost"
login = "radius"
password = "My_OwN_PaSsWoRd"
radius_db = "radius"
#and also:
sqltrace = yes
[...]
###############################################
AND
###############################################
cat radiusd.conf
[...]
$INCLUDE sql.conf
#$INCLUDE sql/mysql/counter.conf
$INCLUDE sql/postgresql/counter.conf
$INCLUDE sqlippool.conf
[...]
###############################################
^^ There is nothing mor useful to find about SQL in the radiusd.conf -
except the sql querrie samples provided in the [...]/raddb/sql/* folder
which I just left like they are - So I guess I configured right - the
modules are just still missed I think so. Correct me if you guess
something different.
BTW.: radiusd -X says *nothing* about sql or anything which sounds quite
similar like "sql" or postgres except the config it loads ;/
[...]
including configuration file /usr/local/etc/raddb/modules/sql_log
[...]
including configuration file /usr/local/etc/raddb/sql.conf
including configuration file /usr/local/etc/raddb/sql/postgresql/dialup.conf
including configuration file
/usr/local/etc/raddb/sql/postgresql/counter.conf
including configuration file /usr/local/etc/raddb/sqlippool.conf
including configuration file /usr/local/etc/raddb/sql/postgresql/ippool.conf
[...]
sadly no querry verboses ...
Thanks
############################################################################################
############################################################################################
############################################################################################
Continueing:
http://lists.freeradius.org/pipermail/freeradius-users/2008-June/msg00715.html
@David
Thank you very much for your efforts!!
Quote:
###
"
After untarring the FreeRADIUS 2.0.5 tarball and changing directory to
the root of the untarred tarball, these steps are roughly what you need:
LDFLAGS="-L/usr/local/lib -pthread" ; \
CFLAGS+="-I/usr/local/include -L/usr/local/lib" ; \
./configure --prefix=/usr/local --libdir=/usr/local/lib \
--localstatedir=/var --with-docdir=/usr/local/share/doc/freeradius \
--with-logdir=/var/log \
--with-openssl-includes=/usr/local/include/openssl \
--with-openssl-libraries=/usr/local/lib
gmake install
You must add --with-pic to the first command if using FreeBSD amd64. You
should omit the two openssl lines if you don't have the OpenSSL port
included. I don't recommend this - I really do believe it's better to
use the port.
"
###
Even if you suggest to rather use ports to install freeRADIUS on FreeBSD
System then compiling I rather compile because of various reasons.
But I might not understood you right in the way how to use those commands.
are those shell commands? Or might I have to add those 2 lines to an config?
bash$ LDFLAGS="-L/usr/local/lib -pthread"
bash$ CFLAGS+="-I/usr/local/include -L/usr/local/lib"
well the next one is clear:
bash$ ./configure --prefix=/usr/local --libdir=/usr/local/lib
--localstatedir=/var --with-docdir=/usr/local/share/doc/freeradius
--with-logdir=/var/log
--with-openssl-includes=/usr/local/include/openssl
--with-openssl-libraries=/usr/local/lib
and I do have amd64 so I'm guessing if I read right in the ./configure
--help that the ./configure command is supposed to look like:
bash$ ./configure --prefix=/usr/local --libdir=/usr/local/lib
--localstatedir=/var --with-docdir=/usr/local/share/doc/freeradius
--with-logdir=/var/log
--with-openssl-includes=/usr/local/include/openssl
--with-openssl-libraries=/usr/local/lib --with-pic
^^ because you mentioned to add --with-pic in the first command which
would be LDFLAGS="-L/usr/local/lib -pthread" --> which didn't make sense
for me to add it there?! correct me if I'm wrong.
#################################################################
BTW - here is a printout of WARNINGS what's not being there when I used
the "./configure --prefix=........" command given from you above:
config.status: WARNING: ./Make.inc.in seems to ignore the --datarootdir
setting
config.status: WARNING: ./src/include/build-radpaths-h.in seems to
ignore the --datarootdir setting
chmod: check-radiusd-config: No such file or directory
configure: WARNING: silently not building rlm_eap_ikev2.
configure: WARNING: FAILURE: rlm_eap_ikev2 requires: libeap-ikev2
EAPIKEv2/connector.h.
configure: WARNING: the TNCS library isn't found!
configure: WARNING: silently not building rlm_eap_tnc.
configure: WARNING: FAILURE: rlm_eap_tnc requires: -lTNCS.
configure: WARNING: silently not building rlm_krb5.
configure: WARNING: FAILURE: rlm_krb5 requires: krb5.
configure: WARNING: silently not building rlm_ldap.
configure: WARNING: FAILURE: rlm_ldap requires: libldap_r ldap.h.
configure: WARNING: silently not building rlm_python.
configure: WARNING: FAILURE: rlm_python requires: python-binary.
configure: WARNING: oracle headers not found. Use
--with-oracle-home-dir=<path>.
configure: WARNING: silently not building rlm_sql_oracle.
configure: WARNING: FAILURE: rlm_sql_oracle requires: oci.h.
[...]
config.status: config.h is unchanged
=== configuring in ./drivers/rlm_sql_postgresql
(/usr/src/freeradius-server-2.0.5/src/modules/rlm_sql/./drivers/rlm_sql_postgresq
l)
configure: running /usr/local/bin/bash ./configure
'--prefix=/usr/local' '--libdir=/usr/local/lib' '--localstatedir=/var'
'--wit
h-docdir=/usr/local/share/doc/freeradius' '--with-logdir=/var/log'
'--with-openssl-includes=/usr/local/include/openssl' '--with-o
penssl-libraries=/usr/local/lib' '--with-pic' '--enable-ltdl-install'
--cache-file=/dev/null --srcdir=.
checking for gcc... gcc
[...]
#################################################################
AND
#################################################################
"gmake install" also tells me that postgresql stuff is going to be
installed ...
libtool: install: warning: relinking `rlm_realm.la'
Making install in rlm_sql_postgresql...
gmake[11]: Entering directory
`/usr/src/freeradius-server-2.0.5/src/modules/rlm_sql/drivers/rlm_sql_postgresql'
if [ "xrlm_sql_postgresql" != "x" ]; then \
rlm_sql_postgresql.la /usr/local/lib/rlm_sql_postgresql.la ||
exit $?; \
rm -f /usr/local/lib/rlm_sql_postgresql-2.0.5.la; \
ln -s rlm_sql_postgresql.la
/usr/local/lib/rlm_sql_postgresql-2.0.5.la || exit $?; \
/usr/src/freeradius-server-2.0.5/install-sh -c -c
.libs/rlm_sql_postgresql-2.0.5.so /usr/local/lib/rlm_sql_postgresql-2.0.5.so
(cd /usr/local/lib && { ln -s -f rlm_sql_postgresql-2.0.5.so
rlm_sql_postgresql.so || { rm -f rlm_sql_postgresql.so && ln -s
rlm_sql_postgresql-2.0.5.so rlm_sql_postgresql.so; }; })
/usr/src/freeradius-server-2.0.5/install-sh -c -c
.libs/rlm_sql_postgresql.lai /usr/local/lib/rlm_sql_postgresql.la
/usr/src/freeradius-server-2.0.5/install-sh -c -c
.libs/rlm_sql_postgresql.a /usr/local/lib/rlm_sql_postgresql.a
chmod 644 /usr/local/lib/rlm_sql_postgresql.a
ranlib /usr/local/lib/rlm_sql_postgresql.a
gmake[11]: Leaving directory
`/usr/src/freeradius-server-2.0.5/src/modules/rlm_sql/drivers/rlm_sql_postgresql'
libtool: install: warning: relinking `rlm_sql.la'
#################################################################
^^ So if I understood the verbose logging printout right - it's actually
supposed to work?!
Thanks
Regards,
Leander
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
