|
Integrate database configuration
123 Flash Chat supports integrating the existing database of your forum or
portal system such as phpBB, PHPNuke, PostNuke, AspNuke, etc., or of other
user systems.
Basically 123 Flash Chat can integrate database of any kind, as long as
there's username and password in it, but if your website do not support
a database your user information will not be able to be integrated. If
this is the case you can use 123 Flash Chat to store your user information.
There are a few steps to integrate a database:
1) configure default/server.xml.
The modes of IntegratedOtherDatabase in default/server.xml include:
None - does not use an integrated database to authorize users
Mysql - uses a mysql database
Oracle - uses an oracle database
Common - uses all kinds of databases, advanced setting.
URL - uses a web URL to authorize a user's login information.
ODBC - uses an ODBC to connect to any database you want.
2) Configure the database xml file.
It could be:
a) Mysql.xml
| Parameter |
Type |
Description |
| database-host |
string |
The hostname of the
database server. |
| database-name |
string |
The database name you
are using. |
| database-user |
string |
The user name which is
required to connect to
the database. |
| database-password |
string |
The password which is
required to connect to
the database. |
| user-table |
string |
The table to store the
user information. |
| username-field |
string |
The column of names of
the user names in the
user-table. |
| password-field |
string |
The column of names of
passwords in the user-
table. |
| enable-md5 |
string |
It defines whether the
password is encrypted
with MD5.
On - encoded.
Off - not encoded.
Passwords in many
portal systems and
forum systems like php-
nuke, post-nuke or
phpBB, etc. are
encrypted with
MD5, thus you will need
to set this value to "On". |
b) Oracle.xml
| Parameter |
Type |
Description |
| mode |
string |
It could be "thin" or
"oci" only. It indicates
the way to access the
database. The default
value is "thin". If you
choose "oci", then your
server must have
installed an racle
client. |
| database-host |
string |
The hostname of the
database server. |
| database-port |
number |
The port of the
database. |
| database-sid |
string |
The sid of the database
server. |
| service-name |
string |
The service name to
connect to oracle. It
doesn't take effect
unless you choose the
mode "oci". |
| database-user |
string |
The user name which is
required to connect to
the database. |
| database-password |
string |
The password which is
required to connect to
the database. |
| user-table |
string |
The table to store the user information. |
| username-field |
string |
The column name of
user names in the user-
table. |
| password-field |
string |
The column name of
passwords in the user-
table. |
| enable-md5 |
string |
It defines whether the
password is encrypted
with MD5.
On - encoded.
Off - not encoded .
Passwords in many
portal systems and
forum systems such as
php-nuke, post-nuke or
phpBB, etc. are
encrypted with MD5,
thus you will need to set
this value to "On"
. |
c) CommonDB.xml
| Parameter |
Type |
Description |
| jdbc-driver |
string |
The name of the jdbc
driver. |
| jdbc-url |
string |
The complete jdbc URL.
If the user name and
password are required
when the database is
accessed, they must
also be included. |
| user-table |
string |
The table to store the
user information. |
| username-field |
string |
The column name of the
user names in the user-
table. |
| password-field |
string |
The column name of
passwords in the user-
table. |
| enable-md5 |
string |
It defines whether the password is encrypted with MD5.
On - encoded.
Off - not encoded .
Passwords in many portal systems and forum systems such as php-nuke, post-nuke or phpBB, etc. are encrypted with MD5, thus you will need to set this value to ¡°On¡±. |
d) Using URL to authorize a users' login information.
You can authorize a users' log in information by using a dynamic web
application.
You can activate this integration method by following the tag below:
Once set to "URL", another 2 arguments have to be defined to avoid
an error.
For example:
http://www.yourhost.com/login_chat.php?username=%username%&pass<>word=%password%
Or:
http://www.yourhost.com/login_chat.asp?username=%username%&password=%password%
One argument is the %usename%, the other is the %password%.
"&" is the character "&' in xml.
That is to say when the user enters their username: "myname" and their
password: "mypassword" , the chat server will visit: " http://www.yourhost.com/login_chat.php?username=myname& password=mypassword " to
get the login information which will return a number between 0 to 7, each with a
different meaning. See the table below:
| Parameter |
Description |
| 0 |
successfully login as ordinary user; |
| 1 |
wrong password ; |
| 2 |
the username can't be used ; |
| 3 |
login error, e.g. error in connecting database ; |
| 4 |
username does not exist; |
| 5 |
successfully login as the administrator; |
| 6 |
guest login not allowed |
7 |
username is banned. |
e)ODBC.xml
| Parameter |
Type |
Description |
| dsn-name |
string |
The DSN name of your
ODBC |
| database-user |
string |
Enter username if it is
required by your ODBC. |
| database-password |
string |
Enter password if it is
required by your ODBC. |
| user-table |
string |
The table to store the
user information. |
| username-field |
string |
The column name of
user names in the user-
table. |
| password-field |
string |
The column name of
passwords in the user-
table. |
| enable-md5 |
string |
It defines whether the
password is encrypted
with MD5.
On - encrypted.
Off - not encrypted
Passwords in many
portal systems and
forum systems such as
php-nuke, post-nuke or
phpBB, etc. are
encrypted with
MD5, thus you will need
to set this value to "On". |
updated at 2008-2-28 |
