Hi, I'm working with Freeradius in production enviroment (start up), at this time is working with only two users, they can connect whitout problems and all seems to work fine but looking into radius.log i found this messages: radius:/usr/local/var/log/radius# tail radius.log -f Mon Jan 14 16:01:37 2008 : Error: rlm_sql (sql): Couldn't insert SQL accounting ALIVE record - Unknown column 'XAscendSessionSvrKey' in 'field list' Mon Jan 14 16:01:37 2008 : Error: rlm_sql_mysql: Cannot store result Mon Jan 14 16:01:37 2008 : Error: rlm_sql_mysql: MySQL error 'Unknown column 'XAscendSessionSvrKey' in 'field list'' Mon Jan 14 16:01:37 2008 : Error: rlm_sql_mysql: Cannot store result Mon Jan 14 16:01:37 2008 : Error: rlm_sql_mysql: MySQL error 'Unknown column 'XAscendSessionSvrKey' in 'field list'' Mon Jan 14 16:01:38 2008 : Error: rlm_sql (sql): Couldn't insert SQL accounting ALIVE record - Unknown column 'XAscendSessionSvrKey' in 'field list' Mon Jan 14 16:01:38 2008 : Error: rlm_sql_mysql: Cannot store result Mon Jan 14 16:01:38 2008 : Error: rlm_sql_mysql: MySQL error 'Unknown column 'XAscendSessionSvrKey' in 'field list'' Mon Jan 14 16:01:38 2008 : Error: rlm_sql_mysql: Cannot store result Mon Jan 14 16:01:38 2008 : Error: rlm_sql_mysql: MySQL error 'Unknown column 'XAscendSessionSvrKey' in 'field list'' Any help please? Thanks in advance, Pablo
Hi,
Hi,
I'm working with Freeradius in production enviroment (start up), at this time is working with only two users, they can connect whitout problems and all seems to work fine but looking into radius.log i found this messages:
you dont state what platform you are using or what version of freeradius however, your mysql SHOULD have such a column in that table (its in the supplied schema) - the error you are getting is the accounting packets which cannot be stored as you are asking for that column...check the sql/mysql/dialup.conf sql/mysql/schema.sql: xascendsessionsvrkey varchar(10) default NULL, ^^^^^^^^^^^^^^^^^^^^ the stuff is in the supplied schema! sql/mysql/dialup.conf: acctstartdelay, xascendsessionsvrkey) \ ^^^^^^^^^^^^^^^^^^^^^ here is the call as part of an UPDATE check case sensitivity alan
Add that column in your radacct table. I had the same problem and it is solved (upgrade to 1.1.7 from 1.1.4 )... Check mysql sample file in sql dir. A.L.M.Buxey@lboro.ac.uk wrote:
Hi,
Hi,
I'm working with Freeradius in production enviroment (start up), at this time is working with only two users, they can connect whitout problems and all seems to work fine but looking into radius.log i found this messages:
you dont state what platform you are using or what version of freeradius
however, your mysql SHOULD have such a column in that table (its in the supplied schema) - the error you are getting is the accounting packets which cannot be stored as you are asking for that column...check the sql/mysql/dialup.conf
sql/mysql/schema.sql: xascendsessionsvrkey varchar(10) default NULL, ^^^^^^^^^^^^^^^^^^^^
the stuff is in the supplied schema!
sql/mysql/dialup.conf: acctstartdelay, xascendsessionsvrkey) \ ^^^^^^^^^^^^^^^^^^^^^ here is the call as part of an UPDATE
check case sensitivity
alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
in lower case really? Marinko Tarlac wrote:
Add that column in your radacct table. I had the same problem and it is solved (upgrade to 1.1.7 from 1.1.4 )... Check mysql sample file in sql dir. A.L.M.Buxey@lboro.ac.uk wrote:
Hi,
Hi,
I'm working with Freeradius in production enviroment (start up), at this time is working with only two users, they can connect whitout problems and all seems to work fine but looking into radius.log i found this messages:
you dont state what platform you are using or what version of freeradius
however, your mysql SHOULD have such a column in that table (its in the supplied schema) - the error you are getting is the accounting packets which cannot be stored as you are asking for that column...check the sql/mysql/dialup.conf
sql/mysql/schema.sql: xascendsessionsvrkey varchar(10) default NULL, ^^^^^^^^^^^^^^^^^^^^
the stuff is in the supplied schema!
sql/mysql/dialup.conf: acctstartdelay, xascendsessionsvrkey) \ ^^^^^^^^^^^^^^^^^^^^^ here is the call as part of an UPDATE
check case sensitivity
alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
__________ Información de NOD32, revisión 2790 (20080114) __________
Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com
I didn't try lowercase but XAscendSessionSvrKey - varchar(10) works fine :) Pablo Lucchetti wrote:
in lower case really?
Marinko Tarlac wrote:
Add that column in your radacct table. I had the same problem and it is solved (upgrade to 1.1.7 from 1.1.4 )... Check mysql sample file in sql dir. A.L.M.Buxey@lboro.ac.uk wrote:
Hi,
Hi,
I'm working with Freeradius in production enviroment (start up), at this time is working with only two users, they can connect whitout problems and all seems to work fine but looking into radius.log i found this messages:
you dont state what platform you are using or what version of freeradius
however, your mysql SHOULD have such a column in that table (its in the supplied schema) - the error you are getting is the accounting packets which cannot be stored as you are asking for that column...check the sql/mysql/dialup.conf
sql/mysql/schema.sql: xascendsessionsvrkey varchar(10) default NULL, ^^^^^^^^^^^^^^^^^^^^
the stuff is in the supplied schema!
sql/mysql/dialup.conf: acctstartdelay, xascendsessionsvrkey) \ ^^^^^^^^^^^^^^^^^^^^^ here is the call as part of an UPDATE
check case sensitivity
alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
__________ Información de NOD32, revisión 2790 (20080114) __________
Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
I added column im radacct and all it's Ok, thanks for your help. Pablo Marinko Tarlac wrote:
Add that column in your radacct table. I had the same problem and it is solved (upgrade to 1.1.7 from 1.1.4 )... Check mysql sample file in sql dir. A.L.M.Buxey@lboro.ac.uk wrote:
Hi,
Hi,
I'm working with Freeradius in production enviroment (start up), at this time is working with only two users, they can connect whitout problems and all seems to work fine but looking into radius.log i found this messages:
you dont state what platform you are using or what version of freeradius
however, your mysql SHOULD have such a column in that table (its in the supplied schema) - the error you are getting is the accounting packets which cannot be stored as you are asking for that column...check the sql/mysql/dialup.conf
sql/mysql/schema.sql: xascendsessionsvrkey varchar(10) default NULL, ^^^^^^^^^^^^^^^^^^^^
the stuff is in the supplied schema!
sql/mysql/dialup.conf: acctstartdelay, xascendsessionsvrkey) \ ^^^^^^^^^^^^^^^^^^^^^ here is the call as part of an UPDATE
check case sensitivity
alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
__________ Información de NOD32, revisión 2790 (20080114) __________
Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com
I'm using freeradius 2.0.0 on Debian Etch, I think the problem is case sensitivity as you mentioned because in schema.sql is un lower case and in dialup.conf also. A.L.M.Buxey@lboro.ac.uk wrote:
Hi,
Hi,
I'm working with Freeradius in production enviroment (start up), at this time is working with only two users, they can connect whitout problems and all seems to work fine but looking into radius.log i found this messages:
you dont state what platform you are using or what version of freeradius
however, your mysql SHOULD have such a column in that table (its in the supplied schema) - the error you are getting is the accounting packets which cannot be stored as you are asking for that column...check the sql/mysql/dialup.conf
sql/mysql/schema.sql: xascendsessionsvrkey varchar(10) default NULL, ^^^^^^^^^^^^^^^^^^^^
the stuff is in the supplied schema!
sql/mysql/dialup.conf: acctstartdelay, xascendsessionsvrkey) \ ^^^^^^^^^^^^^^^^^^^^^ here is the call as part of an UPDATE
check case sensitivity
alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
__________ Información de NOD32, revisión 2790 (20080114) __________
Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com
participants (3)
-
A.L.M.Buxey＠lboro.ac.uk -
Marinko Tarlac -
Pablo Lucchetti