TOPIC:

Hi all,

This is my first post here.
I work for Bromley Adult Education College and decided to install Xerte for the tutors to have a go and create better resources for their teaching.
I'm flying solo and blind here and have very basic skills on web server stuff but willing to learn fast.
We only have 2 people in the IT department so, not much time to play with settings.
I've created a server from scratch using Windows Server 2012-R2, installed IIS, MySQL, PHP and Xerte.
I've gone thru the Xerte config procedure and the site is working for guest login.
I do not want to connect it to LDAP as I would prefer a DB login the way we use with our intranet at the moment. How do I access the database with something other than command line?
I know what I have to change in auth_config.php but don't know the format of DB entries and which DB to add them to. Is there a user interface to add a list of users?
Looking forward to hearing from you,

Regards,

Marta

hi,

im new to xerte too, but got it running this morning.
you already commented out "guest" and uncommented "Db" in auth_config.php ?
simply run management.php on your web-root and log in with your
admin account created during config.
there is a section for creating users.
maybe you have to restart your webserver first.

J

Hi Juergen,

I've tried all that earlier but wondered, what if I had a bunch of accounts to input? It would be a very tedious job indeed to manually input, say 100 accounts, and keep them up to day as new tutors arrive and others leave. We have an MIS and I was thinking of some sort of integration like we have with our intranet via SQL database.
How can I import in MySQL a table from MSSQL?

Many thanks,

Marta

You cannot directly do that. Also, the difficulty is generating/converting passwords.

That is a shame really as it does not make it easy for me to implement it at our college. We cannot afford to have one member of staff dedicated to doing just Xerte admin and maintenance.
Our tutors are not in LDAP but are in our database. Having them doing 3 or 4 different logins to different systems does not help either.

Hi
one way you could do this which might at first seem overkill but actually is very simple is to use Moodle for authentication to Xerte. You don't really have to use Moodle for anything else but authentication but it means you can use all the authentication methods built=in to Moodle to then authenticate to xerte. e.g. you can in theory at least use the Moodle connected to MSSQL then the session info gets passed to Xerte even though Xerte is using MySQL.
HTH
Ron