[
https://issues.apache.org/jira/browse/FINERACT-763?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17102876#comment-17102876
]
Petri Tuomola commented on FINERACT-763:
----------------------------------------
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.
> Travis CI builds are suddenly failing with a weird error
> --------------------------------------------------------
>
> Key: FINERACT-763
> URL: https://issues.apache.org/jira/browse/FINERACT-763
> Project: Apache Fineract
> Issue Type: Bug
> Reporter: Michael Vorburger
> Assignee: Michael Vorburger
> Priority: Critical
> Fix For: 1.4.0
>
> Time Spent: 20m
> Remaining Estimate: 0h
>
> While having a closer look at the build failures of
> https://github.com/apache/fineract/pull/582, I noticed that the first time,
> in Build #162, it seems to have failed in the license test build step just
> due to `Could not GET
> 'https://jcenter.bintray.com/junit/junit/4.12/junit-4.12.jar'. Received
> status code 504 from server: Gateway Time-out` - but had clearly managed to
> do the initial build steps which set the password of the root user for the
> test database.
> The second time (after I added the amended README to this PR), in Build #167
> it fails early when it tries to set the mysql password like this:
> {noformat}
> $ echo "USE mysql;\nUPDATE user SET password=PASSWORD('mysql') WHERE
> user='root';\nFLUSH PRIVILEGES;\n" | mysql -u root
> PAGER set to stdout
> ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'field list'
> The command "echo "USE mysql;
> UPDATE user SET password=PASSWORD('mysql') WHERE user='root';
> FLUSH PRIVILEGES;
> " | mysql -u root" failed and exited with 1 during .
> Your build has been stopped.
> {noformat}
> What's noteworthy is that [Build
> #162|https://travis-ci.org/apache/fineract/builds/544611582#L6] ran with
> {{Build dist: trusty}} whereas [Build
> #167|https://travis-ci.org/apache/fineract/builds/544786072?utm_source=github_status]
> ran under {{Build dist: xenial}} ...
> ... this must be related to
> https://changelog.travis-ci.com/xenial-as-the-default-build-environment-99476
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
