Just as an update, I did a completely fresh install with the newest package on a new VM and it is doing the same thing. Warrior discs don't seem to work.

Issue a binary update, and let me know what you find

Single command

Interactive mode

Sorry, I should have stated that. I tried the most updated(unstable) version as well in testing. Same result.

My next thing for you to try would be exporting client data from the server so that your spells line up with what the server has in its database.

These errors your getting could be client sided

Copy the files generated in export into your client directory and get back to me

Generated files, copied to SOD client folder, overwrote files, same result:(

Next thing is - updating your client - SoD is way too old, I would recommend getting RoF2

Older clients are hard-coded to only read up to so many Spell ID's - they're also not going to understand how to handle newer spell data

*sigh* it actually doesn't work on PEQ with my client. I just tested. Has anything changed in the past year that would cause it to no longer work with the SOD client?

The reason I haven't upgraded is because all of my macros are made for SOD and it would take a lot of work to change them. I box 40+ characters.

Hmm - let me think of some other things, I am fighting some fires at work atm so it will have to be a bit.

Also - the installer uses the same DB as PEQ, so something else has to be going on

I am still stumped in this - any help will be most welcome.

Stumped by what - there's not a whole lot of information here

Shoot me some more information and I can try to help

How do I create an account so that I can log in?

First of all, just to verify, look in your database to make sure these 4 tables are there :

tblloginserveraccounts
tblserveradministration
tblserverlisttype
tblworldserverregistration

If those tables are there, the server "long name" and server "shortname" (in tblworldserverregistration) have to match
what is in your eqemu_config.xml file.

Second of all, there should be a file called login.ini, if you make sure the following line is set to TRUE, the user name and
password you first enter in your client login window, will automatically be created.

auto_create_accounts = TRUE

I just looked - unless I'm looking at the wrong place (I assume the database I want to look is "peq"), they're not there.

In the case you need to see, here's how everything looks before starting the client.

https://i.imgur.com/T8dmKhI.png

You definately got some things going on there. World is not loading a few things, it's also not connecting to the login server and
you should have another window for zone server. Have no idea whats happening on your end.

Nor I, unfortunately. All I've done was run the installer in Admin mode, log into HeidiSQL, edit the shortcut and run "t_start_with_loginserver".

is there a way to change the stat caps granted to each level?

Trojan?
 

I was near done downloading the latest winserver install when my firewall aborted.

Now it claims that link/file has a trojan and won't allow me to download.

Is there a mirror?

gimpel

When I did the whole installer thing, no errors come up, I end with a folder which looks like its suppost to do.

When I start t_start_server.bat a window pops up, as it is supposed to.

World: changes from down to UP, you can watch it going from 0/30 to 30/30.
When its there, another window pops up, immediately closes and World: changes to down again.
Then the loop restarts. This goes on forever, nothing else happening.

Any ideas? Any questions? Log is empty.

Okay, I got it working.

The problem now is that I have another service using the MySQL 3306 port.

Is there any way to change this one to something else?

Thank you very much in advance.

I was having the same issue and made a little progress

I just opened up my task manager and ended the mysql process and service and then tried to boot my world server. Now a couple of different windows pop up and it starts booting world zones, then it boots the UCS which changes from DOWN to UP, then it boots the Queryserv, but after it boots that the UCS goes down again. It basically then ping pongs and boots one but knocks the other down over and over again.

Do have Microsoft SQL Server installed and possibly running at same time ?
(see programs and features in Control Panel)

In my case I don't have anything by that name. Just a bunch of Visual C++ Redistributable files and the .NET framework. I didn't appear to have any other MySQL or Microsoft SQL services running in Task Manager.

Anyone? I have also used a self compiled version of the .exe's, which leads me to think of a configuration problem. But no clue where to look at.

Try going into the main server folder in dos (command) windows and running each .exe manually (just to test), each in it own cmd window.
Errors should showup there if there is nothing in logs, as you indicated. Do these in order: (just type the full name)
loginserver.exe
shared_memory.exe (this will run once and quit)
world.exe
(wait a few seconds for world to load)
eqlaunch.exe zone
ucs.exe
queryserv.exe

Bots not casting
 

I'm very new to this. I had no trouble running the installer. Once it finished I ran the "setup_bots" command at the end. Once I started the server and logged in I was able to create a bot and group but the cleric bot did not cast. I looked through the forums and read a post or two about this. I was not able to find a fix. I have reran the "Setup_bots" from a command prompt and still no casting.

From what I can tell, my DB is missing the bot_spells_entries. There are alot of other bot tables just no spells.

Can anyone tell me how to get that table installed. I know very little about doing this. I can access the DB with heidi SQL and make minor changes to char xp ect... I would need specific instruction on adding the bot_spells_entries table if someone has one or can tell me where to find it.

Thanks for the work on the installer Akkadius!!

I was able to resolve this issue. I found a post with the code to add the bot_spells_entries.

Thanks!

Login server not showing local server
 

Nice installer; worked like a charm with one caveat: the local server doesn't show up in the realm list when I use the local login server. I can log into the server via the public login server, and I can log in to the local login server.

I've tried tons of stuff based on various interpretations of about a dozen sets of instructions and I'm kind of at a loss.

Running on a clean Windows Server 2016 64bit vm on an ESXi host.

I'd set it up as per the Wiki instructions, even adding the <address/> tag that's no-longer there by default.

It didn't work with just my server as , or with loginserver1 being mine and loginserver2 being eqemu, or vice-versa, even though World reported "Added loginserver 192.168.86.29:5998 in each case.

Solution: Remove the eqemu server but use instead of .

Ha, spoke too soon. My server now shows up in the server list, but the client locks up if I try to log into it until I eventually get a 1017.

If I login via eqemulator.net, the server works fine. Hunch is I have the local login server serving a local IP for the server when I go to it, vs the 192.168 address I get when I go via eqemulator.

[edit]
And

I remember <Prophecy> - I was in <Phantom Raiders> for a short stint.

They had their raiding a-listers - which I was not one .. but, I could out-mez their enchanter any day!

I've done this installation a number of times and from memory it should be option #3 that you go with after a fresh installation; I think you have to do it twice so it gets everything from the database that has been updated.

I've been in the Cisco world for 8 or so years myself.

One of the things with this is that what the loginserver sees is your outside address, which is what the loginserver will default to tell the client to use to login to the server.

You can set your local address to avoid this

This will keep traffic from going out/in - but if it works, it works and in the end does it really matter

HTH

Will do that. Thanks.

I understand that most of the time it probably doesn't matter. This morning, it was noticeable because I was having trouble with my connection (ISPs end) and wound up having to reset their equipment, which I think is failing and in need of replacement. Actually... that's not a very convincing argument that things would have been different if I had a local address specified. I'll play around with it.


Thanks again.

Hmm? Not sure I'm understanding.

Either way I hope you got it sorted sir

Does it matter where in the eqeqmu_config.xml file that <localaddress> tag goes?

Also, do you know of any reason my spells or dbstr files might not be correct? I referred to your response in another thread where you told someone to run

export_client_files .\exports

to acquire those files. I've done this and it spits out the 4 files I'm expecting. When I drop these in my eq folder, the behavior I observed was what I might expect if the spells file was wrong. When I right click a gem in game, the spell categories all read "unknown DB string xxx" and so did all the subcategories. If I follow the menu path down to the spell itself, the spell names were fine. Just the categories leading to them all say that. Issuing a /who command in game returns good information for all but the player races. Races still come up "unknown DB string xxx".

Yesterday, that was all fine and good. It didn't stop me from playing the game, but today I'm just experiencing one crash after another. I can get my GM character into the world, but after a minute or so, it crashes. When I pick items up from my inventory or from the equipment slots on the character, they never appear on the cursor. The game partially behaves as if the item is there, but never does what it is supposed to do when I try to re-equip it, drop it into an inventory slot, etc... and then I crash a second later. If I try to use #zone, I crash. Yesterday, I did not have these problems.

Am having all the trouble in the world resolving this today. Any advice is appreciated.

Thanks.




Edit: restarting the server partially resolved this. I'm not crashing anymore and I can pick up items. Still can't figure out the unknown DB string non-sense, though.

Edit2: The crash and cursor issues seem to be specific only to MQ2 + GM Characters. If I start MQ2 and log in using a GM, I can't pick up items anymore. The items disappear. /gate #zone, etc... will crash the GM. Also using F1 to target self with the GM character logged in will crash the GM toon if MQ2 is running. I can log a regular toon in while MQ2 is running and pick up items, /gate, /zone, etc... just fine.

Edit3: Ok... so what I've determined with the GM account is this: If MQ had been running at any time on the client PC, even if I turn it back off before I log in a GM account, all of the problems with picking up items, targeting self, and crashing recur. Even with MQ turned off, if I log in a GM account and hit F1 to target self, I can cause an immediate crash. This issue does not go away until I restart the server (t_stop_server, not actually rebooting the VM my server runs in). Once I restart the server, if I leave MQ turned off, I can log in a GM, target self, pick up items, etc... This is not too big of a deal. I just need to remain aware that there are certain things the GM simply can't do. I can still utilize him for all my GM needs #leveling toons, #gi , etc... MQ2 and regular players all seem to work as intended.

Out of all this, I'm still most interested in trying to resolve the unknown DB string business. Forgot to mention that when I click the Alt Advancement button, I can't see what AAs I'm purchasing either. Those all say "Unknown DB string xxx" as well.

Update: fixed the "Unknown DB string xxx" problem. I wound up using the server files from agnarr-eq.com

I thought I'd tried the dbstr and spells_us files already (I use the underfoot client), but there were also 2 files that needed to go into the resources folder. I don't remember doing anything that would have changed these from when I actually played on the agnarr emu server, but apparently something was changed along the way. Using all their files with the exception of eqhosts.txt resolved the issue I was having.

Also, someone messaged me and said that MQ2 discussion might not be permitted. My apologies. I thought it was condoned here since most of the servers allow it with varying sets of rules to make multiboxing easier.

I also stuck <localaddress>ip</localaddress> just below <loginserver2></loginserver2>. Will give that a try and report back.

Edit: Was trying the <localaddress> thing because after a while, my response time with the server increases from 30ms to nearly 30,000ms (full 30 second delay). I usually have 21 characters logged in. This happened even with the <localaddress> bit in the eqemu_config.xml file in the place I specified above. The response time sits at about 100ms with 21 toons logged in, but after a while, will suddenly start climing from 100 to 900, then 1500, 5000, 19000, and usually stop climbing somewhere between 27000 and 29000. I am not sure if I am triggering this problem or not. The last time it happened, I had just issued an MQ2 command on the GM character. This could have triggered it or it could have been nothing but a coincidence. Won't know without experimenting further. Just updating here in case someone already has an answer.

Edit2: I issued a /bcaa //gate command to make 20 toons all try to gate at once. Usually this is broken in such a way that it just causes the toon to rezone to the current zone in the current location. The idea was to make them all rezone and see if that fixes the problem with the long response time to/from the server. For some reason, on the bards (bound in gfay by default), /gate actually works and sends them to gfay. All toons that were bound in PoK by the soulbinder were kicked to the server select screen when I did the mass gate. The bards wound up in gfay with 30ms response times from the server.

This is also taking up quite a bit of memory. I am not sure that that would contribute to long response times, but when I had 21 logged in, I noticed my machine was using 26.5GB of memory. I have 32GB in this machine. The server runs in a VM on the same machine. Most of the eqgame.exe instances are using about 732MB of memory. EQ instances only account for 15GB of the memory being used. The rest is other garbage running on the machine (firefox, excel, vmware, etc...) The CPU (an i5 @ 3.4GHz) is not being beaten to death or anything. With a toon zoning here and there, I was seeing 15-24% usage.

Unknown DB string is going to show up depending on the types of data you're dealing with on older clients.

if you want to minimize string related issues on the client side I would suggest using ROF2

You can grab a clean version of ROF2 and use its spells_us and dbstr files to import to the server before you try exporting. The database tables are not guaranteed to be up to date.

And yes - this is not really the place for MQ2 support - there is mqemulator.net for that.

Memory footprint from the emulator is not going to be that large

ok, but what about the <localaddress> bit from the last question? Is that in the right place? Would that have anything to do with the long delay? 30s delay makes this unplayable.


Thanks.

localaddress just needs to be under the <world> section

As far as your delay - you're going to have to narrow down that issue, it could be anything. We have servers in production with folks with 50+ box crews who zone in seconds. I'd suggest looking at your PC's resources when the slowdown occurs.

I'm getting closer to an answer on this 30,000ms delay thing. I don't think it has anything to do with MQ, but more testing is required.

Right now, I've had 18 characters logged in and all of their delays are 30-50ms. They have all been logged in for over 2 hours, which is way longer than it was taking for this 30 second response time bug to kick in yesterday. Individually, they can all change zones in 3-5 seconds (assuming the zone was already up). I zoned 18 characters all at the same time and it took 27 seconds for it to complete.

Shortly after the mass /gate, all the toons had response times from anywhere between 400ms and 1200ms. This seems to be correcting itself slowly over time while I have them sitting in place not doing anything. Many of the 500ms response times lowered down to 300ms after a minute or two. My main cleric's 1200ms response time was down to 850 and lowering. I think this will work itself out as I wait.

My current theory is that the huge lags don't really kick in until I bring the bards online and make them start twisting their songs. I have 3 total bards and when they are simultaneously twisting, it generates quite a lot of chatter in the chat windows of 20+ toons all at once. I am wondering if more is going on in the background with bard songs that might be contributing to this giant delay. Going to wait for the response times on all my toons to get back down to 100 or less, then bring them online and make them /twist. I will monitor response times both before and after issuing /twist 1 2 3 (makes them twist spells in the first 3 gem slots).

Sorry for bringing up anything MQ related in the post. I'm not seeking MQ support here at all. If I determine that to be a contributor to the problem, I will take this discussion elsewhere. I am including the information for the sake of drawing a more complete picture.


Edit: I brought the bards online. They all three had 30ms response times while in gfay. I #summoned them to PoK with the rest of the toons and they had 40-50ms response times. I left them idle there for several minutes. My response times on all toons are still gradually lowering during the several minutes. Response times on all toons were between 125ms and 135ms. They didn't seem to be lowering further than that, though perhaps it might have happened if I waited longer. I decided to make all three bards twist the songs in their first 3 gem slots. Most of the chatter is in the GM's chat box. It displays the full name of every song as soon as it is successfully cast. The other toons just have a bunch of "The elemental chorus fades" entries in their chat. If this is what triggers the problem I'm investigating, I imagine it could take 15-20 minutes or so for it to kick in. Will edit the post again if it recurs.

In the meantime, this is what my performance currently looks like. Left is the host machine where the eq clients are running. Right side is the guest machine, where the server lives.

https://i.imgur.com/MTBqHVj.png