After upgrade to Plesk 11 having this Error

[anthony2610]

After upgrading to Plesk 11, I try to create a new database and New Database User but I can not use Webadmin. When I try to click Webadmin button, i have new window and show this Error:

Error

MySQL said: Documentation
Cannot connect: invalid settings.


I still have problems, so can you help me?

Thanks!!!

 

[IgorG]

Do you have any related error messages in /var/log/sw-cp-server/error_log ?

 

[thangloi]

I have error as you and i sent log:

PHP Warning: mysql_close() expects parameter 1 to be resource, boolean given; File: /usr/local/psa/admin/plib/DatabaseManagerMySQL.php, Line: 243

Exception: PHP Warning: mysql_close() expects parameter 1 to be resource, boolean given; File: /usr/local/psa/admin/plib/DatabaseManagerMySQL.php, Line: 243

file: /usr/local/psa/admin/smb/application/library/Smb/Exception/Syntax.php
line: 55
code: 0
trace: #0 [internal function]: Smb_Exception_Syntax::handleError(2, 'mysql_close() e...', '/usr/local/psa/...', 243, Array)
#1 /usr/local/psa/admin/plib/DatabaseManagerMySQL.php(243): mysql_close(false)
#2 /usr/local/psa/admin/plib/DatabaseManagerMySQL.php(261): DatabaseManagerMySQL->bug115166(Resource id #152)
#3 /usr/local/psa/admin/plib/DatabaseManagerMySQL.php(55): DatabaseManagerMySQL->isDatabaseNameUsedImpl('d20606942974ffd...', Resource id #152)
#4 /usr/local/psa/admin/plib/DatabaseManager.php(405): DatabaseManagerMySQL->createDatabaseImpl('d20606942974ffd...', Array, Resource id #152)
#5 /usr/local/psa/admin/htdocs/server/db_server_databases.php(88): DatabaseManager->testConnection()
#6 {main}


2012-07-11 12:23:14: (mod_fastcgi.c.2746) FastCGI-stderr: PHP Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Premature end of data (mysqlnd_wireprotocol.c:553); File: /usr/local/psa/admin/plib/DatabaseManagerMySQL.php, Line: 235

Exception: PHP Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Premature end of data (mysqlnd_wireprotocol.c:553); File: /usr/local/psa/admin/plib/DatabaseManagerMySQL.php, Line: 235

file: /usr/local/psa/admin/smb/application/library/Smb/Exception/Syntax.php
line: 55
code: 0
trace: #0 [internal function]: Smb_Exception_Syntax::handleError(2, 'mysql_connect()...', '/usr/local/psa/...', 235, Array)
#1 /usr/local/psa/admin/plib/DatabaseManagerMySQL.php(235): mysql_connect('localhost:3306', 'bug115166_17658', 'BUG115166_75940...')
#2 /usr/local/psa/admin/plib/DatabaseManagerMySQL.php(261): DatabaseManagerMySQL->bug115166(Resource id #392)
#3 /usr/local/psa/admin/plib/DatabaseManagerMySQL.php(55): DatabaseManagerMySQL->isDatabaseNameUsedImpl('admin_test', Resource id #392)
#4 /usr/local/psa/admin/plib/DatabaseManager.php(72): DatabaseManagerMySQL->createDatabaseImpl('admin_test', Array, Resource id #392)
#5 /usr/local/psa/admin/smb/application/library/Smb/Form/Final/Database.php(205): DatabaseManager->createDatabase(Object(Database))
#6 /usr/local/psa/admin/smb/application/controllers/DatabaseController.php(182): Smb_Form_Final_Database->processForm()
#7 /usr/local/psa/admin/plib/Zend/Controller/Action.php(513): DatabaseController->createAction()
#8 /usr/local/psa/admin/plib/Zend/Controller/Dispatcher/Standard.php(295): Zend_Controller_Action->dispatch('createAction')
#9 /usr/local/psa/admin/plib/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#10 /usr/local/psa/admin/smb/application/library/Smb/Application/Web.php(48): Zend_Controller_Front->dispatch(NULL)
#11 /usr/local/psa/admin/smb/application/public/index.php(15): Smb_Application_Web->run()
#12 {main}

Thanks !!

Thangloi

 

[abdi]

Do you have in #/etc/hosts

127.0.0.1 hostname.com hostname localhost localhost.localdomain