Problem with PserverCMS

07/20/2016 22:08 first_master#1
Hello,
I have problem with Web PserverCMS, i finish setup and there's no wrong
but, i get error when i open [Only registered and activated users can see links. Click Here To Register...]

i think this error from Config this is my config i sure there's wrong but i don't know him

Code:
<?php
return [
    /*
     * DEBUG HELPER
     *
        'zenddevelopertools' => [
            'profiler' => [
                'enabled' => true,
            ],
            'toolbar' => [
                'enabled' => true,
            ],
        ],
        'view_manager' => [
            'display_not_found_reason' => true,
            'display_exceptions'       => true,
        ],
    //*/
    'doctrine' => [
        'connection' => [
            'orm_default' => [
                // mssql db @ windows  => 'GameBackend\DBAL\Driver\PDOSqlsrv\Driver'
                // mssql db @ linux  => 'GameBackend\DBAL\Driver\PDODblib\Driver',
                'driverClass' =>'GameBackend\DBAL\Driver\PDOSqlsrv\Driver',
                'params' => [
                    'host'     => 'DESKTOP-6E9V3TC\SQLEXPRESS',
                    'port'     => '3306',
                    'user'     => 'sa',
                    'password' => 'sql@123',
                    'dbname'   => 'pserverCMS2',
                ],
            ],
            'orm_sro_account' => [
                // mssql db @ windows  => 'GameBackend\DBAL\Driver\PDOSqlsrv\Driver'
                // mssql db @ linux  => 'GameBackend\DBAL\Driver\PDODblib\Driver',
                //'driverClass' =>'GameBackend\DBAL\Driver\PDOSqlsrv\Driver',
                'params' => [
                    'host'     => 'DESKTOP-6E9V3TC\SQLEXPRESS',
                    'port'     => '1443',
                    'user'     => 'sa',
                    'password' => 'sql@123',
                    'dbname'   => 'SRO_VT_ACCOUNT',
                ],
            ],
            'orm_sro_shard' => [
                // mssql db @ windows  => 'GameBackend\DBAL\Driver\PDOSqlsrv\Driver'
                // mssql db @ linux  => 'GameBackend\DBAL\Driver\PDODblib\Driver',
                //'driverClass' =>'GameBackend\DBAL\Driver\PDOSqlsrv\Driver',
                'params' => [
                    'host'     => 'DESKTOP-6E9V3TC\SQLEXPRESS',
                    'port'     => '1443',
                    'user'     => 'sa',
                    'password' => 'sql@123',
                    'dbname'   => 'SRO_VT_SHARD',
                ],
            ],
            'orm_sro_log' => [
                // mssql db @ windows  => 'GameBackend\DBAL\Driver\PDOSqlsrv\Driver'
                // mssql db @ linux  => 'GameBackend\DBAL\Driver\PDODblib\Driver',
                //'driverClass' =>'GameBackend\DBAL\Driver\PDOSqlsrv\Driver',
                'params' => [
                    'host'     => 'DESKTOP-6E9V3TC\SQLEXPRESS',
                    'port'     => '1443',
                    'user'     => 'sa',
                    'password' => 'sql@123',
                    'dbname'   => 'SRO_VT_SHARDLOG',
                ],
            ],
        ],
    ],
    'pserver' => [
        'mail' => [
            'from' => '[Only registered and activated users can see links. Click Here To Register...]',
            'basic' => [
                'name' => 'mail.com',
                'host' => 'mail.com',
                'port' => 465,
                'connection_class' => 'login',
                'connection_config' => [
                    'username' => '[Only registered and activated users can see links. Click Here To Register...]',
                    'password' => 'foobar',
                    'ssl'=> 'ssl',
                ],
            ],
        ],
        'timer' => [
            [
                'name' => 'CTF',
                'hours' => [
                    0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23
                ],
                'min' => 30,
                'icon' => 'fa fa-cubes'
            ],
            [
                'name' => 'Medusa',
                'hours' => [
                    1,22,23
                ],
                'min' => 14,
                'icon' => 'fa fa-digg'
            ],
            //'Sunday' | 'Monday' | 'Tuesday' | 'Wednesday' | 'Thursday' | 'Friday' | 'Saturday'
            [
                'name' => 'Fortresswar',
                'days' => [
                    'Wednesday','Monday'
                ],
                'hour' => 8,
                'min' => 14,
                'icon' => 'fa fa-bomb'
            ],
            [
                'name' => 'Register',
                'type' => 'static',
                'time' => 'Saturday 12:00 - 23:00',
                'icon' => 'fa fa-digg'
            ],
        ],
    ],
    'service_manager' => [
        'aliases' => [
            'gamebackend_dataservice' => GameBackend\DataService\SRO::class,
        ],
    ],
];
Thank you
07/21/2016 01:49 Vxo#2
1443 ---> 1433
07/21/2016 09:28 first_master#3
same problem
12/27/2016 17:59 KoKsPfLaNzE#4
problem fixed with [Only registered and activated users can see links. Click Here To Register...]

the main problem is the setup, you missed the step to install `msodbcsql.msi`


or just check my updated guide