freeradius + cisco asa vpn

Posted on 2010-09-01
Last Modified: 2012-05-10

I'm trying to setup dynamic split tunnels in my VPN with Cisco ASA.
I setup into radreply database the config:

|      id      |      username      |            attribute                  |       op      |      value            |
|      1      |      userX            |      CVPN3000-IPSec-Split-Tunnel-List      |      =      |      acl-name      |

But when I test the loggin, radius debbuging says:
    rlm_sql: Failed to create the pair: Invalid octet string "acl-name" for attribute name " cVPN3000-IPSec-Split-Tunnel-List"
And user is rejected for access.

Does anyone know how to setup this correctly?

Question by:jhclemente
  • 4
  • 3
LVL 77

Expert Comment

ID: 33586266

Check the attribute files to make sure you have the correct definition for the attribute.;jsessionid=B99ED992EF545E8F08583BFAB9DC1CAB.node0
Have you looked at trying to use ipsec-split-tunnel-list instead?

Author Comment

ID: 33588775
Yes, even with "ipsec-split-tunnel-list" I get the same error.

I found in this:

      ATTRIBUTE         CVPN3000-IPSec-Split-Tunnel-List      27      string

And my client is defined this way:

      client IPAddr {
            shortname = shortNameOfClient
            secret = secretPass
            nastype = Cisco-VPN3000

Any idea why I get that error?
LVL 77

Expert Comment

ID: 33588967
The error seems to suggest that acl-name is an invalid string.
Could you check whether the op should be := rather than =?

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

LVL 77

Expert Comment

ID: 33589086
run the radiusd in debug mode to see what it is doing right before this error.


Author Comment

ID: 33591626
Both operators ( := and = ) do the same

This is the debug output:

[files] users: Matched entry DEFAULT at line 172
++[files] returns ok
[sql]       expand: %{User-Name} -> USERNAME
[sql] sql_set_user escaped user --> 'USERNAME'
rlm_sql (sql): Reserving sql socket id: 9
[sql]       expand: --------- REMOVED QUERY -------------
[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 = 'USERNAME' ORDER BY id
rlm_sql: Failed to create the pair: Invalid octet string "acl-name" for attribute name "CVPN3000-IPSec-Split-Tunnel-List"
rlm_sql (sql): Error getting data from database
[sql] SQL query error; rejecting user
rlm_sql (sql): Released sql socket id: 9
++[sql] returns fail
LVL 77

Expert Comment

ID: 33591895
can you try aclname and see if it makes a difference?
Also what is the output
SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' order by id
presumably USERNAME in the above was commented out for a valid username.


Accepted Solution

jhclemente earned 0 total points
ID: 33600868
I finally found the problem.... everything was right in the database.
The problem was with dictionary file.... it had commented out the line for including
I removed the comment and it worked.

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

For a while, I have wanted to connect my HTC Incredible to my corporate network to take advantage of the phone's powerful capabilities. I searched online and came up with varied answers from "it won't work" to super complicated statements that I did…
How to set-up an On Demand, IPSec, Site to SIte, VPN from a Draytek Vigor Router to a Cyberoam UTM Appliance. A concise guide to the settings required on both devices
After creating this article (, I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
Both in life and business – not all partnerships are created equal. Spend 30 short minutes with us to learn:   • Key questions to ask when considering a partnership to accelerate your business into the cloud • Pitfalls and mistakes other partners…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now