In concluzie, sursa db si game se compileaza numai pe masina 32 bit si numai cu mysql 5.5, game nu se compileaza static si NU functioneaza.
Maine sterg masina virtuala pe care am lucrat, daca o vrea cineva sa lase mesaj aici.


mt2@localhost:/usr/home/mt2/game/main/srv1/chan/ch99/core99 $ INTERNAL_IP: 192.168.1.7 interface em0
INTERNAL_IP -> PUBLIC_IP: 192.168.1.7
HOSTNAME: srv1-ch99-core99
mysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: NO)
cannot open direct sql connection to host: localhost user: mt2 db: common
cannot start server while no common sql connected

CONFIG:
COMMON_SQL: localhost mt2 123456 common
LOG_SQL: localhost mt2 123456 log
PLAYER_SQL: localhost mt2 123456 player

ENABLE_STATIC = 1 :

linking ../../../game/bin/game_r41023
/usr/local/bin/ld: /usr/lib/liblzma.a(check.o): in function `lzma_sha256_init':
/usr/src/contrib/xz/src/liblzma/check/check.h:143: undefined reference to `_libmd_SHA256_Init'
/usr/local/bin/ld: /usr/lib/liblzma.a(check.o): in function `lzma_sha256_update':
/usr/src/contrib/xz/src/liblzma/check/check.h:160: undefined reference to `_libmd_SHA256_Update'
/usr/local/bin/ld: /usr/lib/liblzma.a(check.o): in function `lzma_sha256_finish':
/usr/src/contrib/xz/src/liblzma/check/check.h:167: undefined reference to `_libmd_SHA256_Final'
collect2: error: ld returned 1 exit status
gmake: *** [Makefile:195: ../../../game/bin/game_r41023] Error 1
mt2@localhost:/usr/home/mt2/Server/game/src $ locate liblzma
/usr/lib/liblzma.a
/usr/lib/liblzma.so
/usr/lib/liblzma.so.5
/usr/lib/liblzma_p.a
/usr/libdata/pkgconfig/liblzma.pc


./srv1-db &
Log Offmysql_real_connect: Access denied for user 'mt2'@'localhost' (using password: NO)
conf.txt:
SQL_ACCOUNT = "localhost account mt2 123456 3306"

Acest user cu aceasta parola in phpmyadmin se conecteaza si functioneaza.
In consola:
$ mysql -umt2 -p123456
mysql>

Nov 19 20:53:54 localhost kernel: pid 90598 (db_r41023), jid 0, uid 1001: exited on signal 11 (core dumped)
Nov 19 20:54:33 localhost kernel: pid 91454 (db_r41023), jid 0, uid 1001: exited on signal 11 (core dumped)
Nov 19 20:55:31 localhost kernel: pid 93837 (db_r41023), jid 0, uid 1001: exited on signal 11 (core dumped)
Nov 19 21:00:37 localhost kernel: pid 418 (db_r41023), jid 0, uid 1001: exited on signal 11 (core dumped)
Nov 19 21:11:47 localhost kernel: pid 4640 (db_r41023), jid 0, uid 1001: exited on signal 11 (core dumped)
Nov 19 21:13:48 localhost kernel: pid 5007 (db_r41023), jid 0, uid 1001: exited on signal 11 (core dumped)




Ca sa compilez am fost nevoit sa renunt momentan la mysql80-server asa ca acum e nevoie o modificare in filele sql

CURRENT_TIMESTAMP devine '0000-00-00 00:00:00'





Message from mysql55-client-5.5.62_3:

--
Please be aware the database client is vulnerable
to CVE-2015-3152 - SSL Downgrade aka "BACKRONYM".
You may find more information at the following URL:

http://www.vuxml.org/freebsd/36bd352d-2 ... 210b8.html

A vulnerability has been reported concerning the impossibility for MySQL users (with any major stable version) to enforce an effective SSL/TLS connection that would be immune from man-in-the-middle (MITM) attacks performing a malicious downgrade. Versions 5.7.2 and below are affected.

Pe bsd 13 i386 am reusit sa compilez atat game_r41023 cat si db_r41023 din aceste surse.

Ma apuc sa fac un bsd x86 in masina virtuala ca sunt convins ca nimeni de aici nu ma ajuta cu erorile astea.

Din liblua/5.2 lipsesc file, 5.0 se compileaza fara erori.

Server/libsql AsyncSQL.cpp:142:55:
my_bool reconnect = true; devine bool reconnect = true;

Link indisponibil!
Arhivat!