Installation hangs at "Connecting to database.. 5%"
Hi,
I'm trying to install Ubraco with Web Platform Installer (also tried manually same issue) After setting the database to a remote server the installation process hangs at 5%, but the connection works because the scripts creates the tables in the database. So the database is populated successfully. According to the UbracoTraceLog.txt everything is fine, but don't know how to move forward from this point.
... 2013-07-03 11:05:10,464 [16] INFO Umbraco.Core.Persistence.Database - [Thread 8] New table 'umbracoUser2NodePermission' was created 2013-07-03 11:05:10,465 [16] INFO Umbraco.Core.Persistence.Database - [Thread 8] Finalized database schema creation 2013-07-03 11:05:10,465 [16] INFO Umbraco.Core.DatabaseContext - [Thread 8] Database configuration status: <p>Installation completed!</p>
Can you tell us a bit about the operating system you're using? Webserver and MSSQL version?
When you tried to install with webmatrix did you then choose it from the installation dialogue? When chosen in webmatrix it should check for all neccesary dependencie - But maybe the MVC framework is missing? I know this seems odd to ask since the error thrown is about the installation of the database but if all the neccesary frameworks and stuff are not in place that can trigger this odd behaviour - it's a long shot...And I'm sorry that you're getting a bad experience using the installer - *it should be easy* but in some situations it's not unfortunately...
Hopefully we'll be able to figure this out together though.
This is a Windows Server 2008R2 standard with IIS Mssql runs on a different 2008R2 and the sql version is also 2008r2, but we can skip that part because the same problem occures with local DB.
I've installed according to the link that you've provided and it did install a few other thing I'm not sure but probably 17. If I start a new install it does not list anything in prerequsites tab. But I can't say that MVC framework is installed properly, if you can give me any hint how to check that it would be great.
Ok, that should be enough to get this installed properly.
Could you try installing through webmatrix once more and on the DB step choose CE SQL the embedded database rather than your database server. If this is succesfull you can try and migrate the db to your real db server afterwards using the webmatrix migration tool.
I did a clean new install with CE SQL to use local DB but with same result still hangs at Connecting to database...
2013-07-03 14:59:23,522 [16] INFO Umbraco.Core.Persistence.Database - [Thread 10] New table 'umbracoUser2NodePermission' was created 2013-07-03 14:59:23,522 [16] INFO Umbraco.Core.Persistence.Database - [Thread 10] Finalized database schema creation 2013-07-03 14:59:23,522 [16] INFO Umbraco.Core.DatabaseContext - [Thread 10] Database configuration status: <p>Installation completed!</p>
but in this file there are some errors too, if you need the whole file I can upload it for you.
SqlCE4Umbraco.SqlCeProviderException: Error running Reader: SQL Statement: select distinct alias from cmsPropertyType order by alias
Exception: System.Data.SqlServerCe.SqlCeException (0x80004005): The specified table does not exist. [ cmsPropertyType ] at System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr) at System.Data.SqlServerCe.SqlCeCommand.CompileQueryPlan() at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options) at System.Data.SqlServerCe.SqlCeCommand.ExecuteReader(CommandBehavior behavior) at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters) at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters) at SqlCE4Umbraco.SqlCEHelper.ExecuteReader(String commandText, SqlCeParameter[] parameters) at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters)
I had the same issue with the installer hanging at 5% in IE9, even though it had created the tables in the database. Switched to Firefox and it reported it had reached 100%.
I had the same experience as John - was stuck at 5% with the tables having been created in the database. Switching to Chrome (from IE) allowed me to get past 5% and complete the installation
I had this issue, which seemed to be because I pre-empted the set up by writing my connection string into the web.config for the UmbracoDSN connection. I'd filled in the connectionstring and provider attributes. I reverted these to empty strings and tried again, allowing the set up wizard to prompt me for this info, it then successfully completed. I think this was the crucial factor, but since I'd recreated my blank DB to test this, there's a slim chance I added extra roles to the user the second time around.
I had the same issue with the v6.1.6 install hanging at 5%. I've tried fresh installs using Chrome, Firefox and IE 11 but I get the same issue each time. I then tried v6.1.5 in each browser and the same thing happened. I then tried v6.1.4 and that installed successfully (in Firefox I think). A quick upgrade to v6.1.6 following the standard instructions and I now have a working v6.1.6 install.
Installation hangs at "Connecting to database.. 5%"
Hi,
I'm trying to install Ubraco with Web Platform Installer (also tried manually same issue)
After setting the database to a remote server the installation process hangs at 5%, but the connection works because the scripts creates the tables in the database.
So the database is populated successfully.
According to the UbracoTraceLog.txt everything is fine, but don't know how to move forward from this point.
...
2013-07-03 11:05:10,464 [16] INFO Umbraco.Core.Persistence.Database - [Thread 8] New table 'umbracoUser2NodePermission' was created
2013-07-03 11:05:10,465 [16] INFO Umbraco.Core.Persistence.Database - [Thread 8] Finalized database schema creation
2013-07-03 11:05:10,465 [16] INFO Umbraco.Core.DatabaseContext - [Thread 8] Database configuration status: <p>Installation completed!</p>
These are the last lines in the TraceLog.txt
Best regards.
Hey,
Welcome to the forum!
The 5% failing is most usually down to DB permissions.
IMHO it's easier to use a local DB to set teh site up, then transfer it to your server after.
Rich
Hi,
thanks for the fast reply I will try to do a clean manual install with local DB.
I hope afterwords I can migrate it to a remote SQL server :)
Hi Gimp
If you don't mind starting out on SQL CE and migrate afterwards the installation has finished succesfully you could perhaps use the webmatrix approach documented here http://our.umbraco.org/documentation/Installation/install-umbraco-with-microsoft-webmatrix
/Jan
Hi,
I've tried to install manually but the installation still hangs at 5%
Umbraco 6.1.2 using local DB - SQL CE
The file under Updata Umbraco.sdf is created.
According to the log:
2013-07-03 12:52:27,527 [13] INFO Umbraco.Core.Persistence.Database - [Thread 12] New table 'umbracoServer' was created
2013-07-03 12:52:27,527 [13] INFO Umbraco.Core.Persistence.Database - [Thread 12] Finalized database schema creation
2013-07-03 12:52:27,528 [13] INFO Umbraco.Core.DatabaseContext - [Thread 12] Database configuration status: <p>Installation completed!</p>
2013-07-03 12:52:27,790 [13] INFO Umbraco.Core.UmbracoApplicationBase - [Thread 16] Application shutdown. Reason: ConfigurationChange
I have really no idea what is wrong, I might try to install it on a different machine...
Installed Umbraco with webmatrix with same result, also hangs at 5% with local database.
This uses 6.0.6 according to the install script
2013-07-03 13:19:36,587 [7] INFO umbraco.presentation.install.utills.p - [Thread 8] Running 'installOrUpgrade' service
2013-07-03 13:19:36,587 [7] INFO Umbraco.Core.DatabaseContext - [Thread 8] Database configuration status: Started
2013-07-03 13:19:36,588 [7] INFO Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 8] Initializing database migrations
2013-07-03 13:19:36,589 [7] INFO Umbraco.Core.DatabaseContext - [Thread 8] Database configuration status: <p>Upgrade completed!</p>
Hi Gimp
Can you tell us a bit about the operating system you're using? Webserver and MSSQL version?
When you tried to install with webmatrix did you then choose it from the installation dialogue? When chosen in webmatrix it should check for all neccesary dependencie - But maybe the MVC framework is missing? I know this seems odd to ask since the error thrown is about the installation of the database but if all the neccesary frameworks and stuff are not in place that can trigger this odd behaviour - it's a long shot...And I'm sorry that you're getting a bad experience using the installer - *it should be easy* but in some situations it's not unfortunately...
Hopefully we'll be able to figure this out together though.
Cheers,
Jan
Hi again :)
This is a Windows Server 2008R2 standard with IIS
Mssql runs on a different 2008R2 and the sql version is also 2008r2, but we can skip that part because the same problem occures with local DB.
I've installed according to the link that you've provided and it did install a few other thing I'm not sure but probably 17.
If I start a new install it does not list anything in prerequsites tab. But I can't say that MVC framework is installed properly, if you can give me any hint how to check that it would be great.
Hi gimp
Ok, that should be enough to get this installed properly.
Could you try installing through webmatrix once more and on the DB step choose CE SQL the embedded database rather than your database server. If this is succesfull you can try and migrate the db to your real db server afterwards using the webmatrix migration tool.
/Jan
I did a clean new install with CE SQL to use local DB but with same result still hangs at Connecting to database...
2013-07-03 14:59:23,522 [16] INFO Umbraco.Core.Persistence.Database - [Thread 10] New table 'umbracoUser2NodePermission' was created
2013-07-03 14:59:23,522 [16] INFO Umbraco.Core.Persistence.Database - [Thread 10] Finalized database schema creation
2013-07-03 14:59:23,522 [16] INFO Umbraco.Core.DatabaseContext - [Thread 10] Database configuration status: <p>Installation completed!</p>
but in this file there are some errors too, if you need the whole file I can upload it for you.
SqlCE4Umbraco.SqlCeProviderException: Error running Reader:
SQL Statement:
select distinct alias from cmsPropertyType order by alias
Exception:
System.Data.SqlServerCe.SqlCeException (0x80004005): The specified table does not exist. [ cmsPropertyType ]
at System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr)
at System.Data.SqlServerCe.SqlCeCommand.CompileQueryPlan()
at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options)
at System.Data.SqlServerCe.SqlCeCommand.ExecuteReader(CommandBehavior behavior)
at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)
at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)
at SqlCE4Umbraco.SqlCEHelper.ExecuteReader(String commandText, SqlCeParameter[] parameters)
at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters)
Hey,
Is Windows Server 2008 your local Dev machine?
I have no idea why you're having so many problems but something strange is going on in your enviroment.
Rich
nope, this is a virtual machine I just tried to test the environment before going to production.
Long story short:
I started with manual install, with remote mssql.
Web Platform Installer remote mssql, local db.
After that I was installing WebMatrix and yes now the server looks like a developer environment :)
But this wasn't on porpuse.
For now I'll have a small break and will try to install on a different machine.
I just had an interesting issue where the installer wouldn't go past 5% on IE8. Installed FireFox on the server and all was good.
Just posting in case it helps someone in the future.
-Jason
Hi,
it really helped me a lot. No issue using firefox, manual install, remote sql db.
Thx.
I had the same issue with the installer hanging at 5% in IE9, even though it had created the tables in the database. Switched to Firefox and it reported it had reached 100%.
Thanks.
It does hand on 5% :(
SOLUTION
Does not work on IE (10) hangs but works on chrome.
I had the same experience as John - was stuck at 5% with the tables having been created in the database. Switching to Chrome (from IE) allowed me to get past 5% and complete the installation
I had this issue, which seemed to be because I pre-empted the set up by writing my connection string into the web.config for the UmbracoDSN connection. I'd filled in the connectionstring and provider attributes. I reverted these to empty strings and tried again, allowing the set up wizard to prompt me for this info, it then successfully completed. I think this was the crucial factor, but since I'd recreated my blank DB to test this, there's a slim chance I added extra roles to the user the second time around.
I had the same issue with the v6.1.6 install hanging at 5%. I've tried fresh installs using Chrome, Firefox and IE 11 but I get the same issue each time. I then tried v6.1.5 in each browser and the same thing happened. I then tried v6.1.4 and that installed successfully (in Firefox I think). A quick upgrade to v6.1.6 following the standard instructions and I now have a working v6.1.6 install.
Hope this helps,
James.
I have also seen this issue if you forget to copy over the updated install folder
Issue also occurs if you don't have write permissions set on web.config
is working on a reply...