Server for Local/Offline Play Only 1017 error

[Michelle-Bishop]

Hi folks.


I am using this guide here to install a private server = https://github.com/EQEmu/Server/wiki/Windows-Server


I believe I followed everything just fine, I think... though I did notice on the command prompt that Perl didn't install or gave some error, not sure exactly.


Here is the EQEmu Login Server Command Prompt Window ---


[Login Server] Logging System Init.
[Login Server] Config System Init.
[Login Server] MySQL Database Init.
[Login Server] Server Manager Initialize.
[Login Server] Client Manager Initialize.
[Login Server] Server Started.
[Login Server] New world server connection from 10.0.0.100:55569
[Error] Handle_NewLSInfo error, remote address was null, defaulting to stream address 10.0.0.100.
[World Server] Server Kera's Server(Kera's Serv) did not attempt to log in but unregistered servers are allowed.
[Login Server] New Titanium client connection from 10.0.0.100:59094
[Login Server] Application packet received from client (size 14)
[Login Server] Session ready received from client.
[Login Server] Application packet received from client (size 44)
[Login Server] Login received from client.
[Login Server] Application packet received from client (size 12)
[Login Server] Server list request received from client.
[Login Server] Application packet received from client (size 16)
[Login Server] Play received from client, server number 2 sequence 5.
[Login Server] Application packet received from client (size 12)
[Login Server] Client disconnected from the server, removing client.
[Login Server] New Titanium client connection from 10.0.0.100:59096
[Login Server] Application packet received from client (size 14)
[Login Server] Session ready received from client.
[Login Server] Application packet received from client (size 12)
[Login Server] Application packet received from client (size 44)
[Login Server] Login received from client.
[Login Server] Application packet received from client (size 12)
[Login Server] Server list request received from client.
[Login Server] Client disconnected from the server, removing client.




Here's my EQEMU_Config file
------------
{
"server" : {
"chatserver" : {
"host" : "",
"port" : "7778"
},
"database" : {
"db" : "peq",
"host" : "localhost",
"password" : "eqemu",
"port" : "3306",
"username" : "root"
},
"mailserver" : {
"host" : "",
"port" : "7778"
},
"qsdatabase" : {
"db" : "peq",
"host" : "localhost",
"password" : "eqemu",
"port" : "3306",
"username" : "root"
},
"webinterface" : {
"port" : "9081"
},
"world" : {
"http" : {
"enabled" : "true",
"mimefile" : "mime.types",
"port" : "9080"
},
"key" : "jSx0rDQnhBlY72zPJEABOErxZI1ZEBz",
"loginserver1" : {
"account" : "",
"host" : "login.eqemulator.net",
"legacy" : "1",
"password" : "",
"port" : "5998"
},
"loginserver2" : {
"account" : "",
"host" : "10.0.0.100",
"password" : "",
"port" : "5998"
},
"longname" : "Kera's Server",
"shortname" : "Kera's Serv",
"tcp" : {
"ip" : "127.0.0.1",
"port" : "9001"
},
"telnet" : {
"enabled" : "true",
"ip" : "0.0.0.0",
"port" : "9000"
}
},
"zones" : {
"defaultstatus" : "0",
"ports" : {
"high" : "7400",
"low" : "7000"
}
}
}
}

--------


I do want to note, that I did a fresh install of Titanium only edition, as I play on P99 (or used to), and am wishing to play on my own classic type server. Either way, I am using the P99 files still to log in to servers.

I was able to see my server in the list of all servers. Then, I switched it to LAN only or something, so that I could only see my own server, and I was able to, and it said it was UP as well.

As of now, I am getting the 1017 error.
I cannot log into my server.



If anyone has any suggestions, that would be wonderful.
I do not mind getting rid all my installs/reinstalling everything, as I won't be playing online anymore anyways as I won't have reliable internet in the next few weeks.

Thanks folks!

[Huppy]

First of all, if you're using a clean copy of Titanium, that is NOT patched with P99 files, (or any other patches),then there should be no problem on the client end of things.

I am posting a config below that actually works (for me) but I have adjusted with values similiar to yours. The "shortname" is best to be one word, with no spaces. Just make sure both the longname and shortname are matched exactly in the database as well. In this config, the web interface is disabled, since it doesn't work anyway. As my own preference, I don't use telnet, so I use port 9000, instead of 9001. I also use 127.0.0.1 (instead of "localhost").

In your login.ini the following 2 lines should look like this - (leave the "1" off the end of local_network IP)
listen_port = 5998
local_network = 127.0.0.

eqemu_config.json


{
"server" : {
"chatserver" : {
"host" : "10.0.0.100",
"port" : "7778"
},
"database" : {
"db" : "peq",
"host" : "127.0.0.1",
"password" : "eqemu",
"port" : "3306",
"username" : "root"
},
"directories" : {
"logs" : "logs/",
"lua_modules" : "lua_modules/",
"maps" : "maps/",
"patches" : "./",
"plugins" : "plugins/",
"quests" : "quests/",
"shared_memory" : "shared/"
},
"mailserver" : {
"host" : "10.0.0.100",
"port" : "7778"
},
"qsdatabase" : {
"db" : "peq",
"host" : "127.0.0.1",
"password" : "eqemu",
"port" : "3306",
"username" : "root"
},
"world" : {
"http" : {
"enabled" : "false",
"mimefile" : "mime.types",
"port" : "9080"
},
"key" : "jSx0rDQnhBlY72zPJEABOErxZI1ZEBz",
"localaddress" : "10.0.0.100"
"locked" : "false",
"loginserver1" : {
"account" : "",
"host" : "login.eqemulator.net",
"legacy" : "1",
"password" : "",
"port" : "5998"
},
"loginserver2" : {
"account" : "",
"host" : "10.0.0.100",
"legacy" : "0",
"password" : "",
"port" : "5998"
},
"longname" : "Kera's Server",
"shortname" : "keraserver",
"tcp" : {
"ip" : "127.0.0.1",
"port" : "9000",
"telnet" : "disable"
}
},
"zones" : {
"defaultstatus" : "0",
"ports" : {
"high" : "7400",
"low" : "7000"
}
}
}
}

[Michelle-Bishop]

Thank you Huppy.

Yea, I was using the eqgame.exe file from my P99 folder, as my other install I think began to patch EQ to the Live versions or something. Seems I won't be on P99 anymore for some years, I'm going to just get rid of everything and do a fresh install of EQ.

Thank you for the config, and editing. I appreciate it!

[Uleat]

Project PEQ has a 'Getting Started' section over on their website (http://peqtgc.com/forums/index.php?articles/) that you may be interested in.

[from your other thread..]
The current expansion for content is Gates of Discord.

[Michelle-Bishop]

Hmm, with the config Huppy, it doesn't appear as though the server wants to start up. Or the zones won't load or something? Here's an image. It keeps looping this.

https://ibb.co/BBB8YCM

[Huppy]

Hmm, with the config Huppy, it doesn't appear as though the server wants to start up. Or the zones won't load or something? Here's an image. It keeps looping this.

I've never seen that before, but that config sample I posted is the exact same one I am using for my own server, BUT, with different values entered. I assume you edited the config for your own server ? (database, users, passwords, etc.) ? If it's all good, it's obviously a different issue.

[Uleat]

"key" : "jSx0rDQnhBlY72zPJEABOErxZI1ZEBz",
"localaddress" : "10.0.0.100",
"locked" : "false",


missing comma (so far)

[Huppy]

missing comma (so far)

Damn keyboard ;)

[Michelle-Bishop]

Ah, that worked, was just missing that comma and it loaded up like before.

(EDIT) Scratch my other issue off. Fixed it.


Well, it appears I am now able to log in, create a character, and mess around in the tutorial section at the least! Awesome.

Once I get back home work, I have to remember how to switch it so I only see my server and be able to play it offline, as I see all of the private servers as of now.


I guess the main question I have as of now is, what is the server like if I don't make any changes to it at all? Like, what expansions are available, and are there any game-breaking things I need to be aware of? Like, do Boats work? I know that was an issue with P99/classic type stuff.

Either way, I do appreciate the help you guys have done so far. I can at least load it up and mess around so far. Good stuff =)

[Huppy]

I guess the main question I have as of now is, what is the server like if I don't make any changes to it at all?

Look at the content/expansions on PEQTGC server, that's where the database comes from. You'll have yourself a vanilla OoW server, but also with current live content. (defiant, mercs, lvl 100 mobs in PoK, etc.) lol

There is expansions accessible past OoW, but without content worked on. You would have to do that yourself. PEQ is currently working on DoN expansion, but don't hold your breath waiting for it.

[Michelle-Bishop]

Nice. Alright.

Hmm, I'm not sure what I'm doing wrong, but I am getting the 1017 error again after I was able to view just my server prior to logging a character in. grrrr

[Huppy]

With your goal of running just a local/lan server, I am assuming you changed this in your config ?

"loginserver1" : {
"account" : "",
"host" : "login.eqemulator.net",
"legacy" : "1",
"password" : "",
"port" : "5998"
},
"loginserver2" : {
"account" : "",
"host" : "10.0.0.100",
"legacy" : "0",
"password" : "",
"port" : "5998"
},


TO THIS : You only need one loginserver (no 1's or 2's)


"loginserver" : {
"account" : "",
"host" : "10.0.0.100",
"legacy" : "0",
"password" : "",
"port" : "5998"
},


Of course, if you're playing the client on the same box as server, change the IP to 127.0.0.1 (same in your login.ini) But that's only if you don't need a lan setup for others in the house to play.

[Michelle-Bishop]

I don't understand what I am doing wrong...

Here's my eqemu config
------------------
"server" : {
"chatserver" : {
"host" : "10.0.0.100",
"port" : "7778"
},
"database" : {
"db" : "peq",
"host" : "127.0.0.1",
"password" : "eqemu",
"port" : "3306",
"username" : "root"
},
"directories" : {
"logs" : "logs/",
"lua_modules" : "lua_modules/",
"maps" : "maps/",
"patches" : "./",
"plugins" : "plugins/",
"quests" : "quests/",
"shared_memory" : "shared/"
},
"mailserver" : {
"host" : "10.0.0.100",
"port" : "7778"
},
"qsdatabase" : {
"db" : "peq",
"host" : "127.0.0.1",
"password" : "eqemu",
"port" : "3306",
"username" : "root"
},
"world" : {
"http" : {
"enabled" : "false",
"mimefile" : "mime.types",
"port" : "9080"
},
"key" : "jSx0rDQnhBlY72zPJEABOErxZI1ZEBz",
"localaddress" : "10.0.0.100",
"locked" : "false",
"loginserver" : {
"account" : "",
"host" : "10.0.0.100",
"legacy" : "0",
"password" : "",
"port" : "5998"
},
"longname" : "Kera's Server",
"shortname" : "keraserver",
"tcp" : {
"ip" : "127.0.0.1",
"port" : "9000",
"telnet" : "disable"
}
},
"zones" : {
"defaultstatus" : "0",
"ports" : {
"high" : "7400",
"low" : "7000"
}
}
}
}
----------------------
Here's the login.ini
-----------------------
[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 = 10.0.0.100
auto_create_accounts = TRUE
-----------------
Here's the eqhost file
---------------------
[LoginServer]
Host=10.0.0.100:5998
-----------------------

I am able to log in the game with the original one I had, but only when I host the game when it shows up Online and not when it shows just my server at the select screen.
-------------------

{
"server" : {
"chatserver" : {
"host" : "",
"port" : "7778"
},
"database" : {
"db" : "peq",
"host" : "localhost",
"password" : "eqemu",
"port" : "3306",
"username" : "root"
},
"mailserver" : {
"host" : "",
"port" : "7778"
},
"qsdatabase" : {
"db" : "peq",
"host" : "localhost",
"password" : "eqemu",
"port" : "3306",
"username" : "root"
},
"webinterface" : {
"port" : "9081"
},
"world" : {
"http" : {
"enabled" : "true",
"mimefile" : "mime.types",
"port" : "9080"
},
"key" : "jSx0rDQnhBlY72zPJEABOErxZI1ZEBz",
"loginserver1" : {
"account" : "",
"host" : "login.eqemulator.net",
"legacy" : "1",
"password" : "",
"port" : "5998"
},
"loginserver2" : {
"account" : "",
"host" : "10.0.0.100",
"password" : "",
"port" : "5998"
},
"longname" : "Kera's Server",
"shortname" : "Kera's Serv",
"tcp" : {
"ip" : "127.0.0.1",
"port" : "9001"
},
"telnet" : {
"enabled" : "true",
"ip" : "0.0.0.0",
"port" : "9000"
}
},
"zones" : {
"defaultstatus" : "0",
"ports" : {
"high" : "7400",
"low" : "7000"
}
}
}
}
----------------


I've been also switching things out one by one, but I guess I'm just terribad at this. I am hosting the server here on my laptop, and also playing the game on the same machine as well. As of now, I don't care if others can connect to the server or not, but I'd like to at least play for now.

[Huppy]

I don't understand what I am doing wrong...

----------------------
Here's the login.ini
-----------------------
[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 = 10.0.0.100 <<<<<<<<<<<<<<<<<<<<<<<< 10.0.0.
auto_create_accounts = TRUE



As I mentioned before,


In your login.ini the following 2 lines should look like this - (leave the "1" off the end of local_network IP)
listen_port = 5998
local_network = 127.0.0.

[Michelle-Bishop]

I did forget to do that. I just changed it now, tried both IP addresses without the 1 at end and still same issue.

Does the port need to be changed to 5999? I see on other guides it is.


[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 = 100.0.0
auto_create_accounts = TRUE


{
"server" : {
"chatserver" : {
"host" : "10.0.0.100",
"port" : "7778"
},
"database" : {
"db" : "peq",
"host" : "127.0.0.1",
"password" : "eqemu",
"port" : "3306",
"username" : "root"
},
"directories" : {
"logs" : "logs/",
"lua_modules" : "lua_modules/",
"maps" : "maps/",
"patches" : "./",
"plugins" : "plugins/",
"quests" : "quests/",
"shared_memory" : "shared/"
},
"mailserver" : {
"host" : "10.0.0.100",
"port" : "7778"
},
"qsdatabase" : {
"db" : "peq",
"host" : "127.0.0.1",
"password" : "eqemu",
"port" : "3306",
"username" : "root"
},
"world" : {
"http" : {
"enabled" : "false",
"mimefile" : "mime.types",
"port" : "9080"
},
"key" : "jSx0rDQnhBlY72zPJEABOErxZI1ZEBz",
"localaddress" : "10.0.0.100",
"locked" : "false",
"loginserver" : {
"account" : "",
"host" : "10.0.0.100",
"legacy" : "0",
"password" : "",
"port" : "5998"
},
"longname" : "Kera's Server",
"shortname" : "keraserver",
"tcp" : {
"ip" : "127.0.0.1",
"port" : "9000",
"telnet" : "disable"
}
},
"zones" : {
"defaultstatus" : "0",
"ports" : {
"high" : "7400",
"low" : "7000"
}
}
}
}


[LoginServer]
Host=10.0.0.100:5998

[Huppy]

You're missing a period.



[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 = 100.0.0 <<<<<<<<<<<<<<<<<<<<<<<<<<<< PERIOD MISSING
auto_create_accounts = TRUE

[Michelle-Bishop]

dump_packets_out = FALSE
listen_port = 5998
local_network = 100.0.0.
auto_create_accounts = TRUE


Hmm, still same issue. Server is UP, getting the 1017 error still.

[Huppy]

You've gone from this: 10.0.0 to this: 100.0.0. There is only one piece of advice I can give you. If you just want to play on the same machine, set ALL IP addresses in the configs to 127.0.0.1 (NOT localhost). Also in the login.ini use local_network = 127.0.0. If your client still gets a 1017 error, first check your eqhost.txt Are you using Titanium ? point it to 5998. Then if you still can't connect, get a different client. Try checking logs, both server/logs and client/logs. When it comes time to wanting your friends to play, (offline), you will have to set the configs up for a lan IP.

[Michelle-Bishop]

Well, one thing I keep noticing is this in the log files ---

This is what pops up when I only see my server, and trying to connect to ------
-
[World Server] New Zone Server connection from 407e66cf-4934-4af2-8fb8-4aa740b0a690 at 127.0.0.1:56447
[World Server] Account Attempting to be created: 'michellebishop' status: 0
[MySQL Error] 1062: Duplicate entry 'michellebishop' for key 'name'
INSERT INTO account SET name='michellebishop', status=0, lsaccount_id=2, time_creation=UNIX_TIMESTAMP();
[World Server] Account Attempting to be created: 'michellebishop' status: 0
[MySQL Error] 1062: Duplicate entry 'michellebishop' for key 'name'
INSERT INTO account SET name='michellebishop', status=0, lsaccount_id=2, time_creation=UNIX_TIMESTAMP();
[World Server] Account Attempting to be created: 'michellebishop' status: 0
[MySQL Error] 1062: Duplicate entry 'michellebishop' for key 'name'
INSERT INTO account SET name='michellebishop', status=0, lsaccount_id=2, time_creation=UNIX_TIMESTAMP();
-----------

When I am able to log in, online, viewing all servers with eqemulator --
--
[World Server] New Zone Server connection from f5376ec0-4e93-4bc4-9fe1-9356e43b32da at 127.0.0.1:56622
[World Server] Account (MichelleBishop) Logging(In) to character select :: LSID: 298585
---

Does this mean anything?
Either way, I do appreciate the help. It seems like I am close to getting this to work, but I could be totally wrong.

[Uleat]

I think Huppy ran into this recently on another thread.

IIRC, an account of that name was made in the world accounts table by another login server.

If you changed login servers for your server, this is most likely the case.

Deleting the account and letting it be created in your current login server is probably the easiest fix - assuming that you have no game time accumulated.

You may be able to manually create a login server account locally to match the world account entry..that should avoid the issue with auto-account creation too.

[Michelle-Bishop]

I think Huppy ran into this recently on another thread.



If you changed login servers for your server, this is most likely the case.

Deleting the account and letting it be created in your current login server is probably the easiest fix - assuming that you have no game time accumulated.



How would I go about doing either or then? I'm not sure where the account is stored at. If it's as easy as deleting some lines of text in a document, sounds easy enough I assume.

[Huppy]

What Uleat was explaining, involves going into the database tables (account, etc.) If it's going to be complicated for you, I would suggest just logging in with a brand account name. (not the michellebishop name). A totally brand new login account name that you have never used on the emu public loginserver.

[Michelle-Bishop]

Okay well, I just created a new account, new P99 forum account, all that stuff. I am now in-game, while just viewing my server on the list.

I think you guys did it. Going to save and back all this up now and see how things work and give an update.

Happy

[Huppy]

I am now in-game,

Happy

Glad to hear you're up and running. Many of us have been down that road when first starting out. Way back when, I learned the hard way about how a tiny little thing like a typo, or missing character can halt your server totally. I even had an incident where I mistakenly got myself banned from my own server, lol. Tons of fun, but even now, after all this time, I still have to ask a question once in awhile. I don't think it ever ends totally.

[Michelle-Bishop]

Out of paranoia, I backed everything up on multiple USB drives, Google Drive, e-mail, my PC, everywhere lol.

So far so good. I guess the only issue I see right now, is that my hotkeys aren't working properly. Shift, Ctrl, Alt (both left and right) do not work, along with other keys. Shift/Ctrl/Alt+ any other key works, but not without. Both my keyboard, and laptop's keypad aren't doing the trick. Either way, that is something I don't see why I can't fix with some more googling.


For now though, I am trying to make my first toon a GM. I am reading guides on how to, and people keep referring to a "accounts table" in my database. I have no clue where this file is. Is this accessible via command prompt, or is it a file within my emulated server?

Either way, I will have internet access where I am moving to, but it's completely unreliable, but I can still view webpages and do some minor/amateurish tweeking as time goes by and get comfortable with toying with the server.

I am unbelievable happy that I was actually able to get this to work as of now. At some point, I'd like to dual box at the least. I'm assuming, if I run a 2nd client on my laptop, I'd be able to log into the server with a 2nd account?

[Huppy]

To set an account as a GM, it has to be done in the database. Things would be a lot easier for you if you could access it with a program. I use Navicat, but it's not a free download. I have no idea what others are using. BUT, if you know the password that was issued for you to log into the database you can do this from a command prompt. Example:
Type> mysql -u root -p
It will prompt you for the password. Then you will have the mysql prompt.
mysql> use peq
mysql> UPDATE account SET status = 255 WHERE name = 'username'; (username is account name you created) Make sure you encase the name with ' ' as shown.
Then simply log out of mysql by typing exit.

[Michelle-Bishop]

I was able to use the HeidiSQL thing that was installed at some point when I was setting the server up, and seems to work just fine.

Navigating that thing is confusing though. I did manage to delete the account info for the one that I wasn't able to log in with, and am now able to! I'm also glad to see that I am able to log in with both and play at the same time.

I was also able to make myself a GM with the heidisql program. I haven't left Gloomingdeep yet as I've been busy, but seems like things are working fine as of now.


So, with the HeidiSQL thing, I was able to edit all sorts of things. Is that where people are editing their servers at? Like, would I be able to, with time, patience and some learning, do the same?

Also, in case I may want to at some point, I have this SQL file that doesn't change much, but is more "solo" friendly. It says to just add the SQL file into my database. How would I add that? And if I were to just delete it from my DB, is that all that is required to revert back?

[Huppy]

When it comes to learning all about this, anyone is capable, but there is a LOT of reading to do, and usually never stops, depending how far you want to go with customizing your server. If have spare time, you might want to read and learn all about SQL. (structured query language). Once you learn how to manipulate your database tables using sql queries, etc, it will come real easy for you. But like I said, tons of reading to do. Learning perl and/or lua is handy for editing quest scripts as well. I haven't even touched base with lua yet. I'm in no hurry ;)

[Michelle-Bishop]

Honestly, I think I am fairly good for quite some time with just the basic stuff here. I would like to at some point get into editing the database and learning more about customizing the server, but I can't altering it too much.

There is the Solo friendly SQL thing that I may want to try at some point, but honestly, I can already see investing lots of time into this already.

I guess the only thing I may want to do, is open it up to people via LAN or our Network here. But I won't even start thinking about that for maybe half a year or so I'd say, heck maybe a year.


Thank you so very much Huppy and Uleat! You two have improved my quality of life by helping me set this up.