NethServer Version: NS8 Module: Mariadb and PHPMyAdmin
I have Nethserver 8 on a Debian12 VM in Proxmox. Additionally, I have a Nethsecurity 8 VM in Proxmox. I have two NICs on the Proxmox PC; one for internet access using a public IP from my ISP. The other NIC is for office LAN access to the Proxmox GUI. I then configured both a WAN NIC and a virtual NIC on the Nethsecurity VM. The same virtual NIC I have assigned to the Debian 12 VM, which gets it local IP address from the Nethsecurity VM. To access Nethserver 8 and the apps across the internet, I had to create port forwarding rules in Nethsecurity 8, to direct traffic from the WAN IP to the LAN IP. I got this all working smashingly. Shwew, it was tough and cumbersome to get it there, but it is working now.
The https://subdomain.domain.com is the same for Nethsecurity and Nethserver, as can be imagined. The difference is the former uses :9090 in the address bar and the latter uses /cluster-admin. Both seem to work just fine, although Nethserver seems quite sluggish, but that’s a later worry.
Now, within the Nethserver 8 VM, I first installed Nextcloud, which seems to be working. It has a subdomain name of ‘cloud’, so, https://cloud.domain.com.
I didn’t realize I needed to enable the Nethforge repo to find the Webserver and Mariadb, until I searched this forum. I’ve since installed both, albeit after Nextcloud. I’m thinking Nextcloud doesn’t need the same instance of Mariadb as the webserver, since it’s part of the default repo. I made /PHPMyAdmin the path for Mariadb, so to access it I’m using https://subdomain.domain.com/phpmyadmin. I get to the login page and enter admin:admin, but it appears mysql is denying access. I tried my Nethserver credentials and same thing. I tried my root credentials and the same thing. I don’t know what I’m missing. The phpmyadmin doc for NS8 says admin:admin.
Logged in as root on the Debian 12 VM that NS8 resides on, then using your runagent command and then podman command, gives me an error saying, access denied for user 'root'@'localhost'(using password YES).
Almost like I need to be logged in as ‘admin’ in the mariadb environment to be able to reset admin’s password.
It should be possible to login as root without password as the mysql root password is stored in the .my.cnf file in the container.
podman exec mariadb-app cat /root/.my.cnf
Maybe it helps to click save in the NS8 app settings to start reconfiguration.
But I guess something went wrong at installation (like database init) so I think in this case it’s the easiest way to just remove mariadb and reinstall it.
If there are still issues please share the logs after installation and first configuration.
Thanks Markus. I did a number of steps after uninstalling Mariadb. I created a new subdomain in the DNS of my domain host. I did this to differentiate between the Nethsecurity and Nethserver VMs (mentioned in my original post above). Then I used this when creating a domain and user in cluster-admin (I hadn’t done this combination yet). I used the newsubdomain.domain.com as the domain when configuring. I then installed Mariadb and configured it. Now https://newsubdomain.domain.com/phpmyadmin got me in using admin:admin. I was then able to assign a new password to phpmyadmin. Thanks for your input. It’s a great forum when even the gurus help you out with problems. Going through all these cumbersome steps and then R&D’ing will lead me to a decision if I want to keep a proxmox pc and its VMs to replace dedicated equipment we’re currently using. One of them is NS7. I’ll purchase NS8 subscriptions if and when it makes sense to make the leap to Nethsecurity 8 and Nethserver 8.
