Lol, I was just playing around. My problem is practically unfixable apparently. So I guess I'm withdrawing from starting my own server. :cry: PS... thank you all for your hard work :)
|
OK, I wasn't sure by the way you posted that. Glad to hear it. So, do you know how you got rid of the 2006 error?
I'm still messing with everything. I've completely uninstalled mysql (including my.ini, the mysql folder and the registry settings) and reinstalled. And then resourced the db.sql that came with the win32 Eqemulator5.0.zip into a brand new eq database. The db.ini and LoginServer are as correct as they could be. And the user name and password are correct. One other thing, I am running mysql-3.23.58-win with MyODBC-3.51.06. Perhaps I need to download the newest versions available for this new version of EQEmu? Could this be causing the problem? PS - I followed the guide that was given, just to be on the safe side, and that is EXACTLY the way I've been doing it. The only thing I'm not sure of now is mysql program itself. Maybe 5 was built to find the newer version of mysql (4?). Any thoughts on this, anyone? :D |
Here is how I fixed #2006: I tried Grant all privileges on eq.* to Daeroth@localhost with grant option;
Didn't work. 1. Start>run>cmd>dos - Then I did: cd mysql/bin 2.Then the path was: Mysql/bin 3.Mysql -u root mysql Blah blah blah came up 4. Do Grant all privileges on *.* to name@localhost with grant option; Just do that no 'eq.*' just *.* then that's it. That's what fixed it for me...I don't think i did anymore than that... but if that doesn't work tell me ;) |
Just tried that. Plenty of S&G's but no luck. I'm starting to think a sledgehammer is the answer... :twisted:
|
Astartae - restate the current errors you're getting and your problem, i think it's lost in the shuffle. Also, what OS?
|
I posted my world.exe, db.ini and LoginServer.ini data on page 2 as quotes. If you look there, you should find them. And I am on an XP Home Ed. using 512 mb ram and p4 with 1.4 ghz. I set up 4.3 and 4.4 servers with few problems and ran them until something in the eq folder decided to die. ;-)
Now, I am trying to set up the new 5 server and having trouble starting the world.exe file. I've set up db.ini and LoginServer.ini correctly. I've even hand typed them, just to make sure there are no strange invisible characters messing me up. I have mysql 3.23 running on my computer. A few people have mentioned having no problem running them (on Linux I think) but I'm currently downloading 4.0, just to try it out and see if I have any better luck with it. I also installed MyODBC 2.5 and 3.51 just so that it wouldn't show "not found" in that window. I probably didn't need to but I wanted to cover all my bases. I've tried many different things to get world.exe to work. Most recently I've been trying changing the names of the ip address from my online ip addy (not a static ip) to localhost to 127.0.0.1 in the LoginServer.ini. That didn't make much difference. I also tried changing the ip addy in the db.ini and using the miniserver.exe. Putting localhost or 127.0.0.1 in the db.ini made no difference but when I put in my actual online ip address, I actually got a response between the miniserver.exe and the world.exe. Here are the printouts: world.exe: Quote:
Quote:
I have a feeling that I'm forgetting some silly and easy little thing that is going to make me want to smack myself after I fix it. I just wish I'd find that things so I can get in the game finally... |
When you reinstall your MySQL make sure to delete the my.ini file in your windows directory. Try that reinstall and start over with the database.
|
I did that actually. And flushed the registry and the mysql folder. And then did a reboot before I reinstalled mysql. I thought that would fix it but it didn't. Then I was very careful about setting up the eq database with the permissions exactly correct.
Do you think that some XP program could be messing with world.exe finding mysql? I thought that I turned all firewalls off (I don't care for them anyway) but maybe there is one on. But I've tried this on the miniserver as well as the eqemu server with the same results. |
Also when I do the following command at a dos promt, I get this:
Quote:
|
After trying all of this I finally had the idea of changing the case of my username to all lower case. And wow! It worked! I just had a small database error (easy to fix) and presto the world.exe was running just like it should.
So it seems it was a username/password problem but the solution was easier than any of us where thinking. (Lol, isn't that often the case). I wanted to thank all of you who helped and tried to help. I do appreciate it even if it doesn't get me anywhere. In this case it mostly helped to get me thinking in the right direction... Edit - lol, now I'm getting that annoying 1017 error. Time to fix that too. ;-) Can't tell I'm happy about this, can you? :P :lol: :) |
All times are GMT -4. The time now is 01:43 AM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.