Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


These support forums are now closed for new topics and comments.
Please head on over to http://eureka.ucommerce.net/ for support.

  • Sean Dooley 289 posts 528 karma points
    May 17, 2011 @ 12:08
    Sean Dooley
    0

    Can't create a product - Login failed for user

    I have installed uCommerce but keeping getting the message, "Login failed for user" when I am trying to create a product - I am not sure what permissions to set or where to set the permissions?

    Thanks in advance for an help

  • Søren Spelling Lund 1797 posts 2786 karma points
    May 17, 2011 @ 12:31
    Søren Spelling Lund
    0

    Hi Sean,

    Are you getting any useful info in umbracoLog?

    Also which version of Umbraco/uCommerce are you running?

  • Sean Dooley 289 posts 528 karma points
    May 17, 2011 @ 12:55
    Sean Dooley
    0

    Hi Soren

    Here is the information from the umbracoLog

    At /umbraco/create.aspx?nodeId=ProductCatalog&nodeType=Catalog_Root&nodeName=Product%20Catalog&rnd=42.1&rndo=43 (Referred by: http://localhost:56567/umbraco/create.aspx?nodeId=ProductCatalog&nodeType=Catalog_Root&nodeName=Product Catalog&rnd=42.1&rndo=43): System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'root'.
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
       at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject)
       at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout)
       at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
       at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
       at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
       at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
       at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
       at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
       at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
       at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
       at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
       at System.Data.SqlClient.SqlConnection.Open()
       at SubSonic.DataProviders.DbDataProvider.CreateConnection(String connectionString)
       at SubSonic.DataProviders.DbDataProvider.CreateConnection()
       at SubSonic.DataProviders.AutomaticConnectionScope..ctor(IDataProvider provider)
       at SubSonic.DataProviders.DbDataProvider.ExecuteReader(QueryCommand qry)
       at SubSonic.Linq.Structure.DbQueryProvider.Execute[T](QueryCommand`1 query, Object[] paramValues)
       at lambda_method(Closure )
       at SubSonic.Linq.Structure.DbQueryProvider.Execute(Expression expression)
       at SubSonic.Linq.Structure.QueryProvider.System.Linq.IQueryProvider.Execute[S](Expression expression)
       at System.Linq.Queryable.Any[TSource](IQueryable`1 source, Expression`1 predicate)
       at UCommerce.Entities.ProductCatalogGroup.Exists(Expression`1 expression)
       at UCommerceWeb.Umbraco.UCommerce.Catalog.CreateProductCatalogGroup.UniqueNameValidator_ServerValidate(Object source, ServerValidateEventArgs args)
       at System.Web.UI.WebControls.CustomValidator.OnServerValidate(String value)
       at System.Web.UI.WebControls.CustomValidator.EvaluateIsValid()
       at System.Web.UI.WebControls.BaseValidator.Validate()
       at System.Web.UI.Page.Validate()
       at System.Web.UI.Page.Validate(String validationGroup)
       at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
       at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler...

    And also

    At /favicon.ico (Referred by: ): 

    I have installed uCommerce 1.5.1.0 with uCommerce Store 1.1.1.0, and the site is running off a MySQL database.

  • Søren Spelling Lund 1797 posts 2786 karma points
    May 17, 2011 @ 13:22
    Søren Spelling Lund
    0

    uCommerce 1.0 doesn't support MySql. SQL Server Express is free also and supports a wider featureset and MySql.

    uCommerce 2.0 would in theory support MySql, but we've only had a single request for MySql support so far, so we haven't invested in doing it.

    Sorry about the inconvenience.

  • Sean Dooley 289 posts 528 karma points
    May 17, 2011 @ 13:27
    Sean Dooley
    0

    I would prefer to work with MSSQL but my current employers setup uses MySql - alot more hassle then it is actually worth as quite a few good packages only support MSSQL.

    Will keep my fingers crossed.

    Thanks for your help Soren, greatly appreciated.

  • Chono 1 post 21 karma points
    Jul 10, 2011 @ 00:17
    Chono
    0

    +1 on MySql compatibility.

  • Søren Spelling Lund 1797 posts 2786 karma points
    Aug 02, 2011 @ 11:46
    Søren Spelling Lund
    0

    Thanks for the suggesting the feature. it greatly helps us prioritize new features for uCommerce. Keep up the good work.

Please Sign in or register to post replies

Write your reply to:

Draft