登录/ 注册
 找回密码
 立即注册

微信扫码 , 快速开始
发布主题
返回列表 发新帖
收起左侧

谁成功搭建fireflyiii了，求教！

4
回复 150
查看 [ 复制链接 ]
usx

2

主题

6

回帖

0

牛值

江湖小虾
2025-6-30 23:15:22 显示全部楼层 阅读模式
悬赏1飞牛币未解决

我最近根据论坛内两个帖子

1、fnOS飞牛私有云Docker Compose搭建mariadb+ phpmyadmin - 攻略分享 飞牛私有云论坛 fnOS

2、更好的管理个人财务使用飞牛OS部署私有记账系统Firefly III - 攻略分享 飞牛私有云论坛 fnOS

最后根据2教程部署后无法进入fireflyiii，拒绝访问。已经填写正确的数据库172.21.0.2

收藏
送赞
分享
usx

2

主题

6

回帖

0

牛值

江湖小虾
2025-6-30 23:19:37 楼主 显示全部楼层
回复

举报

diglactic/laravel-breadcrumbs ......................................... DONE

jc5/google2fa-laravel ................................................. DONE

laravel-notification-channels/pushover ................................ DONE

laravel/passport ...................................................... DONE

laravel/sanctum ....................................................... DONE

laravel/slack-notification-channel .................................... DONE

laravel/ui ............................................................ DONE

mailersend/laravel-driver ............................................. DONE

nesbot/carbon ......................................................... DONE

nunomaduro/collision .................................................. DONE

nunomaduro/termwind ................................................... DONE

rcrowe/twigbridge ..................................................... DONE

spatie/laravel-html ................................................... DONE

spatie/laravel-ignition ............................................... DONE

[i] Wait for the database. You may see an error about an 'aborted connection', this is normal.

wait-for-it.sh: waiting 60 seconds for 172.21.0.2:3306

wait-for-it.sh: timeout occurred after waiting 60 seconds for 172.21.0.2:3306

[✓] DB is up.

[i] Wait another 10 seconds in case the DB needs to boot.

[✓] Done waiting for the DB to boot.

[i] Will run database commands.

[i] CreateDB does not apply to "mariadb", skipped.

[i] Will run upgrade commands.

[2025-06-30 15:18:22] production.ERROR: Exception is: {"class":"Illuminate\Database\QueryException","errorMessage":"SQLSTATE[HY000] [2002] Connection timed out (Connection: mariadb, SQL: select exists (select 1 from information_schema.tables where table_schema = schema() and table_name = 'migrations' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as exists)","time":"Mon, 30 Jun 2025 15:18:22 +0000","file":"/var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php","line":822,"code":2002,"version":"6.2.19","url":"http://localhost","userAgent":"Symfony","json":true,"method":"GET","post":""}

[2025-06-30 15:18:22] production.ERROR: SQLSTATE[HY000] [2002] Connection timed out (Connection: mariadb, SQL: select exists (select 1 from information_schema.tables where table_schema = schema() and table_name = 'migrations' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as exists) {"exception":"[object] (Illuminate\Database\QueryException(code: 2002): SQLSTATE[HY000] [2002] Connection timed out (Connection: mariadb, SQL: select exists (select 1 from information_schema.tables where table_schema = schema() and table_name = 'migrations' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as exists) at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:822)

[stacktrace]

#0 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(976): Illuminate\Database\Connection->runQueryCallback()

#1 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(955): Illuminate\Database\Connection->tryAgainIfCausedByLostConnection()

#2 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(778): Illuminate\Database\Connection->handleQueryException()

#3 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(395): Illuminate\Database\Connection->run()

#4 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(341): Illuminate\Database\Connection->select()

#5 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(358): Illuminate\Database\Connection->selectOne()

#6 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(174): Illuminate\Database\Connection->scalar()

#7 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/DatabaseMigrationRepository.php(183): Illuminate\Database\Schema\Builder->hasTable()

#8 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(749): Illuminate\Database\Migrations\DatabaseMigrationRepository->repositoryExists()

#9 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(164): Illuminate\Database\Migrations\Migrator->repositoryExists()

#10 /var/www/html/vendor/laravel/framework/src/Illuminate/Support/helpers.php(338): Illuminate\Database\Console\Migrations\MigrateCommand->{closure:Illuminate\Database\Console\Migrations\MigrateCommand::repositoryExists():164}()

#11 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(164): retry()

#12 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(140): Illuminate\Database\Console\Migrations\MigrateCommand->repositoryExists()

#13 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(110): Illuminate\Database\Console\Migrations\MigrateCommand->prepareDatabase()

#14 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(665): Illuminate\Database\Console\Migrations\MigrateCommand->{closure:Illuminate\Database\Console\Migrations\MigrateCommand::runMigrations():109}()

#15 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(109): Illuminate\Database\Migrations\Migrator->usingConnection()

#16 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(88): Illuminate\Database\Console\Migrations\MigrateCommand->runMigrations()

#17 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Database\Console\Migrations\MigrateCommand->handle()

#18 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\Container\BoundMethod::{closure:Illuminate\Container\BoundMethod::call():35}()

#19 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(96): Illuminate\Container\Util::unwrapIfClosure()

#20 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod()

#21 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(754): Illuminate\Container\BoundMethod::call()

#22 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(209): Illuminate\Container\Container->call()

#23 /var/www/html/vendor/symfony/console/Command/Command.php(318): Illuminate\Console\Command->execute()

#24 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(178): Symfony\Component\Console\Command\Command->run()

#25 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Concerns/CallsCommands.php(68): Illuminate\Console\Command->run()

#26 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Concerns/CallsCommands.php(29): Illuminate\Console\Command->runCommand()

#27 /var/www/html/app/Console/Commands/Upgrade/UpgradesDatabase.php(98): Illuminate\Console\Command->call()

#28 /var/www/html/app/Console/Commands/Upgrade/UpgradesDatabase.php(53): FireflyIII\Console\Commands\Upgrade\UpgradesDatabase->callInitialCommands()

#29 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): FireflyIII\Console\Commands\Upgrade\UpgradesDatabase->handle()

#30 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\Container\BoundMethod::{closure:Illuminate\Container\BoundMethod::call():35}()

#31 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(96): Illuminate\Container\Util::unwrapIfClosure()

#32 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod()

#33 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(754): Illuminate\Container\BoundMethod::call()

#34 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(209): Illuminate\Container\Container->call()

#35 /var/www/html/vendor/symfony/console/Command/Command.php(318): Illuminate\Console\Command->execute()

#36 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(178): Symfony\Component\Console\Command\Command->run()

#37 /var/www/html/vendor/symfony/console/Application.php(1092): Illuminate\Console\Command->run()

#38 /var/www/html/vendor/symfony/console/Application.php(341): Symfony\Component\Console\Application->doRunCommand()

#39 /var/www/html/vendor/symfony/console/Application.php(192): Symfony\Component\Console\Application->doRun()

#40 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(197): Symfony\Component\Console\Application->run()

#41 /var/www/html/artisan(35): Illuminate\Foundation\Console\Kernel->handle()

#42 {main}

[previous exception] [object] (PDOException(code: 2002): SQLSTATE[HY000] [2002] Connection timed out at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:67)

[stacktrace]

#0 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(67): PDO::connect()

#1 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(85): Illuminate\Database\Connectors\Connector->createPdoConnection()

#2 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php(48): Illuminate\Database\Connectors\Connector->tryAgainIfCausedByLostConnection()

#3 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connectors/MySqlConnector.php(24): Illuminate\Database\Connectors\Connector->createConnection()

#4 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php(184): Illuminate\Database\Connectors\MySqlConnector->connect()

#5 [internal function]: Illuminate\Database\Connectors\ConnectionFactory->{closure:Illuminate\Database\Connectors\ConnectionFactory::createPdoResolverWithHosts():179}()

#6 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(1228): call_user_func()

#7 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(1264): Illuminate\Database\Connection->getPdo()

#8 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(509): Illuminate\Database\Connection->getReadPdo()

#9 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(404): Illuminate\Database\Connection->getPdoForSelect()

#10 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(809): Illuminate\Database\Connection->{closure:Illuminate\Database\Connection::select():395}()

#11 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(976): Illuminate\Database\Connection->runQueryCallback()

#12 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(955): Illuminate\Database\Connection->tryAgainIfCausedByLostConnection()

#13 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(778): Illuminate\Database\Connection->handleQueryException()

#14 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(395): Illuminate\Database\Connection->run()

#15 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(341): Illuminate\Database\Connection->select()

#16 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(358): Illuminate\Database\Connection->selectOne()

#17 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(174): Illuminate\Database\Connection->scalar()

#18 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/DatabaseMigrationRepository.php(183): Illuminate\Database\Schema\Builder->hasTable()

#19 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(749): Illuminate\Database\Migrations\DatabaseMigrationRepository->repositoryExists()

#20 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(164): Illuminate\Database\Migrations\Migrator->repositoryExists()

#21 /var/www/html/vendor/laravel/framework/src/Illuminate/Support/helpers.php(338): Illuminate\Database\Console\Migrations\MigrateCommand->{closure:Illuminate\Database\Console\Migrations\MigrateCommand::repositoryExists():164}()

#22 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(164): retry()

#23 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(140): Illuminate\Database\Console\Migrations\MigrateCommand->repositoryExists()

#24 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(110): Illuminate\Database\Console\Migrations\MigrateCommand->prepareDatabase()

#25 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(665): Illuminate\Database\Console\Migrations\MigrateCommand->{closure:Illuminate\Database\Console\Migrations\MigrateCommand::runMigrations():109}()

#26 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(109): Illuminate\Database\Migrations\Migrator->usingConnection()

#27 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(88): Illuminate\Database\Console\Migrations\MigrateCommand->runMigrations()

#28 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Database\Console\Migrations\MigrateCommand->handle()

#29 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\Container\BoundMethod::{closure:Illuminate\Container\BoundMethod::call():35}()

#30 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(96): Illuminate\Container\Util::unwrapIfClosure()

#31 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod()

#32 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(754): Illuminate\Container\BoundMethod::call()

#33 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(209): Illuminate\Container\Container->call()

#34 /var/www/html/vendor/symfony/console/Command/Command.php(318): Illuminate\Console\Command->execute()

#35 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(178): Symfony\Component\Console\Command\Command->run()

#36 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Concerns/CallsCommands.php(68): Illuminate\Console\Command->run()

#37 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Concerns/CallsCommands.php(29): Illuminate\Console\Command->runCommand()

#38 /var/www/html/app/Console/Commands/Upgrade/UpgradesDatabase.php(98): Illuminate\Console\Command->call()

#39 /var/www/html/app/Console/Commands/Upgrade/UpgradesDatabase.php(53): FireflyIII\Console\Commands\Upgrade\UpgradesDatabase->callInitialCommands()

#40 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): FireflyIII\Console\Commands\Upgrade\UpgradesDatabase->handle()

#41 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\Container\BoundMethod::{closure:Illuminate\Container\BoundMethod::call():35}()

#42 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(96): Illuminate\Container\Util::unwrapIfClosure()

#43 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod()

#44 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(754): Illuminate\Container\BoundMethod::call()

#45 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(209): Illuminate\Container\Container->call()

#46 /var/www/html/vendor/symfony/console/Command/Command.php(318): Illuminate\Console\Command->execute()

#47 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(178): Symfony\Component\Console\Command\Command->run()

#48 /var/www/html/vendor/symfony/console/Application.php(1092): Illuminate\Console\Command->run()

#49 /var/www/html/vendor/symfony/console/Application.php(341): Symfony\Component\Console\Application->doRunCommand()

#50 /var/www/html/vendor/symfony/console/Application.php(192): Symfony\Component\Console\Application->doRun()

#51 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(197): Symfony\Component\Console\Application->run()

#52 /var/www/html/artisan(35): Illuminate\Foundation\Console\Kernel->handle()

#53 {main}

"}

Illuminate\Database\QueryException

SQLSTATE[HY000] [2002] Connection timed out (Connection: mariadb, SQL: select exists (select 1 from information_schema.tables where table_schema = schema() and table_name = 'migrations' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED')) as exists)

at vendor/laravel/framework/src/Illuminate/Database/Connection.php:822

818▕                     $this->getName(), $query, $this->prepareBindings($bindings), $e

819▕                 );

820▕             }

821▕

➜ 822▕ throw new QueryException(

823▕                 $this->getName(), $query, $this->prepareBindings($bindings), $e

824▕             );

825▕         }

826▕     }



  +39 vendor frames

40 app/Console/Commands/Upgrade/UpgradesDatabase.php:98

  Illuminate\Console\Command::call()

41 app/Console/Commands/Upgrade/UpgradesDatabase.php:53

  FireflyIII\Console\Commands\Upgrade\UpgradesDatabase::callInitialCommands()

[i] Encryption keys exist already.

回复
喔喔

4

主题

192

回帖

0

牛值

小有名气
2025-7-1 08:47:31 显示全部楼层
回复

举报

看日志，你检查一下你的数据库连接配置。

usx
昨天晚上睡觉前解决问题了。 按照教程1搭建的数据库用的非桥接网络，和fireflyiii不是一个网络的，无论填写什么数据库地址都是无法连接。修改数据库网络为桥接模式就可以相互连接了  详情 回复
2025-7-1 11:29
墨香染指尖，代码藏心间。飞牛江湖里，书生亦狂癫。
回复
usx

2

主题

6

回帖

0

牛值

江湖小虾
2025-7-1 11:29:45 楼主 显示全部楼层
回复

举报

喔喔 发表于 2025-7-1 08:47
看日志，你检查一下你的数据库连接配置。

昨天晚上睡觉前解决问题了。
按照教程1搭建的数据库用的非桥接网络，和fireflyiii不是一个网络的，无论填写什么数据库地址都是无法连接。修改数据库网络为桥接模式就可以相互连接了
回复
ttlove514

2

主题

10

回帖

0

牛值

江湖小虾
2025-7-2 23:14:36 显示全部楼层
回复

举报

docker容器一律改HOST模式

回复
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

使用Markdown编辑器编辑 使用富文本编辑器编辑

隐私政策|联系我们
粤ICP备2023020469号