- Joined
- Aug 16, 2010
- Messages
- 240
- Reaction score
- 22
Here we can all post errors we have had in the past and what we did to fix them, that way new devs can come on have a documentation to work with
Level 1 (Errors that require 2 or less steps)
=====================================
Network Error(Permissions to db and other files.)
Step 1: Execute SSH command: chmod 777 /root -R
unknown error 255
Step 1: Reboot server.
Server Update
Step 1: make sure gshop matches client and server.
Step 1-A: make sure gs is running.
err : Identical game server id(#) exist. Check gameserver's ".conf" file.
Step 1: read your logs, and check which two instances have the same "gamed(#)"
Step 2: Go to one of their .conf file Example: gamed/emperor.conf
Step 3: Replace ServerID=# with a number that isnt used for anything else.
Level 2
=====================================
* = if you did not do yet.
network error (Rocklee files)
Why: lampp is not installed.
Step 1: edit config.php (Change passwords).
Step 2: Go to server/build/authd/table.xml
Step 3: Find: <connection name="auth0" poolsize="3" url="jdbc:mysql://localhost:3306/dynasty?useUnicode=true&characterEncoding=utf8" username="root" password="CHANGEME"/>
*Step 1-A: Install lampp
*Step 2-A: run /opt/lampp/lampp security.
*Step 3-A: Set mysql password to the one in Step 2 & 3
Step 4: Reboot server.
Network Error(Advanced - Mysql wont start.)
Why: your Innodb has crashed or failed.
Fix
Step 1: go to opt/lampp/etc/my.conf
Step 2: Go To [msqld]
Step 2-Bfind: myisam_sort_buffer_size = 8M
Step 2-C: Add innodb_force_recovery = 4 under Step 2-B
Step 2-D: save
Step 3: SSH execute command => ( sudo opt/lampp/lampp restart )
Step 3-B: Remove innodb_force_recovery = 4 from Step 3
Step 4: save
Step 5: Step 3.
Level 2-A (Tools)
=======================================
XXX.XX.XX.XXX IP not allowed to connect to mysql.
Why: the username your using / IP isnt allowed to connect to mysql port.
Fix: Create non root user.
Option 1
Option 2
Level 3(Weird but works)
=======================================
Invalid induction ID
Why game DB cannot read account info(AKA induction ID) from newly created log, in /root/server/db/uniquewd/dblogs & OR /root/server/db/gdbwdb/dblogs
Tried(But did not work)
Trial 1: CD sever/gamed => RAN command: ./fix.sh
Trail 2: Change the iseckey from (long number) => 456 and oseckey from(long number) => 123 in server/uniquenamed
Fix:
Step 1: Move the old log.###### from (old root)/server/db/uniquewd/dblogs TO (new root)/server/db/uniquewd/dblogs
Step 2: Copy the new log.##### that we just moved to (new root)/server/db/uniquewd/dblogs, To your desktop.
Note 1: You will see that there is a new log.1234 in (new root)/server/db/uniquewd/dblogs folder, that is 0B big, which will never get bigger.
Step 3: Copy the extension of that log file, and replace the extension of the one you moved to your desktop, to it.
Example.
Step 5: reboot server.
Step 6: create character to see if error gone.
Credits: JDDC,ragezone.com,teamremod.com
Level 1 (Errors that require 2 or less steps)
=====================================
Network Error(Permissions to db and other files.)
Step 1: Execute SSH command: chmod 777 /root -R
unknown error 255
Step 1: Reboot server.
Server Update
Step 1: make sure gshop matches client and server.
Step 1-A: make sure gs is running.
err : Identical game server id(#) exist. Check gameserver's ".conf" file.
Step 1: read your logs, and check which two instances have the same "gamed(#)"
Step 2: Go to one of their .conf file Example: gamed/emperor.conf
Step 3: Replace ServerID=# with a number that isnt used for anything else.
Level 2
=====================================
* = if you did not do yet.
network error (Rocklee files)
Why: lampp is not installed.
Step 1: edit config.php (Change passwords).
Step 2: Go to server/build/authd/table.xml
Step 3: Find: <connection name="auth0" poolsize="3" url="jdbc:mysql://localhost:3306/dynasty?useUnicode=true&characterEncoding=utf8" username="root" password="CHANGEME"/>
*Step 1-A: Install lampp
*Step 2-A: run /opt/lampp/lampp security.
*Step 3-A: Set mysql password to the one in Step 2 & 3
Step 4: Reboot server.
Network Error(Advanced - Mysql wont start.)
Why: your Innodb has crashed or failed.
Fix
Step 1: go to opt/lampp/etc/my.conf
Step 2: Go To [msqld]
Step 2-Bfind: myisam_sort_buffer_size = 8M
Step 2-C: Add innodb_force_recovery = 4 under Step 2-B
Step 2-D: save
Step 3: SSH execute command => ( sudo opt/lampp/lampp restart )
Step 3-B: Remove innodb_force_recovery = 4 from Step 3
Step 4: save
Step 5: Step 3.
Level 2-A (Tools)
=======================================
XXX.XX.XX.XXX IP not allowed to connect to mysql.
Why: the username your using / IP isnt allowed to connect to mysql port.
Fix: Create non root user.
Option 1
You must be registered to see links
hack MySQL: edit my.cnf and put skip-grant-tables in the mysqld section, and restart the server. You can then get in as root and change the password, flush privileges, then remove the dodgy line from my.cnf and restart again
Option 2
You must be registered to see links
#
# Connect to the local database server as user root
# You will be prompted for a password.
#
mysql -h localhost -u root -p
#
# Now we see the 'mysql>' prompt and we can run
# the following to create a new database for Paul.
#
mysql> create database pauldb;
Query OK, 1 row affected (0.00 sec)
#
# Now we create the user paul and give him full
# permissions on the new database
mysql> grant CREATE,INSERT,DELETE,UPDATE,SELECT on pauldb.* to paul@localhost;
Query OK, 0 rows affected (0.00 sec)
#
# Next we set a password for this new user
#
mysql> set password for paul = password('mysecretpassword');
Query OK, 0 rows affected (0.00 sec)
#
# Cleanup and ext
mysql> flush privileges;
mysql> exit;
Level 3(Weird but works)
=======================================
Invalid induction ID
Why game DB cannot read account info(AKA induction ID) from newly created log, in /root/server/db/uniquewd/dblogs & OR /root/server/db/gdbwdb/dblogs
Tried(But did not work)
Trial 1: CD sever/gamed => RAN command: ./fix.sh
Trail 2: Change the iseckey from (long number) => 456 and oseckey from(long number) => 123 in server/uniquenamed
Trail 3: moved the old log.###### from old/server/db/uniquewd/dblogs TO new/server/db/uniquewd/dblogs[UniqueNameServer]
type = tcp
port = 29401
address = 0.0.0.0
so_sndbuf = 65536
so_rcvbuf = 65536
ibuffermax = 1048576
obuffermax = 1048576
accumulate = 268435456
tcp_nodelay = 0
listen_backlog = 10
isec = 2
iseckey = 16899168 (change) => 456
osec = 2
oseckey = 16899168 (change) => 123
case_insensitive = 1
Fix:
Step 1: Move the old log.###### from (old root)/server/db/uniquewd/dblogs TO (new root)/server/db/uniquewd/dblogs
Step 2: Copy the new log.##### that we just moved to (new root)/server/db/uniquewd/dblogs, To your desktop.
Note 1: You will see that there is a new log.1234 in (new root)/server/db/uniquewd/dblogs folder, that is 0B big, which will never get bigger.
Step 3: Copy the extension of that log file, and replace the extension of the one you moved to your desktop, to it.
Example.
Step 4: delete the log.1234 from the server, and move the one from your desktop to its place.(Desktop) log.#####
(Server) log.1234
==========
(Desktop) log.1234
(Server) log.1234
Step 5: reboot server.
Step 6: create character to see if error gone.
Credits: JDDC,ragezone.com,teamremod.com
Last edited: