Koozali.org: home of the SME Server

Obsolete Releases => SME Server 7.x => Topic started by: ronaldson40 on June 14, 2007, 11:20:50 PM

Title: Mysql Access problems
Post by: ronaldson40 on June 14, 2007, 11:20:50 PM

Hi

I am having a rather peculiar problem.

I have created two groups i.e Domain Admins and Domain Users to create a Windows Network.

I have made a program that uses the mysql db as the backend.

I am using the mysql.dll connector for interfacing it with the db and the code is written in C#

Now this is my dilemna. Whenever I log into the windows domain as a Domain Admin I am able to connect to the mysql db on a regular basis.
But when I login as a Domain user and use my program. most of the time, I get this error when i either try to add/retrieve a record.
The error is of this sort : Datagram has no sendto address.

Please note I also have netlogon policies for each user(Made using poledit)

Please advise what could be the reason.

Title: Mysql Access problems
Post by: Confucius on June 14, 2007, 11:33:58 PM

When as Administrator you can make the changes without any error and as a Domain User you can't it seems to me that we're talking about a Windows issue since Windows does the rights on the local machine and there fore also controls the dll and it's actions.
I would suggest to open rights on the registry & file system for 1 specific Domain User in th policies and try again. And ofcourse try 1 of the not adjusted Domain Users to see if it makes a difference.

I would certainly advice to use a registry and/or file monitor to see what's going on.

I really don't think that MySql has caused this error.

Title: Registry/File monitor
Post by: ronaldson40 on June 14, 2007, 11:39:33 PM

Hi
Thanks for your earlier reply..

Can you suggest some registry/file monitor...

Regards

Title: Mysql Access problems
Post by: Confucius on June 14, 2007, 11:45:06 PM

Hmmm... not really the place to continue this thread... but well..

http://www.microsoft.com/technet/sysinternals/utilities/regmon.mspx

M$ bought recently the company that made all these great tools.
This makes clear that I dislike to credit M$ for these tools.

Title: Mysql Access problems
Post by: kruhm on June 17, 2007, 02:12:05 PM

try making them POWER USERS (instead of DOMAIN USERS).

Be sure to use the group name as the group description.
http://wiki.contribs.org/User-Groups

Title: Mysql Access problems
Post by: ronaldson40 on June 18, 2007, 12:04:33 AM

I will try it out

Thx