Copied to clipboard

Flag this post as spam?

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


  • Frederik Petersen 2 posts 22 karma points
    Aug 07, 2010 @ 21:43
    Frederik Petersen
    0

    First time Umbraco setup includes log

    Hi guys, i tried to setup Umbraco for the very first time.
    As many others, i also have a problem with setting up the connection to the mysql server.

    I have posted a log at pastebin, i can't identify the problem myself, because i'm not that advanced of a user.
    So my question is if anyone please could take a couple of minues of their time and take a look at my logfile, and try to explain what i could do to fix this issue.

    By the way, i'm trying to install the CMS trough Microsoft Web platform Installer 3.0.

    Link to the logfile:
    http://pastebin.com/w1fGseef

    Thanks!

  • Sascha Wolter 615 posts 1101 karma points
    Aug 07, 2010 @ 22:19
    Sascha Wolter
    0

    Frederik,

    I had a very brief look (without saying that I understand much of what is going on there), I find it odd that you don't have a password in your connection string

    data source=localhost;initial catalog=danieldk_db;user id=danieldk_db;pooling=False

    which might explain why Umbraco can't connect to the datasource. I don't have any experience with mysql server, but in the php admin (or whatever interface you are using) can you also just login with user 'danieldk_db' and see if you can access the db properly? I know that MS SQL has some suprises waiting after a fresh setup which I regularly fall victim of (like enabling TCP/IP and pipeline connections), so it's sometimes worth the while going a step back and analysing if the database is accessible etc. in the required fashion.

    Secondly would you mind translating this (crucial) bit as I'm afraid I can't understand it (from 'Der opstod...'):

    The database 'danieldk_db' could not be created. 
    ---> System.Data.SqlClient.SqlException: Der opstod en 
    netværksrelateret eller forekomstspecifik fejl, da det blev forsøgt at 
    oprette forbindelse til SQL Server. Serveren blev ikke fundet, eller der
     var ikke adgang til den. Kontroller, at forekomstnavnet er korrekt, og 
    at SQL Server er konfigureret til at tillade fjernforbindelser. 
    (provider: Navngivet pipe-provider, error: 40 - Der kunne ikke åbnes en 
    forbindelse til SQL Server.)

    It looks pretty much like connections via the internal pipeline are not allowed...

    Thanks very much,
    Sascha

  • Frederik Petersen 2 posts 22 karma points
    Aug 07, 2010 @ 23:19
    Frederik Petersen
    0

    First of all i would like to say, thank you for looking at my problem.. (sorry for taking so long to answer, had troubles with the screenshots)

    The translation you requested:
    There was a network related or specific error, when there was a attempt to create a connection to the SQL Server. The server was not found, or there wasent any access to it. Please check that the name is correct, and that the SQL server is configured to allow remote connections. (it allows remote connections)

    Provider: named pipe-provider, error 40 - there couldnt be opened a connection to the SQL server. pipe error?

    I'm very new at mysql and asp.net, but this is what i tried so far:

    1. Downloading Umbraco form Microsoft Web Gallery
    (& installed several programs that comes with the platform installer, as like: Microsoft SQL server 2008, Microsoft Visual Studio 2010 Express & microsoft webmatrix :
    http://www.microsoft.com/web/gallery/install.aspx?appsxml=&appid=Umbraco


    2. After i downloaded it, and it process to the installationen i choose which web server i would like to use:
     I tried Webmatrix, but i figured that it might be better with: Internet Information Services 7.


    3. Where the troubles come in. I have serveral fields that i have to fill, and i might need some information that i don't know where to find.

    phpmyadmin/mysql info:
    http://img17.imageshack.us/img17/4006/phpmyadmin.png

     


    Step 1 of 2: Enter your site information:

    http://img530.imageshack.us/img530/5084/step1m.png

     

    Step 2 of 2 Enter application information:

    http://img340.imageshack.us/i/step2t.png/

     

    error:
    http://img514.imageshack.us/img514/3929/errorzk.png

    If you could help me filling out the form correctly then i couldnt thank you enough.

  • Sascha Wolter 615 posts 1101 karma points
    Aug 09, 2010 @ 13:26
    Sascha Wolter
    0

    Hi Frederik,

    it looks pretty much like Umbraco cannot create a connection to the database because named pipes are not enabled as transport mechanism. Now I'm afraid that I have absolutely no plan of MySQL whatsoever, I found this though on disabling TCP/IP and enabling named pipes for your MySQL installation:
    http://dev.mysql.com/tech-resources/articles/securing_mysql_windows.html
    I am completely unsure though if you can only have named pipes when you disable TCP/IP, because if I remember correctly then Umbraco needs both. However before I go rambling on about what I don't really know it might be easiest if somebody with a running MySQL installation would have a look.

    As to your fields just a couple of suggestions:
    'Location of your database server' will be localhost as displayed in your PHP admin screen shot
    'Umbraco CMS Application name': don't think you will go wrong with 'Umbraco'
    Web site name: whatever you want to call your web site, e.g. danieldk_website (this is just a lable for IIS I assume)
    'Physical path': this is quite important, you have to tell the installer where to put the files for the web site, e.g. c:\inetpub\wwwroot\danieldk_website
    IP Address and host name settings: if you don't have any other web site running on your PC it should be alright with using 'all unassigned', '80' and 'localhost'

    If there is no specific reason for using MySQL I would consider switching to MS SQL Express if you have trouble getting it to work. I know that there are very detailed descriptions in the install docs highlighted above for installing it with SQL Express.

    Hope that helps,
    Sascha

Please Sign in or register to post replies

Write your reply to:

Draft