Solved Prism

[cjm721]

Side note love x2go.

Ok so for prisim your going to need to give the IP of the data base and on the database server have to make sure the communication is going to the correct machine as I have no idea what kind of setup you have. But if your able to connect to the database from your computer should have no trouble to connect from the MC server.

 

[Connor Gavitt]

Still a bit of a noob at web hosting stuff, do you want the ip of the database? Would that be the website url?

 

[cjm721]

same as you connect to it normaly. And I don't need it your MC server plugin needs it.

 

[Connor Gavitt]

I only have ssh on my mc server I use my cpanel for my web host since they do not allow ssh access. That is why I though the ip was the url which I'm guessing is not the ip.

 

[cjm721]

Hum it might be or it might not be. Use the url of your website as the url for prism.

 

[Connor Gavitt]

This is what i'm using for the prism config, it still refuses to connect.

mysql:
hostname: mrmancraft.com
username: hidden
password: hidden
database: mrmancra_prism
port: '3306'

 

[cjm721]

Ok that port might be firewalled on your website. I have never used your CP i am betting (I never pay to have one) but your going to need to figgure out how to port forward on it. Might just have to call your CS if they dont give you some SSH or other form of access.


Side note isn't ultimate version 1.1.2 not version 1.2.1? < from your server link.

Also do you have teamspeak (just client dont need server)

 

[Connor Gavitt]

Thanks for pointing out that typo i'll change it, and yes I do have teamspeak i'll check the port to see if it is fire walled.

 

[Steakbroetchen]

I have Problems with Prism, too.

Both, the FTB Lite Server and the mysql-Database are on the same host (Debian 7)
Without Prism the server is working without problems.
mysql Settings of Prism:

  mysql:
    hostname: 127.0.0.1
    username: root
    password: sql
    database: ftb
    port: '3306'

mysql is working, the database ftb exists.

server.log: http://pastebin.com/yW3rF0ic

 

[Connor Gavitt]

Well do you have a mysqld database? what is it's name?

1. 2013-10-28 15:33:53 [INFO] [Prism]: --------------------- ## Important ## ---------------------
2. 2013-10-28 15:33:53 [INFO] [Prism]: Prism will disable itself because it couldn't connect to a database.
3. 2013-10-28 15:33:53 [INFO] [Prism]: If you're using MySQL, check your config. Be sure MySQL is running.
4. 2013-10-28 15:33:53 [INFO] [Prism]: For help - try http://discover-prism.com/wiki/view/troubleshooting/
5. 2013-10-28 15:33:53 [INFO] [Prism]: --------------------- ## ========= ## ---------------------

 

[Steakbroetchen]

Yeah, I've read and wondered about that, as I've written, mysql is working and the DB ftb exist.

I think the problem is locatet at this Point:

2013-10-28 15:33:53 [INFO] Database connection failed. Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
2013-10-28 15:33:53 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

This is way before Prism warn that it can't connect to the DB
But I have no Idea why this happens and how to fix it.

 

[Connor Gavitt]

Does mysqld allow connections from non-root users? Does that user have perms for mysql? Prism can't connect to the database still. Is there already a table on that database? Does prism show red on the /plugins list?

 

[Steakbroetchen]

After reinstalling the whole server caused by a problem it works as it should, but I have no idea why it works now, I've used the same configs as the first time.
But thanks for the help