Can´t connect to Database!

[iPadrio]

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]

Only GameServer & LoginServer need IP,

others can be 127.0.0.1 try that

[RomainLastChaos]

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]

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]

Can you try by using Wincsp  and putty ? to start your server

[iPadrio]

Putty, Kitty... WinSCP everything the same.