Knight Online Panel (Web) and Game Database Synchronization Problems
In Knight Online pvp servers, the web panel (Registration, Ranking, Pus/Max) and the game server directly use the same SQL Server database. Despite opening a new membership via the website, receiving an "ID or Password Wrong" error when entering the game or the Cash/KC amount received from the site not appearing in the game synchronization (data mismatch) is the problem. In this guide, we will examine the main causes and solutions of the problem.
Reason 1: Different Version (v1299 / v2xx) Table and Procedure Structures
The SQL tables triggered by the web panel you use when sending records to the database may not match the tables read by the game files.
Solution:
- Memberships in v1299 infrastructures are generally
TB_USERwhile recording in the table, in current databases v2xx and aboveACCOUNT_CHARorVERSION_DATAAdditional tables such as should also be filled in. - In the management folder of your web panel
config.phpor by opening the database settings file, check which procedure (Ex: `LOAD_USER_DATA` or `CREATE_NEW_ACCOUNT`) the panel triggers when pressing membership and whether this procedure is available in SQL Server.
Reason 2: SQL Server Remote Connection Permissions
If the hosting/server where your website is hosted and your game server are at different IP addresses, your game server may be blocking data requests from the website for cyber security reasons.
Solution:
- Open SQL Server Management Studio, right-click on your server name and Properties say.
- Connections Switch to the tab and "Allow remote connections to this server" Verify that (Allow remote connections to this server) is checked.
- SQL Server's port to the external network through Windows Firewall 1433 Add an Inbound Rule to the port, allowing only your website's IP address.
Reason 3: MD5 Encryption Method Mismatches
Your web panel may be saving players' passwords to SQL as MD5 (encrypted hashes) to ensure security. However, if Ebenezer/DbAgent is programmed to read passwords in plain text, players cannot log in to the game.
- Turn off the MD5 encryption feature in your panel settings or use MD5 compatible (supported by soaps/guard) versions of your game exe files.
This article is specially prepared for PvPServer.
