Open 4001982248998 opened 6 years ago
Reason: it apparently is not allowed to specify a “null time” like 0000-00-00 00:00:00 anymore. Better use 1970-01-01 00:00:01
0000-00-00 00:00:00
1970-01-01 00:00:01
--- etc/createdb 2018-01-19 10:57:14.300834370 +0100 +++ /usr/local/rtg2/etc/createdb 2018-01-19 12:30:15.710919040 +0100 @@ -23,11 +23,8 @@ # Create the necessary SQL in two /tmp files cat <<EOT >/tmp/mysql.sql -INSERT INTO user (Host, User, Password) VALUES ('$HOST','$USER',PASSWORD("$RTGPASS")); -INSERT INTO db (Host, Db, User, Select_priv, Insert_priv, Update_priv, Delete_priv, -Create_priv, Drop_priv, Grant_priv, References_priv, Index_priv, Alter_priv) -VALUES ('$HOST','$DATABASE','$USER','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'); -FLUSH PRIVILEGES; +CREATE USER '$USER'@'localhost' IDENTIFIED BY '$RTGPASS'; +GRANT ALL PRIVILEGES ON rtg.* TO '$USER'@'localhost'; EOT cat <<EOT >/tmp/rtg.sql @@ -63,7 +60,7 @@ CREATE TABLE ifInOctets ( id int(11) unsigned NOT NULL default '0', - dtime datetime NOT NULL default '0000-00-00 00:00:00', + dtime datetime NOT NULL default '1970-01-01 00:00:01', counter bigint(20) unsigned NOT NULL default '0', rate DOUBLE unsigned NOT NULL, KEY ifInOctets_idx (dtime) @@ -75,7 +72,7 @@ CREATE TABLE ifOutOctets ( id int(11) unsigned NOT NULL default '0', - dtime datetime NOT NULL default '0000-00-00 00:00:00', + dtime datetime NOT NULL default '1970-01-01 00:00:01', counter bigint(20) unsigned NOT NULL default '0', rate DOUBLE unsigned NOT NULL, KEY ifOutOctets_idx (dtime) @@ -87,7 +84,7 @@ CREATE TABLE ifInUcastPkts ( id int(11) unsigned NOT NULL default '0', - dtime datetime NOT NULL default '0000-00-00 00:00:00', + dtime datetime NOT NULL default '1970-01-01 00:00:01', counter bigint(20) unsigned NOT NULL default '0', rate DOUBLE unsigned NOT NULL, KEY ifInUcastPkts_idx (dtime) @@ -99,7 +96,7 @@ CREATE TABLE ifOutUcastPkts ( id int(11) unsigned NOT NULL default '0', - dtime datetime NOT NULL default '0000-00-00 00:00:00', + dtime datetime NOT NULL default '1970-01-01 00:00:01', counter bigint(20) unsigned NOT NULL default '0', rate DOUBLE unsigned NOT NULL, KEY ifOutUcastPkts_idx (dtime) @@ -111,7 +108,7 @@ CREATE TABLE ifInErrors ( id int(11) unsigned NOT NULL default '0', - dtime datetime NOT NULL default '0000-00-00 00:00:00', + dtime datetime NOT NULL default '1970-01-01 00:00:01', counter bigint(20) unsigned NOT NULL default '0', rate DOUBLE unsigned NOT NULL, KEY ifInErrors_idx (dtime)
Reason: it apparently is not allowed to specify a “null time” like
0000-00-00 00:00:00
anymore. Better use1970-01-01 00:00:01