Copied to clipboard

Flag this post as spam?

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


  • gimp 8 posts 37 karma points
    Jul 03, 2013 @ 11:14
    gimp
    0

    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.

  • Rich Green 2246 posts 4008 karma points
    Jul 03, 2013 @ 11:30
    Rich Green
    1

    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

  • gimp 8 posts 37 karma points
    Jul 03, 2013 @ 11:43
    gimp
    0

    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 :)

  • Jan Skovgaard 11280 posts 23678 karma points MVP 11x admin c-trib
    Jul 03, 2013 @ 11:43
    Jan Skovgaard
    0

    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

  • gimp 8 posts 37 karma points
    Jul 03, 2013 @ 12:55
    gimp
    0

    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...

  • gimp 8 posts 37 karma points
    Jul 03, 2013 @ 13:16
    gimp
    0

    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>

  • Jan Skovgaard 11280 posts 23678 karma points MVP 11x admin c-trib
    Jul 03, 2013 @ 13:54
    Jan Skovgaard
    0

    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 

  • gimp 8 posts 37 karma points
    Jul 03, 2013 @ 14:30
    gimp
    0

    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.

  • Jan Skovgaard 11280 posts 23678 karma points MVP 11x admin c-trib
    Jul 03, 2013 @ 14:46
    Jan Skovgaard
    0

    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

  • gimp 8 posts 37 karma points
    Jul 03, 2013 @ 15:03
    gimp
    0

    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)

  • Rich Green 2246 posts 4008 karma points
    Jul 03, 2013 @ 15:22
    Rich Green
    0

    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

  • gimp 8 posts 37 karma points
    Jul 03, 2013 @ 15:54
    gimp
    0

    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.

  • Jason Prothero 422 posts 1243 karma points MVP c-trib
    Jul 11, 2013 @ 01:41
    Jason Prothero
    101

    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

  • gimp 8 posts 37 karma points
    Jul 11, 2013 @ 14:09
    gimp
    0

    Hi,

    it really helped me a lot. No issue using firefox, manual install, remote sql db.

    Thx.

  • John Singleton 4 posts 24 karma points
    Nov 05, 2013 @ 17:55
    John Singleton
    0

    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.

  • Manoj 1 post 21 karma points
    Nov 13, 2013 @ 19:07
    Manoj
    0

    It does hand on 5% :(

     

    SOLUTION

    Does not work on IE (10) hangs but works on chrome.

     

  • Graeme W 113 posts 289 karma points
    Nov 18, 2013 @ 12:56
    Graeme W
    0

    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

  • Ed 3 posts 23 karma points
    Nov 28, 2013 @ 18:22
    Ed
    0

    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.

  • James Wilkinson 15 posts 72 karma points c-trib
    Apr 24, 2014 @ 17:49
    James Wilkinson
    0

    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.

  • kristian schneider 190 posts 351 karma points
    Oct 09, 2014 @ 11:12
    kristian schneider
    1

    I have also seen this issue if you forget to copy over the updated install folder

  • Matt Tomlinson 1 post 21 karma points
    Jan 05, 2015 @ 22:57
    Matt Tomlinson
    0

    Issue also occurs if you don't have write permissions set on web.config

Please Sign in or register to post replies

Write your reply to:

Draft