Titan scrie: ↑14 Mar 2021, 20:38 Destul de interesant, eu unul nu am încercat niciodată să configurez un server pe google cloud, din ce auzisem trebuiau făcute câteva modificări ca să funcționeze..

Poți să încerci să vorbești cu // știu că el configura servere google contra cost.. mai e și // dar nu stiu daca are timp sa te ajute

Dacă am timp o să configurez eu unul zilele astea să văd ce și cum și te ajut cu plăcere dacă nu-i dai de cap până atunci.

skrydll scrie: ↑14 Mar 2021, 17:33

hugeness scrie: ↑14 Mar 2021, 17:29

skrydll scrie: ↑14 Mar 2021, 16:04

Degeaba. Aceeasi problema.

Edit: Am mai obervat ceva. Cand dau sh start.sh server-ul porneste si ramane activ in PS / HTOP, dar cand dau service mysql-server status imi zice ca is not running, dar conexiunea la Website si Server o face si in loguri nu imi zice imi apare ca nu se conecteaza, ba din contra ca connection succesful.

Verifica log-urile la sql, cele din /var/db nu game. Vezi exact de ce isi da close la socket pentru ca probabil ceva iti da kill la pid.

210314 16:15:52 mysqld_safe mysqld from pid file /var/db/mysql/freebsd.pid ended
210314 16:16:26 mysqld_safe Logging to '/var/db/mysql/metin2khserver.err'.
210314 16:16:26 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2021-03-14 16:16:26 0

!

TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2021-03-14 16:16:26 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.51) starting as process 815 ... 2021-03-14 16:16:26 815 [Note] Plugin 'FEDERATED' is disabled. 2021-03-14 16:16:26 815 [Note] InnoDB: Using atomics to ref count buffer pool pages 2021-03-14 16:16:26 815 [Note] InnoDB: The InnoDB memory heap is disabled 2021-03-14 16:16:26 815 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-03-14 16:16:26 815 [Note] InnoDB: Memory barrier is not used 2021-03-14 16:16:26 815 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-03-14 16:16:26 815 [Note] InnoDB: Using CPU crc32 instructions 2021-03-14 16:16:26 815 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2021-03-14 16:16:26 815 [Note] InnoDB: Completed initialization of buffer pool 2021-03-14 16:16:26 815 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created! 2021-03-14 16:16:26 815 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB 2021-03-14 16:16:26 815 [Note] InnoDB: Database physically writes the file full: wait... 2021-03-14 16:16:27 815 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB 2021-03-14 16:16:27 815 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB 2021-03-14 16:16:27 815 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2021-03-14 16:16:27 815 ! InnoDB: New log files created, LSN=45781 2021-03-14 16:16:27 815 [Note] InnoDB: Doublewrite buffer not found: creating new 2021-03-14 16:16:27 815 [Note] InnoDB: Doublewrite buffer created 2021-03-14 16:16:27 815 [Note] InnoDB: 128 rollback segment(s) are active. 2021-03-14 16:16:27 815 ! InnoDB: Creating foreign key constraint system tables. 2021-03-14 16:16:27 815 [Note] InnoDB: Foreign key constraint system tables created 2021-03-14 16:16:27 815 [Note] InnoDB: Creating tablespace and datafile system tables. 2021-03-14 16:16:27 815 [Note] InnoDB: Tablespace and datafile system tables created. 2021-03-14 16:16:27 815 [Note] InnoDB: Waiting for purge to start 2021-03-14 16:16:27 815 [Note] InnoDB: 5.6.51 started; log sequence number 0 2021-03-14 16:16:27 815 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work. 2021-03-14 16:16:27 815 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work. 2021-03-14 16:16:27 815 [Note] Server hostname (bind-address): '*'; port: 3306 2021-03-14 16:16:27 815 [Note] IPv6 is available. 2021-03-14 16:16:27 815 [Note] - '::' resolves to '::'; 2021-03-14 16:16:27 815 [Note] Server socket created on IP: '::'. 2021-03-14 16:16:27 815 ! Insecure configuration for --pid-file: Location '/var/db/mysql' in the path is accessible to all OS users. Consider choosing a different directory. 2021-03-14 16:16:28 815 [Note] Event Scheduler: Loaded 0 events 2021-03-14 16:16:28 815 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '5.6.51' socket: '/tmp/mysql.sock' port: 3306 Source distribution 2021-03-14 16:19:57 815 ! IP address '35.198.135.30' has been resolved to the host name '30.135.198.35.bc.googleusercontent.com', which resembles IPv4-address itself. 2021-03-14 16:19:57 815 ! IP address '35.198.135.30' has been resolved to the host name '30.135.198.35.bc.googleusercontent.com', which resembles IPv4-address itself. 2021-03-14 16:20:10 815 ! IP address '35.198.135.30' has been resolved to the host name '30.135.198.35.bc.googleusercontent.com', which resembles IPv4-address itself. 2021-03-14 16:20:10 815 ! IP address '35.198.135.30' has been resolved to the host name '30.135.198.35.bc.googleusercontent.com', which resembles IPv4-address itself. 2021-03-14 16:20:10 815 ! IP address '35.198.135.30' has been resolved to the host name '30.135.198.35.bc.googleusercontent.com', which resembles IPv4-address itself. 2021-03-14 16:20:10 815 ! IP address '35.198.135.30' has been resolved to the host name '30.135.198.35.bc.googleusercontent.com', which resembles IPv4-address itself. 2021-03-14 16:29:33 815 [Warning] IP address '185.176.222.74' has been resolved to the host name '215522.2cloud.eu', which resembles IPv4-address itself. 2021-03-14 17:04:58 815 [Warning] IP address '35.198.135.30' has been resolved to the host name '30.135.198.35.bc.googleusercontent.com', which resembles IPv4-address itself. 2021-03-14 17:04:58 815 [Warning] IP address '35.198.135.30' has been resolved to the host name '30.135.198.35.bc.googleusercontent.com', which resembles IPv4-address itself. 2021-03-14 17:04:58 815 [Warning] IP address '35.198.135.30' has been resolved to the host name '30.135.198.35.bc.googleusercontent.com', which resembles IPv4-address itself. 2021-03-14 17:04:58 815 [Warning] IP address '35.198.135.30' has been resolved to the host name '30.135.198.35.bc.googleusercontent.com', which resembles IPv4-address itself.

hugeness scrie: ↑15 Mar 2021, 09:13

skrydll scrie: ↑14 Mar 2021, 17:33

hugeness scrie: ↑14 Mar 2021, 17:29
Verifica log-urile la sql, cele din /var/db nu game. Vezi exact de ce isi da close la socket pentru ca probabil ceva iti da kill la pid.

210314 16:15:52 mysqld_safe mysqld from pid file /var/db/mysql/freebsd.pid ended
210314 16:16:26 mysqld_safe Logging to '/var/db/mysql/metin2khserver.err'.
210314 16:16:26 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2021-03-14 16:16:26 0

!

TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2021-03-14 16:16:26 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.51) starting as process 815 ... 2021-03-14 16:16:26 815 [Note] Plugin 'FEDERATED' is disabled. 2021-03-14 16:16:26 815 [Note] InnoDB: Using atomics to ref count buffer pool pages 2021-03-14 16:16:26 815 [Note] InnoDB: The InnoDB memory heap is disabled 2021-03-14 16:16:26 815 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-03-14 16:16:26 815 [Note] InnoDB: Memory barrier is not used 2021-03-14 16:16:26 815 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-03-14 16:16:26 815 [Note] InnoDB: Using CPU crc32 instructions 2021-03-14 16:16:26 815 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2021-03-14 16:16:26 815 [Note] InnoDB: Completed initialization of buffer pool 2021-03-14 16:16:26 815 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created! 2021-03-14 16:16:26 815 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB 2021-03-14 16:16:26 815 [Note] InnoDB: Database physically writes the file full: wait... 2021-03-14 16:16:27 815 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB 2021-03-14 16:16:27 815 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB 2021-03-14 16:16:27 815 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2021-03-14 16:16:27 815 ! InnoDB: New log files created, LSN=45781 2021-03-14 16:16:27 815 [Note] InnoDB: Doublewrite buffer not found: creating new 2021-03-14 16:16:27 815 [Note] InnoDB: Doublewrite buffer created 2021-03-14 16:16:27 815 [Note] InnoDB: 128 rollback segment(s) are active. 2021-03-14 16:16:27 815 ! InnoDB: Creating foreign key constraint system tables. 2021-03-14 16:16:27 815 [Note] InnoDB: Foreign key constraint system tables created 2021-03-14 16:16:27 815 [Note] InnoDB: Creating tablespace and datafile system tables. 2021-03-14 16:16:27 815 [Note] InnoDB: Tablespace and datafile system tables created. 2021-03-14 16:16:27 815 [Note] InnoDB: Waiting for purge to start 2021-03-14 16:16:27 815 [Note] InnoDB: 5.6.51 started; log sequence number 0 2021-03-14 16:16:27 815 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work. 2021-03-14 16:16:27 815 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work. 2021-03-14 16:16:27 815 [Note] Server hostname (bind-address): '*'; port: 3306 2021-03-14 16:16:27 815 [Note] IPv6 is available. 2021-03-14 16:16:27 815 [Note] - '::' resolves to '::'; 2021-03-14 16:16:27 815 [Note] Server socket created on IP: '::'. 2021-03-14 16:16:27 815 ! Insecure configuration for --pid-file: Location '/var/db/mysql' in the path is accessible to all OS users. Consider choosing a different directory. 2021-03-14 16:16:28 815 [Note] Event Scheduler: Loaded 0 events 2021-03-14 16:16:28 815 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '5.6.51' socket: '/tmp/mysql.sock' port: 3306 Source distribution 2021-03-14 16:19:57 815 ! IP address '35.198.135.30' has been resolved to the host name '30.135.198.35.bc.googleusercontent.com', which resembles IPv4-address itself. 2021-03-14 16:19:57 815 ! IP address '35.198.135.30' has been resolved to the host name '30.135.198.35.bc.googleusercontent.com', which resembles IPv4-address itself. 2021-03-14 16:20:10 815 ! IP address '35.198.135.30' has been resolved to the host name '30.135.198.35.bc.googleusercontent.com', which resembles IPv4-address itself. 2021-03-14 16:20:10 815 ! IP address '35.198.135.30' has been resolved to the host name '30.135.198.35.bc.googleusercontent.com', which resembles IPv4-address itself. 2021-03-14 16:20:10 815 ! IP address '35.198.135.30' has been resolved to the host name '30.135.198.35.bc.googleusercontent.com', which resembles IPv4-address itself. 2021-03-14 16:20:10 815 ! IP address '35.198.135.30' has been resolved to the host name '30.135.198.35.bc.googleusercontent.com', which resembles IPv4-address itself. 2021-03-14 16:29:33 815 [Warning] IP address '185.176.222.74' has been resolved to the host name '215522.2cloud.eu', which resembles IPv4-address itself. 2021-03-14 17:04:58 815 [Warning] IP address '35.198.135.30' has been resolved to the host name '30.135.198.35.bc.googleusercontent.com', which resembles IPv4-address itself. 2021-03-14 17:04:58 815 [Warning] IP address '35.198.135.30' has been resolved to the host name '30.135.198.35.bc.googleusercontent.com', which resembles IPv4-address itself. 2021-03-14 17:04:58 815 [Warning] IP address '35.198.135.30' has been resolved to the host name '30.135.198.35.bc.googleusercontent.com', which resembles IPv4-address itself. 2021-03-14 17:04:58 815 [Warning] IP address '35.198.135.30' has been resolved to the host name '30.135.198.35.bc.googleusercontent.com', which resembles IPv4-address itself.

Poti incerca sa pornesti mysql folosind skip name resolve, incearca sa inchizi serverul pentru orice conexiune externa inafara de ip-ul tau. Baiul nu e din cauza la game server, ceva se intampla cu db ul.

[ Postat de pe iPhone ]

skrydll scrie: ↑15 Mar 2021, 09:59

hugeness scrie: ↑15 Mar 2021, 09:13

skrydll scrie: ↑14 Mar 2021, 17:33

210314 16:15:52 mysqld_safe mysqld from pid file /var/db/mysql/freebsd.pid ended
210314 16:16:26 mysqld_safe Logging to '/var/db/mysql/metin2khserver.err'.
210314 16:16:26 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2021-03-14 16:16:26 0

!

TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2021-03-14 16:16:26 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.51) starting as process 815 ... 2021-03-14 16:16:26 815 [Note] Plugin 'FEDERATED' is disabled. 2021-03-14 16:16:26 815 [Note] InnoDB: Using atomics to ref count buffer pool pages 2021-03-14 16:16:26 815 [Note] InnoDB: The InnoDB memory heap is disabled 2021-03-14 16:16:26 815 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-03-14 16:16:26 815 [Note] InnoDB: Memory barrier is not used 2021-03-14 16:16:26 815 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-03-14 16:16:26 815 [Note] InnoDB: Using CPU crc32 instructions 2021-03-14 16:16:26 815 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2021-03-14 16:16:26 815 [Note] InnoDB: Completed initialization of buffer pool 2021-03-14 16:16:26 815 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created! 2021-03-14 16:16:26 815 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB 2021-03-14 16:16:26 815 [Note] InnoDB: Database physically writes the file full: wait... 2021-03-14 16:16:27 815 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB 2021-03-14 16:16:27 815 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB 2021-03-14 16:16:27 815 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2021-03-14 16:16:27 815 ! InnoDB: New log files created, LSN=45781 2021-03-14 16:16:27 815 [Note] InnoDB: Doublewrite buffer not found: creating new 2021-03-14 16:16:27 815 [Note] InnoDB: Doublewrite buffer created 2021-03-14 16:16:27 815 [Note] InnoDB: 128 rollback segment(s) are active. 2021-03-14 16:16:27 815 ! InnoDB: Creating foreign key constraint system tables. 2021-03-14 16:16:27 815 [Note] InnoDB: Foreign key constraint system tables created 2021-03-14 16:16:27 815 [Note] InnoDB: Creating tablespace and datafile system tables. 2021-03-14 16:16:27 815 [Note] InnoDB: Tablespace and datafile system tables created. 2021-03-14 16:16:27 815 [Note] InnoDB: Waiting for purge to start 2021-03-14 16:16:27 815 [Note] InnoDB: 5.6.51 started; log sequence number 0 2021-03-14 16:16:27 815 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work. 2021-03-14 16:16:27 815 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work. 2021-03-14 16:16:27 815 [Note] Server hostname (bind-address): '*'; port: 3306 2021-03-14 16:16:27 815 [Note] IPv6 is available. 2021-03-14 16:16:27 815 [Note] - '::' resolves to '::'; 2021-03-14 16:16:27 815 [Note] Server socket created on IP: '::'. 2021-03-14 16:16:27 815 ! Insecure configuration for --pid-file: Location '/var/db/mysql' in the path is accessible to all OS users. Consider choosing a different directory. 2021-03-14 16:16:28 815 [Note] Event Scheduler: Loaded 0 events 2021-03-14 16:16:28 815 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '5.6.51' socket: '/tmp/mysql.sock' port: 3306 Source distribution 2021-03-14 16:19:57 815 ! IP address '35.198.135.30' has been resolved to the host name '30.135.198.35.bc.googleusercontent.com', which resembles IPv4-address itself. 2021-03-14 16:19:57 815 ! IP address '35.198.135.30' has been resolved to the host name '30.135.198.35.bc.googleusercontent.com', which resembles IPv4-address itself. 2021-03-14 16:20:10 815 ! IP address '35.198.135.30' has been resolved to the host name '30.135.198.35.bc.googleusercontent.com', which resembles IPv4-address itself. 2021-03-14 16:20:10 815 ! IP address '35.198.135.30' has been resolved to the host name '30.135.198.35.bc.googleusercontent.com', which resembles IPv4-address itself. 2021-03-14 16:20:10 815 ! IP address '35.198.135.30' has been resolved to the host name '30.135.198.35.bc.googleusercontent.com', which resembles IPv4-address itself. 2021-03-14 16:20:10 815 ! IP address '35.198.135.30' has been resolved to the host name '30.135.198.35.bc.googleusercontent.com', which resembles IPv4-address itself. 2021-03-14 16:29:33 815 [Warning] IP address '185.176.222.74' has been resolved to the host name '215522.2cloud.eu', which resembles IPv4-address itself. 2021-03-14 17:04:58 815 [Warning] IP address '35.198.135.30' has been resolved to the host name '30.135.198.35.bc.googleusercontent.com', which resembles IPv4-address itself. 2021-03-14 17:04:58 815 [Warning] IP address '35.198.135.30' has been resolved to the host name '30.135.198.35.bc.googleusercontent.com', which resembles IPv4-address itself. 2021-03-14 17:04:58 815 [Warning] IP address '35.198.135.30' has been resolved to the host name '30.135.198.35.bc.googleusercontent.com', which resembles IPv4-address itself. 2021-03-14 17:04:58 815 [Warning] IP address '35.198.135.30' has been resolved to the host name '30.135.198.35.bc.googleusercontent.com', which resembles IPv4-address itself.

Poti incerca sa pornesti mysql folosind skip name resolve, incearca sa inchizi serverul pentru orice conexiune externa inafara de ip-ul tau. Baiul nu e din cauza la game server, ceva se intampla cu db ul.

[ Postat de pe iPhone ]

Am panelul pe alt VPS poate de la asta o fi.

[ Postat de pe Android ]

hugeness scrie: ↑15 Mar 2021, 19:57

skrydll scrie: ↑15 Mar 2021, 09:59

hugeness scrie: ↑15 Mar 2021, 09:13
Poti incerca sa pornesti mysql folosind skip name resolve, incearca sa inchizi serverul pentru orice conexiune externa inafara de ip-ul tau. Baiul nu e din cauza la game server, ceva se intampla cu db ul.

[ Postat de pe iPhone ] ]

Am panelul pe alt VPS poate de la asta o fi.

[ Postat de pe Android ]

Te referi ca ai db pe alt vps? Incearca sa instalezi mysql direct pe acelasi vps si ar trebui sa functioneze

[ Postat de pe iPhone ]

O să incerc motoda din Franța cu Proxy-ul sa vad daca funcționează. Revin cu reply pentru cei cu aceeasi problemă.
[/quote

[ Postat de pe Android ]


EDIT:
Am incercat sa compilez desc.cpp conform tutorialului de la francezi

https://funky-emu.net/topic/23304-c-ins ... otre-game/

, dar intampin aceasta problema:

desc.cpp: In member function 'void DESC::SendLoginSuccessPacket()':
desc.cpp:940:71: error: 'i' was not declared in this scope
CGuild* g = CGuildManager::instance().GetLinkedGuild(rTable.players.dwID);

Asta este desc.cpp:

https://mega.nz/file/S140gbaC#DPBMnjiBi ... hFN-gOc7ec