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

[penfold_99]

Just wondering what definition of 'Open Source' you are using? Since these two statements appear to contradict each other. This one, Open source - Wikipedia, the free encyclopedia which I'd think is pretty good, states 'the end-product (and source-material) available at no cost to the public'. This would normally imply a downloadable source location.

Or am I missing something here?

Hi Tony,

SIMS2MOODLE is released under the GPL Licence, under this licence there can be charges for distributio thats why it has been packaged with on-site installation and support. The GPL Licence allows the user to then modify the source code as the needs arises among other things.

[darklord1474]

Sims has just updated the database to MS SQL 2008 and the plugin has stopped working, any ideas what could have caused this?

[kieran8055]

Sims has just updated the database to MS SQL 2008 and the plugin has stopped working, any ideas what could have caused this?

Same problem with our new MS SQL 2008 as well, Just wondering whether you got the solution.
It seems like Advance firewall in 2008 server blocking connecting to sims instance.

Thanks

[TechMonkey]

Check the port number. I think the default has changed to 1433. Also check the DB username and password as SQL 2008 made the password need to be more complex. Also don't forget to change the academic year field.

Beyond that as far as I am aware it is all working here.

[kieran8055]

Check the port number. I think the default has changed to 1433. Also check the DB username and password as SQL 2008 made the password need to be more complex. Also don't forget to change the academic year field.

Beyond that as far as I am aware it is all working here.

Wel thanks for your reply, basically i have open port for sims instance on 1433 and also added firewall rules, but when i do port scan sql server port wont showup and unable to communicate with tsql. Any ideas??

Thanks

[CyberNerd]

After our sims upgrade SQL2008 changed to port 1714
we changed the freedts.conf to

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

and updated the databases section in moodle to 1714.
We needed to re-run /enrol/database/enrol_database_sync.php to repopulate courses

[TechMonkey]

Thats interesting as I had entirely forgotten about the freetds config so didn't change that. & yet it seems to work... Spooky, my moodle has become sentient!

[kieran8055]

Check the port number. I think the default has changed to 1433. Also check the DB username and password as SQL 2008 made the password need to be more complex. Also don't forget to change the academic year field.

Beyond that as far as I am aware it is all working here.

Still unable to setup port for sims instance on SQL 2008 server, Any suggestions please.

Thanks

[TechMonkey]

Sorry I'm not sure I understand. So you have checked the port being used by SQL 2008, changed the settings in Moodle, checked the username and password for the DB is correct and it is still no working?

[kieran8055]

Sorry I'm not sure I understand. So you have checked the port being used by SQL 2008, changed the settings in Moodle, checked the username and password for the DB is correct and it is still no working?

problem is on sql 2008 server side, unable to establish port for sql instance on sql server configuration.

[kieran8055]

problem is on sql 2008 server side, unable to establish port for sql instance on sql server configuration.

Well its all back in business, Thankyou very much guys for all your help.
And once again thanks to Penfold_99 for amazing work.