Newb setting up Private LAN Server - Page 2

mercdady4965 · #16 08-17-2014, 06:02 PM

It shows 28275.

FYI I can follow instructions. I do not "know" HeidiSQL. lol
Thank you.

Scorpious2k · #17 08-17-2014, 07:53 PM

Well, I didn't want to be insulting by giving too detailed instructions.

I'd say that's greater than zero... so it's probably a compatibility problem. What date did you download the source code you compiled and what is the date on the DB you downloaded?

mercdady4965 · #18 08-17-2014, 08:20 PM

Downloaded on 8-15 2014.

This is the download peqbeta_2014-08-11-02-01.tar.gz
I had downloaded an earlier version 1st. Had issues and thought "resourcing" the new one might work. I'm not positive on the terminology. Sorry I haven't thought to mention this yet. It's been a very confusing week with little sleep. heh.

Scorpious2k · #19 08-17-2014, 10:14 PM

From the change log:

Code:

== 08/02/2014 ==
Kayen: Implemented spell_news fields
- npc_no_los (check if LOS is required for spells) 
- InCombat, OutofCombat - Used together to restrict spells to only be cast while 
in/out of combat (beneficial) or if target is in/out of combat (detrimental).
-min_dist, min_dist_mod, max_dist, max_dist_mod - Scales spell power based on targets distance from caster.
*This will require further work to fully implement but will work with 90% of live spells as is.
*If making custom spells do not include effects that can't be scaled (like a spell trigger)
- min_rage sets minimum distance range that must be away from target.

Required SQL: utils/sql/git/required/2014_08_02_spells_new.sql

So find the file utils/sql/git/required/2014_08_02_spells_new.sql, source it in , and see if that fixes it.

mercdady4965 · #20 08-17-2014, 10:56 PM

Awesome! That fixed that. Now I see
3 windows now show "using database 'peq' at 127.0.0.1:3306". world.exe, queryserv.exe and ucs.exe.
1 window shows 0: sleeping.
I tried to log on with this and another comp and got "A connection to the server could not be reached".

Thank You! You have been a huge help.

EDIT: I found a eqemuauthcrypto error. A missing dll I think. Installing that in the right place solved the above problem.

Now I see 5 windows:

Login Server - Server started
World.exe - using database peq
Queryserv.exe - using database peq
ucs.exe - using database peq
0: Sleeping

I can login to the server screen, but there are no servers seen. "0 of 0 expansions owned" message.

mercdady4965 · #21 08-18-2014, 01:36 AM

Searching through the logs I have found this:
[Debug] [08.18.14 - 01:37:48] Logging System Init.
[Debug] [08.18.14 - 01:37:48] Config System Init.
[Debug] [08.18.14 - 01:37:48] MySQL Database Init.
[Debug] [08.18.14 - 01:37:48] Encryption Initialize.
[Debug] [08.18.14 - 01:37:48] Encryption Loaded Successfully.
[Debug] [08.18.14 - 01:37:48] Server Manager Initialize.
[Network] [08.18.14 - 01:37:48] ServerManager listening on port 5998
[Debug] [08.18.14 - 01:37:48] Client Manager Initialize.
[Network] [08.18.14 - 01:37:48] ClientManager listening on Titanium stream.
[Network] [08.18.14 - 01:37:48] ClientManager listening on SoD stream.
[Debug] [08.18.14 - 01:37:48] Server Started.
[Network] [08.18.14 - 01:37:48] New world server connection from 127.0.0.1:50171
[Network Error] [08.18.14 - 01:37:48] Handle_NewLSInfo error, remote address was null, defaulting to stream address 127.0.0.1.
[Database] [08.18.14 - 01:37:48] Mysql query returned no result: SELECT WSR.ServerID, WSR.ServerTagDescription, WSR.ServerTrusted, SLT.ServerListTypeID, SLT.ServerListTypeDescription, WSR.ServerAdminID FROM tblWorldServerRegistration AS WSR JOIN tblServerListType AS SLT ON WSR.ServerListTypeID = SLT.ServerListTypeID WHERE WSR.ServerShortName = 'Dragon'
[World] [08.18.14 - 01:37:48] Server Dragon's Rest(Dragon) attempted to log in but database couldn't find an entry and only registered servers are allowed.

I think we are real close on this one. : )

mercdady4965 · #22 08-18-2014, 09:00 AM

I found some lines in eqemu_config.xml that needed to be uncommented.

I believe this is correct now:

<address>127.0.0.1</address>
<localaddress>127.0.0.1</localaddress>

And here's my example of "Go home and do it again"...

I have now moved on to another error:
Mysql query returned no results:

Server Dragon's Rest(Dragon) attempted to login but database couldn't find an entry and only registered servers are allowed.
World server disconnected from the server, removing server and freeing connection.

mercdady4965 · #23 08-18-2014, 10:42 AM

I have changed this:


<loginserver>
<host>127.0.0.1</host>
<port>5999</port>
<account>root</account>
<password>****</password>
</loginserver>

to this:


<loginserver>
<host>127.0.0.1</host>
<port>5999</port>
<account></account>
<password></password>
</loginserver>

I took out a account and password that shouldn't have been there.

I can now log onto my server, but there are no NPCs around.

mercdady4965 · #24 08-18-2014, 12:04 PM

I found my NPC solution here:

http://www.eqemulator.org/forums/sho...ighlight=zones

Now on to my laptops. I'm getting a 1017 error when connecting to server. "cannot login to the everquest server. You need to re-run the update patch.

This is the coolest thing ever.

Scorpious2k · #25 08-18-2014, 02:12 PM

Quote:

Originally Posted by mercdady4965

I found my NPC solution here:

http://www.eqemulator.org/forums/sho...ighlight=zones

Now on to my laptops. I'm getting a 1017 error when connecting to server. "cannot login to the everquest server. You need to re-run the update patch.

This is the coolest thing ever.

You've made a lot of progress on your own. This one seems to be a step backwards. Did you change something besides the SQL fix for the NPC problem? Port forward change? Has it only worked on the same computer that the server is running on?

**Uleat** · #26 08-18-2014, 02:42 PM

Lerxst posted here.. http://www.eqemulator.org/forums/sho...01&postcount=6

..about your ip address..though, there were probably enough other issues that it was missed or misunderstood.

For a solo machine, meaning ALL activities occur on the one computer, "127.0.0.1" is fine to use.

If you intend to allow any outside connections, you will need to use the address of your NIC card.

It is best to ensure that the computer 'hosting' the server is set to a 'static' address and not a DHCP one, or the host will be on a different address
every time it, or the network, is rebooted.

Even better, if your router allows you to reserve a single IP address for the MAC address of your NIC card, do this and you can leave the assignment
protocol alone.

In changing your config files...

If your database is on the same computer as your server, then leave it set to "127.0.0.1"

Otherwise, all settings that reflect "127.0.0.1" will need to be changed to that of your NIC's IP address (as lerxst stated, "192.168.x.x")

Your [Login.ini][options] local_network will also need to be updated ("192.168.x.")

For eqhost.txt...

All connecting clients will need to change their host address to the new address..including the one running on the host server.

Lastly...

Instead of trying to fix everything that I just broke, it would probably be a good idea to make backups of the two config files before starting

mercdady4965 · #27 08-18-2014, 03:00 PM

At the moment I have 3 accounts that can log in, create a character and level. 2 are flagged GM, the other not. This is all done from the "server" desktop. On the laptop I see the server, but get this patch message.

The EQEmu Login Server shows a Network Error - Recieved unhandled application packet from the client: [OpCode OP_Unknown (0x0012) Size=10].

mercdady4965 · #28 08-18-2014, 04:42 PM

Thank you, Uleat! I appreciate the help. Definitely have my head spinning. I will try to implement it and get back to you.

By the by, your avatar was kinda creepy to begin with, but after seeing it a few dozen time I think you just need some sleep. lol

mercdady4965 · #29 08-20-2014, 09:15 AM

Could this be a casr of something important(EQ) not being shared on my network? I'm on the server, but my other comps on LAN can't connect.

**Uleat** · #30 08-20-2014, 05:57 PM

Repost your config files and let's see where I led you astray

Have they ever connected and just can't now, or still a no-go from the start?

EDIT: You did create accounts for them, right?