How to integrate MS-SQL
MS-SQL is database running on Windows server.
There're two ways to integrate MS-SQL:
1) integrate using ODBC
a)To connect to your MS SQL, firstly it needs to establish ODBC DSN for it in following way:
run this command on the server you want to install the chat server:
start->settings->control panel->administrative tools->Data sources(ODBC)->New DSN
After creating DSN for your MS SQL, please memorize its name.
for example, DSN name is "yourdsnname"
b)Edit chat server configuration file.
Go to: <123flashchat installed folder>/server/etc/groups/default/server.xml
open it with Notepad or some other editor, find:
None
b1)whether change to:
ODBC
b2)or to:
Common
b1)In the first case to "ODBC", you need to change this file, too:
<123flashchat installed folder>/server/etc/database/default_ODBC.xml
and do following changes:
/***********************************************************/
yourdsnname
your_db_username
your_db_password
your_user_table_name
username_field_name
password_field_name
Off
/***********************************************************/
b2)in the latter case to"Common", you have to edit the file below:
<123flashchat installed folder>/server/etc/database/default_CommonDB.xml
to configure it like:
/*************************************************************/
sun.jdbc.odbc.JdbcOdbcDriver
JDBC:ODBC:yourdsnname;UID=your_db_username;PWD=your_db_password;
your_user_table_name
username_field_name<
password_field_name
Off
/*************************************************************/
Both methods are adaptable, but the previous one is recommended because it's simpler.
Note:
yourdsnname - is the DSN name you've defined,
your_db_username , your_db_password , your_user_table_name, username_field_name, password_field_name -
Please replace with actual name.
About password encryption,
If the password stored in your database is not encrypted,
then: Off,
If it's encrypted with md5, then:On,
If it's encrypted but with some method other than md5, then you can't integrate database with ODBC,
instead, you can try "auth-url" to integrate.
Next , we'll show you how to integrate with "auth-url".
2) integrate using "auth-url"
Using auth-url, not only any kind of database, but also file system(not even a database) can be integrated.
(Of course it needs preliminary web developing experience to finish this integration.)
You can use any kind of web developing language to make this url, like asp, php, etc.
and here's the way it works:
a dynamic web application like a php file or an asp file,
configure the file with your database information, upload it to your web server,
and fill in the url of the dynamic web page to the tag.
so that 123 flash chat server can authorize your members' login information using the file.
The whole process is illustrated with the diagram below:
http://www.123flashchat.com/img/integrate_ext_database.jpg
Instruction:
Edit chat server configuration file.
Find: <123flashchat installed folder>/server/etc/groups/default/server.xml
Open it with Notepad, find:
None
change to:
URL
Find next:
change it to something like:
http://www.yourhost.com/login_chat.php?username=%username%&password=%password%
( for example that you've created this url and it's located at :http://www.yourhost.com/login_chat.php,
moreover, it can be attached with username and password to authorize account from database.)
Among it, "&" means "&" in xml code.
The value of "auth-url" won't be effective unless is set to "URL".
Sample:
Here're two samples of "auth-url" written respectively in php and asp.
You can download them to be reference.
If the password of your user system is encrypted in other method, you should edit the part of authorizing password in this file and make it to your own auth-url.
* If php, login.zip.
* If asp, login_chat.asp.
