Server Crashes and can't login with no errors when you do anything in game :(

[kenken1228]

Attachment 167046No errors in log, All database success and all worldsvr are running. Changed the magic key and client version in database and server. Changed IP and port in languange.enc. Added all ports in firewall. Tried disabling the firewall in Azure VM Centos7.7 and in windows. I tried everything :(

---edit---

I was able to login by disabling the VM centos firewall and adding an network inbound port rule in Azure VM but I have another problem. After I login I connect to the channel and do quests or kill mobs and level up or buy anything it doesn't save in to the database then it crashes when I try to select server or channel, then I have to cabal_restart again so I can login. but when I edit my character in the database everything saves like alz, cash, level, wexp.

--edit--

I found errors after the server crash. all I did was try to open the Warehouse and server crashes.

here are my logs

[MentaL]

[zgabrieldim]

What parameter are you passing to start your cabalmain on your start script? husky or breaklee?
husky -> edit language.enc
breaklee -> edit internal.txt

[kenken1228]

What parameter are you passing to start your cabalmain on your start script? husky or breaklee?
husky -> edit language.enc
breaklee -> edit internal.txt

I'm using husky I edited it already. update i reinstalled my server and I have another problem I disconnect every 5mins ingame I have to restart the server by using cabal_restart for me to login again.

[skronix]

I'm using husky I edited it already. update i reinstalled my server and I have another problem I disconnect every 5mins ingame I have to restart the server by using cabal_restart for me to login again.

Write the ID and Password from Team Viewer in a private message, I will help you.Write the ID and Password from Team Viewer in a private message, I will help you.

[zgabrieldim]

I'm using husky I edited it already. update i reinstalled my server and I have another problem I disconnect every 5mins ingame I have to restart the server by using cabal_restart for me to login again.

Did you find any errors on your logs? Are all services going down or just the WorldSvr? Do you think the machine running your server cannot handle it? Maybe because of your network?

[kenken1228]

Did you find any errors on your logs? Are all services going down or just the WorldSvr? Do you think the machine running your server cannot handle it? Maybe because of your network?

I don't think so? I tried a machine with 32gb ram and 8cpu but still the same. When I'm running it on VB with just 2GB ram the channel doesn't crash. but when I run it on Azure it disconnects. Oh and another things is when I quest and hit mobs and levelup or buy anything it doesn't go save from the database. when I relog it's still level 1 with no experience gained or anything. When I edit my character on the database like give 15b alz ang make my level 200 it saves. when I login it's level 200 and with 15b alz.

- - - Updated - - -

What parameter are you passing to start your cabalmain on your start script? husky or breaklee?
husky -> edit language.enc
breaklee -> edit internal.txt

here's my logs

[samus]

what files are u using?

[zgabrieldim]

I see most of the errors come from stored proc executions, can you double check if you have loaded all the databases in your sql server? Probably check in your sql server why the stored procedures are failing.

[kenken1228]

what files are u using?

I'm using toast repack + CabalPilipinas posted by Draven

- - - Updated - - -

I see most of the errors come from stored proc executions, can you double check if you have loaded all the databases in your sql server? Probably check in your sql server why the stored procedures are failing.

how do I do that? I'm sorry I just started last week I don't know much of these yet. how can I check if it's all loaded?

[zgabrieldim]

I use my sql client to access my database and check if the databases are loaded correctly in the schema browser. This thread from AzureSensei might also help you. https://forum.ragezone.com/f460/cent...-1144251/these databases should be ready, * Account* Authentication* CabalCash* CabalGuild* EventData* Netcafebilling* Server01

[kenken1228]

what do you mean sql client? Mine I use SSMS to edit my databases? sorry if I don't understand you quite well sometimes.

[zgabrieldim]

Ahh, yes. SSMS is your sql client, I use different sql client. but probably something similar to this.

[kenken1228]

It's all loaded, I can edit all the tables like alz, warexp, level, cash, and everything and login successfully ingame but after a few minutes the server crashes.

[zgabrieldim]

Have you checked the stored failing stored procedures that can be found in your logs?
ex: cabal_sp_SetNetCafeTPoint

[kenken1228]

not yet. I don't know what to do with them :(