[Problem]Homepage error!

[HDesign]

hi ,
i installed homepage script
and i go to
(the website)

and this problem



can you fix this problem ?

[.Tobias]

Can you maybee show us the Code on Line 16 ?

[HDesign]

yes

[Descended.]

Is the IP adress : 25.127.15.131
Right ?

[HDesign]

yes

[Spartan#117]

The IP address should be wrapped with ' ' or " " Tags, cause it's a string. (same for user, password and every other string)

Replace lines 15 and 16 with this:

PHP Code:

$sqlHp = mysql_connect('localhost', 'root', '1234')
$sqlServ = mysql_connect('25.127.15.131', 'db_manage', 'signe') 


[HDesign]

not fixed

[Spartan#117]

A little more information would be helpful.

What error appears now? The error you had should be fixed with my code above.

[HDesign]

[Spartan#117]

Try replacing line 15 and 16 with this code:

PHP Code:

$sqlHp = mysql_connect('localhost', 'root', '1234');
$sqlServ = mysql_connect('25.127.15.131', 'db_manage', 'signe'); 


I forgot the semicolon at the end of each line, sorry.

[HDesign]

fixed
but new problem

[Spartan#117]

Your MySQL user is not allowed to connect to the gameserver database. That is normal, because the gameserver user is only allowed to connect from localhost.

In my opinion this is the best way to solve this problem:

Create a new mysql user on the gameserver database and allow connections from every host.
Run these querys on the gameserver database:
Warning: Replace USERNAME and PASSWORD with your new username and password and make sure that you use a strong password!

CREATE USER 'USERNAME'@'%' IDENTIFIED BY 'PASSWORD';

Give the rights to the user:
Again, replace USERNAME with your created user

GRANT ALL ON account.* TO 'USERNAME'@'%';
GRANT ALL ON common.* TO 'USERNAME'@'%';
GRANT ALL ON hotbackup.* TO 'USERNAME'@'%';
GRANT ALL ON log.* TO 'USERNAME'@'%';
GRANT ALL ON player.* TO 'USERNAME'@'%';

Reload the privileges:

FLUSH PRIVILEGES;

Replace the username and password of the gameserver-connection in your website on line 16:

PHP Code:

$sqlServ = mysql_connect('25.127.15.131', 'USERNAME', 'PASSWORD'); 


[HDesign]

i can't type @


why

[Spartan#117]

Where are you typing those Querys? They should be executed in Navicat or another SQL-Client.

[HDesign]

where can i type this ?
i type in console (BSD)