Firefly III
Replies: 2 comments 4 replies
-
|
After spending the whole day trying to debug it, I finally got it work with this docker compose. not sure what exactly made it finally work but this has been one of the most time consuming service to install version: '3.3'
services:
app:
image: fireflyiii/core
hostname: app
container_name: app
restart: always
volumes:
- ./volumes/firefly_iii_upload:/var/www/html/storage/upload
environment:
- APP_KEY=heARL5nQXV1Vq4vcV9NPK2k31z5XR4JS
- DB_HOST=db
- DB_PORT=3306
- DB_CONNECTION=mysql
- DB_DATABASE=fireflydb
- DB_USERNAME=fireflyuser
- DB_PASSWORD=fireflypassword
- APP_ENV=local
ports:
- 9113:8080
depends_on:
- db
networks:
- skynet
db:
image: mysql:8.2.0
command: --default-authentication-plugin=mysql_native_password
hostname: db
container_name: db
restart: always
#env_file: .db.env
environment:
- MYSQL_ROOT_PASSWORD=fireflypassword
- MYSQL_DATABASE=fireflydb
- MYSQL_USER=fireflyuser
- MYSQL_PASSWORD=fireflypassword
volumes:
- ./volumes/firefly_iii_db:/var/lib/mysql
networks:
- skynet
networks:
skynet:
#cron:
#
# To make this work, set STATIC_CRON_TOKEN in your .env file or as an environment variable and replace REPLACEME below
# The STATIC_CRON_TOKEN must be *exactly* 32 characters long
#
# image: alpine
# restart: always
# container_name: firefly_iii_cron
# command: sh -c "echo \"0 3 * * * wget -qO- http://app:8080/api/v1/cron/REPLACEME\" | crontab - && crond -f -L /dev/stdout" |
Beta Was this translation helpful? Give feedback.
-
|
Hi, I have a similar issue. I have installed firefly-iii in docker on Synology nas. My importer page opens up but the firefly login page gives similar error. it says my user doesnot have access to the database. I could not figure out why is that. I will add my files. Could not poll the database: SQLSTATE[HY000] [1045] Access denied for user 'firefly'@'192.168.64.4' (using password: YES) (Connection: mysql, SQL: select id, name, data from configuration where name = is_demo_site and configuration.deleted_at is null limit 1) This error occured in file /var/www/html/app/Support/FireflyConfig.php on line 65 with code 0. docker-compose.yml version: '3.3' services: importer: cron: volumes: networks: .env APP_ENV=production SITE_OWNER=mail@example.com DEFAULT_LOCALE=equal TZ=America/Edmonton TRUSTED_PROXIES= APP_LOG_LEVEL=notice AUDIT_LOG_LEVEL=emergency DB_CONNECTION=mysql DB_SOCKET= MYSQL_USE_SSL=false MYSQL_SSL_CAPATH=/etc/ssl/certs/ PGSQL_SSL_MODE=prefer PGSQL_SCHEMA=public CACHE_DRIVER=file REDIS_SCHEME=tcp REDIS_PATH= REDIS_USERNAME= REDIS_DB="0" COOKIE_PATH="/" MAIL_MAILER=log MAILGUN_DOMAIN= MAILGUN_ENDPOINT=api.mailgun.net MANDRILL_SECRET= SEND_ERROR_MESSAGE=true SEND_REPORT_JOURNALS=true ENABLE_EXTERNAL_MAP=false ENABLE_EXCHANGE_RATES=false ENABLE_EXTERNAL_RATES=false MAP_DEFAULT_LAT=51.983333 VALID_URL_PROTOCOLS= AUTHENTICATION_GUARD=web AUTHENTICATION_GUARD_HEADER=REMOTE_USER PASSPORT_PRIVATE_KEY= CUSTOM_LOGOUT_URL= DISABLE_FRAME_HEADER=false DISABLE_CSP_HEADER=false TRACKER_SITE_ID= ALLOW_WEBHOOKS=false STATIC_CRON_TOKEN=V6cu2koASQDoCBnY8fPY9cD7myEQrjUS DKR_BUILD_LOCALE=false DKR_CHECK_SQLITE=true DKR_RUN_MIGRATION=true DKR_RUN_UPGRADE=true DKR_RUN_VERIFY=true DKR_RUN_REPORT=true DKR_RUN_PASSPORT_INSTALL=true APP_NAME=FireflyIII FIREFLY_III_LAYOUT=v1 APP_URL=http://localhost .db.env MYSQL_RANDOM_ROOT_PASSWORD=yes .importer.env FIREFLY_III_URL= SPECTRE_APP_ID= USE_CACHE=false IGNORE_DUPLICATE_ERRORS=false AUTO_IMPORT_SECRET= CAN_POST_AUTOIMPORT=false CAN_POST_FILES=false IMPORT_DIR_ALLOWLIST= FALLBACK_IN_DIR=false VERIFY_TLS_SECURITY=true JSON_CONFIGURATION_DIR= CONNECTION_TIMEOUT=31.41 APP_ENV=local LOG_RETURN_JSON=false LOG_LEVEL=debug TRUSTED_PROXIES= ENABLE_MAIL_REPORT=false EXPECT_SECURE_URL=false MAIL_MAILER= MAIL_DESTINATION=noreply@example.com MAIL_FROM_ADDRESS=noreply@example.com MAILGUN_DOMAIN= BROADCAST_DRIVER=log REDIS_HOST=127.0.0.1 REDIS_DB="0" ASSET_URL= TRACKER_SITE_ID= APP_NAME=DataImporter APP_URL=http://localhost |
Beta Was this translation helpful? Give feedback.
-
|
Like I mentioned in the comment above you, I managed to get it solved by using mysql instead of mariadb check my docker compose file. |
Beta Was this translation helpful? Give feedback.
-
|
Now mysql is crashing |
Beta Was this translation helpful? Give feedback.
-
|
Could not poll the database: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo for db failed: Name or service not known (Connection: mysql, SQL: select This error occured in file /var/www/html/app/Support/FireflyConfig.php on line 65 with code 0. |
Beta Was this translation helpful? Give feedback.
-
|
could you try to clear everything and use my docker compose and change it to match your use (change volumes and environment) and then go on from there? |
Beta Was this translation helpful? Give feedback.
-
Support guidelines
I've found a bug and checked that ...
Description
错误类型为“Illuminate\Database\QueryException”
Debug information
Expected behaviour
Firefly III v6.1.1 发生了错误：SQLSTATE[HY000] [2002] Connection refused (Connection: mysql, SQL: select
transaction_groups.idastransaction_group_id,transaction_groups.user_idasuser_id,transaction_groups.user_group_idasuser_group_id,transaction_groups.created_atascreated_at,transaction_groups.updated_atasupdated_at,transaction_groups.titleastransaction_group_title,transaction_journals.idastransaction_journal_id,transaction_journals.transaction_type_id,transaction_journals.description,transaction_journals.date,transaction_journals.order,transaction_types.typeastransaction_type_type,source.idassource_transaction_id,source.account_idassource_account_id,source.reconciled,source.amountasamount,source.transaction_currency_idascurrency_id,currency.codeascurrency_code,currency.nameascurrency_name,currency.symbolascurrency_symbol,currency.decimal_placesascurrency_decimal_places,source.foreign_amountasforeign_amount,source.foreign_currency_idasforeign_currency_id,foreign_currency.codeasforeign_currency_code,foreign_currency.nameasforeign_currency_name,foreign_currency.symbolasforeign_currency_symbol,foreign_currency.decimal_placesasforeign_currency_decimal_places,destination.account_idasdestination_account_id,categories.idascategory_id,categories.nameascategory_name,source_account.nameassource_account_name,source_account.ibanassource_account_iban,source_account_type.typeassource_account_type,dest_account.nameasdestination_account_name,dest_account.ibanasdestination_account_iban,dest_account_type.typeasdestination_account_type,budgets.idasbudget_id,budgets.nameasbudget_namefromtransaction_journalsleft jointransaction_groupsontransaction_journals.transaction_group_id=transaction_groups.idleft jointransactionsassourceonsource.transaction_journal_id=transaction_journals.idandsource.amount< 0 left jointransactionsasdestinationondestination.transaction_journal_id=transaction_journals.idanddestination.amount> 0 left jointransaction_typesontransaction_types.id=transaction_journals.transaction_type_idleft jointransaction_currenciesascurrencyoncurrency.id=source.transaction_currency_idleft jointransaction_currenciesasforeign_currencyonforeign_currency.id=source.foreign_currency_idleft joincategory_transaction_journaloncategory_transaction_journal.transaction_journal_id=transaction_journals.idleft joincategoriesoncategory_transaction_journal.category_id=categories.idleft joinaccountsassource_accountonsource_account.id=source.account_idleft joinaccount_typesassource_account_typeonsource_account_type.id=source_account.account_type_idleft joinaccountsasdest_accountondest_account.id=destination.account_idleft joinaccount_typesasdest_account_typeondest_account_type.id=dest_account.account_type_idleft joinbudget_transaction_journalonbudget_transaction_journal.transaction_journal_id=transaction_journals.idleft joinbudgetsonbudget_transaction_journal.budget_id=budgets.idwheretransaction_journals.user_id= 1 andtransaction_journals.user_idis not null andtransaction_groups.deleted_atis null andtransaction_journals.deleted_atis null andsource.deleted_atis null anddestination.deleted_atis null andtransaction_journals.date>= 2023-01-01 00:00:00 andtransaction_journals.date<= 2023-12-31 23:59:59 andtransaction_types.typein (Withdrawal) and (source.account_idin (28, 81, 1, 10, 14, 8, 3, 12, 6, 27, 26, 4, 31, 29, 16, 30) ordestination.account_idin (28, 81, 1, 10, 14, 8, 3, 12, 6, 27, 26, 4, 31, 29, 16, 30)) andcategories.idin (1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 26, 27, 28, 29) andtransaction_journals.deleted_atis null order bytransaction_journals.datedesc,transaction_journals.orderasc,transaction_journals.iddesc,transaction_journals.descriptiondesc,source.amountdesc)。Steps to reproduce
No response
Additional info
No response
Beta Was this translation helpful? Give feedback.
All reactions