Anemon website | Docs / MysqlSimpleConfig

1) First, create the database with the shell command :

 mysqladmin create anemondb

2) Second, launch the mysql command line interface :

 mysql

and run this command to add anemonuser:

 GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON `anemondb`.* TO `anemonuser`@localhost;

Well, you finished the database and user creation.

3) Create tables

 mysql anemondb -u anemonuser < scripts/mysql_schema.sql

4) In server.conf, change the database settings :

 interface_config['module'] = 'config_mysql'
 interface_config['host'] = 'localhost'
 interface_config['base'] = 'anemondb'
 interface_config['user'] = 'anemonuser'
 interface_config['pass'] = ''

 interface_leases['module'] = 'leases_mysql'
 interface_leases['host'] = 'localhost'
 interface_leases['base'] = 'anemondb'
 interface_leases['user'] = 'anemonuser'
 interface_leases['pass'] = ''

5) Insert basic conf data (see doc/config_config.howto.txt)

 INSERT INTO scopes (subnet,first,last) VALUES ('192.168.1.0/24','192.168.1.10','192.168.1.100');
 INSERT INTO options (subnet,parameter,value) VALUES ('192.168.1.0/24','broadcast_address','192.168.1.255');
 INSERT INTO options (subnet,parameter,value) VALUES ('192.168.1.0/24','domain_name_server','192.168.1.1');