Results 1 to 3 of 3

Thread: Zend/SQL Configuration Issue

  1. #1
    jb14 is offline Junior Member
    Join Date
    Aug 2012
    Posts
    4

    Default Zend/SQL Configuration Issue

    Hello All,
    I am getting a Zend_Db_Adapter permissions error that occurs on the live site. This only happens to certain users as I have never received it and cannot replicate this error. Once they receive this error, it seems they are locked out on the current machine they are on. I've had them try to clear browsing history, cookies, etc. and they still receive error. I can log on with their username just fine on my end. I am not the original developer of this site, but this issue began after a server upgrade/migration.

    The environment is set properly in application.ini and does have a password (the username on the server is not root, only for the development(local) server is it root)
    I do not understand why it is 'using pw: no' because the sql user is set up with same password on the server
    I find it very odd that only certain users receive this error.

    Fatal error: Uncaught exception 'Zend_Db_Adapter_Exception' with message 'SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: NO)' in /home/nnlcom/library/Zend/Db/Adapter/Pdo/Abstract.php:144 Stack trace: #0 /home/nnlcom/library/Zend/Db/Adapter/Pdo/Mysql.php(96): Zend_Db_Adapter_Pdo_Abstract->_connect() #1 /home/nnlcom/library/Zend/Db/Adapter/Abstract.php(832): Zend_Db_Adapter_Pdo_Mysql->_connect() #2 /home/nnlcom/library/Zend/Db/Adapter/Abstract.php(902): Zend_Db_Adapter_Abstract->quote('groups', NULL) #3 /home/nnlcom/library/Zend/Db/Select.php(930): Zend_Db_Adapter_Abstract->quoteInto('name = ?', 'groups', NULL) #4 /home/nnlcom/library/Zend/Db/Select.php(463): Zend_Db_Select->_where('name = ?', 'groups', NULL, true) #5 /home/nnlcom/application/models/Widgets.php(107): Zend_Db_Select->where('name = ?', 'groups') #6 /home/nnlcom/application/Bootstrap.php(39): Model_Widgets->getWidgetId('groups') #7 /home/nnlcom/library/Zend/Application/Bootstrap/BootstrapAbstract.php(660): Bootstrap->_initUse in /home/nnlcom/library/Zend/Db/Adapter/Pdo/Abstract.php on line 144
    This error occurs in the bootstrap file at the first point of trying to make connection to db.

    Does anyone have ideas/clues/steps in the right direction for resolving this error?
    Let me know if anyone needs more info.

    Thanks in advance.

  2. #2
    us2n4m2 is offline Junior Member
    Join Date
    Jul 2012
    Posts
    3

    Default

    Hi,

    Check your environment with this instruction in the Bootstrap.php
    var_dump($this->getEnvironment());

    What does it say ?
    Last edited by us2n4m2; 08-02-2012 at 10:52 PM.

  3. #3
    jb14 is offline Junior Member
    Join Date
    Aug 2012
    Posts
    4

    Default

    It does say production.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •