Titanium vs. RoF?

[NickW]

I am new here and found the play guide.

http://108.61.129.166/wiki/wikka.php?wakka=PlayGuide

If I use Titanium to install EQEmu do I only get the first 10 expansions worth of content?

If I use RoF do I get 19 expansions worth of content?

Or does it not matter which I use?

Edit: It also says in that guide that I should use SoD or later if I have a dual core. I have a Q6600 Quad core.. Is this a problem?

Edit 2: In step three of that guide it says I need to create a EQEmu login account. Do I still need to do this if I just want to host/play the game singleplayer?

Edit 3: I just found this guide on what looks to be the EQEmu wiki? Or a new version of the wiki?

http://wiki.eqemulator.org/p?Complete_Windows-based_Server_Setup_Guide&frm=Main

Should I be using this guide instead?

[Uleat]

Regardless of client, if you play on a peqdb-based server, you will only receive playable content up to Gates of Discord.

Custom servers may provide more..or some even restrict their expansion content. You should check a given server's website to see if there's a restriction
on the clients that they allow to connect to their server. Otherwise, any of the supported client should suffice.

The biggest discernment between clients, at the moment, is features.

[NickW]

Regardless of client, if you play on a peqdb-based server, you will only receive playable content up to Gates of Discord.

Custom servers may provide more..or some even restrict their expansion content. You should check a given server's website to see if there's a restriction
on the clients that they allow to connect to their server. Otherwise, any of the supported client should suffice.

The biggest discernment between clients, at the moment, is features.

Thanx for the response. Do you happen to know the answer to any of my other questions? Like which guide to use?

[moofta]

1. Currently the most stable and perhaps most widely available client is the Underfoot one (*coughs*). I would suggest using this if you can, it works better in every way than Titanium, and RoF is still not 100% supported.

2. If you want to run your own server on your PC and log into that rather than play on a public EQEmu server, you do not need an EQEmu login account. I would suggest getting one though, and trying a public server first anyway.

3. This is the new wiki and therefore most up to date for setting up your own server on Windows:-
http://wiki.eqemulator.org/p?Complete_Windows-based_Server_Setup_Guide&frm=Main

4. I really would suggest playing on a currently set up server first, partly to know what to expect, and secondly because most servers could do with more players :) Too many chiefs and not enough Indians!

[demonstar55]

The best supported clients are Titanium then probably Underfoot. Many people prefer UF due to the fact that it uses the newer HP formula and has more features (xtarget, etc) (note: if you find a 'HoT' client its actually just UF with the extra zone files from HoT)

The rest of the clients work well enough to be playable, but not as well as tit or if.

If you're setting up a single player only server and your own login server you don't need to make an account, although unless you do some port forwarding, no friends will be able to play with you (well you need to don't that anyways ...)

You should also try to use the new wiki since the old one has been in read only mode for a while and info can be out of date (although, the new wiki might not have been updated yet either .... Documenting is hard :PW well busy work)

[NickW]

Thanx again for the info. Helps a lot. Kinda confused as to what this step means.

c) Download Visual Studio Express 2013 for Windows Desktop

Download Visual Studio Express 2013 For Windows Desktop (note: there is a "Visual Studio Express 2013 For Windows Desktop" do not use it as it won't work) and put it in the C:\EQ\Installs directory. Download the installer by clicking on 'Install Now'. Note this one is only a simple web installer package. It will download more when you run it.
You can also use full versions of Visual Studio (Professional, Premium, Ultimate), and Visual Studio 2012 Express also.


First it says to download Visual Studio Express 2013 For Windows Desktop. Then it immediately says "note: there is a "Visual Studio Express 2013 For Windows Desktop" do not use it as it won't work"...

So what gives? Typo? :?

[moofta]

fixed the typo. You should use "Visual Studio Express 2013 for Windows Desktop". If you have the 2012 or even the 2010 version, they should work too.

[NickW]

fixed the typo. You should use "Visual Studio Express 2013 for Windows Desktop". If you have the 2012 or even the 2010 version, they should work too.

Gotcha. I tried downloading and installing that one. But, it apparently only works with windows 7 & 8. The only version for 2012 I see is "Visual Studio Express 2012 for Windows Phone". There are seven different options for 2010. I have no idea what any of them mean. Any idea which of these I should use for Windows Vista? :confused:

Thanx.

[demonstar55]

I know VS 2010 (the lowest supported VS version for us) is the last one that works for XP, not sure for Vista, 2012 might work? Either way, you will want the desktop version not the phone .. I assume ..

[NickW]

I know VS 2010 (the lowest supported VS version for us) is the last one that works for XP, not sure for Vista, 2012 might work? Either way, you will want the desktop version not the phone .. I assume ..

I've been looking. I can't seem to find a desktop version for either one. Just 2013. :x

[sorvani]

Didn't look very hard then.
First search result:
http://i.imgur.com/7hIV0o7.jpg

Hmm this shows 2013..
http://i.imgur.com/BcGwge6.jpg

but the search result said 2010.. Maybe I should read the page.. oh look right there at the bottom....
http://i.imgur.com/P4PjtB2.jpg


How about that.. Fucking put a little effort into it.
http://i.imgur.com/1iXnSfv.jpg

[NickW]

Didn't look very hard then.
First search result:
http://i.imgur.com/7hIV0o7.jpg

Hmm this shows 2013..
http://i.imgur.com/BcGwge6.jpg

but the search result said 2010.. Maybe I should read the page.. oh look right there at the bottom....
http://i.imgur.com/P4PjtB2.jpg


How about that.. Fucking put a little effort into it.
http://i.imgur.com/1iXnSfv.jpg

Not sure why you are so hostile.. And I already mentioned those seven options previously. In other words, I already flat out stated I had seen those seven. None of them are listed as the desktop version. Which is what was recommended. And what we were talking about. Feel free not to offer any more help. I could happily do without your advice. Seeing as you have a short temper and can't read the entire topic before posting..

[image]

Express is the only free version of Visual Studio and it is specifically designed for the desktop. Unless you have experience in C++ development you would be better off using pre-compiled binaries instead of trying to compile the source with its dependencies.

[NickW]

Express is the only free version of Visual Studio and it is specifically designed for the desktop. Unless you have experience in C++ development you would be better off using pre-compiled binaries instead of trying to compile the source with its dependencies.

The guide for setting up a server and moofta had said to use the, "Visual Studio Express 2013 For Windows Desktop" version. Because the, "Visual Studio Express 2013 For Windows" version wouldn't work. I have been looking for the 2012/2010 equivalent of that. If the regular Windows version of 2013 doesn't work. I would assume 2012/2010 might have the same problem? Unless I am missing something?

[lerxst2112]

You want the C++ version. The new names don't apply to old products.

[vsab]

Wiki updated.

[NickW]

I've followed the guide down to:

"c) Use CMake to build the required Visual Studio Solution and Project files

Launch your CMake program, typically labeled CMake (cmake-gui). Eg: Start -> CMake 2.8 -> CMake
To the right of the 'Where is the source code' box, click 'Browse Source' and expand the tree, C:\EQ\, click once on Source and then click OK, so the entry in the 'Where is the source code' box should read C:/EQ/Source/
To the right of the 'Where to build the binaries box', click 'Browse Build', expand the tree down to C:\EQ\Source. With 'Source' highlighted, click 'Make New Folder'. Name the new folder Build and click OK. The 'Where to build the binaries box' should now have C:/EQ/Source/Build in it.
Click on Configure.
In the next dialogue that says 'Specify the generator for this project', select 'Visual Studio 12'. Click on Finish.
Some messages should appear in the lower window with hopefully no errors.
Ensure you tick EQEMU_BUILD_LUA then click on Configure again.
(OPTIONAL) If you want to use 'Bots' on your server, click the box next to EQEMU_ENABLE_BOTS and then click Configure again.
(OPTIONAL) If you want to run your own local login server (useful if you want to work on your server disconnected from the internet- on a laptop, for example) then tick EQEMU_BUILD_LOGIN.
Click on Generate and CMake should say 'Generating done' in the output window. You can now close CMake."

However, when specifying the generator for the project. If I choose Visual Studio 12 it says, "Error in configuration process, project files may be invalid". Makes sense seeing as I couldn't install it. I did succesfully install Visual C++ 2010 Express. But, when I select Visual Studio 10 I get a Microsoft Windows popup that says:

"Microsoft Resource File To COFF Object Conversion Utility has stopped working.

A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is available."

And then the same error, "Error in configuration process, project files may be invalid".

I've followed the steps to the letter so far. Double checking everything. Any ideas?

Again, thanx for the help.

http://i61.tinypic.com/2wri26v.jpg

http://i62.tinypic.com/29m0u1v.jpg

http://i59.tinypic.com/i4qmpl.jpg

http://i62.tinypic.com/2wfjw44.jpg

Edit: I added in a bunch of screen caps.

[vsab]

Your screenshots look like Windows 7, or is it Vista?

Visual Studio Express 2013 for Windows Desktop will work on a fully up to date (via windows update, including all service packs) version of Windows 7.

If it's Vista, well good luck on that, nothing seemed to work on that P.O.S operating system!

Try- removing and reinstalling Visual Studio. I would recommend reboots in between each one, and disabling any anti-virus software you have during the install. If that fails, try installing the Windows SDK appropriate for your OS. The Windows 7 one is here:- http://msdn.microsoft.com/en-gb/windows/bb980924.aspx .

Otherwise, try Googling for "Microsoft Resource File To COFF Object Conversion Utility has stopped working".

Incidentally, text logs of compile errors are typically more handy than screen shots, where possible.

[NickW]

It took some digging. But, I found the solution. There is a service pack for Visual Studio 10. I installed it and presto! Back in business. Might want to add that to the wiki. Without it that error just keeps popping up in CMake.

Edit: Here's a link to the service pack. http://www.microsoft.com/en-us/download/details.aspx?id=23691

[NickW]

I ran into a snag here:

"c) Now it is time to create the database.

The following assumes you have used my tip to rename the files to something easier to type!
Launch a command prompt window and navigate to your C:\EQ\SQL folder by typing:

cd c:\EQ\SQL


Then enter mysql -uroot -ppassword where password is the password you chose when installing MySQL.
You should be presented with a mysql> prompt. If you do not, and it says it cannot find "mysql" please refer to (link) Adding MySql to your "Path"
Assuming you are now logged in, you can now create your database."

Back in step 3b using method 2. I was never asked to setup a password for MySQL when installing XAMPP. I messed around with it a bit and got past it using this site:

http://stackoverflow.com/questions/10299148/mysql-error-1045-28000-access-denied-for-user-billlocalhost-using-passw

Figured I would mention it. :D

[vsab]

What command did you actually type in then? I assumed that it wouldn't have a password set so you'd just need to log in using an empty password (since you never supplied one)

[NickW]

Ok so I am down to:

"Launching your server for the first time

OK, If you've done all that, been there and back again, and your 300% sure that you followed these steps exactly, crossed all t's and dotted all i's - Your done.
Before you click on that Start.bat file, a couple things to know. When you run start.bat, a new command window with the title C:\EQ\EQEmuServer\world.exe should appear.
After 10 seconds, three more command windows should appear with the following titles:

?
1
2
3

C:\EQ\EQEmuServer\eqlaunch.exe
C:\EQ\EQEmuServer\queryserv.exe
C:\EQ\EQEmuServer\ucs.exe
If one or all four of the windows does not appear then the corresponding program failed to launch for some reason. Launch a new command prompt window and navigate to C:\EQ\EQEmuServer
and run the command manually, e.g. type
world.exe
and press enter.


This will display any error messages that is causing the program to fail to start. You should look at the errors and go back over the guide to see if you can figure out what you did wrong. If all else fails, make a post on the EQEmu forums asking for assistance.
*NOTE* - Your server places it's log files in the logs folder. This is where you look for troubleshooting problems.
After you have run start.bat and you have the four windows displayed you can now log in the EQEmu public logon server, find your server in the list and login to it."

I'm getting this:

http://i58.tinypic.com/21qy6g.jpg

And when I execute each one individually I get this:

http://i57.tinypic.com/2iky4p2.jpg

I think I have to either create a user or give the user 'eq' a password? I've looked up how to do both. Neither seem to have worked. Any ideas?

[NickW]

What command did you actually type in then? I assumed that it wouldn't have a password set so you'd just need to log in using an empty password (since you never supplied one)

I went through most of the suggestions on that webpage I mentioned. I think what ended up working was "mysql -uroot".

[NickW]

Ok so I am down to:

"Launching your server for the first time

OK, If you've done all that, been there and back again, and your 300% sure that you followed these steps exactly, crossed all t's and dotted all i's - Your done.
Before you click on that Start.bat file, a couple things to know. When you run start.bat, a new command window with the title C:\EQ\EQEmuServer\world.exe should appear.
After 10 seconds, three more command windows should appear with the following titles:

?
1
2
3

C:\EQ\EQEmuServer\eqlaunch.exe
C:\EQ\EQEmuServer\queryserv.exe
C:\EQ\EQEmuServer\ucs.exe
If one or all four of the windows does not appear then the corresponding program failed to launch for some reason. Launch a new command prompt window and navigate to C:\EQ\EQEmuServer
and run the command manually, e.g. type
world.exe
and press enter.


This will display any error messages that is causing the program to fail to start. You should look at the errors and go back over the guide to see if you can figure out what you did wrong. If all else fails, make a post on the EQEmu forums asking for assistance.
*NOTE* - Your server places it's log files in the logs folder. This is where you look for troubleshooting problems.
After you have run start.bat and you have the four windows displayed you can now log in the EQEmu public logon server, find your server in the list and login to it."

I'm getting this:

http://i58.tinypic.com/21qy6g.jpg

And when I execute each one individually I get this:

http://i57.tinypic.com/2iky4p2.jpg

I think I have to either create a user or give the user 'eq' a password? I've looked up how to do both. Neither seem to have worked. Any ideas?

I found the solution here in this thread:

https://www.eqemulator.org/forums/showthread.php?t=38082

I had to log into mysql using "mysql -uroot". Then I had to set a password for the user "root" via "SET PASSWORD FOR 'root'@'localhost' = PASSWORD('myrootpw');". Where myrootpw = whatever you want your password to be.

Then I had to edit the "eqemu_config" file in my EqEmuServer folder. I had to change the user lines to "root", the password lines to my password i selected above AND the database (db) lines to peq.

Phew. I think that sorted it.

[NickW]

And a new problem arises. It seems never ending. :rolleyes:

I went through the "Windows Private Login Server Setup Guide". I finished all the steps. When I run start.bat I get four windows. But, the last one that is supposed to be, "C:\EQ\EQEmuServer\eqlaunch.exe" is shown as "0:sleeping".

First this pops up:

http://i61.tinypic.com/104kcw2.jpg

Then these four windows:

http://i58.tinypic.com/208bo9c.jpg

I've been waiting for something to happen.. Nada.

On my Everquest client I am getting:

"A connection to the server could not be reached. Please check your internet connection to make sure you are online."

Any ideas?

Edit: Does this look right for the host.txt file?

[LoginServer]
Host=127.0.0.1:5999

[cleramsey]

The eqlaunch.exe one should be sleeping that's normal. If it its not sleeping then there's a problem.

[NickW]

The eqlaunch.exe one should be sleeping that's normal. If it its not sleeping then there's a problem.

Ah, ok. Any idea why my EQ client keeps saying, "A connection to the server could not be reached. Please check your internet connection to make sure you are online"? :confused:

Edit: I should of mentioned I can connect to TGC and the other public servers just fine. I just can't connect to my personal server.

[Kingly_Krab]

[LoginServer]
Host=127.0.0.1:5999
That's what you have in your host file? If you're using the public loginserver and trying to connect using that, it won't work.

Try this:
[LoginServer]
Host=login.eqemulator.net:5999
Also, when the "0: sleeping" changes it means it's looking at a zone like this 7004: tutorial, 1 clients". It is not an issue for this to not be sleeping (unless no one is actually online).

Also, may I see your eqemu_config.xml, with the username and password to your database removed?

[vsab]

Try port 5998. If that doesn't work, what does the output window of loginserver.exe say? I mean, you are running it I presume?

[NickW]

Combining this post with the next one..

[NickW]

Try port 5998. If that doesn't work, what does the output window of loginserver.exe say? I mean, you are running it I presume?

That has to be it. So far I have been running Xampp > MySQL > start.bat > then the EQ client. I just tried running loginserver.exe. It pops up for half a second and then disappears.

http://i59.tinypic.com/2elbe6w.jpg

That's the best screenshot I can get. It closes very quickly. It says:

Logging System Init.
Config System Init.
Database Initialization Failure.
Config System Shutdown.
Log System Shutdown.

My start.bat

@echo off
shared_memory.exe
start loginserver.exe
start world.exe
echo Waiting for the world to finish loading before starting zones...
ping -n 10 127.0.0.1 > nul
start queryserv.exe
start ucs.exe
start eqlaunch.exe zone
exit

It is supposed to be starting the loginserver.exe. Apparently, the database initialization failure is stopping it..

Edit: I forgot to mention I tried port 5998 in the host.txt. No change.


[LoginServer]
Host=127.0.0.1:5999
That's what you have in your host file? If you're using the public loginserver and trying to connect using that, it won't work.

Try this:
[LoginServer]
Host=login.eqemulator.net:5999
Also, when the "0: sleeping" changes it means it's looking at a zone like this 7004: tutorial, 1 clients". It is not an issue for this to not be sleeping (unless no one is actually online).

Also, may I see your eqemu_config.xml, with the username and password to your database removed?

I am currently trying to log into my own personal server. I can log onto the public servers no problem with my original host.txt.

Here's my EqEmuConfig.xml:

<?xml version="1.0"?>
<server>
<world>
<shortname>setme</shortname>
<longname>I Forgot To Edit My Config</longname>

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

<!-- Loginserver information. Defaults shown -->
<loginserver>
<host>127.0.0.1</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="127.0.0.1" 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>7778</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>127.0.0.1</host>
<port>3306</port>
<username>root</username>
<password>XXXX</password>
<db>peq</db>
</database>

<qsdatabase>
<host>127.0.0.1</host>
<port>3306</port>
<username>root</username>
<password>XXXX</password>
<db>peq</db>
</qsdatabase>

<!-- 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>

I underlined the bits I changed while following the setup guide.

[vsab]

what's the contents of your login.ini? (again please remove your password, and also if you can use the "Code" tags that would be great)

[NickW]

what's the contents of your login.ini? (again please remove your password, and also if you can use the "Code" tags that would be great)

[database]
host = localhost
port = 3306
db = peq
user = root
password = <XXXX>
subsystem = MySQL</XXXX>

[options]
unregistered_allowed = TRUE
reject_duplicate_servers = FALSE
trace = TRUE
world_trace = FALSE
dump_packets_in = FALSE
dump_packets_out = FALSE
listen_port = 5998
local_network = 192.168.1.

[security]
plugin = EQEmuAuthCrypto
mode = 5

[Titanium]
port = 5998
opcodes = login_opcodes.conf

[SoD]
port = 5999
opcodes = login_opcodes_sod.conf

[schema]
account_table = tblLoginServerAccounts
world_registration_table = tblWorldServerRegistration
world_admin_registration_table = tblServerAdminRegistration
world_server_type_table = tblServerListType

Thanx for all the help. I get the feeling I am on the last leg and one little thing is tripping me up.. :rolleyes:

Edit: This guy seems to have had the same problem. Or something similar.

http://www.eqemulator.org/forums/showthread.php?t=31529

I'm not sure if/how he fixed it. He says he made some progress changing one of the ip addresses? But, he doesn't say which one.. He also talks about an peqlogindb. I created a db for the login server while following the guide. But, I cannot find that file anywhere?

[vsab]

Heh well sometime people try to change lots of things, one of them fixes it but they have no idea which of the 10 things they tried did it.

Try changing "localhost" to "127.0.0.1". Was there an error log generated by the login server?

[Uleat]

I've been suggesting the 'localhost' change for a bit myself. I 'think' that localhost will work fine in the eqemu_config.xml file..but, it needs to be the actual ip in login.ini.

The sql that you sourced in for the login server should have added four (4) tables with the prefix of 'tbl.'

If you don't have those four, you will need to re-source the 'load_login.sql' script file.

[NickW]

Heh well sometime people try to change lots of things, one of them fixes it but they have no idea which of the 10 things they tried did it.

Try changing "localhost" to "127.0.0.1". Was there an error log generated by the login server?

27 error logs for the login server total. They all say the same thing.

[Debug] [04.29.14 - 05:14:23] Logging System Init.
[Debug] [04.29.14 - 05:14:23] Config System Init.
[Error] [04.29.14 - 05:14:23] Database Initialization Failure.
[Debug] [04.29.14 - 05:14:23] Config System Shutdown.
[Debug] [04.29.14 - 05:14:23] Log System Shutdown.


Changing localhost to 127.0.0.1 still gives the same error. Database Initialization Failure.

[NickW]

I've been suggesting the 'localhost' change for a bit myself. I 'think' that localhost will work fine in the eqemu_config.xml file..but, it needs to be the actual ip in login.ini.

The sql that you sourced in for the login server should have added four (4) tables with the prefix of 'tbl.'

If you don't have those four, you will need to re-source the 'load_login.sql' script file.

These?

account_table = tblLoginServerAccounts
world_registration_table = tblWorldServerRegistration
world_admin_registration_table = tblServerAdminRegistration
world_server_type_table = tblServerListType

[vsab]

Yep, those.

[NickW]

Yep, those.

I went through the entire process again for the private login server setup. I think step 4 was the resourcing of load_login.sql. Still getting the same error..

I went back to the default login.ini.

[database]
host = localhost
port = 3306
db = eqemu
user = user
password = password
subsystem = MySQL

[options]
unregistered_allowed = TRUE
reject_duplicate_servers = FALSE
trace = TRUE
world_trace = FALSE
dump_packets_in = FALSE
dump_packets_out = FALSE
listen_port = 5998
local_network = 192.168.1.

[security]
plugin = EQEmuAuthCrypto
mode = 5

[Titanium]
port = 5998
opcodes = login_opcodes.conf

[SoD]
port = 5999
opcodes = login_opcodes_sod.conf

[schema]
account_table = tblLoginServerAccounts
world_registration_table = tblWorldServerRegistration
world_admin_registration_table = tblServerAdminRegistration
world_server_type_table = tblServerListType

I am attempting to understand everything in this file.

host= The guide used 127.0.0.1 in the creation of the login account and start.bat. I've tried leaving it as localhost and I've tried 127.0.0.1.

port= I've had my antivirus and firewall completely off since the start. I don't think the port could be blocked in any way. And the guide says I do not need to mess with port forwarding in my router if the server is just for me.

db= the guide says to change this to peq which is what I did. I've also tried peqbeta which appears to be what the file is actually called. No luck there.

user= I am assuming this is my user account I use to log into MySQL? Which would indeed be "root".

password= I am assuming this is my password I use to log into MySQL along with "uroot".

subsystem= The guide says this one is also a password. Is it the same password as above? My password I use to log into MySQL?

local_network= Why is this one set to 192.168.1.? Why does it have that extra period at the end? Is it important?

I think the problem might lie in here somewhere. Possibly. Any ideas?

[NickW]

Yep, those.

I went through the entire process again for the private login server setup. I think step 4 was the resourcing of load_login.sql. Still getting the same error..

I went back to the default login.ini.

[database]
host = localhost
port = 3306
db = eqemu
user = user
password = password
subsystem = MySQL

[options]
unregistered_allowed = TRUE
reject_duplicate_servers = FALSE
trace = TRUE
world_trace = FALSE
dump_packets_in = FALSE
dump_packets_out = FALSE
listen_port = 5998
local_network = 192.168.1.

[security]
plugin = EQEmuAuthCrypto
mode = 5

[Titanium]
port = 5998
opcodes = login_opcodes.conf

[SoD]
port = 5999
opcodes = login_opcodes_sod.conf

[schema]
account_table = tblLoginServerAccounts
world_registration_table = tblWorldServerRegistration
world_admin_registration_table = tblServerAdminRegistration
world_server_type_table = tblServerListType

I am attempting to understand everything in this file.

host= The guide used 127.0.0.1 in the creation of the login account and start.bat. I've tried leaving it as localhost and I've tried 127.0.0.1.

port= I've have my antivirus and firewall completely off since the start. I don't think the port could be blocked in any way.

db= the guide says to change this to peq which is what I did. I've also tried peqbeta which appears to be what the file is actually called. No luck there.

user= I am assuming this is my user account I use to log into MySQL? Which would indeed be "root".

password= I am assuming this is my password I use to log into MySQL along with "uroot".

subsystem= the guide says this one is also a password. Is it the same password as above? My password I use to log into MySQL?

local_network= Why is this one set to 192.168.1.? Why does it have that extra period at the end? Is it important?

I think the problem might lie in here somewhere. Possibly.

[vsab]

Subsystem should just be MySQL - the wiki editor threw a wobbly so I've fixed that.

Incidentally, peq is the database name "peqbeta.sql" is just a filename (remember you actually renamed it earlier). You could change the name of that file to anything you like really.

The other thing is that -uroot should be read as "username" = "root" - the -u means that the username will come afterwards.

192.168.1. refers to your network, I dunno why it uses that format, exactly. Most home networks are on 192.168.1.* but you can check by opening a command prompt and typing "ipconfig"

I'm just removing my MySQL installation completely and redoing the steps to see if I missed anything, so we'll see how that goes.

[Uleat]

Your db's don't match (didn't Noport just post this on another thread yesterday?)

<database>
<host>127.0.0.1</host>
<port>3306</port>
<username>root</username>
<password>XXXX</password>
<db>peq</db>
</database>

[database]
host = localhost
port = 3306
db = eqemu
user = user
password = password
subsystem = MySQL

[vsab]

OK I completely removed XAMPP and installed the peq database+ lod_login.sql from scratch and I can get loginserve.exer to start up with this login.ini (and yes, I did make my password "password" :P ):-


[database]
host = localhost
port = 3306
db = peq
user = root
password = password
subsystem = MySQL

[options]
unregistered_allowed = TRUE
reject_duplicate_servers = FALSE
trace = TRUE
world_trace = FALSE
dump_packets_in = FALSE
dump_packets_out = FALSE
listen_port = 5998
local_network = 192.168.1.

[security]
plugin = EQEmuAuthCrypto
mode = 5

[Titanium]
port = 5998
opcodes = login_opcodes.conf

[SoD]
port = 5999
opcodes = login_opcodes_sod.conf

[schema]
account_table = tblLoginServerAccounts
world_registration_table = tblWorldServerRegistration
world_admin_registration_table = tblServerAdminRegistration
world_server_type_table = tblServerListType

[NickW]

OK I completely removed XAMPP and installed the peq database+ lod_login.sql from scratch and I can get loginserve.exer to start up with this login.ini (and yes, I did make my password "password" :P ):-


[database]
host = localhost
port = 3306
db = peq
user = root
password = password
subsystem = MySQL

[options]
unregistered_allowed = TRUE
reject_duplicate_servers = FALSE
trace = TRUE
world_trace = FALSE
dump_packets_in = FALSE
dump_packets_out = FALSE
listen_port = 5998
local_network = 192.168.1.

[security]
plugin = EQEmuAuthCrypto
mode = 5

[Titanium]
port = 5998
opcodes = login_opcodes.conf

[SoD]
port = 5999
opcodes = login_opcodes_sod.conf

[schema]
account_table = tblLoginServerAccounts
world_registration_table = tblWorldServerRegistration
world_admin_registration_table = tblServerAdminRegistration
world_server_type_table = tblServerListType

HALLELUJA! I FEEL LIKE SCREAMING THAT DAMN SONG! :D:D:D:D:D:D

Last thing I did before I went to sleep was try it one more time and nada. Same error. I wake up and you post the above login.ini. I replace both of the login.ini with what you just posted. The only thing I changed was my password. AND WALA! IT IS WORKING. VSAB I LOVE YOU. <3

I love everyone else as well for all the help. Except for that Sorvani guy. He was an ass. But, vsab has a special place in my heart from now on. If you ever want to make man babies hit me up.. Cause I would do that for you..

After 5 days of messing with this it is actually working!!!

[vsab]

rofl. Getting a thanks is enough, I have enough gnomes running around as it is ;)

Enjoy!