framework:
secret: '%env(ECCUBE_AUTH_MAGIC)%'
default_locale: '%locale%'
translator:
fallback: ['%locale%']
csrf_protection: { enabled: true }
http_method_override: true
trusted_hosts: ~
# https://symfony.com/doc/current/reference/configuration/framework.html#handler-id
session:
handler_id: 'Eccube\Session\Storage\Handler\SameSiteNoneCompatSessionHandler'
save_path: '%kernel.project_dir%/var/sessions/%kernel.environment%'
name: '%env(ECCUBE_COOKIE_NAME)%'
cookie_lifetime: '%env(ECCUBE_COOKIE_LIFETIME)%'
gc_maxlifetime: '%env(ECCUBE_GC_MAXLIFETIME)%'
cookie_httponly: true
# When using the HTTP Cache, ESI allows to render page fragments separately
# and with different cache configurations for each fragment
# https://symfony.com/doc/current/book/http_cache.html#edge-side-includes
esi: { enabled: true }
fragments: { enabled: true }
php_errors:
log: true
assets:
base_path: '/html/template/%eccube.theme%'
packages:
admin:
base_path: '/html/template/admin'
save_image:
base_path: '/html/upload/save_image'
plugin:
base_path: '/html/plugin'
install:
base_path: '/html/template/install'
temp_image:
base_path: '/html/upload/temp_image'
user_data:
base_path: '/html/user_data'
# json_manifest_path: '%kernel.project_dir%/public/build/manifest.json'
cache:
# this value is used as part of the "namespace" generated for the cache item keys
# to avoid collisions when multiple apps share the same cache backend (e.g. a Redis server)
# See https://symfony.com/doc/current/reference/configuration/framework.html#prefix-seed
prefix_seed: ec-cube
# The 'ide' option turns all of the file paths in an exception page
# into clickable links that open the given file using your favorite IDE.
# When 'ide' is set to null the file is opened in your web browser.
# See https://symfony.com/doc/current/reference/configuration/framework.html#ide
ide: ~
validation: { enable_annotations: true }
templating: { engines: ['twig'] }
USE eccubedb;
SELECT
P.id page_id
,PL.layout_id
,L.layout_name
,P.page_name
,P.file_name
FROM dtb_page P
LEFT JOIN dtb_page_layout PL ON P.id = PL.page_id
LEFT JOIN dtb_layout L ON PL.layout_id = L.id;
<?php
/* This file is part of EC-CUBE
* Copyright(c) LOCKON CO.,LTD. All Rights Reserved.
* http://www.lockon.co.jp/
* For the full copyright and license information, please view the LICENSE file that was distributed with this source code.
*/
namespace Eccube\Command;
use Symfony\Component\Console\Command\Command;
use Symfony\Component\Console\Input\InputInterface;
use Symfony\Component\Console\Output\OutputInterface;
use Symfony\Component\Console\Style\SymfonyStyle;
class MailCommand extends Command
{
protected static $defaultName = 'eccube:mail';
/** * @var SymfonyStyle */ protected $io; public function __construct(\Swift_Mailer $mailer) { parent::__construct(); $this->mailer = $mailer; }protected function configure() { $this->setDescription('メールのテスト'); }protected function initialize(InputInterface $input, OutputInterface $output) { $this->io = new SymfonyStyle($input, $output); }protected function execute(InputInterface $input, OutputInterface $output) { $message = (new \Swift_Message()) ->setSubject('メール送信チェック') ->setFrom('test01@example.com') ->setTo('test02@example.com') ->setBcc('test03@example.com') ->setReplyTo('test04@example.com') ->setReturnPath('test05@example.com'); $this->mailer->send($message); $this->io->success('メール送信テスト完了.'); }
}
An exception occurred in driver: SQLSTATE[HY000] [1044] Access denied for user 'dbuser'@'%' to database データベース名
ではSQLで確認しましょう
DockerのコンテナへSQL接続
意味が違かったらすみません。
Dockerの下記画面で、黄色の枠のCLIを押せばコンテナのコマンドライン?が起動します。
コマンドラインからmysqlに接続
mysql -u root -p
デフォルトのパスワードは:root
sqlで権限確認
SHOW GRANTS FOR `dbuser`@`%`;
結果
+------------------------------------------------------+
| Grants for dbuser@% |
+------------------------------------------------------+
| GRANT USAGE ON *.* TO 'dbuser'@'%' |
| GRANT ALL PRIVILEGES ON `eccubedb`.* TO 'dbuser'@'%' |
+------------------------------------------------------+
2 rows in set (0.00 sec)
> bin/console doctrine:schema:create
! [CAUTION] This operation should not be executed in a production environment!
Creating database schema...
[OK] Database schema created successfully!
> bin/console eccube:fixtures:load
> Finished Successful!