Private Server Accounts
Hi all,
Been a while since i posted, been taking a break. Well since that break i have forgotten something or i have no clue anymore why this is happening. I have my private dev box setup and works and I can connect to it and other can connect to it np, even through hamachi VLan. The problem is they can only connect with my old accounts I had setup. Basically my GM accounts. Any new accounts i make goes into the table but when you try to login EQ says the username and password are incorrect. Code:
INSERT INTO tblloginserveraccounts (AccountName,AccountPassword,AccountEmail,LastIPAddress,LastLoginDate) Again, with my old GM accounts I and others can login, just not new accounts that i make. Thank you |
I ran the script and it works just fine.
Do you happen to have your server locked and the new accounts don't have the proper status to login? |
Hmm i dont ever remember changing that, but i will look into it and update. Thanks Uleat. I know its a dumb question but i cant remember! lol
EDIT : No, Cant even get to server select screen. The initial Login to server select pops back, Username and or password is not valid. Cannot get to server select. Ive made new ones and tried to login them myself and cannot login. But my old ones work just fine. I am so confused lol EDIT : just double checked and new accounts made go into the correct tbloginserveraccounts table. |
You've got a *LONG* way to go before you catch up to me with dumb questions :P
|
Quote:
lol :) |
Was gonna ask about having 2 `tblloginserveraccounts` tables in different db's..but, you answered that already.
Ok, I just tested an account created by your script. I was able to get to character select with Titanium, UF and RoF2. If the old accounts were having issues logging in as well, it would be more telling of the cause :/ |
Quote:
I deleted my 4 TB tables and re-ran the sql to add the tables back in to the proper database to bypass any issues and then created new accounts and I cannot login still. I have to be missing a step or something lol |
I only had to set this up once 2 years ago, now i cant remember how and cannot find the link I had that had all the extra info that the wiki doesnt tell you.
Code:
[Database] [04.07.15 - 17:00:40] Mysql query failed: 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 = 'Pirates' EDIT Now no accounts work lolol. |
This could be the issue, I assume there may have been a swap from windows db to linux also?
INSERT INTO tblloginserveraccounts ( [Database] [04.07.15 - 17:01:07] Mysql query failed: SELECT LoginServerID, AccountPassword FROM tblLoginServerAccounts WHERE AccountName = 'unknown' Best when running a loginserver to run it independent of other db's, ie have a db named "loginserver" and use it only for that purpose. This is better if you want to run multiple servers on your network (which everyone should, (ie, testserver that you are testing all your changes on right?) |
No, i did not swap to linux, still on win7. I manually changed the login names to unknown for security purposes.
|
I wasnt reffering to unkown, hint, it is highlighted in red.
But probably not the issue, sorry, carry on... |
Quote:
Lol Red. For some reason i thought it was search results. :) Going to check git again, maybe new compile has incompatable stuff from old load_logins.sql |
Quote:
Not sure with the wipe..I would double-check your config files to make sure they are using the correct database - especially the login.ini one since that's where the login server gets its settings from. |
Quote:
EDIT I feel like a n00000b now. I swore i checked that thing 3 times. |
All times are GMT -4. The time now is 09:35 AM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.