Bookingstats
This is how to add and configure a new user to the statistic web.
There are 2 websites running, http://bookingstats.com on the internal host magrathea
and the other on https://statistics.hitchhiker.net on host neptun.
Background of doing this is a security consideration, external user will request a dmz machine with a mySQL server, internal user
will use an internal machine with a internal MS-SQL as backend.
Redundancy is a reason too, it is easy to switch between the SQL server if one of them fails.
- Please see Temyra-Backoffice to get an overview how about the data feed
Overview:
Setup new user
To setup a new user you need to follow 2 steps:
- Setup LDAP
- Setup mySQL
Setup LDAP
Setup external user
To setup an external user you have to add the user within the OU External, make the user to a member of statistics
Setup internal user
To setup an internal user within the OU Users' you have to add an Exchange Server attribute, note that you need to do this on the Exchange Server itself
Use Custom attribute4 and set STATUSER
Test the new user
Open http://bookingstats.intern or https://statistics.hitchhiker.net and login within the new user credentials
Since the user is unknown to our web authentication yet (mySQL) you will get something like this:
Setup mySQL
Currently there is another (authentication) server in place where the configuration data sits, on magrathea
You need to add the new username (watch capitals) to the database Bookingstats, table tblUsers
See the following example, fist you need to get a new groupID which you get by the increment of the last groupID
- Run: SELECT * FROM Bookingstats.tblUsers order by groupid;
The above sample shows groupID 38, therefore the new id will be 39. The sample shows the default for an external user.
|
|