Openunison Not writing to DATABASE on first sign in - Githubissues

OpenUnison / openunison-k8s-activedirectory

Self service portal for Kubernetes. Automate provisioning and access of namespaces, authenticate users using Active Directory or LDAP.

https://www.tremolosecurity.com/kubernetes/

Apache License 2.0

15 stars 6 forks source link

Openunison Not writing to DATABASE on first sign in #19

Open AntHanna23 opened 2 years ago

AntHanna23 commented 2 years ago

I am trying to get openunison up in minikube for an example.

minikube version: v1.13.1 commit: 1fd1f67f338cbab4b3e5a6e4c71c551f522ca138-dirty

kubernetes version: 1.20.1

I am deploying the operator and orchestra according to the instructions listed and I cannot access the dashboard. I receive this

The kubernetes tokens also do not work that are presented

I tried to Create an administrative user using the command under the Create First Administrator and got this:

ERROR 1146 (42S02): Table 'unison.userGroups' doesn't exist

The operator does create these databases and successfully connects to mysql:

+--------------------------+
| Tables_in_unison         |
+--------------------------+
| ACTIVEMQ_ACKS            |
| ACTIVEMQ_LOCK            |
| ACTIVEMQ_MSGS            |
| QRTZ_BLOB_TRIGGERS       |
| QRTZ_CALENDARS           |
| QRTZ_CRON_TRIGGERS       |
| QRTZ_FIRED_TRIGGERS      |
| QRTZ_JOB_DETAILS         |
| QRTZ_LOCKS               |
| QRTZ_PAUSED_TRIGGER_GRPS |
| QRTZ_SCHEDULER_STATE     |
| QRTZ_SIMPLE_TRIGGERS     |
| QRTZ_SIMPROP_TRIGGERS    |
| QRTZ_TRIGGERS            |
+--------------------------+

Operator logs:

\nDROP TABLE IF EXISTS QRTZ_PAUSED_TRIGGER_GRPS;\nDROP TABLE IF EXISTS QRTZ_SCHEDULER_STATE;\nDROP TABLE IF EXISTS QRTZ_LOCKS;\nDROP TABLE IF EXISTS QRTZ_SIMPLE_TRIGGERS;\nDROP TABLE IF EXISTS QRTZ_SIMPROP_TRIGGERS;\nDROP TABLE IF EXISTS QRTZ_CRON_TRIGGERS;\nDROP TABLE IF EXISTS QRTZ_BLOB_TRIGGERS;\nDROP TABLE IF EXISTS QRTZ_TRIGGERS;\nDROP TABLE IF EXISTS QRTZ_JOB_DETAILS;\nDROP TABLE IF EXISTS QRTZ_CALENDARS;\n\nCREATE TABLE QRTZ_JOB_DETAILS(\nSCHED_NAME VARCHAR(120) NOT NULL,\nJOB_NAME VARCHAR(200) NOT NULL,\nJOB_GROUP VARCHAR(200) NOT NULL,\nDESCRIPTION VARCHAR(250) NULL,\nJOB_CLASS_NAME VARCHAR(250) NOT NULL,\nIS_DURABLE BOOLEAN NOT NULL,\nIS_NONCONCURRENT BOOLEAN NOT NULL,\nIS_UPDATE_DATA BOOLEAN NOT NULL,\nREQUESTS_RECOVERY BOOLEAN NOT NULL,\nJOB_DATA BLOB NULL,\nPRIMARY KEY (SCHED_NAME,JOB_NAME,JOB_GROUP))\nENGINE=InnoDB;\n\nCREATE TABLE QRTZ_TRIGGERS (\nSCHED_NAME VARCHAR(120) NOT NULL,\nTRIGGER_NAME VARCHAR(200) NOT NULL,\nTRIGGER_GROUP VARCHAR(200) NOT NULL,\nJOB_NAME VARCHAR(200) NOT NULL,\nJOB_GROUP VARCHAR(200) NOT NULL,\nDESCRIPTION VARCHAR(250) NULL,\nNEXT_FIRE_TIME BIGINT(19) NULL,\nPREV_FIRE_TIME BIGINT(19) NULL,\nPRIORITY INTEGER NULL,\nTRIGGER_STATE VARCHAR(16) NOT NULL,\nTRIGGER_TYPE VARCHAR(8) NOT NULL,\nSTART_TIME BIGINT(19) NOT NULL,\nEND_TIME BIGINT(19) NULL,\nCALENDAR_NAME VARCHAR(200) NULL,\nMISFIRE_INSTR SMALLINT(2) NULL,\nJOB_DATA BLOB NULL,\nPRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),\nFOREIGN KEY (SCHED_NAME,JOB_NAME,JOB_GROUP)\nREFERENCES QRTZ_JOB_DETAILS(SCHED_NAME,JOB_NAME,JOB_GROUP))\nENGINE=InnoDB;\n\nCREATE TABLE QRTZ_SIMPLE_TRIGGERS (\nSCHED_NAME VARCHAR(120) NOT NULL,\nTRIGGER_NAME VARCHAR(200) NOT NULL,\nTRIGGER_GROUP VARCHAR(200) NOT NULL,\nREPEAT_COUNT BIGINT(7) NOT NULL,\nREPEAT_INTERVAL BIGINT(12) NOT NULL,\nTIMES_TRIGGERED BIGINT(10) NOT NULL,\nPRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),\nFOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)\nREFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP))\nENGINE=InnoDB;\n\nCREATE TABLE QRTZ_CRON_TRIGGERS (\nSCHED_NAME VARCHAR(120) NOT NULL,\nTRIGGER_NAME VARCHAR(200) NOT NULL,\nTRIGGER_GROUP VARCHAR(200) NOT NULL,\nCRON_EXPRESSION VARCHAR(120) NOT NULL,\nTIME_ZONE_ID VARCHAR(80),\nPRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),\nFOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)\nREFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP))\nENGINE=InnoDB;\n\nCREATE TABLE QRTZ_SIMPROP_TRIGGERS\n ( \n SCHED_NAME VARCHAR(120) NOT NULL,\n TRIGGER_NAME VARCHAR(200) NOT NULL,\n TRIGGER_GROUP VARCHAR(200) NOT NULL,\n STR_PROP_1 VARCHAR(512) NULL,\n STR_PROP_2 VARCHAR(512) NULL,\n STR_PROP_3 VARCHAR(512) NULL,\n INT_PROP_1 INT NULL,\n INT_PROP_2 INT NULL,\n LONG_PROP_1 BIGINT NULL,\n LONG_PROP_2 BIGINT NULL,\n DEC_PROP_1 NUMERIC(13,4) NULL,\n DEC_PROP_2 NUMERIC(13,4) NULL,\n BOOL_PROP_1 BOOLEAN NULL,\n BOOL_PROP_2 BOOLEAN NULL,\n TIME_ZONE_ID VARCHAR(80) NULL,\n PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),\n FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP) \n REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP))\nENGINE=InnoDB;\n\nCREATE TABLE QRTZ_BLOB_TRIGGERS (\nSCHED_NAME VARCHAR(120) NOT NULL,\nTRIGGER_NAME VARCHAR(200) NOT NULL,\nTRIGGER_GROUP VARCHAR(200) NOT NULL,\nBLOB_DATA BLOB NULL,\nPRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),\nINDEX (SCHED_NAME,TRIGGER_NAME, TRIGGER_GROUP),\nFOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)\nREFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP))\nENGINE=InnoDB;\n\nCREATE TABLE QRTZ_CALENDARS (\nSCHED_NAME VARCHAR(120) NOT NULL,\nCALENDAR_NAME VARCHAR(200) NOT NULL,\nCALENDAR BLOB NOT NULL,\nPRIMARY KEY (SCHED_NAME,CALENDAR_NAME))\nENGINE=InnoDB;\n\nCREATE TABLE QRTZ_PAUSED_TRIGGER_GRPS (\nSCHED_NAME VARCHAR(120) NOT NULL,\nTRIGGER_GROUP VARCHAR(200) NOT NULL,\nPRIMARY KEY (SCHED_NAME,TRIGGER_GROUP))\nENGINE=InnoDB;\n\nCREATE TABLE QRTZ_FIRED_TRIGGERS (\nSCHED_NAME VARCHAR(120) NOT NULL,\nENTRY_ID VARCHAR(140) NOT NULL,\nTRIGGER_NAME VARCHAR(200) NOT NULL,\nTRIGGER_GROUP VARCHAR(200) NOT NULL,\nINSTANCE_NAME VARCHAR(200) NOT NULL,\nFIRED_TIME BIGINT(19) NOT NULL,\nSCHED_TIME BIGINT(19) NOT NULL,\nPRIORITY INTEGER NOT NULL,\nSTATE VARCHAR(16) NOT NULL,\nJOB_NAME VARCHAR(200) NULL,\nJOB_GROUP VARCHAR(200) NULL,\nIS_NONCONCURRENT BOOLEAN NULL,\nREQUESTS_RECOVERY BOOLEAN NULL,\nPRIMARY KEY (SCHED_NAME,ENTRY_ID))\nENGINE=InnoDB;\n\nCREATE TABLE QRTZ_SCHEDULER_STATE (\nSCHED_NAME VARCHAR(120) NOT NULL,\nINSTANCE_NAME VARCHAR(200) NOT NULL,\nLAST_CHECKIN_TIME BIGINT(19) NOT NULL,\nCHECKIN_INTERVAL BIGINT(19) NOT NULL,\nPRIMARY KEY (SCHED_NAME,INSTANCE_NAME))\nENGINE=InnoDB;\n\nCREATE TABLE QRTZ_LOCKS (\nSCHED_NAME VARCHAR(120) NOT NULL,\nLOCK_NAME VARCHAR(40) NOT NULL,\nPRIMARY KEY (SCHED_NAME,LOCK_NAME))\nENGINE=InnoDB;\n\nCREATE INDEX IDX_QRTZ_J_REQ_RECOVERY ON QRTZ_JOB_DETAILS(SCHED_NAME,REQUESTS_RECOVERY);\nCREATE INDEX IDX_QRTZ_J_GRP ON QRTZ_JOB_DETAILS(SCHED_NAME,JOB_GROUP);\n\nCREATE INDEX IDX_QRTZ_T_J ON QRTZ_TRIGGERS(SCHED_NAME,JOB_NAME,JOB_GROUP);\nCREATE INDEX IDX_QRTZ_T_JG ON QRTZ_TRIGGERS(SCHED_NAME,JOB_GROUP);\nCREATE INDEX IDX_QRTZ_T_C ON QRTZ_TRIGGERS(SCHED_NAME,CALENDAR_NAME);\nCREATE INDEX IDX_QRTZ_T_G ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_GROUP);\nCREATE INDEX IDX_QRTZ_T_STATE ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_STATE);\nCREATE INDEX IDX_QRTZ_T_N_STATE ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_STATE);\nCREATE INDEX IDX_QRTZ_T_N_G_STATE ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_GROUP,TRIGGER_STATE);\nCREATE INDEX IDX_QRTZ_T_NEXT_FIRE_TIME ON QRTZ_TRIGGERS(SCHED_NAME,NEXT_FIRE_TIME);\nCREATE INDEX IDX_QRTZ_T_NFT_ST ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_STATE,NEXT_FIRE_TIME);\nCREATE INDEX IDX_QRTZ_T_NFT_MISFIRE ON QRTZ_TRIGGERS(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME);\nCREATE INDEX IDX_QRTZ_T_NFT_ST_MISFIRE ON QRTZ_TRIGGERS(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME,TRIGGER_STATE);\nCREATE INDEX IDX_QRTZ_T_NFT_ST_MISFIRE_GRP ON QRTZ_TRIGGERS(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME,TRIGGER_GROUP,TRIGGER_STATE);\n\nCREATE INDEX IDX_QRTZ_FT_TRIG_INST_NAME ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,INSTANCE_NAME);\nCREATE INDEX IDX_QRTZ_FT_INST_JOB_REQ_RCVRY ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,INSTANCE_NAME,REQUESTS_RECOVERY);\nCREATE INDEX IDX_QRTZ_FT_J_G ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,JOB_NAME,JOB_GROUP);\nCREATE INDEX IDX_QRTZ_FT_JG ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,JOB_GROUP);\nCREATE INDEX IDX_QRTZ_FT_T_G ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP);\nCREATE INDEX IDX_QRTZ_FT_TG ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,TRIGGER_GROUP);\n\nDROP TABLE IF EXISTS ACTIVEMQ_ACKS;\nDROP TABLE IF EXISTS ACTIVEMQ_LOCK;\nDROP TABLE IF EXISTS ACTIVEMQ_MSGS;\n\n\nCREATE TABLE ACTIVEMQ_ACKS (\n CONTAINER varchar(250) NOT NULL,\n SUB_DEST varchar(250) DEFAULT NULL,\n CLIENT_ID varchar(250) NOT NULL,\n SUB_NAME varchar(250) NOT NULL,\n SELECTOR varchar(250) DEFAULT NULL,\n LAST_ACKED_ID bigint(20) DEFAULT NULL,\n PRIORITY bigint(20) NOT NULL DEFAULT '5',\n XID varchar(250) DEFAULT NULL,\n PRIMARY KEY (CONTAINER,CLIENT_ID,SUB_NAME,PRIORITY),\n KEY ACTIVEMQ_ACKS_XIDX (XID)\n);\n\nCREATE TABLE ACTIVEMQ_LOCK (\n ID bigint(20) NOT NULL,\n TIME bigint(20) DEFAULT NULL,\n BROKER_NAME varchar(250) DEFAULT NULL,\n PRIMARY KEY (ID)\n);\n\nCREATE TABLE ACTIVEMQ_MSGS (\n ID bigint(20) NOT NULL,\n CONTAINER varchar(250) NOT NULL,\n MSGID_PROD varchar(250) DEFAULT NULL,\n MSGID_SEQ bigint(20) DEFAULT NULL,\n EXPIRATION bigint(20) DEFAULT NULL,\n MSG mediumblob,\n PRIORITY bigint(20) DEFAULT NULL,\n XID varchar(250) DEFAULT NULL,\n PRIMARY KEY (ID),\n KEY ACTIVEMQ_MSGS_MIDX (MSGID_PROD,MSGID_SEQ),\n KEY ACTIVEMQ_MSGS_CIDX (CONTAINER),\n KEY ACTIVEMQ_MSGS_EIDX (EXPIRATION),\n KEY ACTIVEMQ_MSGS_PIDX (PRIORITY),\n KEY ACTIVEMQ_MSGS_XIDX (XID)\n);\ncommit;","secret_data":["AD_BIND_PASSWORD","K8S_DB_SECRET","unisonKeystorePassword","SMTP_PASSWORD","OU_JDBC_PASSWORD"],"source_secret":"orchestra-secrets-source"},"status":{"conditions":{"lastTransitionTime":"2021-08-19 06:23:40GMT","status":"True","type":"Completed"},"digest":"3m4gYOmrrmGBp3qOgT0sRBSfNN4g8/W9WfD7n/soRZk="}} } No change, skipping https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200 https://10.96.0.1:443/apis/openunison.tremolo.io/v5/namespaces/openunison/openunisons?watch=true&timeoutSeconds=30&resourceVersion=20200

mlbiam commented 2 years ago

what do the logs in the openunison-orchestra pod say? That's the pod that will generate these messages

AntHanna23 commented 2 years ago

I solved the issue with the dashboard but the database not writing out the first user still persist. I log in and it shows a successful login in the orchestra logs but nothing is written to the database

AntHanna23 commented 2 years ago

mysql> show tables;
+--------------------------+
| Tables_in_unison         |
+--------------------------+
| ACTIVEMQ_ACKS            |
| ACTIVEMQ_LOCK            |
| ACTIVEMQ_MSGS            |
| QRTZ_BLOB_TRIGGERS       |
| QRTZ_CALENDARS           |
| QRTZ_CRON_TRIGGERS       |
| QRTZ_FIRED_TRIGGERS      |
| QRTZ_JOB_DETAILS         |
| QRTZ_LOCKS               |
| QRTZ_PAUSED_TRIGGER_GRPS |
| QRTZ_SCHEDULER_STATE     |
| QRTZ_SIMPLE_TRIGGERS     |
| QRTZ_SIMPROP_TRIGGERS    |
| QRTZ_TRIGGERS            |
+--------------------------+
14 rows in set (0.00 sec)

Still only these tables are being created after a successful login. I can access the dashboard and kubernetes tokens successfully but cannot make the first approver

mlbiam commented 2 years ago

that's odd. there should be a bunch of other tables. The operator uses the same config and drivers as the openunison pod.

That said, we're getting ready to release a new version of this system that is much more felxible and easier to deploy. Are you willing to help test it?

AntHanna23 commented 2 years ago

Yes, we would be willing to help test