db outsourcing

Printable View

08-04-10
Hemer

db outsourcing

We outsourced our database to a outer server(xx.xx.xxx.xx)
What do we have to change to let the server notice that it's outsourced.

tablexml + ...

wich ip's have to be change at hosts?

Quote:

127.0.0.1 localhost
192.168.0.105 perfectworld

192.168.0.105 aumanager
192.168.0.105 manager
192.168.0.105 link1
192.168.0.105 game1
192.168.0.105 game2
192.168.0.105 game3
192.168.0.105 delivery
192.168.0.105 database
192.168.0.105 backup
192.168.0.105 auth
192.168.0.105 gmserver

thx
Hendrik
08-04-10
Hemer

Re: db outsourcing

have noone outsourced his db, or any part of the server, so far?
08-04-10
hrace009

Re: db outsourcing

do you mean MySQL database? or character database?

if it MySQL Database, i think you only need to change table.xml

and change at line 7

<connection name="auth0" poolsize="3" url="jdbc:mysql://127.0.0.1/dbo?useUnicode=true&characterEncoding=utf8" username="authd" password="nx02columbia"/>

try to change that ip to your MySQL IP out off your PW SERVER.

this is only my asumming, not sure it will work 100% coz i never try it.
08-04-10
Hemer

Re: db outsourcing

yeah, the mysql database is outsourced.
08-04-10
hrace009

Re: db outsourcing

don't forget to grant user Privileges of your remote user.
08-04-10
Hemer

Re: db outsourcing

you're right, that's always the thing i forget. Hope it's fixed now.
08-04-10
hrace009

Re: db outsourcing

oh yeah... i forget one thing....

fill the HOST at Login Information to your REMOTE IP:thumbup1:
08-04-10
Hemer

Re: db outsourcing

you jmean /etc/hosts?
08-04-10
hrace009

Re: db outsourcing

no... at the User Previlage MySQL...

it will ask you from where REMOTE Ip
08-04-10
Hemer

Re: db outsourcing

Oh, that. I know xd

---------- Post added at 08:34 PM ---------- Previous post was at 07:13 PM ----------

ok the problm is still the same.

////////////////////////////
Gameserver: 123.123.123.123
Loginserver: 444.444.444.444
(just for this example)
////////////////////////////

Xampp Startup:

Quote:

/opt/lampp/lampp restart

Stoppe XAMPP fuer Linux 1.7.3a...
XAMPP: Stoppe Apache mit SSL...
XAMPP: Stoppe MySQL...
XAMPP: Stoppe ProFTPD...
XAMPP beendet.

Starte XAMPP fuer Linux 1.7.3a...
XAMPP: Starte Apache mit SSL (und PHP5)...
XAMPP: Starte MySQL...
XAMPP: Starte ProFTPD...
XAMPP fuer Linux gestartet.

Table-XML settings:

Quote:

<driver name="com.mysql.jdbc.Driver" />
<connection name="auth0" poolsize="3" url="jdbc:mysql://444.444.444.444/dbo?useUnicode=true&characterEncoding=utf8" username="root" password="root"/>

Conection of Gameserver at Loginserver permission:
http://i39.tinypic.com/8xviiq.jpg

After the registration of a new account:

Quote:

Deprecated: Function ereg() is deprecated in /opt/lampp/htdocs/register/index.php on line 36

Deprecated: Function ereg() is deprecated in /opt/lampp/htdocs/register/index.php on line 41

Deprecated: Function ereg() is deprecated in /opt/lampp/htdocs/register/index.php on line 46
Can't execute query.
08-04-10
hrace009

Re: db outsourcing

check at your config.php

Spoiler:

<?php

/*-------Config MySQL Database-------*/

$DB_Host = "444.444.444.444"; // localhost or your IP
$DB_User = "user"; // Database user
$DB_Password = "password"; // Database password
$DB_Name = "dbo"; // Database name

$ServerIP = "123.123.123.123"; // IP your PW Server or 127.0.0.1
$ServerPort = "29000"; // Port your PW Server

$db_link = mysql_connect($DB_Host, $DB_User, $DB_Password);
$db = mysql_select_db("$DB_Name", $db_link);

// security check for http_get variables to prevent injections
foreach ($_GET as $key => $value)
{
$_GET[$key] = mysql_real_escape_string($value, $db_link);
}
// security check for http_get variables to prevent injections
foreach ($_POST as $key => $value)
{
$_POST[$key] = mysql_real_escape_string($value, $db_link);
}
?>
08-04-10
Hemer

Re: db outsourcing

that's all right.
We also tried with another loginserver.
That login server haven't got problems with db,
but the gameserver still can't connect to the loginserver.

matrix password error at the server and
"Error in Server and Network" at the client.

there must be other files to be changed.
09-04-10
hrace009

Re: db outsourcing

try to change at the /etc/hosts

Spoiler:

# For loopbacking.
127.0.0.1 localhost
123.123.123.123 server-hemer

444.444.444.444 aumanager
444.444.444.444 manager
123.123.123.123 link1
123.123.123.123 game1
123.123.123.123 game2
123.123.123.123 game3
123.123.123.123 delivery
123.123.123.123 database
123.123.123.123 backup
444.444.444.444 auth
123.123.123.123 gmserver

# End of hosts.

try to change one of it. or the ip at /etc/authd.conf

i wan to try it, but i don't have other PC...
09-04-10
Romulan

Re: db outsourcing

Quote:

Deprecated: Function ereg() is deprecated in /opt/lampp/htdocs/register/index.php on line 36

Deprecated: Function ereg() is deprecated in /opt/lampp/htdocs/register/index.php on line 41

Deprecated: Function ereg() is deprecated in /opt/lampp/htdocs/register/index.php on line 46
Can't execute query.

OH ! It's a little error but the account is created xD don't panic !

Look at your MySQL db and check if the account is successfuly created and check if you can connect with it ingame !

@hrace009
You can make this test between to VirtualBox :ott1:
09-04-10
hrace009

Re: db outsourcing

Quote:

Originally Posted by Romulan

OH ! It's a little error but the account is created xD don't panic !

Look at your MySQL db and check if the account is successfuly created and check if you can connect with it ingame !

@hrace009
You can make this test between to VirtualBox :ott1:

oh yeah i forget one think...

if you use lampp, look at /opt/lampp/etc/php.ini
search in line 516 change the error reporting to be like this = error_reporting = E_ALL & ~E_NOTICE

i XD i got that warning before :ott1:

@Romulan: yes i try it betwen my LAMPP linux VBOX and XAMPP Windust... but i got diferent version of MySQL.:lol:

at Linux i use LAMPP 1.7.3 and this is with newest MySQL, and at Windust XAMPP 1.6.XXXX with the realy oldest MySQL :P: and i got error when importing dbo, it say wrong version number of MySQL need to update it, and my dorm admin now only give web proxy to Internet, and limit download to 1MB xD, so i can't download new XAMPP XD.
09-04-10
Romulan

Re: db outsourcing

Put this URL in your bookmarks :ott1:

http://sourceforge.net/projects/xampp/files/

It will be useful for you later ^^

This is the full list of files made by the apachefriend community

Becareful between the "normal" and the "lite" version of XAMPP ! :wink:
09-04-10
Hemer

Re: db outsourcing

Quote:

Originally Posted by Romulan

OH ! It's a little error but the account is created xD don't panic !

Look at your MySQL db and check if the account is successfuly created and check if you can connect with it ingame !

I have two problems:

1. The registerproblem(I had that often that the errot doeasn't matter and the account will be created, but this time it doeasn't.

2. When I go ingame to login I get that error "Error in server and Network"
If I'm right that's because of a bad request from the gameserver at the outsourced loginserver.

*(The Xampp configuration at problem1 are totaly corect)
09-04-10
hrace009

Re: db outsourcing

Quote:

Originally Posted by Romulan

Put this URL in your bookmarks :ott1:

http://sourceforge.net/projects/xampp/files/

It will be useful for you later ^^

This is the full list of files made by the apachefriend community

Becareful between the "normal" and the "lite" version of XAMPP ! :wink:

wow thx...

Quote:

Originally Posted by Hemer

I have two problems:

1. The registerproblem(I had that often that the errot doeasn't matter and the account will be created, but this time it doeasn't.

2. When I go ingame to login I get that error "Error in server and Network"
If I'm right that's because of a bad request from the gameserver at the outsourced loginserver.

*(The Xampp configuration at problem1 are totaly corect)

Hemer try to check your IP at /etc/auth.conf, change the IP to your MySQL server IP. or at /etc/hosts. i think that problem came's for auth thing....:blushing:
09-04-10
rbb138

Re: db outsourcing

honestly i tried this for mssql in JD and it was a bloody nightmare.
10-04-10
Hemer

Re: db outsourcing

you tried or you did it?^^
13-04-10
hrace009

Re: db outsourcing

Hemmer i found it.. :ott1:

just leave all you IP, you just need to change IP at table.xml and GMserver.conf at etc folder, change those IP to your MySQL IP. but it will slowdown you MySQL Connection, but not to slow.:blush:
13-04-10
Hemer

Re: db outsourcing

Thank you verry much I'll try that. Thanks for your work at this thread!!!