installer not working

[Stefano Gatto]

Hello, I just tried to install piler on a fresh ubuntu 20.04.3 server. after cloning git repo and modifying focal.sh the procedure stopped with

• mysql --defaults-file=/etc/piler/.my.cnf-root -h localhost
• mysql --defaults-file=/etc/piler/.my.cnf -h localhost piler
  ERROR 1045 (28000): Access denied for user 'piler'@'localhost' (using password: YES)

note that if I try to connect to mysql the password in .my.cnf works, what can I check to solve?

BR

‌

[Janos SUTO]

Not sure, the last time I checked the installer worked properly, though with the intended product. Anyway, what did you change?

[Stefano Gatto]

I modified piler_hostname, mysql root password and mysql piler password, nothing else.

‌

[Janos SUTO]

I’ll see if for myself, and keep you posted.

[Stefano Gatto]

thanks

[Janos SUTO]

#lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description:    Ubuntu 20.04.3 LTS
Release:    20.04
Codename:   focal

I’ve just tested with the above system. I change the hostname only, and the installer script has completed just fine.

[Stefano Gatto]

Thank you Janos, I think it could be related to password I choosed for root and piler mysql users?

5A=qAMVW%(xC

YRP##99rn6v7

maybe the symbols are not correctly processed? Strange is that if I try to connect to mysql by hand ( mysql -u user -p ) the credentials work…

Well monday I will try changing only hostname and I’ll keep you up to date

[Janos SUTO]

Indeed, that could be an issue if you don’t properly escape metacharacters having a special meaning to bash.

[Stefano Gatto]

thank you Janos, after modifying password everything has worked as expected