+ Post New Thread
Page 2 of 3 FirstFirst 123 LastLast
Results 16 to 30 of 44
Virtual Learning Platforms Thread, SIMS Timetables & Moodle in Technical; OK I have added in the SIMS2AD views to the SQL Server The adsync View returns data, but the admanager ...
  1. #16

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,658
    Thank Post
    858
    Thanked 646 Times in 429 Posts
    Rep Power
    498
    OK I have added in the SIMS2AD views to the SQL Server
    The adsync View returns data, but the admanager does not?

    Do I need to use the 'sa' username & password for enrolment?

  2. #17
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    929
    Thank Post
    56
    Thanked 162 Times in 114 Posts
    Rep Power
    67
    Quote Originally Posted by Gatt View Post
    yeah just did it on the 3 views (enrolment_current, student_timetable, staff_timetable)
    Can you give an example of the output from student_timetable

  3. #18

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,658
    Thank Post
    858
    Thanked 646 Times in 429 Posts
    Rep Power
    498
    Am getting something similar to this..

    Code:
    Tue:2   10A/Sp1   <<UPN>>   <<STAFF-CODE>>   52
    Mon:1   10C/Hi1   <<UPN>>   <<STAFF-CODE>>   59
    Wed:5   10C/Hi1   <<UPN>>   <<STAFF-CODE>>   59
    Wed:2   10B/Gg1   <<UPN>>   <<STAFF-CODE>>   57
    field headers are :
    Code:
    period_name | class_name | unique_pupil_no | staff_initial | room_name

  4. #19

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,658
    Thank Post
    858
    Thanked 646 Times in 429 Posts
    Rep Power
    498
    OK, in trying to figure out whats wrong with my set up I added

    PHP Code:
    or die ("Cant Connect!"); 
    to the end of the $dbhandle statement in he view.php file for the mod..

    Refreshed the page and got a "Cant Connect" message in my browser - looks like I cannot talk to MS SQL!!

    I have been through everything - its all correct

    dbhost - server,1427
    dbuser - sa
    dbpass - <pasword>
    dbname - sims_mors
    dbtable - dbo.mdl_enrolment_current


    Question - Do you need to connect using "sa" ? - Of So then it looks like my LEA have changed it - and prob wont give me it
    Last edited by Gatt; 9th January 2009 at 03:08 PM.

  5. #20
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    929
    Thank Post
    56
    Thanked 162 Times in 114 Posts
    Rep Power
    67
    how is moodle setup? is it on linux or windows?

    if you have access to add view you will be able to reset the sa password, but hang fire until you have answered the above.

    If your setup is on windows then you need a slight adjustment.

  6. #21

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,658
    Thank Post
    858
    Thanked 646 Times in 429 Posts
    Rep Power
    498
    Its on Linux (Fedora 10)

  7. #22


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339
    Quote Originally Posted by Gatt View Post
    OK, in trying to figure out whats wrong with my set up I added

    PHP Code:
    or die ("Cant Connect!"); 
    to the end of the $dbhandle statement in he view.php file for the mod..

    Refreshed the page and got a "Cant Connect" message in my browser - looks like I cannot talk to MS SQL!!

    I have been through everything - its all correct

    dbhost - server,1427
    dbuser - sa
    dbpass - <pasword>
    dbname - sims_mors
    dbtable - dbo.mdl_enrolment_current


    Question - Do you need to connect using "sa" ? - Of So then it looks like my LEA have changed it - and prob wont give me it

    have you setup freetds on fedora so that the moodle server can talk to the mssql?

    you need to install freetds. you also need php-mssql installed.
    there are rpm's available for this. our /etc/freetds.conf file looks like this:

    Code:
    [global]
    	host = x.x.x.x
    	port = 1427
    	client charset = UTF-8
    	tds version = 7.0
    	text size = 20971520
    where x.x.x.x is the hostname of the SIMS server and 1427 is the port.

  8. #23

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,658
    Thank Post
    858
    Thanked 646 Times in 429 Posts
    Rep Power
    498
    yeah installed FreeTDS - will need to check the conf file but did put in the IP and port for our SIMS server
    Installed php-mssql and restarted apache...

  9. #24


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339
    test freetds on the commandline:
    Is the server there?

    I guess if that works, then look more into php-mssql

  10. #25

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,658
    Thank Post
    858
    Thanked 646 Times in 429 Posts
    Rep Power
    498
    Hmm...

    freetds.conf is correct

    Cannot telnet to the SQl server
    when I try tsql I get "unable to connect: Adaptive server is unavailable or does not exist"


  11. #26


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339
    is the port correct?
    IIRC MSSQL 2000 and 2005 run on different ports
    1433 and 1427?

  12. #27

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,658
    Thank Post
    858
    Thanked 646 Times in 429 Posts
    Rep Power
    498
    yeah its set for 1427 in both FreeTDS and in the SIMS Course Template (as server-ip,1427)

  13. #28


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339
    Code:
    telnet x.x.x.x 1427
    if that doesn't connect it's probably that the sims server is firewalled, or isn't listening on the external interface.

  14. #29

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,658
    Thank Post
    858
    Thanked 646 Times in 429 Posts
    Rep Power
    498
    Doesn't work -
    Will check firewalls
    If its not listening how do i get it to listen?

  15. #30


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339
    I just googled, and got back an awnser from Geoff !
    Moodle & SQL Server 2005

    2. Make sure MS SQL Server can accept incoming TCP/IP connections on port 1433 (the standard one).

    You might need to explicitly allow this in your Windows firewall (see the Control Panel). You may also need to edit options in the :SQL Server Configuration Manager -> Network Configuration -> Protocols -> TCP/IP enabled

SHARE:
+ Post New Thread
Page 2 of 3 FirstFirst 123 LastLast

Similar Threads

  1. AD & VLE (Moodle), Mail (Zimbra), MIS (SIMS .Net)
    By kmount in forum How do you do....it?
    Replies: 1
    Last Post: 14th December 2008, 01:58 PM
  2. Moodle & Sub Categories
    By LOUD in forum Virtual Learning Platforms
    Replies: 1
    Last Post: 27th May 2008, 10:28 AM
  3. Timetables
    By binky in forum MIS Systems
    Replies: 6
    Last Post: 27th March 2008, 12:10 PM
  4. Export timetables from SIMS into Sharepoint 2007
    By scottyses in forum Virtual Learning Platforms
    Replies: 3
    Last Post: 11th March 2008, 10:42 AM
  5. SIMS.NET Timetables
    By BadComputerDay in forum MIS Systems
    Replies: 0
    Last Post: 2nd October 2006, 08:24 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •