Enabling RoF2 on Server

[Bohbo]

I am redoing my server setup and was hoping to get it compatible with RoF2, however search wasn't yielding anything in terms of requirements to allow an RoF2 client to connect. I can connect to Grand Creation with it but that was about it.

Any tips for getting server RoF2 Client compatible?

[demonstar55]

Make sure you copy the conf file?

About it really.

[Bohbo]

Originally Posted by demonstar55

Make sure you copy the conf file?

About it really.

Can you be a bit more specific on the conf file?

Where it is located and exactly where it needs to be placed? Sorry if this is a noobish question. I searched the RoF2 client for *.conf but didn't come up with anything so i assume all server side.

Under the server directory I see the different client conf files.

patch_RoF.conf and patch_6.2.conf seem like the mostly likely candidates, just not sure exactly what to do with it.

EDIT: Okay i see rom the git the patches.cpp
#include "rof2.h"
I assume i un-comment that line and recompile the server?

EDIT2: I found the the "file patch_RoF2.conf" in the Git i copied that to my server directory with the other similar files, and restarted the server. No luck though

[trevius]

In this folder:
https://github.com/EQEmu/Server/tree.../utils/patches

The patch_RoF2.conf file from your source in utils/patches/ needs to be copied into your server folder where you should have copied the other .conf files. That is all you should have to do.

Make sure you are compiling the latest source yourself if you want RoF2. There are no pre-built windows binaries available for RoF2 client yet that I am aware of.

[Bohbo]

Originally Posted by trevius

In this folder:
https://github.com/EQEmu/Server/tree.../utils/patches

The patch_RoF2.conf file from your source in utils/patches/ needs to be copied into your server folder where you should have copied the other .conf files. That is all you should have to do.

Make sure you are compiling the latest source yourself if you want RoF2. There are no pre-built windows binaries available for RoF2 client yet that I am aware of.

Recompiling latest version did the trick! Thanks much, I will start testing it out. Thanks again for the help, very much appreciated.

[trevius]

Moved these posts to their own thread, since the RoF Dev thread is for dev work, not support.

[ionhsmith]

hmm I did all of this and yet when I try to log in all I get is the server selection ... I click my server and then the client becomes unresponsive.

[Coenxai]

Originally Posted by ionhsmith

hmm I did all of this and yet when I try to log in all I get is the server selection ... I click my server and then the client becomes unresponsive.

Again, make sure you have:

1.) Applied the appropriate SQL queries to your database. They can be found here: https://github.com/EQEmu/Server/tree...l/git/required

2.) Compiled the latest source code and moved it to your server's directory.

3.) Added the latest RoF2 opcodes; Link can be found in the post Trevius made.

Quadruple check.

[Uleat]

Make sure that your client's eqhost file is set to use port 5999 and check your logs..they can tell you alot about what's going on.


EDIT: ..or not going on...

[ionhsmith]

yes i have done this all and still not working... I dont know what I am missing

[trevius]

Originally Posted by ionhsmith

yes i have done this all and still not working... I dont know what I am missing

Are you able to connect to PEQ, EZ, or Storm Haven with the same client? All of these servers have RoF2 enabled and work fine. If you cannot connect to them either, then the issue is with your client.

If your client works on those servers, then have you tried any client other than RoF2 on your server and verified it works? If not, you may have ports blocked in your router or something preventing it.

If the above aren't the problem, then you are still doing something wrong on your server. Check your server logs. If you enable all logging, you should be able to see login attempts and see the server trying to match the client to the right patch version. If it doesn't check for RoF, it is because you are missing the patch_RoF2.conf file in your server folder or you are not on the latest version of the source code from git.

[ionhsmith]

I just pulled the git source and then sourced everything in that was new ... I didnt see anything about ROF... i even sourced in the optional files ... I can connot to other servers with it and I can connect to my server fine with UF client. I moved the patch_ROF2.conf into my server folder but still will not connect... I dont see anything in my logs about it having an issue.

[ionhsmith]

i tried to source in a few things and got this

\mysql> source 2014_12_24_npc_types_table_update.sql
ERROR 1060 (42S21): Duplicate column name 'herosforgemodel'
mysql> source 2014_12_15_multiple_table_updates.sql
ERROR 1060 (42S21): Duplicate column name 'augslot6type'
ERROR 1060 (42S21): Duplicate column name 'augslot6visible'
ERROR 1060 (42S21): Duplicate column name 'augslot6unk2'
ERROR 1060 (42S21): Duplicate column name 'augslot6'
ERROR 1060 (42S21): Duplicate column name 'augslot6'
ERROR 1060 (42S21): Duplicate column name 'augslot6'
ERROR 1146 (42S02): Table 'peq.character_corpse_items' doesn't exist
mysql>

[ionhsmith]

hmm nevermind I got it to work ... thanks guys!

[trevius]

Originally Posted by ionhsmith

hmm nevermind I got it to work ... thanks guys!

It is always good to post what you did to fix it. Multiple people spent time to assist you to get it resolved, so it is worthwhile to spent a little time to post what you did to fix it. The main reason for this is for future users that have the same issue, so they might know what they are missing or need to do.

Based on your SQL logs in the previous post showing you are missing the character_corpse_items table, I have to assume the issue was that you were not running the latest source code. Maybe you had just updated your database, but not the actual source code. I am guessing this because the character_corpse_items table is automatically created in more recent code updates as part of the removal of the corpse blob from the older tables. Since you were missing that table, it means your source was older than the corpse blob conversion, which means it was older than the RoF2 client compatibility.