« Previous Next »

Thread: Webplatform installer - Acquia drupla installation failed, could not create db

Last post 11-11-2009 12:05 PM by krolson. 3 replies.

Average Rating Rate It (5)

RSS

Page 1 of 1 (4 items)

Sort Posts:

  • 09-08-2009, 9:00 AM

    Webplatform installer - Acquia drupla installation failed, could not create db

    [14:55:234]The database 'drupal' could not be created.. Retrying operation 'Add' on object dbMySql (uid=drupaluser;Pwd=drupaluser;Database=drupal;Server=localhost). Attempt 2 of 5. Details: originalMessage: The database 'drupal' could not be created. operationType: Add retryAttempt: 2 retryCount: 5 [14:55:234]The database 'drupal' could not be created.. Retrying operation 'Add' on object dbMySql (uid=drupaluser;Pwd=drupaluser;Database=drupal;Server=localhost). Attempt 3 of 5. Details: originalMessage: The database 'drupal' could not be created. operationType: Add retryAttempt: 3 retryCount: 5 [14:55:234]The database 'drupal' could not be created.. Retrying operation 'Add' on object dbMySql (uid=drupaluser;Pwd=drupaluser;Database=drupal;Server=localhost). Attempt 4 of 5. Details: originalMessage: The database 'drupal' could not be created. operationType: Add retryAttempt: 4 retryCount: 5 [14:55:234]The database 'drupal' could not be created.. Retrying operation 'Add' on object dbMySql (uid=drupaluser;Pwd=drupaluser;Database=drupal;Server=localhost). Attempt 5 of 5. Details: originalMessage: The database 'drupal' could not be created. operationType: Add retryAttempt: 5 retryCount: 5 EXCEPTION: Microsoft.Web.Deployment.DeploymentException: The database 'drupal' could not be created. ---> MySql.Data.MySqlClient.MySqlException: Access denied for user 'drupaluser'@'localhost' (using password: YES) at MySql.Data.MySqlClient.MySqlStream.OpenPacket() at MySql.Data.MySqlClient.NativeDriver.Authenticate411() at MySql.Data.MySqlClient.NativeDriver.Authenticate() at MySql.Data.MySqlClient.NativeDriver.Open() at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection() at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver() at MySql.Data.MySqlClient.MySqlPool.GetConnection() at MySql.Data.MySqlClient.MySqlConnection.Open() at Microsoft.Web.Deployment.DBInfo.CreateDatabase() --- End of inner exception stack trace --- at Microsoft.Web.Deployment.DeploymentObject.Add(DeploymentObject source, DeploymentSyncContext syncContext) at Microsoft.Web.Deployment.DeploymentSyncContext.SyncChildren(DeploymentObject dest, DeploymentObject source) at Microsoft.Web.Deployment.DeploymentSyncContext.SyncChildrenOrder(DeploymentObject dest, DeploymentObject source) at Microsoft.Web.Deployment.DeploymentSyncContext.SyncChildren(DeploymentObject dest, DeploymentObject source) at Microsoft.Web.Deployment.DeploymentSyncContext.ProcessSync(DeploymentObject destinationObject, DeploymentObject sourceObject) at Microsoft.Web.Deployment.DeploymentObject.SyncToInternal(DeploymentObject destObject, DeploymentSyncOptions syncOptions, PayloadTable payloadTable, ContentRootTable contentRootTable) at Microsoft.Web.Deployment.DeploymentObject.SyncTo(DeploymentProviderOptions providerOptions, DeploymentBaseOptions baseOptions, DeploymentSyncOptions syncOptions) at Microsoft.Web.Deployment.DeploymentObject.SyncTo(String provider, String path, DeploymentBaseOptions baseOptions, DeploymentSyncOptions syncOptions) at Microsoft.Web.Deployment.DeploymentObject.SyncTo(DeploymentWellKnownProvider provider, String path, DeploymentBaseOptions baseOptions, DeploymentSyncOptions syncOptions) at Microsoft.Web.Deployment.DeploymentObject.SyncTo(DeploymentBaseOptions baseOptions, DeploymentSyncOptions syncOptions) at Microsoft.Web.PlatformInstaller.MsDeployProxy.Install(InstallerItemInstallContext context, RemoteCredentials remoteCredentials)
  • 09-11-2009, 4:04 PM In reply to

    • krolson
    • Top 75 Contributor
    • Joined on 10-06-2008, 10:32 PM
    • Posts 102

    Re: Webplatform installer - Acquia drupla installation failed, could not create db

    Based on this message, it looks like you may have chosen to "Use existing database" rather than "Create new database"? This would always fail unless the database already exists and has the specified user.  Could you please try again and confirm that you see this message when creating a new database (this is the second setting when you enter application information), or explain the database situation you are targeting?

    If you are still seeing this error, it may be possible that the password for the MySql administrator is incorrect.

    You can check the administrator (root) password by opening the MySql command client: Start > All Programs > MySQL > MySQL Server 5.1 > MySQL Command Line Client

    This will prompt you for the password - if you enter the correct password, the window will remain and "Welcom to the MySQL monitor [...]" will appear.

  • 11-02-2009, 12:24 PM In reply to

    Re: Webplatform installer - Acquia drupla installation failed, could not create db

    I tried to create a new database but it failed every time here is the log: [10:11:630]Performing synchronization pass #1. [10:11:631]Parameter entry 'Application Path/1' is applicable to 'iisApp/acquia-drupal' because of its scope. Details: name: Application Path [10:11:631]Parameter entry 'SetAclParameter1/1' is applicable to 'setAcl/acquia-drupal/sites/default' because of its scope. Details: name: SetAclParameter1 [10:11:632]Parameter entry 'Connection String/1' is applicable to 'dbMySql/install.sql' because of its scope. Details: name: Connection String [10:11:636]Adding MSDeploy.iisApp (MSDeploy.iisApp). Details: operationType: Add providerName: MSDeploy.iisApp path: MSDeploy.iisApp [10:11:637]Source createApp (acquia-drupal) does not match destination (FullOrbit/acquia-drupal) differing in attributes (isDest,managedRuntimeVersion['',''],enable32BitAppOnWin64['',''],managedPipelineMode['',''],applicationPool,appExists). Update pending. [10:11:637]Updating createApp (FullOrbit/acquia-drupal). Details: operationType: Update providerName: createApp path: FullOrbit/acquia-drupal [10:11:946]Parameter entry 'db_url in default settings php/1' is applicable to 'acquia-drupal\sites\default\settings.php' because of its scope. Details: name: db_url in default settings php [10:11:946]Source filePath (acquia-drupal\sites\default\settings.php) does not match destination (FullOrbit/acquia-drupal\sites\default\settings.php) differing in attributes (size['9485','9484']). Update pending. [10:11:946]Source filePath (acquia-drupal\sites\default\settings.php) replaced with changed attributes (size['9485','9491']) because of rule Parameterization. Details: rule: Parameterization [10:11:946]Updating filePath (FullOrbit/acquia-drupal\sites\default\settings.php). Details: operationType: Update providerName: filePath path: FullOrbit/acquia-drupal\sites\default\settings.php [10:11:969]Source setAcl (acquia-drupal/sites/default) does not match destination (FullOrbit/acquia-drupal/sites/default) differing in attributes (isDest,setAclUser,setAclAccess). Update pending. [10:11:969]Updating setAcl (FullOrbit/acquia-drupal/sites/default). Details: operationType: Update providerName: setAcl path: FullOrbit/acquia-drupal/sites/default [10:11:973]Adding dbMySql (uid=DarkLightning;database=FullOrbit;server=localhost;allow user variables=True). Details: operationType: Add providerName: dbMySql path: uid=DarkLightning;database=FullOrbit;server=localhost;allow user variables=True [10:11:973]Creating database 'FullOrbit'. [10:11:976]The database 'FullOrbit' could not be created. Retrying operation 'Add' on object dbMySql (uid=DarkLightning;database=FullOrbit;server=localhost;allow user variables=True). Attempt 1 of 5. Details: originalMessage: The database 'FullOrbit' could not be created. operationType: Add retryAttempt: 1 retryCount: 5 [10:11:976]Creating database 'FullOrbit'. [10:11:978]The database 'FullOrbit' could not be created. Retrying operation 'Add' on object dbMySql (uid=DarkLightning;database=FullOrbit;server=localhost;allow user variables=True). Attempt 2 of 5. Details: originalMessage: The database 'FullOrbit' could not be created. operationType: Add retryAttempt: 2 retryCount: 5 [10:11:978]Creating database 'FullOrbit'. [10:11:980]The database 'FullOrbit' could not be created. Retrying operation 'Add' on object dbMySql (uid=DarkLightning;database=FullOrbit;server=localhost;allow user variables=True). Attempt 3 of 5. Details: originalMessage: The database 'FullOrbit' could not be created. operationType: Add retryAttempt: 3 retryCount: 5 [10:11:980]Creating database 'FullOrbit'. [10:11:982]The database 'FullOrbit' could not be created. Retrying operation 'Add' on object dbMySql (uid=DarkLightning;database=FullOrbit;server=localhost;allow user variables=True). Attempt 4 of 5. Details: originalMessage: The database 'FullOrbit' could not be created. operationType: Add retryAttempt: 4 retryCount: 5 [10:11:982]Creating database 'FullOrbit'. [10:11:984]The database 'FullOrbit' could not be created. Retrying operation 'Add' on object dbMySql (uid=DarkLightning;database=FullOrbit;server=localhost;allow user variables=True). Attempt 5 of 5. Details: originalMessage: The database 'FullOrbit' could not be created. operationType: Add retryAttempt: 5 retryCount: 5 [10:11:17]Creating database 'FullOrbit'. EXCEPTION: Microsoft.Web.Deployment.DeploymentException: The database 'FullOrbit' could not be created. ---> MySql.Data.MySqlClient.MySqlException: Access denied for user 'DarkLightning'@'localhost' (using password: YES) at MySql.Data.MySqlClient.MySqlStream.OpenPacket() at MySql.Data.MySqlClient.NativeDriver.Authenticate411() at MySql.Data.MySqlClient.NativeDriver.Open() at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver() at MySql.Data.MySqlClient.MySqlPool.GetConnection() at MySql.Data.MySqlClient.MySqlConnection.Open() at Microsoft.Web.Deployment.DBInfo.CreateDatabase(Int32 timeout) --- End of inner exception stack trace --- at Microsoft.Web.Deployment.DeploymentObject.Add(DeploymentObject source, DeploymentSyncContext syncContext) at Microsoft.Web.Deployment.DeploymentSyncContext.HandleAdd(DeploymentObject destObject, DeploymentObject sourceObject) at Microsoft.Web.Deployment.DeploymentSyncContext.SyncChildren(DeploymentObject dest, DeploymentObject source) at Microsoft.Web.Deployment.DeploymentSyncContext.SyncChildrenOrder(DeploymentObject dest, DeploymentObject source) at Microsoft.Web.Deployment.DeploymentSyncContext.ProcessSync(DeploymentObject destinationObject, DeploymentObject sourceObject) at Microsoft.Web.Deployment.DeploymentObject.SyncToInternal(DeploymentObject destObject, DeploymentSyncOptions syncOptions, PayloadTable payloadTable, ContentRootTable contentRootTable) at Microsoft.Web.Deployment.DeploymentObject.SyncTo(DeploymentProviderOptions providerOptions, DeploymentBaseOptions baseOptions, DeploymentSyncOptions syncOptions) at Microsoft.Web.Deployment.DeploymentObject.SyncTo(DeploymentBaseOptions baseOptions, DeploymentSyncOptions syncOptions) at Microsoft.Web.PlatformInstaller.MSDeployProxy.Install(InstallerContext context, RemoteCredentials remoteCredentials)
  • 11-11-2009, 12:05 PM In reply to

    • krolson
    • Top 75 Contributor
    • Joined on 10-06-2008, 10:32 PM
    • Posts 102

    Re: Webplatform installer - Acquia drupla installation failed, could not create db

    It looks like you are having authorization issues, have you tried confirming that the user id and password you are providing for the MySql database are working (see previous post for how to check this)?

    You must specify the credentials for the MySql database administrator/root account in order to create a new database.

Page 1 of 1 (4 items)
Microsoft Communities