Loginserver connect db error - Printable Version

Loginserver connect db error - Printable Version

+- 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: Ep3 Support (https://lckb.dev/forum/forumdisplay.php?fid=150)
+------ Forum: Solved topics (https://lckb.dev/forum/forumdisplay.php?fid=151)
+------ Thread: Loginserver connect db error (/showthread.php?tid=2912)

- extreme - 12-18-2013

Hi everyone.

I have a problem with EP3 files.
When i try to start GS, helper, SubHelper ecc all ready without any problem, but when i try to open loginserver i have this error "Connect db error"
I have this problem only in the loginserver.

How can solve?

Thanks!

- Darkface - 12-18-2013

check your config in the NewStorm.

u need this:

[Server]
No=1
IP=204.7.5.46
Port=4001
AllowExternalIP=TRUE

[User DB]
IP=127.0.0.1
DBName=newproject_db_user
User=test
Password=test

[Data DB]
IP=127.0.0.1
DBName=newproject_data
User=test
Password=test

[Auth DB]
IP=127.0.0.1
DBName=newproject_db_auth
User=test
Password=test

[Messenger Server]
IP=204.70.5.46
Port=4112

[Connector Server]
Count=1

[Connector_0]
Number=1
MaxSubNumber=1
IP=204.7.5.46
Port=4006

[Block IP]
Number=0

[Block Band]
Number=21
Band0=A-211.094.000.000-211.103.255.255
Band1=A-210.072.000.000-210.079.255.255
Band2=B-203.095.000.000-203.095.063.255
Band3=B-203.094.000.000-203.094.063.255
Band4=B-203.092.000.000-203.092.063.255
Band5=B-203.090.000.000-203.090.063.255
Band6=B-203.089.000.000-203.089.063.255
Band7=B-203.087.224.000-203.087.255.255
Band8=B-203.088.000.000-203.088.063.255
Band9=B-203.095.000.000-203.095.063.255
Band10=B-203.091.000.000-203.091.063.255
Band11=C-202.000.110.000-202.000.110.255
Band12=C-192.188.170.000-192.188.170.255
Band13=B-161.207.000.000-161.207.255.255
Band14=B-159.226.001.000-159.226.003.255
Band15=B-159.226.000.000-159.226.255.255
Band16=C-132.246.027.000-132.246.027.255
Band17=C-222.168.000.000-222.168.255.255
Band18=B-222.169.000.000-222.169.255.255
Band19=A219.149.192.000-219.149.255.255
Band20=A219.150.000.000-219.150.031.255

[Auto Block]
; Refresh : Ãƒâ€ Ã‚Â¯ÃƒÂÃ‚Â¤ Ã‚Â½ÃƒÆ’Ã‚Â°Ã‚Â£Ã‚Â¿Ã‚Â¡ Ãƒâ€¡Ãƒâ€˜Ã‚Â¹ÃƒÂ¸Ã‚Â¾Ã‚Â¿ Ãƒâ‚¬ÃƒÅ¡Ã‚ÂµÃ‚Â¿ Ã‚ÂºÃƒÂÃ‚Â·ÃƒÂÃƒâ€¡Ãƒâ€˜ IPÃ‚Â¸Ã‚Â¦ Ã‚Â¸Ã‚Â®Ã‚Â¼Ãƒâ€šÃƒâ€¡Ãƒâ€, Ã‚Â½ÃƒÆ’Ã‚Â°Ã‚Â£Ã‚Â´ÃƒÅ“Ãƒâ‚¬Ã‚Â§
; MaxTry : Refresh Ã‚ÂµÃ‚Â¿Ãƒâ€¡Ãƒâ€˜ Ãƒâ€¡Ãƒâ€˜ IPÃ‚Â¿Ã‚Â¡Ã‚Â¼Ã‚Â ÃƒÂÃ‚Â¢Ã‚Â±Ãƒâ„¢Ãƒâ€¡Ãƒâ€™ Ã‚Â¼ÃƒÂ¶ Ãƒâ‚¬Ãƒâ€“Ã‚Â´Ãƒâ€š Ã‚Â°ÃƒÂ¨ÃƒÂÃ‚Â¤ Ã‚Â¼ÃƒÂ¶
; ExIPxxx.*****.*****.***** : Ãƒâ€ Ã‚Â¯ÃƒÂÃ‚Â¤ Ã‚Â¾Ãƒâ€ Ãƒâ‚¬ÃƒÅ’Ãƒâ€¡Ãƒâ€¡Ã‚Â´Ãƒâ€š Ã‚Â°Ãƒâ€¹Ã‚Â»ÃƒÂ§ Ã‚Â¾ÃƒË†Ãƒâ€¡Ãƒâ€, Ã‚Â°Ã‚ÂªÃƒâ‚¬Ã‚Âº Ã‚Â¹Ã‚Â«ÃƒÂÃ‚Â¶Ã‚Â°Ãƒâ€¡ 1Ã‚Â·ÃƒÅ½ Ã‚Â¼Ã‚Â³ÃƒÂÃ‚Â¤Ãƒâ€¡ÃƒÂÃ‚Â¸ÃƒÂ§, KeyÃ‚Â¿Ã‚Â¡ IPÃ‚Â¸Ã‚Â¦ Ãƒâ‚¬ÃƒÂ»Ãƒâ‚¬Ã‚Â½
; Ã‚Â¿Ã‚Â¹) 111.222.123.1Ã‚Â¸Ã‚Â¦ ÃƒÂÃ‚Â¦Ã‚Â¿ÃƒÅ“Ãƒâ€¡ÃƒÂÃ‚Â°ÃƒÂÃƒâ‚¬ÃƒÅ¡ Ãƒâ€¡Ãƒâ€™Ã‚Â¶Ã‚Â§,
; ExIP111.222.123.1=1
Refresh=2
MaxTry=5
ExIP211.181.248.133=1

[Block ExID]
ExIDdaekbbang=1

Where this 204.7.5.46 put your external IP.

- MrBuSta - 12-18-2013

dont add password in newstobm.bin...if you add password,files will give cannot connect db error..

- Wizatek - 12-18-2013

U can use passwords, but u need to set mysql to use old passwords.

in etc/my.cnf u need to add old_passwords=1

and also update the password in the user table with OLD_PASSWORD(passwordhere)

- extreme - 12-19-2013

Well, I dont have solve yet.
In the loginServer folder i have 3 files that called NewStobm.
1) NewStobm file bin
2) NewStobm.bin file 20110913

3) NewStobm file BIN_BACKUP

The first files:

[server]
No=1
IP=My ip
Port=4001
AllowExternalIP=TRUE

[user DB]
IP=127.0.0.1
DBName=newproject_db_user
User=test
Password=test

[Data DB]
IP=127.0.0.1
DBName=newproject_data
User=test
Password=test

[Auth DB]
IP=127.0.0.1
DBName=newproject_db_auth
User=test
Password=test

[Messenger Server]
IP=My ip
Port=4112

[Connector Server]
Count=1

[Connector_0]
Number=1
MaxSubNumber=1
IP=My ip
Port=4006

[block IP]
Number=0

[block Band]
Number=21
Band0=A-211.094.000.000-211.103.255.255
Band1=A-210.072.000.000-210.079.255.255
Band2=B-203.095.000.000-203.095.063.255
Band3=B-203.094.000.000-203.094.063.255
Band4=B-203.092.000.000-203.092.063.255
Band5=B-203.090.000.000-203.090.063.255
Band6=B-203.089.000.000-203.089.063.255
Band7=B-203.087.224.000-203.087.255.255
Band8=B-203.088.000.000-203.088.063.255
Band9=B-203.095.000.000-203.095.063.255
Band10=B-203.091.000.000-203.091.063.255
Band11=C-202.000.110.000-202.000.110.255
Band12=C-192.188.170.000-192.188.170.255
Band13=B-161.207.000.000-161.207.255.255
Band14=B-159.226.001.000-159.226.003.255
Band15=B-159.226.000.000-159.226.255.255
Band16=C-132.246.027.000-132.246.027.255
Band17=C-222.168.000.000-222.168.255.255
Band18=B-222.169.000.000-222.169.255.255
Band19=A219.149.192.000-219.149.255.255
Band20=A219.150.000.000-219.150.031.255

[Auto Block]
; Refresh : Ãƒâ€ Ã‚Â¯ÃƒÂÃ‚Â¤ Ã‚Â½ÃƒÆ’Ã‚Â°Ã‚Â£Ã‚Â¿Ã‚Â¡ Ãƒâ€¡Ãƒâ€˜Ã‚Â¹ÃƒÂ¸Ã‚Â¾Ã‚Â¿ Ãƒâ‚¬ÃƒÅ¡Ã‚ÂµÃ‚Â¿ Ã‚ÂºÃƒÂÃ‚Â·ÃƒÂÃƒâ€¡Ãƒâ€˜ IPÃ‚Â¸Ã‚Â¦ Ã‚Â¸Ã‚Â®Ã‚Â¼Ãƒâ€šÃƒâ€¡Ãƒâ€, Ã‚Â½ÃƒÆ’Ã‚Â°Ã‚Â£Ã‚Â´ÃƒÅ“Ãƒâ‚¬Ã‚Â§
; MaxTry : Refresh Ã‚ÂµÃ‚Â¿Ãƒâ€¡Ãƒâ€˜ Ãƒâ€¡Ãƒâ€˜ IPÃ‚Â¿Ã‚Â¡Ã‚Â¼Ã‚Â ÃƒÂÃ‚Â¢Ã‚Â±Ãƒâ„¢Ãƒâ€¡Ãƒâ€™ Ã‚Â¼ÃƒÂ¶ Ãƒâ‚¬Ãƒâ€“Ã‚Â´Ãƒâ€š Ã‚Â°ÃƒÂ¨ÃƒÂÃ‚Â¤ Ã‚Â¼ÃƒÂ¶
; ExIPxxx.*****.*****.***** : Ãƒâ€ Ã‚Â¯ÃƒÂÃ‚Â¤ Ã‚Â¾Ãƒâ€ Ãƒâ‚¬ÃƒÅ’Ãƒâ€¡Ãƒâ€¡Ã‚Â´Ãƒâ€š Ã‚Â°Ãƒâ€¹Ã‚Â»ÃƒÂ§ Ã‚Â¾ÃƒË†Ãƒâ€¡Ãƒâ€, Ã‚Â°Ã‚ÂªÃƒâ‚¬Ã‚Âº Ã‚Â¹Ã‚Â«ÃƒÂÃ‚Â¶Ã‚Â°Ãƒâ€¡ 1Ã‚Â·ÃƒÅ½ Ã‚Â¼Ã‚Â³ÃƒÂÃ‚Â¤Ãƒâ€¡ÃƒÂÃ‚Â¸ÃƒÂ§, KeyÃ‚Â¿Ã‚Â¡ IPÃ‚Â¸Ã‚Â¦ Ãƒâ‚¬ÃƒÂ»Ãƒâ‚¬Ã‚Â½
; Ã‚Â¿Ã‚Â¹) 111.222.123.1Ã‚Â¸Ã‚Â¦ ÃƒÂÃ‚Â¦Ã‚Â¿ÃƒÅ“Ãƒâ€¡ÃƒÂÃ‚Â°ÃƒÂÃƒâ‚¬ÃƒÅ¡ Ãƒâ€¡Ãƒâ€™Ã‚Â¶Ã‚Â§,
;     ExIP111.222.123.1=1
Refresh=2
MaxTry=5
ExIP211.181.248.133=1

[block ExID]
ExIDdaekbbang=1

Second Files

[server]
No=1
;IP=My ip
;IP=My ip
IP=My ip
Port=4001
AllowExternalIP=TRUE

[user DB]
;IP=127.0.0.1
;IP=127.0.0.1
;IP=127.0.0.1
IP=localhost
DBName=newproject_db_user
User=localhost
Password=

[Data DB]
;IP=127.0.0.1
;IP=127.0.0.1
;IP=127.0.0.1
IP=localhost
DBName=newproject_data
User=localhost
Password=

[Auth DB]
;IP=127.0.0.1
;IP=127.0.0.1
;IP=127.0.0.1
IP=localhost
DBName=newproject_db_auth
User=localhost
Password=

[Messenger Server]
;IP=My ip
;IP=My ip
IP=My ip
Port=4000

[Connector Server]
Count=1

[Connector_0]
Number=1
MaxSubNumber=3
;IP=My ip
IP=My ip
Port=4006

[Connector_1]
Number=2
MaxSubNumber=6
;IP=My ip
IP=My ip
Port=4006

[block IP]
Number=0

[block Band]
Number=21
Band0=A-211.094.000.000-211.103.255.255
Band1=A-210.072.000.000-210.079.255.255
Band2=B-203.095.000.000-203.095.063.255
Band3=B-203.094.000.000-203.094.063.255
Band4=B-203.092.000.000-203.092.063.255
Band5=B-203.090.000.000-203.090.063.255
Band6=B-203.089.000.000-203.089.063.255
Band7=B-203.087.224.000-203.087.255.255
Band8=B-203.088.000.000-203.088.063.255
Band9=B-203.095.000.000-203.095.063.255
Band10=B-203.091.000.000-203.091.063.255
Band11=C-202.000.110.000-202.000.110.255
Band12=C-192.188.170.000-192.188.170.255
Band13=B-161.207.000.000-161.207.255.255
Band14=B-159.226.001.000-159.226.003.255
Band15=B-159.226.000.000-159.226.255.255
Band16=C-132.246.027.000-132.246.027.255
Band17=C-222.168.000.000-222.168.255.255
Band18=B-222.169.000.000-222.169.255.255
Band19=A219.149.192.000-219.149.255.255
Band20=A219.150.000.000-219.150.031.255

[Auto Block]
; Refresh : Ãƒâ€ Ã‚Â¯ÃƒÂÃ‚Â¤ Ã‚Â½ÃƒÆ’Ã‚Â°Ã‚Â£Ã‚Â¿Ã‚Â¡ Ãƒâ€¡Ãƒâ€˜Ã‚Â¹ÃƒÂ¸Ã‚Â¾Ã‚Â¿ Ãƒâ‚¬ÃƒÅ¡Ã‚ÂµÃ‚Â¿ Ã‚ÂºÃƒÂÃ‚Â·ÃƒÂÃƒâ€¡Ãƒâ€˜ IPÃ‚Â¸Ã‚Â¦ Ã‚Â¸Ã‚Â®Ã‚Â¼Ãƒâ€šÃƒâ€¡Ãƒâ€, Ã‚Â½ÃƒÆ’Ã‚Â°Ã‚Â£Ã‚Â´ÃƒÅ“Ãƒâ‚¬Ã‚Â§
; MaxTry : Refresh Ã‚ÂµÃ‚Â¿Ãƒâ€¡Ãƒâ€˜ Ãƒâ€¡Ãƒâ€˜ IPÃ‚Â¿Ã‚Â¡Ã‚Â¼Ã‚Â ÃƒÂÃ‚Â¢Ã‚Â±Ãƒâ„¢Ãƒâ€¡Ãƒâ€™ Ã‚Â¼ÃƒÂ¶ Ãƒâ‚¬Ãƒâ€“Ã‚Â´Ãƒâ€š Ã‚Â°ÃƒÂ¨ÃƒÂÃ‚Â¤ Ã‚Â¼ÃƒÂ¶
; ExIPxxx.[CeNsOrEd].[CeNsOrEd].[CeNsOrEd] : Ãƒâ€ Ã‚Â¯ÃƒÂÃ‚Â¤ Ã‚Â¾Ãƒâ€ Ãƒâ‚¬ÃƒÅ’Ãƒâ€¡Ãƒâ€¡Ã‚Â´Ãƒâ€š Ã‚Â°Ãƒâ€¹Ã‚Â»ÃƒÂ§ Ã‚Â¾ÃƒË†Ãƒâ€¡Ãƒâ€, Ã‚Â°Ã‚ÂªÃƒâ‚¬Ã‚Âº Ã‚Â¹Ã‚Â«ÃƒÂÃ‚Â¶Ã‚Â°Ãƒâ€¡ 1Ã‚Â·ÃƒÅ½ Ã‚Â¼Ã‚Â³ÃƒÂÃ‚Â¤Ãƒâ€¡ÃƒÂÃ‚Â¸ÃƒÂ§, KeyÃ‚Â¿Ã‚Â¡ IPÃ‚Â¸Ã‚Â¦ Ãƒâ‚¬ÃƒÂ»Ãƒâ‚¬Ã‚Â½
; Ã‚Â¿Ã‚Â¹) 111.222.123.1Ã‚Â¸Ã‚Â¦ ÃƒÂÃ‚Â¦Ã‚Â¿ÃƒÅ“Ãƒâ€¡ÃƒÂÃ‚Â°ÃƒÂÃƒâ‚¬ÃƒÅ¡ Ãƒâ€¡Ãƒâ€™Ã‚Â¶Ã‚Â§,
;     ExIP111.222.123.1=1
Refresh=2
MaxTry=5
ExIP211.181.248.133=1

[block ExID]
ExIDdaekbbang=1

Third Files

[server]
No=1
;IP=My ip
;IP=My ip
IP=My ip
Port=4001
AllowExternalIP=TRUE

[user DB]
;IP=127.0.0.1
;IP=127.0.0.1
;IP=127.0.0.1
IP=localhost
DBName=newproject_db_user
User=localhost
Password=

[Data DB]
;IP=127.0.0.1
;IP=127.0.0.1
;IP=127.0.0.1
IP=localhost
DBName=newproject_data
User=localhost
Password=

[Auth DB]
;IP=127.0.0.1
;IP=127.0.0.1
;IP=127.0.0.1
IP=localhost
DBName=newproject_db_auth
User=localhost
Password=

[Messenger Server]
;IP=My ip
;IP=My ip
IP=My ip
Port=4000

[Connector Server]
Count=2

[Connector_0]
Number=1
MaxSubNumber=3
;IP=My ip
IP=My ip
Port=4006

[Connector_1]
Number=2
MaxSubNumber=3
;IP=My ip
IP=My ip
Port=4007

[block IP]
Number=0

[block Band]
Number=21
Band0=A-211.094.000.000-211.103.255.255
Band1=A-210.072.000.000-210.079.255.255
Band2=B-203.095.000.000-203.095.063.255
Band3=B-203.094.000.000-203.094.063.255
Band4=B-203.092.000.000-203.092.063.255
Band5=B-203.090.000.000-203.090.063.255
Band6=B-203.089.000.000-203.089.063.255
Band7=B-203.087.224.000-203.087.255.255
Band8=B-203.088.000.000-203.088.063.255
Band9=B-203.095.000.000-203.095.063.255
Band10=B-203.091.000.000-203.091.063.255
Band11=C-202.000.110.000-202.000.110.255
Band12=C-192.188.170.000-192.188.170.255
Band13=B-161.207.000.000-161.207.255.255
Band14=B-159.226.001.000-159.226.003.255
Band15=B-159.226.000.000-159.226.255.255
Band16=C-132.246.027.000-132.246.027.255
Band17=C-222.168.000.000-222.168.255.255
Band18=B-222.169.000.000-222.169.255.255
Band19=A219.149.192.000-219.149.255.255
Band20=A219.150.000.000-219.150.031.255

[Auto Block]
; Refresh : Ãƒâ€ Ã‚Â¯ÃƒÂÃ‚Â¤ Ã‚Â½ÃƒÆ’Ã‚Â°Ã‚Â£Ã‚Â¿Ã‚Â¡ Ãƒâ€¡Ãƒâ€˜Ã‚Â¹ÃƒÂ¸Ã‚Â¾Ã‚Â¿ Ãƒâ‚¬ÃƒÅ¡Ã‚ÂµÃ‚Â¿ Ã‚ÂºÃƒÂÃ‚Â·ÃƒÂÃƒâ€¡Ãƒâ€˜ IPÃ‚Â¸Ã‚Â¦ Ã‚Â¸Ã‚Â®Ã‚Â¼Ãƒâ€šÃƒâ€¡Ãƒâ€, Ã‚Â½ÃƒÆ’Ã‚Â°Ã‚Â£Ã‚Â´ÃƒÅ“Ãƒâ‚¬Ã‚Â§
; MaxTry : Refresh Ã‚ÂµÃ‚Â¿Ãƒâ€¡Ãƒâ€˜ Ãƒâ€¡Ãƒâ€˜ IPÃ‚Â¿Ã‚Â¡Ã‚Â¼Ã‚Â ÃƒÂÃ‚Â¢Ã‚Â±Ãƒâ„¢Ãƒâ€¡Ãƒâ€™ Ã‚Â¼ÃƒÂ¶ Ãƒâ‚¬Ãƒâ€“Ã‚Â´Ãƒâ€š Ã‚Â°ÃƒÂ¨ÃƒÂÃ‚Â¤ Ã‚Â¼ÃƒÂ¶
; ExIPxxx.[CeNsOrEd].[CeNsOrEd].[CeNsOrEd] : Ãƒâ€ Ã‚Â¯ÃƒÂÃ‚Â¤ Ã‚Â¾Ãƒâ€ Ãƒâ‚¬ÃƒÅ’Ãƒâ€¡Ãƒâ€¡Ã‚Â´Ãƒâ€š Ã‚Â°Ãƒâ€¹Ã‚Â»ÃƒÂ§ Ã‚Â¾ÃƒË†Ãƒâ€¡Ãƒâ€, Ã‚Â°Ã‚ÂªÃƒâ‚¬Ã‚Âº Ã‚Â¹Ã‚Â«ÃƒÂÃ‚Â¶Ã‚Â°Ãƒâ€¡ 1Ã‚Â·ÃƒÅ½ Ã‚Â¼Ã‚Â³ÃƒÂÃ‚Â¤Ãƒâ€¡ÃƒÂÃ‚Â¸ÃƒÂ§, KeyÃ‚Â¿Ã‚Â¡ IPÃ‚Â¸Ã‚Â¦ Ãƒâ‚¬ÃƒÂ»Ãƒâ‚¬Ã‚Â½
; Ã‚Â¿Ã‚Â¹) 111.222.123.1Ã‚Â¸Ã‚Â¦ ÃƒÂÃ‚Â¦Ã‚Â¿ÃƒÅ“Ãƒâ€¡ÃƒÂÃ‚Â°ÃƒÂÃƒâ‚¬ÃƒÅ¡ Ãƒâ€¡Ãƒâ€™Ã‚Â¶Ã‚Â§,
;     ExIP111.222.123.1=1
Refresh=2
MaxTry=5
ExIP211.181.248.133=1

[block ExID]
ExIDdaekbbang=1

What is it wrong?
Thanks!

- Wrong - 12-19-2013

Why do you use test as pw? it must be old mysql password and user db is newproject_db I think unless youve edited it, an example of mine:

[Server]
No=1
IP=123.1.155.5
Port=4001
AllowExternalIP=TRUE

[User DB]
IP=127.0.0.1
DBName=newproject_db
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
User=root
Password=

[Messenger Server]
IP=127.0.0.1
Port=50500

[Connector Server]
Count=1

[Connector_0]
Number=1
MaxSubNumber=4
IP=127.0.0.1
Port=50200

[Auto Block]
Refresh=2
MaxTry=7

[SHA256]
Salt=phoohie1yaihooyaequae7PuiWoeNgahjieth3ru3yeeghaepahb7aeYaipe2we6zii6mai6uweig8siasheinoungeoyeiLohShi2xoh2xi8ooxee9ahpiehahc9Phe

PS: Use 127.0.0.1 for all IP instead of external IP except for loginserver and gameservers. No one will access your files like that and it should work even faster.

PS2: My dbs are merged so dont set them like me, set them as you have them in your db

- extreme - 12-19-2013

:lol: Thanks Wrong, I didnt noticed that i put the password. Huh

Ive have put the folder "update" in the client but i have error and client crash, without the folder "update" the game work perfectly.
Why this?

- Paramount - 12-20-2013

Then just dont put it