Hi Piotr, Can you check in the failed-to-upgrade DB whether this table cloud.ldap_trust_map exists? As per the log, the table must have been created. Please check the line number 3814 in the log you shared. Can you create the table? Is there any error?
CREATE TABLE IF NOT EXISTS `cloud`.`ldap_trust_map` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `domain_id` bigint unsigned NOT NULL, `type` varchar(10) NOT NULL, `name` varchar(255) NOT NULL, `account_type` int(1) unsigned NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `uk_ldap_trust_map__domain_id` (`domain_id`), CONSTRAINT `fk_ldap_trust_map__domain_id` FOREIGN KEY (`domain_id`) REFERENCES `domain` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 -Jithin From: Rohit Yadav <[email protected]> Date: Tuesday, 9 July 2024 at 8:34 PM To: [email protected] <[email protected]> Subject: Re: Table 'cloud.ldap_trust_map' doesn't exist Hi Piotr, I'm also using Ubuntu22.04 with kvm and didn't hit it. Can you check and try to apply DB configure (mysqld.cnf) as in my notes here https://rohityadav.cloud/blog/cloudstack-kvm/ If it still happens, are you using MySQL server from Ubuntu's repo or somewhere else? Can you also try 24.04? Regards. ________________________________ From: Piotr Pisz <[email protected]> Sent: Tuesday, July 9, 2024 8:28 PM To: [email protected] <[email protected]> Subject: Table 'cloud.ldap_trust_map' doesn't exist Hi! I'm trying to make a new installation of CS mgmt on ubuntu22 but every time I get a similar error: 2024-07-09 16:42:09,621 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:) java.sql.SQLSyntaxErrorException: Table 'cloud.ldap_trust_map' doesn't exist 2024-07-09 16:42:09,622 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) Unable to execute upgrade script java.sql.SQLSyntaxErrorException: Table 'cloud.ldap_trust_map' doesn't exist Database setup goes ok, the versions are correct (mysql 8.0 java 11, CS 4.19.0.0), unfortunately the first run always stops in the same place. I have done such installations before and they worked properly. I have no idea where the error might be, the full log is attached. Maybe someone could give me a hint? Regards Piotr
