rlm_sql (sql) in sql_postauth: Database query error - Unknown column 'username' in 'f
I also followed the guide and was getting the sql error on the username field.
My fix - which seems to have fixed at least radius for now was 2 sql queries:
alter table radpostauth change user username varchar(64);
alter table radpostauth change date authdate timestamp default CURRENT_TIMESTAMP;