Skip to content

Cannot deploy latest 3.14.0 as a fresh install because of alembic migration issue #634

@zentavr

Description

@zentavr

My Settings file:

    # THIS IS THE SETTINGS FILE THAT IS MOUNTED BY K8S INSIDE THE DOCKER CONTAINER.
    # API Keys
    api_keys = ["111", "222", "333"]

    # Database Settings
    sql_dialect = "mysql"
    sql_database = "bitnami_rtb"
    botnet_db  = "/app/database/botnet.db"
    sql_host = "mysql-mariadb"
    sql_port = "3306"
    sql_user = "bn_rtb"
    sql_password = "zxcvbn"

    # Memcached setup
    memcached = 'rtb-memcached.root-the-box.svc.cluster.local:11211'

    # Game Settings
    game_name = "Game of the Thrones"
    org_footer = "RS"
    global_notification = True
    max_team_size = 20
    max_flag_attempts = 50
    x_headers = True

    # Registration
    restrict_registration = False
    require_email = True
    validate_email = False
    public_teams = True
    #add_admin = []

Do the provision like:

python3 /app/rootthebox.py --setup=prod --config=/app/settings.cfg

...it's weird, but it always wants sqlite3 for bots even if i use MySQL. Also it dies because cannot create .db file (touch ... helps here). After I entered the admin username and password, try to run:

python3 /app/rootthebox.py --start --config=/app/settings.cfg

And it fails to run Alembic Migrations:

│ [I 250107 05:56:55 rootthebox:260] Environment Configuration (SQL_DIALECT): mysql                                                                                                                                                                                
│ [I 250107 05:56:55 rootthebox:260] Environment Configuration (SQL_DIALECT): mysql                                                                                                                                                                                
│ [I 250107 05:56:56 __init__:267] Checking for Database Updates...                                                                                                                                                                                               
│ [I 250107 05:56:56 migration:207] Context impl MySQLImpl.                                                                                                                                                                                                        
│ [I 250107 05:56:56 migration:210] Will assume non-transactional DDL.                                                                                                                                                                                             
│ [I 250107 05:56:56 migration:618] Running upgrade 469f428604aa -> 5ca019edf61f, Cascade on Delete                                                                                                                                                                
│ [E 250107 05:56:56 rootthebox:54] Error: (MySQLdb.ProgrammingError) (1146, "Table 'bitnami_rtb.snapshot_team' doesn't exist")                                                                                                                                    │
│     [SQL: ALTER TABLE snapshot_team DROP FOREIGN KEY snapshot_team_ibfk_1]                                                                                                                                                                                       
│     (Background on this error at: https://sqlalche.me/e/14/f405)

The table snapshot_team not exist.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions