Installer Script/Mysql

[classiceq]

I tried the installer script on a couple different versions of Linux. CentOS 6/7 and Debian 8.8. On all three they error on the same place. Logging into mysql and creating the database. At first I thought maybe it was the cantankerous version of CentOS. Then I read Debian was preferred. I ran the script and answered the questions. It acts as tho it doesn't save the value when asked. I am going to take another pass at it and post the error. It is likely I missed something but after 3 passes I don't know what it is. Any suggestions would be appreciated.

- ceq

[classiceq]

Here is the error.

ERROR 1396 (HY000) at line 1: Operation CREATE USER failed for 'root'@'localhost'

I can see the script install mysql/mariadb. Not sure what is wrong.

- ceq

[classiceq]

More specifically:

170614 15:36:13 [Note] /usr/sbin/mysqld (mysqld 10.0.30-MariaDB-0+deb8u2) starting as process 29551 ...
Setting up libhtml-template-perl (2.95-1) ...
Setting up mariadb-server (10.0.30-0+deb8u2) ...
Processing triggers for libc-bin (2.19-18+deb8u9) ...
Processing triggers for systemd (215-17+deb8u7) ...
ERROR 1396 (HY000) at line 1: Operation CREATE USER failed for 'root'@'localhost'

----

ERROR 1396 (HY000) at line 1: Operation CREATE USER failed for 'root'@'localhost'

[Akkadius]

I tried the installer script on a couple different versions of Linux. CentOS 6/7 and Debian 8.8. On all three they error on the same place. Logging into mysql and creating the database. At first I thought maybe it was the cantankerous version of CentOS. Then I read Debian was preferred. I ran the script and answered the questions. It acts as tho it doesn't save the value when asked. I am going to take another pass at it and post the error. It is likely I missed something but after 3 passes I don't know what it is. Any suggestions would be appreciated.

- ceq

You need to fill out all of the information in the beginning (Usernames/passwords) before continuing on with the rest of the script

[classiceq]

Are you referring to these fields? If so, I did fill in each accordingly.

Enter new UNIX password:
Retype new UNIX password:
Enter MySQL root (Database) password:
Enter Database Name (single word, no special characters, lower case):
Enter (Database) MySQL EQEmu Server username:
Enter (Database) MySQL EQEmu Server password:

[Akkadius]

As long as you did so as instructed, the installer shouldn't have an issue. We've ran through it many times. Make sure you run it as root

[classiceq]

I have no doubt it works correctly. I am just missing something. I installed debian from scratch and updated. Installed GCC-4.9 and ran this:

root@debian:~# wget --no-check-certificate https://raw.githubusercontent.com/EQEmu/Server/master/utils/scripts/linux_installer/install.sh -O install.sh && chmod 755 install.sh && ./install.sh
--2017-06-14 15:28:58-- https://raw.githubusercontent.com/EQEmu/Server/master/utils/scripts/linux_installer/install.sh


That is all.

- ceq

[classiceq]

Also, thanks for your reply/assistance.

- ceq

[classiceq]

Mysql was not installed prior to running the script. The script did install and start the service. I can log in with the credentials I used during the script set up. Hence my confusion.

- ceq

[Akkadius]

Well if you ran the script a few times of course you're going to see errors because its doing things it already did once.

[classiceq]

Thanks for the reply. I understand the process which is why I run it from a fresh build. The error I get is on the first run. The database is never created as you can see by the error.

- ceq

[Akkadius]

Just ran a fresh Debian install.

It all looks fine. Server started right up

https://dl.dropboxusercontent.com/u/50023467/dl/eqemu_install.txt

[classiceq]

I will give it another go on a fresh install and post the results.

Thanks.

- ceq

[Turmoiltoad]

It may be helpful to share the bind address listed in your mysql config (my.cnf).

[classiceq]

This is a good one. Stop me if you heard it.

I enabled IMCP on our firewall and it worked like a charm.

- ceq