Problem on HA setup

Question
1

Hello,
I’m trying to setup 3 nodes PI on 3 nodes MariaDB cluster using the easiest
way: setup 3 nodes MariaDB cluster, then apt-get install privacyidea-nginx
on each node.
I’ve updated all enckey, .pem files and config file on all 3 nodes.
The problem is I only can login to pi03 (the last installed node) and
cannot login to pi01, pi02 web anymore, the error is:

{“jsonrpc”: “2.0”, “signature”:
“7026187327632330681633278920140001577450896977871678459157906326988922079927221036010632651285825459452995613995289272807022263847210357391775903678218621755917780820271246124712451612053264934063580437005200196382606183272804047061946302963599529499788844249627864373595692877669121414593459648097981651219635212708050872132333597009060491288725390199453523300874403665893887013221170229524471921435017766677311093316991375981844546012045951058413541079432083370393892602733553123894146946273396410000940703884843030759965447215553033693040129923541510979035828829494260393223258357219514493197547562393405194948662”,
“detail”: null, “version”: “privacyIDEA 2.18.1”, “result”: {“status”:
false, “error”: {“message”: “(pymysql.err.OperationalError) (1045,
u"Access denied for user ‘pi’@‘localhost’ (using password: YES)")”,
“code”: -500}}, “time”: 1493204627.690565, “id”: 1}

I still can login to mysql using the password show on config file.

Maybe I missed some steps or it has other way to setup HA?

Thank you,
Tan

2

Hi,
Find out that I need to reload uwsgi script to read new config file.
/etc/init.d/uwsgi reload

Sorry to bother,
TanOn Wednesday, April 26, 2017 at 6:07:15 PM UTC+7, Tran Trong Tan wrote:

Hello,
I’m trying to setup 3 nodes PI on 3 nodes MariaDB cluster using the
easiest way: setup 3 nodes MariaDB cluster, then apt-get install
privacyidea-nginx on each node.
I’ve updated all enckey, .pem files and config file on all 3 nodes.
The problem is I only can login to pi03 (the last installed node) and
cannot login to pi01, pi02 web anymore, the error is:

{“jsonrpc”: “2.0”, “signature”:
“7026187327632330681633278920140001577450896977871678459157906326988922079927221036010632651285825459452995613995289272807022263847210357391775903678218621755917780820271246124712451612053264934063580437005200196382606183272804047061946302963599529499788844249627864373595692877669121414593459648097981651219635212708050872132333597009060491288725390199453523300874403665893887013221170229524471921435017766677311093316991375981844546012045951058413541079432083370393892602733553123894146946273396410000940703884843030759965447215553033693040129923541510979035828829494260393223258357219514493197547562393405194948662”,
“detail”: null, “version”: “privacyIDEA 2.18.1”, “result”: {“status”:
false, “error”: {“message”: “(pymysql.err.OperationalError) (1045,
u"Access denied for user ‘pi’@‘localhost’ (using password: YES)")”,
“code”: -500}}, “time”: 1493204627.690565, “id”: 1}

I still can login to mysql using the password show on config file.

Maybe I missed some steps or it has other way to setup HA?

Thank you,
Tan