Luclin RC1 problems

PsychoticX · #1 08-23-2006, 05:44 PM

Well according to project eq... http://www.projecteq.net/ they got an update of the PEQ database that has basically every pre-pop zone (cept vexthal) tuned. I went to install it and after several tries, no use... Even though my original install (cavedude's pack for 0.7.0) works fine with the normal PEQ.

I run mysql prompt and "mysql> source filename" them in. Mysql cc crashes and I can't think of any way to get 100mb of queries to install. The queries get updated fine though.

When I run the updated database (in either 0.7.0 or the latest version), I get this error...

(I cut these short but both let them try 100 times)

straight from cavedude's install...
[Debug] Starting Log: logs/eqemu_debug_2484.log
[Debug] [LAUNCHER__INIT] Loading server configuration..
[Debug] [LAUNCHER__INIT] Starting main loop...
[Debug] [NET__WORLD] Connected to World: 127.0.0.1:9000
[Debug] [NET__WORLD] Connected to World: 127.0.0.1:9000
[Debug] [NET__WORLD] Connected to World: 127.0.0.1:9000
[Debug] [NET__WORLD] Connected to World: 127.0.0.1:9000

Then from the latest revision...
[Debug] Starting Log: logs/eqemu_debug_world_0796.log
[Debug] [WORLD__INIT] Loading server configuration..
[Debug] [WORLD__INIT] Log settings loaded from log.ini
[Debug] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEMu 0.7.0
[Debug] [WORLD__INIT] Connecting to MySQL...
[Status] Starting Log: logs/eqemu_world_0796.log
[Status] Using database 'peq' at localhost:3306
[Debug] [WORLD__INIT] Starting HTTP world service...
[Debug] [WORLD__HTTP] Loaded mime types from mime.types
[Debug] [WORLD__INIT] Loading variables..
[Debug] [WORLD__INIT] Loading zones..
[Debug] [WORLD__INIT] Clearing groups..
[Debug] [WORLD__INIT] Clearing temporary merchant lists..
[Debug] [WORLD__INIT] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=54307
[Debug] [WORLD__INIT] Loading guilds..
[Debug] [WORLD__INIT] Loading EQ time of day..
[Debug] [WORLD__INIT] Loading launcher list..
[Debug] [WORLD__INIT] Reboot zone modes OFF
[Debug] [WORLD__INIT] Deleted 0 stale player corpses from database
[Debug] [WORLD__INIT] Deleted 0 stale player backups from database
[Debug] [WORLD__INIT] Zone (TCP) listener started.
[Debug] [WORLD__INIT] Client (UDP) listener started.
[Debug] [NET__IDENTIFY] Registered patch 6.2
[Debug] [NET__IDENTIFY] Registered patch Titanium
[Debug] [NET__IDENTIFY] Registered patch Live
[Debug] [WORLD__LS] Connecting to login server...
[Debug] [WORLD__LS] Connected to Loginserver: 127.0.0.1:5999
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:1173
[Debug] [WORLD__CONSOLE] New launcher from 127.0.0.1:1173
[Debug] [WORLD__LAUNCH] Adding pending launcher 1
[Debug] [WORLD__LAUNCH] Unknown launcher 'zones' connected. Disconnecting.
[Debug] [WORLD__LAUNCH] Removing pending launcher 1. Adding zones to active list
.
[Debug] [WORLD__LAUNCH] Removing launcher zones (1)
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:1174
[Debug] [WORLD__CONSOLE] New launcher from 127.0.0.1:1174
[Debug] [WORLD__LAUNCH] Adding pending launcher 2
[Debug] [WORLD__LAUNCH] Unknown launcher 'zones' connected. Disconnecting.
[Debug] [WORLD__LAUNCH] Removing pending launcher 2. Adding zones to active list
.
[Debug] [WORLD__LAUNCH] Removing launcher zones (2)
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:1175
[Debug] [WORLD__CONSOLE] New launcher from 127.0.0.1:1175
[Debug] [WORLD__LAUNCH] Adding pending launcher 3
[Debug] [WORLD__LAUNCH] Unknown launcher 'zones' connected. Disconnecting.
[Debug] [WORLD__LAUNCH] Removing pending launcher 3. Adding zones to active list
.
[Debug] [WORLD__LAUNCH] Removing launcher zones (3)
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:1176
[Debug] [WORLD__CONSOLE] New launcher from 127.0.0.1:1176
[Debug] [WORLD__LAUNCH] Adding pending launcher 4
[Debug] [WORLD__LAUNCH] Unknown launcher 'zones' connected. Disconnecting.
[Debug] [WORLD__LAUNCH] Removing pending launcher 4. Adding zones to active list
.
[Debug] [WORLD__LAUNCH] Removing launcher zones (4)
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:1177
[Debug] [WORLD__CONSOLE] New launcher from 127.0.0.1:1177
[Debug] [WORLD__LAUNCH] Adding pending launcher 5

And again, my server WORKS FINE before I update the database.

Any help would be appreciated, or if anyone is having this problem let me know.

#2 08-23-2006, 09:49 PM

did you post this / check on the PEQ forums?

John Adams · #3 08-24-2006, 02:43 AM

Quote:

Originally Posted by PsychoticX

[Debug] [WORLD__INIT] Connecting to MySQL...
[Status] Starting Log: logs/eqemu_world_0796.log
[Status] Using database 'peq' at localhost:3306
[Debug] [WORLD__INIT] Starting HTTP world service...
[Debug] [WORLD__HTTP] Loaded mime types from mime.types
[Debug] [WORLD__INIT] Loading variables..
[Debug] [WORLD__INIT] Loading zones..
[Debug] [WORLD__INIT] Clearing groups..
[Debug] [WORLD__INIT] Clearing temporary merchant lists..
[Debug] [WORLD__INIT] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=54307
[Debug] [WORLD__INIT] Loading guilds..
[Debug] [WORLD__INIT] Loading EQ time of day..
[Debug] [WORLD__INIT] Loading launcher list..
[Debug] [WORLD__INIT] Reboot zone modes OFF
[Debug] [WORLD__INIT] Deleted 0 stale player corpses from database
[Debug] [WORLD__INIT] Deleted 0 stale player backups from database

I am not understanding how you think this is a PEQ database issue when all the above (quoted) database reads seem to have no problems? It's likely your IP setup that's causing problems. There's a post by Crabclaw floating around here that seems to solve some issues with local/minilogin setups.

Aramid · #4 08-24-2006, 03:10 AM

Quote:

Originally Posted by PsychoticX

[Debug] [WORLD__LS] Connected to Loginserver: 127.0.0.1:5999
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:1173
[Debug] [WORLD__CONSOLE] New launcher from 127.0.0.1:1173
[Debug] [WORLD__LAUNCH] Adding pending launcher 1
[Debug] [WORLD__LAUNCH] Unknown launcher 'zones' connected. Disconnecting.
[Debug] [WORLD__LAUNCH] Removing pending launcher 1. Adding zones to active list
.
[Debug] [WORLD__LAUNCH] Removing launcher zones (1)
[Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:1174
[Debug] [WORLD__CONSOLE] New launcher from 127.0.0.1:1174
[Debug] [WORLD__LAUNCH] Adding pending launcher 2
[Debug] [WORLD__LAUNCH] Unknown launcher 'zones' connected. Disconnecting.

Check your Database Tables. Make sure you have a table called

launcher

It seems that you do

If your using MySqlcc, highlight launcher and make sure it contains 2 fields called name and dynamics

Press enter on launcher and see that those fields have the entries

Name --- Dynamics
zones ----- 5

The dashes won't be there, they are used for spacing in this message and the number can be different than 5, 5 is the default.

I was able to duplicate your problem by changing zones to just zone.

LostZaphod · #5 08-24-2006, 03:25 AM

It looks like the schema of the RC1 is that of EQEmu-0.7.0-815 (I did not look at user related tables, or the data, you may have some missing data also).

If you are not using that version of executables you are going to have issues. I suggest going to EQEmu-0.7.0-845 and do all updates that are contained in the change log starting at 815 (07/05/2006) up to 845, and allways do the oldest ones first. Before you do anything BACKUP your current database.

PsychoticX · #6 08-24-2006, 03:31 AM

Adding

Name --- Dynamics
zones ----- 5

seems to have worked, the luclin rc1 pack basically rebuilds your database and for some reason those values weren't there. The table was there but it was empty. I will post this on the PEQ forums so hopefully they can resolve this on their end.

Angelox · #7 08-24-2006, 03:37 AM

Quote:

Originally Posted by PsychoticX

Well according to project eq... http://www.projecteq.net/ they got an update of the PEQ database that has basically every pre-pop zone (cept vexthal) tuned.

Does anyone know what was fixed, or can point me to it?

John Adams · #8 08-24-2006, 03:51 AM

Pretty sure he's referring to the existing Luclin RC1 (what was that, July 17th?) I do not see any notice that it has been updated by PEQ since RC1 release.

bufferofnewbies · #9 10-02-2006, 01:03 PM

This may be a fluke, but i had that error in my test setup for 0.7.0

I changed the ZONES that was listed to zones (from capital to lowercase) and it went thru. Seems the field is case sensitive also.

Hope that was of some help to you.

Astaldoath · #10 10-06-2006, 08:38 AM

I dont even know how to source luclin RC1, can someone explain it to me, i wanna get serious with my server and dont wanna use cavedudes to do it

Angelox · #11 10-06-2006, 09:10 AM

Quote:

Originally Posted by Astaldoath

I dont even know how to source luclin RC1, can someone explain it to me, i wanna get serious with my server and dont wanna use cavedudes to do it

Well, you can use mine if you want - it's based on the PEQ database, just has more zones and work added to it. You don't have to source it (and it's all up to date), only need to restore.
Read through all of my web page if you do decide to use it.
And if you really are serious, then you should learn to use Wiki, this forum search, and follow instructions. Your question is very simple, but you have to learn this yourself.

John Adams · #12 10-06-2006, 12:16 PM

Angelox, with as much work as you've done, I think you deserve your own Wiki page.

You up for it?

Magefeu · #13 10-06-2006, 08:58 PM

Just to let you know that the fix for this problem is in the wiki...

http://www.eqemulator.net/wiki/wikka...=ws70845mysql5

Astaldoath · #14 10-07-2006, 04:04 AM

Quote:

Originally Posted by Angelox

Well, you can use mine if you want - it's based on the PEQ database, just has more zones and work added to it. You don't have to source it (and it's all up to date), only need to restore.
Read through all of my web page if you do decide to use it.
And if you really are serious, then you should learn to use Wiki, this forum search, and follow instructions. Your question is very simple, but you have to learn this yourself.

I searched the wiki, i couldnt find anything about sourcing the database (i guess thats what I need to do) I know how to install via the 7.0 server setup guide. I can do quest scripting, adding items npcs ect.... just couldnt find anywhere to explain how to get the peq up and runnin

John Adams · #15 10-07-2006, 03:23 PM

Importing the SQL files into MySQL could be added to the Wiki, but I think most people feel that is not an "emulator task", but something someone should know how to do anyway. I knew how to run SQL scripts, but I did not know the "source" command in the mysql> prompt until coming to the Emulator (I am an MSSQL guy). I found what I needed by Googling, and discovering many helpful MySQL hints on the MySQL site itself.

But, in short, run "mysql -u root -p", if you have a password on your root, otherwise no -p. Type "use peq" if peq is the name of your database (if you do not have a peq database, I suggest using Cavedudes 352 installer, which does a sh*t-ton of this work for you). Last thing, at the mysql> prompt, just type "source load_system.sql". Be sure put the load_system.sql in the current dir, or you'll need the full path "C:\Temp\load_system.sql" etc... do the same for load_empty_users.sql, and you are then ready to add your first user (which is in the Wiki and all over this forum).