A Database Error Occurred Error Number: 1062
A Database Error Occurred
Error Number: 1062 Duplicate entry '[email protected]' for key 'user_name'
INSERT INTO `ccm_users` (`username`, `password`, `email`, `firstname`, `lastname`, `esc`, `eak`, `egs`, `usergroup_id`, `status`, `priv`, `crypt`, `created`) VALUES ('user2', '$6$rounds=5476$8pJj9AyVGb8tsq5X$FOsQvq2OszdAB99GZlaRhngaJXuKfs9Fzk9xV1aSnNOHemkyh44CxJbcb2TR/Yur2VIojfngBC15K7jTcWGnn/', '[email protected]', 'user2', '', '$6$rounds=5714$Ezm1DqIDVG6Gb2sA$jNoMl4wEsGsyp921H3frCAjuUUiE5J4hfS/UQDrY6fph/8otVODwH2HH5vBgaD1uu1ilu2cifjiDG54ZKk/Pi1', '', '', '2', 1, 0, '$6$rounds=5323$kZ8aNMQvXy10QaJU$XWlYZNhYV163HWedm2RMu7UjgWKccFEy7qJR.4atSOSsEhUHUSFoVBTnDok4W1abFCkzrgye/j3VwfVzwgVdz0', '2016-10-04 15:07:06')
Filename: models/Mcluster.php Line Number: 257
A Database Error Occurred
Error Number: 1062 Duplicate entry '[email protected]' for key 'user_email' INSERT INTO `ccm_users` (`username`, `password`, `email`, `firstname`, `lastname`, `esc`, `eak`, `egs`, `usergroup_id`, `status`, `priv`, `crypt`, `created`) VALUES ('user2', '$6$rounds=5476$8pJj9AyVGb8tsq5X$FOsQvq2OszdAB99GZlaRhngaJXuKfs9Fzk9xV1aSnNOHemkyh44CxJbcb2TR/Yur2VIojfngBC15K7jTcWGnn/', '[email protected]', 'user2', '', '$6$rounds=5714$Ezm1DqIDVG6Gb2sA$jNoMl4wEsGsyp921H3frCAjuUUiE5J4hfS/UQDrY6fph/8otVODwH2HH5vBgaD1uu1ilu2cifjiDG54ZKk/Pi1', '', '', '2', 1, 0, '$6$rounds=5323$kZ8aNMQvXy10QaJU$XWlYZNhYV163HWedm2RMu7UjgWKccFEy7qJR.4atSOSsEhUHUSFoVBTnDok4W1abFCkzrgye/j3VwfVzwgVdz0', '2016-10-04 15:07:06')
Filename: models/Mcluster.php
Line Number: 105
This error can be fixed by truncating the prefix_qlogs table.
1. Login to the MySQL of Master node and take a dump of Ezeelogin database, prefix_qlogs table and truncate prefix_qlogs table
You can find the Ezeelogin database name from /usr/local/etc/ezlogin/ez.conf file.
root@jumpserver:~ mysqldump -u root -p ezeelogin_database_name > ezeelogindatabasebackup.sql
You can find the Ezeelogin database name and table prefix from /usr/local/etc/ezlogin/ez.conf file. Replace prefix with your database prefix.
root@jumpserver:~ mysqldump -u root -p ezlogindb_prefix prefix_qlogs> prefix_qlogs.sql
You should truncate the prefix_qlogs table with the following command.
You can find the table prefix from /usr/local/etc/ezlogin/ez.conf file. Replace prefix with your database prefix
mysql> truncate table prefix_qlogs;
2. Login to the MySQL of Slave node and take a dump of Ezeelogin database, prefix_qlogs table and truncate prefix_qlogs table
root@jumpserver:~ mysqldump -u root -p ezeelogin_database_name > ezeelogindatabasebackup.sql
You can find the Ezeelogin database name and table prefix from /usr/local/etc/ezlogin/ez.conf file. Replace prefix with your database prefix.
root@jumpserver:~ mysqldump -u root -p ezlogindb_prefix prefix_qlogs > prefix_qlogs.sql
You should truncate the prefix_qlogs table with the following command.
mysql> truncate table prefix_qlogs;
3. Login to Ezeelogin WUI of Master node and click on cluster tab > Verify database > sync the tables.
4. Login to Ezeelogin WUI of Slave node and click on cluster tab > Verify database > sync the tables.