EQEmulator Forums - CMAKE Error

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - CMAKE Error (https://www.eqemulator.org/forums/showthread.php?t=38059)

For the Database install, I of course installed MySQL. Then per the guide:

Code:

    Currently you must download the latest database from the following location (you will get redirected to a Google Drive folder):



?

1

        

http://peqtgc.com/releases



    The filename will be something like:-



?

1

        

peqbeta_{Date_and_Time}.tar.gz



    where {Date_and_Time} is actually the time it was generated e.g  2014-04-01-02:01



    Next, go to the folder C:\EQ\SQL and unzip the file.

    If double-clicking on peqbeta_{Date_and_Time}.tar.gz  does not launch 7-zip or your preferred unzipper, you may need to launch 7-manually (possibly using 'Run as Administrator' and go into the settings/options and tell it to associate it with .gz files).

    Once you have the file opened with 7-zip, select extract and extract it to C:\EQ\SQL. It may just unzip to a file called peqbeta_{Date_and_Time}.tar. You  then have to unzip *that* file, and inside are the files you really want.

    There will be approx 11 files, one of which will be Readme.txt. I would advise reading that text! It will be updated whenever the database is (unlike this guide), and may have information that override what you read here. Copied from the current Readme

Then I did the following steps:

Code:

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.



Type: 

create database peq; 

and press enter.

 



    The following ensures any commands you use next will apply to this new database:-



Type: 

use peq; 

and press enter.

 



    Note: Now that the database is created anytime you need to login to MySQL in the future, you can do it with a single line command:



 

mysql -uroot -pyourpassword peq

 

Type: 

source peqbeta.sql;

and press enter.

 

This may take a while to complete, depending on how powerful your PC is.

 

When the mysql> prompt returns:

 

Type: 

source player_tables.sql;

and press enter.

 

 

Finally, type 

exit

and press enter to return to the command prompt.

That was the process I used

Were there any errors with that process? Have you looked at the database in something like HeidiSQL to see if it is actually there and there are tables in it?

If you don't have any other utility you can try 'mysql -uroot -ppassword' and then at the prompt type 'show tables in peq' and see what it lists.

No errors. Here is a screen shot, 174 tables...

http://prntscr.com/3be35s

In fact, I deleted the entire database, and reinstalled the latest git clone, which was dated 4/18/14. I have NOT applied anything from the SVN or Git folder....do I need to with such a new database?

Dunno, the error you most recently posted says that two of the tables in your screenshot don't exist and that there's no shared memory items file to load. Not applying required updates would be a different set of errors, but if you're using the daily dump I don't think you need any.

Okay, I am really close now. I am only getting the following error:

Code:

[04.22. - 09:03:30] Starting Log: logs/eqemu_error_queryserv_0552.log

[04.22. - 09:03:30] Failed to connect to database: Error: #2003: Can't connect to MySQL server on 'localhost' (0)

I find this interesting because every other application is able to connect to the database.

Below is my Config File:

Code:

<?xml version="1.0"?>

<server>

        <world>

                <shortname>DEQ</shortname>

                <longname>Deja EQ</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>login.eqemulator.net</host>

                        <port>5998</port>

                        <account>DejaEQ</account>

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

The reason my Shared_memory was not starting is the .bat file never started that file due to a typo:

Code:

@echo off

shared_memory.exe

start world.exe

echo waiting for the world to finish before starting zone...

ping -n 10 127.0.0.1 > nul

start queryserv.exe

start ucs.exe

start eqlaunch.exe zone

exit

Simply placing start in front of that ran everything until the current error...

Were close guys, thanks for the forth coming help!

Add this to your config file:

Code:

        <database>

                <host>127.0.0.1</host>

                <port>3306</port>

                <username>root</username>

                <password>PASSWORD</password>

                <db>peq</db>

        </database>



        <qsdatabase>

                <host>127.0.0.1</host>

                <port>3306</port>

                <username>root</username>

                <password>PASSWORD</password>

                <db>peq</db>

        </qsdatabase>

These are designed to be modular..even though, most people will only use one machine to run everything.

EDIT: I thought that had been added to the repo config file..

It has been Uleat, I inadvertently deleted that section. I went back and looked in the original file...DOH!

Thanks man, I'll put this back in and try again!

I believe the server is running, however, I do not see it on the server list here...

I have the following windows open, which others seem to have open as well, and they have the same issue. I did remove my account and password from the top of the config file, but my server still doesn't display. Ideas?

Image of the four windows open and "running" :

http://prntscr.com/3cew5r

My current Config file for reference:

Code:

<?xml version="1.0"?>

<server>

        <world>

                <shortname>DEQ</shortname>

                <longname>Deja EQ</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>login.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="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>PASSWORD</password>

                <db>peq</db>

        </database>



        

        <qsdatabase>

                <host>127.0.0.1</host>

                <port>3306</port>

                <username>root</username>

                <password>PASSWORD</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>

If you go back and look at the last config you posted before this you were using the wrong database name in the qsdatabase block.

Okay no errors within the log files. I have the four windows, previously screen shot posted. the following are my MOST RECENT Config and Login files. I still do not see the server on the public list.

Config File:

Code:

<?xml version="1.0"?>

<server>

        <world>

                <shortname>DEQ</shortname>

                <longname>Deja EQ</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>login.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="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>PASSWORD</password>

                <db>peq</db>

        </database>



        

        <qsdatabase>

                <host>127.0.0.1</host>

                <port>3306</port>

                <username>root</username>

                <password>PASSWORD</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>

Code:

[database]

host = localhost

port = 3306

db = peq

user = root

password = MYPASSWORD

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

Here is a screenshot of the log folder, does this help at all? I don't see anything about a login server...

http://prntscr.com/3cl0yi

Quote:

Originally Posted by Hockyplr (Post 229913)

Here is a screenshot of the log folder, does this help at all? I don't see anything about a login server...

Not surprising since you're not running your own login server. Any information about why world could not connect to the public login server would be in the world logs.