Hi
For those that like to automate things here's how you can automate the client configuration.
Create a client as a template.
Log into the server and change directory to where the SQLite datafiles are stored.
# cd /usr/local/MONyog/data/
# ls
Check which is the next number in the sequence it is always four digits like 0005. Create a new directory using the next number in the sequence. Replace 0006 with the sequence number.
# mkdir 0006
In the GUI the template client should have a number like 0005. Copy the connection.data file to the new directory.
# cp 0005/connection.data 0006/
Open the new datafile using SQLite.
# sqlite3 0006/connection.data
sqlite> select * from server_names;
Check which entries you need to change and issue an update.
sqlite> update server_names set name='ServerName', host='ServerName', host_system='ServerName', slowquery_logpath='PathToSlowLog';
After you have updated the settings exit SQLite with CTRL+D. To activate the new client you need to restart MONyog.
# service MONyogd restart
Hope this is useful to someone. More information can be found under:
http://www.webyog.com/blog/2009/07/29/mony…hema-explained/
