FlashPioneer Video Chat -- Administrator Manual Go to Chat Homepage
Welcome
Introduction of Flash Chat
Installation
 
System Requirements
 
Install Flash Server on Windows
Install Flash Media Server
Install Red5 Server
 
Install Flash Server on Linux
Install Flash Media Server
Install Red5 Server
 
Install Video Chat Server
Installation of FMS Edition
Installation of Red5 Edition
 
Install Video Chat Client
Installation of Client
Configuration via setting.xml
Make your Client Setup program
Custom Skin
 
Upgrade
 
Database Integration
Install Chat's database (PHP)
PHP Interface description
Install Chat's database (.NET)
.NET Interface description
 
Administrator's Guide
 
Administrator Panel
Monitor
Setting
Room
User
News
Account
 
FAQ and Troubleshooting
Installation Tour (Linux) RED5 Edition
Installation Tour (Linux) FMS Edition
 

   Database Integration -- Install Chat's database (.NET)


There two ways to keep the data. One is using the file format which is the same as the former version, there is no need for users to setup to use, Users' information and chat history are stored under the Chat server path with an encryption; the other is integrating with the present database by ASP.NET interface through which the users' information and chat history store in the database.

1) First please make sure that your web server supports ASP.net and SQL SERVER

2) Build SQL SERVER database

Operating sql statement of database.sql and build two new datatable: users and log
"users" table is for saving the users' information, the structure is as following

"users" table is for saving the users' information, the structure is as following
uid Primary KEY, autoincrease
username User's name
password Password
level The user's level, the default value is 0, if it is 1 then it is the administrator
signDate Register time
lastLogin The last login time

"log" table is for chatting history, the structure as is as following
lid Primary KEY, autoincrease
target Massage receiving one
ip The user's IP address
username Massage sending one
message Message content
date Message sending time

After running sql statement, insert two users in users table
username admin test
password admin test
level Administrator Register user

3) Install Fluorine program

Unzip aspService.zip, go into the Fluorine file after unzipping, use Notepad or other text editor tools to open "Web.config", and modify the code.
Find the two lines of code as following:

<add key="ConnStr" value="uid=sa;password=password;database=flashchat;server=localhost" />

Modify the database server address, database uid and password, database name in sql server as your configuration respectively.

4) Configure Flashchat

After finishing install chat program, log in chat as administrator, and then go to the administrator panel.


In the Setting panel, choose "remote database" in the red pane in the picture. In "Remoting gateway URL" text field, fill the absolute url of gateway.aspx. And then fill the class path of server object in "Remoting class path" text field, save the setting.

 TOP