PDOException: SQLSTATE[HY000] [1045] Access denied for user 'root'@'172.21.0.1' (using password: YES)

<?php
# 常量配置
// define('FETCH_ASSOC', Phalcon\DB::FETCH_ASSOC);
require __DIR__.'/app/library/vendor/autoload.php';
//error_reporting(0);
//ini_set('display_errors','off');
 
$config = [
    # PA of Phlacon: 框架配置
    'debug'       => 1,                         // 可选配置，默认false
    'trace'       => 1,
    'application' => __DIR__ . '/app/',         // 必选项，项目的启动位置
    'module_path'     => __DIR__ . '/app/modules/', // 可选配置，默认空，多模块开发时，需要指定模块目录
    // 'domain_bind' => false,
    // 'domain_bind' =>[
    //     'api.mayantown.com' => 'api',
    //     'www.mayantown.com' => 'web',
    //     'console.mayantown.com' => 'admin',
    // ],
    'pa_url_path' => '/smart/',
    'user_handler'=> 'HandlerPAUser',
    'routers'     => [
        'GET' =>[
            '/smart/web/activities/:int' => [
                'module'     => 'web',
                'namespace'  => 'web\Controllers',
                'controller' => 'activities',
                'params'     => 1,
                'priority'   => 1,
            ],
            '/smart/proxy/:params' => [
                'namespace'  => 'plugins\Proxy\Controllers',
                'controller' => 'proxy',
                'params'     => 1,
                'priority'   => 1,
            ]
        ],
    ],                       // 额外的路由配置，默认空数组
    #'pa_db' => [],// 指定 pa 使用的数据库
    'pa_db'       => [
        'host'     => '172.17.0.2',
        'dbname'   => 'mp',
        'port'     => 3306,
        'username' => 'root',
        'password' => '123456',
        'adapter'  => 'mysql',
        'options'  => [
            \PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8mb4'
        ],
        'prefix'  => 'pa_'
    ],
    
//    'pa_db'       => [
//        'host'     => '192.168.3.205',
//        'dbname'   => 'mp',
//        'port'     => 33080,
//        'username' => 'root',
//        'password' => 'aJ6^B@sDw771',
//        'adapter'  => 'mysql',
//        'options'  => [
//            \PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8mb4'
//        ],
//        'prefix'  => 'pa_'
//    ],
    
    'resource_url' => 'https://res.mp.qhhznt.com/',
    // 'error' => [
    //     'controller'=> 'Mp_Error_Controller',
    // ],
 
    # 指定 hznt api 的秘钥对
    'hznt_api' => [
        'public_key' =>'D:\wwwroot\api-local.qhhznt.com\hznt\extend\rsa\rsa_public_key.pem',
        'private_key'=>'D:\wwwroot\api-local.qhhznt.com\hznt\extend\rsa\rsa_private_key.pem',
    ],
    
    'sms' => [
        'accessKeyId'  => 'LTAIqf6GVeeCYl89',
        'accessSecret' => 'O156DUSy67L7GhauoJyfHMy6y13uGu',
        'RegionId'     => "cn-hangzhou",
        'SignName'     => "汇智能通",
    ],
    
    'cookie_fields' => ['user_id'=>4, 'login_ip'=>8, 'login_time'=>4], // 必须保留 user_id
    # token 配置
    'token'=>[
        'method'  => 'AES-256-CBC',
        'gzip'    => 1,
    ],
 
    # 日志配置
    'logger'=>[
        'level'=>255,
        'logger'=>'\\Logger\\UdpLogger',
        'params'=>[
//            'ip'   => 'xadcbguo.gicp.net',
            'ip'   => '192.168.3.206',
            'port' => 9173
        ]
    ],
    
    # 发送邮件配置
    'mail'=>[
        'tls'      => true,                                  // 是否加密传输
        'host'     => 'ssl://smtpdm.aliyun.com',             // SMTP 主机地址
        'user'     => 'admin@mp.qhhznt.com',                 // SMTP 验证的用户名
        'password' => 'uXAkJsJhoMl5a5G0B',                   // SMTP 验证的密码
        'port'     => 465,                                   // SMTP服务器端口
        'from'     => ['MP平台客服'=>'admin@mp.qhhznt.com'], // 发送人
        'admin'    => ['Vanni Fan'=>'fanwanqian1@yongdaxing.cn','CTO'=>'zhaoqiang@yongdaxing.cn'],
    ],
 
    # 数据库配置
//    'mp_db'=>[
//        'host'     => '192.168.3.205',
//        'dbname'   => 'mp',
//        'port'     => 33080,
//        'username' => 'root',
//        'password' => 'aJ6^B@sDw771',
//        'adapter'  => 'mysql',
//        'options'  => [
//            \PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8mb4'
//        ],
//    ],
    'mp_db'=>[
        'host'     => '172.17.0.2',
        'dbname'   => 'mp',
        'port'     => 3306,
        'username' => 'root',
        'password' => '123456',
        'adapter'  => 'mysql',
        'options'  => [
            \PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8mb4'
        ],
    ],
 
    # API服务器配置，用来处理MQ、Socket转发过来的请求
    'server' => [
        'daemonize'     => 0,
        'worker_num'    => 4, # 需要大于1，因为第一个worker(worker_id==0)被用于处理计数器，当计数器为非异步模式时，第一个worker是无法处理请求的
        # 服务器监听设置
        'http'   =>['host'=>'172.17.0.2','port'=>9501],
        'socket' =>[
            'udp'=>['host'=>'172.17.0.2','port'=>9502],
            'tcp'=>['host'=>'172.17.0.2','port'=>9503],
        ],
        'url'           => 'http://172.17.0.2:9501',
        'http2connects' => 1000, # MQ使用http2连接服务器的最大数
        'timeout'       => 15,    # 最大延迟5秒
        'timer_gap'     => 1,    # 定时器检查周期，分钟单位
        'rabbit_mq'     => [
            'host'     => '192.168.3.203',
            'port'     => '5672',
            'user'     => 'devel',
            'password' => '123456',
            'exchange' => 'mp/notifications',
            'queue'    => 'mp/notifications',
            'vhost'    => '/',
        ]
    ],
 
 
    // 当不能消费消息时，将原来的消息放入错误队列
    'error_queue'  => [
        'host'     => '172.17.0.2',
        'port'     => '5672',
        'user'     => 'devel',
        'password' => '123456',
        'exchange' => 'mp/notifications/error',
        'queue'    => 'mp/notifications/error',
        'vhost'    => '/',
    ],
    # 外网
    #'error_queue'  => [
    #    'host'     => '39.108.109.67',
    #    'port'     => '35678',
    #    'user'     => 'mp',
    #    'password' => 'EOcxOyvR6mczoRDYP',
    #    'exchange' => 'notifications',
    #    'vhost'    => '/mp',
    #],
 
    # Redis配置
    'redis'=>[
    'host'   => '172.17.0.2',
    'port'   => '6379',
//    'auth'   => '123456',
    'prefix' => ':mp:',
    ],
 
    # 数据源配置
    'source'=>[
        'try_times' => 3,//重试3次
        'timeout'   => 5,//超时5秒
    ],
];
 
# 初始化事件监听对象
$eventsManager = new Phalcon\Events\Manager();
$eventsManager->attach('db', function (){});
 
# 初始化一个简单的全局静态类
final class MP{static $di, $db, $config, $loader;}
if(defined("POWER_BASE_DIR")){
    MP::$di = PA::$di;
    MP::$config = PA::$config;
    MP::$loader = PA::$loader;
}else{
    MP::$di = new Phalcon\Di\FactoryDefault\Cli();
    MP::$config = new Phalcon\Config($config);
    MP::$loader = new Phalcon\Loader();
}
 
MP::$db = (new Phalcon\Db\Adapter\PdoFactory())->newInstance('mysql', $config['mp_db']);
MP::$di->set('mp_db', MP::$db);
MP::$db->setEventsManager($eventsManager);
 
 
return $config;

<?php
namespace Power;
use Phalcon\Loader;
use Phalcon\Mvc\Router;
use Phalcon\Mvc\Model;
use Phalcon\Config\Adapter\Php;
use Phalcon\Di\FactoryDefault;
use Phalcon\Mvc\Application;
use Phalcon\Mvc\Dispatcher;
use Phalcon\Db\Adapter\PdoFactory as DB;
use Phalcon\Events\Manager as EM;
use PA;
 
class App{
    public function __construct()
    {
        // echo "<pre>";
        PA::$di       = new FactoryDefault();
        PA::$em       = new EM();
        PA::$app      = new Application(PA::$di);
        PA::$config   = new Php(POWER_BASE_DIR.'data/config.php');
        PA::$router   = new Router(false); # 不添加默认路由
        PA::$loader   = new Loader();
        PA::$dispatch = new Dispatcher();
        PA::$di->setShared('dispatcher', PA::$dispatch);
        PA::$di->setShared('router', PA::$router);
    }
 
    public function setErrorHandler($config){
        if($error_handler = $config->path('error.handler')) set_error_handler($error_handler);
        if($config->trace){
            (new \Phalcon\Debug())->listen();
        }else{
            if($exception_handler = $config->path('error.exception')) set_exception_handler($exception_handler);
        }
    }
 
    public function init($config=null){
        # 1、PA初始化：Loader目录注册,Loader名字空间注册,常量设置
        # 设置基础环境
        PA::$loader->registerDirs([POWER_BASE_DIR,POWER_BASE_DIR.'library']);
        PA::$loader->registerNamespaces(
            [
                'Power\\Controllers' => POWER_BASE_DIR.'controllers',
                'Power\\Models'      => POWER_BASE_DIR.'models',
            ],
            true
        );
        PA::$loader->register();
 
        # 2、加载 PA 的 vendors，如果有的话
        $pa_vendor = realpath(POWER_BASE_DIR.'library/vendor/autoload.php');
        if($pa_vendor) require $pa_vendor;
 
        # 3、设置 PA 自己的错误处理机制和方法
        $this->setErrorHandler(PA::$config);
 
        # 4、加载项目的配置文件 $config，并合并
        if($config){
            if(!($config instanceof \Phalcon\Config)){
                $config = is_array($config) ? (new \Phalcon\Config($config)) : (new Php($config));
            }
            // 添加名字空间，加载项目的
            if($config->application != POWER_BASE_DIR) PA::$loader->registerDirs([$config->application.'/library'],true);
 
            # 用项目的错误处理来替代PA的错误处理
            if($config->error) $this->setErrorHandler($config);
            # 加载项目的 vendors
            if($config->application){
                $project_vendor = realpath($config->application.'/library/vendor/autoload.php');
                if($project_vendor) require $project_vendor;
            }
            # 合并配置文件
            PA::$config->merge($config);
        }
        # 5、加载数据的配置和路由
        $routers = []; // [$module=>[[具体路由配置],[具体路由配置]]];
        if(PA::$config->pa_db || PA::$config->load_db_config){
            # 初始化 PA 的数据库
            if(!PA::$config->pa_db) throw new \Exception('请配置 pa_db 选项，以便加载数据库的配置');
            $db_connect = PA::$config['pa_db']->toArray();
            $db_adapter = $db_connect['adapter'];
            if($db_adapter == 'sqlite'){ // sqlite 不支持的配置项目
                unset($db_connect['adapter'], $db_connect['host'], $db_connect['prefix']);
            }
            PA::$db = (new DB())->newInstance($db_adapter, $db_connect);
            # 配置文件
            // $db_config = array_column(PA::$db->fetchAll('SELECT var_name as name,var_default as value FROM '.PA::$config->path('pa_db.prefix').'configs'),'value','name');
            $db_config = array_column(\Power\Models\Configs::find()->toArray(),'var_default','var_name');
            PA::$config->merge(new \Phalcon\Config($db_config));// 数据配置
            # 路由
            foreach(\Power\Models\Menus::find(['url_suffix is not null','columns'=>'url_suffix,router,modules']) as $_router){
                foreach(explode(',',$_router->modules) as $_module) {
                    $routers[$_module]['*'][$_router->url_suffix] = json_decode($_router->router, 1);
                }
            }
        }
        define('PA_URL_PATH', '/'.trim(PA::$config->pa_url_path,'/').'/');
 
        # 6、分析匹配的子模块并加载
        $modules = []; # 所有的模块和路由
        if(PA::$config['module_path']) {
            PA::$loader->registerDirs([PA::$config['module_path']],true);
        }
        if(!PA::$config['domain_bind']){ # 没有子模块域名绑定
            if(PA::$config['module_path']){
                # 返回添加成功的模块 todo
                $modules = $this->registerModules(PA::$config['module_path'], '*', $routers);
            }
            $this->loadAdminRouter($routers);
        }
        # 有配置模块
        else{ 
            # 没有配置 modules 目录
            if(!PA::$config['module_path']){
                if(count(PA::$config['domain_bind'])===1 && current(PA::$config['domain_bind'])==='admin'){
                    $this->loadAdminRouter($routers);
                }else throw new \Exception('请配置 modules 参数');
            }
            # 有配置 modules 目录
            else{
                # SERVER_NAME 输出为服务端配置的域名，HTTP_HOST 输出的是客户端请求时的域名(包含端口)
                $server_name = $_SERVER['SERVER_NAME'] ?? PA::$args['server'];
                $domain_base = PA::$config['root_domain'] ?: (substr($server_name, strpos($server_name,'.')+1));
                foreach(PA::$config['domain_bind'] as $domain=>$_module){
                    if('*' === $domain){
                        $modules = $this->registerModules(PA::$config['module_path'], $_module, $routers);
                        break;
                    }
                    $domain = strpos($domain, '.')!==false ? $domain : "$domain.$domain_base";
                    if(strpos($_SERVER['HTTP_HOST'] ?? PA::$args['server'], $domain)!==0) continue; // 不是本域名
                    $modules = $this->registerModules(PA::$config['module_path'], $_module, $routers);
                    break; // 只应用第一个找到的模块
                }
            }
        }
        // print_r($modules);
        // exit;
//        print_r($routers);
        if($modules) PA::$app->registerModules($modules);
        # 8、加载插件，调用 plugin的 autoload 方法。具体操作请在 autoload 方法里面实现
        foreach(PA::$config->plugins ?? [] as $plugin){
            $path = POWER_BASE_DIR . 'plugins/'.$plugin;
            if(file_exists($path) && is_dir($path)){
                $class = '\\plugins\\'.$plugin.'\\Settings';
                if(method_exists($class,'autoload')) {
                    call_user_func([$class, 'autoload']);
                }
            }
        }
 
        # 9、设置 em, view 等
        # 设置错误异常
        Model::setup(['exceptionOnFailedSave' => PA::$config->exception_on_failed_save]);
        # 设置视图
        if(PA::$config->view){
            $class = '\\'.PA::$config->view->class;
            PA::$view = new $class();
            PA::$di->setShared('view', PA::$view);
 
//            PA::$di->setShared('view', function () {
//                $class = '\\'.PA::$config->view->class;
//                $view = new $class();
//                $view->disableLevel(
//                    [
//                        View::LEVEL_LAYOUT      => PA::$config->view->disable_layout,
//                        View::LEVEL_MAIN_LAYOUT => PA::$config->view->disable_main_layout,
//                    ]
//                );
//                return $view;
//            });
        }
 
        # 设置事件监听
        if(PA::$config->events){
            foreach(PA::$config->events ?? [] as $type => $class){
                $objects  = explode('@', $type);
                if(isset($objects[1])){
                    $type    = $objects[0];
                    $objects = explode(',', $objects[1]);
                }else{
                    $objects = [ substr($objects[0], 0, strpos($objects[0],':')) ];
                }
                if(is_string($class)){
                    $function = (new \ReflectionMethod('\\'.trim($class,'\\')))->getClosure();
                }elseif($class instanceof \Closure){ # 闭包
                    $function = $class;
                }else{
                    throw new \Exception('监听事件的回调函数必须是一个闭包或者静态方法');
                }
                PA::$em->attach($type, $function);
                foreach($objects as $obj_name){
                    $obj_name = $obj_name == 'application' ? 'app' : $obj_name;
                    if(isset(PA::${$obj_name})){
                        PA::${$obj_name}->setEventsManager(PA::$em);
                    }else{
                        if(PA::$di->has($obj_name)) PA::$di->get($obj_name)->setEventsManager(PA::$em);
                    }
                }
            }
        }
 
        # 10、排序 router，并注册 router
        # 为路由设置权重
//        echo "<pre>";
        foreach($routers as $module => &$_routers){ # 循环之模块
            foreach($_routers as $method=>&$rule) { # 循环请求方法
                $sort = [];
                array_walk($rule, function (&$v, $k) use (&$sort) {
                    $v['priority'] = $v['priority'] ?? 0;
                    $sort[] = $v['priority'];
                });
                array_multisort($sort, $rule);
//            echo "\n要添加的 $method 有",print_r($rule);
                foreach ($rule as $url => $param) {
                    unset($param['priority']);
                    if ($method === '*') {
                        PA::$router->add($url, $param);
                    } else {
                        PA::$router->{'add' . $method}($url, $param);
                    }
                }
            }
        }
//        print_r(PA::$router);
//        print_r(PA::$loader);
//        print_r($routers);
//        exit;
        # 重新赋值会到配置中
        PA::$config['routers'] = $routers;
 
        define('BASE_DIR', PA::$config->application ?? POWER_BASE_DIR);
        define('VIEW_DIR', $modules ? (BASE_DIR.'modules/') : (BASE_DIR.'views/templates/'));
        return $this;
    }
 
    /**
     * 加载 admin 模块，返回[plugin:[...], db:[...]]
     * 1、 初始化PA的数据库连接
     * 2、 获得所有 DB 中配置的路由信息
     * 3、 获得所有 Plugin 中的配置信息
     * 4、 返回
     */
    public static function loadAdminRouter(&$routers){
        static $loaded = false;
        if(!$loaded){
            $routers['admin'] = include POWER_BASE_DIR.'data/routers.php';
//            $pa_routers = include POWER_BASE_DIR.'data/routers.php';
//            $routers = array_merge_recursive($routers, $pa_routers);
        }
    }
 
    /**
     * 根据一个目录注册模块，包括名字空间，和路由规则
     * @param string $module_dir 模块目录，里面的每个文件夹都被解析成一个模块
     * @param string $include 只分析指定的某几个目录，如果有条目大于1或等于空，表示要模块前缀
     * @param array &$routers 被设置的路由数组
     * @return array
     */
    public static function registerModules(string $module_dir, string $include, array &$routers):array{
        static $modules = []; // [ $module_name => $module_path, ... ]
        # 只分析一次
        if(!$modules){
            foreach(new \DirectoryIterator($module_dir) as $file){
                if($file->isDot() || !$file->isDir()) continue;
                $modules[$file->getBasename()] = $file->getPathname();
            }
        }
        # 需要包含的模块
        $include = preg_split('/[, ]+/',$include);
        if(array_search('*', $include) !== false) $include = array_merge(array_keys($modules),['admin']);
 
        $need_module_url_prefix = count($include) !== 1;
        $have_admin_module = array_search('admin', $include);
        if($have_admin_module !== false){
//            unset($include[$have_admin_module]);
            self::loadAdminRouter($routers);
        }
 
        $registered_modules = []; # 
        foreach($modules as $module=>$path){
            if(!in_array($module,$include)) continue;
 
            # 加载模块的配置
            if(is_file($path.'/init.php')) require_once $path.'/init.php';
            
            $registered_modules[$module] = function(){}; // todo
            $prefix = $need_module_url_prefix ? (PA_URL_PATH."$module/") : '/';
            
            $dispatch = ['namespace'=>$module.'\\Controllers', 'module'=>$module, 'controller'=>1];
            $routers[$module]['*'][$prefix.'?([\w0-9\_\-]+)?/?']=$dispatch;
 
            $dispatch['action']=2;
            $routers[$module]['*'][$prefix.':controller/:action']=$dispatch;
 
            $dispatch['params']=3;
            $routers[$module]['*'][$prefix.':controller/:action/:params']=$dispatch;
//            if(PA::$config->module_path){
//                PA::$loader->registerDirs([PA::$config->module_path.'/'.$module.'/library'],true);
//            }
//            PA::$loader->registerNamespaces([
//                $module.'\\Controllers' => $path.'/controllers',
//                $module.'\\Models'      => $path.'/models',
//            ], true);
        }
        return $registered_modules;
    }
 
    public function run($config_file=null){
        if($config_file) $this->init($config_file);
        echo PA::$app->handle($_SERVER["REQUEST_URI"] ?? PA::$args['uri'])->getContent();
//        $response = PA::$app->handle('/');
//        echo "<pre>";
//        echo "是否已经发送:".$response->isSent();
//        echo "内容:[".print_r($response->getContent(),1).']';
//        PA::$app->
//        if(!$response->isSent())
//            $response->send();
//        echo $response->getContent();
//        exit;
//        if(!$response->isSent()){
//            $response->send();
//        }
//        PA::$app->handle();//->send();
//        echo PA::$app->handle()->getContent();//->send();
    }
 
    public function __call($name, $arguments){
        return call_user_func_array([PA::$app,$name], $arguments);
    }
}

<?php
//$pa = require '../../PA/public/index.php';
$pa = require '../../../pa/public/index.php';
 
# 初始化
$pa->init('../config.php');
 
# 日志服务
if(isset(MP::$config['logger'])){
    Logger\Logger::setLevel(MP::$config->path('logger.level'));
    $class = new ReflectionClass(MP::$config->path('logger.logger'));
    Logger\Logger::addLogger($class->newInstanceArgs(MP::$config->path('logger.params')->toArray()));
}
 
# 额外出初始化
#PA::$di->set('url',function(){
#    $url = new Phalcon\Mvc\Url();
#    $url->setBaseUri('/admin/');
#    return $url;
#},true);
# 运行
$pa->run();