EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   server locked issues (https://www.eqemulator.org/forums/showthread.php?t=37727)

jshows1 01-11-2014 03:43 PM

server locked issues
 
Hey guys. I've had my server up and running for some time now (almost a year) without any issues.

Recently, however, I have wiped my HD and had to start over. I followed the install guide like I did before. When I get to the database section I source in my old database instead of using the new one.

When I start the server up, it shows up in the server screen, however it's locked. I notice that I'm getting a few errors:

1) the world log is giving me this error

Code:

---------------------------------------------
[01.11. - 13:27:38] Starting Log: logs/eqemu_error_world_5668.log
[01.11. - 13:27:38] Could not load EQTime file eqtime.cfg

Now from what I've read around the forums, that shouldn't be a big deal, correct? If I'm wrong, let me know what I need to do in order to fix that pls.

2) in the zone logs, I'm getting this error

Code:

---------------------------------------------
[01.11. - 13:40:05] Starting Log: logs/eqemu_error_zone_6272.log
[01.11. - 13:40:05] Error in GetMaxBaseDataLevel query 'SELECT MAX(level) FROM base_data' #1146: Table 'peq.base_data' doesn't exist
[01.11. - 13:40:05] Error Loading Base Data: EQEmu Exception (SharedDatabase) in ..\..\common\shareddb.cpp at line (1783): Base Data size is zero

So it loks like I'm missing a base_data table from my database? Not sure if that's correct. What's confusing to me is this is the same database that's been working fine. It's a backup of one I used several months back.

That being said, I realize that more than likely the problem is what it usually is: User error. I would much appreciate it if you guys could steer me in the right direction.

also here is a copy of my xml file:

Code:

<?xml version="1.0"?>
<server>
        <world>
                <shortname>Jer</shortname>
                <longname>Jer's Server</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>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>bleh</username>
                <password>bleh</password>
                <db>peq</db>
        </database>

        <qsdatabase>
                <host>127.0.0.1</host>
                <port>3306</port>
                <username>bleh</username>
                <password>bleh</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>


demonstar55 01-11-2014 04:29 PM

I'm guessing you're using a dated guide
https://github.com/EQEmu/Server/wiki...s-Server-Setup

Has two more up to date guides. Well, one of them is, the other is being updated ATM :P

jshows1 01-14-2014 07:32 PM

Thanks for the response, Demon! I was able to finally get my server up and running. I found and sourced in the base_data table. What's interesting is my server ran fine before I reformatted my HD. I made a backup of my old server before I nuked my machine. Not sure why, when I sourced it back in once I re installed, that it wouldn't run. Evidently it was looking for that table which wasn't necessary before. I'm guessing it had to do with an updated version of the whole process.

Anyway, thanks a bunch for the help.


All times are GMT -4. The time now is 05:46 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.