The Definitive Guide to SIMS.net, Moodle and LDAP Integration

[CyberNerd]

In Our AD employeeID field doesnot appear.

 

Any suggestions.

 

Thanks.

 

have a look in Adsiedit - or script it.

[penfold_99]

Hi All,

 

I have update SIMS.net Timetable Block for Moodle to version 1.2.1.

 

CHANGELOG

 

FIXED: Course links with incorrect course id numbers.

[IT_Man_Dan]

Mornin,

 

I've followed the following steps to enable Employee ID in ADUC.

Modifying the Active Directory Users and Computers Shortcut Menu

 

Now that we have the script created, we need a way to call it from the ADUC GUI. To do this we will need to edit the Properties of the user-Display object. The following steps will facilitate this functionality:

 

1. Open ADSI Edit (located in the Support Tools folder of the Windows Server 2003 CD)

2. Expand the CN=Configuration node and navigate to CN=DisplaySpecifiers, CN=409. Select the 409 node in the left hand pane.

3. In the right-hand pane, select the CN=user-Display object. Right click and select Properties.

4. Select the adminContextMenu attribute and click Edit.

5. We now need to add the value that will be used to create the additional menu item and direct it to the employeeID.vbs script. The syntax is very important. Be sure to include the comma at the beginning and after the menu name (Employee-ID). Add the following syntax to the Value to Add: line:

,&Employee-ID,\\servername\sharename\employeeID.vbs

6. Change the servername and sharename items to reflect your current environment and then click Add.

7. Click OK to accept the changes and close ADSI Edit.

8. Allow some time for replication to populate the changes throughout the directory.

9. Open ADUC and select a user. Right click on the user and notice the new menu item now available.

10. Select Employee-ID to launch the script from within the ADUC

11. From here we can either enter a new value for the employeeID attribute for the user or hit Cancel to leave the current value intact. (Note: If no value is present in the field, then the attribute value is empty for that user.)

 

That’s it; we have extended the schema functionality to expose a hidden attribute for editing via the ADUC interface using VBScript. If the popup is not visible, be sure replication has occurred and double check that the path given in ADSI Edit is valid.

 

This opens up almost endless possibilities for modifications without knowledge of C++ or advanced coding languages that will enhance functionality of the ADUC snap-in for your administrators. The script code:

 

 

On Error Resume Next

Dim objemployeeID

Dim objUser

Dim objTemp

Set objemployeeID = Wscript.Arguments

Set objUser = GetObject(objemployeeID(0))

objTemp = InputBox("Current Employee-ID: " & objUser.employeeID & VbCrLf _

& vbCRLF & "If you would like enter a new number or modify the existing number, enter the new number in the textbox below")

if objTemp <> “” then objUser.Put “employeeID”,objTemp

objUser.SetInfo

If Err.Number = “-2147024891″ Then

MsgBox “You current account does not have permission” & VbCrLf _

& “to modify the Employee ID attribute. Please” & VbCrLf _

& “log on with an account with appropriate permissions.”, 16, “Permission Denied”

End If

Set objUser = Nothing

Set objemployeeID = Nothing

Set objTemp = Nothing

WScript.Quit

 

It shows Employee Id when I right click a user but at the moment when I click it i get a scripting error message (please see attached error message image).

 

any ideas, am I just being stupid?

 

Cheers

Dan

[rpwillis]

Hi IT_Man_Dan,

 

It sounds like an encoding issue. Did you use something like WordPad to save the script file. Try deleting it and recreating it with Notepad.

 

Richard

SalamanderSoft Limited

http://blog.salamandersoft.co.uk

[IT_Man_Dan]

Hi Richard,

 

Thanks for your response.

 

I saved the script in notepad. I've tried re saving it using different encoding but not joy :-(

 

Regards

Dan

[kieran8055]

Blank page of School timetable,

 

when we click on my timetable noting comes up just a blank page.

 

I have tested

 

1. telnet XX.XX.XX.XX 1433

connected.

2. isql

Error could not SQL connect

 

 

Any help or suggestions Please.

 

Cheers

Edited May 1, 2009 by kieran8055

[IT_Man_Dan]

Hi Kieran,

 

wow you're ahead of me.

 

I'm still getting the scripting error with employee field.

 

Did you not get the scripting error?

 

Regards

Dan

[kieran8055]

Well Dan,

 

I have added user employeeID manually from adsiedit for 5 users. Though employeeID field is not visible but still field value is searchable.

 

And simultaneously we are testing script on virtual machine.

 

Cheers

Edited May 1, 2009 by kieran8055

[CyberNerd]

Blank page of School timetable,

 

when we click on my timetable noting comes up just a blank page.

 

I have tested

 

1. telnet XX.XX.XX.XX 1433

connected.

2. isql

Error could not SQL connect

 

 

Any help or suggestions Please.

 

Cheers

 

you should bea ble to use tsql to test a basic connection

 

tsql -S x.x.x.x -U sa 

x.x.x.x is the ip of the sims/cmis server

should prompt for a password for the sa account

[kieran8055]

Well CyberN..

 

I can connect using

 

TDSVER=8.0 tsql -S XX.XX.XX.XX (or server name) -U sa

 

But not through

 

tsql -S XX.XX.XX.XX (or server name) -U sa

 

error:

 

Msg 20017, Level 9, State -1, Server OpenClient, Line -1

Unexpected EOF from the server

Msg 20002, Level 9, State -1, Server OpenClient, Line -1

Adaptive Server connection failed

There was a problem connecting to the server.

[CyberNerd]

our /etc/freetds.conf file looks like this:

 

[global]
host = x.x.x.x
port = 1427
client charset = UTF-8
tds version = 7.0
text size = 20971520

 

maybe change to version 8

[kieran8055]

its already version = 8.0

[CyberNerd]

all I did was install

 

freetds-0.64-1.el5.rf.x86_64.rpm

php-mssql-5.1.6-4.el5.x86_64.rpm

 

(on centos/RHEL 5.3 64bit)

 

changed the config file /etc/freetds.conf to

 

[global]
host = x.x.x.x
port = 1427
client charset = UTF-8
tds version = 8.0
text size = 20971520

 

(8.0 also works here)

 

then login

tsql -S x.x.x.x -U sa -P PASSWORD

 

and run

1> use sims
2> select * from mdl_enrolment_v1_0
3> go

(where sims is the dbname and mdl_enrolment_v1_0 is the table/view)

 

this should return a bunch of data.

[kieran8055]

when i tried :-

 

select * from mdl_enrolment_v1_0

 

Msg 911, Level 16, State 1, Server ABCServer, Line 1

Could not locate entry in sysdatabases for database 'sims'. No entry found with that name. Make sure that the name is entered correctly.

[penfold_99]

@kieran8055

 

Have you done all the other bits in CyberNerd's post?

 

What OS are you running on?

[kieran8055]

Hi Penfold

 

Yes i 've done all bits ,

 

I am running on " ubuntu 8.04lts server ".

 

1. I have installed FreeTDS0.82

2 php5-sybase (for php-mssql)

[CyberNerd]

does this file exist?

~/.freetds.conf

could it be overriding the global /etc/freetds.conf

maybe try creating it.

[kieran8055]

ya there is a file (freeetds.conf) in /usr/local/etc

 

The following are the file settings:

 

[global]

host = XX.XX.XX (ip of the MSSQL server)

port = 1433

client charset = UTF-8

tds version = 8.0 (or 8.0 if using FreeTDS 0.82 or later)

text size = 20971520

[CyberNerd]

when i tried :-

 

select * from mdl_enrolment_v1_0

 

Msg 911, Level 16, State 1, Server ABCServer, Line 1

Could not locate entry in sysdatabases for database 'sims'. No entry found with that name. Make sure that the name is entered correctly.

 

ok, I see your connecting. this just says that you database is called something other than 'sims' - you need to fins the name of your sims database.

 

if you do

 

select * from sys.databases
go

 

it should display all the databases on your mssql

[CyberNerd]

i'm wondering if it gets overriden by a file in you userpath?

/home/username/.freetds.conf

 

a google of that errormessage

install pymssql and how to deal with DB-Lib error message 20009, severity 9 « PyYou Weblog

 

So I use an another environnement variable to fix that :

 

export TDSVER=7.0

 

And miracle , everything work with tsql. So I force version of tds in my ~/.freetds.conf in global section as this

 

[global]

tds version = 7.0

 

And after that everything is ok in python. Yahoo!!. I hope that ticket will be useful for you.

Edited May 1, 2009 by CyberNerd

[kieran8055]

tried:

 

Invalid object name 'sys.databases'.

[penfold_99]

tried:

 

Invalid object name 'sys.databases'.

 

What version of ms sql server are you running?

[kieran8055]

On Admin Server Its MSSQL 2005

[CyberNerd]

try:

select * from master.dbo.sysdatabases

[kieran8055]

tried:

select * from master.dbo.sysdatabases

 

It displays 5 rows:

 

with file name as

 

d:\sql2000\MSSQL\data\XXXX