Updated Windows Server Setup Guide

Jobe123 · #1 08-01-2009, 03:07 PM

I know I am drudging this up from god knows how long ago, however I am having one small problem, and this guide is extremely well written.

On step 10 and 11 where it says to copy the text or Import as SQL files I am a bit lost. I do not know where to paste these lines in at, and the import function seems off to me as simple as the rest of this was. Everything else is smooth as silk. Also after you do step 10 and 11 is there a save button? I cannot seem to find one and don't want to mess things up by redoing steps that may force this not to work.

All I really need is clarification of step 10 and 11 and I should be fine, Sorry to bother you with such trivial questions but I am 100% new at this and this guide is quite amazing, just had one question.

spidey1170 · #2 08-01-2009, 03:33 PM

Jobe,

I used a CL (command line) input into mysql for this:

Click on START

Then choose RUN and type CMD, this will pull up a command line interface

Next, type (without quotes): "mysql -u root -p"
Enter your password when prompted

Type "\u peq" and hit ENTER

Then you are able to type in the sql query, hit ENTER and it should work. Hope that helps =)...

**joligario** · #3 08-01-2009, 03:40 PM

Just to add on.. You can specify the database in the command line also.

Code:

mysql -u root -D peq -p

Jobe123 · #4 08-01-2009, 06:38 PM

thanks, also if anyone wants to feel free to answer a few more questions... what do I set my dydns to so I am able to get it connected to the loginserver? is it my IP address?

tnance1337 · #5 08-02-2009, 01:32 PM

Total newbie to this sort of thing, but not a complete idiot and easily trainable. Having trouble with logging into my server.

Not quite sure what I'm doing wrong here. I've completed all steps exactly (to my knowledge) yet when I try to connect my client (using the account name and password I created in tblloginserveraccounts), I keep getting the username and password does not exist error.

EQEmu Login Server window shows that my client is trying to connect but shows "could not find user 0". Not sure what to do for this...looked around on the forums for an hour or so and can't quite figure it out.

Obviously my settings are correct (I think) just something missing somewhere that recognizes the correct username and password. I've tried deleting and re-entering (in heidisql) the sql entry for tblloginserveraccount multiple times with different usernames and passwords, but nothing seems to work. The data tab definitely shows the same user and pass as I'm entering in.

I'm sure it's something simple, but I'm just not familiar enough with this to understand why it's not working. Any help is appreciated.

vales · #6 08-02-2009, 02:24 PM

You guys are free to discuss support for the server setup guide, but I won't be updating it here anymore (since I can't). I hightly recommend checking out the revised guide in my signature - now hosted on the wikki.

If there's anything as far as support questions go, feel free to post here and and someone is bound to offer some help when they can.

tnance1337 · #7 08-02-2009, 02:45 PM

I'm guessing you don't know the answer to my problem, Vales? Lol. I've gone back and run the setup again from the guide in your sig and still same result.

Whoopee · #8 10-06-2009, 12:26 AM

As explained above in Step 2, create a new folder and name it something easy to remember like EQEmu Server Files or something.
Right-click that folder, and paste in the SVN address: http://projecteqemu.googlecode.com/svn.

create this folder where?

bthomsen0312 · #9 11-10-2009, 12:40 AM

so the multitude of guides on thie site confuse me, as it seems like all of them tie together in some weird way, however i followed the steps on this guide and ended up with the error perl58.dll is missing.. i tried searching was there something i missed? the only thing im seeing is that i should have the other used version of perl but i followed this guide

Eva Aisling · #10 02-25-2010, 12:48 AM

I didn't understand instructions at #10 on how to use heidisql, so I used method suggested by this user:

Quote:

Originally Posted by spidey1170

I used a CL (command line) input into mysql for this:

Click on START, RUN and type CMD, this will pull up a command line interface

Next, type (without quotes): "mysql -u root -p"
Enter your password when prompted

Type "\u peq" and hit ENTER

Then you are able to type in the sql query, hit ENTER and it should work. Hope that helps =)...

I ended up with this error:
ERROR 1146 (42S02): Table 'peq.tblloginserveraccounts' doesn't exist
mysql>

Any input or advise would be greatly appreciated!