Problem with server atribute in NAS table with mysql

[Alan Buxey]

Hi,

> My clients are in a MySQL database (nas table).
> 
> +----+------------------+---------------+-------+---------+------------+---------+---------------+---------------------------+
> | id |     nasname     |  shortname | type  | ports    | secret     | server
> | community  | description                |
> +----+------------------+---------------+-------+---------+------------+---------+---------------+---------------------------+
> | 1 |      XXX             | NODO1      | other | NULL | secretN1 | nodes  |
> nodo           | Nodo Wifi                  |
> | 2 |      YYY             | NODO2      | other | NULL | secretN2 | nodes  |
> nodo           | Nodo Wifi                  |
> 
> 
> I want to process some clients through one virtual server (server nodes{}),
> so I have the name of the virtual server in the "server" column, but this
> doesn't work.
> 
> When I receive a request from those clients, the default server proccess
> them.

which means you havent updated the SQL qeuery to use that column.

check your sql/mysql/dialup.conf file and edit the call to pull in the NAS
from

        nas_query = "SELECT id, nasname, shortname, type, secret FROM ${nas_table}"

to

	nas_query = "SELECT id, nasname, shortname, type, secret, server FROM ${nas_table}"

then the server attribute will be pulled in and the 'nodes' virtual host will get used.

alan