Noob Question, Loginserver

[Figback65]

So, I feel really stupid but I cannot find my problem with this. To start, I cleaned my server and made it a stand alone server with nothing installed but whats needed to host my LS account connection and server.

I built a small devbox and setting up login server so I can connect to it but I am having some damn issue.

My error on starting loginserver.exe is,

Failed to connect to MySQL database. Error: Access denied for user 'root'@'localhost' (using password: YES)

I cannot find my problem.

I followed the setup. http://wiki.eqemulator.org/p?Windows...Guide&frm=Main

step 1: ticked login
step 2: recompiled
step 3: copied executable and loginserver.pdb
step 4: sourced load_login
step 5: created login account with name and password to my choice
step 6: <loginserver>
<host>127.0.0.1</host>
<port>5998</port>
<account></account>
<password></password>
</loginserver>
step 7: copied and made the batch file.
step 8: downloaded the dependencie and put it in my server folder.
step 9: setup login.ini
[database]
host = 127.0.0.1
port = 3306
db = the4
user = root
password = my password
subsystem = MySQL

Copied login.ini, login opcodes.conf, login_opcodes_sod.conf.

My password is correct in the login.ini. I have checked and checked. I even redid my navcat connection and in command prompt did a MySQL -uroot -p_______ and connected just fine.

I open command prompt and goto my server directory and manually type loginserver.exe and I get the error above, I let it load through start.bat and I get the error above and it auto closes.

I have tried using 127.0.0.1 and localhost, same problem.

I am using windows 10.
I have 3306 exception allowed in firewall
I can connect with EoC
I can connect with MySQL prompt
I can connect with Navcat.
Is there any crazy password problems with special characters like )(*&^%$#@! through the login.ini?
Is there something not mentioned on the setup page that has to do with any of the 4 database tables that get loaded in login.sql?

<!-- Only specify these two if you really think you need to. (read: You don't) -->
<address></address>
<localaddress>127.0.0.1</localaddress>

local address need to be 127? or actual IP address 192.168.1.

Every variation has me stumped and I am 100% sober! lol

[provocating]

Okay, just so I cover all bases. The database and loginserver are on the same physical machine? Also, I seem to remember some issues with a few special characters at some point. That may not still be a problem but years ago I remember a few special characters could not be in the login.ini file under password.

[Figback65]

yes, database and login are on same machine.
I have 2 machines.
Dedicated server has database and no login, can connect publicly.
DevBox has database and login, Server starts up but loginserver.exe crashes.

[provocating]

Originally Posted by Figback65

yes, database and login are on same machine.
I have 2 machines.
Dedicated server has database and no login, can connect publicly.
DevBox has database and login, Server starts up but loginserver.exe crashes.

Try changing your mysql password to something simple, for testing purposes only.

[Figback65]

Ok let me google up how to change root password.

[Figback65]

Yup, sure enough. There is some special character in !@#$% area that cannot be used in the login.ini. Changed my root password and loginserver.exe started up.

Thanks Provocating

[Figback65]

Now to figure the rest of setup so I can connect across lan and not exactly load eq client on the devbox.

[provocating]

Originally Posted by Figback65

Yup, sure enough. There is some special character in !@#$% area that cannot be used in the login.ini. Changed my root password and loginserver.exe started up.

Thanks Provocating

Your welcome, figured that was it. I ran into the same thing 4 years ago.

[Uleat]

I've posted many times on how to configure for LAN/localhost setups.

Doing an advanced search using my name should bring up a few hits

[Figback65]

Originally Posted by Uleat

I've posted many times on how to configure for LAN/localhost setups.

Doing an advanced search using my name should bring up a few hits

Maybe you should add that line to the setup guide lol

[ionhsmith]

with this setup can you use it to make your own public log in that doesn't show all of the other servers?

[Figback65]

You can, you just have to hand out your public ip or DNS to the people you want connecting to you directly. They will put that info in the eqhost.txt in their client. Make sure the correct ports are forwarded and exceptions in the firewall as well.