+- 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´t connect to Database! (/showthread.php?tid=2578)
- iPadrio - 10-27-2013
Hey Guys,
im currently trying to setup a Last Chaos Server.
Now my problem is that nothing (Connector // GameServer // Helper // LoginServer // Subhelper) can connect to my Database.
So... i installed mysql & the required libs and imported the Databases correctly.
I´m using the untouched Serverfiles from 2012 (where still on my disk from :ignat_02
with the USA Game- & Login Server and data Database.I run CentOS 6.4.
I´ve created two users:
lastchaos@localhost
[email protected]
Both uses the old password encryption.
Here is a video where i try to start the Server and show you my configs:
Hope you can help me.
- OldHM - 10-27-2013
Only GameServer & LoginServer need IP,
others can be 127.0.0.1 try that
- RomainLastChaos - 10-27-2013
Dont matter if helper subhelper connector etc have the vps ip too
PS after whatching your movie
try to change your ports Like the same of here
and try to add database privilège to each users on navicat
config Helper
[server]
Number=1
IP=80.200.7.7
Port=50301
[Char DB]
IP=127.0.0.1
DBName=newproject_db
User=root
Password=
Config Messenger
2
[server]
IP=80.200.7.7
Port=4105
Config SubHelper
3
[server]
Number=1
IP=80.200.7.7
Port=50401
UserPort=4102
MAXSIZE=1000
[Char DB]
IP=127.0.0.1
DBName=newproject_db
User=root
Password=
IP=127.0.0.1
DBName=newproject_post
User=root
Password=
Config Connector
4
[server]
Number=1
MaxSubServer=1
IP=80.200.7.7
Port=4006
[user DB]
IP=127.0.0.1
DBName=newproject_db_auth
User=root
Password=
[Auth DB]
IP=127.0.0.1
DBName=newproject_db_auth
User=root
Password=
[billing Server]
IP=80.200.7.7
Port=8888
Config GameServer
5
[server]
Number=1
SubNumber=1
IP=80.200.7.7
Port=4101
AllowExternalIP=TRUE
[Data DB]
IP=127.0.0.1
DBName=newproject_data
User=root
Password=
IP=127.0.0.1
DBName=newproject_post
User=root
Password=
[user Server]
IP=127.0.0.1
Port=4102
[Char DB]
IP=127.0.0.1
DBName=newproject_db
User=root
Password=
[Messenger Server]
IP=80.200.7.7
Port=4105
[Helper Server]
IP=80.200.7.7
Port=50301
[subHelper Server]
IP=80.200.7.7
Port=50401
[Connector Server]
IP=80.200.7.7
Port=4006
Config LoginServer
6
[server]
No=1
IP=80.200.7.7
Port=4001
AllowExternalIP=TRUE
[user DB]
IP=127.0.0.1
DBName=newproject_db_auth
User=root
Password=
[Data DB]
IP=127.0.0.1
DBName=newproject_data
User=root
Password=
[Auth DB]
IP=127.0.0.1
DBName=newproject_db_auth
User=root
Password=
[Messenger Server]
IP=80.200.7.7
Port=4105
[Connector Server]
Count=1
[Connector_0]
Number=1
MaxSubNumber=1
IP=80.200.7.7
Port=4006
[Auto Block]
Refresh=2
MaxTry=7
2
- iPadrio - 10-27-2013
Dont matter if helper subhelper connector etc have the vps ip too
PS after whatching your movie
try to change your ports Like the same of here
and try to add database privilège to each users on navicat
config Helper
Config Messenger
2
Config SubHelper
3
Config Connector
4
Config GameServer
5
Config LoginServer
6
2
Thank you guys but still dont work...
2
The users can access the Databases && i tryed your configs, but still dont work...
- RomainLastChaos - 10-27-2013
Can you try by using Wincsp and putty ? to start your server
- iPadrio - 10-27-2013
Putty, Kitty... WinSCP everything the same.