Ok, the guide has been updated to account for those steps.

Yes I am trying to simply make a LAN server.

I found the SQL entries for login access and updated them. I was looking for one that started with "tbl" so... that was my mistake. I'm not sure if those tables were in the database to begin with or if they generated after I ran that command that Huppy recommended. But that resolved the error messages I was receiving.

I no longer get the error in the server window about the "tblloginserveraccounts"

However, I still cannot login to my account when eqhost is pointed at my server.

It used to tell me the username/password was incorrect, but now it says:

"A connection to the server cannot be reached, please check your internet connection"

I believe I must have either missed something or modified something I wasnt supposed too. One thing I've noticed while reading the server window information is that the server connections are all pointing to the default address of "127.0.0.1" I do not know if this is supposed to be the case, or if this is why I cannot connect to it.

Here is part of the message I am talking about:

[World Server] New Zone Server connection from 305f9dac-dffe-4b27-a1f2-b2df1931d31c at 127.0.0.1:50060
[World Server] New Zone Server connection from aa4e70b4-ef5c-42ef-a0b0-47b1e3cbf032 at 127.0.0.1:50063
[World Server] New Zone Server connection from 353d21ae-1280-4d3c-8567-2df04ba0abb7 at 127.0.0.1:50067
[World Server] New Zone Server connection from 8edca42d-9d93-4a86-b947-29b8a0dbea58 at 127.0.0.1:50071
[World Server] New Zone Server connection from 93635017-926a-4955-b411-21384fd619f4 at 127.0.0.1:50073
[World Server] New Zone Server connection from aed7a0a2-3e88-48a2-8918-f5004dea1d48 at 127.0.0.1:50076

should these be my local address instead of 127.0.0.1? if not, I wonder if I accidentally changed some address values I shouldnt have when I was trying to fix my previous issues. The addresses I changed would have been in the login.ini or eqemu_config.json files. I think its the .json thats the issue. I'll post what I have, and hopefully someone can identify where I went wrong.

I think i'm really close to a solution on all of this now, and its all thanks to you guys, thank you very much! I really appreciate all of your help! <3

this is my .json file as of now, I think this is where I went wrong, but i'm unsure as to what I need to change.

"

{
"server" : {
"chatserver" : {
"host" : "192.168.0.113",
"port" : "7778"
},
"database" : {
"db" : "peq",
"host" : "localhost",
"password" : "eqemu",
"port" : "3306",
"username" : "root"
},
"mailserver" : {
"host" : "192.168.0.113",
"port" : "7778"
},
"qsdatabase" : {
"db" : "peq",
"host" : "localhost",
"password" : "eqemu",
"port" : "3306",
"username" : "root"
},
"webinterface" : {
"port" : "9081"
},
"world" : {
"localaddress" : "192.168.0.113",
"http" : {
"enabled" : "true",
"mimefile" : "mime.types",
"port" : "9080"
},
"loginserver1" : {
"account" : "-myaccount-",
"host" : "192.168.0.113",
"password" : "-mypassword-",
"port" : "53286"
},
"longname" : "EQUNBOUND",
"shortname" : "UNBD",
"tcp" : {
"ip" : "192.168.0.113",
"port" : "9001"
},
"telnet" : {
"enabled" : "true",
"ip" : "0.0.0.0",
"port" : "9000"
}
},
"zones" : {
"defaultstatus" : "0",
"ports" : {
"high" : "7400",
"low" : "7000"
}
}
}
}

"

I would put your "world" : "loginserver1" : "port" value back to '5998' to help alleviate confusion.

(Make sure that the login.ini file uses the same port.)


The two database entries should be localhost and all others the lan ip address - which all of yours are.


You have the "localaddress" tag set correctly.


I would just verify the 'local_network' value in login.ini is set to and notnor
EDIT:

Also, make sure that your clients are pointing to '192.168.0.113' in their eqhost.txt file.

- Use port 5998 for 'Titanium' and 'Secrets of Faydwer' clients.

- Use port 5999 for all others, including both 'Rain of Fear' clients.


The guide did kind of mis-match in the details of that and has since been corrected.

Thanks again for the quick response and help. I went ahead and corrected those items. For some reason though if I change the db: PEQ to localhost my server will not boot up.

I am able to log in to the server screen now but I do not see the server listed. I will attach a screenshot of what everything looks like.

Also, the following thread mentions "updating the DB to be accurate" I'm not sure if there is further action I need to take regarding that.

http://www.eqemulator.org/forums/showthread.php?

https://pasteboard.co/Is0lkij.png


I did add some additional items I believe I was missing that I took from the thread above.

If I understood you correctly I need to change " "db" : "peq", " to: " "db" : "localhost", " on both of the " "db" " entries. Is that correct?

when I did that the server would go in a loop over and over attempting to load up without ever populating all four windows.

Just making sure I'm not missing anything else, I've copied the json, .ini, and eqhost files all below here.

Does any of it look off?

Thanks again!

Here is my eqemu config file:

"

{
"server" : {
"chatserver" : {
"host" : "192.168.0.113",
"port" : "7778"
},
"database" : {
"db" : "peq",
"host" : "localhost",
"password" : "eqemu",
"port" : "3306",
"username" : "root"
},
"mailserver" : {
"host" : "192.168.0.113",
"port" : "7778"
},
"qsdatabase" : {
"db" : "peq",
"host" : "localhost",
"password" : "eqemu",
"port" : "3306",
"username" : "root"
},
"webinterface" : {
"port" : "9081"
},
"world" : {
"localaddress" : "192.168.0.113",
"http" : {
"enabled" : "true",
"mimefile" : "mime.types",
"port" : "9080"
},
"key" : "KfNJhzxGO6kJMKjdytVjgsoFUkahRzX",
"loginserver1" : {
"account" : "- my account name -",
"host" : "login.eqemulator.net",
"legacy" : "1",
"password" : "- my password - ",
"port" : "5999"
},
"loginserver2" : {
"account" : "- my account name -",
"host" : "192.168.0.113:",
"password" : "- my password -",
"port" : "5999"
},
"longname" : "EQUNBOUND",
"shortname" : "UNBND",
"tcp" : {
"ip" : "192.168.0.113",
"port" : "9001"
},
"telnet" : {
"enabled" : "true",
"ip" : "0.0.0.0",
"port" : "9000"
}
},
"zones" : {
"defaultstatus" : "0",
"ports" : {
"high" : "7400",
"low" : "7000"
}
}
}
}


"

and here is my login.ini:

"

[database]
host = localhost
port = 3306
db = peq
user = root
password = eqemu
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 = 192.168.0.
auto_create_accounts = TRUE

[security]
plugin = EQEmuAuthCrypto
mode = 5

[Titanium]
port = 5998
opcodes = login_opcodes.conf

[SoD]
port = 5999
opcodes = login_opcodes_sod.conf

[schema]
account_table = loginserver_server_accounts
world_registration_table = loginserver_world_server_registration
world_admin_registration_table = loginserver_server_admin_registration
world_server_type_table = loginserver_server_list_type

"

and here is my eqhost.txt in the client's directory:

"

[LoginServer]
Host=192.168.0.113:5999

"

Also, if I may, i'd like to clarify two other things:

As I am running the RoF client, shouldn't I have 5999 as my loginserver port? or should it still be 5998? and should I have the two separate loginserver entries in my json configured as I do as per this post? I added the original "loginserver 1" back into my json. after re-reading the guide once more. Trying to find and fix whatever it is I'm missing.

Thanks again for the information and your time!

By the looks of that screenshot above, your server started up fine. Your EQEmu server, needs to connect to a login server. Either public, private, or (in your config), both. They need a port number to connect. Then your client needs a port to connect to the loginserver. Hence, (as per code) 5998 for Titanium/SoF and all others 5999.

Then your client will use one of these: (after your server and loginserver have connected.) Do not change these.
From your login.ini :

[Titanium]
port = 5998
opcodes = login_opcodes.conf

[SoD]
port = 5999
opcodes = login_opcodes_sod.conf

EDIT: I forgot to mention something, just in case you may not be aware of it. Some people's LAN setup, with your server using one particular LAN IP (such as 192.168.0.113), your router/modem dhcp, may be setup to assign each device connecting to it, with a dynamic IP. (subject to change all the time). I have to assign a static LAN IP for my server in my modem config, so it never changes. You would have to login to your router/modem to do that.(different models, different brands, different setups). Otherwise, when you restart/reboot that particular computer, it may get assigned a different LAN IP and your client computer won't find it on the LAN.

I apologize if I confused you about the two database entries.

I was referring to the "database" and "qsdatabase" tags.

Their addresses ("host") should be localhost. Your original posting had that correct.

The "db" field refers to the name of the database that was created during the install - most likely "peq."


The ports that you are changing do not reflect client ports.

They are ports used by the various server programs to communicate among themselves.


Aside from the port changes that Huppy recommended above, the rest still looks ok.