![](https://secure.gravatar.com/avatar/21caf0a08d095be7196a1648d20942be.jpg?s=120&d=mm&r=g)
Hi Dirk-Willem,
Does this survive a mysql restart? I assume it doesn't? :o
Tom
On 2016-01-22 12:12, Dirk-Willem van Gulik wrote:
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
……..
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium