+ Post New Thread
Page 4 of 7 FirstFirst 1234567 LastLast
Results 46 to 60 of 103
Virtual Learning Platforms Thread, SIMS Timetable Module for Moodle in Technical; Originally Posted by Hightower Can anybody help me configure FreeTDS for Ubuntu 8.04LTS? I've done a "sudo apt-get install freetds-dev" ...
  1. #46


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339
    Quote Originally Posted by Hightower View Post
    Can anybody help me configure FreeTDS for Ubuntu 8.04LTS?

    I've done a "sudo apt-get install freetds-dev" successfully but when editing /etc/freetds.conf I get a blank file - is this normal and do I have to populate it myself?
    I'm not using freetds on ubuntu, but it appears that the config file is just /etc/freetds/freetds.conf



    Code:
    dpkg --listfiles freetds-common 
    /.
    /usr
    /usr/share
    /usr/share/freetds
    /usr/share/freetds/freetds.conf
    /usr/share/doc
    /usr/share/doc/freetds-common
    /usr/share/doc/freetds-common/README
    /usr/share/doc/freetds-common/README.Debian
    /usr/share/doc/freetds-common/TODO.Debian
    /usr/share/doc/freetds-common/copyright
    /usr/share/doc/freetds-common/examples
    /usr/share/doc/freetds-common/examples/freetds.conf.pl
    /usr/share/doc/freetds-common/examples/locales.conf
    /usr/share/doc/freetds-common/NEWS.gz
    /usr/share/doc/freetds-common/TODO.gz
    /usr/share/doc/freetds-common/changelog.Debian.gz
    /etc
    /etc/freetds
    /usr/share/doc/freetds-common/examples/odbcinst.ini
    /usr/share/doc/freetds-common/examples/freetds.conf
    thing is, I can't find the tsql command that is present on RHEL?
    can someone confirm that the freetds package works on ubuntu - you may be better of using the source, luke

  2. #47

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,658
    Thank Post
    858
    Thanked 646 Times in 429 Posts
    Rep Power
    498
    Dont think I can help there - our AD is already setup so dont need to export from SIMS into AD..

  3. #48

    Hightower's Avatar
    Join Date
    Jun 2008
    Location
    Cloud 9
    Posts
    4,920
    Thank Post
    494
    Thanked 690 Times in 444 Posts
    Rep Power
    241
    Quote Originally Posted by Gatt View Post
    Dont think I can help there - our AD is already setup so dont need to export from SIMS into AD..
    Can you quickly bullet the install points it took you to get it to work?

  4. #49
    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
    Nice one - though in the block_simstimetable.php you need to change /mod/simstimetable/ to mod/simstimetable/

    Sorry - meant to remove it myself in my previous quote..

    For some reason if its there it ignores the $CFG->wwwroot entirely!!
    I have fixed this and update the zip file

  5. #50
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    41
    Quote Originally Posted by penfold_99 View Post
    Hi Gatt, Apeo

    I have updated to the latest version, if you could download and test i would be grateful.

    The latest version includes the link to from the timetable to the course.
    Just tested it, same problem.

    Sorry for being and idiot but my logic is off today but with this line of code:

    PHP Code:
    $parts explode($periodseperator$row['period_name']);
    $lessons[$periods[$parts['1']]][$days[$parts['0']]] = $row['class_name'];
    $rooms[$periods[$parts['1']]][$days[$parts['0']]] = $row['room_name'];
    $teachers[$periods[$parts['1']]][$days[$parts['0']]] = $row['staff_initials']; 
    for '1Mon 1', which has a class of say En, it would work out like this:

    Code:
    $parts[0]='1Mon'
    $parts[1]='1'
    $lessons[$periods['1']][$days['1Mon']] = $lessons[1][1]
    $lessons[1][1] = 'En'
    for '2Mon 1', which has a class of say Ma, it would look like this:

    Code:
    $parts[0]='2Mon'
    $parts[1]='1'
    $lessons[$periods['1']][$days['2Mon']] = $lessons[1][1]
    $lessons[1][1] = 'Ma'
    So in the array $lessons the value En has been overriden with Ma. Am i right?

  6. #51

    Hightower's Avatar
    Join Date
    Jun 2008
    Location
    Cloud 9
    Posts
    4,920
    Thank Post
    494
    Thanked 690 Times in 444 Posts
    Rep Power
    241
    Just noticed a big school boy error - the VBS scripts need editing duh!

    Can anybody help me with the correct settings?

    This is what I am struggling with (I don't know whether to leave as default or what to put in the empty ones):

    Code:
    strServerComputer = "student"
    strServerLocalFolder = "e:\users"
    strBaseOU = "OU=UCTC"
    strIntakeOUPrefix = "OU=Year"
    strLogonScript = "logon.bat"
    strProfilePath
    strSchool = "UCTC"
    strHomeDrive = "S:"
    arrUserDomainGroups = Array("Student-Filtered")
    etc etc

    Has anybody got their VBS's for this so I can take a look - especially any CC3 users.

    Thanks,

  7. #52
    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 apeo View Post
    Just tested it, same problem.

    Sorry for being and idiot but my logic is off today but with this line of code:

    PHP Code:
    $parts explode($periodseperator$row['period_name']);
    $lessons[$periods[$parts['1']]][$days[$parts['0']]] = $row['class_name'];
    $rooms[$periods[$parts['1']]][$days[$parts['0']]] = $row['room_name'];
    $teachers[$periods[$parts['1']]][$days[$parts['0']]] = $row['staff_initials']; 
    for '1Mon 1', which has a class of say En, it would work out like this:

    Code:
    $parts[0]='1Mon'
    $parts[1]='1'
    $lessons[$periods['1']][$days['1Mon']] = $lessons[1][1]
    $lessons[1][1] = 'En'
    for '2Mon 1', which has a class of say Ma, it would look like this:

    Code:
    $parts[0]='2Mon'
    $parts[1]='1'
    $lessons[$periods['1']][$days['2Mon']] = $lessons[1][1]
    $lessons[1][1] = 'Ma'
    So in the array $lessons the value En has been overriden with Ma. Am i right?
    You are i need to changes these lines

    PHP Code:
    $parts explode($periodseperator$row['period_name']);
    $lessons[$periods[$parts['1']]][$days[$parts['0']]] = $row['class_name'];
    $rooms[$periods[$parts['1']]][$days[$parts['0']]] = $row['room_name'];
    $teachers[$periods[$parts['1']]][$days[$parts['0']]] = $row['staff_initials']; 
    to this

    PHP Code:
    $parts explode($periodseperator$row['period_name']);
            if ((
    $no_weeks 1) && (strpos($parts['0'],$no_weeks)=== true))
            {
                
    $period $parts['1'] +(count($periods) +1);
            }
            else
            {
                
    $period $parts['1'];
            }
            
    $lessons[$periods[$period]][$days[$parts['0']]] = $row['class_name'];
            
    $rooms[$periods[$period]][$days[$parts['0']]] = $row['room_name'];
            
    $teachers[$periods[$period]][$days[$parts['0']]] = $row['staff_initials']; 
    this will take into account

    Code:
    $parts[0]='2Mon'
    $parts[1]='1'
    $lessons[$periods['1']+][$days['2Mon']] = $lessons[1][1]
    $lessons[1][1] = 'Ma'
    should now become

    Code:
    $parts[0]='2Mon'
    $parts[1]='1'
    offset = (count($periods) +1);
    $lessons[$periods['1'+[offset]]][$days['2Mon']] = $lessons[1][1]
    $lessons[10][1] = 'Ma'
    Last edited by penfold_99; 21st January 2009 at 12:37 PM.

  8. #53
    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 Hightower View Post
    Just noticed a big school boy error - the VBS scripts need editing duh!

    Can anybody help me with the correct settings?

    This is what I am struggling with (I don't know whether to leave as default or what to put in the empty ones):

    Code:
    strServerComputer = "student"
    strServerLocalFolder = "e:\users"
    strBaseOU = "OU=UCTC"
    strIntakeOUPrefix = "OU=Year"
    strLogonScript = "logon.bat"
    strProfilePath
    strSchool = "UCTC"
    strHomeDrive = "S:"
    arrUserDomainGroups = Array("Student-Filtered")
    etc etc

    Has anybody got their VBS's for this so I can take a look - especially any CC3 users.

    Thanks,
    High tower,

    set

    USER_CREATION = FALSE
    AD_REG_UPDATE = FALSE
    AD_UPN_UPDATE = FALSE

    strBaseOU = to you base ou holding all your students

    Set you sims information, SMTP settings and email address and then run it, this will email you a report if everything is correctly setup.

  9. #54

    Hightower's Avatar
    Join Date
    Jun 2008
    Location
    Cloud 9
    Posts
    4,920
    Thank Post
    494
    Thanked 690 Times in 444 Posts
    Rep Power
    241
    Quote Originally Posted by penfold_99 View Post
    High tower,

    set

    USER_CREATION = FALSE
    AD_REG_UPDATE = FALSE
    AD_UPN_UPDATE = FALSE

    strBaseOU = to you base ou holding all your students

    Set you sims information, SMTP settings and email address and then run it, this will email you a report if everything is correctly setup.
    Thanks, changed those but still get the same error.

  10. #55
    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 Hightower View Post
    Thanks, changed those but still get the same error.
    whats the exact error?

  11. #56

    Hightower's Avatar
    Join Date
    Jun 2008
    Location
    Cloud 9
    Posts
    4,920
    Thank Post
    494
    Thanked 690 Times in 444 Posts
    Rep Power
    241

  12. #57

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,658
    Thank Post
    858
    Thanked 646 Times in 429 Posts
    Rep Power
    498
    I think the VB creates users in AD for you but dont know if you need to create the OUs first or if it does it for you...

    Things I know I would change are in Red

    strServerComputer = "Name Of Your SIMS Server"
    strServerLocalFolder = "e:\users"
    strBaseOU = "OU=SchoolName or Pupils or Users"
    strIntakeOUPrefix = "OU=Year"
    strLogonScript = "logon.bat"
    strProfilePath
    strSchool = "SchoolName"
    strHomeDrive = "Pupil Home Drive letter"
    arrUserDomainGroups = Array("Student-Filtered")

  13. #58

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,658
    Thank Post
    858
    Thanked 646 Times in 429 Posts
    Rep Power
    498
    Quote Originally Posted by Hightower View Post
    What names did you give the views in MS SQL when you created them - they need to be the same as the ones in the Doc..

  14. #59

    Hightower's Avatar
    Join Date
    Jun 2008
    Location
    Cloud 9
    Posts
    4,920
    Thank Post
    494
    Thanked 690 Times in 444 Posts
    Rep Power
    241
    Quote Originally Posted by Gatt View Post
    What names did you give the views in MS SQL when you created them - they need to be the same as the ones in the Doc..
    Yeah - they were the same :S

  15. #60
    barney's Avatar
    Join Date
    Jan 2009
    Location
    Surrey
    Posts
    52
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Newbie here and first post ..

    As an institution we are possibly being railroaded into buying Fronter, so I thought we'd take peek moodle to see what it can/can't do and to try and setup something as close to an MLE as we would end up buying.

    In 2 days we've got moddle up and running on Win2k03 box using Apache and MYSQL thanks in no small part to the wonder XAMPP. We've setup LDAP for authentication which works a treat and brought in some of our existing learning materials.

    I've read this thread and Penfold's documentation several times now and I'm still confused As an ex techie and moodle virgin so to speak would someone be kind enough to try and talk me through the latter 2 parts of Penfold's documentation. ie
    # Integrate Moodle and SIMS.net
    # Install SIMS.net Moodle Modules

    Many thanks

SHARE:
+ Post New Thread
Page 4 of 7 FirstFirst 1234567 LastLast

Similar Threads

  1. SIMS.Net & Timetable planning
    By Ravening_Wolf in forum MIS Systems
    Replies: 22
    Last Post: 4th November 2009, 03:27 PM
  2. SIMS Lesson Monitor Timetable Structure
    By Sylv3r in forum MIS Systems
    Replies: 8
    Last Post: 15th March 2009, 09:45 PM
  3. Timetable T6 or Sims.net confused
    By training_needed in forum MIS Systems
    Replies: 4
    Last Post: 26th June 2008, 10:07 AM
  4. Sims Timetable Front end
    By Jamie_a in forum MIS Systems
    Replies: 5
    Last Post: 28th March 2007, 04:49 PM
  5. Moodle Blog Module SQL Injection Vulnerability - Heads Up
    By OutToLunch in forum Virtual Learning Platforms
    Replies: 7
    Last Post: 9th October 2006, 02:25 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
  •