ReportServer Forum

gonzametal

Member

Registered: 2018-08-21

mysql 8 problems

Hi, I am trying to setup reportserver comunity, and the ddl step (using mysql 8) fails here:

create table RS_MONDRIAN_DATASOURCE_CFG (
        cube varchar(255),
        id bigint not null,
        primary key (id)
    ) CHARACTER SET utf8 COLLATE utf8_bin;

In mysql 8, CUBE is a reserver word..... (https://dev.mysql.com/doc/refman/8.0/en/keywords.html)

eduardo

Administrator

Registered: 2016-11-01

Website

Re: mysql 8 problems

Hi gonzametal,

thanks for raising this issue, we are looking into this here: RS-3028
I will update here when I have more information.

We will probably rename this column in the next 3.0.4 version released in the next weeks.

Regards,
Eduardo

eduardo

Administrator

Registered: 2016-11-01

Website

Re: mysql 8 problems

Hi gonzametal,

as I mentioned, these columns will be renamed in the next 3.0.4 version of reportserver. I already changed this.
Note that this does not imply mysql 8 support. For this, I raised ticket RS-3029 and I will update here when mysql 8 is supported.

Regards,
Eduardo

eduardo

Administrator

Registered: 2016-11-01

Website

Re: mysql 8 problems

Hi gonzametal,

ReportServer 3.2.0 will support MySQL 8 (and MariaDB 10)

Regards,
Eduardo