postgresql - FOSUserBundle login form database conection after server move -
i having issue symfony2 , not quite sure causing issue, using fosuserbundle handle login, , registration. moved code new server , working login page. getting fallowing error on login page.
sqlstate[08006] [7] not connect server: permission denied server running on host "" , accepting tcp/ip connections on port 5432?
i using postgres , can psql server know not permissions issue. since new server tested pdo connection test file , worked.
any ideas on issue be?
test file.
<?php try { $dbh = new pdo('pgsql:host=host;dbname=dbname', 'user', 'password'); echo 'connected database'; } catch(pdoexception $e) { echo $e->getmessage(); } ?> anyone have ideas on issue is?
stack trace
stack trace in /var/www/html/portal/vendor/doctrine/dbal/lib/doctrine/dbal/driver/pdoconnection.php @ line 36 - { public function __construct($dsn, $user = null, $password = null, array $options = null) { parent::__construct($dsn, $user, $password, $options); $this->setattribute(pdo::attr_statement_class, array('doctrine\dbal\driver\pdostatement', array())); $this->setattribute(pdo::attr_errmode, pdo::errmode_exception); } @ pdo ->__construct ('pgsql:host=testdb04.cctus.com port=5432 dbname=contourportal ', 'contour_owner', 'owner', array()) in /var/www/html/portal/vendor/doctrine/dbal/lib/doctrine/dbal/driver/pdoconnection.php @ line 36 + @ pdoconnection ->__construct ('pgsql:host=value port=5432 dbname=value ', value', '', array()) in /var/www/html/portal/vendor/doctrine/dbal/lib/doctrine/dbal/driver/pdopgsql/driver.php @ line 26 + @ driver ->connect (array('dbname' => 'value', 'host' => 'value', 'port' => '5432', 'user' => 'contour_owner', 'password' => 'valuer', 'charset' => 'utf8', 'driver' => 'pdo_pgsql', 'driveroptions' => array()), 'contour_owner', 'owner', array()) in /var/www/html/portal/vendor/doctrine/dbal/lib/doctrine/dbal/connection.php @ line 350 + @ connection ->connect () in /var/www/html/portal/vendor/doctrine/dbal/lib/doctrine/dbal/connection.php @ line 627 + @ connection ->executequery ('select t0.username username1, t0.username_canonical username_canonical2, t0.email email3, t0.email_canonical email_canonical4, t0.enabled enabled5, t0.salt salt6, t0.password password7, t0.last_login last_login8, t0.locked locked9, t0.expired expired10, t0.expires_at expires_at11, t0.confirmation_token confirmation_token12, t0.password_requested_at password_requested_at13, t0.roles roles14, t0.credentials_expired credentials_expired15, t0.credentials_expire_at credentials_expire_at16, t0.id id17, t0.billing_entity_id billing_entity_id18 contour_portal_users t0 t0.username_canonical = ?', array('admin'), array('string')) in /var/www/html/portal/vendor/doctrine/orm/lib/doctrine/orm/persisters/basicentitypersister.php @ line 844 + @ basicentitypersister ->loadall (array('usernamecanonical' => 'admin'), null, null, null) in /var/www/html/portal/vendor/doctrine/orm/lib/doctrine/orm/entityrepository.php @ line 157 + @ entityrepository ->findby (array('usernamecanonical' => 'admin')) in /var/www/html/portal/vendor/symfony/symfony/src/symfony/bridge/doctrine/validator/constraints/uniqueentityvalidator.php @ line 106 + @ uniqueentityvalidator ->validate (object(user), object(uniqueentity)) in /var/www/html/portal/vendor/symfony/symfony/src/symfony/component/validator/executioncontext.php @ line 276 + @ executioncontext ->executeconstraintvalidators (object(user), array(object(uniqueentity), object(uniqueentity))) in /var/www/html/portal/vendor/symfony/symfony/src/symfony/component/validator/executioncontext.php @ line 241 + @ executioncontext ->validatevalue (object(user), array(object(uniqueentity), object(uniqueentity))) in /var/www/html/portal/vendor/symfony/symfony/src/symfony/component/validator/validationvisitor.php @ line 110 + @ validationvisitor ->visit (object(classmetadata), object(user), 'registration', 'data') in /var/www/html/portal/vendor/symfony/symfony/src/symfony/component/validator/mapping/classmetadata.php @ line 107 + @ classmetadata ->accept (object(validationvisitor), object(user), 'registration', 'data') in /var/www/html/portal/vendor/symfony/symfony/src/symfony/component/validator/validationvisitor.php @ line 162 + @ validationvisitor ->validate (object(user), 'registration', 'data', true, false) in /var/www/html/portal/vendor/symfony/symfony/src/symfony/component/validator/executioncontext.php @ line 227 + @ executioncontext ->validate (object(user), 'data', 'registration', true) in /var/www/html/portal/vendor/symfony/symfony/src/symfony/component/form/extension/validator/constraints/formvalidator.php @ line 60 + @ formvalidator ->validate (object(form), object(form)) in /var/www/html/portal/vendor/symfony/symfony/src/symfony/component/validator/executioncontext.php @ line 276 + @ executioncontext ->executeconstraintvalidators (object(form), array(object(form))) in /var/www/html/portal/vendor/symfony/symfony/src/symfony/component/validator/executioncontext.php @ line 241 + @ executioncontext ->validatevalue (object(form), array(object(form))) in /var/www/html/portal/vendor/symfony/symfony/src/symfony/component/validator/validationvisitor.php @ line 110 + @ validationvisitor ->visit (object(classmetadata), object(form), 'default', '') in /var/www/html/portal/vendor/symfony/symfony/src/symfony/component/validator/mapping/classmetadata.php @ line 107 + @ classmetadata ->accept (object(validationvisitor), object(form), 'default', '') in /var/www/html/portal/vendor/symfony/symfony/src/symfony/component/validator/validationvisitor.php @ line 162 + @ validationvisitor ->validate (object(form), 'default', '', false, false) in /var/www/html/portal/vendor/symfony/symfony/src/symfony/component/validator/validator.php @ line 90 + @ validator ->validate (object(form)) in /var/www/html/portal/vendor/symfony/symfony/src/symfony/component/form/extension/validator/eventlistener/validationlistener.php @ line 55 + @ validationlistener ->validateform (object(formevent)) @ call_user_func (array(object(validationlistener), 'validateform'), object(formevent)) in kernel.root_dir/cache/dev/classes.php @ line 1664 + @ eventdispatcher ->dodispatch (array(array(object(validationlistener), 'validateform')), 'form.post_bind', object(formevent)) in kernel.root_dir/cache/dev/classes.php @ line 1597 + @ eventdispatcher ->dispatch ('form.post_bind', object(formevent)) in /var/www/html/portal/vendor/symfony/symfony/src/symfony/component/eventdispatcher/immutableeventdispatcher.php @ line 42 + @ immutableeventdispatcher ->dispatch ('form.post_bind', object(formevent)) in /var/www/html/portal/vendor/symfony/symfony/src/symfony/component/form/form.php @ line 624 + @ form ->submit (object(request)) in /var/www/html/portal/vendor/symfony/symfony/src/symfony/component/form/form.php @ line 638 + @ form ->bind (object(request)) in /var/www/html/portal/vendor/friendsofsymfony/user-bundle/fos/userbundle/controller/registrationcontroller.php @ line 52 + @ registrationcontroller ->registeraction (object(request)) @ call_user_func_array (array(object(registrationcontroller), 'registeraction'), array(object(request))) in kernel.root_dir/bootstrap.php.cache @ line 2774 + @ httpkernel ->handleraw (object(request), '1') in kernel.root_dir/bootstrap.php.cache @ line 2748 + @ httpkernel ->handle (object(request), '1', true) in kernel.root_dir/bootstrap.php.cache @ line 2878 + @ containerawarehttpkernel ->handle (object(request), '1', true) in kernel.root_dir/bootstrap.php.cache @ line 2179 + @ kernel ->handle (object(request)) in /var/www/html/portal/web/app_dev.php @ line 29 +
my issue centos issue reason selinux blocking requests out. when disabled started working.
Comments
Post a Comment