How to make server (New version)

[geralex88]

Well, matching the server and client data seems to take a very long time.
I can't guarantee when it will start and when it will be completed.
The amount of data is huge.
Anyways, I'll work on it as time permits.

You can make a script that will generate data, this will reduce the time many times over. An example of the formation of one of the file, I load the data into the database, then I form a new file through the selection script.

RODB-Addition.sql

select
ID,TYPE,DISPOSITION,INTERVAL,EFFECTDURATION,
[Function] = cast (isnull(Define1,0) as varchar(max)) + ',' + cast (isnull(Define2,0) as varchar(max)) + ',' + cast (isnull(Define3,0) as varchar(max)) + ',' + cast (isnull(Define4,0) as varchar(max)) + ','
+ cast (isnull(Define5,0) as varchar(max)) + ',' + cast (isnull(Define6,0) as varchar(max)) + ',' + cast (isnull(Define7,0) as varchar(max)) + ','
+ cast (isnull(Define8,0) as varchar(max)) + ',' + cast (isnull(Define9,0) as varchar(max)) + ',' + cast (isnull(Define10,0) as varchar(max)),
[VALUE] = cast (isnull(Value1,0) as varchar(max)) + ',' + cast (isnull(Value2,0) as varchar(max)) + ',' + cast (isnull(Value3,0) as varchar(max)) + ',' + cast (isnull(Value4,0) as varchar(max)) + ','
+ cast (isnull(Value5,0) as varchar(max)) + ',' + cast (isnull(Value6,0) as varchar(max)) + ',' + cast (isnull(Value7,0) as varchar(max)) + ','
+ cast (isnull(Value8,0) as varchar(max)) + ',' + cast (isnull(Value9,0) as varchar(max)) + ',' + cast (isnull(Value10,0) as varchar(max))
from dbo.Addition$
order by id
for xml RAW ('Row'), type, elements, root ('Database')

 

[airmusic]

Did you test it in win10 or win11 if work?

win11 is ok

 

[Kang Jinsu]

Error in SQL Server :0

[SQL]Error on query:INSERT INTO login(username,password,sex,lastlogin) VALUES ('DK00007','8811c5285e34e2e3319ab7d9f2cfa5b',1,'2023-09-04 오후 3:03:19')
[SQL]테이블 'rg2db.dbo.login', 열 'Banned'에 NULL 값을 삽입할 수 없습니다. 열에는 NULL을 사용할 수 없습니다. INSERT이(가) 실패했습니다.
문이 종료되었습니다.
위치: System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
위치: System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
위치: System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
위치: System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
위치: System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
위치: System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
위치: SagaDB.MSSQLOperator.ExeSql(String sql) 파일 c:\SagaRO2-master\SagaDB\MSSQLOperator.cs:줄 138

[Error]개체 참조가 개체의 인스턴스로 설정되지 않았습니다.
위치: SagaLogin.LoginClient.OnSendLogin(SendLogin p) 파일 c:\SagaRO2-master\SagaLogin\LoginClient.cs:줄 208

(It is fix. in Login table, change `[Banned] [tinyint] NOT NULL DEFAULT 0` )



And, when i create character.

[SQL]Error on query:INSERT INTO chardata(account_id,name,face,details,sex,race,job,cEXP,jEXP,cLevel, jLevel , pendingDeletion , validationKey , HP , maxHP , SP , maxSP , LC , maxLC , LP , maxLP , str , dex , intel , con , luk , stpoints , slots , weaponName , weaponType , GMLevel , mapID , worldID , x , y , z , sightRange , maxMoveRange , state , stance , guild , party , yaw , zeny , save_map , save_x , save_y , save_z ) VALUES (2,N'Kustale','0401020320','01010C010101',1,0,1,0,0,1,1,0,0,250,250,100,100,45,45,0,5,5,3,3,2,0,0,'00000032320100',N'Kustale',2,1,11,1,-17952,10144,96,6000,10000,0,NONE,0,0,0,0,0,0,0,0)
[SQL]열 이름 'NONE'이(가) 유효하지 않습니다.
위치: System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
위치: System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
위치: System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
위치: System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
위치: System.Data.SqlClient.SqlDataReader.get_MetaData()
위치: System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
위치: System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
위치: System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
위치: System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
위치: System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
위치: System.Data.SqlClient.SqlCommand.ExecuteReader()
위치: SagaDB.MSSQLOperator.ExeSql(String sql, Int32 a) 파일 c:\SagaRO2-master\SagaDB\MSSQLOperator.cs:줄 179

[SQL]Error on queryELETE FROM inventory WHERE charID=4294967295;INSERT INTO inventory ( charID , nameid , amount , creatorName , durability , equip ) VALUES(4294967295,16097,1,N'',0,-1);INSERT INTO inventory ( charID , nameid , amount , creatorName , durability , equip ) VALUES(4294967295,16061,1,N'',0,-1);
[SQL]expression을(를) 데이터 형식 int(으)로 변환하는 중 산술 오버플로 오류가 발생했습니다.
expression을(를) 데이터 형식 int(으)로 변환하는 중 산술 오버플로 오류가 발생했습니다.
문이 종료되었습니다.
문이 종료되었습니다.
위치: System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
위치: System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
위치: System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
위치: System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
위치: System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
위치: System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
위치: SagaDB.MSSQLOperator.ExeSql(String sql) 파일 c:\SagaRO2-master\SagaDB\MSSQLOperator.cs:줄 138

[SQL]Error on queryELETE FROM weapon WHERE charID=4294967295;INSERT INTO weapon ( charID , name , level , type , augeSkillID , exp , durability , U1 , active , slot1 , slot2 , slot3 , slot4 , slot5 , slot6 ) VALUES(4294967295,N'Kustale',1,1,150001,0,1800,1,1,0,0,0,0,0,0);
[SQL]expression을(를) 데이터 형식 int(으)로 변환하는 중 산술 오버플로 오류가 발생했습니다.
문이 종료되었습니다.
위치: System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
위치: System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
위치: System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
위치: System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
위치: System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
위치: System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
위치: SagaDB.MSSQLOperator.ExeSql(String sql) 파일 c:\SagaRO2-master\SagaDB\MSSQLOperator.cs:줄 138

[SQL]Error on queryELETE FROM skills WHERE charID=4294967295;INSERT INTO skills ( charID , type , skillID , exp , slot ) VALUES(4294967295,0,1406901,0,0);
[SQL]expression을(를) 데이터 형식 int(으)로 변환하는 중 산술 오버플로 오류가 발생했습니다.
문이 종료되었습니다.
위치: System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
위치: System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
위치: System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
위치: System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
위치: System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
위치: System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
위치: SagaDB.MSSQLOperator.ExeSql(String sql) 파일 c:\SagaRO2-master\SagaDB\MSSQLOperator.cs:줄 138

 

[geralex88]

Error in SQL Server :0

[SQL]Error on query:INSERT INTO login(username,password,sex,lastlogin) VALUES ('DK00007','8811c5285e34e2e3319ab7d9f2cfa5b',1,'2023-09-04 오후 3:03:19')
[SQL]테이블 'rg2db.dbo.login', 열 'Banned'에 NULL 값을 삽입할 수 없습니다. 열에는 NULL을 사용할 수 없습니다. INSERT이(가) 실패했습니다.
문이 종료되었습니다.
위치: System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
위치: System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
위치: System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
위치: System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
위치: System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
위치: System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
위치: SagaDB.MSSQLOperator.ExeSql(String sql) 파일 c:\SagaRO2-master\SagaDB\MSSQLOperator.cs:줄 138

[Error]개체 참조가 개체의 인스턴스로 설정되지 않았습니다.
위치: SagaLogin.LoginClient.OnSendLogin(SendLogin p) 파일 c:\SagaRO2-master\SagaLogin\LoginClient.cs:줄 208

(It is fix. in Login table, change `[Banned] [tinyint] NOT NULL DEFAULT 0` )



And, when i create character.

[SQL]Error on query:INSERT INTO chardata(account_id,name,face,details,sex,race,job,cEXP,jEXP,cLevel, jLevel , pendingDeletion , validationKey , HP , maxHP , SP , maxSP , LC , maxLC , LP , maxLP , str , dex , intel , con , luk , stpoints , slots , weaponName , weaponType , GMLevel , mapID , worldID , x , y , z , sightRange , maxMoveRange , state , stance , guild , party , yaw , zeny , save_map , save_x , save_y , save_z ) VALUES (2,N'Kustale','0401020320','01010C010101',1,0,1,0,0,1,1,0,0,250,250,100,100,45,45,0,5,5,3,3,2,0,0,'00000032320100',N'Kustale',2,1,11,1,-17952,10144,96,6000,10000,0,NONE,0,0,0,0,0,0,0,0)
[SQL]열 이름 'NONE'이(가) 유효하지 않습니다.
위치: System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
위치: System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
위치: System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
위치: System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
위치: System.Data.SqlClient.SqlDataReader.get_MetaData()
위치: System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
위치: System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
위치: System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
위치: System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
위치: System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
위치: System.Data.SqlClient.SqlCommand.ExecuteReader()
위치: SagaDB.MSSQLOperator.ExeSql(String sql, Int32 a) 파일 c:\SagaRO2-master\SagaDB\MSSQLOperator.cs:줄 179

[SQL]Error on queryELETE FROM inventory WHERE charID=4294967295;INSERT INTO inventory ( charID , nameid , amount , creatorName , durability , equip ) VALUES(4294967295,16097,1,N'',0,-1);INSERT INTO inventory ( charID , nameid , amount , creatorName , durability , equip ) VALUES(4294967295,16061,1,N'',0,-1);
[SQL]expression을(를) 데이터 형식 int(으)로 변환하는 중 산술 오버플로 오류가 발생했습니다.
expression을(를) 데이터 형식 int(으)로 변환하는 중 산술 오버플로 오류가 발생했습니다.
문이 종료되었습니다.
문이 종료되었습니다.
위치: System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
위치: System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
위치: System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
위치: System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
위치: System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
위치: System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
위치: SagaDB.MSSQLOperator.ExeSql(String sql) 파일 c:\SagaRO2-master\SagaDB\MSSQLOperator.cs:줄 138

[SQL]Error on queryELETE FROM weapon WHERE charID=4294967295;INSERT INTO weapon ( charID , name , level , type , augeSkillID , exp , durability , U1 , active , slot1 , slot2 , slot3 , slot4 , slot5 , slot6 ) VALUES(4294967295,N'Kustale',1,1,150001,0,1800,1,1,0,0,0,0,0,0);
[SQL]expression을(를) 데이터 형식 int(으)로 변환하는 중 산술 오버플로 오류가 발생했습니다.
문이 종료되었습니다.
위치: System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
위치: System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
위치: System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
위치: System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
위치: System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
위치: System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
위치: SagaDB.MSSQLOperator.ExeSql(String sql) 파일 c:\SagaRO2-master\SagaDB\MSSQLOperator.cs:줄 138

[SQL]Error on queryELETE FROM skills WHERE charID=4294967295;INSERT INTO skills ( charID , type , skillID , exp , slot ) VALUES(4294967295,0,1406901,0,0);
[SQL]expression을(를) 데이터 형식 int(으)로 변환하는 중 산술 오버플로 오류가 발생했습니다.
문이 종료되었습니다.
위치: System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
위치: System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
위치: System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
위치: System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
위치: System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
위치: System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
위치: SagaDB.MSSQLOperator.ExeSql(String sql) 파일 c:\SagaRO2-master\SagaDB\MSSQLOperator.cs:줄 138

Use MySQL...
MSSQL needs to adapt the code to the database structure

 

[RelliuG]

Kang Jinsu Firstly, your posts are simply excellent, congratulations.

I know it's been a long time since your post, I also know that maybe everyone is at other points in their lives.
But I wanted to ask for help, I did all the steps and managed to configure the server in the same way as in the tutorial.
When trying to connect to the "Saga.Authentication" server it does not respond to "Saga.Gateway", even with the settings as described.

What could be happening?

If anyone could help me I would be very grateful.
Thank you guys

RelliuG

 

[Kang Jinsu]

Kang Jinsu Firstly, your posts are simply excellent, congratulations.

I know it's been a long time since your post, I also know that maybe everyone is at other points in their lives.
But I wanted to ask for help, I did all the steps and managed to configure the server in the same way as in the tutorial.
When trying to connect to the "Saga.Authentication" server it does not respond to "Saga.Gateway", even with the settings as described.

What could be happening?

If anyone could help me I would be very grateful.
Thank you guys

RelliuG

Do you use

You must be registered to see links

server? :0

Well this server program is old, doesn't work well for this client and is different from the server in my description. :0
Use

You must be registered to see links

.
Use description

You must be registered to see links

 

[RelliuG]

Do you use

You must be registered to see links

server? :0

Well this server program is old, doesn't work well for this client and is different from the server in my description. :0
Use

You must be registered to see links

.
Use description

You must be registered to see links

No, I've already tested all the options hahaha
But I didn't get this review from this repository, I'll test it.

Regarding your recommendation, I used this version too and followed your tutorial.

I will repeat all the tests using the repositories you recommended.

I'll report here if I managed it or if I have any further doubts.
Thank you for your help.

Do you know how I can fix this?

It stays there infinitely upon login, I believe I need to define this client in the emulator, unfortunately I don't know how

 

[Kang Jinsu]

No, I've already tested all the options hahaha
But I didn't get this review from this repository, I'll test it.

Regarding your recommendation, I used this version too and followed your tutorial.

I will repeat all the tests using the repositories you recommended.

I'll report here if I managed it or if I have any further doubts.
Thank you for your help.

Do you know how I can fix this?

It stays there infinitely upon login, I believe I need to define this client in the emulator, unfortunately I don't know how

Well I don't know about this problem. :0
I tested it again today and it works fine.
Contact @galarex88. (I only edit the client.
The server was not created by me)

 

[RelliuG]

Well I don't know about this problem. :0
I tested it again today and it works fine.
Contact @galarex88. (I only edit the client.
The server was not created by me)

When I use the server you recommend in your tutorial, I have the following problems:
1 - Error in the map server console;
2 - Error in the authentication server console;
3 - In the log files, it says that it did not connect to the database, however this connection exists as you can see in the screenshot;
4 - The gateway server does not communicate with the authentication;
5 - When connecting to the game, it presents this error, which I believe is derived from all of this.

I will send the other prints in the second post.

If geralex88 could help me, I would be very grateful.

When I use the server you recommend in your tutorial, I have the following problems:
1 - Error in the map server console;
2 - Error in the authentication server console;
3 - In the log files, it says that it did not connect to the database, however this connection exists as you can see in the screenshot;
4 - The gateway server does not communicate with the authentication;
5 - When connecting to the game, it presents this error, which I believe is derived from all of this.

I will send the other prints in the second post.

If geralex88 could help me, I would be very grateful.

continuing the prints.

 

[geralex88]

When I use the server you recommend in your tutorial, I have the following problems:
1 - Error in the map server console;
2 - Error in the authentication server console;
3 - In the log files, it says that it did not connect to the database, however this connection exists as you can see in the screenshot;
4 - The gateway server does not communicate with the authentication;
5 - When connecting to the game, it presents this error, which I believe is derived from all of this.

I will send the other prints in the second post.

If geralex88 could help me, I would be very grateful.


continuing the prints.

According to the logs, there was an error connecting or working with the database. Has the database been created? Is the structure loaded with scripts?

 

[RelliuG]

According to the logs, there was an error connecting or working with the database. Has the database been created? Is the structure loaded with scripts?

Yes, in the screenshot "BD_connection.png" you can see the database "sagarev" and existing tables.
I displayed the "Processes" tab to show that the server instances were connected to the database, which does not explain what is being displayed in the logs.

 

[geralex88]

Yes, in the screenshot "BD_connection.png" you can see the database "sagarev" and existing tables.
I displayed the "Processes" tab to show that the server instances were connected to the database, which does not explain what is being displayed in the logs.

What version of the DBMS are you using (MySQL/MariaDB)?
I'll try to check it myself.

 

[RelliuG]

What version of the DBMS are you using (MySQL/MariaDB)?
I'll try to check it myself.

MariaDB

 

[geralex88]

MariaDB

Version?

 

[RelliuG]

Version?

10.11.3

 

[geralex88]

10.11.3

Most likely the problem is in this code: *\saga-revised\Abstraction\Saga.Authentication.Data.Mysql\MysqlProvider.Setup.cs

            //CREATE 5 CONNECTIONS
            for (int i = 0; i < info.pooledconnections; i++)
            {
                try
                {
                    __dbtracelog.WriteLine("database", "Creating database connection: {0}", i);
                    __dbtracelog.WriteInformation("database", "Creating database connection: {0}", i);
                    MySqlConnectionStringBuilder cb = new MySqlConnectionStringBuilder();
                    cb.UserID = info.username;
                    cb.Password = info.password;
                    cb.Port = info.port;
                    cb.Server = info.host;
                    cb.Database = info.database;

                    MySqlConnection conn = new MySqlConnection(cb.ConnectionString);
                    conn.Open();
                    System.Threading.Timer myTimer = new System.Threading.Timer(callback, conn, 300000, 300000);
                    ConnectionPool.Release(conn);

It is necessary to rewrite the database connection check or change MariaDB to MySQL >5.0
Because the emulator was written many years ago and has not been updated for new versions of the DBMS.

 

[RelliuG]

Most likely the problem is in this code: *\saga-revised\Abstraction\Saga.Authentication.Data.Mysql\MysqlProvider.Setup.cs

            //CREATE 5 CONNECTIONS
            for (int i = 0; i < info.pooledconnections; i++)
            {
                try
                {
                    __dbtracelog.WriteLine("database", "Creating database connection: {0}", i);
                    __dbtracelog.WriteInformation("database", "Creating database connection: {0}", i);
                    MySqlConnectionStringBuilder cb = new MySqlConnectionStringBuilder();
                    cb.UserID = info.username;
                    cb.Password = info.password;
                    cb.Port = info.port;
                    cb.Server = info.host;
                    cb.Database = info.database;

                    MySqlConnection conn = new MySqlConnection(cb.ConnectionString);
                    conn.Open();
                    System.Threading.Timer myTimer = new System.Threading.Timer(callback, conn, 300000, 300000);
                    ConnectionPool.Release(conn);

It is necessary to rewrite the database connection check or change MariaDB to MySQL >5.0
Because the emulator was written many years ago and has not been updated for new versions of the DBMS.

Understood, I'm going to do a test using the version of MySQL as you recommended. I'll give you feedback here.
Thank you very much for the help.

Most likely the problem is in this code: *\saga-revised\Abstraction\Saga.Authentication.Data.Mysql\MysqlProvider.Setup.cs

            //CREATE 5 CONNECTIONS
            for (int i = 0; i < info.pooledconnections; i++)
            {
                try
                {
                    __dbtracelog.WriteLine("database", "Creating database connection: {0}", i);
                    __dbtracelog.WriteInformation("database", "Creating database connection: {0}", i);
                    MySqlConnectionStringBuilder cb = new MySqlConnectionStringBuilder();
                    cb.UserID = info.username;
                    cb.Password = info.password;
                    cb.Port = info.port;
                    cb.Server = info.host;
                    cb.Database = info.database;

                    MySqlConnection conn = new MySqlConnection(cb.ConnectionString);
                    conn.Open();
                    System.Threading.Timer myTimer = new System.Threading.Timer(callback, conn, 300000, 300000);
                    ConnectionPool.Release(conn);

It is necessary to rewrite the database connection check or change MariaDB to MySQL >5.0
Because the emulator was written many years ago and has not been updated for new versions of the DBMS.

Get with your recommendations for getting the servers online and communicating, thank you very much for this help.
Now my problem is different.
I use the client made available here by Kang Jinsu and when opening and logging in, an error appears in the client and the game closes, also when trying to log in with the _M option, it does not create the user in the database. What could it be now?
The logs are below.

 

[Kang Jinsu]

Understood, I'm going to do a test using the version of MySQL as you recommended. I'll give you feedback here.
Thank you very much for the help.


Get with your recommendations for getting the servers online and communicating, thank you very much for this help.
Now my problem is different.
I use the client made available here by Kang Jinsu and when opening and logging in, an error appears in the client and the game closes, also when trying to log in with the _M option, it does not create the user in the database. What could it be now?
The logs are below.

See that error:

RagII on Windows 10 (Can run up to Windows XP [maybe?])

You must be registered for see element. Thanks Endreo22, geralax88, LightRO3, Viserion. :sleep: Compiling this client on Windows 10 (Originally, I worked on XP in a virtual machine, but it was very slow because it was a virtual machine. And 3D is not supported...) [I bought a computer.] It...

forum.ragezone.com

+ This is what happens when you create a character on this server.

And the server is not created with ID_M.
There was a tutorial for my old server, And there was a web script to create an account, but... all the files were deleted due to Google Drive exceeding capacity.
So I recommend this server.

You must be registered to see links

Sorry for not being able to help you. :,(

 

[geralex88]

If you use a client from source code, then you need to use a modified version of the server for it.
Example:

You must be registered to see links

or

You must be registered to see links

 

[RelliuG]

See that error:

RagII on Windows 10 (Can run up to Windows XP [maybe?])

You must be registered for see element. Thanks Endreo22, geralax88, LightRO3, Viserion. :sleep: Compiling this client on Windows 10 (Originally, I worked on XP in a virtual machine, but it was very slow because it was a virtual machine. And 3D is not supported...) [I bought a computer.] It...

forum.ragezone.com

+ This is what happens when you create a character on this server.

And the server is not created with ID_M.
There was a tutorial for my old server, And there was a web script to create an account, but... all the files were deleted due to Google Drive exceeding capacity.
So I recommend this server.

You must be registered to see links

Sorry for not being able to help you. :,(

If you use a client from source code, then you need to use a modified version of the server for it.
Example:

You must be registered to see links

or

You must be registered to see links

I thank you two immensely for all your help, with everything we talked about here, I managed to get the revised version of the saga working.
But I will download these versions from geralex88 repository and test.
The client I'm using was the one posted by Kang Jinsu at the beginning of this topic.
I will read the post he recommended better and if you have a suggestion for a client already adapted to the versions of these repositories, I would appreciate it.
Thanks again for the help.