1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

unable to assign Centralized DB

Discussion in 'Plesk Expand 2.3 Troubleshooting Issues' started by Tomer Leibovich, May 11, 2009.

  1. Tomer Leibovich

    Tomer Leibovich Guest

    0
     
    Hi,

    I'm trying to assign my Plesk server to the Centralized DB but without success here:
    Unknown or general internal error. Failed to connect to database: Access denied for user 'admin'@'cust-219-83-172.static.bezeqint.net' (using password: YES)

    I've granted permissions and tried assign it from inside the Plesk Panel - using this method it's working, but from Expand it seems to fail over and over.

    Thanks for the help.
     
  2. gold

    gold Regular Pleskian

    25
    57%
    Joined:
    Jan 8, 2008
    Messages:
    307
    Likes Received:
    0
    Please check the centralized database server settings in the Expand`s database by using command:
    Code:
    /usr/local/expand/sbin/expandmysql -e 'select host,port,type,admin_login,admin_password from exp_db_server'
    
     
  3. Tomer Leibovich

    Tomer Leibovich Guest

    0
     
    The settings are the same as the ones that I've set inside the Plesk servers.
    Just to be sure I've reset the password both at the centralized MYSQL and inside the Plesk server.

    No progress here.
     
  4. gold

    gold Regular Pleskian

    25
    57%
    Joined:
    Jan 8, 2008
    Messages:
    307
    Likes Received:
    0
    Please check the XML packet (from problem report) that Expand sends to the Plesk server assigning to CDB.
     
  5. Tomer Leibovich

    Tomer Leibovich Guest

    0
     
    here is the problem report:

    PROBLEM REPORT FOR ACTION #266184
    ==================

    ACTION INPUT
    -------------
    <?xml version="1.0"?>
    <packet version="2.3.2.17">
    <assign>
    <id>15</id>
    <server_id>14</server_id>
    <default></default>
    </assign>
    </packet>

    ACTION OUTPUT
    -------------
    <?xml version="1.0" encoding="UTF-8" standalone="no" ?>
    <packet action_id="266184" version="2.3.2.17">
    <assign>
    <system>
    <status>error</status>
    <errcode>4003</errcode>
    <errtext>[Operator] PleskAgent error. Failed to add DB server to Plesk server #14: (1002) [PleskAgent - GENERAL] Unknown or general internal error. Failed to connect to database: Access denied for user 'admin'@'cust-219-83-172.static.bezeqint.net' (using password: YES).</errtext>
    </system>
    </assign>
    </packet>

    ACTION LOG:
    --------------
    May 13 2009 08:51:02 [:11631] DEBUG: pool: Sending message to parent: 2.
    May 13 2009 08:51:02 CDBOp[:11631] NOTICE: Command 'assign' requested
    May 13 2009 08:51:02 CDBOp[:11631] INFO: Assign DB server function called.
    May 13 2009 08:51:02 [:11631] DEBUG: Start transaction 'DEFAULT'.
    May 13 2009 08:51:02 CDBOp[:11631] DEBUG: Check for Server #14 exists - found.
    May 13 2009 08:51:02 [:11631] DEBUG: Transport for server #14 requested. Creating a new instance.
    May 13 2009 08:51:02 AConnection[:11631] INFO: >> https://62.219.83.172:8443/enterprise/control/agent.php : POST 256 bytes
    May 13 2009 08:51:02 AConnection[:11631] INFO: <?xml version="1.0" encoding="UTF-8" standalone="no" ?><packet version="1.4.2.0"><db_server><add><host>Mysql.uphosting.co.il</host><port>3306</port><type>mysql</type><admin>admin</admin><password>************</password><default/></add></db_server></packet>
    May 13 2009 08:51:06 AConnection[:11631] INFO: << https://62.219.83.172:8443/enterprise/control/agent.php : Response 890 bytes
    May 13 2009 08:51:06 AConnection[:11631] INFO: <packet version="1.4.2.0"><db_server><add><result><status>error</status><errcode>1002</errcode><errtext>Failed to connect to database: Access denied for user 'admin'@'cust-219-83-172.static.bezeqint.net' (using password: YES)</errtext></result></add></db_server><output>C:\Parallels\Plesk\admin\plib\DatabaseManagerMySQL.php:176
    C:\Parallels\Plesk\admin\plib\DatabaseManager.php:335
    C:\Parallels\Plesk\admin\plib\DatabaseServerManager.php:172
    C:\Parallels\Plesk\admin\plib\api-common\DatabaseManipulator.php:292
    C:\Parallels\Plesk\admin\plib\api-rpc\AgentDatabaseServer.php:56
    C:\Parallels\Plesk\admin\plib\api-rpc\PleskAPIOperator.php:106
    C:\Parallels\Plesk\admin\plib\api-rpc\Agent.php:358
    C:\Parallels\Plesk\admin\plib\api-rpc\PleskAPIOperator.php:106
    C:\Parallels\Plesk\admin\plib\api-rpc\Agent.php:184
    C:\Parallels\Plesk\admin\htdocs\enterprise\control\agent.php:22
    </output></packet>
    May 13 2009 08:51:06 [:11631] INFO: PleskAgent system reports no errors.
    May 13 2009 08:51:06 [:11631] DEBUG: Roll back transaction 'DEFAULT'.
    May 13 2009 08:51:06 CDBOp[:11631] ERR: Expand error: [Operator] PleskAgent error. Failed to add DB server to Plesk server #14: (1002) [PleskAgent - GENERAL] Unknown or general internal error. Failed to connect to database: Access denied for user 'admin'@'cust-219-83-172.static.bezeqint.net' (using password: YES).
    May 13 2009 08:51:06 [:11631] DEBUG: All transport instances destroyed.
    May 13 2009 08:51:06 [:11631] DEBUG: Transport instance for server #14 destroyed.
    May 13 2009 08:51:06 [:11631] DEBUG: All transport instances destroyed.
    May 13 2009 08:51:06 CDBOp[:11631] DEBUG: Boss operator finished with code 4003.

    ACTION ERROR:
    --------------

    TASKMAN OUTPUT:
    --------------
    <?xml version="1.0" encoding="UTF-8" standalone="no"?>
    <packet version="0.1.1.0">
    <result>
    <status>error</status>
    <errtxt>Action executed with errors</errtxt>
    </result>
    </packet>
    ==================
    End of the Report
     
  6. gold

    gold Regular Pleskian

    25
    57%
    Joined:
    Jan 8, 2008
    Messages:
    307
    Likes Received:
    0
    Please check entry for Host=cust-219-83-172.static.bezeqint.net and User=admin in mysql.user table on the Mysql.upho sting.co.il server by using command
    Code:
    mysql -uadmin -p -e 'select * from mysql.user\G'
    
     
  7. Tomer Leibovich

    Tomer Leibovich Guest

    0
     
    1. All privileges are permitted.
    2. Server IP is 62.219.83.172 but expand and the mysql server reported it as cust-219-83-172.static.bezeqint.net, how can I change it?
     
  8. gold

    gold Regular Pleskian

    25
    57%
    Joined:
    Jan 8, 2008
    Messages:
    307
    Likes Received:
    0
    You can add the true value to /etc/hosts file.
     
  9. Tomer Leibovich

    Tomer Leibovich Guest

    0
     
    Unfortunately I'm still unable to assing the centralized MYSQL server to my Win Plesk server from Expand.
    I've doubled checked everything - user/pass are correct.
    Please help me solve this issue as my boss is sitting on my head to bring Expand into production, and this issue is holding me.
     
  10. gold

    gold Regular Pleskian

    25
    57%
    Joined:
    Jan 8, 2008
    Messages:
    307
    Likes Received:
    0
    1. Add the database server inside Plesk panel and enable 'Use this server as default' option.
    2. Reload database servers on the 'Plesk Servers > Reload Servers' page inside Expand panel.
     
  11. Tomer Leibovich

    Tomer Leibovich Guest

    0
     
    Denis,
    Thank you for your help.

    I'm encountering now a different issue with Centralized MySQL and Plesk Windows.
    Both servers are running with external network via firewall and internal network without firewall.
    Port 3306 is opened inside the firewall.

    The problem report isn't really helping me here: (Inner network)
    PROBLEM REPORT FOR ACTION #6134
    ==================

    ACTION INPUT
    -------------
    <?xml version="1.0"?>
    <packet version="2.3.2.17">
    <assign>
    <id>7</id>
    <server_id>5</server_id>
    </assign>
    </packet>

    ACTION OUTPUT
    -------------
    <?xml version="1.0" encoding="UTF-8" standalone="no" ?>
    <packet action_id="6134" version="2.3.2.17">
    <assign>
    <system>
    <status>error</status>
    <errcode>4003</errcode>
    <errtext>[Operator] PleskAgent error. Failed to add DB server to Plesk server #5: (1002) [PleskAgent - GENERAL] Unknown or general internal error. Failed to connect to database: Can't connect to MySQL server on '11.0.0.15' (10060).</errtext>
    </system>
    </assign>
    </packet>

    ACTION LOG:
    --------------
    May 27 2009 23:42:14 [:9410] DEBUG: pool: Sending message to parent: 2.
    May 27 2009 23:42:14 CDBOp[:9410] NOTICE: Command 'assign' requested
    May 27 2009 23:42:14 CDBOp[:9410] INFO: Assign DB server function called.
    May 27 2009 23:42:14 [:9410] DEBUG: Start transaction 'DEFAULT'.
    May 27 2009 23:42:14 CDBOp[:9410] DEBUG: Check for Server #5 exists - found.
    May 27 2009 23:42:14 [:9410] DEBUG: Transport for server #5 requested. Creating a new instance.
    May 27 2009 23:42:14 AConnection[:9410] INFO: >> https://91.202.171.28:8443/enterprise/control/agent.php : POST 233 bytes
    May 27 2009 23:42:14 AConnection[:9410] INFO: <?xml version="1.0" encoding="UTF-8" standalone="no" ?><packet version="1.4.2.0"><db_server><add><host>11.0.0.15</host><port>3306</port><type>mysql</type><admin>root</admin><password>************</password></add></db_server></packet>
    May 27 2009 23:42:36 AConnection[:9410] INFO: << https://91.202.171.28:8443/enterprise/control/agent.php : Response 852 bytes
    May 27 2009 23:42:36 AConnection[:9410] INFO: <packet version="1.4.2.0"><db_server><add><result><status>error</status><errcode>1002</errcode><errtext>Failed to connect to database: Can't connect to MySQL server on '11.0.0.15' (10060)</errtext></result></add></db_server><output>C:\Parallels\Plesk\admin\plib\DatabaseManagerMySQL.php:176
    C:\Parallels\Plesk\admin\plib\DatabaseManager.php:335
    C:\Parallels\Plesk\admin\plib\DatabaseServerManager.php:172
    C:\Parallels\Plesk\admin\plib\api-common\DatabaseManipulator.php:292
    C:\Parallels\Plesk\admin\plib\api-rpc\AgentDatabaseServer.php:56
    C:\Parallels\Plesk\admin\plib\api-rpc\PleskAPIOperator.php:106
    C:\Parallels\Plesk\admin\plib\api-rpc\Agent.php:358
    C:\Parallels\Plesk\admin\plib\api-rpc\PleskAPIOperator.php:106
    C:\Parallels\Plesk\admin\plib\api-rpc\Agent.php:184
    C:\Parallels\Plesk\admin\htdocs\enterprise\control\agent.php:22
    </output></packet>
    May 27 2009 23:42:36 [:9410] INFO: PleskAgent system reports no errors.
    May 27 2009 23:42:36 [:9410] DEBUG: Roll back transaction 'DEFAULT'.
    May 27 2009 23:42:36 CDBOp[:9410] ERR: Expand error: [Operator] PleskAgent error. Failed to add DB server to Plesk server #5: (1002) [PleskAgent - GENERAL] Unknown or general internal error. Failed to connect to database: Can't connect to MySQL server on '11.0.0.15' (10060).
    May 27 2009 23:42:36 [:9410] DEBUG: All transport instances destroyed.
    May 27 2009 23:42:36 [:9410] DEBUG: Transport instance for server #5 destroyed.
    May 27 2009 23:42:36 [:9410] DEBUG: All transport instances destroyed.
    May 27 2009 23:42:36 CDBOp[:9410] DEBUG: Boss operator finished with code 4003.

    Problem Report for external network
    PROBLEM REPORT FOR ACTION #6159
    ==================

    ACTION INPUT
    -------------
    <?xml version="1.0"?>
    <packet version="2.3.2.17">
    <assign>
    <id>7</id>
    <server_id>5</server_id>
    </assign>
    </packet>

    ACTION OUTPUT
    -------------
    <?xml version="1.0" encoding="UTF-8" standalone="no" ?>
    <packet action_id="6159" version="2.3.2.17">
    <assign>
    <system>
    <status>error</status>
    <errcode>4003</errcode>
    <errtext>[Operator] PleskAgent error. Failed to add DB server to Plesk server #5: (1002) [PleskAgent - GENERAL] Unknown or general internal error. Failed to connect to database: Can't connect to MySQL server on 'Mysql.uphosting.co.il' (10061).</errtext>
    </system>
    </assign>
    </packet>

    ACTION LOG:
    --------------
    May 27 2009 23:46:54 [:9410] DEBUG: pool: Sending message to parent: 2.
    May 27 2009 23:46:54 CDBOp[:9410] NOTICE: Command 'assign' requested
    May 27 2009 23:46:54 CDBOp[:9410] INFO: Assign DB server function called.
    May 27 2009 23:46:54 [:9410] DEBUG: Start transaction 'DEFAULT'.
    May 27 2009 23:46:54 CDBOp[:9410] DEBUG: Check for Server #5 exists - found.
    May 27 2009 23:46:54 [:9410] DEBUG: Transport for server #5 requested. Creating a new instance.
    May 27 2009 23:46:54 AConnection[:9410] INFO: >> https://91.202.171.28:8443/enterprise/control/agent.php : POST 245 bytes
    May 27 2009 23:46:54 AConnection[:9410] INFO: <?xml version="1.0" encoding="UTF-8" standalone="no" ?><packet version="1.4.2.0"><db_server><add><host>Mysql.uphosting.co.il</host><port>3306</port><type>mysql</type><admin>root</admin><password>************</password></add></db_server></packet>
    May 27 2009 23:46:56 AConnection[:9410] INFO: << https://91.202.171.28:8443/enterprise/control/agent.php : Response 864 bytes
    May 27 2009 23:46:56 AConnection[:9410] INFO: <packet version="1.4.2.0"><db_server><add><result><status>error</status><errcode>1002</errcode><errtext>Failed to connect to database: Can't connect to MySQL server on 'Mysql.uphosting.co.il' (10061)</errtext></result></add></db_server><output>C:\Parallels\Plesk\admin\plib\DatabaseManagerMySQL.php:176
    C:\Parallels\Plesk\admin\plib\DatabaseManager.php:335
    C:\Parallels\Plesk\admin\plib\DatabaseServerManager.php:172
    C:\Parallels\Plesk\admin\plib\api-common\DatabaseManipulator.php:292
    C:\Parallels\Plesk\admin\plib\api-rpc\AgentDatabaseServer.php:56
    C:\Parallels\Plesk\admin\plib\api-rpc\PleskAPIOperator.php:106
    C:\Parallels\Plesk\admin\plib\api-rpc\Agent.php:358
    C:\Parallels\Plesk\admin\plib\api-rpc\PleskAPIOperator.php:106
    C:\Parallels\Plesk\admin\plib\api-rpc\Agent.php:184
    C:\Parallels\Plesk\admin\htdocs\enterprise\control\agent.php:22
    </output></packet>
    May 27 2009 23:46:56 [:9410] INFO: PleskAgent system reports no errors.
    May 27 2009 23:46:56 [:9410] DEBUG: Roll back transaction 'DEFAULT'.
    May 27 2009 23:46:56 CDBOp[:9410] ERR: Expand error: [Operator] PleskAgent error. Failed to add DB server to Plesk server #5: (1002) [PleskAgent - GENERAL] Unknown or general internal error. Failed to connect to database: Can't connect to MySQL server on 'Mysql.uphosting.co.il' (10061).
    May 27 2009 23:46:56 [:9410] DEBUG: All transport instances destroyed.
    May 27 2009 23:46:56 [:9410] DEBUG: Transport instance for server #5 destroyed.
    May 27 2009 23:46:56 [:9410] DEBUG: All transport instances destroyed.
    May 27 2009 23:46:56 CDBOp[:9410] DEBUG: Boss operator finished with code 4003.


    Pleassse help me here
     
  12. Tomer Leibovich

    Tomer Leibovich Guest

    0
     
    got it fixed.
     
Loading...