How do i change MySql Username/Pass for my Server?

[infernal]

I have problems starting my own server.
I used Jezebell's Guide which was very easy to use. But i do have a problem, and when i run boot5zones.bat, it brings up the 6 windows with all the same error:.... :evil:


<prev txt here>.........
[Error] Loading npcs FAILED!
===============================
Runtime errors:

MySQL Error #1405 or $2001 means your mysql server rejected the username and password you presented it.
For more information on this error, visit http://www.eqemu.net/eqemuerror.php?id=1

Hit any key to exit



.... Well The website link does not work and i am not sure where i can change the username and pass for this...

Also, Which username pass do i use? A new one? the EQemu server username pass? and which one is causing the error?
:?: :?: :?: :?: :?: :?:

[Derision]

start/run/cmd

mysql -u root

grant all privileges on *.* to fred@localhost identified by 'fred' with grant option;

Edit your db.ini file and change the user and password fields to

user=fred
password=fred

or whaterever user and password you choose. Make sure there are no spaces at the end of any line, i.e. go to each line, press the 'END' key and press backspace if there is a space between the last character of the line and where your cursor is.

Make sure you type the grant command exactly as above, i.e. single quotes around the password (the second 'fred' in my example).

[cofruben]

you can edit your password/username in c:\windows\my.ini I guess.

[infernal]

I got a new error now :)
any idea what i did wrong?

WorldServer connect: Connecting to the server failed: TCPConnection::Connect<>:Couldnt resolve hostname. Error: 11001
[Error] worldserver.Connect <> FAILED!
[Status] Entering Sleepmode

[Derision]

11001 is a 'host not found' winsock error. Post your loginserver.ini, and also your boot5zones.bat file.

[infernal]

LoginServer.ini


[LoginServer]
loginserver=eqlogin1.eqemulator.net
loginserver2=eqlogin2.eqemulator.net
loginserver3=eqlogin3.eqemulator.net
loginport=5997
loginport=5997
loginport=5997
worldname=Yourservername
worldaddress=YourexternalIPAddress
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=

[LoginConfig]
ServerMode=Standalone
ServerPort=5999
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=

[ChatChannelServer]
ChatChannelServer=YourInternalIPAddress




boot5zones.bat


REM: ****Read this first!!!****

REM: This file requires your real IP in the place of "YourIP" when you are connecting
REM: To the EQEmu Loginserver.

REM: When you are using minilogin, Replace all IP Addresses to say 127.0.0.1

REM: If you still get errors try using localhost instead of 127.0.0.1

REM:--------------Start-----------------------
@echo off

if NOT exist spells_us.txt goto NOSPELL

start zone . YourExternalIP <4DigitNumber> YourInternalIP
start zone . YourExternalIP <4DigitNumber> YourInternalIP
start zone . YourExternalIP <4DigitNumber> YourInternalIP
start zone . YourExternalIP <4DigitNumber> YourInternalIP
start zone . YourExternalIP <4DigitNumber> YourInternalIP
exit
cls

:NOSPELL
echo You did not copy the spells_en.txt from your everquest directory to this one. Please do so or zones will crash on startup.
PAUSE

REM:---------------END------------------------

[infernal]

not sure what i put inplace of YourIpAddress
so let me know

[Derision]

To get YourInternalIP address:

start/run/cmd

c:\windows\system32\ipconfig

your internal IP address is on the line beginning 'IP Address'

To get YourExternalIP address:

goto http://www.whatsmyip.org

Where you have <4 digit number> in your boot5zones.bat, replace with 7995 for the first 'start zone' command, 7996 for the second, 7997 for the next, and so on.

[infernal]

where do i replace that at?

[infernal]

ok done with the boot5zone
What do i replace in the loginserver.ini?

[Derision]

Change these lines

worldname=Infernal Test Server
worldaddress=Whatever Your external IP Address is

ChatChannelServer=Your InternalIP Address

[infernal]

whats the difference between internal and external ip address?

Where do i find the internal one and where the external...

i got the one from www.whatismyip.org

... whats the internal one then?

[Derision]

Umm, from my post a few posts up in this thread:

To get YourInternalIP address:

start/run/cmd

c:\windows\system32\ipconfig

your internal IP address is on the line beginning 'IP Address'

To get YourExternalIP address:

goto http://www.whatsmyip.org

Where you have <4 digit number> in your boot5zones.bat, replace with 7995 for the first 'start zone' command, 7996 for the second, 7997 for the next, and so on.

[infernal]

the 2 of them are the same....
True?

[infernal]

gave me the exact same error.. heres my
LoginServer.ini

[LoginServer]
loginserver=eqlogin1.eqemulator.net
loginserver2=eqlogin2.eqemulator.net
loginserver3=eqlogin3.eqemulator.net
loginport=5997
loginport=5997
loginport=5997
worldname=Infernal Test [Dev]
worldaddress=68.104.241.117
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=

[LoginConfig]
ServerMode=Standalone
ServerPort=5999
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=

[ChatChannelServer]
ChatChannelServer=68.104.241.117

and my boot5zones.bat

REM: ****Read this first!!!****

REM: This file requires your real IP in the place of "YourIP" when you are connecting
REM: To the EQEmu Loginserver.

REM: When you are using minilogin, Replace all IP Addresses to say 127.0.0.1

REM: If you still get errors try using localhost instead of 127.0.0.1

REM:--------------Start-----------------------
@echo off

if NOT exist spells_us.txt goto NOSPELL

start zone . YourExternalIP 7995 YourInternalIP
start zone . YourExternalIP 7996 YourInternalIP
start zone . YourExternalIP 7997 YourInternalIP
start zone . YourExternalIP 7998 YourInternalIP
start zone . YourExternalIP 7999 YourInternalIP
exit
cls

:NOSPELL
echo You did not copy the spells_en.txt from your everquest directory to this one. Please do so or zones will crash on startup.
PAUSE

REM:---------------END------------------------

[Derision]

the 2 of them are the same....
True?

That is quite possible if you don't have a router. In that case, just use the same address for the Internal and External addresses.

[samandhi]

Try reading this article that covers some NAT and networking basics. Hope it helps..:)

http://gnrt.terena.nl/content.php?section_id=207 (http://gnrt.terena.nl/content.php?section_id=207)

Or this one:

www.25cubed.com/utd/myprogs/guest_presentation.ppt+what+is+the+difference+betw een+internal+and+external+ip+addresses&hl=en&ie=UTF-8] (http://216.239.41.104/search?q=cache:iZW89uo-Z0UJ:http://216.239.41.104/search?q=cache:iZW89uo-Z0UJ:www.25cubed.com/utd/myprogs/guest_presentation.ppt+what+is+the+difference+betw een+internal+and+external+ip+addresses&hl=en&ie=UTF-8 [/url]

[Derision]

If his internal and external IP address are really the same, he has no router, so NAT won't apply in his case.

[samandhi]

True Derision. I was in the process of doing a search for him when the last post was:
whats the difference between internal and external ip address?

Where do i find the internal one and where the external...

i got the one from www.whatismyip.org

... whats the internal one then? So didnt refresh the screen till after I posted... So didnt get it posted till AFTER all the other posts from that one to where mine ended up haha.. :)

[infernal]

i really think its the part of where i am connecting...
Have they changed the ip since Jazabell's Post?

[Derision]

The IP addresses of the login servers may change, but if you are using the names (eqlogin1.eqemulator.net , etc), then this will be transparent to you. The problem is with your config. Post your loginserver.ini, boot5zones.bat and the output of your world.exe and zone.exe processes.

[infernal]

LoginServer.ini

[LoginServer]
loginserver=eqlogin1.eqemulator.net
loginserver2=eqlogin2.eqemulator.net
loginserver3=eqlogin3.eqemulator.net
loginport=5997
loginport=5997
loginport=5997
worldname=Infernal Test [Dev]
worldaddress=68.104.241.117
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=

[LoginConfig]
ServerMode=Standalone
ServerPort=5999
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=

[ChatChannelServer]
ChatChannelServer=68.104.241.117

Boot5zones.bat

REM: ****Read this first!!!****

REM: This file requires your real IP in the place of "YourIP" when you are connecting
REM: To the EQEmu Loginserver.

REM: When you are using minilogin, Replace all IP Addresses to say 127.0.0.1

REM: If you still get errors try using localhost instead of 127.0.0.1

REM:--------------Start-----------------------
@echo off

if NOT exist spells_us.txt goto NOSPELL

start zone . 68.104.241.117 7995 68.104.241.117
start zone . 68.104.241.117 7996 68.104.241.117
start zone . 68.104.241.117 7997 68.104.241.117
start zone . 68.104.241.117 7998 68.104.241.117
start zone . 68.104.241.117 7999 68.104.241.117
exit
cls

:NOSPELL
echo You did not copy the spells_en.txt from your everquest
directory to this one. Please do so or zones will crash on
startup.
PAUSE

REM:---------------END------------------------

World.exe Output:

[Status] CURRENT_WORLD_VERSION:EQEmu 0.5.5
[Status] Loading variables..
[Status] Loading zones..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=26679, max id =68199
[Status] ./LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading ./addon.ini..
[Status] Loading EQ time of day..
[Error] Could not load EQTime file ./eqtime.cfg
[Error] Unable to load ./eqtime.cfg
[Status] Reboot zone modes ON
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Warning: You need to get laid...
TCP listening on: 68.104.241.117:9000
World server listening on: 68.104.241.117:9000
Connected to LoginServer: eqlogin3.eqqmulator.net:5997



Zone.exe Output:

It opens and closes too fast to see anything

[Derision]

Zone.exe Output:

It opens and closes too fast to see anything

start/run/cmd

cd to where your zone.exe is:

Type:

zone . 68.104.241.117 7995 68.104.241.117

That should show the errors that is causing your zones to crash. Copy and paste the output from that window.

[infernal]

hmm how do i do the cd one? long time to use Dos... let alone this..
its in my directory:
C:\Program Files\EQemu

[Derision]

start/run/cmd

Then type

cd \Program Files\EQemu

Then type

zone . 68.104.241.117 7995 68.104.241.117

[infernal]

ok here goes:

[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.5
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading items from database: Count=26679, max id=68199
[Status] Loading npcs
[Status] Loading NPCTypes from database...

[NarutoLegacy]

You need to boot5zones.bat not zone.exe

[infernal]

i already did that
i am still having the problem

[infernal]

ahh thereis a nother part of that which i fergot, came in later

[infernal]

[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.5
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading items from database: Count=26679, max id=68199
[Status] Loading npcs
[Status] Loading NPCTypes from database...
.................................................. ...................
.................................................. ...................
Then i get this error after the normal [Status]

WorldServer connect: Connecting to the server failed: TCPConnection::Connect<>:connect<> failed. Error: 10061
[Error] worldserver.Connect<> FAILED!
[Status] Entering sleep mode





So where do i go wrong?
Im not connecting to the worldserver correctly? what am i doing wrong?

[Monrezz]

start zone . 68.104.241.117 7995 68.104.241.117
start zone . 68.104.241.117 7996 68.104.241.117
start zone . 68.104.241.117 7997 68.104.241.117
start zone . 68.104.241.117 7998 68.104.241.117
start zone . 68.104.241.117 7999 68.104.241.117

should be

start zone . 68.104.241.117 7995 <internal ip>
start zone . 68.104.241.117 7996 <internal ip>
start zone . 68.104.241.117 7997 <internal ip>
start zone . 68.104.241.117 7998 <internal ip>
start zone . 68.104.241.117 7999 <internal ip>

Replace <internal ip> with your internal ip, found via Start => Run => cmd => ipconfig.

[Derision]

Earlier in the thread he stated his internal and external IP were the the same (checked via ipconfig and whatsmyip.org), so he doesn't have a router (apparently).

the 2 of them are the same....
True?

[Monrezz]

I don't have a router, my internal and external are different. He probably read the wrong IP, I know that my ipconfig gives three different addresses. There is more then likely a 192.168.*.* address, use that.

[infernal]

when i do run/cmd/ipconfig i get the following addresses:
IP Address
Subnet Mask
Default Gateway
Anyone of these is probably it?
IP Address Appears the same as my External IP Address.
Any ideas?
I guess i could do a guess and check on all 3 of them... should i try that?

[infernal]

Im guessing nobody has had this error before?
Iv tryed changin all in localhost.ini to localhost but still gives me the same error... not sure where the problem is :?:

[Monrezz]

Replace internal ip with 127.0.0.1.

[samandhi]

Try running ipconfig -all This should tell you all that you need to know... :)

Though, I would follow Monrezz's advice and simply put 127.0.0.1 or localhost for the second part of your boot5zones.bat
start zone . <IP> 7995 localhost (or)
start zone . <IP> 7995 127.0.0.1

Also, if you are using Windows XP make sure that ICS (internet connection sharing) is off, and that you dont have the built in firewall running.. If you are running another firewall program, disable it long enough to make sure that it is NOT the problem...

Are you running DSL or dial-up (sorry if you stated that I might have missed it)? If you are running DSL, do you JUST have a DSL modem, or are you sure it is NOT a combo modem/router? (just a couple of questions to get you thinking hehe)....

[mikenune]

LoginServer.ini

[LoginServer]
loginserver=eqlogin1.eqemulator.net
loginserver2=eqlogin2.eqemulator.net
loginserver3=eqlogin3.eqemulator.net
loginport=5997
loginport=5997
loginport=5997
worldname=Infernal Test [Dev]
worldaddress=68.104.241.117
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=

[LoginConfig]
ServerMode=Standalone
ServerPort=5999
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=

[ChatChannelServer]
ChatChannelServer=68.104.241.117

Before trying to connect your server to eqemulator's login servers, I'd try just running one on Localhost with MiniLogin.exe. To do that, change the following section of your LoginServer.ini file from

[LoginServer]
loginserver=eqlogin1.eqemulator.net
loginserver2=eqlogin2.eqemulator.net
loginserver3=eqlogin3.eqemulator.net
loginport=5997
loginport=5997
loginport=5997

to
[LoginServer]
loginserver=localhost
loginport=5997

Then, after you've done that, change the following section of your Boot5zones.bat from

start zone . 68.104.241.117 7995 68.104.241.117
start zone . 68.104.241.117 7996 68.104.241.117
start zone . 68.104.241.117 7997 68.104.241.117
start zone . 68.104.241.117 7998 68.104.241.117
start zone . 68.104.241.117 7999 68.104.241.117

to

start zone . localhost 7995 localhost
start zone . localhost 7996 localhost
start zone . localhost 7997 localhost
start zone . localhost 7998 localhost
start zone . localhost 7999 localhost


Of course, if you don't want to do that (if you're pretty sure your ISP will let you run a server from home), I'd just take a look at your EQEMu folder for any stray files. I noticed in your World.exe output that it says

Connected to LoginServer: eqlogin3.eqqmulator.net:5997
What it should say is

Connected to LoginServer: eqlogin3.eqemulator.net:5997

The only way this could happen is if there's a typo in your LoginServer.ini that's not showing up. Because Windows XP doesn't like to let you manage file extensions, it's entirely possible that the file you're showing us is actually "LoginServer.ini.txt" instead of "LoginServer.ini."

The best way to verify you have the right file is by opening Windows Explorer, browsing to your EQEMu folder (typically C:\eqemu), and looking at the description of your LoginServer.ini file. If it says "Configuration Settings" then you've got the right one (might be called just "LoginServer"). If you have one called "LoginServer" that has the description of "Configuration Settings" and a file called "LoginServer.ini" that has a description something like "Text File" or "Notepad Document" then you're probably editing the wrong file.

Delete the once that DOES NOT have the description of "Configuration Settings" and edit the one that DOES.

[cofruben]

LoginServer.ini

[LoginServer]
loginserver=eqlogin1.eqemulator.net
loginserver2=eqlogin2.eqemulator.net
loginserver3=eqlogin3.eqemulator.net
loginport=5997
worldname=Infernal Test
worldaddress=68.104.241.117
locked=false

[WorldServer]
Defaultstatus=0
Unavailzone=

[LoginConfig]
ServerMode=Standalone
ServerPort=5999
UplinkAddress=
UplinkPort=
UplinkAccount=
UplinkPassword=


boot5zones.bat

start zone . 68.104.241.117 7995 127.0.0.1
start zone . 68.104.241.117 7996 127.0.0.1
start zone . 68.104.241.117 7997 127.0.0.1
start zone . 68.104.241.117 7998 127.0.0.1
start zone . 68.104.241.117 7999 127.0.0.1


try this

[infernal]

Thank you for your Help everyone. I have the server running!
I was not running World.exe properly for the server to be up.Thanks again!
:P
KeepHopeAlive aka Infernal