COMPLETE PUBLIC SERVER SETUP - Jan-2011 - Page 22

lerxst2112 · #**316** 04-23-2012, 09:53 PM

You would be much better off using Perl 5.12 with Visual Studio 2008. The download is available in the same place as 5.14. 5.14 requires more changes to compile, and even if you make those changes it'll crash.

jshows1 · #**317** 04-23-2012, 11:48 PM

Quote:

Originally Posted by lerxst2112

You would be much better off using Perl 5.12 with Visual Studio 2008. The download is available in the same place as 5.14. 5.14 requires more changes to compile, and even if you make those changes it'll crash.

Got it! Once I downloaded and reinstalled down to Perl 5.12 as well as changing the appropriate lines in the files above, it compiled fine. Thanks so much for the help.

Now I'm to step 14 but Navicat Lite seems to have mysteriously vanished from the internet. Unless the "lite" version is just the full blown version with a 30 day trial. Oh well, I just downloaded that since every link I look for on Navicat Lite seems to be non existent anymore. Will post if i have anymore issues.

Sinclipse · #**318** 05-02-2012, 10:15 PM

Hey guys, so the server is up and running completely, (I had made a server not to long ago, shut it down, uninstalled a few of the programs and reinstalled them) and now, I can get to the Char screen, make a char, but when I go to get in, it DC's me back to the Log in page.... Any help on this?

**joligario** · #**319** 05-02-2012, 10:52 PM

Make sure you've applied all the SQL updates necessary.

Sinclipse · #**320** 05-03-2012, 12:00 AM

Hmm, I just remember I didn't do that step, because I thought it was only for the REV he has posted at the moment... Heh, I should do that before I post next time, I'm a little bit of a idiot some times... Thanks! I'll post back if it works.

Sinclipse · #**321** 05-03-2012, 12:05 AM

Hmm, I got nothing now, I can't figure it out, I went to update it, and got multiple errors. Now, remind you, I uninstalled MySQL and ActivePerl and Zlib deleting all their files, I've gone through the steps, one by one, re-doing everything, the only things that could have possibly messed up were the Maps and Quests... The .keep file has a ? on it, instead of just a NORMAL .keep

Sinclipse · #**322** 05-03-2012, 12:08 AM

---------------------------------------------
[05.02. - 21:07:38] Starting Log: logs/eqemu_error_zone_2936.log
[05.02. - 21:07:38] Path File ./Maps/gfaydark.path not found.

Hmmmmmmmm

Sinclipse · #**323** 05-03-2012, 01:17 AM

After bashing my face on the keyboard over and over and over and over and over agani, I figured it out... Freaking zone points wasn't loaded corrected VIA MYsql.... It's fixed, sorry for the spam posts guys...

Meleek · #**324** 05-08-2012, 01:58 PM

Ok I cant get my start.bat to work it says world.exe can not be found there in the same directory and i did the cmd promt to make sure it was the right path and it still wont find it.... any help would be greatly appriacted... thanks in advanced

Calabeth · #**325** 05-08-2012, 03:31 PM

My personally I have always done the start.bat in the same folder as world.exe etc.. But then made a shortcut to that to place on my desktop.

Of course there is the easier way of having it start up when you start the server pc as a service also I believe I had read somewhere which I should look into lol.

Meleek · #**326** 05-09-2012, 10:52 AM

Still having problems with the bat file =/

Curzon7 · #**327** 06-10-2012, 07:39 PM

I combed through every post in here, and you guys are awesome. My resolve to figure it on my own has hit the wall, here 27 hours after I started this process.

I have a successful compile ( I guess). I initially had the wrong Perl installed (doh) and the wrong mysql (doh^2), so I didn't go in order, exactly. I uninstalled everything, deleted everything, and decided to just go through exactly as stated in the guide. Originally I wanted a private server, but whatever, I'll figure that out later.

When I run the batch file in the server directory, it .. .. .. and then craps out. The error is the same one that one guy was having (page 5 and 7 as my browser sorts it):

---------------------------------------------
[06.10. - 18:28:24] Starting Log: logs/eqemu_debug_3208.log
[06.10. - 18:28:24] [LAUNCHER__INIT] Loading server configuration..
[06.10. - 18:28:25] [NET__WORLD] WorldConnection connect: Connecting to the server localhost:9000 failed: TCPConnection::Connect(): connect() failed. Error: 10061
[06.10. - 18:28:25] [LAUNCHER__ERROR] worldserver.Connect() FAILED! Will retry.
[06.10. - 18:28:25] [LAUNCHER__INIT] Starting main loop...
******
Going into the logs I find the following logs with the same timestamp:
************

Starting Log: logs/eqemu_error_world_6136.log
[06.10. - 18:28:15] Failed to connect to database: Error: #1045: Access denied for user 'root'@'localhost' (using password: YES)

*************

---------------------------------------------
[06.10. - 18:28:15] Starting Log: logs/eqemu_debug_world_6136.log
[06.10. - 18:28:15] [WORLD__INIT] Loading server configuration..
[06.10. - 18:28:15] [WORLD__INIT] Log settings loaded from log.ini
[06.10. - 18:28:15] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEmulator 0.8.0
[06.10. - 18:28:15] [WORLD__INIT] Added loginserver eqemulator.net:5998
[06.10. - 18:28:15] [WORLD__INIT] Connecting to MySQL...
[06.10. - 18:28:15] [WORLD__INIT_ERR] Cannot continue without a database connection.

***************

I checked my .xml config file and the password and database name are perfect. I manually logged into my database to make sure I had the right password. I'm thinking it has to do with the router forwarding maybe? I tried messing around with that, added the 7000-7100, but I can't seem to add another service to cover the other ranges. I'm in windows xp so the firewall exceptions thing doesn't work exactly the same either, I did find a place to open up a port, so I tried that too, but no effect.

What else do ya'all need to miracle my server into connectivity?

GLGanjika · #**328** 06-18-2012, 08:24 AM

This is a working and wonderful server-set up guide and I want to thank whoever went through the trouble of making it.

I have a question though: I'm still pretty new to this whole thing and just wanted to know ; relative to this guide how would I re-source stuff if need be without ruining my server? I would feel most comfortable if some one more familiar could show me which steps in this guide i would have to follow (or should i say refollow) to re-source stuff without causing damage.

Curzon7 · #**329** 06-29-2012, 11:33 PM

Not intending to bump, but it's been a couple weeks, is there someplace else I should ask for help?

**Uleat** · #**330** 06-30-2012, 12:17 AM

C7,

If you can't get the server to connect to the database and they are both on the same computer, then port-forwarding isn't your issue.

Post the contents of your eqemu_config.xml file using a code wrap. (Use the 'Go Advanced' button next to quick reply, then, after pasting
the file, highlight it and click the '#' button above the text box to wrap it.)

There's only so many things it could be if you can manually log into the database but the server can't.

I've seen a couple of different ServerStart.bat files..try this one if you haven't:

<ServerStart.bat>

Code:

@echo off
Echo Starting EQEmuLoginServer

cd C:\eqemu
start eqemuloginserver.exe
echo
echo

cd C:\eqemu
start world.exe
echo waiting a bit for world to finish loading...
echo.
echo.
ping -n 10 127.0.0.1 > nul

echo starting zone
start eqlaunch.exe zone
exit

Also, make sure that this file is in your ..\eqemu\ working directory and just create a shortcut to it like Calabeth said previously.

(Edit: Post the version of MySQL and link the guide that you are using too..there seems to be a lot of "Can't Connect to Database" issues lately.)

U