Table 'cms.version' doesn't exis

fsejoseph · July 25, 2018, 2:03pm

I wrote a yaml file to download Xibo onto my Docker Swarm. I figured out the other problems but what could this mean? I do not see this in any other problems listed on this website.

Waiting for MySQL to start - max 300 seconds
MySQL started
ERROR 1146 (42S02) at line 1: Table 'cms.version' doesn't exist
New install
Provisioning Database
ERROR 1050 (42S01) at line 419 in file: '/var/www/cms/install/master/structure.sql': Table 'lktagdisplaygroup' already exists
ERROR 1050 (42S01) at line 620 in file: '/var/www/cms/install/master/structure.sql': Table 'oauth_client_scopes' already exists
ERROR 1050 (42S01) at line 1123 in file: '/var/www/cms/install/master/structure.sql': Table 'daypart' already exists
ERROR 1050 (42S01) at line 1137 in file: '/var/www/cms/install/master/structure.sql': Table 'task' already exists
ERROR 1146 (42S02) at line 1 in file: '/var/www/cms/install/master/data.sql': Table 'cms.version' doesn't exist
ERROR 1146 (42S02) at line 4 in file: '/var/www/cms/install/master/data.sql': Table 'cms.group' doesn't exist
ERROR 1146 (42S02) at line 10 in file: '/var/www/cms/install/master/data.sql': Table 'cms.help' doesn't exist
ERROR 1146 (42S02) at line 93 in file: '/var/www/cms/install/master/data.sql': Table 'cms.module' doesn't exist
ERROR 1146 (42S02) at line 112 in file: '/var/www/cms/install/master/data.sql': Table 'cms.pages' doesn't exist
ERROR 1146 (42S02) at line 154 in file: '/var/www/cms/install/master/data.sql': Table 'cms.resolution' doesn't exist
ERROR 1146 (42S02) at line 164 in file: '/var/www/cms/install/master/data.sql': Table 'cms.setting' doesn't exist
ERROR 1146 (42S02) at line 243 in file: '/var/www/cms/install/master/data.sql': Table 'cms.usertype' doesn't exist
ERROR 1146 (42S02) at line 248 in file: '/var/www/cms/install/master/data.sql': Table 'cms.user' doesn't exist
ERROR 1146 (42S02) at line 251 in file: '/var/www/cms/install/master/data.sql': Table 'cms.lkusergroup' doesn't exist
ERROR 1146 (42S02) at line 254 in file: '/var/www/cms/install/master/data.sql': Table 'cms.transition' doesn't exist
ERROR 1146 (42S02) at line 259 in file: '/var/www/cms/install/master/data.sql': Table 'cms.datatype' doesn't exist
ERROR 1146 (42S02) at line 266 in file: '/var/www/cms/install/master/data.sql': Table 'cms.datasetcolumntype' doesn't exist
ERROR 1146 (42S02) at line 271 in file: '/var/www/cms/install/master/data.sql': Table 'cms.bandwidthtype' doesn't exist
ERROR 1146 (42S02) at line 285 in file: '/var/www/cms/install/master/data.sql': Table 'cms.tag' doesn't exist
ERROR 1146 (42S02) at line 290 in file: '/var/www/cms/install/master/data.sql': Table 'cms.displayprofile' doesn't exist
ERROR 1146 (42S02) at line 293 in file: '/var/www/cms/install/master/data.sql': Table 'cms.permissionentity' doesn't exist

ERROR 1146 (42S02) at line 305 in file: '/var/www/cms/install/master/data.sql': Table 'cms.oauth_scopes' doesn't exist

ERROR 1146 (42S02) at line 307 in file: '/var/www/cms/install/master/data.sql': Table 'cms.permission' doesn't exist

ERROR 1146 (42S02) at line 321 in file: '/var/www/cms/install/master/data.sql': Table 'cms.task' doesn't exist

ERROR 1146 (42S02) at line 331 in file: '/var/www/cms/install/master/data.sql': Table 'cms.daypart' doesn't exist

ERROR 1146 (42S02) at line 335 in file: '/var/www/cms/install/master/data.sql': Table 'cms.permission' doesn't exist

ERROR 1022 (23000) at line 4 in file: '/var/www/cms/install/master/constraints.sql': Can't write; duplicate key in table '#sql-1_a'

ERROR 1022 (23000) at line 11 in file: '/var/www/cms/install/master/constraints.sql': Can't write; duplicate key in table '#sql-1_a'

ERROR 1022 (23000) at line 17 in file: '/var/www/cms/install/master/constraints.sql': Can't write; duplicate key in table '#sql-1_a'

ERROR 1022 (23000) at line 23 in file: '/var/www/cms/install/master/constraints.sql': Can't write; duplicate key in table '#sql-1_a'

ERROR 1022 (23000) at line 30 in file: '/var/www/cms/install/master/constraints.sql': Can't write; duplicate key in table '#sql-1_a'

ERROR 1022 (23000) at line 38 in file: '/var/www/cms/install/master/constraints.sql': Can't write; duplicate key in table '#sql-1_a'

ERROR 1022 (23000) at line 46 in file: '/var/www/cms/install/master/constraints.sql': Can't write; duplicate key in table '#sql-1_a'

ERROR 1022 (23000) at line 52 in file: '/var/www/cms/install/master/constraints.sql': Can't write; duplicate key in table '#sql-1_a'

ERROR 1022 (23000) at line 59 in file: '/var/www/cms/install/master/constraints.sql': Can't write; duplicate key in table '#sql-1_a'

ERROR 1022 (23000) at line 65 in file: '/var/www/cms/install/master/constraints.sql': Can't write; duplicate key in table '#sql-1_a'

ERROR 1022 (23000) at line 72 in file: '/var/www/cms/install/master/constraints.sql': Can't write; duplicate key in table '#sql-1_a'

ERROR 1022 (23000) at line 78 in file: '/var/www/cms/install/master/constraints.sql': Can't write; duplicate key in table '#sql-1_a'

ERROR 1022 (23000) at line 84 in file: '/var/www/cms/install/master/constraints.sql': Can't write; duplicate key in table '#sql-1_a'

ERROR 1022 (23000) at line 91 in file: '/var/www/cms/install/master/constraints.sql': Can't write; duplicate key in table '#sql-1_a'

ERROR 1022 (23000) at line 97 in file: '/var/www/cms/install/master/constraints.sql': Can't write; duplicate key in table '#sql-1_a'

ERROR 1022 (23000) at line 103 in file: '/var/www/cms/install/master/constraints.sql': Can't write; duplicate key in table '#sql-1_a'

ERROR 1061 (42000) at line 107 in file: '/var/www/cms/install/master/constraints.sql': Duplicate key name 'lkwidgetaudio_widgetId_mediaId_uindex'

ERROR 1061 (42000) at line 109 in file: '/var/www/cms/install/master/constraints.sql': Duplicate key name 'oauth_client_scopes_clientId_scopeId_uindex'

ERROR 1022 (23000) at line 111 in file: '/var/www/cms/install/master/constraints.sql': Can't write; duplicate key in table '#sql-1_a'

ERROR 1022 (23000) at line 115 in file: '/var/www/cms/install/master/constraints.sql': Can't write; duplicate key in table '#sql-1_a'

ERROR 1061 (42000) at line 119 in file: '/var/www/cms/install/master/constraints.sql': Duplicate key name 'requiredfile_displayId_type_index'

ERROR 1061 (42000) at line 121 in file: '/var/www/cms/install/master/constraints.sql': Duplicate key name 'idx_lkregionplaylist_playlistId'

ERROR 1061 (42000) at line 123 in file: '/var/www/cms/install/master/constraints.sql': Duplicate key name 'lkdgdg_parentId_childId_depth_index'

ERROR 1061 (42000) at line 125 in file: '/var/www/cms/install/master/constraints.sql': Duplicate key name 'lkdgdg_childId_parentId_depth_index'

ERROR 1061 (42000) at line 127 in file: '/var/www/cms/install/master/constraints.sql': Duplicate key name 'media_editedMediaID_index'

Configuring Database Settings

ERROR 1146 (42S02) at line 1: Table 'cms.setting' doesn't exist

ERROR 1146 (42S02) at line 1: Table 'cms.user' doesn't exist

ERROR 1146 (42S02) at line 1: Table 'cms.setting' doesn't exist

Setting up Maintenance

Protected Maintenance

ERROR 1146 (42S02) at line 1: Table 'cms.setting' doesn't exist

Updating settings.php

Configuring Maintenance

Removing web/install/index.php from production container

Running maintenance

Starting cron

Starting webserver
AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using 10.0.6.162. Set the 'ServerName' directive globally to suppress this message`

fsejoseph · July 26, 2018, 1:03pm

So right now on the xibo db mysql container \shared\db\cms are not downloading into /var/lib/mysql/cms the only file being downloaded is db.opt the rest of the files are not. That is where I am right now

That was the problem to this issue. I had to download the files from \shared\db\cms to my computer and WinSCP into my EC2 Instance and transfer the files to /var/lib/mysql/cms. That solved the problem but now it cannot find the MYSQL_HOST.

fsejoseph · July 30, 2018, 1:46pm

Here is the logs from one of my containers. I am running Xibo in a Docker Swarm 2 replicas of cms_web, cms_db, cms_xmr. Now I have to figure out why it cannot find the MySQL Host
Waiting for MySQL to start - max 300 seconds

MySQL started

ERROR 2005 (HY000): Unknown MySQL server host 'local' (-2)

New install

Provisioning Database

ERROR 2005 (HY000): Unknown MySQL server host 'local' (-2)

ERROR 2005 (HY000): Unknown MySQL server host 'local' (-2)

ERROR 2005 (HY000): Unknown MySQL server host 'local' (-2)

Configuring Database Settings

ERROR 2005 (HY000): Unknown MySQL server host 'local' (-2)

ERROR 2005 (HY000): Unknown MySQL server host 'local' (-2)

ERROR 2005 (HY000): Unknown MySQL server host 'local' (-2)

ERROR 2005 (HY000): Unknown MySQL server host 'local' (-2)

ERROR 2005 (HY000): Unknown MySQL server host 'local' (-2)

ERROR 2005 (HY000): Unknown MySQL server host 'local' (-2)

Setting up Maintenance

Protected Maintenance

ERROR 2005 (HY000): Unknown MySQL server host 'local' (-2)

ERROR 2005 (HY000): Unknown MySQL server host 'local' (-2)

Updating settings.php

Configuring Maintenance

Removing web/install/index.php from production container

Running maintenance

Starting cron

Starting webserver

AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using 10.0.6.116. Set the 'ServerName' directive globally to suppress this message

alex · August 1, 2018, 12:26pm

You don’t have the correct configuration options passed to your containers, and your replica setup is broken. Please see my reply to your other post. Resolve those issues, and this will then work as expected.