Warning (2): pg_connect(): Unable to connect to PostgreSQL server: connection to server at "192.168.4.13", port 5432 failed: FATAL: database "be_velvetbroker_x01_db" does not exist [APP/Config/database.php, line 123]

//            $member = pg_fetch_array($db_member, 0, PGSQL_ASSOC);
//debug($member);
            $con=pg_connect("host=".$host['db_host']." port=".$host['db_port']." dbname=".$host['db_name']." user=".$host['db_login']." password=".$host['db_password']);

$con = resource
$db_host = resource
$host = array(
	'id' => '50',
	'hash' => 'osjkdjklsdfjklfsdjkflsdsdfjksdfjksdfjksdfjk',
	'active' => '1',
	'member_id' => '1',
	'code' => 'velvetbroker',
	'http_host' => 'www.velvetbroker.it',
	'db_name' => 'be_velvetbroker_x01_db',
	'db_host' => '192.168.4.13',
	'db_login' => 'be_velvetbroker',
	'db_password' => '_be_SuperPanda_2023!*',
	'db_port' => '5432',
	'db_name_slave' => 'velvetbroker_temp_db',
	'db_host_slave' => '192.168.4.14',
	'db_login_slave' => 'convieneonline',
	'db_password_slave' => '_-Conviene-_2015!*',
	'db_port_slave' => '5432',
	'website_id' => '1',
	'domain' => 'velvetbroker',
	'scheme' => 'https://',
	'customsettings_id' => '1',
	'pg_server_id' => null,
	'parent_id' => null
)

pg_connect - [internal], line ??
DATABASE_CONFIG::__construct() - APP/Config/database.php, line 123
ConnectionManager::_init() - CORE/Cake/Model/ConnectionManager.php, line 69
ConnectionManager::getDataSource() - CORE/Cake/Model/ConnectionManager.php, line 83
Model::setDataSource() - CORE/Cake/Model/Model.php, line 3659
Model::setSource() - CORE/Cake/Model/Model.php, line 1162
Model::getDataSource() - CORE/Cake/Model/Model.php, line 3686
Model::_readDataSource() - CORE/Cake/Model/Model.php, line 3053
Model::find() - CORE/Cake/Model/Model.php, line 3025
PagesController::verify301() - APP/Controller/Share/PagesController.php, line 6978
include - APP/Config/bootstrap.php, line 272
Configure::bootstrap() - CORE/Cake/Core/Configure.php, line 98
include - CORE/Cake/bootstrap.php, line 432
[main] - APP/webroot/index.php, line 97

Warning (2): pg_query() expects parameter 1 to be resource, bool given [APP/Config/database.php, line 124]

Code Context

//debug($member);
            $con=pg_connect("host=".$host['db_host']." port=".$host['db_port']." dbname=".$host['db_name']." user=".$host['db_login']." password=".$host['db_password']);
            $db=pg_query($con, "select * from customsettings where id=".$host['customsettings_id']);

$con = false
$db_host = resource
$host = array(
	'id' => '50',
	'hash' => 'osjkdjklsdfjklfsdjkflsdsdfjksdfjksdfjksdfjk',
	'active' => '1',
	'member_id' => '1',
	'code' => 'velvetbroker',
	'http_host' => 'www.velvetbroker.it',
	'db_name' => 'be_velvetbroker_x01_db',
	'db_host' => '192.168.4.13',
	'db_login' => 'be_velvetbroker',
	'db_password' => '_be_SuperPanda_2023!*',
	'db_port' => '5432',
	'db_name_slave' => 'velvetbroker_temp_db',
	'db_host_slave' => '192.168.4.14',
	'db_login_slave' => 'convieneonline',
	'db_password_slave' => '_-Conviene-_2015!*',
	'db_port_slave' => '5432',
	'website_id' => '1',
	'domain' => 'velvetbroker',
	'scheme' => 'https://',
	'customsettings_id' => '1',
	'pg_server_id' => null,
	'parent_id' => null
)

pg_query - [internal], line ??
DATABASE_CONFIG::__construct() - APP/Config/database.php, line 124
ConnectionManager::_init() - CORE/Cake/Model/ConnectionManager.php, line 69
ConnectionManager::getDataSource() - CORE/Cake/Model/ConnectionManager.php, line 83
Model::setDataSource() - CORE/Cake/Model/Model.php, line 3659
Model::setSource() - CORE/Cake/Model/Model.php, line 1162
Model::getDataSource() - CORE/Cake/Model/Model.php, line 3686
Model::_readDataSource() - CORE/Cake/Model/Model.php, line 3053
Model::find() - CORE/Cake/Model/Model.php, line 3025
PagesController::verify301() - APP/Controller/Share/PagesController.php, line 6978
include - APP/Config/bootstrap.php, line 272
Configure::bootstrap() - CORE/Cake/Core/Configure.php, line 98
include - CORE/Cake/bootstrap.php, line 432
[main] - APP/webroot/index.php, line 97

Warning (2): pg_fetch_array() expects parameter 1 to be resource, null given [APP/Config/database.php, line 125]

Code Context

            $con=pg_connect("host=".$host['db_host']." port=".$host['db_port']." dbname=".$host['db_name']." user=".$host['db_login']." password=".$host['db_password']);
            $db=pg_query($con, "select * from customsettings where id=".$host['customsettings_id']);
            $customsettings = pg_fetch_array($db, 0, PGSQL_ASSOC);

$con = false
$db_host = resource
$host = array(
	'id' => '50',
	'hash' => 'osjkdjklsdfjklfsdjkflsdsdfjksdfjksdfjksdfjk',
	'active' => '1',
	'member_id' => '1',
	'code' => 'velvetbroker',
	'http_host' => 'www.velvetbroker.it',
	'db_name' => 'be_velvetbroker_x01_db',
	'db_host' => '192.168.4.13',
	'db_login' => 'be_velvetbroker',
	'db_password' => '_be_SuperPanda_2023!*',
	'db_port' => '5432',
	'db_name_slave' => 'velvetbroker_temp_db',
	'db_host_slave' => '192.168.4.14',
	'db_login_slave' => 'convieneonline',
	'db_password_slave' => '_-Conviene-_2015!*',
	'db_port_slave' => '5432',
	'website_id' => '1',
	'domain' => 'velvetbroker',
	'scheme' => 'https://',
	'customsettings_id' => '1',
	'pg_server_id' => null,
	'parent_id' => null
)
$db = null

pg_fetch_array - [internal], line ??
DATABASE_CONFIG::__construct() - APP/Config/database.php, line 125
ConnectionManager::_init() - CORE/Cake/Model/ConnectionManager.php, line 69
ConnectionManager::getDataSource() - CORE/Cake/Model/ConnectionManager.php, line 83
Model::setDataSource() - CORE/Cake/Model/Model.php, line 3659
Model::setSource() - CORE/Cake/Model/Model.php, line 1162
Model::getDataSource() - CORE/Cake/Model/Model.php, line 3686
Model::_readDataSource() - CORE/Cake/Model/Model.php, line 3053
Model::find() - CORE/Cake/Model/Model.php, line 3025
PagesController::verify301() - APP/Controller/Share/PagesController.php, line 6978
include - APP/Config/bootstrap.php, line 272
Configure::bootstrap() - CORE/Cake/Core/Configure.php, line 98
include - CORE/Cake/bootstrap.php, line 432
[main] - APP/webroot/index.php, line 97

Warning (2): Invalid argument supplied for foreach() [APP/Config/database.php, line 127]

Code Context

            $customsettings = pg_fetch_array($db, 0, PGSQL_ASSOC);
//debug($customsettings);
            foreach($customsettings as $key => $customsetting){

$con = false
$db_host = resource
$host = array(
	'id' => '50',
	'hash' => 'osjkdjklsdfjklfsdjkflsdsdfjksdfjksdfjksdfjk',
	'active' => '1',
	'member_id' => '1',
	'code' => 'velvetbroker',
	'http_host' => 'www.velvetbroker.it',
	'db_name' => 'be_velvetbroker_x01_db',
	'db_host' => '192.168.4.13',
	'db_login' => 'be_velvetbroker',
	'db_password' => '_be_SuperPanda_2023!*',
	'db_port' => '5432',
	'db_name_slave' => 'velvetbroker_temp_db',
	'db_host_slave' => '192.168.4.14',
	'db_login_slave' => 'convieneonline',
	'db_password_slave' => '_-Conviene-_2015!*',
	'db_port_slave' => '5432',
	'website_id' => '1',
	'domain' => 'velvetbroker',
	'scheme' => 'https://',
	'customsettings_id' => '1',
	'pg_server_id' => null,
	'parent_id' => null
)
$db = null
$customsettings = null

DATABASE_CONFIG::__construct() - APP/Config/database.php, line 127
ConnectionManager::_init() - CORE/Cake/Model/ConnectionManager.php, line 69
ConnectionManager::getDataSource() - CORE/Cake/Model/ConnectionManager.php, line 83
Model::setDataSource() - CORE/Cake/Model/Model.php, line 3659
Model::setSource() - CORE/Cake/Model/Model.php, line 1162
Model::getDataSource() - CORE/Cake/Model/Model.php, line 3686
Model::_readDataSource() - CORE/Cake/Model/Model.php, line 3053
Model::find() - CORE/Cake/Model/Model.php, line 3025
PagesController::verify301() - APP/Controller/Share/PagesController.php, line 6978
include - APP/Config/bootstrap.php, line 272
Configure::bootstrap() - CORE/Cake/Core/Configure.php, line 98
include - CORE/Cake/bootstrap.php, line 432
[main] - APP/webroot/index.php, line 97

Warning (2): pg_query() expects parameter 1 to be resource, bool given [APP/Config/database.php, line 132]

Code Context

                }    
            }
            $db=pg_query($con, "select * from registries where id=1 limit 1");

$con = false
$db_host = resource
$host = array(
	'id' => '50',
	'hash' => 'osjkdjklsdfjklfsdjkflsdsdfjksdfjksdfjksdfjk',
	'active' => '1',
	'member_id' => '1',
	'code' => 'velvetbroker',
	'http_host' => 'www.velvetbroker.it',
	'db_name' => 'be_velvetbroker_x01_db',
	'db_host' => '192.168.4.13',
	'db_login' => 'be_velvetbroker',
	'db_password' => '_be_SuperPanda_2023!*',
	'db_port' => '5432',
	'db_name_slave' => 'velvetbroker_temp_db',
	'db_host_slave' => '192.168.4.14',
	'db_login_slave' => 'convieneonline',
	'db_password_slave' => '_-Conviene-_2015!*',
	'db_port_slave' => '5432',
	'website_id' => '1',
	'domain' => 'velvetbroker',
	'scheme' => 'https://',
	'customsettings_id' => '1',
	'pg_server_id' => null,
	'parent_id' => null
)
$db = null
$customsettings = null

pg_query - [internal], line ??
DATABASE_CONFIG::__construct() - APP/Config/database.php, line 132
ConnectionManager::_init() - CORE/Cake/Model/ConnectionManager.php, line 69
ConnectionManager::getDataSource() - CORE/Cake/Model/ConnectionManager.php, line 83
Model::setDataSource() - CORE/Cake/Model/Model.php, line 3659
Model::setSource() - CORE/Cake/Model/Model.php, line 1162
Model::getDataSource() - CORE/Cake/Model/Model.php, line 3686
Model::_readDataSource() - CORE/Cake/Model/Model.php, line 3053
Model::find() - CORE/Cake/Model/Model.php, line 3025
PagesController::verify301() - APP/Controller/Share/PagesController.php, line 6978
include - APP/Config/bootstrap.php, line 272
Configure::bootstrap() - CORE/Cake/Core/Configure.php, line 98
include - CORE/Cake/bootstrap.php, line 432
[main] - APP/webroot/index.php, line 97

Warning (2): pg_fetch_array() expects parameter 1 to be resource, null given [APP/Config/database.php, line 133]

Code Context

            }
            $db=pg_query($con, "select * from registries where id=1 limit 1");
            $companies = pg_fetch_array($db, 0, PGSQL_ASSOC);

$con = false
$db_host = resource
$host = array(
	'id' => '50',
	'hash' => 'osjkdjklsdfjklfsdjkflsdsdfjksdfjksdfjksdfjk',
	'active' => '1',
	'member_id' => '1',
	'code' => 'velvetbroker',
	'http_host' => 'www.velvetbroker.it',
	'db_name' => 'be_velvetbroker_x01_db',
	'db_host' => '192.168.4.13',
	'db_login' => 'be_velvetbroker',
	'db_password' => '_be_SuperPanda_2023!*',
	'db_port' => '5432',
	'db_name_slave' => 'velvetbroker_temp_db',
	'db_host_slave' => '192.168.4.14',
	'db_login_slave' => 'convieneonline',
	'db_password_slave' => '_-Conviene-_2015!*',
	'db_port_slave' => '5432',
	'website_id' => '1',
	'domain' => 'velvetbroker',
	'scheme' => 'https://',
	'customsettings_id' => '1',
	'pg_server_id' => null,
	'parent_id' => null
)
$db = null
$customsettings = null

pg_fetch_array - [internal], line ??
DATABASE_CONFIG::__construct() - APP/Config/database.php, line 133
ConnectionManager::_init() - CORE/Cake/Model/ConnectionManager.php, line 69
ConnectionManager::getDataSource() - CORE/Cake/Model/ConnectionManager.php, line 83
Model::setDataSource() - CORE/Cake/Model/Model.php, line 3659
Model::setSource() - CORE/Cake/Model/Model.php, line 1162
Model::getDataSource() - CORE/Cake/Model/Model.php, line 3686
Model::_readDataSource() - CORE/Cake/Model/Model.php, line 3053
Model::find() - CORE/Cake/Model/Model.php, line 3025
PagesController::verify301() - APP/Controller/Share/PagesController.php, line 6978
include - APP/Config/bootstrap.php, line 272
Configure::bootstrap() - CORE/Cake/Core/Configure.php, line 98
include - CORE/Cake/bootstrap.php, line 432
[main] - APP/webroot/index.php, line 97

Warning (2): Invalid argument supplied for foreach() [APP/Config/database.php, line 135]

Code Context

            $companies = pg_fetch_array($db, 0, PGSQL_ASSOC);
//debug($companies);
            foreach($companies as $key => $company){

$con = false
$db_host = resource
$host = array(
	'id' => '50',
	'hash' => 'osjkdjklsdfjklfsdjkflsdsdfjksdfjksdfjksdfjk',
	'active' => '1',
	'member_id' => '1',
	'code' => 'velvetbroker',
	'http_host' => 'www.velvetbroker.it',
	'db_name' => 'be_velvetbroker_x01_db',
	'db_host' => '192.168.4.13',
	'db_login' => 'be_velvetbroker',
	'db_password' => '_be_SuperPanda_2023!*',
	'db_port' => '5432',
	'db_name_slave' => 'velvetbroker_temp_db',
	'db_host_slave' => '192.168.4.14',
	'db_login_slave' => 'convieneonline',
	'db_password_slave' => '_-Conviene-_2015!*',
	'db_port_slave' => '5432',
	'website_id' => '1',
	'domain' => 'velvetbroker',
	'scheme' => 'https://',
	'customsettings_id' => '1',
	'pg_server_id' => null,
	'parent_id' => null
)
$db = null
$customsettings = null
$companies = null

DATABASE_CONFIG::__construct() - APP/Config/database.php, line 135
ConnectionManager::_init() - CORE/Cake/Model/ConnectionManager.php, line 69
ConnectionManager::getDataSource() - CORE/Cake/Model/ConnectionManager.php, line 83
Model::setDataSource() - CORE/Cake/Model/Model.php, line 3659
Model::setSource() - CORE/Cake/Model/Model.php, line 1162
Model::getDataSource() - CORE/Cake/Model/Model.php, line 3686
Model::_readDataSource() - CORE/Cake/Model/Model.php, line 3053
Model::find() - CORE/Cake/Model/Model.php, line 3025
PagesController::verify301() - APP/Controller/Share/PagesController.php, line 6978
include - APP/Config/bootstrap.php, line 272
Configure::bootstrap() - CORE/Cake/Core/Configure.php, line 98
include - CORE/Cake/bootstrap.php, line 432
[main] - APP/webroot/index.php, line 97

Missing Database Connection

Error: A Database connection using "Postgres" was missing or unable to connect.
The database server returned this error: SQLSTATE[08006] [7] connection to server at "192.168.4.13", port 5432 failed: FATAL: database "be_velvetbroker_x01_db" does not exist

Notice: If you want to customize this error message, create app/View/Errors/missing_connection.ctp

Stack Trace

CORE/Cake/Model/Datasource/DboSource.php line 278 → Postgres->connect()

            ));

        }

        if ($autoConnect) {

            $this->connect();

        }

CORE/Cake/Model/ConnectionManager.php line 105 → DboSource->__construct()

                'message' => 'Datasource is not found in Model/Datasource package.'

            ));

        }

        static::$_dataSources[$name] = new $class(static::$config->{$name});

        static::$_dataSources[$name]->configKeyName = $name;

CORE/Cake/Model/Model.php line 3659 → ConnectionManager::getDataSource()

            $this->useDbConfig = $dataSource;

        }



        $db = ConnectionManager::getDataSource($this->useDbConfig);

        if (!empty($oldConfig) && isset($db->config['prefix'])) {

CORE/Cake/Model/Model.php line 1162 → Model->setDataSource()

 * @return void

 */

    public function setSource($tableName) {

        $this->setDataSource($this->useDbConfig);

        $db = ConnectionManager::getDataSource($this->useDbConfig);

CORE/Cake/Model/Model.php line 3686 → Model->setSource()

    public function getDataSource() {

        if (!$this->_sourceConfigured && $this->useTable !== false) {

            $this->_sourceConfigured = true;

            $this->setSource($this->useTable);

        }

CORE/Cake/Model/Model.php line 3053 → Model->getDataSource()

 * @return array

 */

    protected function _readDataSource($type, $query) {

        $results = $this->getDataSource()->read($this, $query);

        $this->resetAssociations();

CORE/Cake/Model/Model.php line 3025 → Model->_readDataSource()

            return null;

        }



        return $this->_readDataSource($type, $query);

    }

APP/Controller/Share/PagesController.php line 6978 → Model->find()

                'AND' => array(
                    'Redirect.active' => 1,
                    'Redirect.website_id' => $this->website_id,
                    'Redirect.old_url' => $url,
                ),

APP/Config/bootstrap.php line 272 → PagesController->verify301()

    App::import('Controller', 'Pages');

    $PagesController = new PagesController;

    $url = $_SERVER["REQUEST_URI"];

    $newurl = $PagesController->verify301($url);

    if(!empty($newurl)){

CORE/Cake/Core/Configure.php line 98 → include(string)

            }

            static::_setErrorHandlers($error, $exception);



            if (!include CONFIG . 'bootstrap.php') {

                trigger_error(__d('cake_dev',

'/var/www/www.velvetbroker.it/app/Config/bootstrap.php'

CORE/Cake/bootstrap.php line 432 → Configure::bootstrap()



}



Configure::bootstrap(isset($boot) ? $boot : true);

APP/webroot/index.php line 97 → include(string)

    if (function_exists('ini_set')) {

        ini_set('include_path', ROOT . DS . 'lib' . PATH_SEPARATOR . ini_get('include_path'));

    }

    if (!include 'Cake' . DS . 'bootstrap.php') {

        $failed = true;

'/var/www/www.velvetbroker.it/lib/Cake/bootstrap.php'