PEQ editor installation error

[joedit]

Hi guys, thanks again for the work in developing and operating this site.

I am having issues with installing PEQ editor. I have a fresh server install on ubuntu, running on a VPS instance at a hosting provider. The game play seems to be running fine - I am able to connect to the server, set myself as the GM, run around in different zones, etc.

I tried to follow the steps in the install guide to install PEQ editor and am stuck at the first step - "sudo apt install mysql-server"

The installation failed to complete and entered into a Frozen state, and the message is:

--BEGIN--
This MySQL or variant installation has entered "frozen mode". Maintainer
scripts will avoid making changes or starting the daemon until manually
released from this state. See /usr/share/doc/mysql-common/README for
general information about this mode.

In this particular case, an incompatible downgrade attempt has been
detected. This can be resolved in one of two ways:

1. Change the contents of /var/lib/mysql/ to contain database data that
is compatible with the currently installed MySQL or variant daemon
version. For example: you could restore from a backup. Alternatively you
could do a dump using a future version binary and then a restore using
the current version binary.

2. Switch to a MySQL or variant daemon version that is compatible with
the data currently in /var/lib/mysql/. For example, if you have
attempted a downgrade from mysql-server-5.7 to mysql-server-5.6, you
could "apt install mysql-server-5.7" again.

Please resolve this situation and only then remove the /etc/mysql/FROZEN
symlink. You can then run "dpkg-reconfigure <package>" where <package>
should usually be in the form <variant>-server-<version>.

--END--

I am not a developer nor a database person and have very limited skills in these areas....I believe it is saying the Eqemu database content is an older version that is somehow not compatible with the mysql server I am installing? I tried downloading with a v5.6 but it was not available.

Any help would be appreciated.

Thanks.

[joligario]

You only need to install a MySQL server if you don’t already have one installed. Not really good instructions. Where are these instructions?

[joedit]

Thanks joligario. I think MySQL is already installed as part of the server installation, right?

Sorry for the noob question - I tried that as well and skipped to the next instruction, which is to change the bind-address in /etc/mysql/mysql.cnf, but that file seems to be empty @.@. I added the line to bind the address but unfortunately that didnt work neither.

I was trying to follow the instructions from the from the main site: https://eqemu.gitbook.io/server/categories/installation/install-peq-database-editor

[joligario]

Yeah, it does say that some items may have been enabled. It should also maybe say "installed". Don't worry about anything with MySQL other than to source in the schema later down the line. You should skip down to the HTTP and PHP sections. If those are already installed and enabled, follow the next steps.

[joedit]

Thank you again - I followed your advice and after some trial and error, I finally got it installed.

Thanks!!