Hello all,
I have Librenms running from last 20 days. 95 Devices and more than 15.000 Ports.
I have a few servers in my company and i’m thinking to move mysql to another mysql server.
I have mysql database exported but when i’m trying to import to the second mysql server i have this error:
Error
SQL query:
CREATE TABLE
users
(
user_id
int(11) NOT NULL,
username
char(30) COLLATE utf8_unicode_ci NOT NULL,
password
varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
realname
varchar(64) COLLATE utf8_unicode_ci NOT NULL,
descr
char(30) COLLATE utf8_unicode_ci NOT NULL,
level
tinyint(4) NOT NULL DEFAULT ‘0’,
can_modify_passwd
tinyint(4) NOT NULL DEFAULT ‘1’,
twofactor
varchar(255) COLLATE utf8_unicode_ci NOT NULL,
dashboard
int(11) NOT NULL DEFAULT ‘0’,
created_at
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_at
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
MySQL said: Documentation
#1293 - Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
The idea is that maybe i can go forward to have more than 4000 devices in. (mostly switches with 48 ports).
The current server is a:
Intel Xeon X5660 @ 2.80GHz x24 with 48GB ram.
Also, if i will go foward, where i can find a tutorial to have a separate poller online? or maybe a few.
Thank you,
Paul