Hi Alan, it looks like latest CVS head has problems with expansion of ${var} in assignments: rlm_sql (sql): database query error, SELECT id, ipaddr, shortname, type, secret FROM ${nas_table} where secret <> 'DISABLED' group by ipaddr: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{nas_table} where secret <> 'DISABLED' group by ipaddr' at line 1 where "nas_table" is defined properly in sql.conf(which is included by server) but it's not expanded in sql/mysql-dialup.conf" ... nas_query = "SELECT id, ipaddr, shortname, type, secret FROM ${nas_table} where secret <> 'DISABLED' group by ipaddr" ... It's related at least to all variables defined in sql.conf. Milan Holub holub (at) thenet (dot) ch -------------------------------------- TheNet-Internet Services AG, im Bernertechnopark, Morgenstr. 129 CH-3018, Bern, Switzerland 031 998 4333, Fax 031 998 4330 http://www.thenet.ch http://wlan.thenet.ch --------------------------------------