Database Exception
An internal server error occurred.
The above error occurred while the Web server was processing your request.
Please contact us if you think this is a server error. Thank you.
В логи апача ничего не падает.
В potgresql выставил логирование всех запросов - результат :
Код: Выделить всё
2015-01-01 16:36:49 MSK ERROR: permission denied for relation visitor
2015-01-01 16:36:49 MSK STATEMENT: SELECT * FROM "visitor"
2015-01-01 16:36:49 MSK LOG: statement: DEALLOCATE pdo_stmt_00000001
Конфиг yii - config/db.php
Код: Выделить всё
return [
'class' => 'yii\db\Connection',
'dsn' => 'pgsql:host=localhost;port=5432;dbname=xxx',
'username' => 'xxx',
'password' => '12345',
'charset' => 'utf8',
/* 'schemaMap' => [
'pgsql'=> [
'class'=>'yii\db\pgsql\Schema',
'defaultSchema' => 'public' //specify your schema here
]
],*/
];
Код: Выделить всё
# Database administrative login by Unix domain socket
local all postgres trust
local all sprut trust
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
host all all ::1/128 trust
# Allow replication connections from localhost, by a user with the
# replication privilege.
#local replication postgres trust
#host replication postgres 127.0.0.1/32 trust
#host replication postgres ::1/128 trust
Код: Выделить всё
exception 'PDOException' with message 'could not find driver' in /var/www/vhosts/yesiam.loc/vendor/yiisoft/yii2/db/Connection.php:579
Stack trace:
#0 /var/www/vhosts/yesiam.loc/vendor/yiisoft/yii2/db/Connection.php(579): PDO->__construct('pgsql:host=loca...', 'yesiam', '12345678', NULL)
#1 /var/www/vhosts/yesiam.loc/vendor/yiisoft/yii2/db/Connection.php(529): yii\db\Connection->createPdoInstance()
#2 /var/www/vhosts/yesiam.loc/vendor/yiisoft/yii2/db/Connection.php(836): yii\db\Connection->open()
#3 /var/www/vhosts/yesiam.loc/vendor/yiisoft/yii2/db/Connection.php(823): yii\db\Connection->getMasterPdo()
#4 /var/www/vhosts/yesiam.loc/vendor/yiisoft/yii2/db/Command.php(208): yii\db\Connection->getSlavePdo()
#5 /var/www/vhosts/yesiam.loc/vendor/yiisoft/yii2/db/Command.php(815): yii\db\Command->prepare(true)
#6 /var/www/vhosts/yesiam.loc/vendor/yiisoft/yii2/db/Command.php(350): yii\db\Command->queryInternal('fetchAll', NULL)
#7 /var/www/vhosts/yesiam.loc/vendor/yiisoft/yii2/db/Query.php(206): yii\db\Command->queryAll()
#8 /var/www/vhosts/yesiam.loc/vendor/yiisoft/yii2/db/ActiveQuery.php(130): yii\db\Query->all(NULL)
#9 /var/www/vhosts/yesiam.loc/models/Visitor.php(19): yii\db\ActiveQuery->all()
#10 /var/www/vhosts/yesiam.loc/controllers/SiteController.php(55): app\models\Visitor::xxx()
#11 [internal function]: app\controllers\SiteController->actionIndex()
#12 /var/www/vhosts/yesiam.loc/vendor/yiisoft/yii2/base/InlineAction.php(55): call_user_func_array(Array, Array)
#13 /var/www/vhosts/yesiam.loc/vendor/yiisoft/yii2/base/Controller.php(151): yii\base\InlineAction->runWithParams(Array)
#14 /var/www/vhosts/yesiam.loc/vendor/yiisoft/yii2/base/Module.php(455): yii\base\Controller->runAction('', Array)
#15 /var/www/vhosts/yesiam.loc/vendor/yiisoft/yii2/web/Application.php(83): yii\base\Module->runAction('', Array)
#16 /var/www/vhosts/yesiam.loc/vendor/yiisoft/yii2/base/Application.php(375): yii\web\Application->handleRequest(Object(yii\web\Request))
#17 /var/www/vhosts/yesiam.loc/web/index.php(12): yii\base\Application->run()
#18 {main}
Next exception 'yii\db\Exception' with message 'could not find driver' in /var/www/vhosts/yesiam.loc/vendor/yiisoft/yii2/db/Connection.php:534
Stack trace:
#0 /var/www/vhosts/yesiam.loc/vendor/yiisoft/yii2/db/Connection.php(836): yii\db\Connection->open()
#1 /var/www/vhosts/yesiam.loc/vendor/yiisoft/yii2/db/Connection.php(823): yii\db\Connection->getMasterPdo()
#2 /var/www/vhosts/yesiam.loc/vendor/yiisoft/yii2/db/Command.php(208): yii\db\Connection->getSlavePdo()
#3 /var/www/vhosts/yesiam.loc/vendor/yiisoft/yii2/db/Command.php(815): yii\db\Command->prepare(true)
#4 /var/www/vhosts/yesiam.loc/vendor/yiisoft/yii2/db/Command.php(350): yii\db\Command->queryInternal('fetchAll', NULL)
#5 /var/www/vhosts/yesiam.loc/vendor/yiisoft/yii2/db/Query.php(206): yii\db\Command->queryAll()
#6 /var/www/vhosts/yesiam.loc/vendor/yiisoft/yii2/db/ActiveQuery.php(130): yii\db\Query->all(NULL)
#7 /var/www/vhosts/yesiam.loc/models/Visitor.php(19): yii\db\ActiveQuery->all()
#8 /var/www/vhosts/yesiam.loc/controllers/SiteController.php(55): app\models\Visitor::xxx()
#9 [internal function]: app\controllers\SiteController->actionIndex()
#10 /var/www/vhosts/yesiam.loc/vendor/yiisoft/yii2/base/InlineAction.php(55): call_user_func_array(Array, Array)
#11 /var/www/vhosts/yesiam.loc/vendor/yiisoft/yii2/base/Controller.php(151): yii\base\InlineAction->runWithParams(Array)
#12 /var/www/vhosts/yesiam.loc/vendor/yiisoft/yii2/base/Module.php(455): yii\base\Controller->runAction('', Array)
#13 /var/www/vhosts/yesiam.loc/vendor/yiisoft/yii2/web/Application.php(83): yii\base\Module->runAction('', Array)
#14 /var/www/vhosts/yesiam.loc/vendor/yiisoft/yii2/base/Application.php(375): yii\web\Application->handleRequest(Object(yii\web\Request))
#15 /var/www/vhosts/yesiam.loc/web/index.php(12): yii\base\Application->run()
#16 {main}
Additional Information:
Драйверы pdo и pdo_pgsql есть и они enabled
Спасибо.