+ 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,819
    Thank Post
    881
    Thanked 685 Times in 454 Posts
    Rep Power
    505
    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
    1,002
    Thank Post
    60
    Thanked 167 Times in 119 Posts
    Rep Power
    69
    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,819
    Thank Post
    881
    Thanked 685 Times in 454 Posts
    Rep Power
    505
    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,819
    Thank Post
    881
    Thanked 685 Times in 454 Posts
    Rep Power
    505
    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 04:08 PM.

  5. #20
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    1,002
    Thank Post
    60
    Thanked 167 Times in 119 Posts
    Rep Power
    69
    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,819
    Thank Post
    881
    Thanked 685 Times in 454 Posts
    Rep Power
    505
    Its on Linux (Fedora 10)

  7. #22


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,033 Times in 813 Posts
    Rep Power
    341
    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,819
    Thank Post
    881
    Thanked 685 Times in 454 Posts
    Rep Power
    505
    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,033 Times in 813 Posts
    Rep Power
    341
    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,819
    Thank Post
    881
    Thanked 685 Times in 454 Posts
    Rep Power
    505
    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,033 Times in 813 Posts
    Rep Power
    341
    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,819
    Thank Post
    881
    Thanked 685 Times in 454 Posts
    Rep Power
    505
    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,033 Times in 813 Posts
    Rep Power
    341
    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,819
    Thank Post
    881
    Thanked 685 Times in 454 Posts
    Rep Power
    505
    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,033 Times in 813 Posts
    Rep Power
    341
    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, 02:58 PM
  2. Moodle & Sub Categories
    By LOUD in forum Virtual Learning Platforms
    Replies: 1
    Last Post: 27th May 2008, 11:28 AM
  3. Timetables
    By binky in forum MIS Systems
    Replies: 6
    Last Post: 27th March 2008, 01:10 PM
  4. Export timetables from SIMS into Sharepoint 2007
    By scottyses in forum Virtual Learning Platforms
    Replies: 3
    Last Post: 11th March 2008, 11:42 AM
  5. SIMS.NET Timetables
    By BadComputerDay in forum MIS Systems
    Replies: 0
    Last Post: 2nd October 2006, 09: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
  •