EQEmulator Forums - EQEmu on Fedora 22 Server Minimal Guide

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Linux Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=588)

- - EQEmu on Fedora 22 Server Minimal Guide (https://www.eqemulator.org/forums/showthread.php?t=39757)

EQEmu on Fedora 22 Server Minimal Guide

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

http://blog-harmonson.rhcloud.com/20...erver-minimal/

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

Cool, thanks for sharing.

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.

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>ifjhgyt7r6v7vrv5kbfdshdjffkhbfuvydr678ccvbn09 86fr</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.

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.

Quote:

Originally Posted by camryfu (Post 244225)

** REDACTED **

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

Quote:

Originally Posted by provocating (Post 244239)

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.

Quote:

Originally Posted by Cilraaz (Post 244237)

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/.../sshot-556.png

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

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

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

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.

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.

Quote:

Originally Posted by provocating (Post 244246)

I have disabled firewall.

https://dl.dropboxusercontent.com/u/.../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/.../sshot-558.png

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

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.

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?

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/.../sshot-561.png

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

Any idea for me?

thanks in advanced.

One thing glaring at me is this.

Code:

<!-- <address>172.16.10.48</address> -->

<!-- <localaddress>172.16.10.48</localaddress> -->

Should be

Code:

<address>172.16.10.48</address> 

<localaddress>172.16.10.48</localaddress>

Quote:

Originally Posted by provocating (Post 244349)

One thing glaring at me is this.

Code:

<!-- <address>172.16.10.48</address> -->

<!-- <localaddress>172.16.10.48</localaddress> -->

Should be

Code:

<address>172.16.10.48</address> 

<localaddress>172.16.10.48</localaddress>

I changed it, but still no luck.

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

Don't give up on us.

The correct questions still need to be asked.

Quote:

Originally Posted by Uleat (Post 244394)

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.

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

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

https://dl.dropboxusercontent.com/u/.../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/.../sshot-566.png

Quote:

Originally Posted by provocating (Post 244401)

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/...rside_logs.rar

client side logs:

https://dl.dropboxusercontent.com/u/...tside_Logs.rar

thanks for your help.

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.

Quote:

Binary Revision / Local: (9087 / 1000)

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

Quote:

Originally Posted by Uleat (Post 244408)

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/.../sshot-568.png

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

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

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?

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

Maybe the world is not actually up.

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

Code:

 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_hourly.sql'

DB up to date with: 9045 - '2014_08_23_Complete_QueryServ_Table_Structures.sql'

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...



>

Now you are getting somewhere.

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

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

Does your revision change after the update?

Quote:

Binary Revision / Local: (9087 / 9087)

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.

Quote:

Originally Posted by Uleat (Post 244415)

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/.../sshot-570.png

Quote:

Originally Posted by Akkadius (Post 244416)

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

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

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

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

and the folder own is same user (eqadmin):

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

it should be written in that folder.

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

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.

Quote:

Originally Posted by Akkadius (Post 244420)

I set version to '0' and re-update:

https://dl.dropboxusercontent.com/u/.../sshot-575.png

https://dl.dropboxusercontent.com/u/.../sshot-576.png

then re-run client, it still crashed.

Make sure to re-run shared_memory.exe too.

re-run world, it seems up to date:

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

Quote:

Originally Posted by Uleat (Post 244425)

Make sure to re-run shared_memory.exe too.

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