Register for your free account! | Forgot your password?

Go Back   elitepvpers > Metin2 > Metin2 PServer - Discussions / Questions
You last visited: Today at 07:17

  • Please register to post and access all features, it's quick, easy and FREE!

 

Moving db out of virtual box problem

Reply
 
Old   #1
 
elite*gold: 0
Join Date: May 2009
Posts: 4
Received Thanks: 0
Moving db out of virtual box problem

Hey guys,

Have some problems with this. I'm trying to move the DB out of VirtualBOX to the actual PC(linux).
There are a couple of reasons for doing this. Mainly the PC is designated to be a game server, and i'd like to have only one VirtualBox started and only one MySQL on linux which handles all other metin2 databases.
So my config is
Linux PC - server MT2 1
- server MT2 2
....
I'll refer to the actual PC as linux.
This is my channel 1 config:
Quote:
HOSTNAME: channel1
CHANNEL: 1
PORT: 13000
P2P_PORT: 14000
DB_PORT: 3306
DB_ADDR: 192.168.1.50
MAP_ALLOW: 1 2 3 4 5 6 7 8 9 10 11 21 23 24 25 41 43 44 45 61 62 63 64 65 66 69 70 71 72 73 104 108 109 67 68 80 74 75 76 77 78 79 100 101 103 105 107 110 111 112 180 190 191 192 193 194 206
#MAP_ALLOW: 113 184 185 186 187 188 189 193 179
TABLE_POSTFIX:
PASSES_PER_SEC: 25
SAVE_EVENT_SECOND_CYCLE: 180
PING_EVENT_SECOND_CYCLE: 180
PLAYER_SQL: 192.168.1.50 mt2 [email protected]# player
COMMON_SQL: 192.168.1.50 mt2 [email protected]# common
LOG_SQL: 192.168.1.50 mt2 [email protected]# log
LOCALE_SERVICE: germany
#TEST_SERVER: 1
#NO_PK: 1
MALL_URL: google.de
adminpage_ip0: 192.168.1.20
admin_page_password: somepassword
VIEW_RANGE: 20000
CHECK_MULTIHACK: 1
Did i do it right? I have to mention i get NO errors when starting the server. The Linux MySQL is configured to allow the user mt2 from any host and no errors there either. But with all this, the client gets stuck after entering correct username and password. If i enter it wrong it tells me that "Wrong username or password".
Other questions i have
- "PORT" - is the channel's port which has to be forwarded from the router?
- What is "P2P_PORT" and does it also have to be forwarded ?
- Do i have to also forward the 3306 port ? Or that's only between the server and MySQL db ?
- How do i edit the db, game and auth files ? Only hex edit? Can't they be de-compiled ?

Please help me guys, this is driving me nuts.
Big THANKS!



anichillus is offline  
Old   #2
 
elite*gold: 0
Join Date: Apr 2011
Posts: 587
Received Thanks: 671
Well,
This settings are wrong!

PHP Code:
DB_PORT3306
DB_ADDR
192.168.1.50 
--

This settings are only for the db-cache on the metin server, not for the mysqlserver!
So the db_port value must set to 15000/15001 and the db_addr value must set to localhost, becouse the db-cache is running on the same system like the metin server.

PHP Code:
PLAYER_SQL192.168.1.50 mt2 mt2[email protected]# player
COMMON_SQL192.168.1.50 mt2 mt2[email protected]# common
LOG_SQL192.168.1.50 mt2 mt2[email protected]# log 
That seems to be right, i hope you created the user "[email protected]%" or "[email protected]" on your linux machine with the password "[email protected]#".


'aiiR7 is offline  
Old   #3
 
elite*gold: 0
Join Date: May 2009
Posts: 4
Received Thanks: 0
Quote:
Originally Posted by iceE' View Post
Well,
This settings are wrong!

PHP Code:
DB_PORT3306
DB_ADDR
192.168.1.50 
--

This settings are only for the db-cache on the metin server, not for the mysqlserver!
So the db_port value must set to 15000/15001 and the db_addr value must set to localhost, becouse the db-cache is running on the same system like the metin server.

PHP Code:
PLAYER_SQL192.168.1.50 mt2 mt2[email protected]# player
COMMON_SQL192.168.1.50 mt2 mt2[email protected]# common
LOG_SQL192.168.1.50 mt2 mt2[email protected]# log 
That seems to be right, i hope you created the user "[email protected]%" or "[email protected]" on your linux machine with the password "[email protected]#".
Thank you !, I'll try that now.
Yes, of course i created the user.
fingers crossed
anichillus is offline  
Old   #4
 
elite*gold: 0
Join Date: Apr 2011
Posts: 587
Received Thanks: 671
Quote:
Originally Posted by anichillus View Post
Thank you !, I'll try that now.
Yes, of course i created the user.
fingers crossed
If you have any problem about this, do not hesitate to contact me, i can help you.

--

PS: Which linux do you have? - CentOS, Debian, Ubuntu?


'aiiR7 is offline  
Thanks
1 User
Old   #5
 
elite*gold: 0
Join Date: May 2009
Posts: 4
Received Thanks: 0
Yes, it worked !
I have ubuntu. I thought about it and creating the user [email protected]% it's big security leak...anyone can connect to your db and change anything... so it'll be [email protected]_IP

I guess i only have one question left:
"- How do i edit the db, game and auth files ? Only hex edit? Can't they be de-compiled ?"
Thanks so much iceE' !
anichillus is offline  
Old   #6
 
elite*gold: 0
Join Date: Apr 2011
Posts: 587
Received Thanks: 671
Quote:
Originally Posted by anichillus View Post
Yes, it worked !
I have ubuntu. I thought about it and creating the user [email protected]% it's big security leak...anyone can connect to your db and change anything... so it'll be [email protected]_IP

I guess i only have one question left:
"- How do i edit the db, game and auth files ? Only hex edit? Can't they be de-compiled ?"
Thanks so much iceE' !
No problem, dude,
You can extract these files with upx, you can edit them with hex and ida.
'aiiR7 is offline  
Old   #7
 
elite*gold: 0
Join Date: May 2009
Posts: 4
Received Thanks: 0
Quote:
Originally Posted by iceE' View Post
No problem, dude,
You can extract these files with upx, you can edit them with hex and ida.
Thx, i tried with IDA, but caught my ears in it... don't know what to do. I was trying to convert it so it can be used in linux and thus eliminate the need to use a virtual box...i tried exporting it as .c and recompiling it under linux but failed. I guess we'll still use freebsd for now.
anichillus is offline  
Old   #8
 
elite*gold: 0
Join Date: Apr 2011
Posts: 587
Received Thanks: 671
Quote:
Originally Posted by anichillus View Post
Thx, i tried with IDA, but caught my ears in it... don't know what to do. I was trying to convert it so it can be used in linux and thus eliminate the need to use a virtual box...i tried exporting it as .c and recompiling it under linux but failed. I guess we'll still use freebsd for now.
I do not believe someone who says his server is running without problems on a linux system.
The server have to run on freebsd, otherwise the server will not start and give you much errors.


'aiiR7 is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
[PROBLEM] Microsoft Virtual PC 2007 [PROBLEM]
~vote 4 close ~fertig geregelt.
7 Replies - Metin2 PServer - Discussions / Questions
Virtual pc Problem
Hallo Com. Ich habe ein problem, und zwar habe ich bei virtual pc bei der network config die name server ip geändert und ich weis jetzt nicht wie...
9 Replies - Metin2 PServer - Discussions / Questions
Virtual PC PROBLEM...
hab hier ein riesen problem..mein server fährt hoch und wenn da am ende Operation timed out dran steht.. und der server gerade an ist geht...
1 Replies - Metin2 PServer - Discussions / Questions
Moving problem
hello everyone now , i had downloaded the new media.pk2 of Sjsro (old) and where i start to move there is a dilay between the clicking and where...
3 Replies - SRO PServer Ask the Experts
Virtual PC problem + kuk bot problem hilfe ^^
Ich check das nicht ich hab mir virtual pc geholt damit ich auf vp mein kuk bot laufen lassen kann und ich mit meinem anderen weiter normal zocken...
11 Replies - Diablo 2



All times are GMT +1. The time now is 07:17.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.