problem with making new server

Bigolenoobert · #1 09-14-2015, 04:27 PM

hi guys big ole noobert here. new to emu crafting. i am having some issues. with creating my server with the emu pack provided by akka

I go to hit the 1 key. to backup to a folder. and it says.
Error occurred... Exiting...

anyone know what causes this?

Next issue

i am using the titanium client. when i open the client it just says connecting.... and thats it. it just stays like that.

also [World Server] Loading server configuration..
[World Server] CURRENT_VERSION: 1.1.3
[World Server] Added loginserver login.eqemulator.net:5998
[World Server] Connecting to MySQL...
[Status] Starting File Log 'logs/world_4852.log'
[World Server] Starting HTTP world service...
[World Server] Checking Database Conversions..
[MySQL Error] 1050: Table 'character_corpse_items' already exists
CREATE TABLE `character_corpse_items` ( `corpse_id` int(11) unsigned N
OT NULL, `equip_slot` int(11) unsigned NOT NULL, `item_
id` int(11) unsigned DEFAULT NULL, `charges` int(11) unsigned DEFAULT NUL
L, `aug_1` int(11) unsigned DEFAULT '0', `aug_2` int(11) unsign
ed DEFAULT '0', `aug_3` int(11) unsigned DEFAULT '0', `aug_4
` int(11) unsigned DEFAULT '0', `aug_5` int(11) unsigned DEFAULT '0',
`aug_6` int(11) unsigned DEFAULT '0', `attuned` smallint(5)
NOT NULL DEFAULT '0', PRIMARY KEY(`corpse_id`, `equip_slot`) ) ENGI
NE = InnoDB DEFAULT CHARSET = latin1;
[MySQL Error] 1050: Table 'character_corpses' already exists
RENAME TABLE `player_corpses` TO `character_corpses`
[MySQL Error] 1932: Table 'peq.character_corpses' doesn't exist in engine
ALTER TABLE `character_corpses`

ADD COLUMN `is_locked` tinyint(11) NULL DEFAULT 0 AFTER `Was
AtGraveyard`,
ADD COLUMN `exp` int(11) UNSIGNED NULL DEFAULT 0,

ADD COLUMN `size` int(11) UNSIGNED NULL DEFAULT 0,

ADD COLUMN `level` int(11) UNSIGNED NULL DEFAULT 0,

ADD COLUMN `race` int(11) UNSIGNED NULL DEFAULT 0,

ADD COLUMN `gender` int(11) UNSIGNED NULL DEFAULT 0,

ADD COLUMN `class` int(11) UNSIGNED NULL DEFAULT 0,

ADD COLUMN `deity` int(11) UNSIGNED NULL DEFAULT 0,

ADD COLUMN `texture` int(11) UNSIGNED NULL DEFAULT 0,

ADD COLUMN `helm_texture` int(11) UNSIGNED NULL DEFAULT 0,

ADD COLUMN `copper` int(11) UNSIGNED NULL DEFAULT 0,

ADD COLUMN `silver` int(11) UNSIGNED NULL DEFAULT 0,

ADD COLUMN `gold` int(11) UNSIGNED NULL DEFAULT 0,

ADD COLUMN `platinum` int(11) UNSIGNED NULL DEFAULT 0,

ADD COLUMN `hair_color` int(11) UNSIGNED NULL DEFAULT 0,

ADD COLUMN `beard_color` int(11) UNSIGNED NULL DEFAULT 0,

ADD COLUMN `eye_color_1` int(11) UNSIGNED NULL DEFAULT 0,

ADD COLUMN `eye_color_2` int(11) UNSIGNED NULL DEFAULT 0,

ADD COLUMN `hair_style` int(11) UNSIGNED NULL DEFAULT 0,

ADD COLUMN `face` int(11) UNSIGNED NULL DEFAULT 0,

ADD COLUMN `beard` int(11) UNSIGNED NULL DEFAULT 0,

ADD COLUMN `drakkin_heritage` int(11) UNSIGNED NULL DEFAULT 0,

ADD COLUMN `drakkin_tattoo` int(11) UNSIGNED NULL DEFAULT 0,

ADD COLUMN `drakkin_details` int(11) UNSIGNED NULL DEFAULT 0,

ADD COLUMN `wc_1` int(11) UNSIGNED NULL DEFAULT 0,

ADD COLUMN `wc_2` int(11) UNSIGNED NULL DEFAULT 0,

ADD COLUMN `wc_3` int(11) UNSIGNED NULL DEFAULT 0,

ADD COLUMN `wc_4` int(11) UNSIGNED NULL DEFAULT 0,

ADD COLUMN `wc_5` int(11) UNSIGNED NULL DEFAULT 0,

ADD COLUMN `wc_6` int(11) UNSIGNED NULL DEFAULT 0,

ADD COLUMN `wc_7` int(11) UNSIGNED NULL DEFAULT 0,

ADD COLUMN `wc_8` int(11) UNSIGNED NULL DEFAULT 0,

ADD COLUMN `wc_9` int(11) UNSIGNED NULL DEFAULT 0,

CHANGE COLUMN `zoneid` `zone_id` smallint(5) NOT NULL DEFAULT 0 AFTER `charnam
e`,
CHANGE COLUMN `instanceid` `instance_id` smallint(5) UNSIGNED NOT NULL DEFAULT
0 AFTER `zone_id`,
CHANGE COLUMN `timeofdeath` `time_of_death` datetime NOT NULL DEFAULT '0000-00
-00 00:00:00' AFTER `data`,
CHANGE COLUMN `rezzed` `is_rezzed` tinyint(3) UNSIGNED NULL DEFAULT 0 AFTER `t
ime_of_death`,
CHANGE COLUMN `IsBurried` `is_buried` tinyint(3) NOT NULL DEFAULT 0 AFTER `is_
rezzed`;

[MySQL Error] 1932: Table 'peq.character_corpses' doesn't exist in engine
ALTER TABLE `character_corpses`

CHANGE COLUMN `WasAtGraveyard` `was_at_graveyard` tinyint(3) NOT NULL DEFAULT
0 AFTER `is_buried`

[MySQL Error] 1932: Table 'peq.character_corpses' doesn't exist in engine
SHOW COLUMNS FROM `character_corpses` LIKE 'data'
[Upgrade Script] No script update necessary
Perl Version is 5.12.3
================================================== ==========
EQEmu: Automatic Upgrade Check
================================================== ==========
(Windows) MySQL is in system path
Path = C:\Program Files\MariaDB 10.0\bin/mysql
================================================== ==========
Binary Database Version: (9086)
Local Database Version: (9086)

Database up to Date: Continuing World Bootup...
================================================== ==========
[World Server] Loading variables..
[World Server] Loading zones..
[World Server] Clearing groups..
[World Server] Clearing raids..
[World Server] Loading items..
[World Server] Loading skill caps..
[World Server] Loading guilds..
[World Server] Loaded default rule set 'default'
[World Server] Loading EQ time of day..
[World Server] Loading launcher list..
[World Server] Reboot zone modes OFF
[MySQL Error] 1932: Table 'peq.character_corpses' doesn't exist in engine
UPDATE `character_corpses` SET `is_buried` = 1 WHERE `is_buried` = 0 AND (UNIX_
TIMESTAMP() - UNIX_TIMESTAMP(time_of_death)) > 43200 AND NOT time_of_death = 0
[World Server] Deleted -1 stale player corpses from database
[World Server] Loading adventures...
[World Server] Purging expired instances
[World Server] Loading char create info...
[World Server] Zone (TCP) listener started.
[World Server] Client (UDP) listener started.
Unable to open opcodes file 'patch_UF.conf'. Thats bad.
Unable to open opcodes file 'patch_RoF2.conf'. Thats bad.
[World Server] New TCP connection from 127.0.0.1:50689
[World Server] New TCP connection from 127.0.0.1:50690
[World Server] New TCP connection from 127.0.0.1:50691
[World Server] New TCP connection from 127.0.0.1:50695
[World Server] New TCP connection from 127.0.0.1:50724
[World Server] New TCP connection from 127.0.0.1:50726
[World Server] New TCP connection from 127.0.0.1:50728
[World Server] New TCP connection from 127.0.0.1:50730

so several problems all in different orders. can anyone help ? thanks. i really would like to get this server up

Bigolenoobert · #2 09-14-2015, 06:36 PM

any help would be great. if anyone has a instant messenger i can talk to you on to make all of this way faster that would be great. and may cause less confusion

Bigolenoobert · #3 09-14-2015, 08:31 PM

any help at all? almost 50 views and no biters. i dont feel akkas emu repack gave enough info on fully getting the server up. theres more stuff apparently i need to do. that wasnt in the emu pack guide. any help would be great. a link to a full entire guide.

**Akkadius** · #4 09-14-2015, 08:35 PM

What you post doesn't really give any clear indication of issues. Your database is up to date and the server launched, I'm not sure what else you want.

The repack works out of the box.

You also didn't mention any of the steps you took to get to your point you just want someone to resolve your issue as soon as possible

Your character_corpses table but it also looks like it was existing at some point to, so I'm assuming you've been doing some things as well

Bigolenoobert · #5 09-14-2015, 09:00 PM

Hello thanks for the prompt reply. i think my main issue now is being able to connect to the titanium client. when i try to connect it just says connecting....... and then gives me a connection issue error after several minutes

Bigolenoobert · #6 09-14-2015, 09:05 PM

Im sorry if any of this is confusing or a hassle. im pretty new to this. and im just kinda jumping around. hoping to make this work.

Bigolenoobert · #7 09-14-2015, 09:11 PM

when i click the client. it says -patching everquest-
connecting...... and never connects. this is from the titanium edition i downloaded.

**Akkadius** · #8 09-14-2015, 09:12 PM

http://wiki.eqemulator.org/p?Play_Gu...etting_Started

Bigolenoobert · #9 09-14-2015, 09:14 PM

Ahh i see! i tryed this back in feb gave up on it. now im trying it again. that is indeed one of the links i was looking at. and lost it because i never book marked it. let me take a look at the link and see what i can do. thank you again for taking your own personal time to reply. you're really doing a great thing here!

**Akkadius** · #10 09-14-2015, 09:18 PM

Quote:

Originally Posted by Bigolenoobert

Ahh i see! i tryed this back in feb gave up on it. now im trying it again. that is indeed one of the links i was looking at. and lost it because i never book marked it. let me take a look at the link and see what i can do. thank you again for taking your own personal time to reply. you're really doing a great thing here!

I'm one of very many other people who have contributed to the project.

And you're welcome

**Uleat** · #11 09-14-2015, 09:18 PM

Gotta check your server log files.

These will tell you if you are getting login attempts, are having server crashes, and a myriad of other things.

Bigolenoobert · #12 09-14-2015, 09:26 PM

Okay thanks for that other reply. i have another question. whenever i decide to format and redo my operating system again. since the repack was in the C drive. but my Eq client folder is on a different drive. is it gonna REALLY jack up my whole installation to the point to where ill need to remake characters and stuff or? is there a way to save all of that somehow before i format. so i can just put stuff back the way it was somehow?

Bigolenoobert · #13 09-14-2015, 09:39 PM

Sweet! So i am in the game.. finally.. on the default akka repack server would it be a big hassle to completely make a server of my own only im allowed onto? will that somehow get erased? is it better to just stick to this default akka repack server ? I just dont want anything to disappear someday. is that makes sense.

Shendare · #14 09-14-2015, 09:41 PM

One important note that's easy to miss with your eqhost.txt file:

Titanium and Faydwer clients need to be connecting to login.eqemulator.net:5998.

All other (newer) clients need to be connecting to login.eqemulator.net:5999. One number's difference.

Try to connect to the wrong port for your client, and you'll get the connection error every time.

**Uleat** · #15 09-14-2015, 09:45 PM

I think someone has asked the question about a private login server and Akkadius's repack before..I'll post back if I can find it.