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.
-
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
.id
astransaction_group_id
,transaction_groups
.user_id
asuser_id
,transaction_groups
.user_group_id
asuser_group_id
,transaction_groups
.created_at
ascreated_at
,transaction_groups
.updated_at
asupdated_at
,transaction_groups
.title
astransaction_group_title
,transaction_journals
.id
astransaction_journal_id
,transaction_journals
.transaction_type_id
,transaction_journals
.description
,transaction_journals
.date
,transaction_journals
.order
,transaction_types
.type
astransaction_type_type
,source
.id
assource_transaction_id
,source
.account_id
assource_account_id
,source
.reconciled
,source
.amount
asamount
,source
.transaction_currency_id
ascurrency_id
,currency
.code
ascurrency_code
,currency
.name
ascurrency_name
,currency
.symbol
ascurrency_symbol
,currency
.decimal_places
ascurrency_decimal_places
,source
.foreign_amount
asforeign_amount
,source
.foreign_currency_id
asforeign_currency_id
,foreign_currency
.code
asforeign_currency_code
,foreign_currency
.name
asforeign_currency_name
,foreign_currency
.symbol
asforeign_currency_symbol
,foreign_currency
.decimal_places
asforeign_currency_decimal_places
,destination
.account_id
asdestination_account_id
,categories
.id
ascategory_id
,categories
.name
ascategory_name
,source_account
.name
assource_account_name
,source_account
.iban
assource_account_iban
,source_account_type
.type
assource_account_type
,dest_account
.name
asdestination_account_name
,dest_account
.iban
asdestination_account_iban
,dest_account_type
.type
asdestination_account_type
,budgets
.id
asbudget_id
,budgets
.name
asbudget_name
fromtransaction_journals
left jointransaction_groups
ontransaction_journals
.transaction_group_id
=transaction_groups
.id
left jointransactions
assource
onsource
.transaction_journal_id
=transaction_journals
.id
andsource
.amount
< 0 left jointransactions
asdestination
ondestination
.transaction_journal_id
=transaction_journals
.id
anddestination
.amount
> 0 left jointransaction_types
ontransaction_types
.id
=transaction_journals
.transaction_type_id
left jointransaction_currencies
ascurrency
oncurrency
.id
=source
.transaction_currency_id
left jointransaction_currencies
asforeign_currency
onforeign_currency
.id
=source
.foreign_currency_id
left joincategory_transaction_journal
oncategory_transaction_journal
.transaction_journal_id
=transaction_journals
.id
left joincategories
oncategory_transaction_journal
.category_id
=categories
.id
left joinaccounts
assource_account
onsource_account
.id
=source
.account_id
left joinaccount_types
assource_account_type
onsource_account_type
.id
=source_account
.account_type_id
left joinaccounts
asdest_account
ondest_account
.id
=destination
.account_id
left joinaccount_types
asdest_account_type
ondest_account_type
.id
=dest_account
.account_type_id
left joinbudget_transaction_journal
onbudget_transaction_journal
.transaction_journal_id
=transaction_journals
.id
left joinbudgets
onbudget_transaction_journal
.budget_id
=budgets
.id
wheretransaction_journals
.user_id
= 1 andtransaction_journals
.user_id
is not null andtransaction_groups
.deleted_at
is null andtransaction_journals
.deleted_at
is null andsource
.deleted_at
is null anddestination
.deleted_at
is null andtransaction_journals
.date
>= 2023-01-01 00:00:00 andtransaction_journals
.date
<= 2023-12-31 23:59:59 andtransaction_types
.type
in (Withdrawal) and (source
.account_id
in (28, 81, 1, 10, 14, 8, 3, 12, 6, 27, 26, 4, 31, 29, 16, 30) ordestination
.account_id
in (28, 81, 1, 10, 14, 8, 3, 12, 6, 27, 26, 4, 31, 29, 16, 30)) andcategories
.id
in (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_at
is null order bytransaction_journals
.date
desc,transaction_journals
.order
asc,transaction_journals
.id
desc,transaction_journals
.description
desc,source
.amount
desc)。Steps to reproduce
No response
Additional info
No response
Beta Was this translation helpful? Give feedback.
All reactions