problem with making new server

[Bigolenoobert]

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]

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]

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]

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]

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]

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]

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

[Akkadius]

http://wiki.eqemulator.org/p?Play_Guide:_Getting_Started

[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!

[Akkadius]

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]

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]

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]

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]

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]

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.

[Bigolenoobert]

Okay. Thanks for that tip shendare. and Uleat Alright. i appreciate the help and searching.

[Uleat]

At a minimum, you will need the bottom 7 files from here: https://github.com/EQEmu/Server/tree/master/loginserver/login_util

(Do NOT apply the 2 'EQEmuLogin##' sql files. The last 4 are the sql files needed to update your database for login server accounts.)


You will also need to update your configuration files based on this: http://wiki.eqemulator.org/p?Windows_Private_Login_Server_Setup_Guide&frm=Main

(There is a link floating around to a pre-compiled login server binary..I just can't find it atm...)


You will probably need to use this eqemu_config.xml file as well: https://github.com/EQEmu/Server/blob/master/utils/defaults/eqemu_config.xml.full

(Make a back-up copy of your current one, and you should be able to just copy the contents over it. I can't remember if the repack's config file is the short or long
one..so, verify that before copying the contents over.)


Finding that binary and proper configuration should be all that you need at this point.


If you plan to run a 'disconnected' (from the internet) server, then make sure that you read this: http://wiki.eqemulator.org/p?Complete_Windows-based_Server_Setup_Guide&frm=Main

(In particular, section 6d - Database Updates (Applying).)


I haven't tested the repack and private login combo myself..but, there are at least a handful of people who have reported success with it.

[Bigolenoobert]

thanks for that information. im curious. what happens if i just leave it as it is. as akkas repack default server. will other people get in? or will it always just be me. and will there be alot of server down time or?

[Uleat]

As-is is fine too!

There are ways to keep others out, such as locking your server in your config file and giving people that you want in a high enough status to bypass the lock.

I haven't played with that feature..but, there are posts about it.


Downtime for the eqemu public login server is fairly low.

Host computer updates and occasional bouts of DDoS'ing are about all I've seen in the last 3 1/2 years.

EDIT: Though your computer and the eqemu public login server may be up and working, it's possible to have problems with your ISP or other 'backbone' computers.


You can always play on the public login server until you become more comfortable with the administrative aspect and then decide if you want to go with a private
login server later on.


If you plan on running a LAN-only server, I (personally) highly recommend a private login server..but, it is not necessary..and, again, can wait until you're
comfortable in setting one up.

[AdrianD]

I agree with Uleat about carriaging that horse to let all this sink in a bit. I haven't been around very long and patience isn't my style but, I've noticed I get quite a few "Aha!" moments if I come back to it later and can ask questions differently. That's been my experience.

Congratulations on your new server! How exciting!

[Bigolenoobert]

As-is is fine too!

There are ways to keep others out, such as locking your server in your config file and giving people that you want in a high enough status to bypass the lock.

I haven't played with that feature..but, there are posts about it.


Downtime for the eqemu public login server is fairly low.

Host computer updates and occasional bouts of DDoS'ing are about all I've seen in the last 3 1/2 years.

EDIT: Though your computer and the eqemu public login server may be up and working, it's possible to have problems with your ISP or other 'backbone' computers.


You can always play on the public login server until you become more comfortable with the administrative aspect and then decide if you want to go with a private
login server later on.


If you plan on running a LAN-only server, I (personally) highly recommend a private login server..but, it is not necessary..and, again, can wait until you're
comfortable in setting one up.




which config file do i open? and what do i gotta do to lock it as is. on the default akka repack server

[Uleat]

Redirect to answer: http://www.eqemulator.org/forums/showthread.php?t=40012

(Open questions are a pita when you're searching the forums.)