EQEmu on Fedora 22 Server Minimal Guide [Archive]

View Full Version : EQEmu on Fedora 22 Server Minimal Guide

Yummy

06-12-2015, 11:43 PM

I got this hairbrained idea to document my most recent EQEmu build on Fedora.

http://blog-harmonson.rhcloud.com/2015/06/08/eqemu-on-fedora-22-server-minimal/

Feel free to provide constructive criticism, suggestions, or whatever. If I learn something new, I am happy.

rhyotte

07-05-2015, 05:34 PM

Cool, thanks for sharing.

Yummy

09-06-2015, 05:56 PM

Updated.

It had one very glaring flaw where I broke LUA scripts due to not moving lua_modules. Embarrassing, but it is now in the guide. I have added a few other tweaks but nothing as substantial.

camryfu

10-12-2015, 09:31 PM

First, thanks for your guide.

I follow your guild to setup my own eqemu server include loginserver, everything seems setup correctly, and I got RoF(or RoF2) from this link:

** REDACTED **

unzip it into a folder, change eqhost.txt to my loginserver like this:
[LoginServer]
Host=172.16.10.48:5999

=====

my eqemu_config.xml:

<?xml version="1.0"?>
<server>
<world>
<shortname>LATTE</shortname>
<longname>LATTE EQ</longname>






<loginserver>
<host>172.16.10.48</host>
<port>5998</port>
<account></account>
<password></password>
</loginserver>



<unlocked/>


<tcp ip="127.0.0.1" port="9000" telnet="disable"/>


<key>ifjhgyt7r6v7vrv5kbfdshdjffkhbfuvydr678ccvbn0986fr</key>


<http port="9080" enabled="false" mimefile="mime.types" />
</world>


<chatserver>
<host>localhost</host>
<port>7778</port>
</chatserver>


<mailserver>
<host>localhost</host>
<port>7778</port>
</mailserver>

<zones>
<defaultstatus>20</defaultstatus>


<ports low="7000" high="7100"/>
</zones>


<database>
<host>127.0.0.1</host>
<port>3306</port>
<username>root</username>
<password>123321</password>
<db>peq</db>
</database>

<qsdatabase>
<host>127.0.0.1</host>
<port>3306</port>
<username>root</username>
<password>123321</password>
<db>peq</db>
</qsdatabase>


<launcher>




</launcher>


<files>




</files>

<directories>



</directories>
</server>

===
and my login.ini:

[database]
host = localhost
port = 3306
db = peq
user = root
password = 123321
subsystem = MySQL

[options]
unregistered_allowed = TRUE
reject_duplicate_servers = FALSE
trace = TRUE
world_trace = FALSE
dump_packets_in = FALSE
dump_packets_out = FALSE
listen_port = 5998
local_network = 172.16.10.

[security]
plugin = EQEmuAuthCrypto
mode = 5

[Titanium]
port = 5998
opcodes = login_opcodes.conf

[SoD]
port = 5999
opcodes = login_opcodes_sod.conf

[schema]
account_table = tblLoginServerAccounts
world_registration_table = tblWorldServerRegistration
world_admin_registration_table = tblServerAdminRegistration
world_server_type_table = tblServerListType

I can login , can see my server in list, join it, and create character, but hang w while and crash when I click "enter world"

my client logs (it's large so I post link below):
https://dl.dropboxusercontent.com/u/26140408/dbg.txt

I can not figure out what is goning on?

So I try to do a test, use same client and modify eqhost.txt to:
[LoginServer]
Host=login.eqemulator.net:5999

Login, select one server, join, create character, enter world, perfert!!!!

So, that's not client fault, it must be something wrong in my server.

Cilraaz

10-12-2015, 11:14 PM

Are your zone servers running and properly connected to the world server? It could also be a RoF2 issue. I believe the client isn't compatible by default.

provocating

10-12-2015, 11:17 PM

** REDACTED **

Woh, that is highly illegal here. No matter what a forum post, even if they are affiliated with EqEmu, no client postings here.

camryfu

10-12-2015, 11:38 PM

Woh, that is highly illegal here. No matter what a forum post, even if they are affiliated with EqEmu, no client postings here.

I am sorry about that.

camryfu

10-12-2015, 11:40 PM

Are your zone servers running and properly connected to the world server? It could also be a RoF2 issue. I believe the client isn't compatible by default.

https://dl.dropboxusercontent.com/u/26140408/p3/sshot-556.png

this is my connection screen capture, I think zone is connected with world.

Uleat

10-12-2015, 11:41 PM

It's ok - I usually don't ban unless there's a serious issue :)

Stuff like that is easily ** REDACTED ** :)

provocating

10-12-2015, 11:45 PM

If you can see the server then that normally means world is connected. If you cannot zone into the world but the zone servers are up, then normally the zones are crashing or you are blocked on those ports by a firewall.

provocating

10-12-2015, 11:47 PM

camryfu

10-13-2015, 01:36 AM

If it were me, I would open a prompt for world and then a few prompts for a few zones, launch them manually. Then log in with your client and see if they are crashing. So launch around 3 bash prompts and run shared_memory, login server and world in one. Then run a few more and do your ./zone in each of those.

When you log in, if zone is indeed crashing you should see the crash happen in the bash prompt. If a crash is happening then we can diagnose that down next.

I have disabled firewall.

https://dl.dropboxusercontent.com/u/26140408/p3/sshot-557.png

And this picture indicates I use 5 prompts to create 5 zones. Finally, EQ client crashed. seems nothing special except one prompt shows Client linkdead. :

https://dl.dropboxusercontent.com/u/26140408/p3/sshot-558.png

camryfu

10-13-2015, 01:37 AM

It seems that zone doesn't crash, just client linkdead.

provocating

10-13-2015, 08:27 AM

That really looks like a firewall issue. Make sure ports 7000~7020 or so are open and if you have a router, that those ports are opened and forwarded to the server. Just to be sure use a remote port scanner to see if those ports are open and listening.

Just curious does the client immediately crash or is there a long delay? That matters.

Cilraaz

10-13-2015, 09:12 AM

What do you mean by "disabled the firewall"? Did you move this box to the DMZ? Was the router firewall disabled? Were IPTables rules dumped?

camryfu

10-13-2015, 08:50 PM

I run server in a fedora 22 VM, and client in host (win 10).

I disabled firewall means iptable is inactive in that VM.

I have own loginserver (see eqemu_config.xml), all in LAN environment.

for some tests (via login.emulator.net loginserver), I also set my router open ports:

https://dl.dropboxusercontent.com/u/26140408/p3/sshot-561.png

sorry for my mother language(Traditional Chinese), I add some description on it.

Any idea for me?

thanks in advanced.

provocating

10-14-2015, 11:45 AM

camryfu

10-14-2015, 07:53 PM

One thing glaring at me is this.




Should be

<address>172.16.10.48</address>
<localaddress>172.16.10.48</localaddress>

I changed it, but still no luck.

https://dl.dropboxusercontent.com/u/26140408/p3/sshot-564.png

Uleat

10-14-2015, 08:04 PM

Don't give up on us.

The correct questions still need to be asked.

camryfu

10-14-2015, 08:49 PM

Don't give up on us.

The correct questions still need to be asked.

Yes, I won't give up, and many thanks for all of your help.

provocating

10-14-2015, 08:51 PM

Could you post some of your logs, we need to see if there are errors when you are logging in.

camryfu

10-14-2015, 08:55 PM

one clue maybe I can provide is when I start ./world it show up shomething needs to be updated...

https://dl.dropboxusercontent.com/u/26140408/p3/sshot-565.png

hope this help to solve the problem.

I do from 3 to 20 item, nothing changed, then 0 to exit, it continue to load and wait zone to connect.

https://dl.dropboxusercontent.com/u/26140408/p3/sshot-566.png

camryfu

10-14-2015, 08:58 PM

Could you post some of your logs, we need to see if there are errors when you are logging in.

you can download my log below:

server side logs:

https://dl.dropboxusercontent.com/u/26140408/p3/serverside_logs.rar

client side logs:

https://dl.dropboxusercontent.com/u/26140408/p3/clientside_Logs.rar

thanks for your help.

Uleat

10-14-2015, 09:06 PM

Ok, the window output says there are missing updates.

You will need to press #3 to search for updates.

Then press #3 again, if the message changes to PENDING updates.

Binary Revision / Local: (9087 / 1000)

EDIT: You should probably run shared_memory.exe again before starting the server, too.

camryfu

10-14-2015, 09:22 PM

Ok, the window output says there are missing updates.

You will need to press #3 to search for updates.

Then press #3 again, if the message changes to PENDING updates.

EDIT: You should probably run shared_memory.exe again before starting the server, too.

I press twice 3, same result shows below:

https://dl.dropboxusercontent.com/u/26140408/p3/sshot-568.png

It said that save db_update_manifest.txt in db_update, but nothing there:

https://dl.dropboxusercontent.com/u/26140408/p3/sshot-569.png

camryfu

10-14-2015, 09:27 PM

I checked that "https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/db_update_manifest.txt" exists, why it can't retrive it and save it?

provocating

10-14-2015, 09:30 PM

I would expect to see some world logs, but your dump has none.

camryfu

10-14-2015, 09:40 PM

Maybe the world is not actually up.

I try to download https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/db_update_manifest.txt manually, and put it into /home/eqadmin/eqemu/server/db_update, re-run "3", then it begin to do something...:

Enter numbered option and press enter...

> 3
Retrieving latest database manifest...
o URL: (https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/db_update_manifest.txt)
o Saved: (db_update/db_update_manifest.txt)
Reading manifest...

Missing DB Update 9087 '2015_09_25_inventory_snapshots.sql'
o URL: (https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2015_09_25_inventory_snapshots.sql)
o Saved: (db_update/2015_09_25_inventory_snapshots.sql)
DB up to date with: 9086 - '2015_07_02_aa_rework.sql'
Missing DB Update 9085 '2015_07_01_Marquee_Rule.sql'
o URL: (https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2015_07_01_Marquee_Rule.sql)
o Saved: (db_update/2015_07_01_Marquee_Rule.sql)
Missing DB Update 9084 '2015_06_30_runspeed_adjustments.sql'
o URL: (https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2015_06_30_runspeed_adjustments.sql)
o Saved: (db_update/2015_06_30_runspeed_adjustments.sql)
DB up to date with: 9083 - '2015_06_07_aa_update.sql'
DB up to date with: 9082 - '2015_05_25_npc_types_texture_fields.sql'
DB up to date with: 9081 - '2015_05_23_dbstr_us.sql'
DB up to date with: 9080 - '2015_05_23_PetBuffInstrumentMod.sql'
DB up to date with: 9079 - '2015_05_23_BuffDurations.sql'
DB up to date with: 9078 - '2015_05_20_BuffInstrumentMod.sql'
DB up to date with: 9077 - '2015_02_12_zone_gravity.sql'
DB up to date with: 9076 - '2015_02_04_average_coin.sql'
ERROR 1146 (42S02) at line 1: Table 'peq.logsys_categories' doesn't exist
Missing DB Update 9075 '2015_02_02_logsys_packet_logs_with_dump.sql'
o URL: (https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2015_02_02_logsys_packet_logs_with_dump.sql)
o Saved: (db_update/2015_02_02_logsys_packet_logs_with_dump.sql)
ERROR 1146 (42S02) at line 1: Table 'peq.logsys_categories' doesn't exist
Missing DB Update 9074 '2015_02_01_logsys_packet_logs.sql'
o URL: (https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2015_02_01_logsys_packet_logs.sql)
o Saved: (db_update/2015_02_01_logsys_packet_logs.sql)
Missing DB Update 9073 '2015_01_31_character_item_recast.sql'
o URL: (https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2015_01_31_character_item_recast.sql)
o Saved: (db_update/2015_01_31_character_item_recast.sql)
DB up to date with: 9072 - '2015_01_30_merc_attack_delay.sql'
DB up to date with: 9071 - '2015_01_29_merc_stats_table_update.sql'
ERROR 1146 (42S02) at line 1: Table 'peq.logsys_categories' doesn't exist
Missing DB Update 9070 '2015_01_28_quest_debug_log_category.sql'
o URL: (https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2015_01_28_quest_debug_log_category.sql)
o Saved: (db_update/2015_01_28_quest_debug_log_category.sql)
ERROR 1146 (42S02) at line 1: Table 'peq.logsys_categories' doesn't exist
Missing DB Update 9069 '2015_01_25_logsys_Mercenaries_category.sql'
o URL: (https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2015_01_25_logsys_Mercenaries_category.sql)
o Saved: (db_update/2015_01_25_logsys_Mercenaries_category.sql)
Missing DB Update 9068 '2015_01_15_logsys_categories_table.sql'
o URL: (https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2015_01_15_logsys_categories_table.sql)
o Saved: (db_update/2015_01_15_logsys_categories_table.sql)
DB up to date with: 9067 - '2015_01_21_npc_types_update.sql'
DB up to date with: 9066 - '2014_12_31_npc_types_default_values_update.sql'
ERROR 1146 (42S02) at line 1: Table 'peq.vwMercNpcTypes' doesn't exist
Missing DB Update 9065 '2014_12_26_merc_weaponinfo_table_update.sql'
o URL: (https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/git/required/2014_12_26_merc_weaponinfo_table_update.sql)
o Saved: (db_update/2014_12_26_merc_weaponinfo_table_update.sql)
DB up to date with: 9064 - '2014_12_24_npc_types_table_update.sql'
DB up to date with: 9063 - '2014_12_24_npc_types_update.sql'
DB up to date with: 9062 - '2014_12_15_multiple_table_updates.sql'
DB up to date with: 9061 - '2014_12_13_inventory_table_update.sql'
DB up to date with: 9060 - '2014_12_09_items_table_update.sql'
DB up to date with: 9059 - '2014_12_01_mercs_table_update.sql'
DB up to date with: 9058 - '2014_11_26_InventoryTableUpdate.sql'
DB up to date with: 9057 - '2014_11_13_spells_new_updates.sql'
DB up to date with: 9056 - '2014_11_08_RaidMembers.sql'
DB up to date with: 9055 - '2014_10_30_special_abilities_null.sql'
DB up to date with: 9054 - '2014_10_19_raid_group_mentor.sql'
DB up to date with: 9053 - '2014_10_18_group_mentor.sql'
DB up to date with: 9052 - '2014_10_13_RaidLeadership.sql'
DB up to date with: 9051 - '2014_10_11_RaidMOTD.sql'
DB up to date with: 9050 - '2014_09_20_ban_messages.sql'
DB up to date with: 9048 - '2014_09_09_attack_delay.sql'
DB up to date with: 9046 - '2014_08_23_player_events_and_player_aa_rate_hourl y.sql'
DB up to date with: 9045 - '2014_08_23_Complete_QueryServ_Table_Structures.sq l'
DB up to date with: 9044 - '2014_08_20_merchantlist_probability.sql'
DB up to date with: 9043 - '2014_08_18_spells_new_update.sql'
DB up to date with: 9042 - '2014_08_12_NPC_raid_targets.sql'
DB up to date with: 9041 - '2014_08_02_spells_new.sql'
DB up to date with: 9040 - '2014_07_10_npc_spells.sql'
DB up to date with: 9036 - '2014_05_04_SlowMitigationFix.sql'
DB up to date with: 9035 - '2014_04_27_AISpellEffects.sql'
DB up to date with: 9034 - '2014_04_25_spawn_events.sql'
DB up to date with: 9032 - '2014_04_12_SlowMitigation.sql'
DB up to date with: 9031 - '2014_04_10_No_Target_With_Hotkey.sql'
DB up to date with: 9030 - '2014_04_04_PhysicalResist.sql'
DB up to date with: 9028 - '2014_02_26_roambox_update.sql'
DB up to date with: 9027 - '2014_02_20_buff_update.sql'
DB up to date with: 9026 - '2014_02_13_spells_new_update.sql'
DB up to date with: 9025 - '2014_02_13_Rename_instance_lockout_tables.sql'
DB up to date with: 9022 - '2014_01_20_Weather.sql'
DB up to date with: 9020 - '2014_01_20_Not_Extendable.sql'
DB up to date with: 9018 - '2014_01_09_PreservePetSize.sql'
DB up to date with: 9017 - '2014_01_08_SpellsNewAdditions.sql'
DB up to date with: 9015 - '2013_12_26_MerchantList_Class_Required.sql'
DB up to date with: 9014 - '2013_11_18_AssistRadius.sql'
DB up to date with: 9012 - '2013_11_07_BaseData.sql'
DB up to date with: 9011 - '2013_10_31_Recipe_disabling.sql'
DB up to date with: 9009 - '2013_10_12_Merc_Special_Abilities.sql'
DB up to date with: 9008 - '2013_07_11_NPC_Special_Abilities.sql'
DB up to date with: 9007 - '2013_05_05_Item_Tick.sql'
DB up to date with: 9006 - '2013_05_05_Account_Flags.sql'
DB up to date with: 9005 - '2013_04_08_Salvage.sql'
DB up to date with: 9002 - '2013_03_1_Merc_Rules_and_Equipment.sql'
DB up to date with: 9001 - '2013_02_25_Impr_HT_LT.sql'
DB up to date with: 9000 - '2013_02_18_Merc_Rules_and_Tables.sql'
DB up to date with: 8000 - 'mercs.sql'

================================================== ==========
#::: EQEmu Update Utility Menu: (eqemu_update.pl)
================================================== ==========
1) [Backup Database] :: (Saves to Backups folder)
2) [Backup Database Compressed] :: (Saves to Backups folder)
3) [EQEmu DB Schema] :: Run pending REQUIRED updates... (10)
4) [EQEmu DB Bots Schema] Install bots database pre-requisites (Requires bots server binaries)
5) [OPCodes] :: Download latest opcodes for each EQ Client
6) [Maps] :: Download latest map and water files
7) [Plugins (Perl)] :: Download latest Perl plugins
8) [Quests (Perl/LUA)] :: Download latest PEQ quests and stage updates
9) [LUA Modules] :: Download latest LUA Modules (Required for Lua)
10) [DB Data : Alternate Advancement] :: Download Latest AA's from PEQ (This overwrites existing data)
20) [Update the updater] Force update this script (Redownload)
0) Exit

Enter numbered option and press enter...

>

provocating

10-14-2015, 09:45 PM

Now you are getting somewhere.

Cilraaz

10-14-2015, 09:47 PM

That shows you have multiple pending updates, so you'd want to run #3 again.

Uleat

10-14-2015, 09:48 PM

It may be downloading the update files..but, not saving them.

Does your revision change after the update?

Binary Revision / Local: (9087 / 9087)

Akkadius

10-14-2015, 09:53 PM

camryfu

10-14-2015, 09:58 PM

It may be downloading the update files..but, not saving them.

Does your revision change after the update?

Yes, it changed, and no more update request after ./world start up.

https://dl.dropboxusercontent.com/u/26140408/p3/sshot-570.png

camryfu

10-14-2015, 10:05 PM

You need to make sure that you are running world in context of your server directory

Also, make sure the user you are using to run world can also make folders and files. Beyond that make sure the db_update folder can be written by anything if that doesn't fix it. The db_update.pl script that gets ran by world needs to be able to save files and use them to work with them.

Yes, I run loginserver, world, zone all in server directory:

https://dl.dropboxusercontent.com/u/26140408/p3/sshot-571.png

https://dl.dropboxusercontent.com/u/26140408/p3/sshot-572.png

https://dl.dropboxusercontent.com/u/26140408/p3/sshot-573.png

and the folder own is same user (eqadmin):

https://dl.dropboxusercontent.com/u/26140408/p3/sshot-574.png

it should be written in that folder.

camryfu

10-14-2015, 10:07 PM

Because of no more update need after world startup, I try to re-run client to seek for luck, but crash again.

Akkadius

10-14-2015, 10:12 PM

Are you sure that the updates ran? If they aren't able to pull down the manifest and the update files during the update, you may have not actually had anything updated at all.

When the manifest gets pulled down (First option 3 run) you should also see all of the updates you are missing in the same run.

Second run will then apply those updates.

I would set your db_version 'version' column to 0 and run it again manually. If you're missing database schema updates that can cause a client crash inevitably.

If you're completely updated for sure and your client is still crashing, you could have a corrupt character and I would try to make another after you are fully updated.

camryfu

10-14-2015, 10:51 PM

Uleat

10-14-2015, 10:56 PM

Make sure to re-run shared_memory.exe too.

camryfu

10-14-2015, 10:58 PM

re-run world, it seems up to date:

https://dl.dropboxusercontent.com/u/26140408/p3/sshot-577.png

camryfu

10-14-2015, 11:03 PM

Make sure to re-run shared_memory.exe too.

Yes, I do re-run share_momery, same result.

camryfu

10-15-2015, 12:14 AM

First, I am happy to tell all of you I have solved this problem, many thanks to you.

It's DB problem.

According to so many missing errors, I decide to download one by one from url, and save it to db_update.

after download them, I re-run "3" to excute these db update sql files, then WOW so happy to see the world.

Hi, Lizardman there!!

https://dl.dropboxusercontent.com/u/26140408/p3/sshot-579.png

provocating

10-15-2015, 12:22 AM

When I did not see World running, or possibly crashing I figured it was your database.

camryfu

10-15-2015, 12:30 AM

When I did not see World running, or possibly crashing I figured it was your database.

For two weeks, I almost try every installation guides, linux(ubuntu,debian,fedora), windows.. and five clients(one Titanium, three different source RoF2, and one p1999), finally, it works.

Uleat

10-15-2015, 02:47 PM

camryfu

10-15-2015, 08:20 PM

Camryfu, I'm glad that you had success with your server!

For reference:

You may still have problems when you update your server.

If downloading updates by hand worked for you, then you may need to do that in the future also.

Thanks for your advice, I decide to migrate whole system to one deticated ubuntu linux server , not vm, and also seek for the answer why it can't update automatically.

Shendare

10-15-2015, 09:58 PM

Yeah, it's acting like Perl didn't have write access to the directory.