Any MS SQL experts here?
I need help with something. :pullhair:
|
yep :) Fire away
|
I'm really hoping you can help here. :)
I'm trying to install Screwturn Wiki 5: http://sunhorizon.info/Help.InstallSqlServer But I keep running into tons of errors. Do you have your own Windows dev environment where you can test this? (preferably Windows 2012 R2, SQL Express 2014) It would be good to see if somebody else can successfully install this on their own servers. And no, I've not discounted the possibility that this isn't just a PEBKEC/id10t error just yet. :laugh: The instructions at the STW5 site are not at all newbie-friendly, and the current dev is not very responsive. I've not developed anything that requires ASP.NET or SQL in more than 6 years now. (We've been doing everything in PHP and MySQL in recent years. Partially because it's easier, partially because that's just where everything is going nowadays.) So I'm just guessing, and it's not going well. I think the error is in my manual SQL setup. Even before 2009, since 2006, we've been spoiled by Plesk. So I've not created anything manually in almost 10 years now. This is the latest issue: Code:
Server Error in '/wiki5' Application. v5 flat files version relies on SQL Compact (SQLCE), but there seems to be an issue with SQLCE and Windows 2012 IIS8. From what I was reading, it has to be recompiled from source, and that's really out of question as well. via PM, I can look to give you some various minor access to our IIS7 test server, though the best approach would be simply in helping me go step-by-step to properly manually config the database -- assuming that's the issue. We'd even be willing to buy a cheap Windows 2012 R2 VPS for a month, if you're sure that this can be done. Then we can give you admin/RDP access to it. Perhaps set it up local first. Still able/willing to help? :) Update: I think the database is correct now. This is the new error: Code:
Server Error in '/wiki5' Application. |
Did you edit your web.config?
Code:
<add key="SettingsStorageProviderConfig" value="Data Source=(local);Initial Catalog={dbnamehere};User ID=wiki_user;Password={password};" /> Update: ok I see you did that step |
1 Attachment(s)
Since we have managed support from LiquidWeb, I asked them about this last night. After testing the script themselves, and arriving at the same issue, they believe the problem lies with either the 'SqlServerProviders.dll' (ie, it's not compatible with current SQL Express versions), or with Windows 2012 R2 IIS8, or perhaps even with 32-bit vs. 64-bit OS.
The developer claims it works on 2008, but I've not gotten anywhere with 2008 R2 IIS7.5 either. The main project page is here: https://stw.codeplex.com/SourceContr...ssemblyInfo.cs The source code is available, though I'm not skilled enough to edit it, and recompile it. |
That zip stopped at 4MB, and the spot in the source is https://stw.codeplex.com/SourceContr...rverProviders/
I'm getting Code:
Global Settings Storage Provider must be specified in the Web.congfig file. I can compile it. |
The server attachment download stalled for you at 4mb? Odd. But I do know that it can sometimes happen when your ISP is dropping packets. That even happens to me.
Both myself and LiquidWeb think that the instructions are wrong. I know this for a fact with the SQL CE "flat file" (not really a flat file) version. The SQL string should be Code:
<add key="GlobalSettingsStorageProviderConfig" value="Data Source=localhost\SQLEXPRESS;Initial Catalog=ScrewTurnWiki;User ID=wiki_user;Password=password;" /> The web.config look even more wrong for the SQL edition, as SQL CE commands are seemingly still around. Both I and LiquidWeb techs played with that, and we only ran into more errors. Your link is bringing up some sort of index, not what you had intended. If you could correct whatever is wrong, and recompile it, that would be incredibly helpful. Right now, we're working on the third major revision for this site. The SQL version of Screwturn may be an integral part of it. The SQL CE version will collapse under our traffic, so it's sadly not an option. Do you have somewhere that you can test this? Either Windows Server 2012, or at least a Windows 8.1 desktop? |
(local) is a thing, see
https://blogs.msdn.com/b/sql_protoco...edirected=true Quote:
I have everything installed here. I think I grasp this stuff. I think it works in the right circumstances because there's a test harness in the source and presumably they wouldn't release it if the tests didn't work. I'd like to run the unit tests myself and see if they work. If all else fails, I can hardcode the connection string and compile a new dll (which is exactly what they do in the tests; all the code is written for this, I just have to copy/paste stuff). If that works, then at least we know the thing can work, then it's a matter of finding out why it's not reading the config. I could simply make a version to read our own config and leave it at that. At the moment I'm getting Quote:
And here it is (source code written in C# from StartupTools.cs, which implements a class method): Code:
/// <summary> Code:
<appSettings> |
Quote:
|
I've found that another setting at least tries to connect to database;
Code:
<add key="GlobalSettingsStorageProviderConfig" value="Server=.\SQLEXPRESS;User ID=sa;Password=password;Database=screwturn;Initial Catalog=screwturn"/> You can use Data Source= or Server= and then localhost\sqlexpress or .\sqlexpress or (local), then to pick the database you use Database= or Initial Catalog=. I found that if I supply the wrong password, I get a wrong password error, which tells me that it's actually connecting. In this way I can prove which server and credential settings work. Now the only point at which I'm stuck, is I always get "The system cannot find the file specified", which seems to hint to me that the only thing left that could be wrong, is the database name. In this case I would experiment with short, all lowercase database names. It theoretically could be a firewall or remote connection issue, but since I tried (local) as well as server location strings, that's probably not it. I haven't found exactly the code which reads the connection string, but I think it starts here: Code:
globalSettingsStorageProvider.SetUp(Host.Instance, GetGlobalSettingsStorageProviderConfiguration()); I found the code, pretty sure the GlobalSettingsStorageProviderConfig is the only one that matters. Connection strings are standard, so you can look those up anywhere. I'm installing visual studio so I can see what config it's reading, and if that's right, then I'll write a small program to open the database and see if I can figure out what's wrong. ps don't think you need a database expert, more like c# asp web backend developer. -- merged -- Good news, I found the problem. I compiled it, and found out what it was reading for a config. It's missing the database part (Database=). I don't know why yet, but I can fix it with our own file. Problem is, that might be readable from the web server so it's safer to hardcode it. I'll leave it in a private. -- merged -- ok, I forced the config string and it's still not working, now to write a small program to open a database. |
I'm really glad that you're looking in this. You're really good with code, and if anybody can figure with out, it may be you. :)
I've been having some advanced conversations with fellow video restorationists recently, and your name came up. We were talking about that software TBC. We have some new ideas on how you continue that. I looked at the code myself, and it was promising. I want to contact you about that in about a month, when I have a bit more free time. |
Any update on this?
The STW5 dev finally got back to me: (1) Oddly, he did not mention SQL at all. (2) He mentioned that SQL CE can be tricky to install. (However, the traffic limitation of CE will be too low for this site. All that effort to get it working, and it was all mostly-wasted effort. We can demo STW5, be in-production use is out.) (3) He asked about MySQL, and stated adding it back is viable. I have a STW3 mod that I offered him, in my last email. He said the STW3 devs removed it from STW2. I suggested that an open-source project needs an open-source database (MySQL, not SQL). Hopefully he's looking into it. The last email took 3 weeks to respond to. At least it's something, but I'm not 100% confident. Looking closer at the server, SQL made a database, added some tables, then failed without a specific error. Yet another 2012 dev server has been setup, and I'll look to test it when I have some time. |
Site design, images and content © 2002-2024 The Digital FAQ, www.digitalFAQ.com
Forum Software by vBulletin · Copyright © 2024 Jelsoft Enterprises Ltd.