Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Linux Servers

Support::Linux Servers Support forum for Linux EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 06-14-2017, 02:02 PM
classiceq
Sarnak
 
Join Date: Jan 2008
Posts: 47
Default Installer Script/Mysql

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
Reply With Quote
  #2  
Old 06-14-2017, 04:36 PM
classiceq
Sarnak
 
Join Date: Jan 2008
Posts: 47
Default Error Message

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
Reply With Quote
  #3  
Old 06-14-2017, 04:39 PM
classiceq
Sarnak
 
Join Date: Jan 2008
Posts: 47
Default

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'
Reply With Quote
  #4  
Old 06-14-2017, 05:00 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,071
Default

Quote:
Originally Posted by classiceq View Post
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
Reply With Quote
  #5  
Old 06-14-2017, 05:26 PM
classiceq
Sarnak
 
Join Date: Jan 2008
Posts: 47
Default Username/passwords

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:
Reply With Quote
  #6  
Old 06-14-2017, 05:33 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,071
Default

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
Reply With Quote
  #7  
Old 06-14-2017, 05:37 PM
classiceq
Sarnak
 
Join Date: Jan 2008
Posts: 47
Default As Root

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/EQ...ler/install.sh -O install.sh && chmod 755 install.sh && ./install.sh
--2017-06-14 15:28:58-- https://raw.githubusercontent.com/EQ...ler/install.sh


That is all.

- ceq
Reply With Quote
  #8  
Old 06-14-2017, 05:37 PM
classiceq
Sarnak
 
Join Date: Jan 2008
Posts: 47
Default Thanks

Also, thanks for your reply/assistance.

- ceq
Reply With Quote
  #9  
Old 06-14-2017, 05:40 PM
classiceq
Sarnak
 
Join Date: Jan 2008
Posts: 47
Default

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
Reply With Quote
  #10  
Old 06-14-2017, 06:03 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,071
Default

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.
Reply With Quote
  #11  
Old 06-14-2017, 07:07 PM
classiceq
Sarnak
 
Join Date: Jan 2008
Posts: 47
Default Errors

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
Reply With Quote
  #12  
Old 06-14-2017, 07:32 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,071
Default

Just ran a fresh Debian install.

It all looks fine. Server started right up

https://dl.dropboxusercontent.com/u/...mu_install.txt
Reply With Quote
  #13  
Old 06-15-2017, 09:48 AM
classiceq
Sarnak
 
Join Date: Jan 2008
Posts: 47
Default Install

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

Thanks.

- ceq
Reply With Quote
  #14  
Old 06-15-2017, 03:47 PM
Turmoiltoad
Forum Guide
 
Join Date: Apr 2013
Posts: 27
Default

It may be helpful to share the bind address listed in your mysql config (my.cnf).
Reply With Quote
  #15  
Old 06-15-2017, 05:12 PM
classiceq
Sarnak
 
Join Date: Jan 2008
Posts: 47
Default Resolved

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

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

- ceq
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 03:09 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3