+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Guides & Help Section (https://lckb.dev/forum/forumdisplay.php?fid=193)
+---- Forum: Help & Support (https://lckb.dev/forum/forumdisplay.php?fid=157)
+----- Forum: Ep2 Support (https://lckb.dev/forum/forumdisplay.php?fid=166)
+------ Forum: Solved Topics (https://lckb.dev/forum/forumdisplay.php?fid=144)
+------ Thread: Can you please check my newStobm.bin Files for mistakes (/showthread.php?tid=1803)
Pages:
1
2
- Shozia - 04-07-2013
Im unable to run them at the moment!
Connector
[server]
Number=1
MaxSubServer=5
IP=my ip
Port=4006
[user DB]
IP=127.0.0.1
DBName=newproject_db_auth
User=spyce
Password=
[Auth DB]
IP=127.0.0.1
DBName=newproject_db_auth
User=spyce
Password=
[billing Server]
IP=my ip
Port=8888
[sHA256]
Salt=phoohie1yaihooyaequae7PuiWoeNgahjieth3ru3yeeghaepahb7aeYaipe2we6zii6mai6uweig8siasheinoungeoyeiLohShi2xoh2xi8ooxee9ahpiehahc9Phe
GameServer
[server]
Number=1
SubNumber=1
IP=my ip
Port=4001
AllowExternalIP=TRUE
[Data DB]
IP=127.0.0.1
DBName=newproject_data
User=spyce
Password=
IP=127.0.0.1
DBName=newproject_post
User=spyce
Password=
[user Server]
IP=my ip
Port=4102
[Char DB]
IP=127.0.0.1
DBName=newproject_db_auth
User=spyce
Password=
[Messenger Server]
IP=my ip
Port=4105
[Helper Server]
IP=my ip
Port=3000
[subHelper Server]
IP=my ip
Port=50401
[Connector Server]
IP=my ip
Port=4006
[Zones]
Count=36
[Zone_0]
No=0
Remote=FALSE
[Zone_1]
No=1
Remote=FALSE
[Zone_2]
No=2
Remote=FALSE
[Zone_3]
No=3
Remote=FALSE
[Zone_4]
No=4
Remote=FALSE
[Zone_5]
No=5
Remote=FALSE
[Zone_6]
No=6
Remote=FALSE
[Zone_7]
No=14
Remote=FALSE
[Zone_8]
No=7
Remote=FALSE
[Zone_9]
No=10
Remote=FALSE
[Zone_10]
No=9
Remote=FALSE
[Zone_11]
No=11
Remote=FALSE
[Zone_12]
No=12
Remote=FALSE
[Zone_13]
No=8
Remote=FALSE
[Zone_14]
No=15
Remote=FALSE
[Zone_15]
No=17
Remote=FALSE
[Zone_16]
No=18
Remote=FALSE
[Zone_17]
No=19
Remote=FALSE
[Zone_18]
No=20
Remote=FALSE
[Zone_19]
No=21
Remote=FALSE
[Zone_20]
No=22
Remote=FALSE
[Zone_21]
No=23
Remote=FALSE
[Zone_22]
No=25
Remote=FALSE
[Zone_23]
No=29
Remote=FALSE
[Zone_24]
No=30
Remote=FALSE
[Zone_25]
No=31
Remote=FALSE
[Zone_26]
No=24
Remote=FALSE
[Zone_27]
No=32
Remote=FALSE
[Zone_28]
No=33
Remote=FALSE
[Zone_29]
No=34
Remote=FALSE
[Zone_30]
No=35
Remote=FALSE
[Zone_31]
No=36
Remote=FALSE
[Zone_32]
No=37
Remote=FALSE
[Zone_33]
No=38
Remote=FALSE
[Zone_34]
No=39
Remote=FALSE
[Zone_35]
No=40
Remote=FALSE
Helper
[server]
Number=1
IP=my ip
Port=3000
[Char DB]
IP=my ip
DBName=newproject_db_auth
User=spyce
Password=
LoginServer
[server]
No=1
IP=my IP
Port=4001
AllowExternalIP=TRUE
[user DB]
IP=my IP
DBName=newproject_db_auth
User=spyce
Password=
[Data DB]
IP=my IP
DBName=newproject_data
User=spyce
Password=
[Auth DB]
IP=my IP
DBName=newproject_db_auth
User=spyce
Password=
[Messenger Server]
IP=my IP
Port=4105
[Connector Server]
Count=1
[Connector_0]
Number=1
MaxSubNumber=5
IP=my IP
Port=4006
[Auto Block]
Refresh=2
MaxTry=7
[sHA256]
Salt=phoohie1yaihooyaequae7PuiWoeNgahjieth3ru3yeeghaepahb7aeYaipe2we6zii6mai6uweig8siasheinoungeoyeiLohShi2xoh2xi8ooxee9ahpiehahc9Phe
Messenger
[server]
IP=myip
Port=4105
SubHelper
[server]
Number=1
IP=my ip
Port=50401
UserPort=4102
MAXSIZE=1000
[Char DB]
IP=my ip
DBName=newproject_db
User=spyce
Password=
IP=my ip
DBName=newproject_post
User=spyce
Password=
Databases are:
newproject_data
newproject_db
newproject_db_auth
newproject_post
Mysql Server is running, apache aswell
- halohalo - 04-07-2013
I would change the user name back to: "root" and check the config.ini files also. And check that in Navicat your db names are the same as in the server named (with no spelling mistakes). Have you disable the FireWall of user and user root and in the case of the gameserver, have you add the new libs necessary?
- dateone - 04-07-2013
Connector
[server]
Number=1
MaxSubServer=5
IP=my ip
Port=4006
[user DB]
IP=127.0.0.1
DBName=newproject_db_auth
User=spyce
Password=
[Auth DB]
IP=127.0.0.1
DBName=newproject_db_auth
User=spyce
Password=
[billing Server]
IP=127.0.0.1
Port=8888
[sHA256]
Salt=phoohie1yaihooyaequae7PuiWoeNgahjieth3ru3yeeghaepahb7aeYaipe2we6zii6mai6uweig8siasheinoungeoyeiLohShi2xoh2xi8ooxee9ahpiehahc9Phe
GameServer
[server]
Number=1
SubNumber=1
IP=my ip
Port=4001
AllowExternalIP=TRUE
[Data DB]
IP=127.0.0.1
DBName=newproject_data
User=spyce
Password=
IP=127.0.0.1
DBName=newproject_post
User=spyce
Password=
[user Server]
IP=127.0.0.1
Port=4102
[Char DB]
IP=127.0.0.1
DBName=newproject_db_auth
User=spyce
Password=
[Messenger Server]
IP=127.0.0.1
Port=4105
[Helper Server]
IP=127.0.0.1
Port=3000
[subHelper Server]
IP=127.0.0.1
Port=50401
[Connector Server]
IP=127.0.0.1
Port=4006
[Zones]
Count=36
[Zone_0]
No=0
Remote=FALSE
[Zone_1]
No=1
Remote=FALSE
[Zone_2]
No=2
Remote=FALSE
[Zone_3]
No=3
Remote=FALSE
[Zone_4]
No=4
Remote=FALSE
[Zone_5]
No=5
Remote=FALSE
[Zone_6]
No=6
Remote=FALSE
[Zone_7]
No=14
Remote=FALSE
[Zone_8]
No=7
Remote=FALSE
[Zone_9]
No=10
Remote=FALSE
[Zone_10]
No=9
Remote=FALSE
[Zone_11]
No=11
Remote=FALSE
[Zone_12]
No=12
Remote=FALSE
[Zone_13]
No=8
Remote=FALSE
[Zone_14]
No=15
Remote=FALSE
[Zone_15]
No=17
Remote=FALSE
[Zone_16]
No=18
Remote=FALSE
[Zone_17]
No=19
Remote=FALSE
[Zone_18]
No=20
Remote=FALSE
[Zone_19]
No=21
Remote=FALSE
[Zone_20]
No=22
Remote=FALSE
[Zone_21]
No=23
Remote=FALSE
[Zone_22]
No=25
Remote=FALSE
[Zone_23]
No=29
Remote=FALSE
[Zone_24]
No=30
Remote=FALSE
[Zone_25]
No=31
Remote=FALSE
[Zone_26]
No=24
Remote=FALSE
[Zone_27]
No=32
Remote=FALSE
[Zone_28]
No=33
Remote=FALSE
[Zone_29]
No=34
Remote=FALSE
[Zone_30]
No=35
Remote=FALSE
[Zone_31]
No=36
Remote=FALSE
[Zone_32]
No=37
Remote=FALSE
[Zone_33]
No=38
Remote=FALSE
[Zone_34]
No=39
Remote=FALSE
[Zone_35]
No=40
Remote=FALSE
Helper
[server]
Number=1
IP=127.0.0.1
Port=3000
[Char DB]
IP=127.0.0.1
DBName=newproject_db_auth
User=spyce
Password=
LoginServer
[server]
No=1
IP=my IP
Port=4001
AllowExternalIP=TRUE
[user DB]
IP=127.0.0.1
DBName=newproject_db_auth
User=spyce
Password=
[Data DB]
IP=127.0.0.1
DBName=newproject_data
User=spyce
Password=
[Auth DB]
IP=127.0.0.1
DBName=newproject_db_auth
User=spyce
Password=
[Messenger Server]
IP=127.0.0.1
Port=4105
[Connector Server]
Count=1
[Connector_0]
Number=1
MaxSubNumber=5
IP=127.0.0.1
Port=4006
[Auto Block]
Refresh=2
MaxTry=7
[sHA256]
Salt=phoohie1yaihooyaequae7PuiWoeNgahjieth3ru3yeeghaepahb7aeYaipe2we6zii6mai6uweig8siasheinoungeoyeiLohShi2xoh2xi8ooxee9ahpiehahc9Phe
Messenger
[server]
IP=127.0.0.1
Port=4105
SubHelper
[server]
Number=1
IP=127.0.0.1
Port=50401
UserPort=4102
MAXSIZE=1000
[Char DB]
IP=127.0.0.1
DBName=newproject_db
User=spyce
Password=
IP=127.0.0.1
DBName=newproject_post
User=spyce
Password=
You changed quite alot, unnecessarily.
E.g. your servers need to connect to the database, which is local.
Then, you shouldnt have changed the ports. Actually they are right, but they might not be open.
Also, make sure that you dont use a MySQL password! You havent specified any...
Open the servers in the right order:
Messenger
Helper
SubHelper
Connector
Loginserver
GameServer
Btw, a screen shot would be very helpful for the next time!
dateone
- Shozia - 04-07-2013
Thank you alot. I changed everything you told me but now nothing happens after the Messenger Server is running.
Here an image:
my run-file
#!/bin/sh
cd Messenger/Messenger
chmod 777 Messenger;
./Messenger start;
cd ../../;
cd Helper/Helper
chmod 777 Helper;
./Helper start ;
cd ../../;
cd SubHelper/SubHelper
chmod 777 SubHelper;
./SubHelper start;
cd ../../;
cd Connector/Connector
chmod 777 Connector;
./Connector start;
cd ../../;
cd LoginServer/LoginServer
chmod 777 LoginServer;
./LoginServer start;
cd ../../;
cd GameServer/GameServer1
chmod 777 GameServer_d;
./GameServer_d start
I turned off my firewall if you need to know
- dateone - 04-08-2013
Thank you alot. I changed everything you told me but now nothing happens after the Messenger Server is running.
Here an image:
my run-file
#!/bin/sh
cd Messenger/Messenger
chmod 777 Messenger;
./Messenger start;
cd ../../;
cd Helper/Helper
chmod 777 Helper;
./Helper start ;
cd ../../;
cd SubHelper/SubHelper
chmod 777 SubHelper;
./SubHelper start;
cd ../../;
cd Connector/Connector
chmod 777 Connector;
./Connector start;
cd ../../;
cd LoginServer/LoginServer
chmod 777 LoginServer;
./LoginServer start;
cd ../../;
cd GameServer/GameServer1
chmod 777 GameServer_d;
./GameServer_d start
I turned off my firewall if you need to know
Theres no mistake!
Nothings wrong with the Messenger. The messenger only needs to be started, it is correct, that nothing happens then.
this is exactly how it should look like. As it says: Messenger server runnung..
- Shozia - 04-08-2013
I cant connect when IP is set to 127.0.0.1 !
You can see my Helper File in last posts
When I change the newStobm.bin of Helper:
[Char DB]
IP: my IP 192..... (not 127.0.0.1)
screen:
- dateone - 04-08-2013
[server]
Number=1
IP=127.0.0.1
Port=3000
[Char DB]
IP=127.0.0.1
DBName=newproject_db_auth
User=spyce
Password=
You forgot this
- Shozia - 04-08-2013
You forgot this
No When I try to connect with IP=127.0.0.1 Error: Cannot Connect DB!!
When I use my IP=192.... I think the Helper is able to connect (im not sure) but has any problems with my database. You see the error on the last screen I posted.
MySQL Server is running and I am able to connect via my Windows PC tro the Database. I use the ID: spyce and no PW. To connect from my windows I also use my IP for sure.
Okay I found the first solution. The problem was, that the system wanted for any reasons the user root. I created it and this was the solution. If anyone has the same problem: You have to reboot mysqld after you created a user.
Now theres again with 127.0.0.1 the Guild bug I screened.
- dateone - 04-08-2013
why dont you use the default newStobm.bins? They run for sure for everyone, no need to change so much as you did.
Only change the first IP of your GameServer and LoginServer each to your VM IP, thats it!
If you want, I can upload them for you tomorrow.
Edit: I forgot to mention that you also have to change your DB names and MySQL settings
- Shozia - 04-08-2013
Okay because of your great help I fixed alot of bugs and mistakes.
Every part of the server is running but the Game Server.
Heres the image:
I turned off my firewall for the test but still nothing working.
ANy Ideas?