<div dir="ltr">Dear Ivan,<br><br>Sorry .. I see now .<br><br>but, i still have a problem with mysql module.<br><br>Mysql server is running ok, and library path default on /usr/local/lib.<br>When first running, libfreeradius cannot founded. so .. i make link to /usr/lib. and running ok.<br>
but .. now the problem like this :<br><br><br>HERE acctsessionid = '%{Acct-Session-Id}' AND username = '%{SQL-User-Name}' AND nasipaddress = '%{NAS-IP-Address}'"<br>
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}')"<br>
group_membership_query = "SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority"<br> connect_failure_retry_delay = 60<br> simul_count_query = ""<br>
simul_verify_query = "SELECT radacctid, acctsessionid, username, nasipaddress, nasportid, framedipaddress, callingstationid, framedprotocol FROM radacct WHERE username = '%{SQL-User-Name}' AND acctstoptime IS NULL"<br>
postauth_query = "INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( '%{User-Name}', '%{%{User-Password}:-%{Chap-Password}}', '%{reply:Packet-Type}', '%S')"<br>
safe-characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"<br> }<br>rlm_sql (sql): Could not link driver rlm_sql_mysql: rlm_sql_mysql.so: cannot open shared object file: No such file or directory<br>
rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the search path of your system's ld.<br>/usr/local/etc/raddb/sql.conf[22]: Instantiation failed for module "sql"<br>/usr/local/etc/raddb/sites-enabled/default[373]: Failed to find module "sql".<br>
/usr/local/etc/raddb/sites-enabled/default[368]: Errors parsing session section.<br> }<br>}<br>Errors initializing modules<br><br><br>What can I do ?? Thanks<br><br><div class="gmail_quote">2008/7/23 Ivan Kalik <<a href="mailto:tnt@kalik.net">tnt@kalik.net</a>>:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">You are not calling sql (is that where the password is). Uncomment sql<br>
entries in default virtual server.<br>
<br>
Ivan Kalik<br>
Kalik Informatika ISP<br>
<br>
<br>
Dana 22/7/2008, "Asep Samsul" <<a href="mailto:asamsul@gmail.com">asamsul@gmail.com</a>> piše:<br>
<div><div></div><div class="Wj3C7c"><br>
>Hi,<br>
><br>
>I'm using freeradius 1.1.7 , and now i want to try for the other machine to<br>
><a href="http://2.0.5." target="_blank">2.0.5.</a><br>
><br>
>I'm sure about configuration, :<br>
><br>
>- Using Opensuse 10.2<br>
>- Using mysql and freeradius 2.0.5<br>
>- NAS from VPN Mikrotik<br>
><br>
>Please help me,.... a'm using default configuration from installer.<br>
><br>
> +- entering group authorize<br>
>++[preprocess] returns ok<br>
>++[chap] returns noop<br>
> rlm_mschap: Found MS-CHAP attributes. Setting 'Auth-Type = mschap'<br>
>++[mschap] returns ok<br>
> rlm_realm: No '@' in User-Name = "asul", looking up realm NULL<br>
> rlm_realm: No such realm "NULL"<br>
>++[suffix] returns noop<br>
> rlm_eap: No EAP-Message, not doing EAP<br>
>++[eap] returns noop<br>
>++[unix] returns updated<br>
> users: Matched entry DEFAULT at line 175<br>
>++[files] returns ok<br>
>++[expiration] returns noop<br>
>++[logintime] returns noop<br>
>rlm_pap: Found existing Auth-Type, not changing it.<br>
>++[pap] returns noop<br>
> rad_check_password: Found Auth-Type mschap<br>
>auth: type "MSCHAP"<br>
>+- entering group MS-CHAP<br>
> rlm_mschap: No Cleartext-Password configured. Cannot create LM-Password.<br>
> rlm_mschap: No Cleartext-Password configured. Cannot create NT-Password.<br>
> rlm_mschap: Told to do MS-CHAPv2 for asul with NT-Password<br>
> rlm_mschap: FAILED: No NT/LM-Password. Cannot perform authentication.<br>
> rlm_mschap: FAILED: MS-CHAP2-Response is incorrect<br>
>++[mschap] returns reject<br>
>auth: Failed to validate the user.<br>
> Found Post-Auth-Type Reject<br>
>+- entering group REJECT<br>
> expand: %{User-Name} -> asul<br>
> attr_filter: Matched entry DEFAULT at line 11<br>
>++[attr_filter.access_reject] returns updated<br>
>Sending Access-Reject of id 17 to <a href="http://202.159.24.1" target="_blank">202.159.24.1</a> port 1025<br>
>Finished request 3.<br>
>Going to the next request<br>
><br>
><br>
<br>
</div></div><div><div></div><div class="Wj3C7c">-<br>
List info/subscribe/unsubscribe? See <a href="http://www.freeradius.org/list/users.html" target="_blank">http://www.freeradius.org/list/users.html</a><br>
</div></div></blockquote></div><br></div>