How To Install an Metin2 Server on FreeBSD 9 64-bit

[Shogun 4478]

Your MYSQL server is down for some reason, check /var/db/mysql/[hostname].err

[OceanusPT 2]

esse ponto ficou resolvido. Mas agora dá isto no syserr da db

 

SYSERR: Dec 23 23:09:12 :: Start: TABLE_POSTFIX not configured use default

SYSERR: Dec 23 23:09:12 :: InitializeTables: InitializeMobTable FAILED

SYSERR: Dec 23 23:09:12 :: Initialize: Table Initialize FAILED

SYSERR: Dec 23 23:09:12 :: pid_deinit: 

End of pid

Dec 23 23:09:12 :: AsyncSQL: closing mysql connection.

Dec 23 23:09:12 :: AsyncSQL: closing mysql connection.

Dec 23 23:09:12 :: AsyncSQL: closing mysql connection.

Dec 23 23:09:12 :: AsyncSQL: closing mysql connection.......................

 

 

it's all ok with the mysql_upgrade now.

But now i have this in syerr "db"  when i make start,sh,,,, 

dam xD

 

i solve one bug, and i win 2 xD

 

 

edit: in NAVICAT, the mob_proto its ok.... but maybe its not here xD

[Shogun 4478]

If that's 34k or higher you need mob_proto.txt and item_proto.txt in the core path

[OceanusPT 2]

i have do that shogun, but my files: item_name.txt, item_proto.txt, mob_names.txt and mob_proto.txt, are diferente of my navicat. 

i use files 34k and i never need to add anything in this files.... 

 

They need to be the same like in navicat?

[raihan3 20]

from where i can buy server

[OceanusPT 2]

Hi there,

 

Finaly i have put the server to start and i have make the connection between  client and server.

But now i have one last problem (i hope),the server only start with the item_proto.txt itens. And now i dont have my normal items from navicat.,,, can any one help. pls?

The same for na mob_proto. Only work at the mob_proto.txt

[OceanusPT 2]

ee /etc/rc.conf

Add these lines:

php_fpm_enable="YES"
nginx_enable="YES"

Start your services:

service nginx start

 

 

i have made all... but i get 

 

nginx: [emerg] unknown directive "rewrite" in /usr/local/etc/nginx/nginx.conf:38

/usr/local/etc/rc.d/nginx: WARNING: failed to start nginx

 

 

line38: " rewrite ^(.*)$ $scheme://xxxxxxxxxx.xxxxx$1; "

 

any help pls?

[Rumor 2548]

 

ee /etc/rc.conf

Add these lines:

php_fpm_enable="YES"
nginx_enable="YES"

Start your services:

service nginx start

 

 

i have made all... but i get 

 

nginx: [emerg] unknown directive "rewrite" in /usr/local/etc/nginx/nginx.conf:38

/usr/local/etc/rc.d/nginx: WARNING: failed to start nginx

 

 

line38: " rewrite ^(.*)$ $scheme://xxxxxxxxxx.xxxxx$1; "

 

any help pls?

 

 http://bit.ly/1xmcB3Z

[Traceur3RUN 73]

error exit delayed from previous errors

[danhakhavro 42]

I install the php, and nginx and when i upload the metin2 site for host i have this problem:

 

403 Forbidden

 

I put permission 755 and try 777 but nothing work.

 

 

Sombebody can help me please?

Edited August 18, 2022 by Metin2 Dev
Core X - External 2 Internal

[guy12 1]

hi i have question, what i must change in this tutorial when i use 32 bit freebsd system?

[ZiuZitsu 5]

/usr/local/bin/mysqladmin: connect to server at 'localhost' failed

error: 'Access denied for user 'root'@'localhost' (using password: NO)'

[Shogun 4478]

 

/usr/local/bin/mysqladmin: connect to server at 'localhost' failed

error: 'Access denied for user 'root'@'localhost' (using password: NO)'

 

 

Wrong password / host, Check mysql.user table

[ZiuZitsu 5]

how?

[ElfRaIdeR 0]

Hey i need some help. What files to donwoald and how to install that... help me please

[BeHappy4Ever 234]

I bought a root server and i installed it.when i am going to login it says that my elements are false even are ok or no..I need really fast help me please.At localhost the server was working fine.

[kieranFMT2 292]

Rumor can you make a tut for 32 free bsd please

 

Thanks

[CjMt2 20]

Rumor: Just one question ... why not use www/apache24 port? Is simple, stable, work ok.

 

hi i have question, what i must change in this tutorial when i use 32 bit freebsd system?

Rumor can you make a tut for 32 free bsd please

 

Thanks

 

For i386 exist small difference like "/usr/lib" not "/usr/lib32" for example. Read carefuly first post and finaly you have working FreeBSD server.

[Mi4uric3 4]

Hi,

I'm trying to set up on a FreeBSD 9.3 x64 system.

I've had problems with this:

 

pkg_add -r compat7x-amd64

As you can see here, there are no packages for any OS except 8.4 anymore. I solved it by doing this:

setenv PACKAGESITE ftp://ftp.tw.freebsd.org/pub/releases/amd64/amd64/9.0-RELEASE/packages/misc/
pkg_add -r compat7x-amd64-7.3.703000.201008_1

9.0 was the only available source I could find, but it worked fine on 9.3, so I guess that's ok then.

Before installing compat7x-amd64 I got "elf_load_section: truncated ELF file", afterwards this error disappeared.

I downloaded the library files linked to in the 1st post, dropped them into /usr/lib32 and gave them the same rights like the other libraries in this direcotry have.

After executing the start.sh I get the typical "Shared object has no run-time symbol table" error message. But since I put the libraries in place that can't be the problem.

I'm starting to wonder if the game files I use are corrupt..

Do you have any advice for me?

Edit: I now converted the original Mcncc.com Metin2.vhd to vmdk and loaded it in VMWare. Configured some stuff and tried it.

First time I got "Can not get public IP address". Downloaded game file, changed 192.168 to 111.111, uploaded it, started it again, now I get the "Shared object has no run-time symbol table", too.

WTF

[raihan3 20]

error: 'Access denied for user 'root'@'localhost' (using password: NO)'
root@localhost:/usr/ports/databases/mysql56-server #

 

[Rumor 2548]

Rumor: Just one question ... why not use www/apache24 port? Is simple, stable, work ok.

 

 

hi i have question, what i must change in this tutorial when i use 32 bit freebsd system?

 

Rumor can you make a tut for 32 free bsd please

 

Thanks

 

For i386 exist small difference like "/usr/lib" not "/usr/lib32" for example. Read carefuly first post and finaly you have working FreeBSD server.

because nginx is better

error: 'Access denied for user 'root'@'localhost' (using password: NO)'
root@localhost:/usr/ports/databases/mysql56-server #

 

set and use a password with mysql

[raihan3 20]

how to set password with mysql

 

[raihan3 20]

Your MYSQL server is down for some reason, check /var/db/mysql/[hostname].err

shougun in my hostname.err i see it can you see where is error

 

150714 18:47:28 mysqld_safe mysqld from pid

This is the hidden content, please

• Sign In
• or
• Sign Up

/var/db/mysql/localhost.pid ended
150714 18:48:24 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2015-07-14 18:48:26 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-07-14 18:48:26 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.24) starting as process 798 ...
2015-07-14 18:48:26 798 [Note] Plugin 'FEDERATED' is disabled.
2015-07-14 18:48:26 798 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-07-14 18:48:26 798 [Note] InnoDB: The InnoDB memory heap is disabled
2015-07-14 18:48:26 798 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-07-14 18:48:26 798 [Note] InnoDB: Memory barrier is not used
2015-07-14 18:48:26 798 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-07-14 18:48:26 798 [Note] InnoDB: Not using CPU crc32 instructions
2015-07-14 18:48:26 798 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-07-14 18:48:26 798 [Note] InnoDB: Completed initialization of buffer pool
2015-07-14 18:48:26 798 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2015-07-14 18:48:26 798 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2015-07-14 18:48:26 798 [Note] InnoDB: Database physically writes the file full: wait...
2015-07-14 18:48:27 798 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2015-07-14 18:48:29 798 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2015-07-14 18:48:30 798 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2015-07-14 18:48:30 798 [Warning] InnoDB: New log files created, LSN=45781
2015-07-14 18:48:30 798 [Note] InnoDB: Doublewrite buffer not found: creating new
2015-07-14 18:48:31 798 [Note] InnoDB: Doublewrite buffer created
2015-07-14 18:48:31 798 [Note] InnoDB: 128 rollback segment(s) are active.
2015-07-14 18:48:31 798 [Warning] InnoDB: Creating foreign key constraint system tables.
2015-07-14 18:48:31 798 [Note] InnoDB: Foreign key constraint system tables created
2015-07-14 18:48:31 798 [Note] InnoDB: Creating tablespace and datafile system tables.
2015-07-14 18:48:31 798 [Note] InnoDB: Tablespace and datafile system tables created.
2015-07-14 18:48:31 798 [Note] InnoDB: Waiting for purge to start
2015-07-14 18:48:31 798 [Note] InnoDB: 5.6.24 started; log sequence number 0
/usr/local/libexec/mysqld: Error on delete of './auto.cnf' (Errcode: 2 - No such file or directory)
2015-07-14 18:48:31 798 [Warning] World-writable config file './auto.cnf' has been removed.

2015-07-14 18:48:31 798 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 28da7a29-2a48-11e5-a13d-0200003be049.
2015-07-14 18:48:31 798 [Note] Server hostname (bind-address): '*'; port: 3306
2015-07-14 18:48:31 798 [Note] IPv6 is available.
2015-07-14 18:48:31 798 [Note]   - '::' resolves to '::';
2015-07-14 18:48:31 798 [Note] Server socket created on IP: '::'.
2015-07-14 18:48:31 798 [ERROR] Column count of mysql.events_waits_current is wrong. Expected 19, found 16. Created with MySQL 50537, now running 50624. Please use mysql_upgrade to fix this error.
2015-07-14 18:48:31 798 [ERROR] Column count of mysql.events_waits_history is wrong. Expected 19, found 16. Created with MySQL 50537, now running 50624. Please use mysql_upgrade to fix this error.
2015-07-14 18:48:31 798 [ERROR] Column count of mysql.events_waits_history_long is wrong. Expected 19, found 16. Created with MySQL 50537, now running 50624. Please use mysql_upgrade to fix this error.
2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure
2015-07-14 18:48:31 798 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_thread_by_event_name: expected column 'THREAD_ID' at position 0 to have type bigint(20), found type int(11).
2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure
2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure
2015-07-14 18:48:31 798 [ERROR] Column count of mysql.file_summary_by_event_name is wrong. Expected 23, found 5. Created with MySQL 50537, now running 50624. Please use mysql_upgrade to fix this error.
2015-07-14 18:48:31 798 [ERROR] Column count of mysql.file_summary_by_instance is wrong. Expected 25, found 6. Created with MySQL 50537, now running 50624. Please use mysql_upgrade to fix this error.
2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure
2015-07-14 18:48:31 798 [ERROR] Incorrect definition of table performance_schema.mutex_instances: expected column 'LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11).
2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure
2015-07-14 18:48:31 798 [ERROR] Incorrect definition of table performance_schema.rwlock_instances: expected column 'WRITE_LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11).
2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure
2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure
2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure
2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure
2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure
2015-07-14 18:48:31 798 [ERROR] Column count of mysql.threads is wrong. Expected 14, found 3. Created with MySQL 50537, now running 50624. Please use mysql_upgrade to fix this error.
2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure
2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure
2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure
2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure
2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure
2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure
2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure
2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure
2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure
2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure
2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure
2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure
2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure
2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure
2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure
2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure
2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure
2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'users' has the wrong structure
2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema' 'accounts' has the wrong structure
2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure
2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure
2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure
2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure
2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure
2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure
2015-07-14 18:48:31 798 [Note] Event Scheduler: Loaded 0 events
2015-07-14 18:48:31 798 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.24'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
2015-07-15 05:36:02 798 [Warning] IP address '198.13.107.123' could not be resolved: hostname nor servname provided, or not known

 

 

 

/usr/local/bin/mysqladmin: connect to server at 'localhost' failed

error: 'Access denied for user 'root'@'localhost' (using password: NO)'

 

 

Wrong password / host, Check mysql.user table

Shogun where i find /host for check mysql.user table

 

Edited August 26, 2022 by Metin2 Dev
Core X - External 2 Internal

[dzdev 37]

error: 'Access denied for user 'root'@'localhost' (using password: NO)'

help  :( 

[Readon 0]

root@root260545:~ # fetch ftp://ftp.freebsd.org/pub/FreeBSD/releases/amd64/amd64/9.1-RELEASE/lib32.txz
fetch: ftp://ftp.freebsd.org/pub/FreeBSD/releases/amd64/amd64/9.1-RELEASE/lib32.txz: File unavailable (e.g., file not found, no access)

 

 

 

Anyone knows an alternative or so? Doesn't work...