header1 : ERROR db gwactivity_logs: Incorrect string value: ’\xDDerrsssi...’ for column ’status’ at row 1"
ERROR DB gwactivity_logs: Incorrect string value during Ezeelogin upgrade
For the above error, you need to set the status of the " gwactivity_logs " table to empty for row 1. Gateway Activity Logs stores the details of all the Ezeelogin users accessing the Ezeelogin ssh gateway server under Users >> Shell Activity. The following screenshot shows how the Gateway Activity logs look like:
1.Run the following command to take Ezeelogin database backup.
[email protected]:# mysqldump $(awk '/^db_name/ {print $2}' /usr/local/etc/ezlogin/ez.conf) > $(awk '/^db_name/ {print $2}' /usr/local/etc/ezlogin/ez.conf).sql
[email protected]:# mysqldump $(awk '/^db_name/ {print $2}' /usr/local/etc/ezlogin/ez.conf) $(awk '/^db_prefix/ {print $2}' /usr/local/etc/ezlogin/ez.conf)gwactivity_logs >$(awk '/^db_prefix/ {print $2}' /usr/local/etc/ezlogin/ez.conf)gwactivity_logs.sql
Replace " dbprefix_" with the value of dbprefix_ in /usr/local/etc/ezlogin/ez.conf of your ezeelogin jump server.
mysql> update dbprefix_gwactivity_logs set status="" where id=1;
mysql> update dbprefix_gwactivity_logs set status="";