How to add new column in icradius
I need your help. I hope you can help me. I have 5 radius server (3 is icradius and 2 freeradius). We have a project to combine all those 5 servers to 1 new server. I decided to use the icradius for the new radius server. I have succesfully combine the 3 icradius radius to the new radius server. Now, I have 3 icradius daemon running in 1 server. My problem is the remaining 2 freeradius. I tried to backup the freeradius database and transfer to the icradius server. Then copy a new binary and rename it like the ff:
/usr/local/sbin/radiusd-bro -d /etc/bro_raddb -a /var/log/radius_bro -l /var/log/radius_bro -p 1645 -i 10.4.0.54 -y
Now, as I check the logs, it has an error.
Mon Jul 14 17:20:09 2008: Debug: Exec-Program-Wait: value-pairs: Session-Timeout=126000,
Mon Jul 14 17:20:09 2008: Info: Exec-Program: returned: 0
Mon Jul 14 17:20:09 2008: Auth: Login OK: [testingbro] (from nas pm-04.philonline.com/S1) socket 0 (7 sec)
Mon Jul 14 17:20:10 2008: Error: Acct: Couldn't insert SQL accounting START record - Column count doesn't match value count at row 1
Mon Jul 14 17:20:24 2008: Error: Acct: Couldn't insert SQL accounting STOP record - Column count doesn't match value count at row 1
Mon Jul 14 17:20:41 2008: Info: MASTER: exit.
As I check the radacct, it has 2 column that was different from the icradius radacct
This 2 column above is came from the freeradius radacct. The icradius radacct doesn't have ConnectInfo_start and ConnectInfo_stop
How could I make icradius read those two columns?