Hi
Im my radius server gives "Mysql check_error : 1054 received "message after user authorization procc. What is it mean My usergroup table is empty !!! modcall: entering group authorize modcall[authorize]: module "preprocess" returns ok radius_xlat: 'dark' rlm_sql (sql): sql_set_user escaped user --> 'dark' radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'dark' ORDER BY id' rlm_sql (sql): Reserving sql socket id: 4 radius_xlat: 'SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupche ck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = 'dark' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id' rlm_sql_mysql: MYSQL check_error: 1054 received rlm_sql_getvpdata: database query error radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'dark' ORDER BY id' radius_xlat: 'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrouprep ly.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = 'dark' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id' rlm_sql_mysql: MYSQL check_error: 1054 received rlm_sql_getvpdata: database query error rlm_sql (sql): Released sql socket id: 4 And my second question is im exporting detail to mysql But i want to export detail to postgresql At same time with mysql i edit my Radius.conf . Like this # Include another file that has the SQL-related configuration. # This is another file solely because it tends to be big. # # The following configuration file is for use with MySQL. # # For Postgresql, use: ${confdir}/postgresql.conf # For MS-SQL, use: ${confdir}/mssql.conf # $INCLUDE ${confdir}/sql.conf $INCLUDE /usr/local/radiusd/etc/raddb/postgresql.conf # Write a 'utmp' style log file, of which users are currently # logged in, and where they've logged in from. # And postgresql.conf like this # Connect info server = "localhost" login = "puser" password = "ppass" # Database table configuration radius_db = "pdata_db" But in postgres radacct table is empty - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html