[Mobile]Dragon Nest Mobile 1.5.461 Multilangue(Centos Server)

[ninekinsen]

sorry sir,, how to set up GM account?

[rocklee330]

bruh incorrect password 123456. what is the password bro

i use that vmware alot and password is 123456

[carabien]

are u indonesia people @rocklee330 ??

[rocklee330]

belgium as my location say

[yokohiro]

my game dont save progress character...
i'm level 20, relog, come back to lvl 4.
any ideia for this erro?

ps: in local server work fine, this error for vps (wan)

08:06:50 [Debug] ProcessReply(mysqlthread.cpp:128) task GlobalUpdateTask finished, sql use 2(ms), total use 5(ms) threadtype 56112896
08:07:35 [Info] PushTaskToMysql(rolecache.cpp:247) [rolecache] push role write task 285784415931931 into thread 6
08:07:35 [Info] PushTaskToMysql(rolecache.cpp:255) [rolecache] pop write task fail 285784415931931
08:07:35 [Debug] ProcessReply(mysqlthread.cpp:128) task AccountRoleUpdateTask finished, sql use 4(ms), total use 12(ms) threadtype 22542080
08:07:35 [Error] OnReply(rolewritetask.cpp:81) Write role data task failed, roleid: 285784415931931, errMsg: ErrDesc: Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline., ErrNo: 1118
08:07:35 [Debug] OnReply(rolewritetask.cpp:99) Role 285784415931931 update data, totalSize 24440, fieldNum 59, details: WeekEnd4v4Data=7 SQARecord=10 RoleMiscData=133 BagContent=542 CompeteDragonInfo2DB=10 PkRecord=153 DragonRecord2DB=20 FashionRecord=48 SChatRecord=8 DragonGroupDB=0 SpActivity=606 TowerRecord2DB=8 FlowerRecord=10 PayV2Record=287 MilitaryRecord=14 ReportDataRecord=38 PetSysData=19 BattleFieldData=69 LiveRecord=0 PvpData=28 ActivityRecord=28 RoleSystem=1627 IdipData=14 TShowVoteRecord=6 RolePartnerData=20 SBuffRecord=0 AchieveDbInfo=0 NpcFeelingRecord=6 QQVipInfo=0 Designation2DB=38 SpriteRecord=138 SkillRecord=776 ArenaRecord=8 TajieHelp2DB=0 HeroBattleRecord=52 RiskInfo2DB=24 IBShopAllRecord=5460 DragonGuildRecordData=1168 FirstPassRecord=0 RoleTask=78 RoleLotteryInfo=41 RoleFindBackRecord=195 LoginRecord=15 TeamRecord=140 RolePushInfo=0 RoleExtraInfo=26 BuyGoldFatInfo=18 ShopRecord=10195 PlatformShareResult=34 CampRoleRecord=0 RoleConfig=215 StageInfo=144 RoleBrief=120 Attribute=1480 SAtlasRecord=0 RewardRecord=300 LevelSealRecord=19 GuildRecord=37 CheckinRecord=8 
08:07:35 [Debug] OnReply(rolewritetask.cpp:119) Role 285784415931931 update ex data, totalSize 153, fieldNum 8, details: DataMore=63 MechaInfoRecord=0 PasswordProtectInfo=12 DuelRecord=24 Nightmarerecord=16 RiftRecord2Db=0 AncientEquipment=30 FollowerRecord=8 
08:07:35 [Debug] ProcessReply(mysqlthread.cpp:128) task RoleWriteTask finished, sql use 6(ms), total use 12(ms) threadtype 5756672
08:07:35 [Debug] ProcessReply(mysqlthread.cpp:128) task AccountReadTask finished, sql use 0(ms), total use 5(ms) threadtype 22542080
08:07:42 [Debug] ProcessReply(mysqlthread.cpp:128) task AccountLastSelectTask finished, sql use 1(ms), total use 5(ms) threadtype 22542080
08:07:42 [Debug] ProcessReply(mysqlthread.cpp:128) task RoleReadTask finished, sql use 2(ms), total use 5(ms) threadtype 5756672
08:07:47 [Info] Execute(onlinewritetask.cpp:51) Online Write insert into tb_dragonnest_onlinecnt(`gameappid`,`timekey`,`gsid`,`zoneareaid`,`onlinecntios`,`onlinecntandroid`, `onlinecntzh`, `onlinecntcht`, `onlinecntkor`, `onlinecnten`, `onlinecntjp`, `onlinecntthai`, `onlinecntind`, `onlinecnttukey`, `onlinecntarab`,`onlinecntna`,`onlinecntfr`,`onlinecntnazh`,`onlinecntes`,`onlinecntpt`,`onlinecntru`,`onlinecntita`,`onlinecntde`) values('wxfdab5af74990787a',1587024467,1003,1003,0,2,1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0)
08:07:47 [Debug] ProcessReply(mysqlthread.cpp:128) task OnlineWriteTask finished, sql use 3(ms), total use 5(ms) threadtype 4267153152
08:07:48 [Debug] ProcessReply(mysqlthread.cpp:128) task RoleTaskUpdateTask finished, sql use 3(ms), total use 5(ms) threadtype 30934784

[harlem321]

bro how to open gateinfo.ibd and .frm file

[harlem321]

do i need to install phpmyadmin to open .frm and .ibd files?

[pangs10]

any one can teach me how to add more channels?

[rocklee330]

my game dont save progress character...
i'm level 20, relog, come back to lvl 4.
any ideia for this erro?

ps: in local server work fine, this error for vps (wan)

08:06:50 [Debug] ProcessReply(mysqlthread.cpp:128) task GlobalUpdateTask finished, sql use 2(ms), total use 5(ms) threadtype 56112896
08:07:35 [Info] PushTaskToMysql(rolecache.cpp:247) [rolecache] push role write task 285784415931931 into thread 6
08:07:35 [Info] PushTaskToMysql(rolecache.cpp:255) [rolecache] pop write task fail 285784415931931
08:07:35 [Debug] ProcessReply(mysqlthread.cpp:128) task AccountRoleUpdateTask finished, sql use 4(ms), total use 12(ms) threadtype 22542080
08:07:35 [Error] OnReply(rolewritetask.cpp:81) Write role data task failed, roleid: 285784415931931, errMsg: ErrDesc: Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline., ErrNo: 1118
08:07:35 [Debug] OnReply(rolewritetask.cpp:99) Role 285784415931931 update data, totalSize 24440, fieldNum 59, details: WeekEnd4v4Data=7 SQARecord=10 RoleMiscData=133 BagContent=542 CompeteDragonInfo2DB=10 PkRecord=153 DragonRecord2DB=20 FashionRecord=48 SChatRecord=8 DragonGroupDB=0 SpActivity=606 TowerRecord2DB=8 FlowerRecord=10 PayV2Record=287 MilitaryRecord=14 ReportDataRecord=38 PetSysData=19 BattleFieldData=69 LiveRecord=0 PvpData=28 ActivityRecord=28 RoleSystem=1627 IdipData=14 TShowVoteRecord=6 RolePartnerData=20 SBuffRecord=0 AchieveDbInfo=0 NpcFeelingRecord=6 QQVipInfo=0 Designation2DB=38 SpriteRecord=138 SkillRecord=776 ArenaRecord=8 TajieHelp2DB=0 HeroBattleRecord=52 RiskInfo2DB=24 IBShopAllRecord=5460 DragonGuildRecordData=1168 FirstPassRecord=0 RoleTask=78 RoleLotteryInfo=41 RoleFindBackRecord=195 LoginRecord=15 TeamRecord=140 RolePushInfo=0 RoleExtraInfo=26 BuyGoldFatInfo=18 ShopRecord=10195 PlatformShareResult=34 CampRoleRecord=0 RoleConfig=215 StageInfo=144 RoleBrief=120 Attribute=1480 SAtlasRecord=0 RewardRecord=300 LevelSealRecord=19 GuildRecord=37 CheckinRecord=8 
08:07:35 [Debug] OnReply(rolewritetask.cpp:119) Role 285784415931931 update ex data, totalSize 153, fieldNum 8, details: DataMore=63 MechaInfoRecord=0 PasswordProtectInfo=12 DuelRecord=24 Nightmarerecord=16 RiftRecord2Db=0 AncientEquipment=30 FollowerRecord=8 
08:07:35 [Debug] ProcessReply(mysqlthread.cpp:128) task RoleWriteTask finished, sql use 6(ms), total use 12(ms) threadtype 5756672
08:07:35 [Debug] ProcessReply(mysqlthread.cpp:128) task AccountReadTask finished, sql use 0(ms), total use 5(ms) threadtype 22542080
08:07:42 [Debug] ProcessReply(mysqlthread.cpp:128) task AccountLastSelectTask finished, sql use 1(ms), total use 5(ms) threadtype 22542080
08:07:42 [Debug] ProcessReply(mysqlthread.cpp:128) task RoleReadTask finished, sql use 2(ms), total use 5(ms) threadtype 5756672
08:07:47 [Info] Execute(onlinewritetask.cpp:51) Online Write insert into tb_dragonnest_onlinecnt(`gameappid`,`timekey`,`gsid`,`zoneareaid`,`onlinecntios`,`onlinecntandroid`, `onlinecntzh`, `onlinecntcht`, `onlinecntkor`, `onlinecnten`, `onlinecntjp`, `onlinecntthai`, `onlinecntind`, `onlinecnttukey`, `onlinecntarab`,`onlinecntna`,`onlinecntfr`,`onlinecntnazh`,`onlinecntes`,`onlinecntpt`,`onlinecntru`,`onlinecntita`,`onlinecntde`) values('wxfdab5af74990787a',1587024467,1003,1003,0,2,1,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0)
08:07:47 [Debug] ProcessReply(mysqlthread.cpp:128) task OnlineWriteTask finished, sql use 3(ms), total use 5(ms) threadtype 4267153152
08:07:48 [Debug] ProcessReply(mysqlthread.cpp:128) task RoleTaskUpdateTask finished, sql use 3(ms), total use 5(ms) threadtype 30934784

you have not follow the tuto and verify you db is on compressed

- - - Updated - - -

Anyone interest on discord group for fixing this game?

fix this game what you mean ? he run really well and only 2 thing api (for topup and giftcode) and homeshop

[yokohiro]

you have not follow the tuto and verify you db is on compressed

i'm follow the tuto, go try again.

execute again this command, the error persist
mysql -uroot -p123456 -e "source /root/install/all.sql;"

https://ibb.co/McGDr5g

[rocklee330]

it seems your db still on compact not compressed
check if you have same my.cnf then the one on root.tar.gz (installer) if yes try restart mysql and import db again

mysql> SHOW ENGINES;

for see if innodb work

[ninekinsen]

how to enable GM account?

[rocklee330]

login_conf.xml debug 0 to 1 (not for log)

[RGaming]

login_conf.xml debug 0 to 1 (not for log)

is this possible to allow GM command only in 1 account or 2 account

[rocklee330]

yes it is ,close debug login and open everywhere else
after on mysql gmaccount find your id (a number for identify account) and enter it in account column in gm account
N.B.: id colomn is for indexing in gmaccount so can left it blank (auto completion)