Phpmyadmin databases, but not root

[unecc]

What type of hardware are you using: Virtual machine
What YunoHost version are you running: 12.1.25 (stable)

Describe your issue

I’ve yunohost on a proxmox vm.
My installed app is moodle and phpmyadmin.
I would access to moodle mysql database but when i open phpmyadmin, it make autologin with phpmyadmin_root@localhost so i can’t view moodle databases.
i try to logout but doesn’t works.
please how can I do? Thanks

Share relevant logs or error messages

general info.

[otm33]

Hello @unecc

AFAIK, Moodle uses postgresql with yunohost.
Check the output of

sudo mariadb -e "SHOW DATABASES;"
sudo -u postgres psql -p 5432 -c "\l"

*port for postgresql may be different

[unecc]

[unecc]

But moodle db is empty, maybe i’ve created that db…

[otm33]

@unecc

moodle db is empty, maybe i’ve created that db…

which db are you mentionning ?
First table returns mariadb DB (sudo mariadb -e "SHOW DATABASES;"),
Second one postgresql DB (sudo -u postgres psql -p 5432 -c "\l"

Does

sudo -u postgres psql -d moodle -c "\dt"

return noting ?

[unecc]

[jarod5001]

Can you please use copy/paste what’s in the terminal instead of screenshots?

[unecc]

yes, right!
with sudo -u postgres psql -d moodle -c “\dt”
i can see schema of moodle db.

[otm33]

@unecc

with sudo -u postgres psql -d moodle -c “\dt”
i can see schema of moodle db.

wrong screenshot ?

[unecc]

@otm33

sudo mariadb -e "SHOW DATABASES;"),

yes i’ve closed the result. Otm thanks, maybe you are saying to me that moodle don’t use mysql but pgsql?

[otm33]

@unecc

maybe you are saying to me that moodle don’t use mysql but pgsql?

I am

@otm33

Moodle uses postgresql with yunohost.

manifest.toml

[unecc]

So thanks for your help!
pgweb app can connect to database. thanks