Re: Error installing a brand new ACS 4.18.1

2023-10-25 Thread Wei ZHOU
Hi Ricardo, This seems to be an issue with mariadb refer to https://jira.mariadb.org/browse/MDEV-31987 -Wei On Thu, 19 Oct 2023 at 21:36, Ricardo Pertuz wrote: > I tried these versions none of them work > > 10.10.6-MariaDB > 10.5.22-MariaDB > 10.11.5-MariaDB > > Looks weird as I have a

Re: Error installing a brand new ACS 4.18.1

2023-10-20 Thread Ricardo Pertuz
Thanks Wei, I tried these commands SET FOREIGN_KEY_CHECKS=0; SET GLOBAL FOREIGN_KEY_CHECKS=0; without success, I removed Mariadb and installed Mysql 8.x and it working now. Atte, Ricardo Pertuz On 20 Oct 2023 at 4:46 AM -0500, users@cloudstack.apache.org, wrote: > > SET

Re: Error installing a brand new ACS 4.18.1

2023-10-20 Thread Wei ZHOU
Hi Ricardo, I have a ubuntu 20.04 env with mysql 8, it works mgmt1:~# dpkg -l |grep mysql-server ii mysql-server 8.0.34-0ubuntu0.20.04.1 all MySQL database server (metapackage depending on the latest version) ii mysql-server-8.0

Re: Error installing a brand new ACS 4.18.1

2023-10-19 Thread Ricardo Pertuz
I tried these versions none of them work 10.10.6-MariaDB 10.5.22-MariaDB 10.11.5-MariaDB Looks weird as I have a functional ACS 4.18.0 running on 10.5.19-MariaDB Atte, Ricardo Pertuz On 19 Oct 2023 at 1:35 PM -0500, Wei ZHOU , wrote: > The issue might be related to database versions, need

Re: Error installing a brand new ACS 4.18.1

2023-10-19 Thread Wei ZHOU
The issue might be related to database versions, need to confirm. Can you try MySQL or upgrade mariadb? -Wei 在 2023年10月19日星期四,Ricardo Pertuz 写道: > This one Wei: > > Server version: 10.10.6-MariaDB-1:10.10.6+maria~ubu2004 > > > Atte, > > Ricardo Pertuz > > > On 19 Oct 2023 at 12:56 PM -0500,

Re: Error installing a brand new ACS 4.18.1

2023-10-19 Thread Ricardo Pertuz
This one Wei: Server version: 10.10.6-MariaDB-1:10.10.6+maria~ubu2004 Atte, Ricardo Pertuz On 19 Oct 2023 at 12:56 PM -0500, Wei ZHOU , wrote: > HI Ricardo, > > Do you use MySQL, mariadb or other alternatives? What's the version? > > -Wei > > 在 2023年10月19日星期四,Ricardo Pertuz 写道: > > > Thans

Re: Error installing a brand new ACS 4.18.1

2023-10-19 Thread Wei ZHOU
HI Ricardo, Do you use MySQL, mariadb or other alternatives? What's the version? -Wei 在 2023年10月19日星期四,Ricardo Pertuz 写道: > Thans Wei, > > It it a new virtual machine with no previous installation, I just > > 1. Dropped both databases > 2. Send de cloudstack-database-setup again with no

Re: Error installing a brand new ACS 4.18.1

2023-10-19 Thread Ricardo Pertuz
Thans Wei, It it a new virtual machine with no previous installation, I just 1. Dropped both databases 2. Send de cloudstack-database-setup again with no errror 3. Start de ACS Management daemon Now getting another SQL error 2023-10-19 12:47:29,711 ERROR [c.c.u.d.ScriptRunner] (main:null)

Re: Error installing a brand new ACS 4.18.1

2023-10-19 Thread Wei ZHOU
Hi Ricardo, Have you installed management service on the host before? You can drop the cloud and cloud_usage database, then retry. If you install multiple management servers, install them one by one. -Wei 在 2023年10月19日星期四,Ricardo Pertuz 写道: > Hi team, > > I’m trying to install a brand new

Error installing a brand new ACS 4.18.1

2023-10-19 Thread Ricardo Pertuz
Hi team, I’m trying to install a brand new ACS 4.18 in Ubuntu 20.04 LTS and when starting it’s getting this error 2023-10-19 12:24:15,354 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:) Error executing: alter table vm_template add size bigint unsigned 2023-10-19 12:24:15,355 ERROR