I am trying to pull and download Invoice Ninja, I am new to this, and I think that I did everything correct, it looks like that it can connect to the database correctly. The logs in the app seem like its all OK, it created database tables, and nothing seems to be pointing out to me that it should not be working, but I can’t connect to the application. Any idea what I am doing wrong?
docker run --rm -it invoiceninja/invoiceninja php artisan key:generate --show
docker volume create mycompany-ninja-pub
docker volume create mycompany-ninja-storage
docker volume create mycompany-ninja-db
docker network create mycompany-ninja-mysqlnet
docker run -d \
--name mycompany-ninja-db \
-e MYSQL_ROOT_PASSWORD=ninja \
-e MYSQL_DATABASE=ninja \
-e MYSQL_USER=ninja \
-e MYSQL_PASSWORD=ninja \
-v mycompany-ninja-db:/var/lib/mysql \
--net=mycompany-ninja-mysqlnet \
--restart=always \
mysql:5.7
docker run -d \
-v mycompany-ninja-pub:/var/app/public \
-v mycompany-ninja-storage:/var/app/storage \
-e APP_ENV='production' \
-e APP_DEBUG=0 \
-e APP_URL='http://192.168.160.121' \
-e APP_KEY='DwXC0UU6CHxCItfUut8u2HwU+XQiD/0xEdVY1dxH9fY=' \
-e APP_CIPHER='AES-256-CBC' \
-e DB_TYPE='mysql' \
-e DB_STRICT='false' \
-e DB_HOST=mycompany-ninja-db \
-e DB_DATABASE='ninja' \
-e DB_USERNAME='ninja' \
-e DB_PASSWORD='ninja' \
-p '46592:9000' \
-p '46593:80' \
--net=mycompany-ninja-mysqlnet \
--restart=always \
--name 'mycompany-ninja' \
invoiceninja/invoiceninja
Here are my logs.
Initialising Laravel...,
Configuration cache cleared!,
Configuration cached successfully!,
Configuration cache cleared!,
Configuration cached successfully!,
Route cache cleared!,
Routes cached successfully!,
les cached successfully!,
Migration table created successfully.,
Migrating: 2014_10_12_100000_create_password_resets_table,
Migrated: 2014_10_12_100000_create_password_resets_table (1,078.12ms),
Migrating: 2014_10_13_000000_create_users_table,
Migrated: 2014_10_13_000000_create_users_table (70,799.09ms),
Migrating: 2019_11_10_115926_create_failed_jobs_table,
Migrated: 2019_11_10_115926_create_failed_jobs_table (180.43ms),
Migrating: 2020_03_05_123315_create_jobs_table,
Migrated: 2020_03_05_123315_create_jobs_table (364.34ms),
Migrating: 2020_04_08_234530_add_is_deleted_column_to_company_tokens_table,
Migrated: 2020_04_08_234530_add_is_deleted_column_to_company_tokens_table (1,233.28ms),
Migrating: 2020_05_13_035355_add_google_refresh_token_to_users_table,
Migrated: 2020_05_13_035355_add_google_refresh_token_to_users_table (1,233.47ms),
Migrating: 2020_07_05_084934_company_too_large_attribute,
Migrated: 2020_07_05_084934_company_too_large_attribute (975.77ms),
Migrating: 2020_07_08_065301_add_token_id_to_activity_table,
Migrated: 2020_07_08_065301_add_token_id_to_activity_table (1,109.62ms),
Migrating: 2020_07_21_112424_update_enabled_modules_value,
Migrated: 2020_07_21_112424_update_enabled_modules_value (6.72ms),
Migrating: 2020_07_28_104218_shop_token,
Migrated: 2020_07_28_104218_shop_token (416.78ms),
Migrating: 2020_08_04_080851_add_is_deleted_to_group_settings,
Migrated: 2020_08_04_080851_add_is_deleted_to_group_settings (309.50ms),
Migrating: 2020_08_11_221627_add_is_deleted_flag_to_client_gateway_token_table,
Migrated: 2020_08_11_221627_add_is_deleted_flag_to_client_gateway_token_table (300.84ms),
Migrating: 2020_08_13_095946_remove_photo_design,
Migrated: 2020_08_13_095946_remove_photo_design (2.71ms),
Migrating: 2020_08_13_212702_add_reminder_sent_fields_to_entity_tables,
Migrated: 2020_08_13_212702_add_reminder_sent_fields_to_entity_tables (1,849.00ms),
Migrating: 2020_08_18_140557_add_is_public_to_documents_table,
Migrated: 2020_08_18_140557_add_is_public_to_documents_table (7,584.29ms),
Migrating: 2020_09_22_205113_id_number_fields_for_missing_entities,
Migrated: 2020_09_22_205113_id_number_fields_for_missing_entities (2,284.98ms),
Migrating: 2020_09_27_215800_update_gateway_table_visible_column,
Migrated: 2020_09_27_215800_update_gateway_table_visible_column (1,910.48ms),
Migrating: 2020_10_11_211122_vendor_schema_update,
Migrated: 2020_10_11_211122_vendor_schema_update (876.04ms),
Migrating: 2020_10_12_204517_project_number_column,
Migrated: 2020_10_12_204517_project_number_column (1,023.05ms),
Migrating: 2020_10_14_201320_project_ids_to_entities,
Migrated: 2020_10_14_201320_project_ids_to_entities (1,192.65ms),
Migrating: 2020_10_19_101823_project_name_unique_removal,
Migrated: 2020_10_19_101823_project_name_unique_removal (3,041.39ms),
Migrating: 2020_10_21_222738_expenses_nullable_assigned_user,
Migrated: 2020_10_21_222738_expenses_nullable_assigned_user (525.60ms),
Migrating: 2020_10_22_204900_company_table_fields,
Migrated: 2020_10_22_204900_company_table_fields (1,409.15ms),
Migrating: 2020_10_27_021751_tasks_invoice_documents,
Migrated: 2020_10_27_021751_tasks_invoice_documents (2,069.03ms),
Migrating: 2020_10_28_224711_status_sort_order,
Migrated: 2020_10_28_224711_status_sort_order (51.13ms),
Migrating: 2020_10_28_225022_assigned_user_tasks_table,
Migrated: 2020_10_28_225022_assigned_user_tasks_table (428.94ms),
Migrating: 2020_10_29_001541_vendors_phone_column,
Migrated: 2020_10_29_001541_vendors_phone_column (50.32ms),
Migrating: 2020_10_29_093836_change_start_time_column_type,
Migrated: 2020_10_29_093836_change_start_time_column_type (555.58ms),
Migrating: 2020_10_29_204434_tasks_table_project_nullable,
Migrated: 2020_10_29_204434_tasks_table_project_nullable (400.58ms),
Migrating: 2020_10_29_210402_change_default_show_tasks_table,
Migrated: 2020_10_29_210402_change_default_show_tasks_table (34.11ms),
Migrating: 2020_10_30_084139_change_expense_currency_id_column,
Migrated: 2020_10_30_084139_change_expense_currency_id_column (346.01ms),
Migrating: 2020_11_01_031750_drop_migrating_column,
Migrated: 2020_11_01_031750_drop_migrating_column (337.95ms),
Migrating: 2020_11_03_200345_company_gateway_fields_refactor,
Migrated: 2020_11_03_200345_company_gateway_fields_refactor (375.90ms),
Migrating: 2020_11_08_212050_custom_fields_for_payments_table,
Migrated: 2020_11_08_212050_custom_fields_for_payments_table (442.63ms),
Migrating: 2020_11_12_104413_company_gateway_rename_column,
Migrated: 2020_11_12_104413_company_gateway_rename_column (50.24ms),
Migrating: 2020_11_15_203755_soft_delete_paymentables,
Migrated: 2020_11_15_203755_soft_delete_paymentables (284.12ms),
Migrating: 2020_12_14_114722_task_fields,
Migrated: 2020_12_14_114722_task_fields (777.91ms),
Migrating: 2020_12_17_104033_add_enable_product_discount_field_to_companies_table,
Migrated: 2020_12_17_104033_add_enable_product_discount_field_to_companies_table (327.31ms),
Migrating: 2020_12_20_005609_change_products_table_cost_resolution,
Migrated: 2020_12_20_005609_change_products_table_cost_resolution (408.56ms),
Migrating: 2020_12_23_220648_remove_null_values_in_countries_table,
Migrated: 2020_12_23_220648_remove_null_values_in_countries_table (1.58ms),
Migrating: 2021_01_03_215053_update_canadian_dollar_symbol,
Migrated: 2021_01_03_215053_update_canadian_dollar_symbol (19.68ms),
Migrating: 2021_01_05_013203_improve_decimal_resolution,
Migrated: 2021_01_05_013203_improve_decimal_resolution (10,442.94ms),
Migrating: 2021_01_07_023350_update_singapore_dollar_symbol,
Migrated: 2021_01_07_023350_update_singapore_dollar_symbol (15.36ms),
Migrating: 2021_01_08_093324_expenses_table_additional_fields,
Migrated: 2021_01_08_093324_expenses_table_additional_fields (883.69ms),
Migrating: 2021_01_11_092056_fix_company_settings_url,
Migrated: 2021_01_11_092056_fix_company_settings_url (2,551.32ms),
Migrating: 2021_01_17_040331_change_custom_surcharge_column_type,
Migrated: 2021_01_17_040331_change_custom_surcharge_column_type (2,276.86ms),
Migrating: 2021_01_23_044502_scheduler_is_running_check,
Migrated: 2021_01_23_044502_scheduler_is_running_check (208.82ms),
Migrating: 2021_01_24_052645_add_paid_to_date_column,
Migrated: 2021_01_24_052645_add_paid_to_date_column (1,588.72ms),
Migrating: 2021_01_25_095351_add_number_field_to_clients_and_vendors,
Migrated: 2021_01_25_095351_add_number_field_to_clients_and_vendors (1,245.82ms),
Migrating: 2021_01_29_121502_add_permission_changed_timestamp,
Migrated: 2021_01_29_121502_add_permission_changed_timestamp (311.34ms),
Migrating: 2021_02_15_214724_additional_company_properties,
Migrated: 2021_02_15_214724_additional_company_properties (348.46ms),
Migrating: 2021_02_19_212722_email_last_confirmed_email_address_users_table,
Migrated: 2021_02_19_212722_email_last_confirmed_email_address_users_table (343.86ms),
Migrating: 2021_02_25_205901_enum_invitations_email_status,
Migrated: 2021_02_25_205901_enum_invitations_email_status (1,910.99ms),
Migrating: 2021_02_27_091713_add_invoice_task_datelog_property,
Migrated: 2021_02_27_091713_add_invoice_task_datelog_property (492.48ms),
Migrating: 2021_03_03_230941_add_has_password_field_to_user_table,
Migrated: 2021_03_03_230941_add_has_password_field_to_user_table (384.04ms),
Migrating: 2021_03_08_123729_create_billing_subscriptions_table,
Migrated: 2021_03_08_123729_create_billing_subscriptions_table (3,012.75ms),
Migrating: 2021_03_08_205030_add_russian_lang,
Migrated: 2021_03_08_205030_add_russian_lang (372.89ms),
Migrating: 2021_03_09_132242_add_currency_id_to_billing_subscriptions_table,
Migrated: 2021_03_09_132242_add_currency_id_to_billing_subscriptions_table (1,517.14ms),
Migrating: 2021_03_18_113704_change_2fa_column_from_varchar_to_text,
Migrated: 2021_03_18_113704_change_2fa_column_from_varchar_to_text (566.33ms),
Migrating: 2021_03_19_221024_add_unique_constraints_on_all_entities,
Migrated: 2021_03_19_221024_add_unique_constraints_on_all_entities (0.03ms),
Migrating: 2021_03_20_033751_add_invoice_id_to_client_subscriptions_table,
Migrated: 2021_03_20_033751_add_invoice_id_to_client_subscriptions_table (899.84ms),
Migrating: 2021_03_23_233844_add_nullable_constraint_to_recurring_invoice_id,
Migrated: 2021_03_23_233844_add_nullable_constraint_to_recurring_invoice_id (367.95ms),
Migrating: 2021_03_25_082025_refactor_billing_scriptions_table,
Migrated: 2021_03_25_082025_refactor_billing_scriptions_table (1,593.95ms),
Migrating: 2021_03_26_201148_add_price_column_to_subscriptions_table,
Migrated: 2021_03_26_201148_add_price_column_to_subscriptions_table (1,600.49ms),
Migrating: 2021_04_01_093128_modify_column_on_subscriptions_table,
Migrated: 2021_04_01_093128_modify_column_on_subscriptions_table (475.89ms),
Migrating: 2021_04_05_115345_add_trial_duration_to_accounts_table,
Migrated: 2021_04_05_115345_add_trial_duration_to_accounts_table (325.30ms),
Migrating: 2021_04_05_213802_add_rest_fields_to_webhooks_table,
Migrated: 2021_04_05_213802_add_rest_fields_to_webhooks_table (278.12ms),
Migrating: 2021_04_06_131028_create_licenses_table,
Migrated: 2021_04_06_131028_create_licenses_table (258.38ms),
Migrating: 2021_04_12_095424_stripe_connect_gateway,
Migrated: 2021_04_12_095424_stripe_connect_gateway (16.73ms),
Migrating: 2021_04_13_013424_add_subscription_id_to_activities_table,
Migrated: 2021_04_13_013424_add_subscription_id_to_activities_table (482.82ms),
Migrating: 2021_04_22_110240_add_property_to_checkout_gateway_config,
Migrated: 2021_04_22_110240_add_property_to_checkout_gateway_config (1.52ms),
Migrating: 2021_04_25_115919_update_designs,
Migrated: 2021_04_25_115919_update_designs (2.09ms),
Migrating: 2021_04_29_085418_add_number_years_active_to_company_users_table,
Migrated: 2021_04_29_085418_add_number_years_active_to_company_users_table (378.19ms),
Migrating: 2021_05_03_152940_make_braintree_provider_visible,
Migrated: 2021_05_03_152940_make_braintree_provider_visible (0.65ms),
Migrating: 2021_05_04_231430_add_task_property_to_companies_table,
Migrated: 2021_05_04_231430_add_task_property_to_companies_table (242.87ms),
Migrating: 2021_05_06_211039_add_show_task_end_date_to_companies_table,
Migrated: 2021_05_06_211039_add_show_task_end_date_to_companies_table (277.67ms),
Migrating: 2021_05_10_041528_add_recurring_invoice_id_to_activities_table,
Migrated: 2021_05_10_041528_add_recurring_invoice_id_to_activities_table (623.58ms),
2021-05-16 14:24:46,331 WARN For [program:php-fpm], redirect_stderr=true but stderr_logfile has also been set to a filename, the filename has been ignored,
2021-05-16 14:24:46,331 WARN For [program:scheduler], redirect_stderr=true but stderr_logfile has also been set to a filename, the filename has been ignored,
2021-05-16 14:24:46,331 WARN For [program:queue-worker], redirect_stderr=true but stderr_logfile has also been set to a filename, the filename has been ignored,
2021-05-16 14:24:46,331 WARN For [program:queue-worker], redirect_stderr=true but stderr_logfile has also been set to a filename, the filename has been ignored,
2021-05-16 14:24:46,333 INFO supervisord started with pid 1,
2021-05-16 14:24:47,338 INFO spawned: 'shutdown' with pid 62,
2021-05-16 14:24:47,342 INFO spawned: 'php-fpm' with pid 63,
2021-05-16 14:24:47,345 INFO spawned: 'queue-worker_00' with pid 64,
2021-05-16 14:24:47,349 INFO spawned: 'queue-worker_01' with pid 65,
2021-05-16 14:24:47,353 INFO spawned: 'scheduler' with pid 66,
READY,
[16-May-2021 14:24:47] NOTICE: [pool www] 'user' directive is ignored when FPM is not running as root,
[16-May-2021 14:24:47] NOTICE: [pool www] 'user' directive is ignored when FPM is not running as root,
[16-May-2021 14:24:47] NOTICE: [pool www] 'group' directive is ignored when FPM is not running as root,
[16-May-2021 14:24:47] NOTICE: [pool www] 'group' directive is ignored when FPM is not running as root,
[16-May-2021 14:24:47] NOTICE: fpm is running, pid 63,
[16-May-2021 14:24:47] NOTICE: ready to handle connections,
Schedule worker started successfully.,
2021-05-16 14:24:48,642 INFO success: shutdown entered RUNNING state, process has stayed up for > than 1 seconds (startsecs),
2021-05-16 14:24:48,642 INFO success: php-fpm entered RUNNING state, process has stayed up for > than 1 seconds (startsecs),
2021-05-16 14:24:48,642 INFO success: queue-worker_00 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs),
2021-05-16 14:24:48,642 INFO success: queue-worker_01 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs),
2021-05-16 14:24:48,643 INFO success: scheduler entered RUNNING state, process has stayed up for > than 1 seconds (startsecs),
,
[2021-05-16T14:25:00+00:00] Execution #1 output:,
Running scheduled command: App\Jobs\Util\SchedulerCheck,
,
[2021-05-16T14:26:00+00:00] Execution #2 output:,
No scheduled commands are ready to run.,
,
[2021-05-16T14:27:00+00:00] Execution #3 output:,
No scheduled commands are ready to run.,
,
[2021-05-16T14:28:00+00:00] Execution #4 output:,
No scheduled commands are ready to run.,
,
[2021-05-16T14:29:00+00:00] Execution #5 output:,
No scheduled commands are ready to run.,
,
[2021-05-16T14:30:00+00:00] Execution #6 output:,
Running scheduled command: App\Jobs\Util\SchedulerCheck,
,
[2021-05-16T14:31:00+00:00] Execution #7 output:,
No scheduled commands are ready to run.,
,
[2021-05-16T14:32:00+00:00] Execution #8 output:,
No scheduled commands are ready to run.,
,
[2021-05-16T14:33:00+00:00] Execution #9 output:,
No scheduled commands are ready to run.,
,
[2021-05-16T14:34:00+00:00] Execution #10 output:,
No scheduled commands are ready to run.,