MM revelation

This page is not finished, for now it is only a bunch of notes.

How it started?

(meetup Andrew Gray)
Meetup group title: “FREE – LIFE CHANGING EVENTS & SEMINARS IN LONDON”
Title of the meetup: Learn how to make a min of $5k p/m passive income! Exclusive opp ENDS 11th 7pm!!

Learn how to make a min of $5k p/m passive income! Exclusive opp ENDS 11th 7pm!!

Saturday, Jul 22, 2017, 3:00 PM

Location details are available to members only.

13 Members Attending

****Third PRE LAUNCH event – Not sure if there will be another one! *****Hello everyone, Andrew Gray, the Founder of this group here. I have an EXCLUSIVE opportunity from my mentor Eric Ho – (Google him, he is a serial entrepreneur!).I am not going to say much here, but there is the potential to earn a minimum of $5,000 per month, passive income,…

Check out this Meetup →

The meetup post contains only a link. The link get you to a registration form.

Place, revealed by email 1 day before.
Plaza River bank
forced to be there soon
5 emails with a stupid video (I’m exciting, pre-launh, like Facebook) before the event.

auditorium
water (no beer, orange joice or something to eat)

yuhuuu, gimme five and big smile, and videos and photos all the time.

high volume music
Singer, horrible pop music, promotion of her album
another singer,

A women was the speaker and then present Eric Ho.
It is like in the videos on youtube.
Good speaker, bla bla bla and trickes to get attention.
Bla bla bla. Some photos
At 24 years old he was financial independent.
Some images with cars (some out of the shop winmdow!)
Some in SPA or yatch (clearly not his, because he was not manouvering”).
A lot os self-videos, some embarassing for the stupidity.

He present Mister Wong. An idiot that has 20 million like for a video on youtube, So? How can this makew ME rich?

All the time generic questions to the crowd and “raise your and if/who”…

All the links in the email before the event are tracked with funnel.

Advertisements

SQL Server connection fails

– IDK: I don’t know
– Y: yes
– N: no

Which version is your SQL Server ?
– I don’t know
– 2016
– 2014
– 2005

Are you using an IP in the conenction string?
– Y
– N

Is the application that need to conenct on the same machine of SQL Server ?
– Y
– N

Are you using a Trusted conenction?
– IDK
– Y
– N

Are you using “localhost” as server name?
– IDK
– Y
– N

Do you know which connection string are you using?
– IDN
– Y
– N

Are the TCP inbound/outboundport allowed for port 1433?
– IDN
– Y
– N

The Login user in SQL Server is allowed to connect and login?
– IDN
– Y
– N

+ A001: use “(local)” instead of “localhost”
+ A002: check this: https://support.microsoft.com/en-us/help/328306/potential-causes-of-the-sql-server-does-not-exist-or-access-denied-err
+ A003: use “(local)” or instead of the IP address
+ A004: check this settings in Server/Security/Logins/User/(right click)/Properties/(Status section)
[attach image]

Connection fail to SQL Server after a database restore

Scenario.

Restore SQL Server database X.
Try to conenct using the usual connection string. Conenction fail.

Yes
Yes
Delete the user in “Security” of SQL Server.
Delete the user from the “Users” of the database.
Create a new user in Server/Securit6y/Logins:
– User name: seelct a user that exists in the machine, ex.: \user
– leave everything unchaged
Create a user in the database in database/Security/Users:
– Login namne: seelct <achine\
– User name: select \
No
Todo
> Yes
< Do you use an IP address in the connection string?

in the database:
– User name: select / using hhe selector
– Login name:
– Default schema:
> No
Yes
Check the user defined in the Application Pool of the current web site
> No
Todo
> No
Todo

MVC API tests – manage unknown error raised by HttpServer

Scenario: integration tests against ASP.Net MVC API.
MVC version 5.2

Create a base class test to manage the repetitive API GET/POST calls like:

protected HttpResponseMessage Execute(HttpMethod method, string url, T data)
{
url = BASE_URL + url;

HttpRequestMessage request = new HttpRequestMessage(method, url);
request.Headers.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));

JsonMediaTypeFormatter formatter = new JsonMediaTypeFormatter();
formatter.SerializerSettings.ContractResolver = new CamelCasePropertyNamesContractResolver();
if (method == HttpMethod.Post && data != null)
request.Content = new ObjectContent(data, formatter);

using (var server = new HttpServer(GetConfiguration()))
using (var client = new HttpClient(server))
{
var response = client.SendAsync(request).Result;
return response;
}
}

Boom.

500. Internal server Error.

The server is set like this:
private HttpConfiguration GetConfiguration()
{
HttpConfiguration configuration = new HttpConfiguration();
//var dependencyResolver = new WindsorDependencyResolver(container);
//configuration.DependencyResolver = dependencyResolver;
WebApiConfig.Register(configuration);

// remove all HostAuthenticationFilter due to the error “no OWIN Authentication manager…”
foreach (var filter in configuration.Filters.Where(f => f.Instance is HostAuthenticationFilter).ToList())
configuration.Filters.Remove(filter.Instance);

return configuration;
}

mmhh… try to debug:
It enter in the ApiController, get the data from the REpository and it exit from the class with a nice colelction of data… what is wrong ???

Routing is ok, it is actually passing the request to the right controller.
Injection of repositories is ok, it is fetching and returning data.
Log4Net is ok, I’m not calling the “log4net.Config.XmlConfigurator.Configure();” without a proper configuration in app.config.

Adding “configuration.IncludeErrorDetailPolicy = IncludeErrorDetailPolicy.Always;”
is absolutely useless for this problem.

What to do now?

I’ll check one of 2 or 3 previous project where I’ve already done this a where I spent 1,2 or 7 days to figure out this ALL THE TIMES fucking problem !