Need help (freeradius <--> 2nd router)

Discussion in 'HOWTO-Related Questions' started by denbagoos, Mar 19, 2014.

  1. denbagoos

    denbagoos New Member

    need help here...i wanna use freeradius for my hotspot, i use two mikrotik for my router and i have a problem connecting my 2nd mikrotik to freeradius
    here is my topology
    [​IMG]

    when i test on LAN connection its working fine but when i use it for my RB433 user cannot login...
    this is what i get from freeradius -X
    Code:
    rad_recv: Access-Request packet from host 192.168.1.2 port 59092, id=26, length=193
            NAS-Port-Type = Wireless-802.11
            Calling-Station-Id = "A4:17:31:41:CB:B6"
            Called-Station-Id = "hotspot3"
            NAS-Port-Id = "bullet"
            User-Name = "test"
            NAS-Port = 2152726618
            Acct-Session-Id = "8050005a"
            Framed-IP-Address = 192.168.10.183
            Mikrotik-Host-IP = 192.168.10.183
            CHAP-Challenge = 0xf1fb74cf86fcb8d3dd4bf34451c2f96c
            CHAP-Password = 0x18622df4a39f1dc321153f4223329159d5
            Service-Type = Login-User
            WISPr-Logoff-URL = "http://192.168.10.1/logout"
            NAS-Identifier = "RB433"
            NAS-IP-Address = 192.168.1.2
    # Executing section authorize from file /etc/freeradius/sites-enabled/default
    +- entering group authorize {...}
    [am-authorize]  expand: %u -> test
    [am-authorize]  expand: %n -> 192.168.1.2
    Exec-Program output:
    Exec-Program: returned: 0
    ++[am-authorize] returns ok
    ++[preprocess] returns ok
    [chap] Setting 'Auth-Type := CHAP'
    ++[chap] returns ok
    ++[mschap] returns noop
    ++[digest] returns noop
    [suffix] No '@' in User-Name = "test", looking up realm NULL
    [suffix] No such realm "NULL"
    ++[suffix] returns noop
    [eap] No EAP-Message, not doing EAP
    ++[eap] returns noop
    ++[files] returns noop
    [sql]   expand: %{User-Name} -> test
    [sql] sql_set_user escaped user --> 'test'
    rlm_sql (sql): Reserving sql socket id: 3
    [sql]   expand: SELECT id, username, attribute, value, op           FROM radcheck           WHERE username = '%{SQL-User-Name}'           ORDER BY id -> SELECT id, username, attribute, value, op           FROM radcheck           WHERE username = 'test'           ORDER BY id
    [sql] User found in radcheck table
    [sql]   expand: SELECT id, username, attribute, value, op           FROM radreply           WHERE username = '%{SQL-User-Name}'           ORDER BY id -> SELECT id, username, attribute, value, op           FROM radreply           WHERE username = 'test'           ORDER BY id
    rlm_sql: Failed to create the pair: Invalid octet string "0" for attribute name "Mikrotik-Total-Limit"
    rlm_sql (sql): Error getting data from database
    [sql] SQL query error; rejecting user
    rlm_sql (sql): Released sql socket id: 3
    ++[sql] returns fail
    Using Post-Auth-Type Reject
    # Executing group from file /etc/freeradius/sites-enabled/default
    +- entering group REJECT {...}
    [attr_filter.access_reject]     expand: %{User-Name} -> test
     attr_filter: Matched entry DEFAULT at line 11
    ++[attr_filter.access_reject] returns updated
    Delaying reject of request 0 for 1 seconds
    Going to the next request
    Waking up in 0.8 seconds.
    Sending delayed reject for request 0
    Sending Access-Reject of id 26 to 192.168.1.2 port 59092
    Waking up in 4.9 seconds.
    Cleaning up request 0 ID 26 with timestamp +8
    Ready to process requests.
    
    thanks for all your help.....
     
  2. denbagoos

    denbagoos New Member

    anyone.......?
     

Share This Page