Skip to Content

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. 

root@gateway:#   mysqldump $(awk '/^db_name/ {print $2}' /usr/local/etc/ezlogin/ez.conf) > $(awk '/^db_name/ {print $2}' /usr/local/etc/ezlogin/ez.conf).sql

 
 2.Run the following command to take the backup of the "  gwactivity_logs " table.   

root@gateway:#  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

 
3. Log in to your MySQL console and clear the status field values on table " gwactivity_logs " for row 1.   
 

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;

 
4. If clearing the status for row 1 doesn’t fix the issue, you need to clear the status of all the rows in the table " gwactivity_logs ".   

mysql> update dbprefix_gwactivity_logs set status="";

 
 After clearing the status field you can continue updating Ezeelogin.