Cannot login with freeradius 2.0.5

[Asep Samsul]

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/0d76b3e1/attachment.html>