Updated Windows Server Setup Guide

[spidey1170]

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]

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

mysql -u root -D peq -p

[Jobe123]

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]

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]

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]

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.

[gibroni]

i do not get step 9 in this guild about creating another database called peqlogindb? as far as i have tried and messed arouind with this, nothing uses that database, it is using the account section in peq database and i think that is why i am having issues. i have a server up and runing but no one can log in and create their own account. only can log in if i create them an account in peq/account myself. so what is step 9 actually doing?

[vales]

Originally Posted by tnance1337

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.

Sorry, missed the post since it's kinda confusing with two topics with people responding in both. :P Can we get a lock on the other one that's not a sticky, please?

Did you by any chance have a EQEmu server set up prior to this?

[tzu-theory]

I am getting stuck on the following, highlighted in bold. What file is this and where is it found? I admit my naivete but I appear to be so close

11.) Setting up the world server. Here's the sql file to make the world server entry.

Again, the red text is what you want to modify with your server name.
NameOfServer is the actual name of the server.
ShortNameOfServer is the shortname for client files in your game directory (i.e. UI_Soandso_ShortNameOfServer.ini).
ServerTagDescription is what you will see in parenthesis after the server's name - i.e. NameOfServer(Come and have fun!)
The green number 2 signifies what kind of server it is. 1 = Legends, 2 = Preferred, 3 = Standard.

[smcallister88]

Upon launching the login server, at the end, i get:

[Database] [1.11.12 - 00:31:38] Mysql query failed: SELECT max(ServerID) FROM tblworldserverregisteration
[Database] [1.11.12 - 00:31:38] Mysql query failed: UPDATE tblworldserverregisteration SET ServerLastLoginDate = now(), ServerLastIPAddr = '127.0.0.1' where ServerID = 0

Where would be a good place to start looking? I checked out login.ini and eqemulogin.ini so far both look perfect...

[Whoopee]

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]

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]

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

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!