22 Jan
2016
22 Jan
'16
12:12 p.m.
On 22 Jan 2016, at 11:04, Adam Armstrong adama@memetic.org wrote:
I'm actually not sure. Perhaps in /etc/mysql/my.cnf ?
Adam.
Snippet from our updated config for test setups below. It is the SET line you are after.
…..
set -e cd $INSTDIR
rm -rf logs rrd mkdir logs rrd chown www:www rrd
cat <<EOM | mysql CREATE DATABASE observium DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; GRANT ALL PRIVILEGES ON observium.* TO 'observium'@'localhost' IDENTIFIED BY ‘$INSTPASS'; SET GLOBAL sql_mode = ‘';
EOM
./discovery.php -u ./adduser.php admin "$INSTPASS" 10
cat $CFG/devices | while read host; do ./add_device.php $host public v2c; done
./discovery.php -h all -d ./poller.php -h all -d
……..