Trouble with Database installation Ubuntu 22.04 Zero

[BreckAConner]

Good Morning,

I've been trying to go through the Ubuntu Server 22.04 Install guide. Everything has been smooth up until installing the database. After step 3 under "Install Database", I can't seem to figure out why I can't select my realm. I feel like the answer is right under me, but I can't figure it out.

MariaDB [(none)]> select * from realmlist;
ERROR 1046 (3D000): No database selected
MariaDB [(none)]> ERROR 1046 (3D000): No database selected

 

Breck Conner

 

 

[BreckAConner]

I am not that smart when it comes to databases. I figured it out between using the 18.04 tutorial and 22.04 tutorial. My issue was not selecting a database, I was following the tutorial and didn't realize it was just giving an example.

3.2 To configure the database, get at first your IP address by executing the command:

ifconfig

Note down your IP and open MariaDB again:

mysql -u mangos -p<password>

I figured out I need to put the database name after the password to select the auth database to go on to the next step. I apologize for the ignorance.

mysql -u mangos -pPASSWORD mangos_auth

 

[BreckAConner]

I've ran into a new problem trying to build MaNGOS.

Edited September 15, 2023 by BreckAConner

[BreckAConner]

With help on the MaNGOS discord, User $fyre helped with linking a issue that was brought up on up in general chat. I'm not sure what GCC is but I guess it's the incorrect version. Here's the code that was provided to me. This helped me finished the build. Fingers crossed that I have no more issues.

sudo apt install gcc-12 g++-12
sudo update-alternatives --install /usr/bin/gcc gcc /usr/bin/gcc-12 12
sudo update-alternatives --install /usr/bin/g++ g++ /usr/bin/g++-12 12