1 Attachment(s)
Server Crashes and can't login with no errors when you do anything in game :(
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
Re: Server Crashes and can't login with no errors when you do anything in game :(
Re: Server Crashes and can't login with no errors when you do anything in game :(
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.
Re: Server Crashes and can't login with no errors when you do anything in game :(
Quote:
Originally Posted by
samus
what files are u using?
I'm using toast repack + CabalPilipinas posted by Draven
- - - Updated - - -
Quote:
Originally Posted by
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.
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?
Re: Server Crashes and can't login with no errors when you do anything in game :(
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
Re: Server Crashes and can't login with no errors when you do anything in game :(
what do you mean sql client? Mine I use SSMS to edit my databases? sorry if I don't understand you quite well sometimes.
Re: Server Crashes and can't login with no errors when you do anything in game :(
Ahh, yes. SSMS is your sql client, I use different sql client. but probably something similar to this.
https://i.ibb.co/8chmkq2/Capture2.png
https://ibb.co/0y9bTV8
Re: Server Crashes and can't login with no errors when you do anything in game :(
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.
Re: Server Crashes and can't login with no errors when you do anything in game :(
Have you checked the stored failing stored procedures that can be found in your logs?
ex: cabal_sp_SetNetCafeTPoint
Re: Server Crashes and can't login with no errors when you do anything in game :(
not yet. I don't know what to do with them :(