Vvveb postinstall: how to connect database? Which database?

[dankerthrone]

What app is this about, and its version: vvveb 1.0.7.3~ynh1
What YunoHost version are you running: 12.1.27
What type of hardware are you using: VPS bought online

Describe your issue

Stuck post-install.

I’m trying to set up an instance of vvveb for an online presence, but post-install I’m greeted with this screen and I have no idea what to input here.

I can’t create new users, but I also do not know how to authenticate existing DB users and whether that’s a good idea.

Please help

Share relevant logs or error messages

none

[dankerthrone]

Nevermind, Claude Sonnet 4.5 pointed out that it’s entirely possible that the install process did indeed create a vvveb mysql database, but it didn’t show up in the post-install messages.

Sure enough:

sudo yunohost app setting vvveb db_name
sudo yunohost app setting vvveb db_user
sudo yunohost app setting vvveb db_pwd

revealed the DB name and user to be vvveb and also a strong randomly generated password.

However, when I queried MariaDB about user vvveb, it didn’t know any such user.

So basically what you have to do at this point is tell the DB about your user. There doesn’t seem to be a yunohost CLI command to this, so I hope I didn’t introduce any headaches down the road by going

sudo mysql <<EOF
CREATE DATABASE IF NOT EXISTS vvveb CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE USER IF NOT EXISTS 'vvveb'@'localhost' IDENTIFIED BY 'superstrongandsecurepwd';
GRANT ALL PRIVILEGES ON vvveb.* TO 'vvveb'@'localhost';
FLUSH PRIVILEGES;
EOF

Now I can get past the post-install screen and see if I like this complicated CMS better than my currently installed complicated CMS, Wordpress

[jarod5001]

@dankerthrone

MariaDB

That’s because the package defines a postgresql db