Hi, I have a user with "Max-All-Session" attribute set to 3600. When trying to connect, server is rejecting the user with following error =========== rlm_sql: Failed to create the pair: Invalid octet string "3600" for attribute name "Max-All-Session" rlm_sql (sql): Error getting data from database [sql] SQL query error; rejecting user ... ... ... ============= What is this error means and how to solve this? Other related questions: ===== 1. What is the measurement value for "Max-All-Session"? Seconds? 2. I tried searching the wiki relating to this and found some instructions about creating sqlcounter.conf at http://wiki.freeradius.org/Rlm_sqlcounter. I am using current version of freeradius 2.1.6 so Do I have to go through these steps? I am asking this because I found the "counter.conf" in /etc/raddb/sql/mysql/ which seems to be similar to what is in wiki. This is a newbie question, so please be patient with me. I did few mispost in daloradius forum recently expecting the answer about freeradius. Thanks -- ============================== Registered Linux User #460714 Currently Using Fedora 10, CentOS 5.3 ==============================
On Sun, Jul 12, 2009 at 8:03 PM, Deepak<d88pak@gmail.com> wrote:
Hi,
I have a user with "Max-All-Session" attribute set to 3600. When trying to connect, server is rejecting the user with following error
=========== rlm_sql: Failed to create the pair: Invalid octet string "3600" for attribute name "Max-All-Session" rlm_sql (sql): Error getting data from database [sql] SQL query error; rejecting user ... ... ... =============
What is this error means and how to solve this?
Other related questions: ===== 1. What is the measurement value for "Max-All-Session"? Seconds? 2. I tried searching the wiki relating to this and found some instructions about creating sqlcounter.conf at http://wiki.freeradius.org/Rlm_sqlcounter. I am using current version of freeradius 2.1.6 so Do I have to go through these steps? I am asking this because I found the "counter.conf" in /etc/raddb/sql/mysql/ which seems to be similar to what is in wiki.
This is a newbie question, so please be patient with me. I did few mispost in daloradius forum recently expecting the answer about freeradius.
Thanks
after some googling I found out that Max-All-Session attribute have to be in dictionary so I added in dictionary file and all went well. But I still need answer on sqlcounter.conf Can freeradius 2 do accounting based on Max-All-Session by default ( I already enabled the accounting via sql)? or i have to follow the instruction based on the wiki I mentioned earlier? Thanks again -- ============================== Registered Linux User #460714 Currently Using Fedora 10, CentOS 5.3 ==============================
after some googling I found out that Max-All-Session attribute have to be in dictionary so I added in dictionary file and all went well.
But I still need answer on sqlcounter.conf Can freeradius 2 do accounting based on Max-All-Session by default ( I already enabled the accounting via sql)? or i have to follow the instruction based on the wiki I mentioned earlier?
You need to list the sqlcounter in authorize (in virtual server) and instantiate (in radiusd.conf). Ivan Kalik Kalik Informatika ISP
You need to list the sqlcounter in authorize (in virtual server) and instantiate (in radiusd.conf).
Ivan Kalik Kalik Informatika ISP
Thanks for the info. Its working now. :-) Regards -- ============================== Registered Linux User #460714 Currently Using Fedora 10, CentOS 5.3 ==============================
Hi,
I have a user with "Max-All-Session" attribute set to 3600. When trying to connect, server is rejecting the user with following error
=========== rlm_sql: Failed to create the pair: Invalid octet string "3600" for attribute name "Max-All-Session" rlm_sql (sql): Error getting data from database [sql] SQL query error; rejecting user ... ... ... =============
What is this error means and how to solve this?
Your counter was't instantiated. Ivan Kalik Kalik Informatika ISP
participants (2)
-
Deepak -
Ivan Kalik