[Loris-dev] loris server

[Julie Ashworth, HWNI Computing Support]

Thanks Melanie,

On 12-11-2019 12.06 +0000, Melanie Legault, Mrs wrote:
>    Hello,
>    Also, in the config table, `url` should be `http://localhost/` with the
>    slash at the end. Should not be the cause to the current problem.

The 'troubleshooting' instructions state to use localhost without the slash:

"ConfigSetting host value should not terminate in a slash. E.g.
"http://localhost" not "http://localhost/". To fix, run: (for http)
UPDATE Config SET Value='http://localhost' WHERE ConfigID=(SELECT ID
FROM ConfigSettings WHERE Name='host');"
https://github.com/aces/Loris/wiki/Project-Customization#troubleshooting-configuration-settings

Will you please confirm if localhost should have a slash at the end?

>    As for creating a new user, I don't think it will solve the problem.
>    Could you ensure that in MariaDB, the user `lorismysql`@`localhost` have
>    the update permission (select, insert, update, delete) on
>    `loris_database`.* as well as  usage on these tables.

MariaDB [(none)]> SHOW grants for 'lorismysql'@'localhost';
+-------------------------------------------------------------------------------------------------------------------+
| Grants for lorismysql at localhost
+-------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'lorismysql'@'localhost' IDENTIFIED BY PASSWORD xxx
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE TEMPORARY TABLES ON `loris_database`.* TO 'lorismysql'@'localhost'   |
+-------------------------------------------------------------------------------------------------------------------+

>    Also can you check which version of MariaDB you have?  The version of
>    MariaDB that come with CentOS 7 isn't supported for the latest versions of
>    LORIS.
>    We have instructions (not quite definitive yet) on how to install MariaDB
>    10.3 in the documentation for Release 22 that should be out soon.
>    [1]https://github.com/aces/Loris/blob/22.0-release/README.CentOS7.md
>    Kind regards,
> 

Ahh, this is probably why it isn't working. 

# rpm -qi mariadb
Name        : mariadb
Epoch       : 1
Version     : 5.5.64
Release     : 1.el7
Architecture: x86_64
Source RPM  : mariadb-5.5.64-1.el7.src.rpm
Build Date  : Thu 08 Aug 2019 07:29:56 AM PDT
Packager    : CentOS BuildSystem <http://bugs.centos.org>

I'll try reinstalling MariaDB.

thanks,
Julie