Cannot login with freeradius 2.0.5

[Asep Samsul]

Dear all,

I'm already success for starting freeradius 2.0.5

Thanks

2008/7/23 Asep Samsul <asamsul at gmail.com>:

> Dear Ivan,
>
> Sorry .. I see now .
>
> but, i still have a problem with mysql module.
>
> Mysql server is running ok, and library path default on /usr/local/lib.
> When first running, libfreeradius cannot founded. so .. i make link to
> /usr/lib. and running ok.
> but .. now the problem like this :
>
>
> HERE acctsessionid   = '%{Acct-Session-Id}'           AND username
> = '%{SQL-User-Name}'           AND nasipaddress      = '%{NAS-IP-Address}'"
>         accounting_stop_query_alt = "           INSERT INTO
> radacct             (acctsessionid, acctuniqueid, username,
> realm, nasipaddress, nasportid,              nasporttype, acctstarttime,
> acctstoptime,              acctsessiontime, acctauthentic,
> connectinfo_start,              connectinfo_stop, acctinputoctets,
> acctoutputoctets,              calledstationid, callingstationid,
> acctterminatecause,              servicetype, framedprotocol,
> framedipaddress,              acctstartdelay, acctstopdelay)
> VALUES             ('%{Acct-Session-Id}',
> '%{Acct-Unique-Session-Id}',              '%{SQL-User-Name}',
> '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}',
> '%{NAS-Port-Type}',              DATE_SUB('%S',                  INTERVAL
> (%{%{Acct-Session-Time}:-0} +                  %{%{Acct-Delay-Time}:-0})
> SECOND),              '%S', '%{Acct-Session-Time}', '%{Acct-Authentic}',
> '',              '%{Connect-Info}',
> '%{%{Acct-Input-Gigawords}:-0}' << 32 |
> '%{%{Acct-Input-Octets}:-0}',              '%{%{Acct-Output-Gigawords}:-0}'
> << 32 |              '%{%{Acct-Output-Octets}:-0}',
> '%{Called-Station-Id}', '%{Calling-Station-Id}',
> '%{Acct-Terminate-Cause}',              '%{Service-Type}',
> '%{Framed-Protocol}', '%{Framed-IP-Address}',              '0',
> '%{%{Acct-Delay-Time}:-0}')"
>         group_membership_query = "SELECT groupname           FROM
> radusergroup           WHERE username = '%{SQL-User-Name}'           ORDER
> BY priority"
>         connect_failure_retry_delay = 60
>         simul_count_query = ""
>         simul_verify_query = "SELECT radacctid, acctsessionid,
> username,                                nasipaddress, nasportid,
> framedipaddress,                                callingstationid,
> framedprotocol                                FROM
> radacct                                WHERE username =
> '%{SQL-User-Name}'                                AND acctstoptime IS NULL"
>         postauth_query = "INSERT INTO radpostauth
> (username, pass, reply, authdate)                           VALUES
> (                           '%{User-Name}',
> '%{%{User-Password}:-%{Chap-Password}}',
> '%{reply:Packet-Type}', '%S')"
>         safe-characters =
> "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"
>   }
> rlm_sql (sql): Could not link driver rlm_sql_mysql: rlm_sql_mysql.so:
> cannot open shared object file: No such file or directory
> rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the
> search path of your system's ld.
> /usr/local/etc/raddb/sql.conf[22]: Instantiation failed for module "sql"
> /usr/local/etc/raddb/sites-enabled/default[373]: Failed to find module
> "sql".
> /usr/local/etc/raddb/sites-enabled/default[368]: Errors parsing session
> section.
>  }
> }
> Errors initializing modules
>
>
> What can I do ?? Thanks
>
> 2008/7/23 Ivan Kalik <tnt at kalik.net>:
>
> You are not calling sql (is that where the password is). Uncomment sql
>> entries in default virtual server.
>>
>> Ivan Kalik
>> Kalik Informatika ISP
>>
>>
>> Dana 22/7/2008, "Asep Samsul" <asamsul at gmail.com> piše:
>>
>> >Hi,
>> >
>> >I'm using freeradius 1.1.7 , and now i want to try for the other machine
>> to
>> >2.0.5.
>> >
>> >I'm sure about configuration, :
>> >
>> >- Using Opensuse 10.2
>> >- Using mysql and freeradius 2.0.5
>> >- NAS from VPN Mikrotik
>> >
>> >Please help me,.... a'm using default configuration from installer.
>> >
>> > +- entering group authorize
>> >++[preprocess] returns ok
>> >++[chap] returns noop
>> >  rlm_mschap: Found MS-CHAP attributes.  Setting 'Auth-Type  = mschap'
>> >++[mschap] returns ok
>> >    rlm_realm: No '@' in User-Name = "asul", looking up realm NULL
>> >    rlm_realm: No such realm "NULL"
>> >++[suffix] returns noop
>> >  rlm_eap: No EAP-Message, not doing EAP
>> >++[eap] returns noop
>> >++[unix] returns updated
>> >    users: Matched entry DEFAULT at line 175
>> >++[files] returns ok
>> >++[expiration] returns noop
>> >++[logintime] returns noop
>> >rlm_pap: Found existing Auth-Type, not changing it.
>> >++[pap] returns noop
>> >  rad_check_password:  Found Auth-Type mschap
>> >auth: type "MSCHAP"
>> >+- entering group MS-CHAP
>> >  rlm_mschap: No Cleartext-Password configured.  Cannot create
>> LM-Password.
>> >  rlm_mschap: No Cleartext-Password configured.  Cannot create
>> NT-Password.
>> >  rlm_mschap: Told to do MS-CHAPv2 for asul with NT-Password
>> >  rlm_mschap: FAILED: No NT/LM-Password.  Cannot perform authentication.
>> >  rlm_mschap: FAILED: MS-CHAP2-Response is incorrect
>> >++[mschap] returns reject
>> >auth: Failed to validate the user.
>> >  Found Post-Auth-Type Reject
>> >+- entering group REJECT
>> >        expand: %{User-Name} -> asul
>> > attr_filter: Matched entry DEFAULT at line 11
>> >++[attr_filter.access_reject] returns updated
>> >Sending Access-Reject of id 17 to 202.159.24.1 port 1025
>> >Finished request 3.
>> >Going to the next request
>> >
>> >
>>
>> -
>> List info/subscribe/unsubscribe? See
>> http://www.freeradius.org/list/users.html
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20080723/7de68a36/attachment.html>