Troubleshooting
Problem 1: An error is reported when MariaDB verifies the user.
Symptom
An error message similar to "ERROR 1045 (28000): Access denied for user 'test'@'localhost' (using password: YES)" is displayed when MariaDB verifies the user.
Possible Cause
The default plugin attribute is incorrect.
Procedure:
See 7.
Problem 2: An error is reported when MariaDB creates a database.
Symptom
MariaDB verifies the user successfully, but an error message similar to "ERROR 1045 (28000): Access denied for user 'pasa'@'localhost' (using password: YES)" during database creation.
Possible Cause
The permission of the paas user is incorrect.
Procedure:
Run the following commands: mysql -upasa -p123456
use mysql;
insert into mysql.user(Host,User,Password) values("localhost","pasa",password("123456"));
Problem 3: An error is reported during the PASA running.
Symptom
An error message similar to "Can't locate URI/Escape.pm in @INC" is displayed during the PASA running.
Possible Cause
The URI is missed in Perl.
Procedure
See Installing URI.
Parent topic: PASA 2.4.1 Porting Guide (CentOS 7.6)