Forwarded conversation
Subject: MySQL Server Wont install and start right
------------------------

From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 1:02 PM
To: royxu@servercraft.co


can you help me installing this mysql or sqlite please. ive been at it for hours and it keeps saying failed to start mysql server

----------
From: Roy Xu <royxu@servercraft.co>
Date: Thu, Feb 18, 2016 at 1:09 PM
To: seething word <seethingword@gmail.com>


Hi,

Did you run:
yum install mysql-server
/sbin/service mysqld start

Or what process did you use to install it?

Regards,

Roy

----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 1:15 PM
To: Roy Xu <royxu@servercraft.co>


​​
[root@4-30-111-137 ~]# /sbin/service mysqld start
MySQL Daemon failed to start.
Starting mysqld:                                           [FAILED]

----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 1:16 PM
To: Roy Xu <royxu@servercraft.co>


i used the same way you just suggested. ive uninstalled and installed it like 10 times and it still says that


----------
From: Roy Xu <royxu@servercraft.co>
Date: Thu, Feb 18, 2016 at 1:35 PM
To: seething word <seethingword@gmail.com>


This could be caused by a number of conflicts.  What other applications have you installed so far?


----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 1:35 PM
To: Roy Xu <royxu@servercraft.co>


multicraft and mymcadmin from what i remember. is there any way you can get it to work?


----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 2:05 PM
To: Roy Xu <royxu@servercraft.co>


were you able to get the MySQL going?


----------
From: Roy Xu <royxu@servercraft.co>
Date: Thu, Feb 18, 2016 at 2:05 PM
To: seething word <seethingword@gmail.com>


Are you alternating accessing the server and installing applications on the root and SC account?  It looks like what happened is you've installed applications under different users, and the shared libraries have permissions issues.  At this point, it would probably be easier to reinstall the OS.  Let me know if you want me to do this.

Regards,

Roy

----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 2:07 PM
To: Roy Xu <royxu@servercraft.co>


if you reinstall the OS, are you able to get the multicraft set back up under free license?


----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 2:09 PM
To: Roy Xu <royxu@servercraft.co>


cause it literally took me like 12 hours to get this far

----------
From: Roy Xu <royxu@servercraft.co>
Date: Thu, Feb 18, 2016 at 2:24 PM
To: seething word <seethingword@gmail.com>


We generally don't offer software support, because it's nearly impossible for us to know what's been done on the server before we step in.  If I install software, you also won't know what procedures I used, and could cause conflicts later.  For now, I'll look into the daemon error.

Regards,

Roy

----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 2:25 PM
To: Roy Xu <royxu@servercraft.co>


ok if neccesary, reinstall but try to get it workin please

----------
From: Roy Xu <royxu@servercraft.co>
Date: Thu, Feb 18, 2016 at 2:25 PM
To: seething word <seethingword@gmail.com>


We host Minecraft with MCMA, but looking over multicraft, it looks like you were supposed to install and run the sql db first.  Was this the order you did it in?

----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 2:26 PM
To: Roy Xu <royxu@servercraft.co>


MCMA? and ya i think i did

----------
From: Roy Xu <royxu@servercraft.co>
Date: Thu, Feb 18, 2016 at 2:42 PM
To: seething word <seethingword@gmail.com>


McMyAdmin, but you would likely need an enterprise license to use this.

Regards,

Roy

----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 2:43 PM
To: Roy Xu <royxu@servercraft.co>


​are the different programs installed under different users?
​

----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 2:44 PM
To: Roy Xu <royxu@servercraft.co>


​how much is that for 5 servers?​

----------
From: Roy Xu <royxu@servercraft.co>
Date: Thu, Feb 18, 2016 at 2:47 PM
To: seething word <seethingword@gmail.com>


This is their full pricing model:

https://www.mcmyadmin.com/#/editions

It would probably be on the expensive end for what you are trying to set up.  I'm going to go ahead and reinstall the OS.

Regards,

Roy

----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 2:48 PM
To: Roy Xu <royxu@servercraft.co>


k


----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 3:02 PM
To: Roy Xu <royxu@servercraft.co>


your reinstalling the OS right now?


----------
From: Roy Xu <royxu@servercraft.co>
Date: Thu, Feb 18, 2016 at 3:11 PM
To: seething word <seethingword@gmail.com>


Yes, the server is unreachable during the installation.  It should be done in about 5 minutes.

Regards,

Roy

----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 3:20 PM
To: Roy Xu <royxu@servercraft.co>


ok well i just bought a multicraft license for 5 servers to fit the 5 IP's that come with the dedicated server but i do not know how to set them to the separate IP's


----------
From: Roy Xu <royxu@servercraft.co>
Date: Thu, Feb 18, 2016 at 3:21 PM
To: seething word <seethingword@gmail.com>


Hi,

Each instance will have a McMyAdmin.conf file, here you can set the IP address etc of the server.  I've completed the server reinstall and included a desktop.  I have NOT yet installed the VNC viewer, as this may affect other things you are doing.  I would recommend first getting the sql server and any other base applications you need first.  This can all be done via SSH as root.

Regards,

Roy

----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 3:23 PM
To: Roy Xu <royxu@servercraft.co>


ok im logged in as root
is there any way you can help me through this or provide me a link on how to install the mysql just to make sure i dont mess up again?

----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 3:26 PM
To: Roy Xu <royxu@servercraft.co>


also do i have to install apache?


----------
From: Roy Xu <royxu@servercraft.co>
Date: Thu, Feb 18, 2016 at 3:37 PM
To: seething word <seethingword@gmail.com>


Do the sql install first, and it should work fine:

yum install mysql-server
/sbin/service/mysqld start

I'm not sure if you'll need apache, but it's an easy install through yum as well.

----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 3:42 PM
To: Roy Xu <royxu@servercraft.co>


i got an error trying to start the httpd service after installing mysql and multicraft;

[root@4-30-111-137 multicraft]# service httpd start
Starting httpd: httpd: Could not open configuration file /etc/httpd/conf/httpd.conf: Permission denied
                                                           [FAILED]

----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 3:44 PM
To: Roy Xu <royxu@servercraft.co>


nevermind


----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 3:46 PM
To: Roy Xu <royxu@servercraft.co>


I need to do this:

At last we also have to open HTTP and Minecraft ports in our firewall. That is if your system uses FirewallD - our VPS products don't have that by default, so if you use one of those you don't have to run the below commands.

firewall-cmd --permanent --zone=public --add-port=80/tcp
firewall-cmd --permanent --zone=public --add-port=25565/tcp
firewall-cmd --reload
But it says firewall-cmd: command not found

----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 4:12 PM
To: Roy Xu <royxu@servercraft.co>


omg its doing it again

----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 4:14 PM
To: Roy Xu <royxu@servercraft.co>


https://gyazo.com/088ad9ce05451e1500d605ce30d822cc

----------
From: Roy Xu <royxu@servercraft.co>
Date: Thu, Feb 18, 2016 at 4:15 PM
To: seething word <seethingword@gmail.com>


Is it failing to start the sql server again?

----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 4:16 PM
To: Roy Xu <royxu@servercraft.co>


no the sql server is started and running
but the multicraft panel is saying it cant connect


----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 4:17 PM
To: Roy Xu <royxu@servercraft.co>


[root@4-30-111-137 ~]# /etc/init.d/httpd restart
Stopping httpd:                                            [  OK  ]
Starting httpd:                                            [  OK  ]
[root@4-30-111-137 ~]# service mysqld restart
Stopping mysqld:                                           [  OK  ]
Starting mysqld:                                           [  OK  ]

----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 4:25 PM
To: Roy Xu <royxu@servercraft.co>


where is the mysql installed?

----------
From: Roy Xu <royxu@servercraft.co>
Date: Thu, Feb 18, 2016 at 4:30 PM
To: seething word <seethingword@gmail.com>


I believe the default sql directory is /etc/mysql  What issue are you having on the server right now?

----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 4:32 PM
To: Roy Xu <royxu@servercraft.co>


i cant connect multicraft to the mysql database


----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 4:43 PM
To: Roy Xu <royxu@servercraft.co>


can you figure this out? im literally out of ideas

----------
From: Roy Xu <royxu@servercraft.co>
Date: Thu, Feb 18, 2016 at 4:43 PM
To: seething word <seethingword@gmail.com>


Did you create the database in mysql?

----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 4:44 PM
To: Roy Xu <royxu@servercraft.co>


i used mysql to create the database yes
but its not wanting to connect

----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 4:45 PM
To: Roy Xu <royxu@servercraft.co>


and when i try to do the sqlite database, it says this
Error 500
Undefined index: dbUser


----------
From: Roy Xu <royxu@servercraft.co>
Date: Thu, Feb 18, 2016 at 4:46 PM
To: seething word <seethingword@gmail.com>


You shouldn't have installed sqlite with mysql, this is redundant.

----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 4:48 PM
To: Roy Xu <royxu@servercraft.co>


sqlite was already installed
do i remove it?

----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 4:51 PM
To: Roy Xu <royxu@servercraft.co>


is there a way i can set up mysql without using console? like through tightvnc

----------
From: Roy Xu <royxu@servercraft.co>
Date: Thu, Feb 18, 2016 at 4:52 PM
To: seething word <seethingword@gmail.com>


No, just don't run the sqlite server.  All of the mysql commands are input through the console.

----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 4:53 PM
To: Roy Xu <royxu@servercraft.co>


is there a way to reset the mysql and make a new database?

----------
From: Roy Xu <royxu@servercraft.co>
Date: Thu, Feb 18, 2016 at 4:58 PM
To: seething word <seethingword@gmail.com>


Are you using a guide?  If so, let me know what steps you did with SQL.

----------
From: Roy Xu <royxu@servercraft.co>
Date: Thu, Feb 18, 2016 at 4:59 PM
To: seething word <seethingword@gmail.com>


I just looked at your error again.  Are you sure you have the user / permissions setup correctly for multricraft to access the DB?


----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 4:59 PM
To: Roy Xu <royxu@servercraft.co>


yes hold on ill get you the guides i used
https://shadyshosting.com/billing/knowledgebase/31/How-to-Install-Multicraft-on-Centos-6-64bit.html

----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 5:00 PM
To: Roy Xu <royxu@servercraft.co>


thats why i was wondering if i can reset the database completely and make a new one with a new password and everything

----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 5:01 PM
To: Roy Xu <royxu@servercraft.co>


https://javapipe.com/multicraft-control-panel this guide too

----------
From: Roy Xu <royxu@servercraft.co>
Date: Thu, Feb 18, 2016 at 5:04 PM
To: seething word <seethingword@gmail.com>


You can drop the entire DB from the mysql console and create a new one.

----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 5:06 PM
To: Roy Xu <royxu@servercraft.co>


Failed to connect: Failed to connect to the database.
The error message is: CDbConnection failed to open the DB connection: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: YES)

----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 5:07 PM
To: Roy Xu <royxu@servercraft.co>


The error message is: CDbConnection failed to open the DB connection: SQLSTATE[42000] [1049] Unknown database 'multicraft_daemon'

----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 5:11 PM
To: Roy Xu <royxu@servercraft.co>


how?

----------
From: Roy Xu <royxu@servercraft.co>
Date: Thu, Feb 18, 2016 at 5:15 PM
To: seething word <seethingword@gmail.com>


http://dev.mysql.com/doc/refman/5.7/en/drop-database.html

----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 5:17 PM
To: Roy Xu <royxu@servercraft.co>


i dont understand


----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 5:19 PM
To: Roy Xu <royxu@servercraft.co>


what do i need to type in to remove the database? cause i dont know the name of it


----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 5:21 PM
To: Roy Xu <royxu@servercraft.co>


nevermind i got it


----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 5:46 PM
To: Roy Xu <royxu@servercraft.co>


well crap
now it wont even let me log into multicraft

----------
From: seething word <seethingword@gmail.com>
Date: Thu, Feb 18, 2016 at 5:49 PM
To: Roy Xu <royxu@servercraft.co>


FUCK! i think it needs another os reset -_- its messed up somehow. idk whats going on
please take a look at it and see if you can see anything

http://4.30.111.137/