I am not getting this module. How do you get the data from the orignal database into your external sso tables? ARe we talking about two external databases, your sso sample tables and the tablse from the original database? Can your module map directly to the old database? Is this mapping part in the source code?
Our current database store is in mySQL and the field names and datatypes are different than SQL. How do you map from the MySQL database to your sso tables which then can import into DNN?
If you just want to use DNN DB as temporary holding place, review the two tables TE_SsoXP_Authentication and TE_SsoXP_UserImport. As part of the installation, there are about 200 test records added to these table. You can add your own records to these tables.
If you want to do live authentication against your mySQL table (and import data), purchase the source code and update the SQLDataProvider.vb to make oledb call to your mySQL db. The Sso supports MS SQL out of the box and it will require customization to access non-mssql db.
Fuji Nguyen InDyne Inc/Chief Technology Officer
Thanks. This is clearer now.
I was trying to see where in the free source you can download you can change the tablenames etc.
so if I can get a method of getting my mySQL data into your temporary tables on a scheduled sync, then I could use the module as is.
If I want to by pass the temporary table and do it live I need to purchase the source code and modify the SQLDataProvider.
I would not mind doing this using temporary tables on a schedule but the product or tool (DBSync for MS SQL & MySQL) i have to move the mySQLData to the temp tables requires that the tables have the same names. so i am thinking I need the source code primarily just to change the table name.
I thought the source that you can down
oops, I meant to say, I am NOW getting this module. I am using 4.7 will the 4.8 download work with 4.7??
Also is it essential to develope on the DNN source code version. I have the toughest time getting that to intall correctly locally.
I get it finished but the host and admin cannot log in.?
The Sso installation for DNN 4.8 will not work on DNN 4.7. There is new methods in DNN 4.8 that are not backward compatible with DNN 4.7.
You first upload the Install version. Then follow the instructions in this blog http://opensource.indyneinc.com/home/Products/SsoXPFree/tabid/99/articleType/ArticleView/articleId/16/Default.aspx to setup the source code in the solution.
Do the admin and host account existed in your external database? The module settings screen has a flag to prevent password update for the admin/host account. The default is not to allow update.