+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Off-Topic (The Outer World) (https://lckb.dev/forum/forumdisplay.php?fid=198)
+---- Forum: General Discussion (https://lckb.dev/forum/forumdisplay.php?fid=147)
+---- Thread: Everytime MySQL Error. (/showthread.php?tid=1212)
- Xen - 11-13-2012
Hey Guys,
Everytime i start i get an MySQL Erorr.
I edited all the configuration files.
And runed the startService.sh
I saw many errors, so i got the source of startService.sh with cat startService.sh and runed every server from hand.
First i used a password, now not anymore.
Its a dedicated Server.
iptables with: service iptables stop
Connector:
[server]
Number=1
MaxSubServer=5
IP=185.5.174.90
Port=50200
[user DB]
IP=127.0.0.1
DBName=lc_auth
User=lcusr
Password=
[Auth DB]
IP=127.0.0.1
DBName=lc_auth
User=lcusr
Password=
[billing Server]
IP=127.0.0.1
Port=8802
[sHA256]
Salt=phoohie1yaihooyaequae7PuiWoeNgahjieth3ru3yeeghaepahb7aeYaipe2we6zii6mai6uweig8siasheinoungeoyeiLohShi2xoh2xi8ooxee9ahpiehahc9Phe
Error: 2
Helper:
[server]
Number=1
IP=185.5.174.90
Port=50301
[Char DB]
IP=185.5.174.90
DBName=lc_char
User=lcusr
Password=
Error: 2
Subhelper:
[server]
Number=1
IP=185.5.174.90
Port=50401
UserPort=4102
MAXSIZE=1000
[Char DB]
IP=127.0.0.1
DBName=lc_char
User=lcusr
Password=
Error: 2
Messenger:
[server]
IP=185.5.174.90
Port=50500
Error: 2
GameServer:
[server]
Number=1
SubNumber=1
IP=185.5.174.90
Port=4101
AllowExternalIP=TRUE
[Data DB]
IP=127.0.0.1
DBName=lc_data
User=lcusr
Password=
[user Server]
IP=127.0.0.1
Port=4102
[Char DB]
IP=127.0.0.1
DBName=lc_char
User=lcusr
Password=
[Messenger Server]
IP=185.5.174.90
Port=50500
[Helper Server]
IP=185.5.174.90
Port=50301
[subHelper Server]
IP=185.5.174.90
Port=50401
[Connector Server]
IP=185.5.174.90
Port=50200
[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
Error: 2
LoginServer:
[server]
No=1
Port=4001
AllowExternalIP=TRUE
[user DB]
IP=127.0.0.1
DBName=lc_char
User=lcusr
Password=
[Data DB]
IP=127.0.0.1
DBName=lc_data
User=lcusr
Password=
[Auth DB]
IP=127.0.0.1
DBName=lc_auth
User=lcusr
Password=
[Messenger Server]
IP=185.5.174.90
Port=50500
[Connector Server]
Count=1
[Connector_0]
Number=1
MaxSubNumber=5
IP=185.5.174.90
Port=50200
[Auto Block]
Refresh=2
MaxTry=7
[sHA256]
Salt=phoohie1yaihooyaequae7PuiWoeNgahjieth3ru3yeeghaepahb7aeYaipe2we6zii6mai6uweig8siasheinoungeoyeiLohShi2xoh2xi8ooxee9ahpiehahc9Phe
Error: 2
I tested the Ports with a PHP Scripts, it says the Server ist Offline.
I coded a complete Website for my Server, dont want to abbort the project
Hope some one can help me.
Greets,
Xen
- Garfield - 11-14-2012
all server wtih ip 127.0.0.1
and Gameserver & LoginServer
[server]
IP=185.5.174.90
- luoo - 11-14-2012
UPDATE mysql.user SET Password = OLD_PASSWORD('NEUES PASSWORT') WHERE Host = 'localhost' AND User = 'root';
You must set the root pw to old password.
- Xen - 11-14-2012
all server wtih ip 127.0.0.1
and Gameserver & LoginServer
[server]
IP=185.5.174.90
185.5.174.90 is the dedicated IP of my Root.
But i will try it.
UPDATE mysql.user SET Password = OLD_PASSWORD('NEUES PASSWORT') WHERE Host = 'localhost' AND User = 'root';
You must set the root pw to old password.
Why?
I created a new user called lcusr without Password & Only Right for 127.0.0.1