Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Linux Servers

Support::Linux Servers Support forum for Linux EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 01-13-2024, 06:49 PM
Xamven
Fire Beetle
 
Join Date: Jul 2019
Posts: 12
Default Latest linux + docker images missing SQL files on fresh install, fatal error.

Over the last few days I've done probably a dozen installs across windows, linux + docker, and just wondering if there's a suggested 'stable' release I should be targeting to install?

I was attempting to setup an AWS based instance (ubuntu 20.04) with massive overkill specs to find out if my slowness with 12+ toons was related to my local clients or the server, and ran into problems with both a standard 'basic linux' install, and the docker install (logs below) - both complain around missing .SQL files and this error, and it borks out:

orld | QueryErr | QueryDatabaseMulti [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ADD COLUMN `seconds_before_idle` int(11) UNSIGNED NOT NULL DEFAULT 60 AFTER `...' at line 3] (1064) query [ALTER TABLE `zone`ADD COLUMN `idle_when_empty` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 AFTER `min_lava_damage`ADD COLUMN `seconds_before_idle` int(11) UNSIGNED NOT NULL DEFAULT 60 AFTER `idle_when_empty`]

Am I running into the case of using the 'bleeding edge' .. is there a way to pull down the earlier 'stable' versions? I'm perfectly happy with an older version, just wanting something as stable as possible... (and the install last week was stable with docker, but this week isn't).

Any suggestions appreciated.



[Zip] Extracting [/tmp/eqemu-server-linux-x64.zip]
[Zip] Extracted (10) files in [/tmp/eqemu-server-linux-x64.zip] to [/home/eqemu/server/bin]!
Starting server

> Bootstrapping PEQ Database

curl http://db.projecteq.net/api/v1/dump/latest -o /tmp/db.zip
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 30.2M 0 30.2M 0 0 4240k 0 --:--:-- 0:00:07 --:--:-- 5604k
unzip -o /tmp/db.zip -d /tmp/db/
Archive: /tmp/db.zip
inflating: /tmp/db/peq-dump/create_all_tables.sql
inflating: /tmp/db/peq-dump/create_tables_content.sql
inflating: /tmp/db/peq-dump/create_tables_login.sql
inflating: /tmp/db/peq-dump/create_tables_player.sql
inflating: /tmp/db/peq-dump/create_tables_queryserv.sql
inflating: /tmp/db/peq-dump/create_tables_state.sql
inflating: /tmp/db/peq-dump/create_tables_system.sql
inflating: /tmp/db/peq-dump/drop_all_tables.sql
inflating: /tmp/db/peq-dump/drop_tables_content.sql
inflating: /tmp/db/peq-dump/drop_tables_login.sql
inflating: /tmp/db/peq-dump/drop_tables_player.sql
inflating: /tmp/db/peq-dump/drop_tables_queryserv.sql
inflating: /tmp/db/peq-dump/drop_tables_state.sql
inflating: /tmp/db/peq-dump/drop_tables_system.sql
cd /tmp/db/peq-dump/ && mysql -ueqemu \
-pkwMVsuWS5172zDiBosbVwX2gZucik51 \
-h mariadb \
peq \
< ./create_all_tables.sql
rm -rf /tmp/db/
cd ~/server && ./bin/world database:updates
World | Info | CheckVersionsUpToDate ----------------------------------------------------------------------
World | Info | CheckVersionsUpToDate Server | database [9249] binary [9252] checking updates
World | Info | CheckVersionsUpToDate Config | [server.auto_database_updates] [true]
World | Info | CheckVersionsUpToDate ----------------------------------------------------------------------
World | Info | UpdateManifest [9250] [missing] | [2023_01_06_task_activities_list_group.sql]
World | Info | UpdateManifest [9251] [ok] | [2023_01_12_instance_list_notes.sql]
World | Info | UpdateManifest [9252] [missing] | [2024_01_07_zone_idle_when_empty.sql]
World | Info | UpdateManifest ----------------------------------------------------------------------
World | Info | UpdateManifest Automatically backing up database before applying updates
World | Info | UpdateManifest ----------------------------------------------------------------------
World | Info | DatabaseDump MySQL installed [mysql Ver 15.1 Distrib 10.11.4-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper]
World | Info | DatabaseDump Database [peq] Host [mariadb] Username [eqemu]
World | Info | DatabaseDump Backing up database [mysqldump --defaults-extra-file=login.my.cnf peq --allow-keywords --extended-insert --max-allowed-packet=1G --net-buffer-length=32704 --skip-lock-tables > backups/peq-2024-01-13.sql]
World | Info | DatabaseDump This can take a few minutes depending on the size of your database
World | Info | DatabaseDump LOADING... PLEASE WAIT...
World | Info | DatabaseDump Database dump created at [backups/peq-2024-01-13.sql]
World | Info | DatabaseDump Compression requested. Compressing dump [backups/peq-2024-01-13.sql]
World | Info | DatabaseDump Compressed dump created at [backups/peq-2024-01-13.tar.gz]
World | Info | UpdateManifest ----------------------------------------------------------------------
World | Info | UpdateManifest Running database migrations. Please wait...
World | Info | UpdateManifest ----------------------------------------------------------------------
World | Info | UpdateManifest [9250] [2023_01_06_task_activities_list_group.sql] [ok]
World | QueryErr | QueryDatabaseMulti [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ADD COLUMN `seconds_before_idle` int(11) UNSIGNED NOT NULL DEFAULT 60 AFTER `...' at line 3] (1064) query [ALTER TABLE `zone`ADD COLUMN `idle_when_empty` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 AFTER `min_lava_damage`ADD COLUMN `seconds_before_idle` int(11) UNSIGNED NOT NULL DEFAULT 60 AFTER `idle_when_empty`]
World | Error | UpdateManifest (#1064) [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ADD COLUMN `seconds_before_idle` int(11) UNSIGNED NOT NULL DEFAULT 60 AFTER `...' at line 3]
World | Info | UpdateManifest Required database update failed. This could be a problem
World | Info | UpdateManifest Would you like to skip this update? [y/n] (Timeout 60s)
World | Info | UpdateManifest [9252] [2024_01_07_zone_idle_when_empty.sql] [error]
World | Error | UpdateManifest Fatal | Database migration [2024_01_07_zone_idle_when_empty.sql] failed to run
World | Error | UpdateManifest Fatal | Shutting down
make[1]: *** [Makefile:114: init-peq-database] Error 1
make: *** [Makefile:66: install] Error 2
make: *** [Makefile:101: install] Error 2
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 02:36 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3