Page 1 of 2
Wanted: Armitage
Posted: Sun Feb 01, 2015 6:16 pm
by Nephris
Hi folks,
hope everything is fine.
Is your Irish man Armitage still alive & kickin and around here?
I died several times trying to get the great stats script working ,he wrote for our Online sessions, which are already more than 14 months ago, and which we really enjoyed.
However I am just too stupid in Sql things and hope he can give me a hand, as we could use it quiet well.
So I hope Armitage is still around then and there and we can make a date for setting up the script together
Greetz Nephris
Re: Wanted: Armitage
Posted: Sun Feb 01, 2015 6:35 pm
by :FI:Armitage
I'm still here just been busy.
What issues are you having ?
Re: Wanted: Armitage
Posted: Mon Feb 02, 2015 12:44 pm
by Nephris
Hi m8,
great to read form you, thx.
Well I tried several times to get the Mysql stuff installed and the databases and so the script running.
The problem is I am receiving error messages and tbh I just dont know what I actually do, as I ve no clue in MySql.
I am able to install a database via MyphpAdmin but that is already the most far end I guess.
So I even dont get the tools running which are needed to run the script correctly.
Would it be possible to meet in TS an evening?
I guess the qiuckes way would be remote desktop access?
Is Win8 or Win7 fine enough to run the script and the tools?
Re: Wanted: Armitage
Posted: Mon Feb 02, 2015 5:55 pm
by :FI:Armitage
I can meet you on TS.
but you need Microsoft SQL (Express will do ) not MySQL.
Any windows environment should work.
Re: Wanted: Armitage
Posted: Mon Feb 02, 2015 7:50 pm
by Nephris
Great.
Would Wednesday evening be fine?
20:00h your time?
Re: Wanted: Armitage
Posted: Mon Feb 02, 2015 8:33 pm
by :FI:Armitage
Wednesday is not good. how about Thursday 8:30 GMT ?
Re: Wanted: Armitage
Posted: Mon Feb 02, 2015 9:22 pm
by Nephris
Basically Thursday would be fine, although I am hosting the weekly coop session during that time.
I will quit the session as the stats got higher priority atm
and join your TS at 8:30h GMT on thursday then.
Is there any pw on your TS?
Re: Wanted: Armitage
Posted: Wed Feb 04, 2015 3:16 pm
by :FI:Armitage
no password on the public channel.
Re: Wanted: Armitage
Posted: Thu Feb 05, 2015 1:57 pm
by Nephris
Just did a quick teste via the TS Viewer on your website and it is asking for a password
vs25.tserverhq.com:6315
Just in case something will go wrong or you are checking this post lately, I add our TS adress aswell in which I would be
nephris.ddns.net
Catch later this evening , SQL Server 2014 (english) and IIS are installed so far.
Is it fine for you to work with
Teamvieweras "on-klick-VPN" Remote Administration?
No need to install, as it works directly from the executeable.
edit: am in the Take off Shoes Channel of your TS, presented on your website ts viewer. Hope that is the correct one.
Re: Wanted: Armitage
Posted: Thu Feb 05, 2015 9:52 pm
by Nephris
I was waiting until 8:50 GMT in your TS.
Hope you will still make it, but I switch back to our TS,
so maybe you want to pick me up there and we ll move to a private channel.
nephris.ddns.net
Re: Wanted: Armitage
Posted: Fri Feb 06, 2015 8:12 pm
by :FI:Armitage
nephris so sorry. There were some production issues in work so I was working rather late and totally forgot you.
How about Saturday or Sunday 19:30 GMT ?
Re: Wanted: Armitage
Posted: Fri Feb 06, 2015 9:03 pm
by Nephris
No problem. RL is always priority.
Tomorrow evening should be fine.
I ll be there.
Re: Wanted: Armitage
Posted: Sat Feb 07, 2015 9:49 pm
by Nephris
Guess you meant sunday and less saturday
Re: Wanted: Armitage
Posted: Sun Feb 08, 2015 5:22 pm
by Nephris
I got most of the stuff running, however it ends in error messages, when calling the default.aspx.
The databse is actually running...when I did everything correct. The LogParser did aswell its job.
But the big end comes at the stats web.
ASP was registered and installed. I added a user with access to ilsstats DB called "IIS APPPOOL\DefaultAppPool", which fixed the
Login failed for user 'IIS APPPOOL\DefaultAppPool'. error.
However the war doesnt seem to be done by that...
Right now I receive
Could not find stored procedure 'RepHighLevelOverview'.
Code: Select all
[SqlException (0x80131904): Could not find stored procedure 'RepHighLevelOverview'.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +388
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +815
System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4515
System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +69
System.Data.SqlClient.SqlDataReader.get_MetaData() +134
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +6553981
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) +6556619
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +586
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +104
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +288
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +237
IL2SWAUtilities.DataAccess.RunSP(String StoredProcedureName, String[] parameters, Object[] arguments) in C:\work\il2\IL2SWA.DataAccess\DataAccess.cs:37
IL2SWA._default.Page_Load(Object sender, EventArgs e) in C:\work\il2\il2statsweb\default.aspx.cs:19
System.Web.UI.Control.LoadRecursive() +71
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3178
The problem is I have not much clue of what I am doing besides granting permission etc.
I guess the error is a short fix, but in try&error it is quiet hard to hunt it down.
Re: Wanted: Armitage
Posted: Sun Feb 08, 2015 5:36 pm
by :FI:Armitage
its most likely a permissions issue.
you need to give the default asp.net user execute permission on all of the sps in the db
grant execute on SPNAME to UserName
replacing SPName with the name of the sp and username with the default asp.net user name
This is from memory and I could be wrong.
I'll be on tonight