Re: Shared memory and ASP.NET web services - John L.Utz III - com.mysql.lists.dotnet

11 messages in com.mysql.lists.dotnetRe: Shared memory and ASP.NET web ser...

From	Sent On	Attachments
Homam S.A.	11 Jan 2005 13:20
John L.Utz III	11 Jan 2005 14:06
Homam S.A.	11 Jan 2005 17:18
John L.Utz III	11 Jan 2005 17:50
Reggie Burnett	13 Jan 2005 14:15
Homam S.A.	13 Jan 2005 17:53
Homam S.A.	13 Jan 2005 17:59
Darren Hill	13 Jan 2005 18:36
Mike Hillyer	13 Jan 2005 20:32
Homam S.A.	13 Jan 2005 21:31
Reggie Burnett	16 Jan 2005 07:52

Subject:	Re: Shared memory and ASP.NET web services
From:	John L.Utz III (jo...@utzweb.net)
Date:	01/11/2005 02:06:36 PM
List:	com.mysql.lists.dotnet

Hello;

At Tue, 11 Jan 2005 13:21:06 -0800 (PST), Homam S.A. wrote:

I'm trying to use the shared memory protocol in an ASP.NET web service, but I'm getting the following error:

"Unable to connect to any of the specified MySQL hosts --> Failed to open shared memory connection"

Which host? is it on the same box as the WebService?

If I remove the the "protocol=memory" from the connection string, it works fine. If I use the same connection string in a windows forms or a console application, the shared memory connection works fine.

So it seems to me it's a security problem with the ASP.NET account (ASPNET).

well, you have a way to test this using runas to execute your console app or your winform app using the ASPNET account....hmmm...except that you would need the *password* for the ASPNET account and i dont know what that is or how to find that out.

so, then the fallback would be to create a new local user with the same permission level as the ASPNET account and see if you can use runas to run your console app or winform with that account and get a successfull connection

the other thing you could try would be to temporarily escalate the process by using a different account other than ASPNET. here's the msdn:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/secmod/html/secmod15.asp

Has anybody used the shared memory protocol from ASP.NET, and if so, what kind of permissions did you grant to the ASPNET account to get it to work?

i have not used this protocol because i dont currently develop with MySQL, i am a SQLServer guy.

but ASPNET permissioning is uniformly obnoxious across all db's :-) and this is the process that i have used with my current c# project to figure out what is going wrong from a permissons perspective.

HTH!

johnu

I appreciate your help!

Homam