Hi, continueing: http://lists.freeradius.org/pipermail/freeradius-users/2008-June/msg00677.ht... @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.ht... @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