Hi, We have a problem with our production server. The issue it self was resolved but we now try to restore our backup. With restoring the backup the newly created tables and data result in a corrupt end result.
The issue is that the fields with the unix time stamp as INT result in a TINYINT in the restored database. For example the egw_Accounts.account_lastlogin is defined as a TINYINT. with the value 127. that is not even close to the regular expression in that field.
This results in so much errors in the data that our database backups are not usable without a lot of manual labor. The backup itself is in correct shape. Field are correct in the declaration:
‘egw_accounts’ => array(
‘fd’ => array(
‘account_id’ => array(‘type’ => ‘auto’,‘nullable’ => False),
‘account_lid’ => array(‘type’ => ‘varchar’,‘precision’ => ‘64’,‘nullable’ => False),
‘account_pwd’ => array(‘type’ => ‘varchar’,‘precision’ => ‘128’,‘nullable’ => False),
‘account_lastlogin’ => array(‘type’ => ‘int’,‘precision’ => ‘1’),
‘account_lastloginfrom’ => array(‘type’ => ‘ascii’,‘precision’ => ‘255’),
‘account_lastpwd_change’ => array(‘type’ => ‘int’,‘precision’ => ‘1’),
‘account_status’ => array(‘type’ => ‘varchar’,‘precision’ => ‘1’,‘default’ => ‘A’,‘nullable’ => False),
‘account_expires’ => array(‘type’ => ‘int’,‘precision’ => ‘1’),
‘account_type’ => array(‘type’ => ‘varchar’,‘precision’ => ‘1’),
‘account_primary_group’ => array(‘type’ => ‘int’,‘precision’ => ‘1’,‘default’ => ‘0’,‘nullable’ => False),
‘account_challenge’ => array(‘type’ => ‘varchar’,‘precision’ => ‘100’),
‘account_response’ => array(‘type’ => ‘varchar’,‘precision’ => ‘100’),
‘account_description’ => array(‘type’ => ‘varchar’,‘precision’ => ‘255’)
We run on Azure, Ubuntu 20.04, Local MYSQL on the host of the dockers, database creation by the egroupware/setup page is succesfull, restore from this setup page. But the result is that you cannot login, cannot create a admin account. etc…
Some help would be appreciated.
Kind regards, Sacha.
