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

[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

[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

[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.