Hi Alan, I know about radius -X ... I already setted up the version 1.1.7 succesfully ... but now I'm working on almost complety revised version 2.0.5 ... so SQL configs are different for me and I might made some mistakes there so that the radius -X is not showing me some pg code ... ;/ ____ Btw.: ./configure --with-your-personal-options | grep WARNING --> There is nothing saying anything about sql , or pg or postgres in ./configure --help ... You may want to give me an example especialy for postgres ?! Would be great. --> I also tryed: ./configure --with-postgresql=YES --enable-postgresql=YES --with-rlm-postgresql-lib-dir=/usr/local/lib/ --with-rlm-postgresql-include-dir=/usr/local/lib/ --> But I haven't had more luck than before .. and also no more WARNING messages to read than I've had before .. so there might be something wrong ... ____ But anyway .. here's how I used to run it usually ... because you said it trys to build as much modules as possible if the neccessary software stuff like postgresql-server/client is already preinstalled ... so postgres support for freeradius should work also ... but .. sadly .. it won't do it yet for me ... ;) root /usr/src/freeradius-server-2.0.5 # ./configure | grep WARNING 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. root /usr/src/freeradius-server-2.0.5 # ... ^^ which looks fine for me so far ... because I only need PostgreSQL ... not Oracle or MySQL. but if I now go ahead and do: # ./configure, gmake, gmake install and finally run radius -X it shows me not even one time anything about pg or postgres module ...: root /usr/src/freeradius-server-2.0.5 # radiusd -X FreeRADIUS Version 2.0.5, for host x86_64-unknown-freebsd7.0, built on Jun 23 2008 at 02:01:51 Copyright (C) 1999-2008 The FreeRADIUS server project and contributors. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. You may redistribute copies of FreeRADIUS under the terms of the GNU General Public License v2. Starting - reading configuration files ... including configuration file /usr/local/etc/raddb/radiusd.conf including configuration file /usr/local/etc/raddb/proxy.conf including configuration file /usr/local/etc/raddb/clients.conf including configuration file /usr/local/etc/raddb/snmp.conf including files in directory /usr/local/etc/raddb/modules/ including configuration file /usr/local/etc/raddb/modules/policy including configuration file /usr/local/etc/raddb/modules/acct_unique including configuration file /usr/local/etc/raddb/modules/unix including configuration file /usr/local/etc/raddb/modules/chap including configuration file /usr/local/etc/raddb/modules/preprocess including configuration file /usr/local/etc/raddb/modules/expiration including configuration file /usr/local/etc/raddb/modules/mac2vlan including configuration file /usr/local/etc/raddb/modules/mschap including configuration file /usr/local/etc/raddb/modules/ippool including configuration file /usr/local/etc/raddb/modules/files including configuration file /usr/local/etc/raddb/modules/krb5 including configuration file /usr/local/etc/raddb/modules/passwd including configuration file /usr/local/etc/raddb/modules/radutmp including configuration file /usr/local/etc/raddb/modules/attr_rewrite including configuration file /usr/local/etc/raddb/modules/echo including configuration file /usr/local/etc/raddb/modules/etc_group including configuration file /usr/local/etc/raddb/modules/pap including configuration file /usr/local/etc/raddb/modules/realm including configuration file /usr/local/etc/raddb/modules/pam including configuration file /usr/local/etc/raddb/modules/always including configuration file /usr/local/etc/raddb/modules/exec including configuration file /usr/local/etc/raddb/modules/logintime including configuration file /usr/local/etc/raddb/modules/sql_log including configuration file /usr/local/etc/raddb/modules/smbpasswd including configuration file /usr/local/etc/raddb/modules/sradutmp including configuration file /usr/local/etc/raddb/modules/counter including configuration file /usr/local/etc/raddb/modules/ldap including configuration file /usr/local/etc/raddb/modules/expr including configuration file /usr/local/etc/raddb/modules/attr_filter including configuration file /usr/local/etc/raddb/modules/checkval including configuration file /usr/local/etc/raddb/modules/digest including configuration file /usr/local/etc/raddb/modules/detail including configuration file /usr/local/etc/raddb/modules/detail.log including configuration file /usr/local/etc/raddb/modules/mac2ip including configuration file /usr/local/etc/raddb/eap.conf 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 including configuration file /usr/local/etc/raddb/policy.conf including files in directory /usr/local/etc/raddb/sites-enabled/ including configuration file /usr/local/etc/raddb/sites-enabled/default including configuration file /usr/local/etc/raddb/sites-enabled/inner-tunnel including dictionary file /usr/local/etc/raddb/dictionary [...] no more sql infomation ^^ postgresql seems not even to be loaded when radius starts ... [...] a step further I noticed there is even no module in: root /usr/src/freeradius-server-2.0.5 # ls -lach /usr/local/etc/raddb/modules/ total 84 dr--r--r-- 2 root wheel 1.0K Jun 23 01:36 . dr--r--r-- 7 root wheel 1.0K Jun 23 01:36 .. -r--r--r-- 1 root wheel 507B Jun 23 01:36 acct_unique -r--r--r-- 1 root wheel 465B Jun 23 01:36 always -r--r--r-- 1 root wheel 1.0K Jun 23 01:36 attr_filter -r--r--r-- 1 root wheel 1.4K Jun 23 01:36 attr_rewrite -r--r--r-- 1 root wheel 182B Jun 23 01:36 chap -r--r--r-- 1 root wheel 1.4K Jun 23 01:36 checkval -r--r--r-- 1 root wheel 2.9K Jun 23 01:36 counter -r--r--r-- 1 root wheel 1.8K Jun 23 01:36 detail -r--r--r-- 1 root wheel 1.7K Jun 23 01:36 detail.log -r--r--r-- 1 root wheel 318B Jun 23 01:36 digest -r--r--r-- 1 root wheel 3.3K Jun 23 01:36 echo -r--r--r-- 1 root wheel 706B Jun 23 01:36 etc_group -r--r--r-- 1 root wheel 809B Jun 23 01:36 exec -r--r--r-- 1 root wheel 597B Jun 23 01:36 expiration -r--r--r-- 1 root wheel 601B Jun 23 01:36 expr -r--r--r-- 1 root wheel 606B Jun 23 01:36 files -r--r--r-- 1 root wheel 2.2K Jun 23 01:36 ippool -r--r--r-- 1 root wheel 196B Jun 23 01:36 krb5 -r--r--r-- 1 root wheel 4.9K Jun 23 01:36 ldap -r--r--r-- 1 root wheel 1.1K Jun 23 01:36 logintime -r--r--r-- 1 root wheel 725B Jun 23 01:36 mac2ip -r--r--r-- 1 root wheel 394B Jun 23 01:36 mac2vlan -r--r--r-- 1 root wheel 2.1K Jun 23 01:36 mschap -r--r--r-- 1 root wheel 684B Jun 23 01:36 pam -r--r--r-- 1 root wheel 613B Jun 23 01:36 pap -r--r--r-- 1 root wheel 1.2K Jun 23 01:36 passwd -r--r--r-- 1 root wheel 604B Jun 23 01:36 policy -r--r--r-- 1 root wheel 1.7K Jun 23 01:36 preprocess -r--r--r-- 1 root wheel 1.5K Jun 23 01:36 radutmp -r--r--r-- 1 root wheel 891B Jun 23 01:36 realm -r--r--r-- 1 root wheel 402B Jun 23 01:36 smbpasswd -r--r--r-- 1 root wheel 2.0K Jun 23 01:36 sql_log -r--r--r-- 1 root wheel 489B Jun 23 01:36 sradutmp -r--r--r-- 1 root wheel 586B Jun 23 01:36 unix root /usr/src/freeradius-server-2.0.5 # so it might be still missed .. but what part is missed to get postgresql support? I already do have PostgreSQL Server 8.3 compiled and successfully running and I also do have PostgreSQL Client 8.1 also already installed from binary to my FreeBSD.. so WTF? ;) ?? Thx a lot regards, Leander A.L.M.Buxey@lboro.ac.uk schrieb:
Hi,
I'm now trying to compile 2.0.5 ... downloaded it, extracted it, and executeted ./configure --help --> but I couldn't find an option saying SQL support or postgres or anything ... could you give me a clue about the syntax?
run ./configure
it will spew out a lot of WARNINGs if it cannot find required packages....so you can either read the output, or just do
./configure --with-your-personal-options | grep WARNING
(where, of course, --with-your-personal-options isnt a real flag but is an example! you put your desired flags there as per ./configure --help)
by default, freeradius will try to build as many 3rd party items as it can - if it cant find the required development headers/includes etc then it wont compile the support in and will simply throw out a warning. simple as that. if you do compile freeradius and dont have, eg mysql-devel stuff installed, then the radiusd will work fine - but just wont accept or work with any mysql stuff.
alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html