You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cloudstack.apache.org by Piotr Pisz <pi...@piszki.pl> on 2024/07/09 14:57:41 UTC

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

Re: Table 'cloud.ldap_trust_map' doesn't exist

Posted by Jithin Raju <ji...@shapeblue.com>.
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 <ro...@shapeblue.com>
Date: Tuesday, 9 July 2024 at 8:34 PM
To: users@cloudstack.apache.org <us...@cloudstack.apache.org>
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 <pi...@piszki.pl>
Sent: Tuesday, July 9, 2024 8:28 PM
To: users@cloudstack.apache.org <us...@cloudstack.apache.org>
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

Re: Table 'cloud.ldap_trust_map' doesn't exist

Posted by Rohit Yadav <ro...@shapeblue.com>.
 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 <pi...@piszki.pl>
Sent: Tuesday, July 9, 2024 8:28 PM
To: users@cloudstack.apache.org <us...@cloudstack.apache.org>
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