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 <[EMAIL PROTECTED]>: > 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" <[EMAIL PROTECTED]> 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 >
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html