search

ansibleguy76 / ansibleforms

A webapplication to create pretty advanced forms to run ansible playbooks or awx templates.
https://ansibleforms.com/
GNU General Public License v3.0
66 stars 10 forks source link

MySql Tables are not being created #206

Closed ansibleguy76 closed 3 weeks ago

ansibleguy76 commented 3 weeks ago

Discussed in https://github.com/ansibleguy76/ansibleforms/discussions/198

Originally posted by **andycampbell69** August 8, 2024 After the myslq & server nodes are running, I get a this following error "It appears that you have an unuseable schema. Part of the database is present, and part is missing." when I navigate to the WebUI. This what I see in the Logs. 2024-08-08T20:40:36.475780863+08:00 stdout F 2024-08-08 12:40:36:4036 ^[[32minfo: Waiting for mysql to start^[[0m 2024-08-08T20:40:36.515481742+08:00 stdout F 2024-08-08 12:40:36:4036 ^[[37mnotice: Serving static files from /app/dist/views^[[0m 2024-08-08T20:40:36.517704459+08:00 stdout F 2024-08-08 12:40:36:4036 ^[[37mnotice: Exposing app under /^[[0m 2024-08-08T20:40:36.519758855+08:00 stdout F 2024-08-08 12:40:36:4036 ^[[37mnotice: Running https !^[[0m 2024-08-08T20:40:36.591367856+08:00 stdout F 2024-08-08 12:40:36:4036 ^[[37mnotice: App running on port 8443!^[[0m 2024-08-08T20:40:36.696603177+08:00 stdout F 2024-08-08 12:40:36:4036 ^[[32minfo: Mysql is ready^[[0m 2024-08-08T20:40:36.699845633+08:00 stdout F 2024-08-08 12:40:36:4036 ^[[36mdebug: checking schema AnsibleForms^[[0m 2024-08-08T20:40:36.720199577+08:00 stdout F 2024-08-08 12:40:36:4036 ^[[36mdebug: Schema 'AnsibleForms' is present^[[0m 2024-08-08T20:40:36.722535443+08:00 stdout F 2024-08-08 12:40:36:4036 ^[[36mdebug: checking table credentials^[[0m 2024-08-08T20:40:36.734933917+08:00 stdout F 2024-08-08 12:40:36:4036 warning: Table 'credentials' is not present^[[0m 2024-08-08T20:40:36.757161542+08:00 stdout F 2024-08-08 12:40:36:4036 ^[[36mdebug: checking table groups^[[0m 2024-08-08T20:40:36.765647444+08:00 stdout F 2024-08-08 12:40:36:4036 warning: Table 'groups' is not present^[[0m 2024-08-08T20:40:36.767114077+08:00 stdout F 2024-08-08 12:40:36:4036 ^[[36mdebug: checking table job_output^[[0m 2024-08-08T20:40:36.77519258+08:00 stdout F 2024-08-08 12:40:36:4036 warning: Table 'job_output' is not present^[[0m 2024-08-08T20:40:36.777150777+08:00 stdout F 2024-08-08 12:40:36:4036 ^[[36mdebug: checking table jobs^[[0m 2024-08-08T20:40:36.784346019+08:00 stdout F 2024-08-08 12:40:36:4036 warning: Table 'jobs' is not present^[[0m 2024-08-08T20:40:36.78524789+08:00 stdout F 2024-08-08 12:40:36:4036 ^[[36mdebug: checking table ldap^[[0m 2024-08-08T20:40:36.793984143+08:00 stdout F 2024-08-08 12:40:36:4036 warning: Table 'ldap' is not present^[[0m 2024-08-08T20:40:36.795276404+08:00 stdout F 2024-08-08 12:40:36:4036 ^[[36mdebug: checking table tokens^[[0m 2024-08-08T20:40:36.801650356+08:00 stdout F 2024-08-08 12:40:36:4036 warning: Table 'tokens' is not present^[[0m 2024-08-08T20:40:36.802894613+08:00 stdout F 2024-08-08 12:40:36:4036 ^[[36mdebug: checking table users^[[0m 2024-08-08T20:40:36.811938664+08:00 stdout F 2024-08-08 12:40:36:4036 warning: Table 'users' is not present^[[0m 2024-08-08T20:40:36.813117237+08:00 stdout F 2024-08-08 12:40:36:4036 ^[[36mdebug: checking table awx^[[0m 2024-08-08T20:40:36.819999751+08:00 stdout F 2024-08-08 12:40:36:4036 warning: Table 'awx' is not present^[[0m 2024-08-08T20:40:36.854622297+08:00 stdout F 2024-08-08 12:40:36:4036 ^[[32minfo: Schema 'AnsibleForms' is present^[[0m 2024-08-08T20:40:36.85584098+08:00 stdout F 2024-08-08 12:40:36:4036 ^[[32minfo: undefined^[[0m 2024-08-08T20:40:36.856697851+08:00 stdout F 2024-08-08 12:40:36:4036 ^[[31merror: Table 'credentials' is not present^[[0m 2024-08-08T20:40:36.858599282+08:00 stdout F 2024-08-08 12:40:36:4036 ^[[31merror: Table 'groups' is not present^[[0m 2024-08-08T20:40:36.859453221+08:00 stdout F 2024-08-08 12:40:36:4036 ^[[31merror: Table 'job_output' is not present^[[0m 2024-08-08T20:40:36.860333741+08:00 stdout F 2024-08-08 12:40:36:4036 ^[[31merror: Table 'jobs' is not present^[[0m 2024-08-08T20:40:36.862309135+08:00 stdout F 2024-08-08 12:40:36:4036 ^[[31merror: Table 'ldap' is not present^[[0m 2024-08-08T20:40:36.863068671+08:00 stdout F 2024-08-08 12:40:36:4036 ^[[31merror: Table 'tokens' is not present^[[0m 2024-08-08T20:40:36.863941669+08:00 stdout F 2024-08-08 12:40:36:4036 ^[[31merror: Table 'users' is not present^[[0m 2024-08-08T20:40:36.864776391+08:00 stdout F 2024-08-08 12:40:36:4036 ^[[31merror: Table 'awx' is not present^[[0m 2024-08-08T20:40:36.8670758+08:00 stdout F 2024-08-08 12:40:36:4036 ^[[36mdebug: checking availability: /root/.ssh/id_rsa^[[0m 2024-08-08T20:40:36.86890343+08:00 stdout F 2024-08-08 12:40:36:4036 ^[[32minfo: Moving older form backups to new backup folder^[[0m 2024-08-08T20:40:36.872971237+08:00 stdout F 2024-08-08 12:40:36:4036 ^[[37mnotice: Abandoning jobs^[[0m 2024-08-08T20:40:36.875617219+08:00 stdout F 2024-08-08 12:40:36:4036 ^[[32minfo: Initializing hourly abandoned jobs timer^[[0m 2024-08-08T20:40:36.876666139+08:00 stdout F 2024-08-08 12:40:36:4036 ^[[32minfo: Pulling repositories^[[0m On a side note, The server pod fail to deploy unless execute permissions 774 are set on the ./data & ./data/mysql/init/ directories. Any Ideas?
ansibleguy76 commented 3 weeks ago

is fixed in 5.0.4.