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 :(
Re: Server Crashes and can't login with no errors when you do anything in game :(
If the databases are loaded properly already as you checked in SMSS, I think you need to make sure that your services can connect to your database.
check IPs, Ports, Usernames, Passwords in the /etc/cabal/*.ini files.
Is your database running on the same vm as your services? (to eliminate the network issues)
I've seen this in your logs,
[Wed Apr 15 2020 16:42:49.617325 4097772352]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]Read from SQL server failed.[Wed Apr 15 2020 16:42:49.617377 4097772352]: [##ERROR##] DB ERROR(CODE) : 20004[Wed Apr 15 2020 16:42:49.617388 4097772352]: [##ERROR##] DB ERROR(VAR_INFO) : [Wed Apr 15 2020 16:42:49.617397 4097772352]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
DB ERROR(SQLSTATE) : 08S01 -> Google says that this is a connection failure.
Re: Server Crashes and can't login with no errors when you do anything in game :(
I've set all the right IPs, Ports, Username and Password in all of my .ini files. What do you mean is my database running on the same VM? Yes I think I'm only using one VM the IP of the VM and the Database is the same so yeah? Do I need to separate them? I don't understand why when I tried it offline it doesn't have any errors. Do you have email that we can exchange messages?
Re: Server Crashes and can't login with no errors when you do anything in game :(
Wed Apr 15 2020 15:52 ===== *&&&&* bad Paket key >> Invalid CharIdx no pUserCtx to inject in ChatNode
EventMgr get Wrong Paket Key, GlobalDBAgent is Connected with DB but the FreeTds say Read From SQL is ERROR
[##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]Read from SQL server failed.
Re: Server Crashes and can't login with no errors when you do anything in game :(
I fixed it. Azure VM can't handle a using 1 VM for server and database. I fixed the error by installing the dabatase and the server with two seperate VMs. In contabo vps I have no problem using only 1 VPS with the server and database, but 3gb ram with 2cpu can't handle 20 channels. just 5-8 channels i guess.