|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Support::Windows Servers Support forum for Windows EQEMu users. |
04-18-2008, 11:20 PM
|
Sarnak
|
|
Join Date: Aug 2006
Posts: 52
|
|
PEQDB Error??
Hi guys im getting this error when i try to source my sql file that i extracted right after with winrar. any suggestions on how i can fix this?
Thanks in advance
|
04-18-2008, 11:47 PM
|
Sarnak
|
|
Join Date: Aug 2006
Posts: 52
|
|
Ive also realized that this may be because my path was C:\Peqdb_Peq_Db , i had ran those commands when there 2 peqdb folders inside eachother, copied the files into one folder and it became C:\peqdb , and its still giving me the same thing now, mabye its because i created database peq; when i had those 2 folders in eachother ?
|
04-19-2008, 09:45 AM
|
Sarnak
|
|
Join Date: Dec 2006
Posts: 98
|
|
Try typing in the whole address of "source c:\peqdb\peqdb_1106.sql". Just because you \u in mysql, doesn't change the directory for when you try and open files, it just changes the DB.
|
04-19-2008, 12:22 PM
|
Sarnak
|
|
Join Date: Aug 2006
Posts: 52
|
|
god bless you ;p works now thanks alot hehe
|
04-19-2008, 12:37 PM
|
Sarnak
|
|
Join Date: Aug 2006
Posts: 52
|
|
but now ive been hit with another probem when i run my start.bat =/
|
04-19-2008, 12:48 PM
|
Sarnak
|
|
Join Date: Dec 2006
Posts: 98
|
|
check your eqemu_config.xml file. It sounds like you don't have the right user/password/DB being assigned in it. If you used cavedude's installer pack4, the eqemu_config.xml file is wrong as it lists the db as "eq" by default instead of the actual database it makes which is "peq".
It should read something like:
<?xml version="1.0">
<server>
<world>
<shortname>Birthright [PEQ-Custom All Spells and Items]</shortname>
<longname>Birthright [PEQ-Custom All Spells and Items]</longname>
<address>WAN IP</address>
<localaddress>LAN IP</localaddress>
<loginserver>
<host>eqemulator.net</host>
<port>5998</port>
<account></account>
<password></password>
</loginserver>
<key>12345678</key>
<http port="9080" enabled="true" mimefile="mime.types" />
</world>
<database>
<host>localhost</host>
<port>3306</port>
<username>root</username>
<password>what ever you made it during MySQL setup</password>
<db>peq</db>
</database>
</server>
|
04-19-2008, 01:01 PM
|
Sarnak
|
|
Join Date: Aug 2006
Posts: 52
|
|
Nope did all of that stuff correctly ,but there are 2 files ... eqemu_config(XML document) and eqemu_config.xml.full (FULL document) can this be my problem?
EDIT:: deleted the eqemu full file as it had stupid unnecessary information in it. Start.bat still gives me the same errors
|
|
|
|
04-19-2008, 01:12 PM
|
Sarnak
|
|
Join Date: Aug 2006
Posts: 52
|
|
some other logs
Quote:
---------------------------------------------
[04.19. - 12:31:50] Starting Log: logs/eqemu_debug_world_3476.log
[04.19. - 12:31:50] [WORLD__INIT] Loading server configuration..
[04.19. - 12:31:50] [WORLD__INIT] Log settings loaded from log.ini
[04.19. - 12:31:50] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEMu 0.7.0
[04.19. - 12:31:50] [WORLD__INIT] Connecting to MySQL...
[04.19. - 12:31:50] [WORLD__INIT] Starting HTTP world service...
[04.19. - 12:31:50] [WORLD__HTTP] Loaded mime types from mime.types
[04.19. - 12:31:50] [WORLD__INIT] Loading variables..
[04.19. - 12:31:50] [WORLD__INIT] Loading zones..
[04.19. - 12:31:50] [WORLD__INIT] Clearing groups..
[04.19. - 12:31:50] [WORLD__INIT] Clearing temporary merchant lists..
[04.19. - 12:31:50] [WORLD__INIT] Loading items..
[04.19. - 12:32:20] [WORLD__INIT] Loading guilds..
[04.19. - 12:32:20] [GUILDS__ERROR] Error loading guilds 'SELECT id, name, leader, minstatus, motd, motd_setter FROM guilds': #1146: Table 'peq.guilds' doesn't exist
[04.19. - 12:32:20] [RULES__ERROR] Failed to find ruleset 'default' for load operation. Canceling.
[04.19. - 12:32:20] [WORLD__INIT] No rule set configured, using default rules
[04.19. - 12:32:20] [WORLD__INIT] Loading EQ time of day..
[04.19. - 12:32:20] [WORLD__INIT_ERR] Unable to load eqtime.cfg
[04.19. - 12:32:20] [WORLD__INIT] Loading launcher list..
[04.19. - 12:32:20] [WORLD__INIT] Reboot zone modes OFF
[04.19. - 12:32:20] [WORLD__INIT] Deleted -1 stale player corpses from database
[04.19. - 12:32:20] [WORLD__INIT] Deleted -1 stale player backups from database
[04.19. - 12:32:20] [WORLD__INIT] Zone (TCP) listener started.
[04.19. - 12:32:20] [WORLD__INIT] Client (UDP) listener started.
[04.19. - 12:32:20] [NET__IDENTIFY] Registered patch 6.2
[04.19. - 12:32:20] [NET__IDENTIFY] Registered patch Titanium
[04.19. - 12:32:20] [NET__IDENTIFY] Registered patch Anniversary
[04.19. - 12:32:20] [NET__IDENTIFY] Registered patch Live
[04.19. - 12:32:20] [WORLD__LS] Connecting to login server...
[04.19. - 12:32:20] [WORLD__LS] Connected to Loginserver: eqemulator.net:5998
[04.19. - 12:32:21] [WORLD__LS] Loginserver provided 69.118.154.199 as world address
[04.19. - 12:33:36] [WORLD__ZONE] New TCP connection from 127.0.0.1:2425
[04.19. - 12:33:36] [WORLD__CONSOLE] New launcher from 127.0.0.1:2425
[04.19. - 12:33:36] [WORLD__LAUNCH] Adding pending launcher 1
[04.19. - 12:33:36] [WORLD__LAUNCH] Unknown launcher 'zone' connected. Disconnecting.
[04.19. - 12:33:36] [WORLD__LAUNCH] Removing pending launcher 1. Adding zone to active list.
[04.19. - 12:33:36] [WORLD__LAUNCH] Removing launcher zone (1)
[04.19. - 12:33:51] [WORLD__ZONE] New TCP connection from 127.0.0.1:2429
[04.19. - 12:33:51] [WORLD__CONSOLE] New launcher from 127.0.0.1:2429
[04.19. - 12:33:51] [WORLD__LAUNCH] Adding pending launcher 2
[04.19. - 12:33:56] [WORLD__LAUNCH] Unknown launcher 'zone' connected. Disconnecting.
[04.19. - 12:33:56] [WORLD__LAUNCH] Removing pending launcher 2. Adding zone to active list.
[04.19. - 12:33:56] [WORLD__LAUNCH] Removing launcher zone (2)
[04.19. - 12:34:06] [WORLD__ZONE] New TCP connection from 127.0.0.1:2441
[04.19. - 12:34:06] [WORLD__CONSOLE] New launcher from 127.0.0.1:2441
[04.19. - 12:34:06] [WORLD__LAUNCH] Adding pending launcher 3
[04.19. - 12:34:11] [WORLD__LAUNCH] Unknown launcher 'zone' connected. Disconnecting.
[04.19. - 12:34:11] [WORLD__LAUNCH] Removing pending launcher 3. Adding zone to active list.
[04.19. - 12:34:11] [WORLD__LAUNCH] Removing launcher zone (3)
[04.19. - 12:34:21] [WORLD__ZONE] New TCP connection from 127.0.0.1:2454
[04.19. - 12:34:21] [WORLD__CONSOLE] New launcher from 127.0.0.1:2454
[04.19. - 12:34:21] [WORLD__LAUNCH] Adding pending launcher 4
|
|
|
|
|
04-19-2008, 02:00 PM
|
|
The PEQ Dude
|
|
Join Date: Apr 2003
Location: -
Posts: 1,988
|
|
You're missing your player tables, be sure to source load_player.sql as well.
|
04-19-2008, 04:28 PM
|
Sarnak
|
|
Join Date: Aug 2006
Posts: 52
|
|
k went back opened up mysql commandline and pathed to my peqdb folder and tried to source load_player.sql and this is what happened =/
here is a ss of what my peqdb folder contains ...
|
04-19-2008, 04:35 PM
|
Sarnak
|
|
Join Date: Aug 2006
Posts: 52
|
|
also ... tried sourcing aa_timers.sql independently and this is what happened ...
and for those concerned about the wrong XML writeout ... heres mine ;
|
04-19-2008, 07:27 PM
|
Sarnak
|
|
Join Date: Dec 2006
Posts: 98
|
|
Your address line is wrong. how you have it now would be if you were using minilogin, but your loginserver is listed as eqemulator.net. If you are trying to host it via public login server, then the address line MUST be the IP your cable/dsl modem is using, NOT a private IP such as 192.168.xxx.xxx.
Example:
<address>12.345.6.78</address>
<localaddress>192.168.5.15</localaddress>
|
04-19-2008, 07:52 PM
|
Sarnak
|
|
Join Date: Aug 2006
Posts: 52
|
|
how would i figure out the IP my cable/dsl modem is using then? is my localaddress correct? Will this correct my sourcing problem ?
|
04-21-2008, 10:49 PM
|
Fire Beetle
|
|
Join Date: Apr 2006
Posts: 3
|
|
Not sure if this will help, but I ran across a similar issue with the variables table not being there. When I sourced load_player.sql MySQL errored on me. I checked my PEQ database and noticed it didn't follow through all the source files listed in load_player.sql. I matched up and found that it had stopped on name_filter.sql. I then removed this from load_player.sql and re-sourced it with no error.
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 04:58 PM.
|
|
|
|
|
|
|
|
|
|
|
|
|