Premium Shogun 4588 Posted December 23, 2014 Premium Share Posted December 23, 2014 Your MYSQL server is down for some reason, check /var/db/mysql/[hostname].err 1 Link to comment Share on other sites More sharing options...
OceanusPT 2 Posted December 23, 2014 Share Posted December 23, 2014 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 Link to comment Share on other sites More sharing options...
Premium Shogun 4588 Posted December 23, 2014 Premium Share Posted December 23, 2014 If that's 34k or higher you need mob_proto.txt and item_proto.txt in the core path 1 Link to comment Share on other sites More sharing options...
OceanusPT 2 Posted December 24, 2014 Share Posted December 24, 2014 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? Link to comment Share on other sites More sharing options...
raihan3 20 Posted December 24, 2014 Share Posted December 24, 2014 from where i can buy server Link to comment Share on other sites More sharing options...
OceanusPT 2 Posted December 24, 2014 Share Posted December 24, 2014 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 Link to comment Share on other sites More sharing options...
OceanusPT 2 Posted December 25, 2014 Share Posted December 25, 2014 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? Link to comment Share on other sites More sharing options...
Rumor 2607 Posted December 26, 2014 Author Share Posted December 26, 2014 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 Link to comment Share on other sites More sharing options...
Traceur3RUN 75 Posted December 29, 2014 Share Posted December 29, 2014 error exit delayed from previous errors Link to comment Share on other sites More sharing options...
danhakhavro 42 Posted January 16, 2015 Share Posted January 16, 2015 (edited) 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 Link to comment Share on other sites More sharing options...
guy12 1 Posted February 28, 2015 Share Posted February 28, 2015 hi i have question, what i must change in this tutorial when i use 32 bit freebsd system? Link to comment Share on other sites More sharing options...
ZiuZitsu 5 Posted March 27, 2015 Share Posted March 27, 2015 /usr/local/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' Link to comment Share on other sites More sharing options...
Premium Shogun 4588 Posted March 27, 2015 Premium Share Posted March 27, 2015 /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 Link to comment Share on other sites More sharing options...
ZiuZitsu 5 Posted March 27, 2015 Share Posted March 27, 2015 how? Link to comment Share on other sites More sharing options...
ElfRaIdeR 0 Posted March 28, 2015 Share Posted March 28, 2015 Hey i need some help. What files to donwoald and how to install that... help me please Link to comment Share on other sites More sharing options...
BeHappy4Ever 247 Posted March 28, 2015 Share Posted March 28, 2015 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. Link to comment Share on other sites More sharing options...
kieranFMT2 302 Posted April 9, 2015 Share Posted April 9, 2015 Rumor can you make a tut for 32 free bsd please Thanks Link to comment Share on other sites More sharing options...
CjMt2 20 Posted May 17, 2015 Share Posted May 17, 2015 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. Link to comment Share on other sites More sharing options...
Mi4uric3 4 Posted May 24, 2015 Share Posted May 24, 2015 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_19.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 Link to comment Share on other sites More sharing options...
raihan3 20 Posted July 14, 2015 Share Posted July 14, 2015 error: 'Access denied for user 'root'@'localhost' (using password: NO)'root@localhost:/usr/ports/databases/mysql56-server # Link to comment Share on other sites More sharing options...
Rumor 2607 Posted July 15, 2015 Author Share Posted July 15, 2015 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 Link to comment Share on other sites More sharing options...
raihan3 20 Posted July 15, 2015 Share Posted July 15, 2015 how to set password with mysql Link to comment Share on other sites More sharing options...
raihan3 20 Posted July 15, 2015 Share Posted July 15, 2015 (edited) 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 ended150714 18:48:24 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql2015-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 pages2015-07-14 18:48:26 798 [Note] InnoDB: The InnoDB memory heap is disabled2015-07-14 18:48:26 798 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins2015-07-14 18:48:26 798 [Note] InnoDB: Memory barrier is not used2015-07-14 18:48:26 798 [Note] InnoDB: Compressed tables use zlib 1.2.32015-07-14 18:48:26 798 [Note] InnoDB: Not using CPU crc32 instructions2015-07-14 18:48:26 798 [Note] InnoDB: Initializing buffer pool, size = 128.0M2015-07-14 18:48:26 798 [Note] InnoDB: Completed initialization of buffer pool2015-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 MB2015-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 MB2015-07-14 18:48:29 798 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB2015-07-14 18:48:30 798 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile02015-07-14 18:48:30 798 [Warning] InnoDB: New log files created, LSN=457812015-07-14 18:48:30 798 [Note] InnoDB: Doublewrite buffer not found: creating new2015-07-14 18:48:31 798 [Note] InnoDB: Doublewrite buffer created2015-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 created2015-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 start2015-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: 33062015-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 structure2015-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 structure2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure2015-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 structure2015-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 structure2015-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 structure2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure2015-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 structure2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'users' has the wrong structure2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema' 'accounts' has the wrong structure2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure2015-07-14 18:48:31 798 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure2015-07-14 18:48:31 798 [Note] Event Scheduler: Loaded 0 events2015-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 distribution2015-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 Link to comment Share on other sites More sharing options...
dzdev 40 Posted July 15, 2015 Share Posted July 15, 2015 error: 'Access denied for user 'root'@'localhost' (using password: NO)' help :( Link to comment Share on other sites More sharing options...
Readon 0 Posted July 20, 2015 Share Posted July 20, 2015 root@root260545:~ # fetch ftp://ftp.freebsd.org/pub/FreeBSD/releases/amd64/amd64/9.1-RELEASE/lib32.txzfetch: 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... Link to comment Share on other sites More sharing options...
Recommended Posts