[jira] [Commented] (FINERACT-951) use Ubuntu Xenial instead of Trusty on Travis

["Michael Vorburger (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/FINERACT-951?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17102880#comment-17102880 ] 

Michael Vorburger commented on FINERACT-951:
--------------------------------------------

[~ptuomola] noted in FINERACT-763 that the problem re. {{UPDATE user SET password=PASSWORD('mysql') WHERE user='root';}} is, quote:

{quote}I think this is because Xenial has MySQL 5.7 (instead of 5.5), and MySQL 5.7 has no 'password' column (the column is called 'authentication_string'). So to get this to work a) Fineract needs to work with MySQL 5.7 and the script needs to be updated to refer to the right column or b) MySQL in the image needs to be downgraded to 5.5.{quote}

It seems like the "[recommended|https://www.cyberciti.biz/faq/mysql-change-user-password/]" (?) way to set MySQL user passwords is actually to use {{ALTER USER 'userName'@'localhost' IDENTIFIED BY 'New-Password-Here';}} ?  Or perhaps even better, there apparently is a [SET PASSWORD|https://dev.mysql.com/doc/refman/8.0/en/set-password.html] ...

[~ptuomola] do you want to explore this, and raise a PR? Let's do this separately from and in parallel to FINERACT-937 ...

> use Ubuntu Xenial instead of Trusty on Travis
> ---------------------------------------------
>
>                 Key: FINERACT-951
>                 URL: https://issues.apache.org/jira/browse/FINERACT-951
>             Project: Apache Fineract
>          Issue Type: Improvement
>            Reporter: Michael Vorburger
>            Priority: Major
>
> In FINERACT-763, we (had to) fix {{dist: trusty}} in our {{.travis.yml}}.
> That worked around that problem - but now we're stuck on this (fairly old..) Ubuntu, on Travis.
> For FINERACT-937, but also more generally, we should move on to Trusty, if we can.
> This requires solving that {{mysql}} problem.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)