MySQL Problem.

[SampleText]

I'm trying to set up a mysql database for my friends sourcebans server but the page seems to not let me excute.

I tick this:
[img]http://gyazo.com/b33da217d8f6091573ad8f28f8a251da.png[/img]
and then when my friend executes it, it doesn't let him execute it. It simply gives him this

Unknown MySQL server host 'jack-attack.net ' (1)

SQL Query type: CONNECT
Script: '/orangebox/Sourcebans/install/index.php'
SQL Query: jack-attack.net 
SQL Params: jackatta_sqlsb

So I go back to see what's wrong and I find this unticked.
[img]http://gyazo.com/05725ed0385e217c8bd21eac25ba1f34.png[/img]
How can I fix this?

[^seth]

You have a space after the hostname

[SampleText]

Can't connect to MySQL server on 'www.jack-attack.net' (4)

SQL Query type: CONNECT
Script: '/orangebox/Sourcebans/install/index.php'
SQL Query: [url]www.jack-attack.net[/url]
SQL Params: jackatta_sqlsb

[editline]15th January 2011[/editline]

Does nothing

[^seth]

Try 'localhost'

[compwhizii]

Ask your host what to set as the host for the MySQL server.

[SampleText]

[QUOTE=compwhizii;27443826]Ask your host what to set as the host for the MySQL server.[/QUOTE]

I am the host

I think

[Encryption]

Is the gameserver hosted on the same box as the webserver?

[SampleText]

No

[Qombat]

Then it'll be localhost.

[editline]16th January 2011[/editline]

Disregard that.

[^seth]

If you're connecting from another server, have you added that server's IP to the "Allowed hosts" in your cPanel?

[compwhizii]

[QUOTE=LinuX;27443834]I am the host

I think[/QUOTE]

Who are you paying to host the website and what kind of service is it?

[editline]15th January 2011[/editline]

[QUOTE=^seth;27443872]If you're connecting from another server, have you added that server's IP to the "Allowed hosts" in your cPanel?[/QUOTE]

He's installing the panel

[Encryption]

[QUOTE=compwhizii;27443885]Who are you paying to host the website and what kind of service is it?

[editline]15th January 2011[/editline]

He's installing the panel[/QUOTE]

Whiz, sourcebans and cpanel are different panels...

[compwhizii]

[QUOTE=Encryption;27443931]Whiz, sourcebans and cpanel are different panels...[/QUOTE]

I'm talking about LinuX is installing the sourcebans web interface

[SampleText]

[QUOTE=^seth;27443872]If you're connecting from another server, have you added that server's IP to the "Allowed hosts" in your cPanel?[/QUOTE]

How do I do that

[compwhizii]

[QUOTE=LinuX;27443956]How do I do that[/QUOTE]

But hold on before you do that, where are you installing the sourcebans web interface and where is the MySQL server being hosted

[editline]15th January 2011[/editline]

Are they from the same place?

[SampleText]

The my SQL server is on Xenonservers, and the sourcebans interface is on [url]http://3quarteraiming.com/[/url]

[editline]15th January 2011[/editline]

[QUOTE=compwhizii;27443953]I'm talking about A member that is permabanned right after he got GM is installing the sourcebans web interface[/QUOTE]

He is, not me.

[^seth]

Add 216.22.26.29 to allowed hosts.

[compwhizii]

I'm helping via steam now.

[^seth]

It's "Remote MySQL" under the "Databases" category.

[editline]16th January 2011[/editline]

:ninja:

[deadeye536]

[QUOTE=^seth;27444464]Add 216.22.26.29 to allowed hosts.[/QUOTE]

The SQL database is open for access from anyone. Tried a connection from my PC to jack-attack.net using HeidiSQL, and I hit MySQL (although I had no authorization).

[compwhizii]

We opened it for anyone, but the second host was blocking from accessing MySQL so now we're setting up on the same server

[SampleText]

We did it
[url]http://www.jack-attack.net/sourcebans/[/url]