Ad:

Python Discussion Thread
Unsolved
Views: 7377

Jul 26th, 2007

Adding user and mailbox in Active Directory

Expand Post »

I am new to Python and, in fact, I have limited programming experience in general.

I am attempting to create a web form that our HR employees can use to add new employees into Active Directory and to create a mailbox for that user. AD is on a WIN2k server and Exchange 2000. I have the form and some code that will add the user based on submitted fields from the webform. The code fails when it gets to the part about creating the mailbox. Below is my code:

python Syntax (Toggle Plain Text)
import win32com.client
import win32com, win32com.adsi
import pythoncom
import cgi
 
FormFile = "addusertmp.html"
print 'Content-Type: text/html\n\n'
def DisplayForm():
    FormHandle = open(FormFile, "r")
    FormInput = FormHandle.read()
    FormHandle.close()
    print FormInput
 
def ProcessForm(entries):
    first = entries['first'].value
    last = entries['last'].value
    login = entries['login'].value
    password = entries['password'].value
    title = entries['title'].value
 
entries = cgi.FieldStorage()
 
def add_acct (location, user):
    ad_obj=win32com.client.GetObject(location)
 
    ad_user=ad_obj.Create('user','cn='+user['login'])
    ad_user.Put('sAMAccountName',user['login'])
    ad_user.Put('userPrincipalName',user['login']+'@domain.org')
    ad_user.Put('DisplayName',user['first']+' '+user['last'])
    ad_user.Put('givenName',user['first'])
    ad_user.Put('sn',user['last'])
    ad_user.Put('description',user['title'])
    ad_user.SetInfo();ad_user.GetInfo()
    ad_user.AccountDisabled=0
    ad_user.setpassword(user['password'])
    ad_user.SetInfo()
    ad_user.CreateMailbox('CN=Maibox Store (SERVER),CN=First Storage Group,CN=InformationStore,CN=SERVER,CN=Servers,CN=First Administrative Group,CN=Administrative Groups,CN=Company Name,CN=Microsoft Exchange,CN=Services,CN=Configuration'+location)
    ad_user.EmailAddress=user+'@domain.org'
    ad_user.SetInfo()
    ad_user.Put('msExchUserAccountControl',2)
    ad_user.SetInfo()
 
if entries:
    location='LDAP://OU=Employees,DC=domain,DC=org'
    user={'first':entries.getvalue('first'),'last':entries.getvalue('last'),'login':entries.getvalue('login'),'title':entries.getvalue('title'),'password':entries.getvalue('password')}
    print user
    add_acct(location,user)
    print "user added"
else:
    DisplayForm()
import win32com.client
import win32com, win32com.adsi
import pythoncom
import cgi

FormFile = "addusertmp.html"
print 'Content-Type: text/html\n\n'
def DisplayForm():
    FormHandle = open(FormFile, "r")
    FormInput = FormHandle.read()
    FormHandle.close()
    print FormInput

def ProcessForm(entries):
    first = entries['first'].value
    last = entries['last'].value
    login = entries['login'].value
    password = entries['password'].value
    title = entries['title'].value

entries = cgi.FieldStorage()

def add_acct (location, user):
    ad_obj=win32com.client.GetObject(location)

    ad_user=ad_obj.Create('user','cn='+user['login'])
    ad_user.Put('sAMAccountName',user['login'])
    ad_user.Put('userPrincipalName',user['login']+'@domain.org')
    ad_user.Put('DisplayName',user['first']+' '+user['last'])
    ad_user.Put('givenName',user['first'])
    ad_user.Put('sn',user['last'])
    ad_user.Put('description',user['title'])
    ad_user.SetInfo();ad_user.GetInfo()
    ad_user.AccountDisabled=0
    ad_user.setpassword(user['password'])
    ad_user.SetInfo()
    ad_user.CreateMailbox('CN=Maibox Store (SERVER),CN=First Storage Group,CN=InformationStore,CN=SERVER,CN=Servers,CN=First Administrative Group,CN=Administrative Groups,CN=Company Name,CN=Microsoft Exchange,CN=Services,CN=Configuration'+location)
    ad_user.EmailAddress=user+'@domain.org'
    ad_user.SetInfo()
    ad_user.Put('msExchUserAccountControl',2)
    ad_user.SetInfo()

if entries:
    location='LDAP://OU=Employees,DC=domain,DC=org'
    user={'first':entries.getvalue('first'),'last':entries.getvalue('last'),'login':entries.getvalue('login'),'title':entries.getvalue('title'),'password':entries.getvalue('password')}
    print user
    add_acct(location,user)
    print "user added"
else:
    DisplayForm()

When I go to the web form and I enter&submit the required fields, this creates the user & enables the user, but also produces the following error and never creates the mailbox:
{'password': 'test', 'login': 'bbonez', 'title': 'Bouncer', 'last': 'Bonez', 'first': 'Big'} Traceback (most recent call last): File "W:\SysadminSite\adduser2.cgp", line 50, in ? add_acct(location,user) File "W:\SysadminSite\adduser2.cgp", line 37, in add_acct ad_user.CreateMailbox('CN=Maibox Store (SERVER),CN=First Storage Group,CN=InformationStore,CN=SERVER,CN=Servers,CN=First Administrative Group,CN=Administrative Groups,CN=Company Name,CN=Microsoft Exchange,CN=Services,CN=Configuration'+location) File "C:\Python22\Lib\site-packages\win32com\client\dynamic.py", line 438, in __getattr__ raise AttributeError, "%s.%s" % (self._username_, attr) AttributeError: .CreateMailbox

Any help would be GREATLY appreciated. Thank you!

Similar Threads

Intergrating with Active Directory in Mac OS X
Integrating with Active Directory in Mac OS X
os 10.x and active directory q ? in Mac OS X

drexlus

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

3 posts
since Jul 2007

Permalink

Jul 27th, 2007

Re: Adding user and mailbox in Active Directory

It looks like your problem is on the Windows end rather than the Python end. Apparently, a 'user' object's CreateMailbox() method requires something different from what you are supplying. As a result, Server 2k is choking but (as usual) isn't telling you exactly why.

If the error were Python-related, you would get a much more descriptive message

.

We did something like what you are trying to do at school, but handled it by having Python create a .csv file for all users and then used Active Directory to import the users from the .csv file. I can't recall the details at the moment, but it seems unlikely to be appropriate to your situation.

I would recommend the following:

* Try commenting out the code that concerns mailbox creation (lines 37-41, if I'm reading it right).
* Make sure that you can use the web form to create a new user. Make sure the new user goes into the right OU and is a member of all of the right security groups!
* Check your Server 2k documentation for the right syntax for the CreateMailbox. See if you can debug lines 37-41 that way.

Hope it helps,
Jeff

jrcagle

Reputation Points: 92

Solved Threads: 156

Practically a Master Poster

Offline

608 posts
since Jul 2006

Permalink

Jul 30th, 2007

Re: Adding user and mailbox in Active Directory

Thanks for the insight. The code does, in fact, create the user in the proper groups. It creates it with the correct password and the account is enabled.

So it makes sense what you're saying about Server 2k rejecting the "CreateMailbox" syntax. I will see if I can research what I need to be using to get that mailbox created. If anybody can help me out here, I would appreciate it.

drexlus

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

3 posts
since Jul 2007

Permalink

Aug 2nd, 2007

Re: Adding user and mailbox in Active Directory

Alright, so I have gotten a bit further, but could use a bit more help. My code now looks like:

python Syntax (Toggle Plain Text)
import win32com.client
import win32com, win32com.adsi
import cdoexm
import pythoncom
import cgi
 
FormFile = "addusertmp.html"
print 'Content-Type: text/html\n\n'
def DisplayForm():
    FormHandle = open(FormFile, "r")
    FormInput = FormHandle.read()
    FormHandle.close()
    print FormInput
 
def ProcessForm(entries):
    first = entries['first'].value
    last = entries['last'].value
    login = entries['login'].value
    password = entries['password'].value
    title = entries['title'].value
 
entries = cgi.FieldStorage()
 
def add_acct (location, user):
    ad_obj=win32com.client.GetObject(location)
 
    ad_user=ad_obj.Create('user','cn='+user['login'])
    ad_user.Put('sAMAccountName',user['login'])
    ad_user.Put('userPrincipalName',user['login']+'@garcoschools.org')
    ad_user.Put('DisplayName',user['first']+' '+user['last'])
    ad_user.Put('givenName',user['first'])
    ad_user.Put('sn',user['last'])
    ad_user.Put('description',user['title'])
    ad_user.SetInfo();ad_user.GetInfo()
    ad_user.AccountDisabled=0
    ad_user.setpassword(user['password'])
    ad_user.SetInfo()
    ad_user.MailEnable("SMTP:"+user['login']+"@domain.org")
    ad_user.SetInfo()
    HomeMDB=('CN=Mailbox Store (SERVER),CN=First Storage Group,CN=InformationStore,CN=SERVER,CN=Servers,CN=First Administrative Group,CN=Administrative Groups,CN=Company name,CN=Microsoft Exchange,CN=Services,CN=Configuration,OU=Employees,DC=domain,DC=org')
    cdoexm.IMailboxStore.CreateMailbox(HomeMDB)
    ad_user.EmailAddress=user['login']+'@domain.org'
    ad_user.SetInfo()
    ad_user.Put('msExchUserAccountControl',2)
    ad_user.SetInfo()
 
 
entries=1  #test line, remove later
if entries:
    location='LDAP://OU=Employees,DC=domain,DC=org'
#    user={'first':entries.getvalue('first'),'last':entries.getvalue('last'),'login':entries.getvalue('login'),'title':entries.getvalue('title'),'password':entries.getvalue('password')}
    user={'first':'jason','last':'bourne','login':'bbourne2','title':'Assassin','password':'password'}  #testline, remove later
    print user
    add_acct(location,user)
    print "user added"
else:
    DisplayForm()
import win32com.client
import win32com, win32com.adsi
import cdoexm
import pythoncom
import cgi

FormFile = "addusertmp.html"
print 'Content-Type: text/html\n\n'
def DisplayForm():
    FormHandle = open(FormFile, "r")
    FormInput = FormHandle.read()
    FormHandle.close()
    print FormInput

def ProcessForm(entries):
    first = entries['first'].value
    last = entries['last'].value
    login = entries['login'].value
    password = entries['password'].value
    title = entries['title'].value

entries = cgi.FieldStorage()

def add_acct (location, user):
    ad_obj=win32com.client.GetObject(location)

    ad_user=ad_obj.Create('user','cn='+user['login'])
    ad_user.Put('sAMAccountName',user['login'])
    ad_user.Put('userPrincipalName',user['login']+'@garcoschools.org')
    ad_user.Put('DisplayName',user['first']+' '+user['last'])
    ad_user.Put('givenName',user['first'])
    ad_user.Put('sn',user['last'])
    ad_user.Put('description',user['title'])
    ad_user.SetInfo();ad_user.GetInfo()
    ad_user.AccountDisabled=0
    ad_user.setpassword(user['password'])
    ad_user.SetInfo()
    ad_user.MailEnable("SMTP:"+user['login']+"@domain.org")
    ad_user.SetInfo()
    HomeMDB=('CN=Mailbox Store (SERVER),CN=First Storage Group,CN=InformationStore,CN=SERVER,CN=Servers,CN=First Administrative Group,CN=Administrative Groups,CN=Company name,CN=Microsoft Exchange,CN=Services,CN=Configuration,OU=Employees,DC=domain,DC=org')
    cdoexm.IMailboxStore.CreateMailbox(HomeMDB)
    ad_user.EmailAddress=user['login']+'@domain.org'
    ad_user.SetInfo()
    ad_user.Put('msExchUserAccountControl',2)
    ad_user.SetInfo()


entries=1  #test line, remove later
if entries:
    location='LDAP://OU=Employees,DC=domain,DC=org'
#    user={'first':entries.getvalue('first'),'last':entries.getvalue('last'),'login':entries.getvalue('login'),'title':entries.getvalue('title'),'password':entries.getvalue('password')}
    user={'first':'jason','last':'bourne','login':'bbourne2','title':'Assassin','password':'password'}  #testline, remove later
    print user
    add_acct(location,user)
    print "user added"
else:
    DisplayForm()

The error I get now is:
File "E:\Projects\Python\SysAdmin\tests\adduser2.py", line 41, in add_acct
cdoexm.IMailboxStore.CreateMailbox(HomeMDB)
TypeError: unbound method CreateMailbox() must be called with IMailboxStore instance as first argument (got str instance instead)

Any idea what I'm doing wrong? Thanks

drexlus

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

3 posts
since Jul 2007

Permalink

Aug 3rd, 2007

Re: Adding user and mailbox in Active Directory

Hi,

Quote ...

The error I get now is:
File "E:\Projects\Python\SysAdmin\tests\adduser2.py", line 41, in add_acct
cdoexm.IMailboxStore.CreateMailbox(HomeMDB)
TypeError: unbound method CreateMailbox() must be called with IMailboxStore instance as first argument (got str instance instead)

this is what it comes to me at the moment, CreateMailBox() method of IMailboxStore class.

So when you are calling a member function class, you can call member function in two ways..
- using instance of the class and function parameters
- using class name, and passing the instance of the class as first argument and function parameters following it, to the function.

In your case you are passing an argument of string type as first argument, hence you get TyoeError exception. So you need to pass, an instance of IMailboxStore class as first argument.

Below is the sample code, which is similar to your's.. helps you in better understanding the problem

Python Syntax (Toggle Plain Text)
>>> class test:
	def fun(self):
		print 'hi'
 
 
>>> t=test() # creating an instance
>>> t.fun()	# calling function using instance of the class itself
hi
>>> test.fun()
 
Traceback (most recent call last):
  File "<pyshell#11>", line 1, in -toplevel-
    test.fun()
TypeError: unbound method fun() must be called with test instance as first argument (got nothing instead)
>>> test.fun(t)	# calling member function with the instance of the class
hi
>>>
>>> class test:
	def fun(self):
		print 'hi'

		
>>> t=test() # creating an instance
>>> t.fun()	# calling function using instance of the class itself
hi
>>> test.fun()

Traceback (most recent call last):
  File "<pyshell#11>", line 1, in -toplevel-
    test.fun()
TypeError: unbound method fun() must be called with test instance as first argument (got nothing instead)
>>> test.fun(t)	# calling member function with the instance of the class
hi
>>>

Hope i explained the problem properly, all the best.

kath.

Last edited by katharnakh; Aug 3rd, 2007 at 3:21 am.

katharnakh

Reputation Points: 19

Solved Threads: 34

Posting Whiz in Training

Offline

237 posts
since Jan 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Python Forum Timeline: Expanded Calendar utilizing wxPython

Next Thread in Python Forum Timeline: need help creating simple program

DaniWeb Message

Cancel Changes

User Name
Password