xascendsessionsvrkey (data too long) in freeradius 2.2.5
I installed freeradius 2.2.5 and i have problem with acounting Error: [sql] Couldn't insert SQL accounting START record - Data too long for column 'xascendsessionsvrkey' at row 1 i can't alter radacct table because i have more than 20 million records I try to use freeradius with test database after alter xascendsessionsvrkey to varchaer(255) the value of xascendsessionsvrkey like ===> 3134:4235:3936::/57 ip v6 disable on radius and database server
Hi,
i can't alter radacct table because i have more than 20 million records
yes you can.....and if the data needs to be bigger than the column size you have then you'll have to (I've altered column config on databases much larger than a few dozen million records) alan
hi can you help me On 13 May 2014 21:40, <A.L.M.Buxey@lboro.ac.uk> wrote:
Hi,
i can't alter radacct table because i have more than 20 million records
yes you can.....and if the data needs to be bigger than the column size you have then you'll have to (I've altered column config on databases much larger than a few dozen million records)
alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
i used mysql databse when i alter table the data copy to tmp table and take alot of time On 13 May 2014 21:57, mohammed Erheem <mohammed059@gmail.com> wrote:
hi can you help me
On 13 May 2014 21:40, <A.L.M.Buxey@lboro.ac.uk> wrote:
Hi,
i can't alter radacct table because i have more than 20 million records
yes you can.....and if the data needs to be bigger than the column size you have then you'll have to (I've altered column config on databases much larger than a few dozen million records)
alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
On 13 May 2014, at 20:00, mohammed Erheem <mohammed059@gmail.com> wrote:
i used mysql databse when i alter table the data copy to tmp table and take alot of time
stop freeradius writing to the database, and use the detail writer to write accounting requests to a flat file instead whilst the modification is in progress. Arran Cudbard-Bell <a.cudbardb@freeradius.org> FreeRADIUS Development Team FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2
can i ask question what is xascendsessionsvrkey and the vakue of xascendsessionsvrkey depent on what i have cisco router 7206 (l2tp == >vpdn) freeradius 2.2.5 mysql 5.5.37 On 13 May 2014 22:12, Arran Cudbard-Bell <a.cudbardb@freeradius.org> wrote:
On 13 May 2014, at 20:00, mohammed Erheem <mohammed059@gmail.com> wrote:
i used mysql databse when i alter table the data copy to tmp table and take alot of time
stop freeradius writing to the database, and use the detail writer to write accounting requests to a flat file instead whilst the modification is in progress.
Arran Cudbard-Bell <a.cudbardb@freeradius.org> FreeRADIUS Development Team
FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
participants (3)
-
A.L.M.Buxey＠lboro.ac.uk -
Arran Cudbard-Bell -
mohammed Erheem