PDA

View Full Version : Newbie question for you pros

Lladail
09-29-2009, 09:59 PM
So I'm trying to set up my own public sever, and I did everything on Vales wikki guide thing

http://www.eqemulator.net/wiki/wikka.php?wakka=ValesEQ

but my problem is loading into the game ( i think thats where its messing up ) I click on my start.bat file and it opens the 2 screens one disappers and other says

"Wait for World to finish loading... Press Enter when done.
Press any key to continue . . ."

I click enter and it says

[Debug] Starting Log: logs/eqemu_debug_3308.log
[Debug] [LAUNCHER__INIT] Loading server configuration..
[Debug] [NET__WORLD] WorldConnection connect: Connecting to the server 127.0.0.1
:9000 failed: TCPConnection::Connect(): connect() failed. Error: 10061
[Debug] [LAUNCHER__ERROR] worldserver.Connect() FAILED! Will retry.
[Debug] [LAUNCHER__INIT] Starting main loop...

It's bugging me so bad I've searched the forums, but couldnt find anything ( i didnt look through every post but did quite a few... any help would be awesome! thanks guys

Ladail.
ChaosSlayerZ
09-29-2009, 10:55 PM
I had the problem when one of your screen instantly closes itself - it was related to my version of Perl been too old.
The devs often upgrade the compile versions and not everytime inform us about it =P
Lladail
09-29-2009, 11:06 PM
I was having that problem and deleted every type of emu file i had, then redownloaded everything and got to where i am now =\ lol
ChaosSlayerZ
09-29-2009, 11:16 PM
try getting just the latest Perl version the compiled on.

this thread may help

http://www.eqemulator.net/forums/showthread.php?t=26643&page=2
Lladail
09-29-2009, 11:18 PM
atm i have perl ActivePerl-5.8.9.826-MSWin32-x86-290470.msi ( the latest version ) but do you think it could be perl is the reason I'm getting the error logging into world ?
ChaosSlayerZ
09-29-2009, 11:20 PM
as I said- the window shutting down by itself - that was exactly the problem I had cause I had older version of Perl that devs used.

Of course your problem may be unrelated...
Lladail
09-29-2009, 11:24 PM
aye, its not shutting down by it self tho, it was but i got past that part, now the window just says

[Debug] Starting Log: logs/eqemu_debug_3308.log
[Debug] [LAUNCHER__INIT] Loading server configuration..
[Debug] [NET__WORLD] WorldConnection connect: Connecting to the server 127.0.0.1
:9000 failed: TCPConnection::Connect(): connect() failed. Error: 10061
[Debug] [LAUNCHER__ERROR] worldserver.Connect() FAILED! Will retry.
[Debug] [LAUNCHER__INIT] Starting main loop...

after i click enter
Tharkun
09-30-2009, 12:03 AM
actually there are 2 applications that you need running.

The one your getting the error from is EQLAUNCH.EXE, your getting that error because it cant find WORD.EXE in memory.

World.exe is the window that is closing it self.

Check your log folder to see if there are any world logs too see what the log says. World is crashing for some reason.
Lladail
09-30-2009, 12:21 AM
---------------------------------------------
[09.29. - 21:31:20] Starting Log: logs/eqemu_error_world_3960.log
[09.29. - 21:31:20] Failed to connect to database: Error: #1045: Access denied for user 'root'@'localhost' (using password: YES)

thats what is in the log, thats the last one i can see.
Tharkun
09-30-2009, 12:25 AM
world.exe cant open your database.

check your eqemu_config.xml to make sure the correct login/pw are specified here

<!-- Database configuration, replaces db.ini. Defaults shown -->
<database>
<host>localhost</host>
<port>3306</port>
<username>MySQL Account</username>
<password>MySQL Password</password>
<db>peq</db>
</database>

then you should be good
Lladail
09-30-2009, 12:30 AM
<!-- Database configuration, replaces db.ini. Defaults shown -->
<database>
<host>localhost</host>
<port>3306</port>
<username>root</username>
<password>******</password>
<db>peq</db>
</database>

is what I have atm ( the * are letters but not giving that out =p )

do i do anything with the <host> ?
Tharkun
09-30-2009, 12:33 AM
as long as the DBserver and World are on the same computer localhost is fine.

bear in mind the <pw> is case sensitive, so how ever you created the login for MYSQL is how that needs to be also.

just for giggles, bring up a command prompt and run

mysql -u root -p

then enter the same p/w you have in the config to see if you can login
Lladail
09-30-2009, 12:36 AM
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Joe>mysql -u root -p
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 27
Server version: 5.0.84-community-nt MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

is what i got
Tharkun
09-30-2009, 12:40 AM
is world still crashing?
Lladail
09-30-2009, 12:45 PM
well i tried restalling perl and i get perl version 5.10.0 build 1004... installed it and now I'm getting

"The procedure entry point Perl_hv_common_key_len could not be located in the dynamic link library perl58.dll"

I have the perl58.dll file in my system32 file but cant find anything about this problem =\

Thanks in advance lol...
Tharkun
09-30-2009, 01:00 PM
the build you have of the server requires Perl5.8. Remove Perl5.10 and Re-install 5.8

The only way I have gotten Perl 5.10 to work is to compile my own binaries
Lladail
09-30-2009, 06:08 PM
I unstilled all of perl 5.10 and installed perl 5.8.9 build 826 and still getting the same error =\
Sylaei
10-01-2009, 12:39 AM
You are way past this but, for future knowledge or for searchers, when you get a dos window that just closes, you are getting an error in that window. In order for it not to close you need to open a cmd prompt and manually run each command until you find the one with the error.

That said it seems like you now have two problems, the first was the connection issue which had nothing to do with perl. The second is that you now have a perl issue. Make sure that the perl/bin folder is in the path statement. Your path statement may have gotten messed up with the uninstall/install of perl.

I also found this entry by cavedude http://www.eqemulator.net/forums/showpost.php?p=159114&postcount=1
Basically it says to run version 5.8.8 build 822 and reboot after installing it. I have had this (perl) issue before and I am not sure what I did to fix it, but I am running perl 5.8.8 build 822. Please read the entire post above as there are some links to files that might help.

Once the perl issue is fixed open a cmd prompt and change to your eq server folder and run world.exe wait for it to finish, then open another and run eqlaunch.exe zoneThis should give you an error you can see and we can proceed from there.

HTH
DDude11
10-06-2009, 04:20 PM
it looks like he has the same prob as me so i openeed command prompt like you said and switched to my server folder and ran world.exe and got this
---------------------------------------------
[10.06. - 13:17:29] Starting Log: logs/eqemu_error_world_5780.log
[10.06. - 13:17:29] Failed to connect to database: Error: #1045: Access denied for user 'eq'@'localhost' (using password: YES)
pfyon
10-06-2009, 06:48 PM
it looks like he has the same prob as me so i openeed command prompt like you said and switched to my server folder and ran world.exe and got this
---------------------------------------------
[10.06. - 13:17:29] Starting Log: logs/eqemu_error_world_5780.log
[10.06. - 13:17:29] Failed to connect to database: Error: #1045: Access denied for user 'eq'@'localhost' (using password: YES)

That means the credentials you used for the database are not correct.
Sylaei
10-06-2009, 09:29 PM
Make sure you can log into your mysql database with the command from a dos prompt:

mysql -u eq -p
After you hit enter it will ask for a password. If this works make sure your eqemu_config.xml file has the same user 'eq' and password you used here. Also make sure your database name is set correctly.


Your eqemu_config.xml file should look like this, with the appropriate changes of course.

<database>
<host>localhost</host>
<port>3306</port>
<username>eq</username>
<password>newpwd</password>
<db>peq</db>
</database>
pfyon is correct your credentials are messed up.
DDude11
10-07-2009, 12:55 AM
its letting me login fine to mysql when i start command prompt then type mysql -u root -p then it asks for my PW and i enter it and it says welcome to mysql yada yada yada. what i found interesting is you are saying to type mysql -u eq -p and i am typeing mysql -u root -p and it is allowing me access. did i do something wrong?
Sylaei
10-07-2009, 01:15 AM
it looks like he has the same prob as me so i openeed command prompt like you said and switched to my server folder and ran world.exe and got this
---------------------------------------------
[10.06. - 13:17:29] Starting Log: logs/eqemu_error_world_5780.log
[10.06. - 13:17:29] Failed to connect to database: Error: #1045: Access denied for user 'eq'@'localhost' (using password: YES)


I chose to use 'eq' because that is the account that you are trying to login into the mysql server with based on the error message. The line that says 'Access denied for user 'eq'@'localhost'. This means that your eqemu_config.xml file has eq as the user to log into the mysql database. Change the user to root and it should connect. Make sure the password is correct also.

It doesn't matter what the username is as long as it is setup in the database and the eqemu_config.xml file.


<database>
<host>localhost</host>
<port>3306</port>
Change this line here -> <username>eq</username>
<password>newpwd</password>
<db>peq</db>
</database>
DDude11
10-07-2009, 01:43 AM
well see thats whats strange about this. when the error message comes after trying world.exe it says in it access denied for user 'eq'@'localhost' but here is my entire eqemu_config.xml and you can see that my username is set as root not eq. (password is starred out but ive triple checked that its correct by logging into mysql with it.) o and scrutinize my config file as much as possible to see if i screwed up anywhere else.

<?xml version="1.0">
<server>
<world>
<shortname>LEGITEST NON LEGIT</shortname>
<longname>DT'S LEGITEST NON LEGIT SERVER</longname>

<!-- Only specify these two if you really think you need to. -->
<!--<address>192.168.1.100</address>-->
<!--<localaddress>127.0.0.1</localaddress>-->

<!-- Loginserver information. -->
<loginserver>
<host>eqemulator.net</host>
<port>5998</port>
<account></account>
<password></password>
</loginserver>

<!-- Sets the shared key used by zone/launcher to connect to world -->
<key>some long random string</key>

<!-- Enable and set the port for the HTTP service. -->
<http port="9080" enabled="true" mimefile="mime.types" />
</world>

<!-- Database configuration, replaces db.ini. -->
<database>
<host>localhost</host>
<port>3306</port>
<username>root</username>
<password>*****</password>
<db>peq</db>
</database>
</server>
Theeper
10-07-2009, 07:43 PM
Are you sure you have the config file in the correct place?

'eq' is the username used in the default config file.
DDude11
10-08-2009, 04:24 PM
where should my eqemu_config.xml file be? in the same folder that has the folders for quests maps the start.bat i created etc right??
Sylaei
10-08-2009, 08:06 PM
Thats where it should be in the same folder with start.bat, world.exe, zone.exe and the others.


Can you post your entire eqemu_config.xml file? Don't know that that'll help but......
DDude11
10-08-2009, 08:50 PM
yea i posted my entire config file 2 or 3 posts up but i did a search of my drive and found another eqemu_config.xml but for some reason it was in my /installanywhere/documents folder insted of my eqemu server folder so i moved it in and moved the old one out just to try and here it is. (again starred out pw is my actual pw which ive verifyed in mysql.)

<?xml version="1.0">
<server>
<world>
<shortname>DTs</shortname>
<longname>DT's legitest nonlegit</longname>

<!-- Only specify these two if you really think you need to. (read: You don't) -->
<!-- <address>192.168.1.100</address> -->
<!-- <localaddress>127.0.0.1</localaddress> -->

<!-- Loginserver information. Defaults shown -->
<loginserver>
<host>eqemulator.net</host>
<port>5998</port>
<account></account>
<password></password>
</loginserver>

<!-- Server status. Default is unlocked -->
<!--<locked/>-->
<!-- <unlocked/> -->

<!-- Sets the ip/port for the tcp connections. Both zones and console (if enabled). Defaults are shown -->
<tcp ip="localhost" port="9000" telnet="disable"/>

<!-- Sets the shared key used by zone/launcher to connect to world -->
<key>some long random string</key>

<!-- Enable and set the port for the HTTP service. Defaults are shown -->
<http port="9080" enabled="false" mimefile="mime.types" />
</world>

<!-- Chatserver (channels) information. Defaults shown -->
<chatserver>
<host>channels.eqemulator.net</host>
<port>7778</port>
</chatserver>

<!-- Mailserver (in-game mail) information. Defaults shown -->
<mailserver>
<host>channels.eqemulator.net</host>
<port>7779</port>
</mailserver>

<zones>
<defaultstatus>20</defaultstatus>

<!-- Sets port range for world to use to auto configure zones -->
<ports low="7000" high="7100"/>
</zones>

<!-- Database configuration, replaces db.ini. Defaults shown -->
<database>
<host>localhost</host>
<port>3306</port>
<username>root</username>
<password>****</password>
<db>peq</db>
</database>

<!-- Launcher Configuration -->
<launcher>
<!-- <logprefix>logs/zone-</logprefix> -->
<!-- <logsuffix>.log</logsuffix> -->
<!-- <exe>zone.exe or ./zone</exe> -->
<!-- <timers restart="10000" reterminate="10000"> -->
</launcher>

<!-- File locations. Defaults shown -->
<files>
<!-- <spells>spells_us.txt</spells> -->
<!-- <opcodes>opcodes.conf</opcodes> -->
<!-- <logsettings>log.ini</logsettings> -->
<!-- <eqtime>eqtime.cfg</eqtime> -->
</files>
<!-- Directory locations. Defaults shown -->
<directories>
<!-- <maps>Maps</maps> -->
<!-- <quests>quests</quests> -->
<!-- <plugins>plugins</plugins> -->
</directories>
</server>
Sylaei
10-10-2009, 12:47 AM
Sorry DDude11, I didn't realize the post above was there. Shoulda looked. :-) I don't see anything in the latest eqemu_config.xml that is wrong. I have these lines uncommented in mine but I don't think this has anything to do with your issue.

<!-- Only specify these two if you really think you need to. (read: You don't) -->
<!-- <address>192.168.1.100</address> -->
<!-- <localaddress>127.0.0.1</localaddress> -->
You said that you found another copy of the eqemu_config.xml file on your drive, is it possible that you have multiple world.exe files and for some reason one is located in your path and windows is trying that one?

I am at at a loss, can we see some more of the log file around the error?
DDude11
10-10-2009, 02:02 AM
i truely appriciate all your help it was the weirdest thing i figured it out today and now everything works great and im the proud owner of a server haha all i had to do was take out the password in my eqemu_config file and try and run the start.bat and when i did that it would not let me connect but at least it recognized me as root and not eq so then i went back to the config file and put my password back in and it worked great lol. just a weird problem of trial and error i suppose lol but hey if you are well versed in running a server and the things you can do as a gm take a look at my latest sad thread haha
http://www.eqemulator.net/forums/showthread.php?t=29756
thanks again :)
Sylaei
10-10-2009, 12:56 PM
Not a problem, glad it is working.
Arrudar
11-14-2009, 03:55 PM
I am having the same issue and have done the same things that DDude has done, however, it still hasnt fixed my issue. It is trying to connect to eq@localhost as opposed to the root@localhost it is set up to be.
Arrudar
11-14-2009, 08:13 PM
OK, i fixed it. what is was is it was saved as a file with an extension called "FULL". Simply took out the extension and made sure it was just a .xml file.