[
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)
