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

Printable View

14-04-20
kenken1228

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
15-04-20
zgabrieldim

Re: Can't login :(

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

Re: Can't login :(

Quote:

Originally Posted by 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

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.
15-04-20
skronix

Re: Can't login :(

Quote:

Originally Posted by kenken1228

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.
15-04-20
zgabrieldim

Re: Can't login :(

Quote:

Originally Posted by kenken1228

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?
15-04-20
kenken1228

1 Attachment(s)

Re: Can't login :(

Quote:

Originally Posted by zgabrieldim

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 - - -

Quote:

Originally Posted by 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

here's my logs
16-04-20
samus

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

what files are u using?
16-04-20
zgabrieldim

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.
16-04-20
kenken1228

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?
16-04-20
zgabrieldim

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
16-04-20
kenken1228

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.
16-04-20
zgabrieldim

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
16-04-20
kenken1228

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.
16-04-20
zgabrieldim

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
16-04-20
kenken1228

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 :(
16-04-20
zgabrieldim

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.
17-04-20
kenken1228

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?
27-04-20
pierr32

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.
28-04-20
kenken1228

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.