Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
I upgraded to Umbraco 6.0.3 and Contour to 3.0.9 (using the update zip). I use MySQL database.
Now when I am trying to open Forms tree node in Contour section I get error:
[Win32Exception (0x80004005): Access is denied]
[SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +6675286
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +688
System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, Boolean withFailover) +6701832
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover) +219
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout) +6703968
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance) +6704427
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions) +610
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) +1049
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions) +74
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnectionOptions userOptions) +6706995
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnectionOptions userOptions) +78
System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) +2192
System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) +116
System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) +1012
System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) +6711619
System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) +152
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter commandParameters) +94
umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteReader(String commandText, SqlParameter parameters) +26
umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter parameters) +161
Comment author was deleted
In v6 it isn't using the appSetting but the con string is moved to an actual con string so you'll have to update that
So in <connectionStrings> you'll need one with the name umbracoDbDSN (there is probably a default that is set to ms sql)
It is within ConnectionStrings section of web.config.
<add name="umbracoDbDSN" connectionString="server=xxx;database=xxx;user id=xxx;password=xxx;" providerName="MySql.Data.MySqlClient" />
BTW in the source code of FormStorage.cs (inspected using ReSharper) I can see here and there piece of code:
Doesn't it mean that Courier is still relying on the old connection string format??
If I try to add datalayer=mysql into the connection string, then data layer returns an error
"ERROR umbraco.DataLayer.SqlHelper`1[[MySql.Data.MySqlClient.MySqlParameter, MySql.Data, Version=18.104.22.168, Culture=neutral, PublicKeyToken=c5687fc88969c44d]] - [Thread 91] Error executing query select id from umbracoUser where userLogin = @login System.ArgumentException: Keyword not supported."
Do you still have the original appsetting from before the upgrade, what happens if you place that in the new umbracoDbDSN constring ?
Yeah you are right looks like Contour will need some updates to work on MySQL with umbraco v6
Added to the issue tracker: http://issues.umbraco.org/issue/CON-332
Solution will be part of 3.0.10 (next maintenance release) that should be out before 1 May
(to answer your previous question - as I mentioned, if I try to put the old appsetting string into connectionString I get an error "keyword not supported" and just can't login to Umbraco admin at all. Also it does not make any difference if the old umbracoDbDSN appsetting exists under appSettings or not.
I'm trying to get contour installed and working using MySQL and Umbraco 6.0.3 - it's still looking for a SQL Server?
Is this not fixed yet?
Hey Rob, yup issue is still open, should be part of a maintenance release coming this month
Is there any update?
The issue still occurs on 6.1.3 (!)
Yeah still in issue, will take a look for next maintenance release, will try to do this week
This would be great - it becomes annoying as this is the only issue preventing us to migrate to v6.
Ok will update you later this week, hopefully it isn't that hard to fix :)
Is there a bug opened on this issue so I could track its progress?
Yeah you can find it here http://issues.umbraco.org/issue/CON-332
Any update, please?
No luck so far but more details tomorrow hope to have something ready then
Ok made some progress hope to have a build ready today/tomorrow that should work on mysql, it would be awesome if you could give that a test, will post more details when the build is ready
Ok think I got it working, if any of you could test to confirm that would be great :)
You can get a WIP version here http://nightly.umbraco.org/Umbraco%20Contour/3.0.15%20WIP/ that has the fixes
Anyone able to test this one?
Will do today,thank you.
UPD: works like a charm. Tested on 6.1.3 with MySQL.
@Gleb thanks for confirming :)
Tested and working under v6.0.6 with MySQL 5.5
Many thanks Tim!
@Rob great thanks for testing and confirming the fix :) will release a new Contour version that has the fix this week :)
3.0.15 is out today (includes the mysql fixes) http://our.umbraco.org/forum/umbraco-pro/contour/44376-Contour-3015-changes
is working on a reply...
Write your reply to:
Image will be uploaded when post is submitted