Install on debian 9 (and MariaDB 10.1.23)

4 posts / 0 new
Last post
tajoli
Install on debian 9 (and MariaDB 10.1.23)

Hi to all,

I'm tring to install CWIS 4 on a Debian 9 with MariaDB 10.1.23, PHP 7.0.21, Apache 2.4.25.
I find problems on setup tables of database.
The error is:

Database command failed:
CREATE TABLE IF NOT EXISTS TaskQueue (
TaskId INT NOT NULL AUTO_INCREMENT,
Callback MEDIUMTEXT DEFAULT NULL,
Parameters MEDIUMTEXT DEFAULT NULL,
Priority INT DEFAULT 3,
Description TEXT DEFAULT NULL,
INDEX (TaskId),
INDEX (Callback(64), Parameters(256))
);
(SQL error: Specified key was too long; max key length is 1000 bytes)

In MariaDB (and also in MySQL) now the default charset of a db is uft8mb4, the default engine is InnoDB and general speakong
charset is on uft8. In this situation the CREATE command of table 'TaskQueue' is invalid.
So, what do I need to do on MariaDB/MySQL config ?
Do I need to setup deafult to Engine=MyISAM anc charset=latin1 ?

Bye

ealmasy
Re: Install on debian 9 (and MariaDB 10.1.23)

Ah, we're not currently running Debian on any of our servers at Scout, so we hadn't seen this issue.  If you unpack the attached zip file and copy the enclosed ApplicationFramework--CreateTables.sql file into the lib/ScoutLib directory and the enclosed CHECKSUMS file into the install directory and then run the installation, I think that should take care of the problem.

tajoli
Re: Install on debian 9 (and MariaDB 10.1.23)

Hi,
I test the patch and now CWIS 4 works in my enviroment.
But attention, if you use PHP7.0 [on every Linux env] you need to to install php7.0-mbstring.
It is not a standard part of PHP7.0, so you need to add it.
On debian/Ubuntu:
apt-get install php7.0-mbstring

More info here:
https://stackoverflow.com/questions/35756821/call-to-undefined-function-...
Bye

ealmasy
Re: Install on debian 9 (and MariaDB 10.1.23)

Glad to hear the patch worked for you!

And thank you for letting us know about the mbstring issue.  If possible we'll make those functions optional in the 4.0.1 release.  (And of course also fix the key length issue.)