@Yawar Hadi

Thanks. I need the version 2.0.5 because of various reasons.

if you talk about this part in radius.conf:

###############################################################################################

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/radius/radacct
      detail
      sql
}

###############################################################################################
^^ it's not there anymore in 2.0.5 radius.conf - I also looked for that without success ;)


Quote:
there is also a
sql configuration
which is comment out like  #sql
you have to uncomment it.  #sql ----->sql
*sql ......


*^^ what config are you talking about? The only useful "sql" hint I was able to find in radius.conf was "$INCLUDE sql.conf" which is already uncommented ..

Thank you







Yawar Hadi schrieb:
i have setup radius 1.6 with mysql databse and also add the functionlaity of procedure calling.. i you need any help feel free to contact me i am available 10am to 8 pm mon to fri...
thanks

On Thu, Jul 24, 2008 at 1:00 PM, Yawar Hadi <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote:

    i also face this problem for more then one month.
       because the problem is with module configuration
    like in radius 1.6 version
    in raddb/radiusd.conf  file

    ..................
    .............
    module authorize
    {
    #pap ...
             ........................
    #chap...
              .................

    there is also a
    sql configuration
    which is comment out like  #sql
    you have to uncomment it.  #sql ----->sql
    *sql ......*
           ....................
    }

    then sql configuration added to the radius....

    but the problem is in radius 2.0.5 nothing like this in radiusd.conf.
    they have move these configuration files to some else place.

    my suggetions is  to move to version radius 1.6
    because more people work on it and it is more stable then radius 2.0.5
    hope it will help you


    BEST REGARDS

    Yawar Hadi Noshahi

    QAU Islamabad (+92-0300-5504798)



    On Thu, Jul 24, 2008 at 12:41 PM, Leander S.
    <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote:

        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 <http://Make.inc.in>
        seems to ignore the --datarootdir setting
        config.status: WARNING:  ./src/include/build-radpaths-h.in
        <http://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
        <http://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 <http://rlm_sql_postgresql.la>
        /usr/local/lib/rlm_sql_postgresql.la
        <http://rlm_sql_postgresql.la> || exit $?; \
              rm -f /usr/local/lib/rlm_sql_postgresql-2.0.5.la
        <http://rlm_sql_postgresql-2.0.5.la>; \
              ln -s rlm_sql_postgresql.la
        <http://rlm_sql_postgresql.la>
        /usr/local/lib/rlm_sql_postgresql-2.0.5.la
        <http://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
        <http://rlm_sql_postgresql-2.0.5.so>
        /usr/local/lib/rlm_sql_postgresql-2.0.5.so
        <http://rlm_sql_postgresql-2.0.5.so>
        (cd /usr/local/lib && { ln -s -f rlm_sql_postgresql-2.0.5.so
        <http://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
        <http://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
        <http://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
        <http://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




-- Yawar Hadi Noshahi

    QAU Islamabad (+92-0300-5504798)




--
Yawar Hadi Noshahi

QAU Islamabad (+92-0300-5504798)
------------------------------------------------------------------------

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

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

Reply via email to