Fresh Debain 7

[Azuull]

First, I am running ESXi and have Debian 7.7.0 running in a virtual machine.
Secondly, I am using this guide: http://wiki.eqemulator.org/p?EQEmu_on_Debian_7_Virtualbox

Third, the problem:

root@PEQ:~/server# ./world
[Status] Using database 'eq' at localhost:3306
Unable to clear group leaders: #1146: Table 'eq.group_leaders' doesn't exist
Unable to clear groups: #1146: Table 'eq.group_id' doesn't exist
Unable to clear raids: #1146: Table 'eq.raid_members' doesn't exist
Unable to clear raid details: #1146: Table 'eq.raid_details' doesn't exist
Unable to clear raid leaders: #1146: Table 'eq.raid_leaders' doesn't exist
[Error] EQLConfig::LoadSettings: #1146: Table 'eq.launcher_zones' doesn't exist
[Error] EQLConfig::LoadSettings: #1146: Table 'eq.launcher_zones' doesn't exist
[Error] Error in AdventureManager:::GetLeaderboardInfo: SELECT ch.name, ch.id, adv_stats.* FROM adventure_stats AS adv_stats LEFT JOIN `character_data` AS ch ON adv_stats.player_id = ch.id; (#1146: Table 'eq.adventure_stats' doesn't exist)




In the beginning, I was using Ubuntu Server 14.0.4.1 and then, once Debian 7.7.0 finished downloading, swapped to that after encountering that error. Error occurs under both VMs.


Assistance would be much appreciated.

[vsab]

Did you source in player-tables.sql from http://peqtgc.com/releases ?
You're just missing a few db tables is all.

[Azuull]

Did you source in player-tables.sql from http://peqtgc.com/releases ?
You're just missing a few db tables is all.



I thought this part of the guide:

$ cd ~/peq
$ mysql -u eq -p -h 127.0.0.1 eq < peqbeta_*.sql
$ mysql -u eq -p -h 127.0.0.1 eq < player_*.sql
$ cp eqtime.cfg ~/server


did that. I'll run it again and get back with you.

[Azuull]

Did you source in player-tables.sql from http://peqtgc.com/releases ?
You're just missing a few db tables is all.


Result:

root@PEQ:~/peq# mysql -u eq -p -h localhost eq < player_*.sql
Enter password:
ERROR 1050 (42S01) at line 3: Table 'commands' already exists
root@PEQ:~/peq#


I have even opened MySQL in /peq/ and tried 'source' and got 'DUPLICATE', etc.

[vsab]

Actually it dfoes look like the latest database dump is missing some tables, although the raid_leaders ones are in the /utils/sql/git/required/ part of the source. Anyway:-

CREATE TABLE IF NOT EXISTS `group_id` (
`groupid` int(4) NOT NULL,
`charid` int(4) NOT NULL,
`name` varchar(64) NOT NULL,
`ismerc` tinyint(3) NOT NULL DEFAULT '0',
PRIMARY KEY (`groupid`,`charid`,`name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `group_leaders` (
`gid` int(4) NOT NULL,
`leadername` varchar(64) NOT NULL,
`marknpc` varchar(64) NOT NULL DEFAULT '',
`leadershipaa` tinyblob,
`maintank` varchar(64) NOT NULL DEFAULT '',
`assist` varchar(64) NOT NULL DEFAULT '',
`puller` varchar(64) NOT NULL DEFAULT '',
PRIMARY KEY (`gid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `launcher_zones` (
`launcher` varchar(64) NOT NULL DEFAULT '',
`zone` varchar(16) NOT NULL DEFAULT '',
`port` mediumint(9) NOT NULL DEFAULT '0',
PRIMARY KEY (`launcher`,`zone`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


CREATE TABLE IF NOT EXISTS `raid_details` (
`raidid` int(4) NOT NULL,
`loottype` int(4) NOT NULL,
`locked` tinyint(1) NOT NULL,
PRIMARY KEY (`raidid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `raid_members` (
`raidid` int(4) NOT NULL,
`charid` int(4) NOT NULL,
`groupid` int(4) NOT NULL,
`_class` tinyint(4) NOT NULL,
`level` tinyint(4) NOT NULL,
`name` varchar(64) NOT NULL,
`isgroupleader` tinyint(1) NOT NULL,
`israidleader` tinyint(1) NOT NULL,
`islooter` tinyint(1) NOT NULL,
PRIMARY KEY (`charid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



I think we have a few issues anyway, since currently my setup is unable to group more than 2 characters..

[Azuull]

Actually it dfoes look like the latest database dump is missing some tables, although the raid_leaders ones are in the /utils/sql/git/required/ part of the source. Anyway:-

CREATE TABLE IF NOT EXISTS `group_id` (
`groupid` int(4) NOT NULL,
`charid` int(4) NOT NULL,
`name` varchar(64) NOT NULL,
`ismerc` tinyint(3) NOT NULL DEFAULT '0',
PRIMARY KEY (`groupid`,`charid`,`name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `group_leaders` (
`gid` int(4) NOT NULL,
`leadername` varchar(64) NOT NULL,
`marknpc` varchar(64) NOT NULL DEFAULT '',
`leadershipaa` tinyblob,
`maintank` varchar(64) NOT NULL DEFAULT '',
`assist` varchar(64) NOT NULL DEFAULT '',
`puller` varchar(64) NOT NULL DEFAULT '',
PRIMARY KEY (`gid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `launcher_zones` (
`launcher` varchar(64) NOT NULL DEFAULT '',
`zone` varchar(16) NOT NULL DEFAULT '',
`port` mediumint(9) NOT NULL DEFAULT '0',
PRIMARY KEY (`launcher`,`zone`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


CREATE TABLE IF NOT EXISTS `raid_details` (
`raidid` int(4) NOT NULL,
`loottype` int(4) NOT NULL,
`locked` tinyint(1) NOT NULL,
PRIMARY KEY (`raidid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `raid_members` (
`raidid` int(4) NOT NULL,
`charid` int(4) NOT NULL,
`groupid` int(4) NOT NULL,
`_class` tinyint(4) NOT NULL,
`level` tinyint(4) NOT NULL,
`name` varchar(64) NOT NULL,
`isgroupleader` tinyint(1) NOT NULL,
`israidleader` tinyint(1) NOT NULL,
`islooter` tinyint(1) NOT NULL,
PRIMARY KEY (`charid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



I think we have a few issues anyway, since currently my setup is unable to group more than 2 characters..


So, would it be safe to say to step back a release and use that one? Instead of using peqbeta_* OCT 11, use peqbeta_* SEPT ?

[vsab]

The one for 25th September seems more complete that the later one, try that then remember to source in the sql patches that are in the source code repo under utils/sql/git/required/ (and can do the optional as well if you like).

[Azuull]

The one for 25th September seems more complete that the later one, try that then remember to source in the sql patches that are in the source code repo under utils/sql/git/required/ (and can do the optional as well if you like).

Okay, I appreciate it.

On another note, is there a good guide to follow to setup a login server? I found one but, somehow, it doesn't seem complete.

[vsab]

not really for linux..

Ensure you have the dependencies in your dependencies folder (Ubuntu ones worked for me on Debian 7) from eqemu.github.io.

Run cmake -i and make build login server to "on". then hit make again.

The rest is the same as for Windows servers really in terms of database stuff. I just blanket copy all of bin/ to where I run the server, so it copies the .a and .o files as well as the binaries.
http://wiki.eqemulator.org/p?Windows_Private_Login_Server_Setup_Guide&frm=Main

I use this:-
http://wiki.eqemulator.org/i?M=Pastebin&Paste=tiC4AqP8
to run the server. It's fairly easy to modify to run the login server too.

[Azuull]

September's release did indeed work. I haven't gotten around to attempting a private login server yet. Will post once I attempt, with results.